Assume that Cliffs Fresh Stack Pancake Restaurant does a regression analysis on the next years data using

Assume that Cliff€™s €œFresh Stack€ 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 Cliff€™s €œFresh Stack€ Pancake Restaurant serves 4,200 pancakes in a month, what would its total operating costs be?

Transcribed Image Text:

Regression Statistics Multiple R R Square Adjusted R Square Standard Error Observations 0.56 0.31 0.14 107.40 ANOVA df MS Significance F 0.25 Regression Residual Total 20542.55 20542.55 46140.78 11535.19 66683.33 1.78 4 Upper 95% Lower Upper 95.0% 95.0% 130.18 3382.54-130.18 3382.54 0.67 Lower Coefficients 1626.18 0.22 Standard Error 632.59 0.16 Stat 2.57 1.33 P-value 0.06 0.25 95% Intercept X Variable 1 -0.24 0.67 0.24