eBook Show Me How Print am 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: Rumble Thunder Estimated inventory (units), June 1 Desired inventory (units), June 30 Expected sales volume (units): North Region South Region Unit sales price a. Prepare a sales budget. Product and Area Model: Rumble North Region South Region Total Model: Thunder North Region South Region Bowser Inc. Sales Budget 219 66 252 57 2,150 1,900 5,050 5,700 $125 $195 For the Month Ending June 30 Unit Sales Volume Unit Selling Price Total Sales 00 000 1000 Print Item eBook Product and Area Model: Rumble Show Me How Sales Budget For the Month Ending June 30 Unit Sales Volume Unit Selling Price Total Sales North Region South Region Total Model: Thunder North Region South Region Total Total revenue from sales QO 10000 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 Total units available Total units to be produced < Direct materials purchases budget Print Item Tobin's Frozen Pizza Inc. has determined from its production budget the following estimated production volumes for 12" and 16" frozen pizzas for November: Units 12" Pizza Units 16" Pizza Budgeted production volume 13,200 25,600 There are three direct materials used in producing the two types of pizza. The quantities of direct materials expected to be used for each pizza are as follows: Direct materials: 12" Pizza 16" Pizza Dough Tomato 0.90 lb. per unit 1.50 lb. per unit 0.60 1.00 Cheese 0.80 1.30 In addition, Tobin's has determined the following information about each material: Dough Tomato Cheese Estimated inventory, November 1 650 lbs. 220 lbs. 270 lbs. Desired Inventory, November 30 Price per pound 680 lbs. $1.00 210 lbs. $2.30 300 lbs. $3.30 Prepare November's direct materials purchases budget for Tobin's Frozen Pizza Inc. For those boxes in which you must enter subtracted or negative numbers use a minus sign. Dough Tomato Cheese Estimated inventory, November 1 650 lbs. 220 lbs. 270 lbs. Desired inventory, November 30 680 lbs. 210 lbs. 300 lbs. Price per pound $1.00 $2.30 $3.30 Prepare November's direct materials purchases budget for Tobin's Frozen Pizza Inc. For those boxes in wh sign. Tobin's Frozen Pizza Inc. Direct Materials Purchases Budget For the Month Ending November 30 Line Item Description Dough Tomato Cheese Total Units required for production: 12" pizza 16" pizza Total units available Total units to be purchased Unit Price Total direct materials to be purchased x $ Show Me How Print Item Schedule of cash collections of accounts receivable Pampered Pal Inc., a pet supplies distributor, was organized on January 1. Projected sales for each of the first three months of operations are as follows: January February March $160,000 230,000 310,000 All sales are on account. Collections are expected as follows: 54% of sales are expected to be collected in the month of the sale, 42% in the month following the sale, and the remainder in the second month following the sale. Prepare a schedule indicating cash collections from sales for January, February, and March, Pampered Pal Inc. Schedule of Cash Collections from Sales For the Three Months Ending March 31 January February March Line Item Description January sales on account: Collected in January Collected in February Collected in March February sales on account Collected in February Collected in March March sales on account: Collected in March Total cash collected 0 0000 Schedule of cash payments for a service company EastGate Physical Therapy Inc. is planning its cash payments for operations for the first quarter (January-March). The Accrued Expenses Payable balance on January 1 is $28,000. The budgeted expenses for the next three months are as follows: Salaries Utilities January February March $64,400 $78,400 $86,800 5,300 5,900 7,000 Other operating expenses Total 48,900 53,300 58,700 $118,600 $137,600 $152,500 Other operating expenses include $3,500 of monthly depreciation expense and $800 of monthly insurance expense that was prepaid for the year on May 1 of the previous year. Of the remaining expenses, 65% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on January 1 relates to the expenses incurred in December Prepare a schedule of cash payments for operations for January, February, and March. EastGate Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months Ending March 31 Line Item Description January February Total cash payments March CUT