Explore BrainMass

Explore BrainMass

    Optimization with Excel Solver

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 2, 2020, 4:26 am ad1c9bdddf


    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.