Assume that Asokans Golden Brown Pancake Restaurant does a regression analysis on the next years data using

Assume that Asokan€™s €œGolden Brown€ Pancake Restaurant does a regression analysis on the next year€™s data using Excel 2007. The output generated by Excel is as follows:

Requirements
1. What is the fixed cost per month?
2. What is the variable cost per pancake?
3. If Asokan€™s €œGolden Brown€ Pancake Restaurant serves 3,700 pancakes in a month, what would the company€™s total operating costs be?

Transcribed Image Text:

SUMMARY OUTPUT Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.72 0.51 0.39 99.45 ANOVA df MS 4.20 Regressiorn Residual Tota 41497.6D 41497.6D 39561.23 9890.31 81058.83 0.11 Lower 95% 144.96 0.11 Lower Upper 95.0% 95.0% 2992.16 144.96 2992.16 0.72 Upper 95% Intercept X Variable 1 Coefficients Standard Error 564.95 0.15 1423.60 0.31 t Stat 2.52 2.05 P-value 0.07 0.11 0.72