320 likes | 402 Vues
Accounting What the Numbers Mean 10e. Demonstration Problem. Chapter 12 – Exercise 10 Estimating Costs Based on Behavior Patterns. Problem Definition.
E N D
Accounting What the Numbers Mean 10e Demonstration Problem Chapter 12 – Exercise 10 Estimating Costs Based on Behavior Patterns
Problem Definition • The following table shows the amount of cost incurred in August for the cost items indicated. During August, 8,000 units of the firm’s single product were manufactured. Raw materials $41,600 Factory depreciation expense 40,500 Direct labor 99,200 Production supervisor’s salary 6,100 Computer rental expense 4,200 Maintenance supplies used 800
Problem Requirements • How much cost would you expect to be incurred for each of the above items during September when 9,600 units of product are planned for production? • Calculate the average total cost per unit for the 8,000 units manufactured in August. Explain why this figure would not be useful to a manager interested in predicting the cost of producing 9,600 units in September.
Problem Solution • Step 1– Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Is the cost item a variable cost or a fixed cost?
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Variable Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Variable costs change as activity changes.
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Variable Factory depreciation expense Fixed Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Fixed costs remain constant as activity changes.
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Variable Factory depreciation expense Fixed Direct labor Variable Production supervisor’s salary Computer rental expense Maintenance supplies used
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Variable Factory depreciation expense Fixed Direct labor Variable Production supervisor’s salary Fixed Computer rental expense Maintenance supplies used
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Variable Factory depreciation expense Fixed Direct labor Variable Production supervisor’s salary Fixed Computer rental expense Fixed Maintenance supplies used
Problem Solution • Step 1 – Determine the cost behavior pattern for each cost item: Cost Behavior Raw materials Variable Factory depreciation expense Fixed Direct labor Variable Production supervisor’s salary Fixed Computer rental expense Fixed Maintenance supplies used Variable
Problem Solution • Step 2- Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $ 5.20 Variable rate calculation: $41,600 / 8,000 units = $ 5.20/unit
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 $ 5.20 Fixed costs items will remain constant regardless of the level of activity (within the relevant range).
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 $ 5.20 12.40 Variable rate calculation: $99,200 / 8,000 units = $12.40/unit
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 $ 5.20 12.40
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $ 5.20 12.40
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $ 5.20 12.40 0.10 Variable rate calculation: $800 / 8,000 units = $ 0.10/unit
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70
Problem Solution • Step 2 - Determine the fixed amount or variable rate for each cost item at 8,000 units of activity: Cost @ 8,000 units Cost Behavior Fixed Amount Variable Rate/Unit Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost $ 41,600 40,500 99,200 6,100 4,200 800 $192,400 Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 Cost formula = $50,800 fixed cost + $17.70 per unit variable cost
Problem Solution • Step 3– Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determined in Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 Calculation: 9,600 units * $5.20 per unit
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 40,500 Fixed costs do not change at 9,600 units.
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 40,500 119,040 Calculation: 9,600 units * $12.40 per unit
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 40,500 119,040 6,100
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 40,500 119,040 6,100 4,200
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 40,500 119,040 6,100 4,200 960 Calculation: 9,600 units * $0.10 per unit
Problem Solution • Step 3 – Calculate the cost expected to be incurred in September when 9,600 units are manufactured using the cost formula determinedin Step 2: Cost Behavior Fixed Amount Variable Rate/Unit Cost @ 9,600 units Raw materials Factory depreciation expense Direct labor Production supervisor’s salary Computer rental expense Maintenance supplies used Total Cost Variable Fixed Variable Fixed Fixed Variable $40,500 6,100 4,200 $50,800 $ 5.20 12.40 0.10 $17.70 $ 49,920 40,500 119,040 6,100 4,200 960 $220,720
Problem Requirements • How much cost would you expect to be incurred for each of the above items during September when 9,600 units of product are planned for production? • Calculate the average total cost per unit for the 8,000 units manufactured in August. Explain why this figure would not be useful to a manager interested in predicting the cost of producing 9,600 units in September.
Problem Solution • Average total cost for August: • It would not be meaningful to use this average total cost figure to predict costs in the subsequent months; that would involve unitizing the fixed expenses – and fixed costs do not behave on a per unit basis. $192,400 / 8,000 =$24.05 per unit
Problem Solution • Average total cost calculations are only valid for the number of units used in the calculation. Average total cost for any other number of units produced would be different because the fixed expenses per unit would decrease for each additional unit produced. • Using the average total cost of $24.05 to estimate the cost of producing 9,600 units would give an estimate of $230,880, which is significantly higher than the $220,720 calculated in part a using the cost formula: Total Cost = $50,800 fixed cost + $17.70 per unit variable cost
Accounting What the Numbers Mean 10e You should now have a better understandingof using cost behavior information. Remember that there is a demonstration problem for each chapter that is here for your learning benefit. David H. Marshall Wayne W. McManus Daniel F. Viele