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

Answer:

                                       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