Question

Problem 5-21A Sales Mix; Multiproduct Break-Even Analysis [LO5-9] Gold Star Rice, Ltd., of Thailand exports Thai...

Problem 5-21A Sales Mix; Multiproduct Break-Even Analysis [LO5-9]

Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties of rice—Fragrant, White, 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

$

321,600   

100%

$

134,000   

100%

$

214,400   

100%

$

670,000   

100%

  Variable expenses

96,480   

30%

107,200   

80%

117,920   

55%

321,600   

48%

  Contribution margin

$

225,120   

70%

$

26,800   

20%

$

96,480   

45%

348,400   

52%

  

  Fixed expenses

  

  

  

231,400   

  Net operating income

$

117,000   

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 $117,000 for the month and break even sales at $445,000.

     Assume that actual sales for the month total $670,000 as planned. Actual sales by product are: White, $214,400; Fragrant, $268,000; and Loonzain, $187,600.

Required:

1.

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

  

  

2.

Compute the break-even point in dollar sales for the month based on your actual data. (Round your answer to nearest whole dollar.)

  

Problem 5-21A Sales Mix; Multiproduct Break-Even Analysis [LO5-9] Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties of rice—Fragrant, White, 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 $ 321,600 100% $ 134,000 100% $ 214,400 100% $ 670,000 100% Variable expenses 96,480 30% 107,200 80% 117,920 55% 321,600 48% Contribution margin $ 225,120 70% $ 26,800 20% $ 96,480 45% 348,400 52% Fixed expenses 231,400 Net operating income $ 117,000 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 $117,000 for the month and break even sales at $445,000. Assume that actual sales for the month total $670,000 as planned. Actual sales by product are: White, $214,400; Fragrant, $268,000; and Loonzain, $187,600. Required: 1. Prepare a contribution format income statement for the month based on actual sales data. 2. Compute the break-even point in dollar sales for the month based on your actual data. (Round your answer to nearest whole dollar.)

Homework Answers

Answer #1

1.Contribution format income statement for the month based on actual sales data :

White

Fragrant

Loonzain

Total

Sales $214,400 $268,000 $187,600 $670,000
(-) Variable expenses

$64,320

[ 30% of sales ]

$214,400

[ 80% of sales ]

$103,180

[ 55% of sales ]

$381,900
Contribution margin $150,080 $53,600 $84,420 $288,100
(-) Fixed expenses $231,400

  Net operating income

$56,700

2. Company's overall actual contribution margin ratio = actual total contribution margin / actual total sales = [ $288,100 / $670,000 ] * 100 = 43%

Company's overall Break-even point in dollars based on actual data = Fixed expenses / Company's overall actual contribution margin ratio = $231,400 / 43% = $583,140

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 312,000 100 % $ 130,000 100 % $ 208,000 100 % $ 650,000 100 % Variable expenses 93,600 30 % 104,000 80 % 114,400 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 364,800 100 % $ 152,000 100 % $ 243,200 100 % $ 760,000 100 % Variable expenses 109,440 30 % 121,600 80 % 133,760 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 384,000 100 % $ 160,000 100 % $ 256,000 100 % $ 800,000 100 % Variable expenses 115,200 30 % 128,000 80 % 140,800 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 307,200 100 % $ 128,000 100 % $ 204,800 100 % $ 640,000 100 % Variable expenses 92,160 30 % 102,400 80 % 112,640 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 336,000 100 % $ 140,000 100 % $ 224,000 100 % $ 700,000 100 % Variable expenses 100,800 30 % 112,000 80 % 123,200 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 369,600 100 % $ 154,000 100 % $ 246,400 100 % $ 770,000 100 % Variable expenses 110,880 30 % 123,200 80 % 135,520 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 297,600 100 % $ 124,000 100 % $ 198,400 100 % $ 620,000 100 % Variable expenses 89,280 30 % 99,200 80 % 109,120 55 %...
Gold Star Rice, Ltd., of Thailand exports Thai rice throughout Asia. The company grows three varieties...
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 $ 302,400 100 % $ 126,000 100 % $ 201,600 100 % $ 630,000 100 % Variable expenses 90,720 30 % 100,800 80 % 110,880 55 %...