Masde Corporation produces and sells Product CharlieD. To guard against stockouts, the company requires that 25% of the next month's sales be on hand at the end of each month. Budgeted sales of Product CharlieD over the next four months are:
June | July | August | September | |
---|---|---|---|---|
Budgeted sales in units | 40,000 | 60,000 | 50,000 | 80,000 |
Prepare a Production Budget. | ||||
Budgeted production for June,July , August. | ||||
Masde Corporation | ||||
Production Budget | ||||
For the Months of June through August | ||||
June | July | August | Quarter | |
Budgeted unit sales | 40000 | 60000 | 50000 | 150000 |
Plus:Desired ending finished goods inventory (25 % of the next month's) | 15000 | 12500 | 20000 | 47500 |
Total needs | 55000 | 72500 | 70000 | 197500 |
Less:Beginning finished goods Inventory | 10000 | 15000 | 12500 | 37500 |
Required production in units | 45000 | 57500 | 57500 | 160000 |
Working Notes : | ||||
Desired Ending Inventory = 25 % of next month | ||||
June = 60000* 25 % | 15000 | |||
July = 50000 * 25 % | 12500 | |||
August = 80000*25% | 20000 | |||
Beginning finished goods inventory in June month = 40000*25 % = 10000 | ||||
Get Answers For Free
Most questions answered within 1 hours.