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		48	%				20	%				32	%				100	%
Sales	$	360,000		100	%	$	150,000		100	%	$	240,000		100	%	$	750,000		100	%
Variable expenses		108,000		30	%		120,000		80	%		132,000		55	%		360,000		48	%
Contribution margin	$	252,000		70	%	$	30,000		20	%	$	108,000		45	%		390,000		52	%
Fixed expenses																	231,400
Net operating income																$	158,600

Dollar sales to break-even	=	Fixed expenses	=	$231,400	= $445,000
		CM ratio		0.52

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

Assume that actual sales for the month total $750,000 as planned. Actual sales by product are: White, $240,000; Fragrant, $300,000; and Loonzain, $210,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

1	Contribution format income Statement based on Actual data
								(In $)
		Product
		White		Fragrant		Loonzain		Total
	Sales	2,40,000	100%	3,00,000	100%	2,10,000	100%	7,50,000	100%
	Variable Expenses	72,000	30%	2,40,000	80%	1,15,500	55%	4,27,500	57%
	Contribution margin	1,68,000	70%	60,000	20%	94,500	45%	3,22,500	43%
	Fixed Expenses							2,31,400
	Net operating Income							91,100
2	Computation of Break even point based on Actual Data
	Fixed Expenses (a)	2,31,400
	Contribution Margin Ratio (b)	0.43
	Break even point in dollar sales (a/b)	5,38,140