1-a
Variable cost per unit = ($1900-1300)/(700-400) = $2 per hour
Fixed Cost = $1900 - 700 x 2 = $500
Y = $500 + 2 X
1-b
Variable utility cost per hour = $2
3-a
SUMMARY OUTPUT | ||||||||
Regression Statistics | ||||||||
Multiple R | 0.97559 | |||||||
R Square | 0.951776 | |||||||
Adjusted R Square | 0.93972 | |||||||
Standard Error | 54.90902 | |||||||
Observations | 6 | |||||||
ANOVA | ||||||||
df | SS | MS | F | Significance F | ||||
Regression | 1 | 238023.3 | 238023.3 | 78.94638 | 0.000886 | |||
Residual | 4 | 12060 | 3015 | |||||
Total | 5 | 250083.3 | ||||||
Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0% | |
Intercept | 501 | 123.3054 | 4.063083 | 0.01531 | 158.6494 | 843.3506 | 158.6494 | 843.3506 |
Total Hours of Operation | 2.02 | 0.227345 | 8.885178 | 0.000886 | 1.388789 | 2.651211 | 1.388789 | 2.651211 |
Y = 501 + 2.02 X
3-b
Variable cost per hour = $2.02 per hour
4
(1) Total Cost = $500 + 300 x $2 = $1100
(2) Total Cost = $501 + 300 x $2.02 = $1107
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-8) Gator Beach...
Exercise 6-34 Estimating Cost Behavior by Multiple Methods (Appendix) (LO 6-1, 6-2, 6-5, 6-9) Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company's stores are listed below for the past six months. Total Utility Total Hours Month of Operation January 550 February 600 March 700 April 500 May 450 400...
Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months. Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The...
Hi please answer asap Thank you ! Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company's stores are listed below for the past six months. Total Hours Month of Operation January 450 February 600 March 800 April 400 May 350 June 300 Total Utility Cost $2,520 3,100 3,900 2,400 2,050...
Gator Beach Marts, a chain of convenience grocery stores in the Fort Lauderdale area, has store hours that fluctuate from month to month as the tourist trade in the community varies. The utility costs for one of the company’s stores are listed below for the past six months. Month Total Hours of Operation Total Utility Cost January 550 $ 1,620 February 600 1,700 March 700 1,900 April 500 1,600 May 450 1,350 June 400 1,300 Required: 1-a. Use the...
Problem 5A-8 High-Low Method; Predicting Cost (L05-10) Nova Company's total overhead cost at various levels of activity are presented below: Month April May June July Machine- Hours 51,000 41,000 61,000 71,000 Total Overhead Cost $ 212,630 $ 187,330 $ 237,930 $ 263,230 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 41,000 machine-hour level of activity is: Utilities (variable) Supervisory salaries (fixed) Maintenance (mixed) Total overhead cost $...
Problem 5A-8 High-Low Method; Predicting Cost [LO5-10] Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 52,000 $ 207,440 May 42,000 $ 181,740 June 62,000 $ 233,140 July 72,000 $ 258,840 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 42,000 machine-hour level of activity is: Utilities (variable) $ 63,000 Supervisory salaries (fixed) 56,000 Maintenance (mixed) 62,740...
Problem 5A-8 High-Low Method; Predicting Cost [LO5-10] Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 46,000 $ 179,200 May 36,000 $ 156,700 June 56,000 $ 201,700 July 66,000 $ 224,200 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 36,000 machine-hour level of activity is: Utilities (variable) $ 43,200 Supervisory salaries (fixed) 61,000 Maintenance (mixed) 52,500...
PROBLEM 5A-8 High-Low Method; Predicting Cost LO5-10 Nova Company's total overhead cost at various levels of activity are presented below: Total Overhead Machine- Month Cost Hours April..... May $198,000 $174,000 $222,000 $246,000 70,000 60,000 ... .. June. 80,000 July 90,000 Cost-Volume-Profit Relationships Assume that the total overhead cost above consists of utilities, supervisory salaries, and main- tenance. The breakdown of these costs at the 60,000 machine-hour level of activity is: Utilities (variable).... Supervisory salaries (fixed) Maintenance (mixed).. $ 48,000 21,000...
Nova Company's total overhead cost at various levels of activity are presented below: Total Machine- Overhead Hours 45,000 35,000 55,000 65,000 Month Cost S 185,650 $ 160,350 $ 210,950 $ 236,250 April May June July Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 35,000 machine-hour level of activity is: $ 45,500 54,000 60,850 $160,350 Utilities (variable) Supervisory salaries (fixed) Maintenance (mixed) Total overhead cost Nova Company's management...
Problem 5A-8 High-Low Method; Predicting Cost (LO5-10] Nova Company's total overhead cost at various levels of activity are presented below: Total Machine- Overhead Month Hours 47,000 37,000 57,000 67,000 Cost $ 190,930 $ 167,030 $ 214,830 $ 238,730 April May June July Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 37,000 machine-hour level of activity is: $ 44,400 Utilities (variable) Supervisory salaries (fixed) Maintenance (mixed) 63,000 59,630...