PART II - COST-VOLUME-PROFIT ANALYSIS (chapter 21 review) CVP analysis involves the examination of the relationship between sales prices, sales and production volume, costs, expenses and of course the eventual profit to be earned given various scenarios. It's often thought of as a great "what-if tool. Management often requests information from the cost accountants on staff. PROBLEM: Front Range Furniture expects to maintain the same inventories at the end of 2020 as at the beginning of the year. The total of all production costs for the year is assumed to be equal to the cost of goods sold. With this in mind, the various department heads were asked to submit estimates of the costs of their departments during the year. A summary report of these estimates is as follows: Estimated Variable Costs (per unit) Estimated Fixed Costs (total) 50 30 350,000 4 Production Costs: Direct Materials Direct Labor Factory Overhead Selling Expenses: Sales salaries/commissions Travel Advertising Miscellaneous selling expenses Administrative Expenses: Management and office staff salaries Office Supplies Miscellaneous administrative expenses Total 340,000 4,000 16,000 2,300 1 4 325,000 6,000 8,700 $1,152,000 $ 90 It's expected that 12,000 units will be sold at a price of $240 per unit. Maximum sales within the relevant range are 18,000. Required: 1. Complete the chart in your working papers to calculate total fixed and variable costs (see the Working Papers for more detailed instructions). 2. Once totals are calculated, create a basic Contribution Margin Income Statement. Complete the following analysis: a. Calculate Contribution Margin per unit and Contribution Margin Ratio b. Calculate the Break-Even Point in units and dollars C. Calculate the Margin of Safety in dollars and as a percentage of sales d. Determine the Degree of Operating Leverage 3. Repeat requirement #2 under the following two independent What-If scenarios: a. If total fixed manufacturing costs can be decreased by 125,000, what are the revised CVP analysis results as a result of that change? b. If total fixed costs increase by $250,000, and to offset the added cost management decides to increase sales price by 20%, causing total sales to decline 15% as a result of that change, what are the revised CVP analysis results as a result of those changes? 4. Provide a summary analysis and recommendations in the space provided to management. REQUIREMENT #3: Repeat requirement #2 under the two independent "What-if" scenarios: WHAT-IF SCENARIO #1: If total fixed manufacturing costs can be decreased by 125,000, what are the revised CVP analysis results as a result of that change? WHAT-IF SCENARIO #2: If total fixed costs increase by $250,000, and to offset the added cost management decides to increase sales price by 20%, causing total sales to decline 15% as a result of that change, what are the revised CVP analysis results as a result of those changes? FRONT RANGE FURNITURE Contribution Margin Income Statement - "What-if" #1 For the year ended December 31, 2015 Sales (12,000 x $240) Less: Variable Costs (12,000 x $90) Contribution Margin Less: Fixed Costs Net Income (or Loss) WHAT-IF SCENARIO #1 Contribution Margin per unit Contribution Margin Ratio Break-Even in Units Break-Even in Dollars Margin of Safety in dollars Margin of Safety (percentage) Degree of Operating Leverage FRONT RANGE FURNITURE Contribution Margin Income Statement - "What-If" #2 For the year ended December 31, 2015 Sales (12,000 x 85%) x ($240 x 120%) Less: Variable Costs (12,000 x 85%) * $90) Contribution Margin Less: Fixed Costs Net Income (or Loss) WHAT-IF SCENARIO #2 Contribution Margin per unit Contribution Margin Ratio Break-Even in Units Break-Even in Dollars Margin of Safety in dollars Margin of Safety (percentage) Degree of Operating Leverage ESTIMATED SALES What-If #1 What-If #2 Sales Volume in units Sales Price per unit Total estimated sales revenue $0 $0 $0 COMMENT HERE: Provide a brief recommendation in this text box of your CVP analysis findings to management. Be sure to explain your position based on your findings from the above analysis. You may delete these instructions and expand this box as needed. After completing this section of your project, submit to the dropbox for Part 2. TYPE YOUR ANALYSIS RECOMMENDATIONS HERE