80.2K

Verified Solution

Link Copied!

Use Excel and show formulas

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 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 Material J 8,000 kg 30 April 2020 7,000 kg 2,000 kg Material M 4,000 kg Production Statistics for April 2020 500 units Finished goods on 1 April 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. ustrial Accounting 3 (EBIAC3A) ctical Assignment (2022) (1) (5) (13) Page 2 of 4

Answer & Explanation Solved by verified expert

See Answer