Gold Star Rice, Limited, 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% | 384,000 | 48% |
Contribution margin | $ 268,800 | 70% | $ 32,000 | 20% | $ 115,200 | 45% | 416,000 | 52% |
Fixed expenses | 224,640 | |||||||
Net operating income | $ 191,360 |
Dollar sales to break-even = Fixed expenses / CM ratio = $224,640 / 0.52 = $432,000
As shown by these data, net operating income is budgeted at $191,360 for the month and the estimated break-even sales is $432,000.
Assume that actual sales for the month total $800,000 as planned; however, actual sales by product are: White, $256,000; Fragrant, $320,000; and Loonzain, $224,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.
Trending nowThis is a popular solution!
Step by stepSolved in 3 steps
- Red Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 34,000 54,000 27,000 54,000 Each T-shirt is expected to sell for $18. The purchasing manager buys the T-shirts for $7 each. The company needs to have enough T-shirts on hand at the end of each quarter to fill 28 percent of the next quarter’s sales demand. Selling and administrative expenses are budgeted at $68,000 per quarter plus 14 percent of total sales revenue. Required:. Determine budgeted cost of merchandise purchased for quarters 1, 2, and 3.. Determine budgeted cost of good sold for quarters 1, 2, and 3.. Determine selling and administrative expenses for quarters 1, 2, and 3.. Complete the budgeted income statement for quarters 1, 2, and 3.arrow_forwardSmithen Company, a wholesale distributor, has been operating for only a few months. The company sells three products-sinks, mirrors, and vanities. Budgeted sales by product and in total for the coming month are shown below based on planned unit sales as follows: Sinks Mirrors Vanities Total Percentage of total sales Sales Variable expenses Contribution margin unit Units Percentage 50% 600 300 300 1,200 Contribution margin per Fixed expenses Operating income 25% 25% 100% S Sinks 46% 319.99 $239,992.00 100% $157,200 100% $126,808.00 100% $524,000.00 100% 47,998.40 20% 125,760 80% 63,404.00 50% 237,162.40 45% $191,993.60 80% $ 31,440 20% $63,404.00 50% 286,837.60 55% Break-even point in sales dollars - Product Mirrors 30% S 104.80 Fixed expenses Overall CM ratio $248,050 $239.03* $248,050 0.55 Vanities 24% 1,037.73 units $ 211.35 Total 100% =$451,000 Break-even point in unit sales: Total Fixed expenses Weighted average CM per unit *($319.99 x 0.50) + ($104.80 x 0.25)+($211.35 × 0.25)…arrow_forwardGold Star Rice, Limited, 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% $ 374,400 112,320 $ 262,080 Fragrant 20% 100% $ 156,000 30% 124,800 70% $ 31,200 Product 100% 80% 20% Loonzain 32% $ 249,600 137, 280 $ 112,320 100% 55% 45% Total 100% $ 780,000 374,400 405, 600 228,800 $ 176,800 Dollar sales to break-even = Fixed expenses ÷ CM ratio = $228,800 ÷ 0.52 = $440,000 As shown by these data, net operating income is budgeted at $176,800 for the month and the estimated break-even sales is $440,000. Assume actual sales for the month total $780,000 as planned; however, actual sales by product are White, $249,600; Fragrant, $312,000; and Loonzain, $218,400. Required: 1. Prepare a contribution format income statement for the month…arrow_forward
- Gold Star Rice, Limited, 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 Percentage of total sales White 48% Fragrant 20% Loonzain 32% Total 100% Sales Variable expenses $ 369,600 110,880 100% 30% $ 154,000 123,200 100% 80% Contribution margin Fixed expenses Net operating income $ 258,720 70% $ 30,800 20% $ 246,400 135,520 $ 110,880 100% 55% 45% $ 770,000 369,600 100% 48% 400,400 52% 226,720 $ 173,680 Dollar sales to break-even - Fixed expenses / CM ratio = $226,720/0.52 = $436,000 As shown by these data, net operating income is budgeted at $173,680 for the month and the estimated break-even sales is $436,000. Assume that actual sales for the month total $770,000 as planned; however, actual sales by product are: White, $246,400; Fragrant, $308,000; and Loonzain, $215,600. Required: 1. Prepare a contribution format income statement…arrow_forwardGold Star Rice, Limited, 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 20% $ 150,000 108,000 $ 42,000 Fragrant 52% 100% $ 390,000 72% 28% $ 312,000 78,000 Required 1 Required 2 Product Loonzain 28% Complete this question by entering your answers in the tabs below. 100% $ 210,000 20% 84,000 80% $ 126,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. 100% 40% 60% Tota 100% Dollar sales to break-even = Fixed expenses / CM ratio = $449,280 / 0.64 = $702,000 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.…arrow_forwardRed Canyon T-shirt Company operates a chain of T-shirt shops in the southwestern United States. The sales manager has provided a sales forecast for the coming year, along with the following information: Quarter 1 Quarter 2 Quarter 3 Quarter 4 Budgeted unit sales 40,000 60,000 30,000 60,000 Each T-shirt is expected to sell for $15. The purchasing manager buys the T-shirts for $6 each. The company needs to have enough T-shirts on hand at the end of each quarter to fill 25 percent of the next quarter’s sales demand. Selling and administrative expenses are budgeted at $80,000 per quarter plus 10 percent of total sales revenue. Required: Determine budgeted sales revenue for each quarter. Determine budgeted cost of merchandise purchased for each quarter. Determine budgeted cost of good sold for each quarter. Determine selling and administrative expense for each quarter. Complete the budgeted income statement for each quarter.arrow_forward
- Wongtien Electronics Corp. in Hong Kong, SAR, China, manufactures tablets, laptops and desktop PCs. Wongtien currently operates a standard absorption costing system. Budgeted information for next year is given below (currency in one thousand Hong Kong Dollars, HK$000): Products Tablets Laptops Desktop PCs Total Sales revenue 3,640 12,480 9,880 26,000 Direct material 800 2,800 2,200 5,800 Direct labor 300 1,200 800 2,300 Fixed production overheads 1,456 4,992 3,952 10,400 Gross profit 1,084 3,488 2,928 7,500 Fixed production overheads are currently absorbed based on a percentage of sales revenue. Wongtien is considering changing to an activity-based…arrow_forwardGold 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 $ 374,400 100 % $ 156,000 100 % $ 249,600 100 % $ 780,000 100 % Variable expenses 112,320 30 % 124,800 80 % 137,280 55 % 374,400 48 % Contribution margin $ 262,080 70 % $ 31,200 20 % $ 112,320 45 % 405,600 52 % Fixed expenses 234,000 Net operating income $ 171,600 Dollar sales to break-even = Fixed expenses = $234,000 = $450,000 CM ratio 0.52 As shown by these data, net operating income is budgeted at $171,600 for the month and the estimated break-even sales is $450,000. Assume that actual sales for the…arrow_forwardWongtien Electronics Corp. in Hong Kong, SAR, China, manufactures tablets, laptops and desktop PCs. Wongtien currently operates a standard absorption costing system. Budgeted information for next year is given below (currency in one thousand Hong Kong Dollars, HK$000): Products Tablets Laptops Desktop PCs Total Sales revenue 3,640 12,480 9,880 26,000 Direct material 800 2,800 2,200 5,800 Direct labor 300 1,200 800 2,300 Fixed production- overheads 1,456 4,992 3,952 10,400 Gross profit 1,084 3,488 2,928 7,500 Fixed production overheads are currently absorbed based on a percentage of sales revenue. Wongtien is considering changing to an…arrow_forward
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education