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.