All areas shaded yellow are input fields

Waterways Corporation has recently acquired a small manudacturing operation in Britikh Colurnbis that protuces one of its more popular items. This plant wil provide these units for resale in retail hardware stores in British Columbia and Alberta. Because the budget prepared by the plant was incomplete, Jordan Leigh, Waterway' CFO, was sent to B,C to oversee the plant's budgeting process for the second puarter of 2023. Jordan asked the various managers to collect the following information for preparing the second-quarter budget. Based on the ecperience in the home phant, Jordan has sugsested that the B.C. plant keep 10\% of the next month's unit sale130s in ending imentory. The plant has contracts with some of the major home hardware glints so all sales are on account; 50% of the accounts rectivable 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 The combined quantity of direet materials (consksting of metal, plastic, and rubber) ised in each unit is 1.00kg. Metal, plastic, and rubber toguther amount to 51.50 per k8. Inventory of combined direct materials on March 31 consisted of 12.050kt Thir plant likes to beep 10Nh of the matriak needed for the rext month in its ending thentory. Fity percent of the payables is pakd in the month of purchase and 500W is poid in the inontti after purchase. Accounts aayabie on March 31 wil total 5121200 Directiabout Labgut roquites 15 minutet per unit for completion and is paid at an average rate of $18 per hour. 28+ E. labour butret WATERWAYS CORPORATION Diritish Columbia Production Plant tabour Budnet for the 2nd Ouarter, 2023 75 24 a. Mandacunar overteat buted WATERWAYS CORPORATION Aritish Columbla Production Plant Manufecturine Overhead Eudest for the 2nd Quarter, K. Lellin ave Kaminitration Budret WATERWAYS CONPORATION British Columbia Production Plant: Sielling and Administretlve Budget for the 2 nd Quarter, and Admin. Loributent 4. P Sheet1 + Ready Tevedidinithation butrel WATERWAYS CORPORATION British Columbia Production Plant ing and Administratlve Budget for the 2 nd Quarter, 14 isetret WATERWAYS CORPORATION Beritish Columbia Production Plant cash Budect for the 2nd Quarter, 2023 tis nalabie aih tabioh exendturn pendeture: sunese 76 (.)1714) tianer Correat Tetal