Melody Audio Company manufactures two models of speakers, DL&XL. Based on the following production and sales data forSeptember2007.
Prepare...
(a) a Sales Budget
(b) a Production Budget
DL XL
Estimated Inventory (units),September1 380 140
Desired Inventory (units),September30 450 110
Expected Sales Volume (units):
EastRegion 4,400 3,200
WestRegion 2,900 2,100
UnitSalesPrice $120.00 $170.00
Prepare...
(a) a Sales Budget
(b) a Production Budget
DL XL
Estimated Inventory (units),September1 380 140
Desired Inventory (units),September30 450 110
Expected Sales Volume (units):
EastRegion 4,400 3,200
WestRegion 2,900 2,100
UnitSalesPrice $120.00 $170.00
Related questions
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.
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
Sales and Production Budgets Sonic Inc. manufactures two modelsof speakers, Rumble and Thunder. Based on the following productionand sales data for June, prepare (a) a sales budget and (b) aproduction budget. Rumble Thunder Estimated inventory (units), June1 278 77 Desired inventory (units), June 30 319 67 Expected salesvolume (units): East Region 4,100 4,600 West Region 5,000 4,350Unit sales price $115 $185 a. Prepare a sales budget. Sonic Inc.Sales Budget For the Month Ending June 30 Product and Area UnitSales Volume Unit Selling Price Total Sales Model Rumble: EastRegion $ $ West Region Total $ Model Thunder: East Region $ $ WestRegion Total $ Total revenue from sales $
2.
Personal Budget
At the beginning of the school year, Katherine Malloy decided toprepare a cash budget for the months of September, October,November, and December. The budget must plan for enough cash onDecember 31 to pay the spring semester tuition, which is the sameas the fall tuition. The following information relates to thebudget:
| Cash balance, September 1 (from a summer job) | $6,350 |
| Purchase season football tickets in September | 90 |
| Additional entertainment for each month | 220 |
| Pay fall semester tuition in September | 3,400 |
| Pay rent at the beginning of each month | 310 |
| Pay for food each month | 170 |
| Pay apartment deposit on September 2 (to be returned December15) | 400 |
| Part-time job earnings each month (net of taxes) | 790 |
a. Prepare a cash budget for September,October, November, and December. Enter all amounts as positivevalues except an overall cash decrease which should be indicatedwith a minus sign.
| KATHERINE MALLOY | ||||
| CashBudget | ||||
| Forthe Four Months Ending December 31 | ||||
| September | October | November | December | |
| Estimated cash receipts from: | ||||
| Part-time job | $ | $ | $ | $ |
| Deposit | ||||
| Total cash receipts | $ | $ | $ | $ |
| Estimated cash payments for: | ||||
| Season football tickets | $ | |||
| Additional entertainment | $ | $ | $ | |
| Tuition | ||||
| Rent | ||||
| Food | ||||
| Deposit | ||||
| Total cash payments | $ | $ | $ | $ |
| Overall cash increase (decrease) | $ | $ | $ | $ |
| Cash balance at beginning of month | ||||
| Cash balance at end of month | $ | $ | $ | $ |
