Essay About Observations12Anova Dfssmsfsignificance Fregression12.26521E And Total Bill

Business Campaign Plan: Mailing
Essay Preview: Business Campaign Plan: Mailing
Report this essay
You are a vice president of finance for Captain Jack’s Restaurant, a chain of 24 restaurants on the Gulf Coast, including five restaurants in California.  The company is considering a plan whereby customers will be mailed coupons in the month of their birthday, entitling them to 30 percent off their total bill.  The cost of the mailing (printing, paper, postage, etc.) is estimated to be $550,000.  You estimate that the campaign will result in an annual increase in sales of $3,000,000 at normal prices.        Total monthly operating costs on sales using data from the past year are provided below.Operating CostsSalesJanuary$    3,809,720$  4,141,000February3,850,0004,065,000March3,969,0004,410,000April4,007,2254,502,500May3,895,0004,750,000June4,221,2404,852,000July4,343,2004,880,000August4,177,3604,747,000September4,070,0004,625,000October4,035,6004,484,000November3,795,8504,265,000December4,105,2004,665,000$ 48,279,395$ 54,386,500(a.)  Perform regression analysis for Captain Jack’s.SUMMARY OUTPUTRegression StatisticsMultiple R0.839596802R Square0.70492279Adjusted R Square0.675415069Standard Error97375.78793Observations12ANOVA dfSSMSFSignificance FRegression12.26521E+112.26521E+1123.88943520.000634652Residual10948204407489482044075Total113.21341E+11    CoefficientsStandard Errort StatP-valueLower 95%Upper 95%Lower 95.0%Upper 95.0%Intercept1617476.445493020.29963.2807501970.00827844518958.76072715994.129518958.76072715994.129Sales0.5308243340.1086045164.8876819860.0006346520.2888383940.7728102750.2888383940.772810275 (b.)  Write out the cost function.