Question

Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties of rice—White, Fragrant, and Loonzain. Budgeted sales by product and in total for the coming month are shown below:

	Product
	White					Fragrant					Loonzain					Total
Percentage of total sales		20	%				52	%				28	%				100	%
Sales	$	150,000		100	%	$	390,000		100	%	$	210,000		100	%	$	750,000		100	%
Variable expenses		108,000		72	%		78,000		20	%		84,000		40	%		270,000		36	%
Contribution margin	$	42,000		28	%	$	312,000		80	%	$	126,000		60	%		480,000		64	%
Fixed expenses																	449,280
Net operating income																$	30,720

Dollar sales to break-even	=	Fixed expenses	=	$449,280	= $702,000
		CM ratio		0.64

As shown by these data, net operating income is budgeted at $30,720 for the month and the estimated break-even sales is $702,000.

Assume that actual sales for the month total $750,000 as planned. Actual sales by product are: White, $300,000; Fragrant, $180,000; and Loonzain, $270,000.

Required:

1. Prepare a contribution format income statement for the month based on the actual sales data.

2. Compute the break-even point in dollar sales for the month based on your actual data

Answer 1

• Requirement 1

	White		Fragrant		Loonzain		Total
Percent of total sales	40%		24%		36%		100%
Sales	$300,000	100%	$180,000	100%	$270,000	100%	$750,000	100%
Variable expenses	$216,000	72%	$36,000	20%	$108,000	40%	$360,000	48%
Contribution margin	$84,000	28%	$144,000	80%	$162,000	60%	$390,000	52%
Fixed expenses							$449,280
Net Operating Income							($59,280)

• Requirement 2

Dollar sales to break-even	=	Fixed expenses	=	$449,280	$864,000
		CM ratio		0.52