Question 5 OR (b)

Optimum product mix with machine Z as the bottleneck

12 marks

Time to write
About 24 minutes
Topic
Key factor and product-mix decisions

Question

Question 5 OR (b) · 12 marks

Meera Ltd., makes three products A, B and C, each of which uses three different machines X, Y and Z. The relevant data for June, 2024 are:

ProductABC
Selling Price per unit (Rs)11,0008,4006,200
Variable cost per unit (Rs.)7,6005,8004,200
Machine-wise hours required per unit:
Machine X20125
Machine Y20166
Machine Z2062
Expected Demand (units)220220220

Machine Z has been identified as the bottleneck, with capacity limited to 5,600 hours. From the above information calculate the optimum product mix, and ascertain the total profit at that mix if fixed cost amounts to Rs.8,00,000

Reworded from the university paper: names and figures differ, the task is the same. The original paper belongs to the University of Delhi. See DU's question bank.

Before you write

Read off the question and its marks

24 minfor 12 marks

Read from the question

  • calculateFormula first, then the working, then the answer with its unit (₹, %, units).

Write it in this order

  1. Read the data; note exactly what is asked 2 min
  2. 1 Contribution per Z hour and ranking 4 marks 7 min
  3. 2 Allocation of machine Z hours and optimum mix 5 marks 8 min
  4. 3 Total profit 3 marks 5 min
  5. Check: arithmetic, units (₹, %), final answer underlined 2 min

Try it first. About 24 minutes for 12 marks. Write it out, then open the solution.

Solution

Hover or tap a marked figure, like 72,000, to see how it is made and where else it appears.

Contribution per bottleneck hour and ranking

With machine Z as the bottleneck, products are ranked by contribution per machine-Z hour.

ParticularsABC
Selling price per unit (₹)11,0008,4006,200
Less: Variable cost per unit (₹)7,6005,8004,200
Contribution per unit (₹)3,4002,6002,000
Machine Z hours per unit2062
Contribution per Z hour (₹)170433.331,000
RankIIIIII

Although A earns the most per unit, it earns the least per hour of the scarce machine Z.

Optimum product mix

Product (in order of rank)UnitsMachine Z hours usedContribution (₹)
C (full demand: 220 × 2 hours)2204404,40,000
B (full demand: 220 × 6 hours)2201,3205,72,000
A (balance: 3,840 hours ÷ 20 hours)1923,8406,52,800
Total5,60016,64,800

Hours left for A = 5,600 − 440 − 1,320 = 3,840, enough for 192 of the 220 units demanded. The optimum mix is A 192 units, B 220 units and C 220 units.

Total profit

Particulars₹
Total contribution16,64,800
Less: Fixed cost8,00,000
Profit8,64,800

Where the 12 marks sit

#ComponentMarks
1Contribution per Z hour and ranking4
2Allocation of machine Z hours and optimum mix5
3Total profit3
Total12
Keyboard: ← → previous and next question, / search

Report a problemopens an email to admin@getkunji.com with the question ID834-Q5bORalready filled in.