Brookes Inc. manufactures basketballs for $20/unit. Brookes Inc. budgets on a quarterly basis and the sales department has budgeted for the following sales: 01 Q2 Q3 04 10,000 11,000 12,000 14,000 Please prepare the sales Budget. Sales Budget For the year ended December 31, 2020 Quarter 1 Quarter 2 Quarter 3 Quarter 4 Year Expected Sales (units) Selling Price (S/unit) Total Budgeted Sales Brookes Inc does not collect all of the sales revent in the period of te the accounts receivable deportment has buitested for sales revence to be collected in the period of de unid 15% tooted in the next period. The accounts receivable beginning balance > Mease prepare the schedule of Expected Collections Schedule of Expected Cash Collections ter Cutter Quarter 4 Year Accounts Receivable Beginning balance 0.000 30,000 First quarter sales Second quarter sales Third quarter sales Fourth quarter sales Total cash collections Wookes we has woken with the Polution Department and determined that it would be to lawadud endine hd poods inovatory of 2016 runt periode water. The sumed te www finished goods for at and the desired endin entory of 4 provide Mente prepare the production Datert For the Year Ended December 11, 2010 Charter 2 Cutter Quarter Que Yew Badgefed Sales Add Desired ending inventory of need oods 1000 3.000 Total needs Deduct beginning inventory of 2.000 2010 Requred Production The Production Department is mady to budget for et Material Purchases. The Direct Materweed we 15/unit and the cost of the missie Product would have the quartus production needs as the desired ending inventory of raw materials the entory of raw materials and the ending inventory for ispred se prepare the Direct Materials Bugt Dext Materials that For the Year Ended December 31, 2019 Quartet Charter Year Rund Production in Cases Productions Add: esived ending inventory of raw materials Total needs Deduct: Beginning wentory of raw materials 21.000 21000 w materials to be purchased cost of raw materials to be purchased The Accounts Payabile Department has advised Brokes Inc. that they expect to pay forberedt Month period of purchased in the next period. Accounts Payabancesponde Please prepare the schedule of Expected Cash Disbursements for Material Schedule of Expected Cashes for Male Quarter 1 Charter | Date Cher Accounts Payable beginning balance $25,800 25.00 Erst quarter purchase Second quarter purchases Fourth quarter purchases Total disbursements The Human Resources Department has indicated that the Direct Labour Cost per hour is $7.50 and the Production Department has indicated that the of Direct Labour Hours per unit is 0.30 Please prepare the Direct Labour Budget: Direct Labour Budget For the Year Ended December 31, 2019 Q1 Q3 94 Year Required Production in cases Total direct labour hours needed Total direct labour cost Brookes inchas determined that the variable Overhead Hate per Direct labour hours $1.75 and the feed manufacturing overheads 56,200 per quarter and depreciation is $1.500. Mease prepare the Manufacturing Overhead Budget Manufacturing Overhead 02 04 Year 01 Budgeted direct labour hours Variable overhead rate $1.75 $1.75 $1.75 $1.25 Variable manufacturing overhead Fixed manufacturing overhead Total manufacturing overhead Depreciation Gash disbursement for manufacturing overhead Brookes it would like to know the unit product cost as well as the ending finished goods inventory dollar amount Please End Finch Brookes Inc. would like to know the unit product cost as well as the ending finished goods inventory dollar amount. Please prepare the Ending Finished Goods Inventory Budget Ending Finished Goods Inventory Budget For the Year Ended December 31, 2019 Quantity per unit Cost Item Production Cost per case: Total per kilogram Direct Materials Direct labour Manufacturing Overhead Unit Product Cost kilograms hours hours per hour per hour Budgeted Finished Goods Inventory Ending finished goods inventory Unit product cost Ending finished goods inventory in dollars 301 Brookes Inc, budgeted for fixed selling and administrative expenses below. The variable selling and administrative rate based on budgeted units $11/hour > Please prepare the Selling and Administrative Expense Budget $3,000 850 100 Advertising Executive Salaries 02 Insurance Q3 Insurance 24 Property taxes Depreciation 2,000 4,300 10,000 Selling and Administrative Expense Budget Q1 92 Q3 Q4 Year Budgeted Sales Variable selling & admins expense Total budgeted variable selling & administrative expense $11 $11 $11 $11 $11 Budgeted fixed selling & admin. expenses: Advertising Executive Salaries Insurance Property taxes Depreciation Total budgeted fixed selling & admin. expense Total budgeted selling & admin. expenses Less: Depreciation Cash disbursements for selling & administrative expenses The honen haar hand and there har hans nodd 94 Year Total budgeted selling & admin, expenses Less: Depreciation Cash disbursements for selling & administrative expenses The beginning cash balance has been provided and equipment purchases and dividends has been provided. Please prepare the cash budget. Cash Budget For the Year Ended December 31, 2019 Q1 Q2 Q3 Cash balance, beginning $42,500 Add Receipts: Collection from customers Total Cash available before current financing Deduct disbursements Direct materials Direct labour Manufacturing overhead Selling and administrative Equipment purchases 40,000 20,000 27,000 Dividends 500 500 500 500 Total Disbursements Excess (deficiency) of cash available over disbursements 50,000 137,000 2.000