Reconsider the Lockhead Aircraft Co. problem presented in Problem 16.15 regarding a project to develop a new fighter airplane for the U.S. Air Force. Management is extremely concerned that current plans for this project have a substantial likelihood (roughly a probability of 0.5) of missing the deadline imposed in the Department of Defense contract to finish within 100 weeks. The company has a bad record of missing deadlines, and management is worried that doing so again would jeopardize obtaining future contracts for defense work. Furthermore, management would like to avoid the hefty penalties for missing 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 is given below. These normal times are the rounded estimates of the means obtained from the original data in Problem 16.15. The corresponding mean critical path provides an estimate that the project will finish in 100 weeks. However, management understands well that the high variability of activity durations means that the actual duration of the project may be much longer. Therefore, the decision is made to require that the estimated project duration based on means (as used throughout the CPM analysis) must not exceed 92 weeks. Formulate and solve a spreadsheet model that fits linear programming for this problem.

r