Sales and production budgets

Bowser 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:

Line Item Description Rumble Thunder

Estimated inventory $($units$),$ June $124561$

Desired inventory $($units$),$ June $3028253$

Expected sales volume $($units$)$:

North Region $2,2001,950$

South Region $5,8505,100$

Unit sales price $$110$ $$205$

Question Content Area

a$.$ Prepare a sales budget.

Bowser Inc.

Sales Budget

For the Month Ending June $30$

Product and Area Unit Sales Volume Unit Selling Price Total Sales

Model: Rumble

North Region North Region

$2,200$

$North Region

$110$

$North Region

$242,000$

South Region South Region

$5,850$

South Region

$110$

South Region

$643,500$

Total Total

$8,050$

$Total

$885,500$

Model: Thunder

North Region North Region

$1,950$

$North Region

$205$

$North Region

$399,750$

South Region South Region

$5,100$

South Region

$205$

South Region

$1,045,500$

Total Total

$7,050$

$Total

$1,445,250$

Total revenue from sales $Total revenue from sales

$2,330,750$

Feedback Area

Feedback

Once sales quantities are estimated, the expected sales revenue can be determined.

Question Content Area

b$.$ Prepare a production budget. For those boxes in which you must enter subtracted or negative numbers use a minus sign.

Bowser Inc.

Production Budget

For the Month Ending June $30$

Line Item Description Units Rumble Units Thunder

Expected units to be sold

Expected units to be sold

$527$

Expected units to be sold

Desired inventory, June $30$

Desired inventory, June $30$

$282$

Desired inventory, June $30$

$53$

Total units available Total units available

Total units available

Estimated inventory, June $1$

Estimated inventory, June $1$

Estimated inventory, June $1$

Total units to be produced Total units to be produced

Total units to be produced