In: Accounting
Sales and A budget of estimated unit production.Production Budgets
Sonic Inc. manufactures two models of speakers, Rumble and Thunder. Based on the following production and sales data for June, prepare (a) a sales budget and (b) a production budget.
Rumble | Thunder | ||
Estimated inventory (units), June 1 | 278 | 69 | |
Desired inventory (units), June 30 | 320 | 60 | |
Expected sales volume (units): | |||
East Region | 3,900 | 3,450 | |
West Region | 5,250 | 4,550 | |
Unit sales price | $110 | $225 |
a. Prepare a sales budget.
Sonic Inc. | |||
Sales Budget | |||
For the Month Ending June 30 | |||
Product and Area |
Unit Sales Volume |
Unit Selling Price |
Total Sales |
Model Rumble: | |||
East Region | $ | $ | |
West Region | |||
Total | $ | ||
Model Thunder: | |||
East Region | $ | $ | |
West Region | |||
Total | $ | ||
Total revenue from sales | $ |
Feedback
b. Prepare a production budget.
Sonic Inc. | ||
Production Budget | ||
For the Month Ending June 30 | ||
Units Model Rumble | Units Model Thunder | |
Expected units to be sold | ||
|
||
Total units required | ||
|
||
Total units to be produced |
Ans.(a) | Statement of Sales Budget | |||||
Sonic Inc. | ||||||
Sales Budget | ||||||
For the Month Ending June 30 | ||||||
Product and Area | Unit Sales Volume | Unit Selling Price | Total Sales | |||
Model Rumble: | ||||||
East Region | 3,900 | 110 | 429,000 | |||
West Region | 5,250 | 110 | 577,500 | |||
Total | 9,150 | $ 1,006,500 | ||||
Model Thunder: | ||||||
East Region | 3,450 | 225 | 776,250 | |||
West Region | 4,550 | 225 | 1,023,750 | |||
Total | 8,000 | $ 1,800,000 | ||||
Total Revenue from Sales | $ 2,806,500 | |||||
Ans.(b) | Statement of Production Budget | |||||
Sonic Inc. | ||||||
Production Budget | ||||||
For the Month Ending June 30 | ||||||
Units Model Rumble | Units Model Thunder | |||||
Expected Units to be sold | 9,150 | 8,000 | ||||
Add: Desired inventory, June 30 | 320 | 60 | ||||
Total Units Required | 9,470 | 8,060 | ||||
Less: Estimated inventory, June 1 | 278 | 69 | ||||
Total Units to be Produced | 9,192 | 7,991 |