Question

In: Accounting

Chorus, Inc. expects quarterly sales volume for 2017 as follows: 1) 40,000 units; 2) 60,000; 3)...

Chorus, Inc. expects quarterly sales volume for 2017 as follows: 1) 40,000 units; 2) 60,000; 3) 100,000; and 4) 50,000. Additionally, Chorus expects quarterly sales volume for 2018 as follows: 1) 70,000 units; 2) 80,000; 3) 75,000; and 4) 85,000. Chorus has an inventory policy which requires ending finished goods inventory to be 30% of budgeted sales for the next quarter.

(T or F) The amount of production necessary to meet the expected sales for 2017 is 275,000 units.

Solutions

Expert Solution

Ans. FALSE
The amount of production necessary to meet the sales for 2017 is 259,000.
*Calculations are as follows :
CHORUS INC.
Production Budget
For the Year Ended December 31, 2017
First quarter Second quarter Third quarter Fourth quarter Total
Sales 40,000 60,000 100,000 50,000
Add: Desired Ending inventory 18000 30000 15000 21000
Total needs 58,000 90,000 115,000 71,000
Less: Beginning inventory -12000 -18000 -30000 -15000
Units to be produced 46,000 72,000 85,000 56,000 259,000
*WORKING NOTES :
*Ending inventory of currrent quarter = 30% of next quarter's sales
*Calculations for Ending inventory:
Quarter
1 60,000 * 30% 18000
2 100,000 * 30% 30000
3 50,000 * 30% 15000
4 70,000 * 30% 21000
Quarter 1 beginning inventory = Ending inventory of quarter 4 of 2016 = 30% of first quarter of 2017 sales
40,000 * 30%
12,000 units
*Calculations for Beginning inventory:
Quarter
1 (calculated as above) 12000
2 Ending inventory of Q1 18000
3 Ending inventory of Q2 30000
4 Ending inventory of Q3 15000

Related Solutions

Aztec, Inc. had sales as follows during 2017: Quarter 1 7,000 units Quarter 2 8,000 units...
Aztec, Inc. had sales as follows during 2017: Quarter 1 7,000 units Quarter 2 8,000 units Quarter 3 9,000 units Quarter 4 8,000 units Aztec expects sales in each quarter of 2018 to be 10% more than the respective quarters for 2017. If each unit sells for $100, what amounts will appear as sales revenue in the quarterly sales budgets for 2018? $770,000; $880,000; $990,000; $880,000 $630,000; $720,000; $810,000; $720,000
2. The quarterly sales for Grinder Inc are as follows: Period Sales ($M) 2014 96 2015...
2. The quarterly sales for Grinder Inc are as follows: Period Sales ($M) 2014 96 2015 106 2016 100 2017 115 2018 122 2019 120 2020 ??? • Calculate and fit the best straight line to the points using linear regression. • Using the data for trend forecast, estimate the sales for 2020. • Estimate the forecast error. • Show on the graph the regression line, the forecasted sale, and the forecast error.
Braindead Pty Ltd expects sales of 40,000 units of Faytik101 in March. Faytik101 is its most...
Braindead Pty Ltd expects sales of 40,000 units of Faytik101 in March. Faytik101 is its most popular high performance desktop model. The sales manager is confident that between April and June, the total sales will have a 50% growth rate each month from the month before. Each unit of Faytik101 requires 50 units of a specific chip known as Slacker-2. This chip is purchased from an external supplier. The firm maintains 10% of the following month’s sales needs in inventory....
Data on the two products are as follows : Alpha BETA Sales in volume in units...
Data on the two products are as follows : Alpha BETA Sales in volume in units 520 420 units sale price $300 $400 units variable cost 200 240 units contribution margin $100 $160 Total fixed costs for the manufacture of both products are $100,000. Assuming that sales mix in terms of unit remains constant, what is the breakeven point in total revenue dollars?
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,530 May 2,420 June 2,310 The target ending inventory of finished products is as follows. March 31 2,050 April 30 2,300 May 31 2,100 June 30 2,300 2 units of material are required for each unit of finished product. Production for July is estimated at 2,710 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,590 May 2,450 June 2,360 The target ending inventory of finished products is as follows. March 31 2,030 April 30 2,240 May 31 2,170 June 30 2,330 2 units of material are required for each unit of finished product. Production for July is estimated at 2,620 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,600 May 2,420 June 2,320 The target ending inventory of finished products is as follows. March 31 2,010 April 30 2,270 May 31 2,100 June 30 2,360 2 units of material are required for each unit of finished product. Production for July is estimated at 2,670 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,600 May 2,500 June 2,380 The target ending inventory of finished products is as follows. March 31 2,030 April 30 2,290 May 31 2,140 June 30 2,380 2 units of material are required for each unit of finished product. Production for July is estimated at 2,780 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,560 May 2,420 June 2,340 The target ending inventory of finished products is as follows. March 31 2,040 April 30 2,200 May 31 2,200 June 30 2,300 2 units of material are required for each unit of finished product. Production for July is estimated at 2,800 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units...
Rensing Ltd. estimates sales for the second quarter of 2017 will be as follows. Month Units April 2,520 May 2,440 June 2,390 The target ending inventory of finished products is as follows. March 31 2,010 April 30 2,280 May 31 2,170 June 30 2,330 2 units of material are required for each unit of finished product. Production for July is estimated at 2,750 units to start building inventory for the fall sales period. Rensing’s policy is to have an inventory...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT