Answer using excel

QUESTION 1 (35) Jay Emm Ltd manufactures and sells only one product. The following information refers to the operations during April 2020: 1. Cost per Unit of Product Raw Materials: R40.00 R36.00 Direct Labour: 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 R56.00 R30.00 Manufaturing Overheads: 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) Production budget (unit and value) 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. (4) (1) (5) (13)