10. Crystal Company manufactures two models of microcassetterecorders, VCH and MTV. Based on the following production data forApril of the current year, prepare a production budget forApril.
VCH
MTV
Estimated inventory (units), April 1
2,800
4,200
Desired inventory (units), April 30
6,900
5,250
Expected sales volume (units):
Eastern zone
12,500
12,960
Midwest zone
19,000
19,800
Western zone
14,500
9,840
10. Crystal Company manufactures two models of microcassetterecorders, VCH and MTV. Based on the following production data forApril of the current year, prepare a production budget forApril.
VCH | MTV | |
Estimated inventory (units), April 1 | 2,800 | 4,200 |
Desired inventory (units), April 30 | 6,900 | 5,250 |
Expected sales volume (units): | ||
Eastern zone | 12,500 | 12,960 |
Midwest zone | 19,000 | 19,800 |
Western zone | 14,500 | 9,840 |
Related questions
Harmony Audio Company manufactures two models of speakers, DLand XL. Based on the following production and sales data forSeptember 2016, prepare (a) a sales budget and (b) a productionbudget.
| DL | XL | ||
| Estimated inventory (units), September 1 | 303 | 75 | |
| Desired inventory (units), September 30 | 348 | 65 | |
| Expected sales volume (units): | |||
| East Region | 4,300 | 3,800 | |
| West Region | 5,650 | 4,900 | |
| Unit sales price | $135 | $215 |
a. Prepare a sales budget.
| Harmony AudioCompany | |||
| SalesBudget | |||
| For the MonthEnding September 30, 2016 | |||
| Product and Area | Unit Sales Volume | Unit Selling Price | Total Sales |
| Model DL: | |||
| East Region | $ | $ | |
| West Region | |||
| Total | $ | ||
| Model XL: | |||
| East Region | $ | $ | |
| West Region | |||
| Total | $ | ||
| Total revenue from sales | $ | ||
b. Prepare a production budget.
| Harmony AudioCompany | ||
| ProductionBudget | ||
| For the MonthEnding September 30, 2016 | ||
| Units Model DL | Units Model XL | |
| Expected units to be sold | ||
| Plus desired inventory, September 30,2016 | ||
| Total | ||
| Less estimated inventory, September 1,2016 | ||
| Total units to be produced | ||
Ultimate Audio Company manufactures two models of speakers, U500 and S1000. Based on the following production and sales data for June.
| U500 | S1000 | ||
| Estimated inventory (units), June 1 | 300 | 95 | |
| Desired inventory (units), June 30 | 345 | 83 | |
| Expected sales volume (units): | |||
| Northeast Region | 4,400 | 4,950 | |
| Southwest Region | 5,450 | 6,150 | |
| Unit sales price | $135 | $190 |
a. Prepare a A budget that indicates for each product (1) the quantity of estimated sales, and (2) the expected unit selling price.sales budget. Enter all amounts as positive numbers.
| ULTIMATE AUDIO COMPANY | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Sales Budget | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| For the Month Ending June 30
b. Prepare a production budget. Enter all amounts as positive numbers.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Factory Overhead Cost Budget
Sweet Tooth Company budgeted the following costs for anticipatedproduction for August:
| Advertising expenses | $259,400 |
| Manufacturing supplies | 14,220 |
| Power and light | 42,400 |
| Sales commissions | 290,020 |
| Factory insurance | 24,690 |
| Production supervisor wages | 124,710 |
| Production control wages | 32,420 |
| Executive officer salaries | 264,390 |
| Materials management wages | 35,670 |
| Factory depreciation | 20,210 |
Prepare a factory overhead cost budget, separating variable andfixed costs. Assume that factory insurance and depreciation are theonly fixed factory costs.
| SweetTooth Company | ||
| Factory Overhead Cost Budget | ||
| Forthe Month Ending August 31 | ||
| Variable factory overhead costs: | ||
| Manufacturingsupplies | $ | |
| Power and light | ||
| Production supervisorwages | ||
| Production controlwages | ||
| Materials managementwages | ||
| Total variable factory overhead costs | $ | |
| Fixed factory overhead costs: | ||
| Factory insurance | $ | |
| Factory depreciation | ||
| Total fixed factory overhead costs | ||
| Total factory overhead costs | $ | |
2.
Sales and Production Budgets
Sonic Inc. manufactures two models of speakers, Rumble andThunder. 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 | 77 | |
| Desired inventory (units), June 30 | 319 | 67 | |
| Expected sales volume (units): | |||
| East Region | 4,100 | 4,600 | |
| West Region | 5,000 | 4,350 | |
| Unit sales price | $115 | $185 |
a. Prepare a sales budget.
| SonicInc. | |||
| SalesBudget | |||
| Forthe 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 | $ | ||
