Jay Emm Ltd manufactures and sells only one product. The following information refers to the operations...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. 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.
Expert Answer:
Related Book For
Management Accounting
ISBN: 9781760421144
7th Edition
Authors: Kim Langfield Smith, Helen Thorne, David Alan Smith, Ronald W. Hilton
Posted Date:
Students also viewed these general management questions
-
The following information refers to the financial records of McDonalds Corporation over a three-year period (dollar amounts in millions except share price). a. Compute dividends declared as a...
-
1 Calculate total cost and cost per unit of each home appliances by applying absorption costing. 2 Calculate the total cost and cost per unit of each home appliance by applying ABC system. 3...
-
Carrier Fabrication Company (CFC) manufactures and sells only one product, a special front-mounting bicycle rack for large vehicles. CFC entered into a one-time contract to produce an additional...
-
State the degree and leading coefficient of the polynomial f(x) = 4 + x = 2x 2 - 7x 3 .
-
How does the organization of data in a contribution margin statement help firms make better decisions? Discuss.
-
At Cooks' Corner, a kitchen equipment store, most employees work less than 40 hours per week. However only employees who work a minimum of 40 hours per week are eligible for health insurance. a) Is...
-
The alternate hypothesis for a goodness-of-fit test says that some of the probabilities differ from those specified by the null hypothesis. In Exercises 11 and 12, determine whether the statement is...
-
On January 1, 2013, Plains Power Company overhauled four turbine engines that generate power for customers. The overhaul resulted in a slight increase in the capacity of the engines to produce power....
-
O pts Alltech Corporation on January 1, 2025, issues $100,000 of 5% bonds due in 5 years with interest payable annually at year-end ($100,000 x .05 = $5,000). The current market rate of interest for...
-
In June 2017, BMW announced plans to spend $600 million to expand production at its South Carolina plant. The new investment would allow BMW to prepare for new X model SUVs. BMW apparently felt it...
-
Pizza Studio is a relatively new pizza chain that takes the made-to-order model used by Chipotle and Subway and applies it to pizzas. At a counter, customers order their pizzas with exactly the...
-
Krispy Kremes growth was too rapid with the addition of many new franchised stores at the expense of existing franchises. True/False
-
A companys being late in publishing its balance sheet and statement of cash flows is a signal that the company is taking time to ______________ the statements as it has something to ______________ .
-
Enrons Bankruptcy Examiner concluded that the Prepay Transactions may have been Enrons single largest source of cash during the four-year period prior to Enrons filing for bankruptcy. True/False
-
The electricity fiasco in California was concocted by Enron by transmitting energy into a fictional world ______________ of transmission schedules and ______________ congestion in power lines.
-
Enrons energy trading, especially its gas trading and its trading on the manipulated California electricity market, generated profits that staved off the inevitable crash caused by fictitious...
-
After extensive job cuts to reduce costs, upper - level managers are spending significant amounts of time solving problems in the production units. Lower - level managers are resentful that they...
-
What can you do to reduce hunger where you live? To reduce hunger globally?
-
Give two examples of management accounting information that would be prepared on a regular basis, and two examples of management accounting information that might be prepared on an ad hoc basis.
-
Surf Life Saving Australia (SLSA) is Australia's major water safety, drowning prevent rescue organisation. SLSA aims to create a safe environment at beaches around Australia water patrols and through...
-
Refer to the data given in Exercise 21-23. In E21-23 Tiger's Place is a not-for-profit nursery run by the parents of the enrolled children. Since the school is out of town, it has a water storage...
-
Scott-Russel mechanism for generating straight line has (a) four lower kinematic turning pairs (b) two lower kinematic turning pairs and one lower kinematic sliding pairs (c) one lower kinematic...
-
The driving shaft of a Hooke's joint is rotating at a uniform speed of \(600 \mathrm{rpm}\). The speed of the driven shaft must be 575 and \(625 \mathrm{rpm}\). Determine the maximum permissible...
-
Define a steering gear.
Study smarter with the SolutionInn App