E3-36A (similar to) Assume that Cliffs Hot and Fresh Pancake Restaurant does a regression analysis on the next years data using Microsoft Excel 2007. The output generated by Excel is as follows: EB (Click the icon to view the regression analysis.) Requirements 1. What is the fixed cost per month? 2. What is the variable cost per pancake? 3. If Cliff's Hot and Fresh Pancake Restaurant serves 3,600 pancakes in a month, what would the company's total operating costs be? Regression Statistics Multiple FR R Square Adjusted R Square Standard Error Observations Anova 0.38 0.14 0.14 76.49 df MS Significance F Regression Residual Total 3945.34 23404.66 27350.00 3945.34 0.67 0.46 4 5851.16 Coefficients 2116.41 0.07 Standard Error 316.45 0.09 t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper 95.0% 2995.03 0.32 Intercept 6.69 0.00 1237.80 2995.03 1237.80 X Variable 1 0.82 0.46 0.17 0.32 0.17