Given the project details below, develop response to the following questions using Linear

Programming to develop the formulation $($list of variables, constraints etc.$),$ and implement

in excel for solution using the Simplex method provided through the solver.

a$.$ Upon sketching the network diagram, list the set of constraints and their contents for

the problem. Use the constraints and formulate the linear programming problem by

updating the excel file.

b$.$ Determine the shortest period by minimizing the project duration $($not the crash cost$)!$

c$.$ Determine the shortest period to minimize the project total cost of project $($which

includes the total normal direct cost of tasks prior to crash, the cost due to crashing

activities, and the total indirect cost due to $$800/$week rate of indirect cost to be

applied to the duration of the project$).$

d$.$ Determine the minimal total cost when you introduce a constraint that project

duration needs to be less than or equal to project desired deadline, and tabulate the

values of total project cost corresponding to deadline durations of: $40,39,38,37,36,$

$35,34,33,32,31$ and $30$ weeks, while recording the activities that are crashed and

their durations to achieve each listed deadline.