Question: [ text { Minimize } Z = x _ { 1 } + x _ { 2 } + x _ { 3

\[\text { Minimize } Z=x_{1}+x_{2}+x_{3}+x_{4}+x_{5}+x_{6}+x_{7}\] subject to: \[\begin{array}{l}\mathrm{x}_{2}-\mathrm{x}_{1}\geq 12\\\mathrm{x}_{3}-\mathrm{x}_{2}\geq 8\\\mathrm{x}_{4}-\mathrm{x}_{2}\geq 4\\\mathrm{x}_{4}-\mathrm{x}_{3}\geq 0\\\mathrm{x}_{5}-\mathrm{x}_{4}\geq 4\\\mathrm{x}_{6}-\mathrm{x}_{4}\geq 12\\\mathrm{x}_{6}-\mathrm{x}_{5}\geq 4\\\mathrm{x}_{7}-\mathrm{x}_{6}\geq 4\\\mathrm{x}_{\mathrm{i}},\mathrm{x}_{\mathrm{i}}\geq 0\end{array}\]
Please use Excel Solver to solve the following CPM/PERT Model Formation Example from the S14 lecture slides. Please submit an Excel file showing your work. Excel cells w/o formulas will result in a "0" on the assignment. You can skip the sensitivity analysis

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!