- 20 Marks
MA – L2 – Q45 – Decision making techniques
Question
Image Solutions Limited deals in various products. Relevant details of the products are as under:
| PW | PX | PY | PZ | |
|---|---|---|---|---|
| Estimated annual demand (units) | 5,000 | 10,000 | 7,000 | 8,000 |
| Sales price per unit (GH¢) | 150 | 180 | 140 | 175 |
| Material consumption: | ||||
| R (kg) | 2 | 2.5 | 1.5 | 1.75 |
| T (kg) | 0.5 | 0.6 | 0.4 | 0.65 |
| Labour hours | 2 | 2.25 | 1.75 | 2.5 |
| Variable overheads (based on labour cost) | 75% | 80% | 100% | 90% |
| Fixed overheads per unit (GH¢) (based on 80% capacity utilisation) | 10 | 20 | 14 | 16 |
| Machine hours required: | ||||
| Processing machine hours | 5 | 6 | 8 | 10 |
| Packing machine hours | 2 | 3 | 2 | 4 |
Company has a long term contract for purchase of material R and T at a price of GH¢ 15 and GH¢ 20 per kg respectively. Wage rate for 8 hours shift is GH¢ 200.
The estimated overheads given in the above table are exclusive of depreciation expenses. The company provides depreciation on number of hours used basis. The depreciation on each machine based on full capacity utilisation is as follows:
| Hours | GH¢ | |
|---|---|---|
| Processing machine | 150,000 | 150,000 |
| Packing machine | 100,000 | 50,000 |
The company has launched an advertising campaign to promote the sale of its products. GH¢ 2 million have been spent on such campaign. This cost is allocated to the products on the basis of sale.
Required:
Compute the number of units of each product that the company should produce in order to maximize the profit and also compute the product wise and total contribution at optimal product mix.
Answer
| Sale price | PW | PX | PY | PZ |
|---|---|---|---|---|
| 150.00 | 180.00 | 140.00 | 175.00 | |
| Less: Variable cost | ||||
| Material R at GH¢15 | 30.00 | 37.50 | 22.50 | 26.25 |
| Material T at GH¢20 | 10.00 | 12.00 | 8.00 | 13.00 |
| Labour cost at GH¢25 per hour | 50.00 | 56.25 | 43.75 | 62.50 |
| Overheads | 37.50 | 45.00 | 43.75 | 56.25 |
| 127.50 | 150.75 | 118.00 | 158.00 | |
| Contribution margin per unit | 22.50 | 29.25 | 22.00 | 17.00 |
| Annual demand (Units) | 5,000 | 10,000 | 7,000 | 8,000 |
Possible production under each machine:
Processing machine:
| PW | PX | PY | PZ | |
|---|---|---|---|---|
| Machine hours required per unit | 5.00 | 6.00 | 8.00 | 10.00 |
| Average CM per hour | 4.50 | 4.88 | 2.75 | 1.70 |
| Production priority | 2 | 1 | 3 | 4 |
| No. of units that can be produced in available hours in order of CM priority (Restricted to annual demand) | 5,000 | 10,000 | 7,000 | 900 |
| Hours required | 25,000 | 60,000 | 56,000 | 9,000 |
| Contribution margin (GH¢) | 112,500 | 292,500 | 154,000 | 15,300 |
Production for product ‘PZ’ has to be restricted to 900 units due to limited number of machine hours.
Packing machine:
| PW | PX | PY | PZ | |
|---|---|---|---|---|
| Machine hours required per unit | 2.00 | 3.00 | 2.00 | 4.00 |
| Average CM per hour | 11.25 | 9.75 | 11.00 | 4.25 |
| Production priority | 1 | 3 | 2 | 4 |
| No. of units that can be produced in available hours in order of CM priority (Restricted to annual demand) | 5,000 | 10,000 | 7,000 | 8,000 |
| Hours required | 10,000 | 30,000 | 14,000 | 32,000 |
Conclusion:
The packing machine can meet the full demand but capacity of processing machine is limited. Therefore, product mix of processing machine will be manufactured.
Assumption:
It has been assumed that the wage rate per eight hours is divisible.
- Uploader: Salamat Hamid