Explore BrainMass

Optimization with Excel Solver

I need help with the excel solver for this minimization problem. Please take a look at it and let me know if you can help me with the solver. I have included the objective and the constraints.


Solution Preview

Dear Student:

Please open the attached Excel file with the Excel Solver solution and then follow the instructive explanations below:

Excel Worksheets: Excel Solver (includes the solution) and Answer Report (includes Excel Solver Report)

Column A: Activities A-K
Column B: Original Expected Time
Column C: Crash Time (this is the y-variable in the Excel Solver solution)
Column D: Crash Cost (crash cost for each activity is obtained from the objective function)
Column E: Crash Cost * Crash Time = Total crash cost for each activity (the sum of these costs in cell E17 is the total cost, which we are trying to minimize)
Column F: New Early Start (is the earliest start using the crashed activities time)
Column G: New Early Finish (is the earliest finish using the crashed activities time; this information is the x-variable in the Excel Solver solution)
Column ...

Solution Summary

Optimization with Excel Solvers are examined.