Answered step by step
Verified Expert Solution
Link Copied!

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?

image text in transcribed

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?

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions