Question

In: Accounting

Frazier Manufacturing Company collected the following production data for the past month: Units Produced Total Cost...

Frazier Manufacturing Company collected the following production data for the past month: Units Produced Total Cost 1,600 $66,000 1,300 57,000 1,500 67,500 1,100 49,500 If the high-low method is used, what is the monthly total cost equation? A. Total cost = $0 + $45/unit B. Total cost = $13,200 + $33/unit C. Total cost = $16,500 + $30/unit D. Total cost = $9,900 + $36/unit

I know the answer is $13,200+33/unit. But I do not see how the math is done, or I get 34. Could someone break down each step of the math for me please & thank you.

Solutions

Expert Solution

Answer:-a)- Total Fixed costs =$13200

b)- Variable cost per unit =$33 per unit

Explanation:-

High-Low Method:-

Variable cost per unit (x) is calculated using the following formula:

Variable cost per unit=a2-a1/b2-b1

Where,
a2 is the total cost at highest level of activity;
a1 is the total cost at lowest level of activity;
b2 are the number of units at highest level of activity; and
b1 are the number of units at lowest level of activity

Total Fixed Cost

Total fixed cost (a) is calculated by subtracting total variable cost from total cost, thus:

Total Fixed Cost = a2 – x*b2 = a1 – x*b1

We have,
at highest activity: b2 = 1600; a2 = $66000
at lowest activity: b1 = 1100; a1 =$49500

Variable Cost per unit = ($66000? $49500) ÷ (1600 units – 1100 units)  

                                     = $16500/500 units =$33 per unit
Total Fixed Cost = $66000 ? ($33 per unit*1600 units)

= $66000 – $52800 =$13200


Related Solutions

Konza Company has collected the following cost and production data from their manufacturing operations over the...
Konza Company has collected the following cost and production data from their manufacturing operations over the past eight months. Period Units Produced Total costs (Sh) 1 2,200 10,500 2 3,100 12,750 3 5,600 18,500 4 1,700 9,250 5 6,300 20,750 6 8,100 25,250 7 5,050 17,625 8 3,000 12,500 (a) Using the high-low method ; i. Estimate the fixed production costs, ii. Estimate the variable production cost per unit, (b) Establish a cost estimating function for the total production costs....
Princeton Manufacturing Company summarizes the following total cost data for the month of March. Princeton has...
Princeton Manufacturing Company summarizes the following total cost data for the month of March. Princeton has a normal capacity per month of 25,000 units of product that sell for $80 each. For the foreseeable future, sales volume should equal normal capacity of production. Direct material $590,000 Direct labor 330,000 Variable overhead 170,000 Fixed overhead (Note 1 280,000 Selling expense (Note 2 160,000 Administrative expense (fixed) 112,000 $1,642,000 Notes: 1. Beyond normal capacity, fixed overhead cost increases $12,700 for each 1,000...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,000 450 4,900 550 5,400 600 6,000 700 6,300 750 6,900 This data was used to develop an estimated regression equation, ŷ = 1,305.33 + 7.44x, relating production volume and cost for a particular manufacturing operation. Use α = 0.05 to test whether the production volume is significantly related to the total cost. (Use the F test.) State...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production...
Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,000 450 5,000 550 5,300 600 5,900 700 6,400 750 6,900 This data was used to develop an estimated regression equation, ŷ = 1,305.33 + 7.44x, relating production volume and cost for a particular manufacturing operation. Use α = 0.05 to test whether the production volume is significantly related to the total cost. (Use the F test.) (a)...
Consider the following sample of production volumes and total cost data for a manufacturing operation.
You may need to use the appropriate technology to answer this question. Consider the following sample of production volumes and total cost data for a manufacturing operation. Production Volume (units) Total Cost ($) 400 4,100 450 5,000 550 5,500 600 5,900 700 6,500 750 7,000 This data was used to develop an estimated regression equation, ŷ = 1,342.67 + 7.52x, relating production volume and cost for a particular manufacturing operation. Use α = 0.05 to test whether the production volume...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning WIP 16,000 units Started in production 100,000 Completed production 90,000 Ending WIP 26,000 The beginning inventory was 60% complete for conversion costs. The ending inventory was 40% complete for conversion costs. Materials are added at the beginning of the process. Costs pertaining to the month of April are as follows: Beginning inventory costs are:      Materials $63,000      Direct labour 18,000      Factory overhead...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning WIP 17,100 units Started in production 104,500 Completed production 91,300 Ending WIP 30,300 The beginning inventory was 60% complete for conversion costs. The ending inventory was 40% complete for conversion costs. Materials are added at the beginning of the process. Costs pertaining to the month of April are as follows: Beginning inventory costs are:      Materials $66,100      Direct labour 19,500      Factory overhead...
Question 31 Montreal Manufacturing Inc. has the following cost and production data for the month of...
Question 31 Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning WIP 17,100 units Started in production 104,500 Completed production 91,300 Ending WIP 30,300 The beginning inventory was 60% complete for conversion costs. The ending inventory was 40% complete for conversion costs. Materials are added at the beginning of the process. Costs pertaining to the month of April are as follows: Beginning inventory costs are:      Materials $66,100      Direct labour 19,500     ...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning WIP 20,000 units Started in production 104,000 Completed production 94,300 Ending WIP 29,700 The beginning inventory was 60% complete for conversion costs. The ending inventory was 40% complete for conversion costs. Materials are added at the beginning of the process. Costs pertaining to the month of April are as follows: Beginning inventory costs are:      Materials $64,100      Direct labour 20,500      Factory overhead...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning...
Montreal Manufacturing Inc. has the following cost and production data for the month of April. Beginning WIP 17,900 units Started in production 104,000 Completed production 91,600 Ending WIP 30,300 The beginning inventory was 60% complete for conversion costs. The ending inventory was 40% complete for conversion costs. Materials are added at the beginning of the process. Costs pertaining to the month of April are as follows: Beginning inventory costs are:      Materials $64,100      Direct labour 20,900      Factory overhead...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT