In: Accounting
Weightless Inc. produces a Bath and Gym version of its popular electronic scale. The anticipated unit sales for the scales by sales region are as follows:
Bath Scale | Gym Scale | |||
East Region unit sales | 20,500 | 40,600 | ||
West Region unit sales | 22,100 | 23,200 | ||
Total | 42,600 | 63,800 |
The finished goods inventory estimated for October 1, for the Bath and Gym scale models is 1,700 and 2,100 units, respectively. The desired finished goods inventory for October 31 for the Bath and Gym scale models is 1,200 and 2,300 units, respectively.
Prepare a production budget for the small and large scales for the month ended October 31. For those boxes in which you must enter subtracted or negative numbers use a minus sign.
Weightless Inc. | ||
Production Budget | ||
For the Month Ending October 31 | ||
Units Bath Scale | Units Gym Scale | |
Total | ||
Total units to be produced |
Weightless Inc. |
||
Production Budget |
||
For the Month Ending October 31 |
||
Units Bath Scale |
Units Gym Scale |
|
Budgeted sale [East + West Region] |
42,600 |
63,800 |
Add: Desired ending Inventory (Oct 31) |
1,200 |
2,300 |
Total |
43,800 |
66,100 |
Less: Beginning inventory (Oct 1) |
|
|
Total units to be produced |
42,100 |
64,000 |