Jay Emm Ltd manufactures and sells only one product. The following information refers to the operations during April 2020: Cost per Unit of Product 1. 2. 3. Raw Materials: Direct Labour: Manufaturing Overheads: Raw Material inventory 1 April 2020 8,000 kg 4,000 kg Production Statistics for April 2020 Finished goods on 1 April Sales in April Finished products on 30 April Material J Material M Material J (8kg at R5 per kg) Material M (6kg at R6 per kg) Station 1 (7 hrs at R8 per hour) Station 2 (5 hrs at R6 per hour) 9 hours at R5 per hour Required 30 April 2020 7,000 kg 2,000 kg 500 units 3,000 units at R300 per unit 300 units Prepare the following budgets for April 2020: a) b) Raw Materials Purchases budget (kilogram and value) c) Direct labour budget (hours and value) d) Manufacturing overheads (hours and value) e) Closing inventories (units, kilograms, and value) Formatting (currency, thousands indicator, lines etc.) R40.00 R36.00 R56.00 R30.00 R45.00 R207.00 (4) (1) (5) (13) INSTRUCTIONS 1. Use Microsoft Excel to answer all the questions in this assignment 2. Each question should be on a new sheet in your Excel workbook. Change the name of each sheet to correspond to the question number (Q1a, Q2, etc.) 3. The name of the file must be in the following format: Student number_EBIAC3A_Practical 2022 4. Calculations in your spreadsheet will be verified (typed in formulas, standard Excel functions, etc.). All mathematical calculations have to be done using Excel - if you type in an answer that should be calculated, you will lose marks. 5. All quantities and values should have comma separators and currency indicators. 6. If a value from a previous calculation have to be inserted, do not type the value.