Production Manager nas provide Mimi wielonowms Pio - Sales Unit (bottles) Unit Selling Price Direct Material Required per bottle in ml) Cost of Direct Material (RM per ml) Direct Labour Hours (DLH per bottle) Rate (RM per DLH) Quarter 3 - 2020 Cili sos Tomato sos mayonaise 1,500 1,000 300 RM15 RM10 RM10 300 250 I 450 RM0.10 RM0.05 RM0.04 1.5 1.01 1.0 RM4.50 RM4.50 RM4.50 Quarter 4 - 2020 Cili sos Tomato sos Mayonnaise 1,500 1,000 500 RM15 RM10 RM10 300 250 450 RM0.10 RM0.05 RM0.04 1.5 1.0 1.0 RM4.50 RM4.50 RM4.50 The managers would like to maintain the quarterly ending balances of its inventories as: Finished Goods Inventory 10% of current Quarter's required sales unit Raw Materials Inventory 10% of current Quarter's required direct material (in ml) It is expected that the beginning balances for Quarter 3 of both inventories to be at: Cili sos Tomato sos Finished Goods Inventory Raw Materials Inventory 150 units 45,000 ml 100 units 25,000 ml The standard cost cards for 2022 is available for reference to plan the quarterly budgets: Manufacturing Overhead - Costs Card Variable Costs Selling & Administrative Expense - Costs Card RM per DLH Variable Expenses % on Sales Revenue RM0.25 Shipping Charges 1.00% RM0.15 Sales Commission 5.00% Utilities Packaging Fixed Costs per month Factory Rent Depreciation - Mixer Blender per month Fixed Expenses RM30,000| Travel Allowances RM5,000 Advertising RM1,000 RM1,500 Required: Show all workings on a Microsoft Excel spreadsheet. Marks are granted based on the correct answer, and, the relevant Excel cell-reference, formulae and/or functions used. Prepare the following Operating Budgets to project KSB's expected costs requirements for the last 6-months of 2022: a) Direct Materials Budget b) Direct Labour Budget Show the total for each product and the total for each quarter