Question: Hello, I need help creating a linear programming model for solver in excel using this data below. Please post screenshots of excel on how this
Hello, I need help creating a linear programming model for solver in excel using this data below. Please post screenshots of excel on how this was achieved for Solver.
Develop a linear programming model for minimizing the cost for crashing

The objective function would be to minimize the cost of crashing so that the project can be completed in 38 weeks instead of 43 weeks.


Activitiy Expected Time Crashed Activity Time (weeks) A 6 4 B 9 7 4 2 NININ D 12 8 E 10 Normal 1,000 1,000 1,500 2,000 5,000 3,000 8,000 5,000 10,000 4,000 5,000 Crashed 1,900 1,800 2,700 3,200 8,000 4,100 10,250 6,400 12,400 4,400 5,500 7 4 5 4 Time Difference Cost of Crash Cost of crash per week 2 $ 900.00 $ 450.00 2 $ 800.00 $ 400,00 2 $ 1,200.00 600.00 4 $ 1,200.00 $ 300.00 3 $ 3,000.00 $ 1,000.00 2 $ 1,100.00 $ 550.00 3 $ 2,250.00 750.00 2 $ 1,400.00 $ 700.00 3 $ 2,400.00 $ 800.00 1 $ 400.00 S 400.00 1 $ 500.00 $ 500.00 F 6 G 8 H 6 I 7 3 J 4 4 3 3 K 4 $ Optimistic Pessimistic variance Most probable 6 Expected time 6 A 4 8 6 8 16 B D 9 4 2 4 6 0.4444 2.7778 0.4444 7.1111 1 8 10 24 12 E 7 10 13 10 4 8 F G H 6 6 0.4444 7.1111 4 20 8 4 6 8 6 0.4444 I 4 6 7 4 2.7778 0.1111 J 14 5 6 3 4 K 2 4 4 0.4444 G|1321 Alol6 8 21291 639 START |C | 9|||| p|13125| JH29155| | 5559 4 913 (12|1729N6 2935 435|39 (K5943 FINISH 4 3943 B 09 909 E| 13123| F2329| 101323 62329 1 2936 7 32 39 The critical activities are B, C, E, F, H, J and K. The critical path is BCEFHJK
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
