Explore BrainMass
Share

Variable cost using the High- Low Method

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel customers pay $150 per night. Data for the past 7 months are as follows:

January February March April May June July
Number of rooms cleaned 250 160 200 150 270 170 260
Cleaning cost $6,450 $4,060 $5,100 $4,100 $7,000 $4,200 $6,530

How much are estimated monthly variable costs using the high-low method?

© BrainMass Inc. brainmass.com October 25, 2018, 9:30 am ad1c9bdddf
https://brainmass.com/economics/finance/variable-cost-using-high-low-method-576181

Solution Preview

The answer is in the attached excel file:

Rooter's Cleaning Services provided data concerning the costs incurred to clean hotel rooms for which hotel customers pay $150 per night. Data for the past 7 months are as follows:

January February March April May June July
Number of rooms cleaned 250 160 200 150 270 170 260
Cleaning cost $6,450 $4,060 $5,100 $4,100 $7,000 $4,200 $6,530

How much are estimated monthly variable costs using the high-low method?

Month Number of rooms cleaned Cleaning cost
January 250 $6,450 ...

Solution Summary

Calculates fixed and variable cost using the high-low method.

$2.19
See Also This Related BrainMass Solution

Applied Accounting for Decision-Making

JTI is in the process of measuring its manufacturing costs and has assigned you to the measure of the manufacturing maintenance activity of JTI's small travel items, including travel clocks. This production is done in a large plant in the eastern United States.
Maintenance is a significant mixed cost. Activity analysis indicates that maintenance activity consists primarily of maintenance labor setting up machines using certain supplies. A setup consists of preparing the necessary machines for a particular production run of a product. During setup, machines must still be running, which consumes energy. Thus, the costs associated with maintenance include labor, supplies, and energy. Unfortunately, JTI's cost accounting system does not trace these costs to maintenance activity separately.
JTI employs two full-time maintenance mechanics to perform maintenance. The annual salary of a maintenance mechanic is $30,000 and is considered a fixed cost. Two plausible cost drivers have been suggested: units produced and number of setups.
Data had been collected for the past 12 months and a plot made for the cost driver - units of production. The maintenance cost figures collected include estimates for labor, supplies, and energy. You recently attended an activity-based costing seminar where you learned that some types of activities are performed each time a batch of goods is processed rather than each time a unit is produced. Based on this concept, you have gathered data on the number of setups performed over the past 12 months. The plots of monthly maintenance costs vs. the two potential cost drivers follow.

1. Find monthly fixed maintenance cost and the variable maintenance cost per driver unit using the visual-fit method based on each potential cost driver. Explain how you treated the April data.
2. Find monthly fixed maintenance cost of the variable maintenance cost per
driver unit using the high-low method based on each potential cost driver.
3. Which cost driver best meets the criteria for choosing cost functions? Explain.

View Full Posting Details