Question

Sales and Production Budgets 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 25,000 10,000 Desired inventory (units), June 30 30,000 15,000 Expected sales volume (units): Northeast Region 140,000 100,000 Southwest Region 160,000 125,000 Unit sales price $45 $80 a. Prepare a sales budget. Enter all amounts as positive numbers.

Answer 1

Part a

Ultimate Audio Company

Sales Budget

For the Month Ending June 30

Product and Area Unit Sales Volume Unit Selling Price Total Sales

Model U500 :

Northeast Region 140,000 $45 $6,300,000

Southwest Region 160,000 $45 $7,200,000

Total $13,500,000

Model U500 :

Northeast Region 100,000 $80 $8,000,000

Southwest Region 125,000 $80 $10,000,000

Total $18,000,000

Total Revenue from Sales $31,500,000

Part b

Ultimate Audio Company

Production Budget

For the Month Ending June 30

Model U500 Model S1000

Expected Units to be Sold 300,000 225,000

Add Desired Closing Inventory 30,000 15,000

Total 330,000 240,000

Less Desired Opening Inventory (25,000) (10,000)

Total Production 305,000 230,000

Step-by-step explanation:

Note : I have attached the complete question as images below !

A Sales Budget shows the Total Expected Revenue from sale of budgeted units.

Total Revenue = Total Expected Units Sales x Selling Price Per Unit

A Production Budget shows the number of units to be produced to meet the Sales and Inventory targets

Total Production = Expected Sales + Desired Closing Inventory - Desired Opening Inventory