Question

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. MonthLabor-HoursMachine-HoursOverhead Costs 1 3,625 6,775 $513,435 2 3,575 7,035 518,960 3 3,400 7,600 549,575 4 3,700 7,265 541,400 5 3,900 7,955 581,145 6 3,775 7,895 572,320 7 3,700 6,950 535,110 8 3,625 6,530 510,470 9 3,550 7,270 532,195 10 3,975 7,725 565,335 11 3,375 6,490 503,775 12 3,550 8,020 564,210 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 of 7,500 machine-hours next year. What are the estimated monthly overhead costs, assuming no inflation

Answer 1

Answer:

Adriana Corporation

Using the High and Low method the Variable and Fixed portions of the Total Cost is:

Fixed Costs = $247,420

Variable Costs = $39.50 Per unit x 8,020 Machine Hours = $316,790

B. at an average of 7,500hrs Machine hours, the estimated Overhead costs = $247,420 x (39.50 x 7,500)

= $543,670

Explanation:

The High and Low Method is a costing method which attempts to split the mix of Fixed and Variable costs in a mixed Total cost of production by looking at one element of variability (in this case Machine Hours)

It is a subjective approach, however simple to calculate. Other method is the regression analysis, which is more complex in comparison to the high and Low

The attached excel file shows how we derived the Variable and Fixed Costs element of the Overhead Costs

djsjsb

cvhjedskjb

gdggd

Download xlsx