Question

In: Accounting

High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities...

  1. High-Low Method, Cost Formulas

    The controller of the South Charleston plant of Ravinia, Inc., monitored activities associated with materials handling costs. The high and low levels of resource usage occurred in September and March for three different resources associated with materials handling. The number of moves is the driver. The total costs of the three resources and the activity output, as measured by moves for the two different levels, are presented as follows:

    Resource        Number of Moves        Total Cost
    Forklift depreciation:              
    Low        5,500                $3,400      
    High        18,500                3,400      
    Indirect labor:              
    Low        5,500                $87,100      
    High        18,500                167,700      
    Fuel and oil for forklift:              
    Low        5,500                $3,520      
    High        18,500                11,840      

    Required:

    If required, round your answers to two decimal places. Enter a "0" if required.

    1. Determine the cost behavior formula of each resource. Use the high-low method to assess the fixed and variable components.

    Forklift depreciation:
    V $fill in the blank 1
    F $fill in the blank 2
    Y $fill in the blank 3
    Indirect labor:
    V $fill in the blank 4
    F $fill in the blank 5
    Y $fill in the blank 6 + $fill in the blank 7X
    Fuel and oil for forklift:
    V $fill in the blank 8
    F $fill in the blank 9
    Y $fill in the blank 10X

    2. Using your knowledge of cost behavior, predict the cost of each item for an activity output level of 8,000 moves.

    Forklift depreciation $fill in the blank 11
    Indirect labor $fill in the blank 12
    Fuel and oil for forklift $fill in the blank 13

    3. Construct a cost formula that can be used to predict the total cost of the three resources combined. If required, round your answers to two decimal places.
    Materials handling cost = $fill in the blank 14 + $fill in the blank 15X

    Using this formula, predict the total materials handling cost if activity output is 8,000 moves.
    Y = $fill in the blank 16

Solutions

Expert Solution

Hope you understood the solution. If you have any doubt please leave your doubt in the comment section so that I can clarify your doubt.

Thank You.


Related Solutions

High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities...
High-Low Method, Cost Formulas The controller of the South Charleston plant of Ravinia, Inc., monitored activities associated with materials handling costs. The high and low levels of resource usage occurred in September and March for three different resources associated with materials handling. The number of moves is the driver. The total costs of the three resources and the activity output, as measured by moves for the two different levels, are presented as follows: Resource        Number of Moves        Total...
Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high...
Question One High-Low Method, High—Low Method, Cost Formulas (LO 3) During the past year, the high and low use of three different resources for Wilson Trucking occurred in July and April. The resources are truck depreciation, fuel, and truck maintenance. The number of kilometres travelled is the driver. The total costs of the three resources and the related number of truck kilometres are as follows: Resource                              Truck Kilometres      Total Cost ($) Truck depreciation: High                                                   46,000,000   2,800,000 Low                                                    32,400,000   2,800,000 Fuel:...
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...
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...
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...
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...
Give a numerical example of cost function method the high-low method  and analyze this cost function? Discuss...
Give a numerical example of cost function method the high-low method  and analyze this cost function? Discuss how is this cost function used in decision making?
Jaguar Electronics, Inc. is a specialized electronics firm located in Charleston, South Carolina in the United...
Jaguar Electronics, Inc. is a specialized electronics firm located in Charleston, South Carolina in the United States. The company was founded in 1965 and has enjoyed success and modest growth as a supplier of components to large manufacturers of specialty electronic-mechanical devices. Recently the company's management has decided to begin manufacturing and marketing a product called the 'Airflow'. The Airflow is manufactured by assembling two component parts: (1) mechanical assemblies (MA), which are purchased from a company in Belgium; and...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT