Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What is the best way to meet the expedited request of 26 weeks? Original Problem - I completed for min cost to crash using solver,
What is the best way to meet the expedited request of 26 weeks?
Original Problem - I completed for min cost to crash using solver, came up with $195,000. 1st picture is problem and 2nd picture is after running solver. I am just not sure how to answer What is the best way to meet the expedited request of 26 weeks?
Here is where I am after running Solver. I need to solve for Question 1 - What is the best way to meet the expedited request of 26 weeks?
Earth Mover Project "Current project has a critical path of 30 weeks. You must complete the job by at least week 26!" NORMAL CRASH Activity A Time (weeks) 6 Best Time (weeks) 5 Crash Cost ($/week) 15,000 un B 4 4 3 2 $ D 6 Activity Crash Cost Time reduction ($) (weeks) $ 15,000 1 $ 0 $ 50,000 1 $ 150,000 3 $ 70,000 1 $ 180,000 3 $ 0 $ 350,000 1 $ 300,000 4 Cost $ 80,000 $ 100,000 $ 50,000 $ 150,000 $ 180,000 $ 300,000 $ 100,000 $ 450,000 $ 350,000 3 Nm NN .. 50,000 50,000 70,000 60,000 E TIM 3 10 F 2 7 2 $ U I i N 2 6 UN H 5 4 350,000 75,000 8 $ Goal to complete by: 30 weeks Change this goal from the current 30 weeks to the new 26 week target! Objective Function Min cost to CRASH S Then run SOLVER to find the least expensive way to reach your goal !!!Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started