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 | ||||