Question

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 750 300
Desired inventory (units), June 30 500 250
Expected sales volume (units):
East Region 12,000 3,500
West Region 14,000 4,000
Unit sales price $160 $200
a. Prepare a sales budget.
b. Prepare a production budget.

Answer 1

SONIC INC.

SALES BUDGET

FOR THE MONTH ENDING JUNE 30

Product and Area Unit sales volume Unit selling Price Total sales

Rumble

Midwest Region 12,000 $160 $1,920,000

South Region 14,000 $160 $2,240,000

Total 26,000 $4,160,000

Thunder

Midwest Region 3,500 $200 $700,000

South Region 4,000 $200 $800,000

Total 7,500 $1,500,000

Total Revenue from sales = $4,160,000 + 1,500,000 = 5,660,000

2. SONIC INC.

PRODUCTION BUDGET

FOR THE MONTH ENDING JUNE 30

UNITS RUMBLE UNITS THUNDER

Expected unit to be sold 26,000 7,500

Add: Desired Inventory June 30 500 250

Total 26,500 7,750

Less: Estimated Inventory June 1 750 300

Total units to be produced 25,750 7,450