Part II - Effect of Sales Mix on CVP Analysis ** Round all answers to two...

Part II - Effect of Sales Mix on CVP Analysis

** Round all answers to two decimal places.** Also can you please how work so i can understand

Fat Cat Furniture store sells two types of products; cat beds and scratching posts. Over the past year Fat at sold 6,000 cat beds and 4,000 scratching posts, the sales mix of 6,000 beds to 4,000 posts creates a percentage of 60% for the cat beds and 40% for the scratching posts. Fat Cat's total fixed costs are $40,000. The cat bed's unit selling price is $44.00 and variable costs per bed are $24.00. The scratching post's unit selling price is $100.00 and variable cost per post is $30.00.

1. Calculate the weighted average contribution margin per unit.

2. Calculate Fat Cat's breakeven point in units for the "package" of products.

3. Calculate how many units of each product line the company must sell in order to breakeven

4. Calculate the sales dollars required of each product line to breakeven. Do not use the weighted average contribution margin ratio formula due to rounding issues. May still use the weighted average contribution margin per unit formula.

5. Prove the breakeven point by preparing a contribution margin income statement. Make sure to provide three columns: one for Cat Beds, one for Scratching Posts, and one for Total.

6. The owner of Fat Cat Furniture wants to earn a $60,000 profit. Calculate the sales volume in units and total sales dollars of each product line the company must sell in order to earn $60,000 in profit. Do not use the weighted average contribution margin ratio formula due to rounding issues. May still use the weighted average contribution margin per unit formula.

Solutions

Expert Solution

1
		CAT BEDS	SCRATCHING POSTS
	SELLING PRICE	$ 44	$ 100
	VARIABLE COST	$ 24	$ 30
	CONTRIBUTION	$ 20	$ 70
	WEIGHTS	0.6	0.4
	WEIGHTED CONTRIBUTION	12	28	40

2
	FIXED COST	$ 40,000.00
	WEIGHTED CONTRIBUTION	40
	BREAK EVEN UNITS	FIXED COST / CONTRIBUTION
		= 40000/40
		1,000
3	SALES UNIT
	CAT BEDS 60%	600	UNITS
	SCRATCHING POSTS 40%	400	UNITS

4	SALES AMOUNT
	CAT BEDS	$ 26,400
	SCRATCHING POSTS	$ 40,000

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

3. Sales mix and CVP Analysis: Goalie’s Ball, Inc. produces and sells two different types of...

3. Sales mix and CVP Analysis: Goalie’s Ball, Inc. produces and sells two different types of soccer goals: basic and premium. Monthly information regarding the two types of goals are shown below: Basic Premium Total Sales $ 1,080,000 $720,000 $1,800,000 Variable costs $315,400 $294,100 $609,500 Fixed expenses are $517,250 per month in total for the company. Determine the sales mix for the two products Determine the contribution margin ratio for each of the two products (round your decimal answer to...

CVP Analysis and Sales Mix (Multiple Products). Sierra Books Incorporated produces two different products with the...

CVP Analysis and Sales Mix (Multiple Products). Sierra Books Incorporated produces two different products with the following monthly data (this is the base case). Text Lecture Notes Total Selling price per unit $100 $12 Variable cost per unit $60 $3 Expected unit sales 21,000 14,000 35,000 Sales mix 60 percent 40 percent 100 percent Fixed costs $750,000 Assume the sales mix remains the same at all levels of sales except for requirement i. Required: Round to the nearest unit of...

3. Sales mix and CVP Analysis: Goalie’s Ball, Inc. produces and sells three different types of...

3. Sales mix and CVP Analysis: Goalie’s Ball, Inc. produces and sells three different types of soccer balls: basic, deluxe, and pro. Monthly information regarding the three types of balls are shown below: Basic Deluxe Pro Sales volume (Units) 5,500 4,000 500 Price per unit $20.00 $35.00 $60.00 VC per unit $8.00 $19.00 $32.00 Total Fixed Costs (FC): $108,500 Determine the sales mix percentage (%) for the three products. Determine the contribution margin (CM) per unit for each of the...

1) What is a CVP income statement used for? 2) Explain the term sales mix and...

1) What is a CVP income statement used for? 2) Explain the term sales mix and its effects on break-even sales. 3) What is Margin of Safety and how does it get used in CVP Analysis? 4) How does a company determine sales mix when a company has limited resources? 5) How does operating leverage affect profitability?

Determine the value z* that satisfies the conditions below. (Round all answers to two decimal places.)...

Determine the value z* that satisfies the conditions below. (Round all answers to two decimal places.) (a) Separates the largest 3.2% of all z values from the others z* = (b) Separates the largest 0.8% of all z values from the others z* = (c) Separates the smallest 5.6% of all z values from the others z* = (d) Separates the smallest 12.1% of all z values from the others z* =

Multiple-Product Analysis, Changes in Sales Mix, Sales to Earn Target Operating Income Basu Company produces two...

Multiple-Product Analysis, Changes in Sales Mix, Sales to Earn Target Operating Income Basu Company produces two types of sleds for playing in the snow: basic sled and aerosled. The projected income for the coming year, segmented by product line, follows: Basic Sled Aerosled Total Sales $3,000,000 $2,400,000 $5,400,000 Total variable cost 1,000,000 1,000,000 2,000,000 Contribution margin $2,000,000 $1,400,000 $3,400,000 Direct fixed cost 778,000 650,000 1,428,000 Product margin $1,222,000 $750,000 $1,972,000 Common fixed cost 198,900 Operating income $1,773,100 The selling prices...

Both of the following statements apply to Part (a) answers and Part (b) answers: (a) Two...

Both of the following statements apply to Part (a) answers and Part (b) answers: (a) Two point charges totaling 542.0 μC exert a repulsive force of 2490 N on one another when separated by 0.5 m. (b) What is the charge on each if the same magnitude of force as before is attractive and the charges total −130.0μC? (Enter your answer in calculation notation to 3-sigfigs with appropriate units. Ex: 3.00X108 = 3.00E+8). Units are not required in this problem....

Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week...

Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) 1 17 2 23 3 14 4 25 5 17 6 16 7 22 8 19 9 21 10 19 11 17 12 23 (a) Show the exponential smoothing forecasts using α = 0.1, and α = 0.2. Exponential Smoothing Week α = 0.1 α = 0.2 13 (b) Applying the MSE measure of forecast accuracy, would you prefer a...

Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week...

Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) 1 16 2 22 3 17 4 23 5 15 6 17 7 21 8 19 9 20 10 18 11 15 12 23 (a) Show the exponential smoothing forecasts using α = 0.1, and α = 0.2. Exponential Smoothing Week α = 0.1 α = 0.2 13 (b) Applying the MSE measure of forecast accuracy, would you prefer a...

Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week...

Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) 1 17 2 21 3 16 4 24 5 17 6 18 7 22 8 20 9 21 10 19 11 16 12 25 (a) Show the exponential smoothing forecasts using α = 0.1, and α = 0.2. Exponential Smoothing Week α = 0.1 α = 0.2 13 (b) Applying the MSE measure of forecast accuracy, would you prefer a...

Subjects