Unit: Quantitative Analysis
Sign in to download the full Topic PDF and enable offline revision mode.
Login to Access| Minibus type | Manufacturer | Cost | Maximum seating | Expected daily profit |
| capacity | per minibus (Sh.) | |||
| Weaverbird | Fastbus | 80,000 | 11 | 10,000 |
| Eaglet | Fastbus | 90,000 | 14 | 12,000 |
| Dovey | Smartbus | 70,000 | 7 | 9,000 |
| Crowlet | Smartbus | 140,000 | 18 | 16,000 |
| Departments | Required time | Available time | |
| Mountain bike | BMX | ||
| Assembly | 2 | 3 | 180 |
| Fitting | 2 | 1 | 120 |
| Painting | 3 | 3 | 240 |
| Subject to: | 1. 4x + 3y ≤ 240 |
| 2. 2x + y ≤ 100 | |
| 3. y ≤ 50 | |
| 4. x, y > 0 |
To produce two units of Standard requires 240 minutes in the Cutting department, half the amount of time in the Assembly department and same amount of time in the Finishing department as in the Cutting department.
To produce one unit of Deluxe requires 60 minutes, 180 minutes and 60 minutes in Cutting, Assembly and Finishing departments respectively.
To produce three units of Luxury requires 180 minutes in Cutting department and twice the amount of time in both Assembly and Finishing departments.
The contribution per unit from Standard, Deluxe and Luxury is Sh.6, Sh.5 and Sh.2 per unit respectively.
Required:
(i) Formulate the above problem as a linear programming model.
(ii) Prepare an initial simplex tableau to solve the above model.

| Product 1 | Product 2 | |
| Processing time: | ||
| 1.6 | 1.0 |
| 2.5 | 1.0 |
Selling price (Sh./unit) | 22 | 48 |
| Material and labour cost (Sh./unit) | 14 | 37 |
| Maximum possible production and sale (units) | 30 | 50 |
| Hours required per unit of product | ||
| Department | "Alkon" | "Zenon" |
| Assembly | 2 | 3 |
| Finishing | 4 | 2 |
| Packaging | 5 | 3 |
| Resource | Product 1 | Product 2 | Product 3 | Product 4 |
| Raw materials (units) | 2 | 3 | 4 | 7 |
| Labour hours | 3 | 4 | 5 | 6 |
| Sales price (Sh.) | 4 | 6 | 7 | 8 |
| ОBJЕCТIVE FUNCTION VALUE
1) 6650.0000 | ||
| VARIABLE | VALUE | REDUCED COST |
| X1 X2 X3 X4 | .000000 400.000000 150.000000 400.000000 | 1.000000 .000000 .000000 .000000 |
| ROW | SLACK OR SURPLUS | DUAL PRICES |
| 2) 3) 4) 5) | 0.000000 0.000000 0.000000 250.000000 | 3.000000 -2.000000 1.000000 .000000 |
| NO. ITERATIONS 4 | ||
| RANGES IN WHICH BASIS IS UNCHANGED |
| ОВJЕСTIVE COEFFICIENT RANGES | |||
| VARIABLE | CURRENT COEFF | ALLOWABLE INCREASE | ALLOWABLE DECREASE |
| X1 | 4.000000 | 1.000000 | Infinity |
| X2 | 6.000000 | 0.66667 | .500000 |
| X3 | 7.000000 | 1.000000 | .500000 |
| X4 | 8.000000 | 2.000000 | Infinity |
| RIGHT-HAND SIDE RANGES |
| ОВJЕСTIVE COEFFICIENT RANGES | |||
| VARIABLE | CURRENT RHS | ALLOWABLE INCREASE | ALLOWABLE DECREASE |
| 2) | 950.000000 | 50.000000 | 100.000000 |
| 3) | 400.000000 | 37.000000 | 125.000000 |
| 4) | 4600.000000 | 250.000000 | 150.000000 |
| 5) | 5000.000000 | Infinity | 250.000000 |
| Topics | ||||
| T1 | T2 | T3 | ||
| Lecturers | L1 L2 L3 L4 | 42 48 50 58 | 16 40 18 38 | 27 25 36 60 |
| Product | ||||
| X | Y | |||
| Sh. | Sh. | Sh. | Sh. | |
| Selling price | 400 | 360 | ||
| Variable costs: | ||||
| Material B (Sh.20 per kg) | 80 | 80 | ||
| Direct labour (Sh.16 per hour) | 64 | 32 | ||
| Packing (Sh.24 per hour) | 24 | 48 | ||
| Other variables | 152 | (320) | 140 | (300) |
| Fixed overhead (Sh.14 per hour direct labour) | (56) | (28) | ||
| Standard profit | 24 | 32 | ||
| Raw material | Maximum quantity | Quantity required per unit of production | |
| (units) | Product X | Product Y | |
| RM1 | 27 | 3 | 0 |
| RM2 | 30 | 0 | 2 |
| RM3 | 20 | 1 | 1 |
| \(C_1\) | \(C_2\) | ||
| Maximum sales (units) | 8,000 | 12,000 | |
| Selling price (Sh.) | 1,000 | 900 | |
| Machine time (hours): | X | 0.5 | 0.3 |
| Y | 0.4 | 0.45 |
| Variable | Value | Reduced Values | Objective coefficient | All increase | All decrease |
| \(C_1\) | 4,250 | 0 | 555 | 261.70 | 65.00 |
| \(C_2\) | 4,250 | 0 | 490 | 65.00 | 157.00 |
| Constraints | Value | Shadow Price | Right hand side constraint | Allowable increase | Allowable decrease |
| Plastic waste | 34,000 | 98,125 | 34,000 | 1,733.33 | 6,800 |
| Machine X | 3,400 | 325,000 | 3,400 | 850 | 850 |
| Machine Y | 3,612.5 | 0 | 3,800 | - | 227.5 |
| Fuel per litre | Crude oil (litres) | Furnace time (hours) | Mixer (litres) |
| Diesel (Refinery I) | 3 | 2 | 8 |
| Petrol (Refinery I) | 1 | 1 | 6 |
| Diesel (Refinery II) | 3 | 1 | 7 |
| Petrol (Refinery II) | 2 | 1 | 5 |
|
Milling plant
Eldoret Nanyuki Narok |
Monthly output (units) 30,000 12,000 28,000 |
Unit production cost (Sh.) 96 100 104 |
|
Distribution office
Mombasa Kisumu Nairobi Isiolo |
Monthly demand (units)
20,000 24,000 30,000 18,000 |
| To | |||||
| From |
Eldoret Nanyuki Narok |
Mombasa
64 56 58 |
Kisumu
36 52 42 |
Nairobi
52 44 36 |
Isiolo
58 32 50 |
| To | |||||
| From |
Nakuru Meru |
Mombasa
60 62 |
Kisumu
46 56 |
Nairobi
40 46 |
Isiolo
52 28 |
Production Light Dark | Selling price (Sh.) per litre 13.00 16.00 | Unit variable cost (Sh.) per litre 9.00 10.00 |