Question 1 (Total 20 marks)
Ricky is the operations manager of a company making leather soccer balls for children; and with recent increase in the costs, he wishes to look into the productivity of his company. He would like to know if his company is having a 5% increase in productivity in order to be qualified for a bonus. Please see the annual data below:
Year 2018 |
Year 2019 |
|
Unit Produced |
500,000 |
500,000 |
Labour (hours) |
90,000 |
81,000 |
Capital Invested ($) |
10,000,000 |
11,000,000 |
Materials (Ton) |
240 |
228 |
The details of the various cost items are: S40 per labour hour and $18 per kg of materials While for the capital expense, it is at 0.9% per month of capital investment
Year 2018 |
Year 2019 |
Cost or Rate |
Monthly Cost 2018 |
Monthly Cost 2019 |
Productivity Change (%) |
|
Unit Produced |
500,000 |
500,000 |
||||
Labour (hours) |
90,000 |
81,000 |
40 |
300000 |
|
|
Capital Invested ($) |
10,000,000 |
11,000,000 |
0.9% |
|
99000 |
|
Materials (Ton) |
240 |
228 |
18 |
360000 |
|
|
Sub-total |
|
|
|
The boss of the company is now considering to outsource the
operations to a third party who offers a product transfer cost of
$16 per unit that covers the materials, labour and capital
costs.
Answer to the question:
Data given in the question is as below:
The year 2018 | The year 2019 | Rate | |
Unit Produced | 5,00,000 | 5,00,000 | |
Labour (hours) | 90,000 | 81,000 | 40 |
Capital Invested ($) | 1,00,00,000 | 1,10,00,000 | 0.90% |
Materials (in KG) | 240000 | 228000 | 18 |
Let us calculate the productivity by calculating the cost of each category and then compare them between the two years to find out the improvement or reduction in productivity in the respective category.
Cost items | Annual Cost of 2018 | Annual Cost of 2019 | Monthly Cost 2018 | Monthly Cost 2019 | Reduction() or Increase in Cost | Remark | Productivity |
5,00,000 | 5,00,000 | 41666.66667 | 41666.66667 | ||||
Labour | 3600000 | 3240000 | 300000 | 270000 | -10% | 10% reduction | 10% improvement |
Capital Cost | 1080000 | 1188000 | 90000 | 99000 | 10% | 10% increase | 10% reduction |
Material Cost | 4320000 | 4104000 | 360000 | 342000 | -5% | 5% reduction | 5% improvement |
Subtotal Cost | 9000000 | 8532000 | 750000 | 711000 | -5% | 5% reduction | 5% improvement |
Unit cost= Total Cost/Number of units made | 18 | 17.064 | 18 | 17.064 | -5% | 5% reduction | 5% improvement |
# Will Ricky get his productivity improvement bonus for the Year 2019? Why?
Yes, he will get the bonus, as we have seen that the per-unit production cost in the Year 2019 is 5% lower with respect to the year 2018 production cost per unit, hence he has achieved an overall 5% improvement in productivity.
# The boss of the company is now considering outsourcing the operations to a third party who offers a product transfer cost of $16 per unit that covers the materials, labor and capital costs.
As we have seen that the cost of capital is increasing and even with a 5% improvement in productivity the cost per unit is $17.06 per unit hence to reach at $16 level the has to improve by another 6.2% improvement in their productitvity which may be difficult to achieve. Therefore, if we only consider the cost part then outsourcing of the job makes sense if there are no other cost differences.
As I explained that only cost should not be considered for making a decision to outsource the manufacturing. the other critical factors which should be considered are as below:
a. Quality: There should not be any difference in quality standards by any means otherwise reduced cost has no meaning.
b. Timely Supply: Supply should be as per committed timeline, there should not be any lag in deliveries of products.
c. Other overhead expenses: there should not be any other ordinary or extraordinary overhead expense linked with getting the manufacturing to outsource.
d. Legality: there should not be any legal violation for which his company should be held responsible and this thing should be clearly agreed in the contract.
Question 1 (Total 20 marks) Ricky is the operations manager of a company making leather soccer...
Question 1 (40 marks) Magnate Ltd is a manufacturing company which produces a fixed budget for planning purposes. Set out below is the monthly fixed budget of production costs, together with the actual results observed for the month of November 2019. Budget Actual Units produced 5,000 5,500 £ £ Cost Direct material 20,000 22,764 Direct labour 60,000 75,900 Variable Production overhead 14,000 14,950 Fixed Production overhead 10,000 9,000 Depreciation 4,000 4,000 In preparing the flexed budget, the following standards were...
Question 4 20 marks Forest Company has provided the following data concerning one of the products in its standard cost system. Variable manufacturing overhead is applied to products on the basis of direct labour- hours. Inputs Direct materials Direct labour Variable manufacturing overhead Standard Quantity or Hours per Unit of Output 8.0 grams 0.60 hours 0.60 hours Standard Price or Rate $ 6.10 per gram $ 19.80 per hour $ 4.40 per hour The company has reported the following actual...
Question 4 Perfect Furniture Berhad (PFB) specialises in living room leather furniture products. During the month of March, the company purchased RM210,000 of raw materials. Direct labour hours worked during the period were 8,000 hours. The workers were paid RM10 per hour. Direct expenses (high performance glue, etc) of RM22,000 were incurred. Manufacturing overhead for the month were RM72,000. For the month of March, 72 units of leather furniture was sold for RM9,500 each. PFB also incurred selling costs including...
Q.3 Answer all parts Total 20 marks] The Engineering Manager in A Company Ltd. is responsible for maximising the profit from four product lines A, B, C and D. They have been provided with the following information; Direct materials (kgs) 80 90 95 70 Direct labour (hrs) Welding Assembly Finishing 4.5 9.5 4 3.5 4 8 4 4.5 4 Selling price per unit (E) 1500 2500 3000 1000 300 450 Max.sales for the period (in units) 400 280 250 Budgeted...
Q.3 Answer all parts Total 20 marks] The Engineering Manager in A Company Ltd. is responsible for maximising the profit from four product lines A, B, C and D. They have been provided with the following information; Direct materials (kgs) 80 95 70 Direct labour (hrs) Welding Assembly Finishing 4.5 9 4 4.5 9.5 4 3.5 4 8 4 Selling price per unit (E) 1500 2500 3000 1000 280 Max.sales for the period in units) 400 300 450 250 250...
Question 1 (20 marks) Gauteng Potteryworks makes a variety of pottery products that it sells to retailers. The company uses a job-order costing system in which predetermined overhead rates are used to apply manufacturing overhead cost to jobs. The predetermined overhead rate in the Moulding Department is based on machine-hours, and the rate in the Painting Department is based on direct labour cost. At the beginning of the year, the company’s management made the following estimates: 6 PBA4807 MAY/JUNE 2019...
Question 3 (20 Marks) Anchor Homes Ltd manufactures modular homes. The company has two main products that it sells commercially: a 1,000 square foot, one-bedroom model and a 1,500 square foot, two- bedroom model. The company recently began providing emergency housing (huts) to Emergency Management Australia (EMA). The emergency housing is similar to the 1,000 square foot model. EMA has requested Anchor Homes Ltd to create a bid for 150 emergency huts to be sent for flood victims in the...
Question 4 20 marks Forest Company has provided the following data concerning one of the products in its standard cost system. Variable manufacturing overhead is applied to products on the basis of direct labour- hours. Inputs Direct materials Direct labour Variable manufacturing overhead Standard Quantity or Hours per Unit of Output 8.0 grams 0.60 hours 0.60 hours Standard Price or Rate $ 6.10 per gram $ 19.80 per hour $ 4.40 per hour The company has reported the following actual...
8 of 9 QUESTION 4 [TOTAL MARKS: 25 Marks (a) Basic Lad sells Product X for €30 each. Total unit variable costs are €15. Fixed costs for the company are €250,000. Target profit for the period is €25.000 Calculate the following for the company using appropriate formula (show all working 1. Breakeven point in units 2. Breakeven point in value 3. Sales in units to achieve the expected target profit 4. Sales in value to achieve an expected target profit...
Question 3: Variance Analysis (20 marks in total) A Chill Menu Company produces cases of frozen food. During April, the company produced 1,450 cases of food and incurred the following actual costs: Variable overhead 11000 Fixed overhead 26000 Actual direct labour cost (8,000 direct labour hours) 151200 Actual material cost (30,000 kilograms purchased and used 66000 Standard cost and annual budget information is as follows: Standard cost per case Direct labour (5 hours @ $18) 90 Direct material (20 kilograms...