Maxwell Company makes treadmills. The company controller wants to calculate the fixed and variable costs associated with the janitorial costs incurred in the factory using the regression method. Data for the past four months were collected. Month Janitorial costs Machine hours September $11,000 575 October 11,400 610 November 10,200 510 December 10,725 550 What would Maxwell Company's estimate of total janitorial cost be at a level of 600 machine hours? Round the variable rate and fixed cost to the nearest cent.

Maxwell Company makes treadmills. The company controller wants to calculate the fixed and variable costs associated with the janitorial costs incurred in the factory using the regression method. Data for the past four months were collected. Month Janitorial costs Machine hours September $11,000 575 October 11,400 610 November 10,200 510 December 10,725 550 What would Maxwell Company's estimate of total janitorial cost be at a level of 600 machine hours? Round the variable rate and fixed cost to the nearest cent.

Principles of Cost Accounting

17th Edition

ISBN:9781305087408

Author:Edward J. Vanderbeck, Maria R. Mitchell

Publisher:Edward J. Vanderbeck, Maria R. Mitchell

Chapter4: Accounting For Factory Overhead

Section: Chapter Questions

Problem 4P: Using the data in P4-2 and Microsoft Excel: 1. Separate the variable and fixed elements. 2....

See similar textbooks

Similar questions

Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Month Maintenance Costs Machine Hours 1 $ 2,660 1,750 2 2,820 1,830 3 2,970 1,910 4 3,080 1,930 5 3,160 1,960 6 3,130 1,940 7 3,070 1,920 8 2,910 1,900 9 2,680 1,760 10 2,280 1,160 11 2,290 1,360 12 2,510 1,650
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor-hours, machine-hours, or both. The following data were collected from last year's operations. Month Labor-Hours Machine-Hours Overhead Costs 1 725 1,349 $ 102,630 2 720 1,404 103,742 3 685 1,517 109,818 4 750 1,459 108,368 5 770 1,589 116,290 6 745 1,583 114,521 7 735 1,396 107,079 8 720 1,307 102,082 9 715 1,463 106,471 10 790 1,538 113,065 11 675 1,298 103,776 12 720 1,608 116,796 Required: a. Use the high-low method to estimate the fixed and variable portions of overhead costs based on machine-hours. b. Managers expect the plant to operate at a monthly average…
Adriana Corporation manufactures football equipment. In planning for next year, the managers want to understand the relation between activity and overhead costs. Discussions with the plant supervisor suggest that overhead seems to vary with labor hours, machine hours, or both. The following data were collected from last year’s operations. Month Labor-Hours Machine-Hours Overhead costs 1 720 1,355 $ 102,644 2 720 1,411 103,842 3 675 1,527 109,938 4 750 1,462 108,297 5 785 1,582…
Ethan Manufacturing Inc. produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month 1 2345 67 000 8 9 10 11 12 Maintenance Costs $ 2,740 2,900 3,050 3,160 3,240 3,210 3,150 2,990 2,760 2,360 2,370 2,590 Machine Hours 1,830 1,910 1,990 2,010 2,040 2,020 2,000 1,980 1,840 Required 1 Required 2 1,240 1,440 1,730 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. Complete this question by entering your answers in the tabs below. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1. (Do not round intermediate calculations, with the exception…
Andover Company makes weather balloons. The company controller wanted to calculate the fixed and variable costs associated with the maintenance costs incurred by the factory. Data for the past six months were collected. Maintenance Machine Month cost hours January $10,120 526 February 9,560 389 March 9,712 412 April 10,460 569 May 10,226 541 June 9,686 399 Required: A. Using the high-low method, calculate the fixed cost of maintenance and the variable rate per machine hour. Round the total fixed cost to the nearest dollar, and round the variable cost per machine hour to two decimal places. B. Using the high-low method, construct the cost formula for the total maintenance cost. C. Calculate the budgeted cost for maintenance assuming that 485 hours are worked next month. Round the answer to the nearest dollar.
Ethan Manufacturing Incorporated produces floor mats for automobiles. The owner, Joseph Ethan, has asked you to assist in estimating maintenance costs. Together, you and Joseph determine that the single best cost driver for maintenance costs is machine hours. These data are from the previous fiscal year for maintenance costs and machine hours: Month Maintenance Costs Machine Hours 1 $ 2,780 1,870 2 2,940 1,950 3 3,090 2,030 4 3,200 2,050 5 3,280 2,080 6 3,250 2,060 7 3,190 2,040 8 3,030 2,020 9 2,800 1,880 10 2,400 1,280 11 2,410 1,480 12 2,630 1,770 Required: 1. What is the cost equation for maintenance costs using the high-low method? 2. Calculate the mean absolute percentage error (MAPE) for the cost equation you developed in requirement 1.
Mema Company makes motorcycles. Management wants to estimate overhead costs to plan its operations. A recent trade publication revealed that overhead costs tend to vary with machine hours. To check this, they collected the following data for the past 12 months. (See the picture for the table) Compute for the: 1. If the plant is planning to operate at a level of 200 machine hours next period, what would be the estimated overhead costs?
The controller of Ferrence Company estimates the amount of materials handling overhead cost that should be allocated to the company's two products using the data that are given below: The total materials handling cost for the year is expected to be $16,486.40. If the materials handling cost is allocated on the basis of material moves, how much of the total materials handling cost should be allocated to the specialty windows? (Round off your answer to the nearest whole dollar.) Question 12 options: $3,266 $9,274 $8,243 $6,595
Mema Company makes motorcycles. Management wants to estimate overhead costs to plan its operations. A recent trade publication revealed that overhead costs tend to vary with machine hours. To check this, they collected the following data for the past 12 months. (See the picture for the table) Compute for the: Use the High-low method to estimate the fixed and variable portion of overhead costs based on machine hours.
Company, which uses the high-low method to analyze cost behavior, has determined that machine hours best predict the company's total utilities cost. The company's cost and machine hour usage data for the first six months of the year follow:
Oakwood Creations Company makes decorative candle pedestals. An industrial engineer consultant developed ideal time standards for one unit of the Berkley model pedestal. The standards follow, along with the cost accountant's determination of current labor pay rates: Worktype 1 Worktype 2 Worktype 3 0.18 hour @ $12.31 per hour 0.32 hour @ $10.89 per hour 0.62 hour @ $19.65 per hour Required: a. Using the preceding data, calculate the direct labor cost for a Berkley model pedestal. b. Would it be appropriate to use the cost calculated in part a as a standard cost for evaluating direct labor performance and valuing inventory? Complete this question by entering your answers in the tabs below. Required A Required B Would it be appropriate to use the cost calculated in part a as a standard cost for evaluating direct labor performance and valuing inventory? Would it be appropriate to use the cost calculated in part a as a standard cost for evaluating direct labor performance and valuing…
The controller of the Blade Company wants you to estimate a cost function from the following two observations in a general ledger account called Maintenance: (Click to view the information.) Required 1. Estimate the cost function for maintenance. 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain. Requirement 1. Estimate the cost function for maintenance. (Round your answers to the nearest cent as needed.) Maintenance costs = Maintenance costs = +( +( X X Requirement 2. Can the constant in the cost function be used as an estimate of fixed maintenance cost per month? Explain. the relevant range, not at cost levels the relevant range. If there are no months with zero The cost function in requirement 1 is an estimate of how costs behave machine-hours represented in the maintenance account, data in that account function provides the best available starting point for a straight line that approximates how a cost behaves be used to…