Problem 4. CVP Analysis, con't. Part 2. Silky Smooth lotions come in two sizes: 4-ounce and 8-ounce bottles. The accompanying Excel file summarizes the selling prices and variable costs per case of each lotion size Fixed costs are $300,000. Current production and sales are 4.000 cases of 4-ounce bottles and 6,000 cases of 8-ounce bottles. These relative proportions of sales of the two products represent the past three year's average sales for Silky Smooth, as shown in its Contribution Margin Income Statement. REQUIRED a. Given the current sales mix, calculate the break-even point in sales units, including the breakdown of the sales of each product. b. Calculate the Degree of Operating Leverage (DOL) at the current sales volume and sales mix. (Use the total; don't attempt to allocate fixed costs to the two products.) c. Using your DOL. in (b), compute the operating profit that would result from a 10% increase in sales from the current sales volume with the same sales mix. d. On you Excel spreadsheet, prepare a data table for the breakeven volume and percentage change in the breakeven point from the current level, for each 1% change in the sales mix of 4-oz & 8-oz bottles, over the range of 35/65% to 45/55%, respectively (1.e., 4-oz. range is 35-45%, corresponding 8-oz range is 63-55% What does your analysis suggest? e. Silky Smooth's marketing director believes that by dropping the price of the 4-oz bottle from $38 to $36 (a 5.26% decrease), sales of the 4-oz bottles should increase by 15% over the current level, without impacting sales of 8-oz bottles. Project the operating profit that would result from this change. Problem 4. CVP Analysis, con't. Part 2. Silky Smooth lotions come in two sizes: 4-ounce and 8-ounce bottles. The accompanying Excel file summarizes the selling prices and variable costs per case of each lotion size Fixed costs are $300,000. Current production and sales are 4.000 cases of 4-ounce bottles and 6,000 cases of 8-ounce bottles. These relative proportions of sales of the two products represent the past three year's average sales for Silky Smooth, as shown in its Contribution Margin Income Statement. REQUIRED a. Given the current sales mix, calculate the break-even point in sales units, including the breakdown of the sales of each product. b. Calculate the Degree of Operating Leverage (DOL) at the current sales volume and sales mix. (Use the total; don't attempt to allocate fixed costs to the two products.) c. Using your DOL. in (b), compute the operating profit that would result from a 10% increase in sales from the current sales volume with the same sales mix. d. On you Excel spreadsheet, prepare a data table for the breakeven volume and percentage change in the breakeven point from the current level, for each 1% change in the sales mix of 4-oz & 8-oz bottles, over the range of 35/65% to 45/55%, respectively (1.e., 4-oz. range is 35-45%, corresponding 8-oz range is 63-55% What does your analysis suggest? e. Silky Smooth's marketing director believes that by dropping the price of the 4-oz bottle from $38 to $36 (a 5.26% decrease), sales of the 4-oz bottles should increase by 15% over the current level, without impacting sales of 8-oz bottles. Project the operating profit that would result from this change
