Question

In: Accounting

Shatner Inc. has decided to use the high-low method to estimate the total cost and the...

Shatner 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
5,945 $436,240
3,820 415,670
1,845 280,440

a. Determine the variable cost per unit and the total fixed cost.

Variable cost: (Round to the nearest dollar.) $ per unit
Total fixed cost: $

b. Based on part (a), estimate the total cost for 2,800 units of production.

Total cost for 2,800 units: $

Solutions

Expert Solution

Answer:- a)-High-Low Method:-

Variable Cost per Unit

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

Variable cost per unit=Y2-Y1/X2-X1

Where,
y2 is the total cost at highest level of activity;
y1 is the total cost at lowest level of activity;
x2 are the number of units/miles/ labor ,machine hours etc. at highest level of activity; and
x1 are the number of units/miles/ labor, machine hours etc. at lowest level of activity

The variable cost per unit is equal to the slope of the cost volume line (i.e. change in total cost ÷ change in number of machine hours).

Total Fixed Cost

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

Total Fixed Cost = y2 – b*x2 = y1 – b*x1

We have,
at highest activity: x2 = 5945 units; y2 = $436240
at lowest activity: x1 = 1845 units; y1 = $280440

Variable Cost per unit = ($436240− $280440) ÷ (5945 −1845)  

= $155800/4100 units =$38 per unit

Total Fixed Cost = $436240 − ($38 × 5945) = $436240 – $225910 =$210330

b)-The estimated monthly overhead costs =

Variable costs+ Fixed costs

=(2800 units*$38 per unit)+$210330

=$106400+$210330 =$316730


Related Solutions

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...
Ziegler Inc. has decided to use the high-low method to estimate the total cost and the...
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 1,260 $221,760 2,610 277,690 4,060 344,960 a. Determine the variable cost per unit and the total fixed cost. Variable cost: (Round to the nearest dollar.) $ per unit Total fixed cost: $ b. Based on part (a), estimate the total cost...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $854,100 325,000 February 952,200 363,000 March 673,000 235,000 April 913,000 351,000 May 765,700...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and...
1. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed “gross-ton miles,” which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $929,600 247,000 February 1,036,400 276,000 March 732,500 179,000 April 993,700 268,000 May 833,400...
Please answer both. High-Low Method for a Service Company Boston Railroad decided to use the high-low...
Please answer both. High-Low Method for a Service Company Boston Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Boston Railroad is a measure of railroad operating activity, termed "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $1,008,400 298,000 February 1,124,300 333,000 March 794,600 216,000 April 1,078,000 323,000...
High-Low Method, Cost Formulas During the past year, the high and low use of three different...
High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,400,000 Low 28,000 $ 18,400,000 Fuel: High...
High-Low Method, Cost Formulas During the past year, the high and low use of three different...
High-Low Method, Cost Formulas During the past year, the high and low use of three different resources for Fly High Airlines occurred in July and April. The resources are airplane depreciation, fuel, and airplane maintenance. The number of airplane flight hours is the driver. The total costs of the three resources and the related number of airplane flight hours are as follows: Resource Airplane Flight Hours Total Cost Airplane depreciation: High 44,000 $ 18,000,000 Low 28,000 $ 18,000,000 Fuel: High...
In applying the high-low method of cost estimation to mixed costs, how is the total fixed...
In applying the high-low method of cost estimation to mixed costs, how is the total fixed cost estimated? If fixed costs increase, what would be the impact on the (a) contribution margin? (b) income from operations? An examination of the accounting records of Clowney Company disclosed a high contribution margin ratio and production at a level below maximum capacity. Based on this information, suggest a likely means of improving income from operations. Explain.
Using the high-low method, determine (a) the variable cost per unit and (b) the total fixed cost.
The manufacturing costs of Ackerman Industries for the first three months of the year follow:ParticularsTotal costUnits producedJanuary$1,900,00020,000 unitsFebruary2,250,00027,000March2,400,00030,000Using the high low method,Determine (a) the variable cost per unit and (b) the total fixed cost
Continental Railroad decided to use the high-low method and operating data from the past six months...
Continental Railroad decided to use the high-low method and operating data from the past six months to estimate the fixed and variable components of transportation costs. The activity base used by Continental Railroad is a measure of railroad operating activity, termed "gross-ton miles," which is the total number of tons multiplied by the miles moved. Transportation Costs Gross-Ton Miles January $854,900 228,000 February 953,100 255,000 March 673,600 165,000 April 913,800 247,000 May 766,400 198,000 June 982,600 268,000 Determine the variable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT