budget prepared by the plant was incomplete, Jordan Leigh. Waterways' CFO, was sent to BC to oversee the plant's budgeting process for the second quarter of 2023. Jordan asked the various managers to collect the following information for preparing the second-quarter budget. Sales \begin{tabular}{lr} \hline Unit sales for February 2023 & $95,000 \\ \hline Unit sales for March 2023 & 107,000 \\ \hline Expected unit sales for April 2023 & 115,000 \\ \hline Expected unit sales for May 2023 & 120,000 \\ \hline Expected unit sales for June 2023 & 125,000 \\ \hline Expected unit sales for July 2023 & 140,000 \\ \hline Expected unit sales for August 2023 & 165,000 \\ \hline Average unit selling price & $14 \\ \hline \end{tabular} receivable is collected in the month of sale, and the balance is collected in the month after sale. This was the same collection pattern as the previous year. The new plant has no bad debts. Direct Materials This plant likes to keep 20% 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 $124,200. Labour requires 15 minutes per unit for completion and is paid at an average rate of $12 per hour. \begin{tabular}{|lrl|} \hline Manuficcuring Overhead & \\ \hline Indirect materials & $0.70 & per labour hour \\ \hline Indirect labour & $0.60 & per labour hour \\ \hline Utilities & $0.50 & per labour hour \\ \hline Maintenance & $0.40 & per labour hour \\ \hline Salaries & $43,000 & per month \\ \hline Depreciation & $16,000 & per month \\ \hline Property takes & $2,000 & per month \\ \hline Insurance & $1,200 & per month \\ \hline Janitorial & $2,500 & per month \\ \hline \end{tabular} Selling and Administrative Variable selling and administrative expenses per unit are $1.50 AdvertisingDepreciationInsurance:OtherfixedcostsSalaries$12,000amonth$2,200amonth$1,200amonth$3,600amonth$71,000amonth Other Information in $1.000 increments at 2.9 interest. Borrowing is considered to be on the first day of the month and repayments and interest payments are on the last day of the month. In May, $840,600 of newrequipment to update operations will be purchased. For the second quarter of 2023, prepare a sales budget For the second quarter of 2023, prepare a schedule for expected cash collections from customers. For the second quarter of 2023, prepare a production budget For the second quarter of 2023, prepare a direct materials budget. (Round cost per lot to 2 dechnal places, eg. 0.25 and all other ansmers fo 0 decimal places es 2.520 ) WATERWAYS CORPORATION British Columbia Production Plant Direct Materials Budget for the 2nd Quarter, 2023 For the second quarter of 2023. prepare a schedule for expected payments for materials purchases. (Round answers to 0 derinal phoces, ea 2.520) WATERWAYS CORPORATION British Columbia Production Plant Expected DM Cash Disbursements for the 2nd Quarter, 2023 For the second quarter of 2023, prepare a direct labour budget (hlound the per unilt to 2 decimal falocies, esp 525 ) For the second quarter of 2023, prepare a manufacturing overhead budget. (Round variable overhead rate to 2 declinal places, es. 5.25 and all other answers io 0 decimal places, ea 2.275.) For the second quarter of 2023, prepare a selling and administrative expenses budget (Enter per unlt expenses roumbed to 2 dechnal places, a.g 125.) WATERWAYS CORPORATION British Columbia Production Plant Selling and Administrative Budget for the 2nd Quarter, 2023 $ \$) 5