Question

Texas-Q Company produces and sells barbeque grills. Texas-Q sells three models: a small portable gas grill, a larger stationary gas grill, and the specialty smoker. In the coming year, Texas-Q expects to sell 14,100 portable grills, 47,000 stationary grills, and 4,700 smokers. Information on the three models is as follows:

	Portable	Stationary	Smokers
Price	$86	$195	$245
Variable cost
per unit	42	126	144

Total fixed cost is $1,947,530.

	Required:
1.	What is the sales mix of portable grills to stationary grills to smokers?
2.	Compute the break-even quantity of each product.
3.	Prepare an income statement for Texas-Q for the coming year. What is the overall contribution margin ratio? Use the contribution margin ratio to compute overall break-even sales revenue. Enter the contribution margin ratio as a percentage rounded to two decimal places; round the break-even sales revenue to the nearest dollar.
4.	Compute the margin of safety for the coming year.

1. What is the sales mix of portable grills to stationary grills to smokers?  

2. Compute the break-even quantity of each product.

Break-Even Portable Grills
Break-Even Stationary Grills
Break-Even Smokers

3(a) What is the overall contribution margin ratio? Use the contribution margin ratio to compute overall break-even sales revenue. Enter the contribution margin ratio as a percentage rounded to two decimal places; round the break-even sales revenue to the nearest dollar.

Contribution Margin Ratio	%
Break-Even Revenue

3(b) Prepare an income statement for Texas-Q for the coming year. Refer to the list of Amount Descriptions for the exact wording of text items within your income statement.

Refer to the list below for the exact wording of text items within your income statement.

Amount Descriptions
Operating income
Operating loss
Sales
Total contribution margin
Total fixed cost
Total variable cost

4. Compute the margin of safety for the coming year.

The margin of safety for the coming year is .

Answer 1

1		Portable	Stationary	Smokers	Total
	Units	14,100	47,000	4,700	65,800
	Sales Mix	21.43%	71.43%	7.14%	100.00%
2		Portable	Stationary	Smokers
	Price	86.00	195.00	245.00
	Less: VC	42.00	126.00	144.00
	CM	44.00	69.00	101.00
	Sales Mix	21.43%	71.43%	7.14%
	Weighted Av CM	9.43	49.29	7.21	65.93
	(CM * Sales Mix)
	Fixed Cost	1,947,530
	Break Even Units	29,540.00	(Fixed Cost/65.93)
		Portable	Stationary	Smokers
	Sales Mix	21.43%	71.43%	7.14%
	Break Even Units	6,330	21,100	2,110
3		Portable	Stationary	Smokers
	Price	86.00	195.00	245.00
	Less: VC	42.00	126.00	144.00
	CM	44.00	69.00	101.00
	Sales Mix	21.43%	71.43%	7.14%
	Weighted Av Sales	18.43	139.29	17.50	175.21
	Weighted Av CM	9.43	49.29	7.21	65.93
	Weighted Av CM ratio				37.63%
	Fixed Cost	1,947,530
	Break Even Revenue	5,175,830
		Portable	Stationary	Smokers
	Units	14,100	47,000	4,700
	Price	86.00	195.00	245.00
	Less: VC	42.00	126.00	144.00
	CM	44.00	69.00	101.00
	Price	1,212,600	9,165,000	1,151,500	11,529,100
	Less: VC	592,200	5,922,000	676,800	7,191,000
	CM	620,400	3,243,000	474,700	4,338,100
	Sales	11,529,100
	Less: Variable Cost	7,191,000
	Total Contribution Margin	4,338,100
	Less: Fixed Cost	1,947,530
	Operating Income	2,390,570
4	Margin of Safety:
	Sales	11,529,100
	Less: Break Even Revenue	5,175,830
	Margin of Safety	6,353,270