please answer part F,G,H,I in last picture thanks

"Waterways Continuing Problem-10 (Part Level Submission) Waterways Corporation has recently wouired a small manufacturing operation in British Columbia that produces one of its more popular items. This plant will provide these units for resale in retail hardware stores in Brit Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterway cro, was sent to n. to oversee the plane's budgeting process for the second quarter of 2017. Jordan asked the various managers to collect the following information for preparing the second-quarter budget. Sales Unt sales for February 2017 98,000 Unit sales for March 2017 110.000 Expected unit sales for April 2017 118,000 Expected unit sales for May 2017 123,000 Expected unit sales for June 2017 128,000 Expected unt sales for Say 2017 143,000 Expected unt sales for August 2017 160,000 Average unit selling price 112 Based on the experience from the home plant, Jordan hosted that the plant keep 10% of the next months in sales in ending inventory. The plant has contracts with some of the major home hardware ants, so sales are on account 50% of the accounts receivable is collected in the month of sale, and the balance is collected in the month where. This was the same collection pattern from the previous year. The new plant has no bad debts Direct Materials The combined quantity of direct materials (consisting of metal, plastic and rubber) used in each unit is 1.20 kg, Metal, plastic and rubber together amount to $1.50 per kg. Inventory of combined direct material on March 31 consisted of 14,220 This plant likes to keep 10% of the materiais needed for the next month in its ending inventory. Hitty percent of the payables is paid in the month of purchase, and so is paid in the month after purchase Accounts Payable on March 31 will total $120,600. Direct Labour Labour requires 15 minutes per unt for completion and is paid at an average rate of $12 per hour Manufacturing Overhead Indirect materials $0.70 per labour hour Indirect labour 19.40 per tabour hour Unities 50.40 per labour hour Maintenance $0.30 per labour hour Salaries $43,800 per month Depreciation $17.000 per month Property taxes $2.500 per month Insurance $1,500 per month Janitorial $2,200 per month Selling and Administrative Variable selling and administrative cost per unit is $1.50 Advertising $12,000 a month Depreciation $2,100 a month Insurance $1,300 a month Other fixed costs $3,700 a month Salaries 563,000 a month Other Information The Cash balance on March 31 will be $113,500, but Waterways has decided it would like to maintain a cash balance of at least $500,000 beginning on April 30. The company has an open line of credit with its bank. The terms of the agreement require borrowing to be in $1,000 increments interest. Borrowing is considered to be on the first day of the month and repayments are on the last day of the month. Assume interest is paid at the end of the quarter In May, $870,000 of new equipment to update operations will be purchased Three months' insurance is prepaid on the first day of the first month of the quarter a) Your answer is correct. For the second quarter of 2017, prepare a sales budget WATERWAYS CORPORATION British Columbia Production Plant Sales Budget for the 2nd Quarter, 2017 April May Total Sales in units 118OOD 1123000 T12000 169000 Per unit selling price $13 SE SIE Total expected sales 416000 14760004516000 3142.000 June Your answer is correct. For the second quarter of 2017, prepare a schedule for expected cash collections from customers. (Round answers to decimal places, 6.9.5.275.) WATERWAYS CORPORATION British Columbia Production Plant Expected Cash Collections for the 2nd Quarter, 2017 April May June Total Collections from March 560000 $60000 April 1708000 700000 PAROC May 238000 28000 May P38000 000 June 68000 68000 Total cash collections ST1368000 1446000 $100.000 4320000 April At *(c) Your answer is partially correct. For the second quarter of 2017, prepare a production budget WATERWAYS CORPORATION British Columbia Production Plant Production Budget for the 2nd Quarter, 2017 April May June Audgeted Unt Sales 118000 7123000 T128000 Add Ending Inventory 112300 112800 114300 Total B62000 714300 Required Production Units 1130300 1135800 1142300 383300 Less Beginning Inventory 11800 TTO T2300 1123500 T12800 T129500 Required Production Units 18500 371500 For the second quarter of 2017, prepare a direct materials budget. (Round cost per kg to 2 decimal places, e.g. 0.25 and all other answers to decimal places. 2,520.) WATERWAYS CORPORATION British Columbia Production Plant Direct Materials Budget for the 2nd Quarter, 2017 April June Total Units to be produced 1129500 Direct Materials. Per Unit) 1 Total Production Needs 0200 Tan200 155400 Add Ending Inventory 114820 1700 1157020 MS1260 og Theonning Inventory 116220 20 Total Materials Reuired 2000 TC920 115732 120 Korter kol Tote cost of Purchases 214200 DPP Atten "le) Your answer is correct. For the second quarter of 2017, prepare a schedule for expected payments for materials purchases(Round answers to decimal places, ... 2,520.) WATERWAYS CORPORATION British Columbia Production Plant Expected DM Cash Disbursements for the 2nd Quarter, 2017 April June Total Disbursements from March 120600 120600 May April 707100 107:00 April 07100 1107100 May 3 T111690 1111690 111690 1111690 117990 18790 5229680 1117990 Total payments $27200 2676170 f. For the first quarter of 2017, prepare a selling and administrative budget (Enter per unit expenses rounded to 2 decimal places. E.g. 1.25) g. For the first quarter of 2017, prepare a schedule for expected cash collections from customers. (Do not leave any answer field blank. Enter o for amounts.) h.For the first quarter of 2017, prepare a schedule for expected payments for materials purchases. (Round answers to 0 decimal places, e.g. 2,520. Do not leave any answer field blank. Enter O for amounts.) i.For the first quarter of 2017, prepare a cash budget. (Round answers to 0 decimal places, e.g. 2,520. Do