Purchase Solution

Optimization with Excel Solver

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Summary

Optimization with Excel Solvers are examined.

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 ...

Purchase this Solution

Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

Change and Resistance within Organizations

This quiz intended to help students understand change and resistance in organizations

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.