Question: CAN YOU MAKE EXCEL FILE LIKE THIS? Decision Variable Activity Duration Cost objective function A 6 8 6 2 B 1 4 C 7 0

CAN YOU MAKE EXCEL FILE LIKE THIS?
Decision Variable Activity Duration Cost objective function A 6862 B 14 C 70 D 510 E 910 F 1220 G 3100 Event Time 000162737416528631 Constraint x(0)+dA 6=x(1) x(0)+dC 7=x(2) x(1)+dB 7=x(3) x(2)+dD 12=x(4) x(3)+dE 16=x(4) x(4)+dF 28=x(5) x(5)+dG 31=x(6) For, 1. Formulate a linear programming model in Excel and output (1) activity start times that minimize the project's duration given a particular budget (2) activity start times that minimize the project's cost given a particular project duration. Project information is shown in the table below. Times are in weeks. Costs are in $10,000.
Please create an LP model to answer the following questions.
(a) If there is a budget of $850,000 for the banquet, how quickly can the project be finished?
(b) If the project has already been advertised for a date 14 weeks from now, how
inexpensively can the project be completed?
CAN YOU MAKE EXCEL FILE LIKE THIS? Decision

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!