Question: Assume that Devon's Yukon Pancake Restaurant does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows:

Assume that Devon's Yukon Pancake Restaurant does a regression analysis on the next year's data using Excel. The output generated by Excel is as follows:
Assume that Devon's Yukon Pancake Restaurant does a regression analysis

Requirements
1. What is the fixed cost per month?
2. What is the variable cost per pancake?
3. If Devon's Yukon Pancake Restaurant serves 3,500 pancakes in a month, what would its total operating costs be?

Regression Statistics 4 Multiple R 0.38 0.14 0.07 76.49 7 Standard Eror 8 Observations 10 ANOVA df 3,945.34 23,404.66 27,350.00 MS 3,945.34 5,851.16 Significance F 0.46 0.67 13 Residual 14 Total 15 Lower Upper 95.0% 1,237.80 2,995.03 1,237.80 2,995.03 Upper 95% 16 Coefficients Standard Error 316.45 0.09 t Stat P-value 0.00 0.46 95% 95.0% 2,116.41 0.07 6.69 18 XVariable 1 0.82 0.17 0.32 0.17 0.32

Step by Step Solution

3.36 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Req 1 The fixed cost per month is 211641 This is the Intercept Coef... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Word file Icon

1112-B-M-A-C-B(1431).docx

120 KBs Word File

Students Have Also Explored These Related Managerial Accounting Questions!