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. QUESTION 1 (35) Jay Emm Ltd manufactures and sells only one product. The following information refers to the operations during 2020: 1. Cost per Unit of Product Raw Materials: Material J (8kg at R5 per kg) R40.00 Material M (6kg at R6 per kg) R36.00 Direct Labour: Station 1 (7 hrs at R8 per hour) R56.00 R30.00 hour Manufaturing Overheads: 9 hours at R5 per hour R45.00 R207.00 Raw Material inventory 1 April 2020 30 April 2020 Material J 8,000 kg 7,000 kg Material M 4,000 kg 2,000 kg Production Statistics for April 2020 Finished goods on 1 April 500 units Sales in April 3,000 units at R300 per unit 300 units Finished products on 30 April Required 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.) 2. 3. F (1) (5) (13)