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 B C D E F G Event Time Constraint xdA x xdC x xdB x xdD x xdE x xdF x xdG x For, Formulate a linear programming model in Excel and output activity start times that minimize the project's duration given a particular budget 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 $
Please create an LP model to answer the following questions.
a If there is a budget of $ for the banquet, how quickly can the project be finished?
b If the project has already been advertised for a date weeks from now, how
inexpensively can the project be completed?
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
