Question

In: Accounting

Chapter 6 Homework Problem 6A-8 High-Low Method; Predicting Cost [LO6-10] Nova Company’s total overhead cost at...

Chapter 6 Homework

Problem 6A-8 High-Low Method; Predicting Cost [LO6-10]

Nova Company’s total overhead cost at various levels of activity are presented below:

Month Machine-
Hours
Total
Overhead
Cost
April 46,000 $ 168,260
May 36,000 $ 144,660
June 56,000 $ 191,860
July 66,000 $ 215,460

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) $ 46,800
Supervisory salaries (fixed) 45,000
Maintenance (mixed) 52,860
Total overhead cost $ 144,660

Nova Company’s management wants to break down the maintenance cost into its variable and fixed cost elements.

Required:

1. Estimate how much of the $215,460 of overhead cost in July was maintenance cost. (Hint: to do this, it may be helpful to first determine how much of the $215,460 consisted of utilities and supervisory salaries. Think about the behavior of variable and fixed costs.)

2. Using the high-low method, estimate a cost formula for maintenance in the form Y = a + bX.

3. Express the company’s total overhead cost in the form Y = a + bX.

4. What total overhead cost would you expect to be incurred at an activity level of 41,000 machine-hours?

Solutions

Expert Solution


Related Solutions

High–Low Method; Predicting Cost Prince Company’s total overhead costs at various levels of activity are presented...
High–Low Method; Predicting Cost Prince Company’s total overhead costs at various levels of activity are presented below:    labour    overhead Month    Hours    Cost September . . . . . . . . . . . . . . . . . . 100,000 $388,000 October . . . . . . . . . . . . . . . . . . . . . 80,000    $340,400 November . . . . . . ....
Exercise 6A-3 Cost Behavior; High-Low Method [LO6-10] Hoi Chong Transport, Ltd., operates a fleet of delivery...
Exercise 6A-3 Cost Behavior; High-Low Method [LO6-10] Hoi Chong Transport, Ltd., operates a fleet of delivery trucks in Singapore. The company has determined that if a truck is driven 96,000 kilometers during a year, the average operating cost is 10.3 cents per kilometer. If a truck is driven only 64,000 kilometers during a year, the average operating cost increases to 11.5 cents per kilometer. Required: 1. Using the high-low method, estimate the variable operating cost per kilometer and the annual...
Please show me step by step. Exercise 6A-1 High-Low Method [LO6-10] The Cheyenne Hotel in Big...
Please show me step by step. Exercise 6A-1 High-Low Method [LO6-10] The Cheyenne Hotel in Big Sky, Montana, has accumulated records of the total electrical costs of the hotel and the number of occupancy-days over the last year. An occupancy-day represents a room rented for one day. The hotel's business is highly seasonal, with peaks occurring during the ski season and in the summer. Month Occupancy-Days Electrical Costs January 1,736 $ 4,127 February 1,904 $ 4,207 March 2,356 $ 5,083...
Chapter 6 HOMEWORK Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4,...
Chapter 6 HOMEWORK Problem 6-20 CVP Applications: Break-Even Analysis; Cost Structure; Target Sales [LO6-1, LO6-3, LO6-4, LO6-5, LO6-6, LO6-8] Northwood Company manufactures basketballs. The company has a ball that sells for $25. At present, the ball is manufactured in a small plant that relies heavily on direct labor workers. Thus, variable expenses are high, totaling $15.00 per ball, of which 60% is direct labor cost. Last year, the company sold 37,500 of these balls, with the following results: Sales (37,500...
Chapter 6 Homework Required information Exercise 6A-2 Least-Squares Regression [LO6-11] [The following information applies to the...
Chapter 6 Homework Required information Exercise 6A-2 Least-Squares Regression [LO6-11] [The following information applies to the questions displayed below.] Bargain Rental Car offers rental cars in an off-airport location near a major tourist destination in California. Management would like to better understand the variable and fixed portions of its car washing costs. The company operates its own car wash facility in which each rental car that is returned is thoroughly cleaned before being released for rental to another customer. Management...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine-Hours Total...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine-Hours Total Overhead Cost      April 50,000           $184,400              May 40,000           $160,000              June 60,000           $208,800              July 70,000           $233,200         Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 40,000 machine-hour level of activity is:   Utilities (variable) $ 52,000     Supervisory salaries (fixed) 45,000   Maintenance (mixed) 63,000   Total overhead cost $...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine-Hours Total...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine-Hours Total Overhead Cost      April 48,000           $196,100              May 38,000           $170,600              June 58,000           $221,600              July 68,000           $247,100         Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 38,000 machine-hour level of activity is:   Utilities (variable) $ 57,000     Supervisory salaries (fixed) 54,000   Maintenance (mixed) 59,600   Total overhead cost $...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost...
High-low method Ziegler Inc. has decided to use the high-low method to estimate the total cost and the fixed and variable cost components of the total cost. The data for various levels of production are as follows: Units Produced Total Costs 104,500 $30,703,250 119,500 33,380,750 136,500 36,415,250 This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below. Determine the variable cost per unit and...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 49,000 $ 185,290 May 39,000 $ 160,190 June 59,000 $ 210,390 July 69,000 $ 235,490 Assume that the total overhead cost above consists of utilities, supervisory salaries, and maintenance. The breakdown of these costs at the 39,000 machine-hour level of activity is: Utilities (variable) $ 50,700 Supervisory salaries (fixed) 50,000 Maintenance (mixed) 59,490 Total overhead cost $ 160,190 Nova Company’s...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours...
Nova Company’s total overhead cost at various levels of activity are presented below: Month Machine- Hours Total Overhead Cost April 46,000 $ 169,660 May 36,000 $ 146,060 June 56,000 $ 193,260 July 66,000 $ 216,860 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) $ 46,800 Supervisory salaries (fixed) 46,000 Maintenance (mixed) 53,260 Total overhead cost $ 146,060 Nova Company’s...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT