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): Midwest Region 12,000 3,500 South Region 14,000 4,000 Unit sales price $60 $90 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 Midwest Region $ $ South Region Total $ Model: Thunder Midwest Region $ $ South Region Total $ Total revenue from sales $ b. Prepare a production budget. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Sonic Inc. Production Budget For the Month Ending June 30 Units Rumble Units Thunder Total units available Total units to be produced

Answer 1

Answer and Explanation:

a. The preparation of the sales budget is prepared below:-

Sonic Inc.

Sales budget

Particulars Unit Sales Unit Selling price Total Sales

Volume

Model Rumble:

East Region 12,000 $60 $720,000

West Region 14,000 $60 $840,000

Total $1,560,000

Model Thunder:

East region 3,500 $90 $315,000

West region 4,000 $90 $360,000

Total $675,000

Total revenue from sales $2,235,000

To reach the total revenue from sales we simply added the total of model rumble with a total of model thunder.

b. The Preparation of the production budget is shown below:-

Sonic Inc.

Production budget

Particulars Units Model Units Model

Rumble Thunder

Expected units to be

sold 26,000 7,500

(12,000 + 14,000) (3,500 + 4,000)

Add: Desired ending

inventory 500 250

Total units required 26,500 7,750

Less: Beginning inventory 750 300

Total units to be produced 25,750 7,450

So, to reach at total units to be produced we simply deduct the beginning inventory from total units required.