Hi please only answer question G.

Waterways Continuing Problem-10 (Part Level Submission) Waleways Corporation has recently equired a small matuturing per liur in British Columbia lhal produces one at its more populations. This planl will provide these units for resiale in relail fiatate stores in British Columbia arid Albeld. Rezuse the budget preparesi boy the plail was incomplete, Treien Leigh, Widlerways cro, vias sen o B.C. to oversee the plant si budgeting press for the serverici contest of 2017. Jordan asked the various managers to collect the following information for preparing the second-quarter budget. Sales Unil sales for February 2017 99,000 Unit sales for March 2017 111,000 Expected unil sales for April 2017 119,000 Expected unit sales for May 2017 124,000 Exexcluduriil sales ur June 2017 129,000 Expected unit sales for July 2017 144,000 Expectes uril sales for August 2017 169,000 Average unit selling price $12 Based on the experience from the home plant, Jordan has suggested that the B.C. plant keep 10% of the next month's unit seles in ending inventory. The plant has contracts with some of the major home hardware gients, so all sales are on account; 50% of the accounts receivable is collected in the month of sale, and the balance is collected in the month after sale. This was the same collection pattern from the previous year. The new plent has no bed debts. Direct Materials The combined quantity of direct matcrials (ronsisting of metal, plastic and rubber) used in cach unit is 1.10 kg. Metal, plastic, and rubber together arraunt to $1.50 per kg. Inventory of rantind dirext matcrial on March 31 consisted of 19,145 kg This plant likes to keep 10% of the materials needed for the next month in its ending inventory. Fifty percent of the payables is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable on March 31 will total $120,000. Direct Labour Labour requires 15 minutes per unit for completion and is paid at an average rate of s14 per hour Direct Labour Labour requires 15 minutes per until for completion and is paici al an average tale of $14 per tout Manufacturing Overhead Indirect materials $0.30 per labour hour Indirect labour $0.60 per labour hour Ulililies $0.50 per labout how Maintenance $0.30 per labour hour Salaries $43,800 per month Depreciation $14,800 per month Properly lakes 52,450 per month Insurance S1,250 per month Janitorial $2,400 per month Selling and Administrative Variablc sclling and administrative cost per unit is $1.60. Advertising $16,000 a month Depreciation $2.500 a month Insurance $1,200 a month Other fixed costs $3,600 a month Salaries $57,000 a month Other Information The Cash balance on March 31 will be $124,500, but Waterways has decided it would like to maintain a cash balance of at least $400,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 at 29% 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, 5690,000 of new equipment la upale aperclions will be purchased The Cash balance on March 31 will be $124,500, but Waterways has decided it would like to maintain a cash balance of at least $400,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 at 2% 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, $690,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 May April June Total Sales in units 119000 124000 129000 372000 Per unit selling price 12 12 12 12 Total expected sales 1428000 1488000 1548000 4464000 (b) Your answer is correct. For the second quarter of 2017, prepare a schedule for expected cash collections from customers. (Round answers to 0 decimal places, e.g. 5,275.) WATERWAYS CORPORATION British Columbia Production Plant Expected Cash Collections for the 2nd Quarter, 2017 May June April Total Collections from March 666000 666000 April 714000 714000 April 714000 714000 May 744000 744000 May 744000 744000 June 774000 774000 Total cash collections 1380000 1458000 1518000 4356000 (c) Your answer is 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 Total Budgeted Unit Sales 119000 124000 129000 372000 Add Ending Inventory 12400 12900 14400 14400 : Total Required Units 131400 136900 143400 386400 Less Beginning Inventory 11900 12400 12900 11900 Required Production Units v 119500 124500 130500 374500 (e) Your answer is correct. For the second quarter of 2017, prepare a schedule for expected payments for materials purchases. (Round answers to 0 decimal places, e.g. 2,520.) WATERWAYS CORPORATION British Columbia Production Plant Expected DM Cash Disbursements for the 2nd Quarter, 2017 May June April Total Disbursements from March >> 120000 120000 April 99000 99000 April 99000 99000 May 103208 103208 May 103208 103208 June 108983 108983 Total payments 219000 202208 212191 633399 (f) Your answer is correct. For the second quarter of 2017, prepare a direct labour budget. (Round time per unit to 2 decimal places, e.g. 1.30.) WATERWAYS CORPORATION British Columbia Production Plant Labour Budget for the 2nd Quarter, 2017 April May June Total Units to be Produced 119500 124500 130500 374500 Direct Labour Time (Hours) Per Unit v 0.25 0.25 0.25 0.25 Total Required Direct Labour Hours 29875 31125 32625 93625 Direct Labour Cost Per Hour 14 14 14 14 Total Direct Labour Cost 418250 435750 456750 1310750 (g) For the second quarter of 2017, prepare a manufacturing overhead budget. (Round variable overhead rate to 2 decimal places, e.g. 5.25 and all other answers to 0 decimal places, e.g. 2,275.) WATERWAYS CORPORATION British Columbia Production Plant Manufacturing Overhead Budget for the 2nd Quarter, 2017 April May June Total $ $ $ v Add Less Cash Outflow for Manufacturing Overhead Total Variable Manufacturing Overhead Expected Direct Labour Hours Total Manufacturing Overhead Fixed Overhead Non-Cash Items Variable Rate Waterways Continuing Problem-10 (Part Level Submission) Waleways Corporation has recently equired a small matuturing per liur in British Columbia lhal produces one at its more populations. This planl will provide these units for resiale in relail fiatate stores in British Columbia arid Albeld. Rezuse the budget preparesi boy the plail was incomplete, Treien Leigh, Widlerways cro, vias sen o B.C. to oversee the plant si budgeting press for the serverici contest of 2017. Jordan asked the various managers to collect the following information for preparing the second-quarter budget. Sales Unil sales for February 2017 99,000 Unit sales for March 2017 111,000 Expected unil sales for April 2017 119,000 Expected unit sales for May 2017 124,000 Exexcluduriil sales ur June 2017 129,000 Expected unit sales for July 2017 144,000 Expectes uril sales for August 2017 169,000 Average unit selling price $12 Based on the experience from the home plant, Jordan has suggested that the B.C. plant keep 10% of the next month's unit seles in ending inventory. The plant has contracts with some of the major home hardware gients, so all sales are on account; 50% of the accounts receivable is collected in the month of sale, and the balance is collected in the month after sale. This was the same collection pattern from the previous year. The new plent has no bed debts. Direct Materials The combined quantity of direct matcrials (ronsisting of metal, plastic and rubber) used in cach unit is 1.10 kg. Metal, plastic, and rubber together arraunt to $1.50 per kg. Inventory of rantind dirext matcrial on March 31 consisted of 19,145 kg This plant likes to keep 10% of the materials needed for the next month in its ending inventory. Fifty percent of the payables is paid in the month of purchase, and 50% is paid in the month after purchase. Accounts Payable on March 31 will total $120,000. Direct Labour Labour requires 15 minutes per unit for completion and is paid at an average rate of s14 per hour Direct Labour Labour requires 15 minutes per until for completion and is paici al an average tale of $14 per tout Manufacturing Overhead Indirect materials $0.30 per labour hour Indirect labour $0.60 per labour hour Ulililies $0.50 per labout how Maintenance $0.30 per labour hour Salaries $43,800 per month Depreciation $14,800 per month Properly lakes 52,450 per month Insurance S1,250 per month Janitorial $2,400 per month Selling and Administrative Variablc sclling and administrative cost per unit is $1.60. Advertising $16,000 a month Depreciation $2.500 a month Insurance $1,200 a month Other fixed costs $3,600 a month Salaries $57,000 a month Other Information The Cash balance on March 31 will be $124,500, but Waterways has decided it would like to maintain a cash balance of at least $400,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 at 29% 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, 5690,000 of new equipment la upale aperclions will be purchased The Cash balance on March 31 will be $124,500, but Waterways has decided it would like to maintain a cash balance of at least $400,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 at 2% 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, $690,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 May April June Total Sales in units 119000 124000 129000 372000 Per unit selling price 12 12 12 12 Total expected sales 1428000 1488000 1548000 4464000 (b) Your answer is correct. For the second quarter of 2017, prepare a schedule for expected cash collections from customers. (Round answers to 0 decimal places, e.g. 5,275.) WATERWAYS CORPORATION British Columbia Production Plant Expected Cash Collections for the 2nd Quarter, 2017 May June April Total Collections from March 666000 666000 April 714000 714000 April 714000 714000 May 744000 744000 May 744000 744000 June 774000 774000 Total cash collections 1380000 1458000 1518000 4356000 (c) Your answer is 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 Total Budgeted Unit Sales 119000 124000 129000 372000 Add Ending Inventory 12400 12900 14400 14400 : Total Required Units 131400 136900 143400 386400 Less Beginning Inventory 11900 12400 12900 11900 Required Production Units v 119500 124500 130500 374500 (e) Your answer is correct. For the second quarter of 2017, prepare a schedule for expected payments for materials purchases. (Round answers to 0 decimal places, e.g. 2,520.) WATERWAYS CORPORATION British Columbia Production Plant Expected DM Cash Disbursements for the 2nd Quarter, 2017 May June April Total Disbursements from March >> 120000 120000 April 99000 99000 April 99000 99000 May 103208 103208 May 103208 103208 June 108983 108983 Total payments 219000 202208 212191 633399 (f) Your answer is correct. For the second quarter of 2017, prepare a direct labour budget. (Round time per unit to 2 decimal places, e.g. 1.30.) WATERWAYS CORPORATION British Columbia Production Plant Labour Budget for the 2nd Quarter, 2017 April May June Total Units to be Produced 119500 124500 130500 374500 Direct Labour Time (Hours) Per Unit v 0.25 0.25 0.25 0.25 Total Required Direct Labour Hours 29875 31125 32625 93625 Direct Labour Cost Per Hour 14 14 14 14 Total Direct Labour Cost 418250 435750 456750 1310750 (g) For the second quarter of 2017, prepare a manufacturing overhead budget. (Round variable overhead rate to 2 decimal places, e.g. 5.25 and all other answers to 0 decimal places, e.g. 2,275.) WATERWAYS CORPORATION British Columbia Production Plant Manufacturing Overhead Budget for the 2nd Quarter, 2017 April May June Total $ $ $ v Add Less Cash Outflow for Manufacturing Overhead Total Variable Manufacturing Overhead Expected Direct Labour Hours Total Manufacturing Overhead Fixed Overhead Non-Cash Items Variable Rate