Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started