Question

Problem 5-21 Sales Mix; Multiproduct Break-Even Analysis (L05-9] 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: Percentage of total sales Sales Variable expenses Contribution margin Fixed expenses Net operating income White 48 % $302,400 90,720 $211,680 Product Fragrant Loonzain 20% 32% 100 % $126,000 100 % $201,600 100 % 30 % 100,800 80% 110,880 55% 70% $ 25,200 20% $ 90,720 45% Total 100% $630,000 302,400 327,600 227,760 $ 99,840 100 % 48 % 52 % Dollar sales to break- even Fixed expenses CM ratio $227,760 - = $438,000 0.52 As shown by these data, net operating income is budgeted at $99,840 for the month and the estimated break-even sales is $438,000. Assume that actual sales for the month total $630,000 as planned. Actual sales by product are: White, $201,600; Fragrant, $252,000; and Loonzain, $176,400. 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. Complete this question by entering your answers in the tabs below.

Answer 1

Percentage of Total Sales Sale Variabel Expenses Contribution Margin Fixed Cost Net operating Income Contribution Margin Income Statement Products white Fragrant Loonzain 32% 40% 28% 201600 100% 252000 100% 176400 100% 60480 30% 201600 80% 97020 55% 141120 70% 50400 20% 79380 45% Total Total 100% 630000 359100 270900 227760 43140 100.0% 57.0% 43.0% Break Even in Dollar Sales = Fixed Cost / CM Ratio = (227760/0.43) 529674