Answered step by step
Verified Expert Solution
Question
1 Approved Answer
421 (a) Formulate a linear programming model for this problem. C (b) Use Excel to solve the problem. C (c) Use another software option to
421 (a) Formulate a linear programming model for this problem. C (b) Use Excel to solve the problem. C (c) Use another software option to solve the problem. 3240 10.8-5. The Lockhead Aircraft Co. is ready to begin a project to develop a new fighter airplane for the U.S. Air Force. The com- pany's contract with the Department of Defense calls for project completion within 92 weeks, with penalties imposed for late delivery. The project involves 10 activities (labeled A, B, . . . , J), where their precedence relationships are shown in the project net- work below. endZooin bins added tromeo unitare A woods beisqaidw ban vonT ecannoalone eggallow simonogs sboy vloildug and A smoo Syed 23593 boj DRA buyon START FINISH H E Insimilesvil lod Management would like to avoid the hefty penalties for miss- ing the deadline in the current contract. Therefore, the decision has been made to crash the project, using the CPM method of time-cost trade-offs to determine how to do this in the most economical way. The data needed to apply this method are given next. Normal Crash Normal Crash Activity Time Time Cost Cost 32 weeks 28 weeks $160 million 180 million 28 weeks 125 million 146 million no D 25 weeks 36 weeks 31 weeks 170 million 210 million 16 weeks 13 weeks 60 million 72 million 32 weeks 27 weeks 135 million 160 million 54 weeks 47 weeks 215 million 257 million 17 weeks 15 weeks 90 million 96 million 20 weeks 17 weeks 120 million 132 million 34 weeks 30 weeks 190 million 226 million 18 weeks 16 weeks 80 million 84 million a) Formulate a linear programming model for this problem. (b) Use Excel to solve the problem. (c) Use another software option to solve the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started