please answer as soon as possible

Hirookes Inc. does not collect all of these reverse in the period of sale. The accounts recewable department has budgeted for 15 of sales revenue to be collected in the period of sale and 15 to be collected in the next period. The accounts receivable beginning balance is $80,000 > Please prepare the schedule of ute of Expected Cash Collections Schedule of Expected Cash Collections Quarter ) Quarter Quarter 1 Quarter Year Accounts Receivable, beginning balance 30,000 30.000 First quarter sales Second quarter sales Thi quarter sales Fourth quarter sales Totalcanhotions Rejsep K BUDGETING ASSEGNANTV2 Protected View . Seved to this File Home nsert Draw Design Layout References Ming: Review View Help PROTECTED VW Be cardul--files from the continue Un you need to edit ale to stay in Protected Enable liditing trookes Inc. has spoken with the Production Department and determined that it would like to have a desred ending the goods inventory of 20% of next periods sales. The word nie tory finished goods for 1 and the desired ending inventory of 4 is provided. > Please prepare the production Budget Production Bludget For the Year Ended December 31, 2019 Quarter 2 Quarter Quarter 1 Year Quarter Badgeted sales Add Desired ending inventory of finished roods 1000 3.000 Total needs Deducti leginning inventory of finished roods 2.000 2.000 Required Production Fan B 8- BUDGED ASSOMNIV. Protected in Seved to this Home Insert Design Layout References Malings Review View PROTECTED VIEW Becaufiles from the Internet can contain viruses. Unless you need to edit, es sales to stay in Protected Entleding The Production Department is ready to budget for Direct Material Purchases. The Direct Materials needed are stand the cost of the raw materiale $1.50/ Production would like to have 10 quarters production needs as the desired ending inventory of raw materials. The assumed 1 beginning inventory of raw materials and the ending inventory for 4 is provided. Please prepare the Direct Materials Budget Direct Materials Budget For the Year Ended December 31, 2019 Quarter 2 Quarter 1 Quarter Year Quarter Required Production in Cases Production needs Add Desired ending inventory of raw materials 22.500 22.500 Totat needs Deduct: Beginning inventory of raw materials 21.000 21000 Raw materials to be purchased Cost of raw materials to be purchased BUDGE ASSIVE Pected viewed the Insert Draw Layout References Mailings Help O PROTICHD VW Bechestrom the Internet con contains Unless you rundt de styled View The Accounts Payable. Department has advised Brookes Inc. that they expect to pay for Drect Material in the period of purchase and in the period Accounts Payable bed and Paw prepare the schedule of Expected Cashburns for Material Schedule of Expected Cash On rements for Materials Quarter 1 arter arte 3 Our Year Accounts Payable benghalan $25,000 25.00 First quarter Suche Second quarter purchases The arter purchases Fourth water purchases Totalash dastusrent a Rajdeep BUDGE ASSIGNMENTV Protected ViewSaved to the Fide Home Insert Design Layout References Mailings Vir Help PROTECTED VIEW He care-tiles from the Internet can contain runes. Unless you need to use it's set to stay in Protected Vi. Enable Editing Dr The Human Resources Department has indicated that the Direct Labour Cost per hour is $7.50 and the Production Department has indicated that the forect labour Hours per writ. > Please prepare the Direct Labour Budget: Direct Labour Budget For the Year Ended December 31, 2019 01 06 Year Required Production in cases Total direct labour hours needed Total direct labour cost Rajdeep Kue BUDGETING ASSIGNMENTV2 - Protected Vier - Saved to the PC- File Home Insert Draw Design Layout References Mallings Review View 0 PROTECTED VIEW Be careful-Files from the Internet can contain Viruses. Unless you need to edit it's safe to stay in Protected View Enable Editing Help Brookes Inc. has determined that the Variable Overhead Rate per Direct labour hour is $1.75 and the fored manufacturing overhead is $6,200 per quarter and depreciation is $1,500 Please prepare the Manufacturing Overhead Budget Manufacturing Overhead Budget 02 Q3 1 04 Year Budgeted direct labour hours 51.75 51.75 $1.75 Variable overhead rate $1.75 $1.75 Variable manufacturing bverhead Fixed manufacturing overhead Total manufacturing overhead Less: Depreciation Cash disbursement for manufacturing overhead lirookes 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 twentory Budget Endine Finished Goods Inventory Budeet BUDGETING ASSIGNMENTV2 - Protected ViewSaved to this PC Pad File Home insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View manumturing overnesa Enable Editing 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 ventory 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 BUDGETING ASSIGNMENTV - Protected ViewSaved to this PC- Rajder File Home Insert Draw Design Layout References Madings Review View Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View Enable Editing Brookes Inc. budgeted for fixed selling and administrative expenses below. The variable selling and administrative rate based on budgeted units is $11/hour Please prepare the Selling and Administrative Expense Budget Advertising Executive Salaries O2 Insurance Q3 insurance Q4 Property taxes Depreciation $3,000 850 100 2.000 4,300 10,000 Selling and Administrative Expense Budget Q1 02 Q3 04 Year $11 Budgeted Sales Variable selling & admins expense Total budgeted variable selling & administrative expense $11 $11 $11 $11 Budgeted fixed selling & admin. expenses: Advertising Executive Salaries insurance Property taxes Depreciation Total budgeted foed selling & admin, expense 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 word 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 02 03 24 Year Q1 $42,500 Cash balance, beginning Add Receipts: Collection from customers Total Cash available before current financing Deduct disbursements Direct materials Direct labour Manufacturing overhead Selling and administrative Equipment purchases Dividends Total Disbursements Excess (deficiency) of cash available over disbursements 50,000 500 40,000 500 20,000 500 27,000 500 137,000 2,000 Brookes Inc. manufactures basketballs for $20/unit. Brookes Inc. budgets on a quarterly basis and the sales department has budgeted for the following sales: Budgeted Sales Units: 01 Q2 Q3 Q4 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 ($/unit) Total Budgeted Sales Hirookes Inc. does not collect all of these reverse in the period of sale. The accounts recewable department has budgeted for 15 of sales revenue to be collected in the period of sale and 15 to be collected in the next period. The accounts receivable beginning balance is $80,000 > Please prepare the schedule of ute of Expected Cash Collections Schedule of Expected Cash Collections Quarter ) Quarter Quarter 1 Quarter Year Accounts Receivable, beginning balance 30,000 30.000 First quarter sales Second quarter sales Thi quarter sales Fourth quarter sales Totalcanhotions Rejsep K BUDGETING ASSEGNANTV2 Protected View . Seved to this File Home nsert Draw Design Layout References Ming: Review View Help PROTECTED VW Be cardul--files from the continue Un you need to edit ale to stay in Protected Enable liditing trookes Inc. has spoken with the Production Department and determined that it would like to have a desred ending the goods inventory of 20% of next periods sales. The word nie tory finished goods for 1 and the desired ending inventory of 4 is provided. > Please prepare the production Budget Production Bludget For the Year Ended December 31, 2019 Quarter 2 Quarter Quarter 1 Year Quarter Badgeted sales Add Desired ending inventory of finished roods 1000 3.000 Total needs Deducti leginning inventory of finished roods 2.000 2.000 Required Production Fan B 8- BUDGED ASSOMNIV. Protected in Seved to this Home Insert Design Layout References Malings Review View PROTECTED VIEW Becaufiles from the Internet can contain viruses. Unless you need to edit, es sales to stay in Protected Entleding The Production Department is ready to budget for Direct Material Purchases. The Direct Materials needed are stand the cost of the raw materiale $1.50/ Production would like to have 10 quarters production needs as the desired ending inventory of raw materials. The assumed 1 beginning inventory of raw materials and the ending inventory for 4 is provided. Please prepare the Direct Materials Budget Direct Materials Budget For the Year Ended December 31, 2019 Quarter 2 Quarter 1 Quarter Year Quarter Required Production in Cases Production needs Add Desired ending inventory of raw materials 22.500 22.500 Totat needs Deduct: Beginning inventory of raw materials 21.000 21000 Raw materials to be purchased Cost of raw materials to be purchased BUDGE ASSIVE Pected viewed the Insert Draw Layout References Mailings Help O PROTICHD VW Bechestrom the Internet con contains Unless you rundt de styled View The Accounts Payable. Department has advised Brookes Inc. that they expect to pay for Drect Material in the period of purchase and in the period Accounts Payable bed and Paw prepare the schedule of Expected Cashburns for Material Schedule of Expected Cash On rements for Materials Quarter 1 arter arte 3 Our Year Accounts Payable benghalan $25,000 25.00 First quarter Suche Second quarter purchases The arter purchases Fourth water purchases Totalash dastusrent a Rajdeep BUDGE ASSIGNMENTV Protected ViewSaved to the Fide Home Insert Design Layout References Mailings Vir Help PROTECTED VIEW He care-tiles from the Internet can contain runes. Unless you need to use it's set to stay in Protected Vi. Enable Editing Dr The Human Resources Department has indicated that the Direct Labour Cost per hour is $7.50 and the Production Department has indicated that the forect labour Hours per writ. > Please prepare the Direct Labour Budget: Direct Labour Budget For the Year Ended December 31, 2019 01 06 Year Required Production in cases Total direct labour hours needed Total direct labour cost Rajdeep Kue BUDGETING ASSIGNMENTV2 - Protected Vier - Saved to the PC- File Home Insert Draw Design Layout References Mallings Review View 0 PROTECTED VIEW Be careful-Files from the Internet can contain Viruses. Unless you need to edit it's safe to stay in Protected View Enable Editing Help Brookes Inc. has determined that the Variable Overhead Rate per Direct labour hour is $1.75 and the fored manufacturing overhead is $6,200 per quarter and depreciation is $1,500 Please prepare the Manufacturing Overhead Budget Manufacturing Overhead Budget 02 Q3 1 04 Year Budgeted direct labour hours 51.75 51.75 $1.75 Variable overhead rate $1.75 $1.75 Variable manufacturing bverhead Fixed manufacturing overhead Total manufacturing overhead Less: Depreciation Cash disbursement for manufacturing overhead lirookes 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 twentory Budget Endine Finished Goods Inventory Budeet BUDGETING ASSIGNMENTV2 - Protected ViewSaved to this PC Pad File Home insert Draw Design Layout References Mailings Review View Help PROTECTED VIEW Be careful--files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View manumturing overnesa Enable Editing 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 ventory 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 BUDGETING ASSIGNMENTV - Protected ViewSaved to this PC- Rajder File Home Insert Draw Design Layout References Madings Review View Help PROTECTED VIEW Be careful files from the Internet can contain viruses. Unless you need to edit, it's safe to stay in Protected View Enable Editing Brookes Inc. budgeted for fixed selling and administrative expenses below. The variable selling and administrative rate based on budgeted units is $11/hour Please prepare the Selling and Administrative Expense Budget Advertising Executive Salaries O2 Insurance Q3 insurance Q4 Property taxes Depreciation $3,000 850 100 2.000 4,300 10,000 Selling and Administrative Expense Budget Q1 02 Q3 04 Year $11 Budgeted Sales Variable selling & admins expense Total budgeted variable selling & administrative expense $11 $11 $11 $11 Budgeted fixed selling & admin. expenses: Advertising Executive Salaries insurance Property taxes Depreciation Total budgeted foed selling & admin, expense 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 word 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 02 03 24 Year Q1 $42,500 Cash balance, beginning Add Receipts: Collection from customers Total Cash available before current financing Deduct disbursements Direct materials Direct labour Manufacturing overhead Selling and administrative Equipment purchases Dividends Total Disbursements Excess (deficiency) of cash available over disbursements 50,000 500 40,000 500 20,000 500 27,000 500 137,000 2,000 Brookes Inc. manufactures basketballs for $20/unit. Brookes Inc. budgets on a quarterly basis and the sales department has budgeted for the following sales: Budgeted Sales Units: 01 Q2 Q3 Q4 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 ($/unit) Total Budgeted Sales