Sales and Production Budgets 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 230   57 Desired inventory (units), June 30 264   50 Expected sales volume (units):       Midwest Region 2,100   1,850 South Region 5,450   4,750 Unit sales price $145   $190 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 fill in the blank 546851fde010fce_1 $fill in the blank 546851fde010fce_2 $fill in the blank 546851fde010fce_3 South Region fill in the blank 546851fde010fce_4 fill in the blank 546851fde010fce_5 fill in the blank 546851fde010fce_6 Total fill in the blank 546851fde010fce_7   $fill in the blank 546851fde010fce_8 Model: Thunder       Midwest Region fill in the blank 546851fde010fce_9 $fill in the blank 546851fde010fce_10 $fill in the blank 546851fde010fce_11 South Region fill in the blank 546851fde010fce_12 fill in the blank 546851fde010fce_13 fill in the blank 546851fde010fce_14 Total fill in the blank 546851fde010fce_15   $fill in the blank 546851fde010fce_16 Total revenue from sales     $fill in the blank 546851fde010fce_17 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   fill in the blank 36a1c7fda00a02a_2 fill in the blank 36a1c7fda00a02a_3   fill in the blank 36a1c7fda00a02a_5 fill in the blank 36a1c7fda00a02a_6 Total units available fill in the blank 36a1c7fda00a02a_7 fill in the blank 36a1c7fda00a02a_8   fill in the blank 36a1c7fda00a02a_10 fill in the blank 36a1c7fda00a02a_11 Total units to be produced fill in the blank 36a1c7fda00a02a_12 fill in the blank 36a1c7fda00a02a_13   Depreciation Direct labor Estimated inventory, June 1 Expected units to be sold Supervisor salaries

Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,500 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each month is 20 percent of the next month’s sales. The data on materials used are as follows: Direct Material Per-Unit Usage Unit Cost Part #K298 2                $4         Part #C30 3                7         Inventory policy dictates that sufficient materials be on hand at the beginning of the month to satisfy 30 percent of the next month’s production needs. This is exactly the amount of material on hand on…

2

Sales and Production Budgets 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 235   69 Desired inventory (units), June 30 270   60 Expected sales volume (units):       East Region 2,850   2,500 West Region 4,850   5,500 Unit sales price $135   $185 a.  Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending June 30 Product and Area UnitSalesVolume UnitSellingPrice TotalSales Model Rumble:       East Region fill in the blank a2cab3f7d050faf_1 $fill in the blank a2cab3f7d050faf_2 $fill in the blank a2cab3f7d050faf_3 West Region fill in the blank a2cab3f7d050faf_4 fill in the blank a2cab3f7d050faf_5 fill in the blank a2cab3f7d050faf_6 Total fill in the blank a2cab3f7d050faf_7   $fill in the blank a2cab3f7d050faf_8 Model Thunder:       East…

Sales and Production Budgets 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 211   62 Desired inventory (units), June 30 242   54 Expected sales volume (units):       East Region 2,100   1,850 West Region 4,800   5,400 Unit sales price $115   $210 a.  Prepare a sales budget. Sonic Inc. Sales Budget For the Month Ending June 30 Product and Area UnitSalesVolume UnitSellingPrice TotalSales Model Rumble:       East Region   $ $ West Region       Total     $ Model Thunder:       East Region   $ $ West Region       Total     $ Total revenue from sales     $ b.   Prepare a production budget. Sonic Inc. Production Budget For the Month Ending June 30   Units Model Rumble Units Model Thunder Expected units to be sold…

Prepare the raw material purchases budget (in quantities) for 20x0.

How do I prepare the selling and administrative expense budget for the quarter ended March 31, 20X1?

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 265      66 Desired inventory (units), June 30 305   57 Expected sales volume (units):       Northeast Region 3,100   2,750 Southwest Region 5,600   4,850 Unit sales price $120   $205 a.  Prepare a sales budget. Enter all amounts as positive numbers. ULTIMATE AUDIO COMPANY Sales Budget For the Month Ending June 30 Product and Area Unit Sales Volume Unit Sales Price Total Sales Model U500:       Northeast Region   $ $ Southwest Region       Total     $ Model S1000:       Northeast Region   $ $ Southwest Region       Total     $ Total revenue from sales     $ b.  Prepare a production budget. Enter all amounts as positive numbers. ULTIMATE AUDIO COMPANY Production Budget For the Month Ending June 30…

Function: SUM; Formula: Subtract, Multiply; Cell Referencing Using Excel to Prepare a Production Budget PROBLEM Paige Company estimates that following unit sales and desired inventory level for the four quarters of the year ending December 31, 2022. Quarter 1 sales Quarter 2 sales Quarter 3 sales Quarter 4 sales Desired ending finished goods inventory based on next quarter's expected unit sales Unit selling price 10,000 14,000 15,000 18,000 25% $ 70.00 Prepare a production budget by quarters for the first 6 months of 2022. Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area or this work area as indicated. Use the SUM function with cell referencing for totals. Paige Company Production Budget For the Six Months Ending June 30, 2022 Quarter 1 10,000 Expected unit sales Add: Desired ending finished goods units Total required units Less: Beginning finished goods units Required production…

Sales and Production Budgets 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 305 76 Desired inventory (units), June 30 350 66 Expected sales volume (units): Midwest Region 4,300 3,800 South Region 5,700 4,950 Unit sales price $135 $215 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 %24