Skip to main content
Business LibreTexts

5.E: Exercises (Part 1)

  • Page ID
    864
    • Anonymous
    • LibreTexts
    \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Questions

    1. What is a fixed cost? Provide two examples.
    2. What is the difference between a committed fixed cost and a discretionary fixed cost? Provide examples of each.
    3. What is a variable cost? Provide two examples.
    4. What is a mixed cost? Provide two examples.
    5. Describe the variables in the cost equation \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\).
    6. How is the cost equation \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) used to estimate future costs?
    7. Why is it important to identify how costs behave with changes in activity?
    8. Review Note 5.11 "Business in Action 5.2" Why was the school district’s administration surprised to find out that cost savings from closing a school would be much lower than initially anticipated?
    9. Explain how account analysis is used to estimate costs.
    10. Describe the four steps of the high-low method and how these steps are used to estimate costs.
    11. Why might the high-low method lead to inaccurate results?
    12. Describe the five steps of the scattergraph method and how these steps are used to estimate costs.
    13. How can the scattergraph method be used to identify unusual data points?
    14. Describe how regression analysis is used to estimate costs.
    15. How does the contribution margin income statement differ from the traditional income statement?
    16. Review Note 5.27 "Business in Action 5.3" Which costs at Lowe’s are likely to be variable costs?
    17. Describe the term relevant range. Why is it important to stay within the relevant range when estimating costs?
    18. Explain how some costs can behave in a nonlinear way.

    Brief Exercises

    1. Planning at Bikes Unlimited. Refer to the dialogue at Bikes Unlimited presented at the beginning of the chapter. What is the first step to be taken by Susan and her accounting staff to help in estimating profit for August?
    2. Identifying Cost Behavior. Vasquez Incorporated is trying to identify the cost behavior of the three costs that follow. Cost information is provided for three months.
    Cost A Cost B Cost C
    Month Units Produced Total Costs Cost per Unit Total Costs Cost per Unit Total Costs Cost per Unit
    1 1,500 $1,500   $4,500   $3,000  
    2 3,000 $1,500   $5,250   $6,000  
    3 750 $1,500   $3,750   $1,500  

    Required:

    1. Calculate the cost per unit, and then identify how the cost behaves for each of the three costs (fixed, variable, or mixed). Explain the reasoning for your answers.
    2. How does identifying cost behavior patterns help managers?
    1. Account Analysis. Cordova Company would like to estimate production costs on an annual basis. Costs incurred for direct materials and direct labor are variable costs. The accounting records indicate that the following production costs were incurred last year for 50,000 units.
    Direct materials $100,000
    Direct labor $215,000
    Manufacturing overhead $300,000 (20 percent fixed; 80 percent variable)

    Required:

    Use account analysis to estimate the fixed costs per year, and the variable cost per unit.

    1. High-Low Method. The city of Rockville reported the following annual cost data for maintenance work performed on its fleet of trucks.
    Reporting Period (Year) Total Costs Level of Activity (Miles Driven)
    Year 1 $ 750,000 225,000
    Year 2 $850,000 240,000
    Year 3 $1,100,000 430,000
    Year 4 $1,150,000 454,000
    Year 5 $1,250,000 560,000
    Year 6 $1,550,000 710,000

    Required:

    1. Use the four steps of the high-low method to estimate total fixed costs per year and the variable cost per mile. State your results in the cost equation form \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\).
    2. What would the estimated costs be if the trucks drove 500,000 miles in year 7?
    1. Scattergraph Method. Refer to the data in Brief Exercise 22 for the city of Rockville.

    Required:

    1. Use the five steps of the scattergraph method to estimate total fixed costs per year and the variable cost per mile. State your results in the cost equation form \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) by filling in the dollar amounts for \(\mathcal{f}\) and \(\mathcal{v}\).
    2. What would the estimated costs be if the trucks drove 500,000 miles in year 7?
    1. Regression Analysis. Regression analysis was run using the data in Brief Exercise 22 for the city of Rockville. The output is shown here:
      Coefficients
    y-intercept 441,013
    x variable 1.53

    Required:

    1. Use the regression output to develop the cost equation \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) by filling in the dollar amounts for \(\mathcal{f}\) and \(\mathcal{v}\).
    2. What would the city of Rockville’s estimated costs be if its trucks drove 500,000 miles in year 7?
    1. Contribution Margin Income Statement. Last year Pod Products, Inc., sold its product for $250 per unit. Production costs totaled $40,000 (25 percent fixed, 75 percent variable). Selling and administrative costs totaled $150,000 (10 percent fixed, 90 percent variable). Pod Products produced and sold 1,000 units last year.

    Required:

    Prepare a contribution margin income statement for Pod Products, Inc.

    1. Relevant Range. Jersey Company produces jerseys for athletic teams, and typically produces between 1,000 and 5,000 jerseys annually. The accountant is asked to estimate production costs for this coming year assuming 9,000 jerseys will be produced.

    Required:

    What is meant by the term relevant range, and why is the relevant range important for estimating production costs for this coming year at Jersey Company?

    Exercises: Set A

    1. Identifying Cost Behavior. Zhang Corporation is trying to identify the cost behavior of the three costs shown. Cost information is provided for six months.
    Cost A Cost B Cost C
    Month Units Produced Total Costs Cost per Unit Total Costs Cost per Unit Total Costs Cost per Unit
    1 18,000 $36,000   $19,800   $5,000  
    2 16,000 $32,000   $19,200   $5,000  
    3 14,000 $28,000   $18,200   $5,000  
    4 12,000 $24,000   $16,800   $5,000  
    5 10,000 $20,000   $14,500   $5,000  
    6 8,000 $16,000   $12,000   $5,000  

    Required:

    1. Calculate the cost per unit, and then identify how the cost behaves (fixed, variable, or mixed) for each of the three costs. Explain the reasoning behind your answers.
    2. Why is it important to identify how costs behave with changes in activity?
    1. Account Analysis. Baker Advertising Incorporated would like to estimate costs associated with its clients on an annual basis. Assume costs for supplies and advertising staff are variable costs. The accounting records indicate the following costs were incurred last year for 100 clients:
    Supplies $ 20,000
    Advertising staff wages (hourly employees) $170,000
    Manager salary $ 90,000
    Building rent $ 56,000

    Required:

    1. Use account analysis to estimate total fixed costs per year, and the variable cost per unit. State your results in the cost equation form \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) by filling in the dollar amounts for \(\mathcal{f}\) and \(\mathcal{v}\).
    2. Estimate the total costs for this coming year assuming 120 clients will be served.
    1. High-Low Method. Castanza Company produces computer printers. Management wants to estimate the cost of production equipment used to produce printers. The company reported the following monthly cost data related to production equipment:
    Reporting Period (Month) Total Costs Machine Hours
    January $ 920,000 45,000
    February $600,000 25,000
    March $500,000 20,000
    April $1,100,000 90,000
    May $1,140,000 95,000
    June $620,000 30,000
    July $880,000 38,000
    August $910,000 48,000
    September $1,060,000 78,000
    October $960,000 51,000
    November $1,400,000 96,000
    December $980,000 54,000

    Required:

    1. Use the four steps of the high-low method to estimate total fixed costs per month and the variable cost per machine hour. State your results in the cost equation form \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) by filling in the dollar amounts for \(\mathcal{f}\) and \(\mathcal{v}\).
    2. What would Castanza Company’s estimated costs be if it used 50,000 machine hours next month?
    3. What would Castanza Company’s estimated costs be if it used 15,000 machine hours next month? Why should you feel uncomfortable estimating costs for 15,000 machine hours?
    1. Scattergraph Method. Castanza Company produces computer printers. Management wants to estimate the cost of production equipment used to produce printers. The company reported the following monthly cost data related to production equipment (this is the same data as the previous exercise):
    Reporting Period (Month) Total Costs Machine Hours
    January $ 920,000 45,000
    February $600,000 25,000
    March $500,000 20,000
    April $1,100,000 90,000
    May $1,140,000 95,000
    June $620,000 30,000
    July $880,000 38,000
    August $910,000 48,000
    September $1,060,000 78,000
    October $960,000 51,000
    November $1,400,000 96,000
    December $980,000 54,000

    Required:

    1. Use the five steps of the scattergraph method to estimate total fixed costs per month and the variable cost per machine hour. State your results in the cost equation form \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) by filling in the dollar amounts for \(\mathcal{f}\) and \(\mathcal{v}\).
    2. What would Castanza Company’s estimated costs be if it used 50,000 machine hours next month?
    3. What would Castanza Company’s estimated costs be if it used 15,000 machine hours next month?
    1. Regression Analysis. Regression analysis was run for Castanza Company resulting in the following output (this is based on the same data as the previous two exercises):
      Coefficients
    y-intercept 445,639
    x variable 8.54

    Required:

    1. Contribution Margin Income Statement. Last month Kumar Production Company sold its product for $60 per unit. Fixed production costs were $40,000, and variable production costs amounted to $15 per unit. Fixed selling and administrative costs totaled $26,000, and variable selling and administrative costs amounted to $5 per unit. Kumar Production produced and sold 7,000 units last month.

    Required:

    1. Prepare a traditional income statement for Kumar Production Company.
    2. Prepare a contribution margin income statement for Kumar Production Company.
    3. Why do companies use the contribution margin income statement format?
    1. Regression Analysis Using Excel (Appendix). Walleye Company produces fishing reels. Management wants to estimate the cost of production equipment used to produce the reels. The company reported the following monthly cost data related to production equipment:
    Reporting Period (Month) Total Costs Machine Hours
    January $1,104,000 54,000
    February $720,000 30,000
    March $600,000 24,000
    April $1,320,000 108,000
    May $1,368,000 114,000
    June $744,000 36,000
    July $1,056,000 45,600
    August $1,092,000 57,600
    September $1,272,000 93,600
    October $1,152,000 61,200
    November $1,680,000 115,200
    December $1,176,000 64,800

    Required:

    1. Use Excel to perform regression analysis. Provide a printout of the results.
    2. Use the regression output to develop the cost equation \(\text{Y} = \mathcal{f} + \mathcal{v} \text{X}\) by filling in the dollar amounts for \(\mathcal{f}\) and \(\mathcal{v}\).
    3. What would Walleye Company’s estimated costs be if it used 90,000 machine hours this month?

    This page titled 5.E: Exercises (Part 1) is shared under a CC BY-NC-SA 3.0 license and was authored, remixed, and/or curated by Anonymous via source content that was edited to the style and standards of the LibreTexts platform; a detailed edit history is available upon request.