Attached you will find an excel file containing portions of the master budget for Genie Manufacturing Limited for the month of January 2022. Using the information below fill in the missing portions of the master budget (Production budget, direct materials usage & purchases, cost of goods sold and budgeted income statement). Portions of the budget will fill in based on the amounts you enter in the following budgets: Production budget Direct materials usage & purchases Genie Manufacturing Limited manufactures and sells pet carriers. The following information has been gathered to assist you in preparing the budget for January 2022: Materials & labour requirements & costs Requirements Cost Direct materials: Plastic 5 kilograms $4.50/kg Metal .75 kilograms $4.00/kg Direct labour 4 hours $15/hour Direct materials: Inventory Information - Direct Materials Beginning inventory Target ending inventory Cost of beginning inventory Plastic Metal 200 kg 70 kg 320 kg 50 kg $800 $210 Inventory Information - Finished Goods Target ending inventory 35 units Beginning inventory 20 units Beginning inventory value $2,800 Genie accounts for all inventories using FIFO cost flow assumption. Nonproduction fixed costs for January 2022 include salaries of $26,000 and other operating costs of $10,000. The only variable nonproduction cost is sales commissions of 1% of sales revenue.