Use Excel or Another Technology to Solve the Following Optimization

question 88

Multiple Choice

Use Excel or another technology to solve the following optimization problem. Minimize subject to

• A)Minimum is 10,100 at
• B)Minimum is 9,100 at
• C)Minimum is 9,000 at
• D)Minimum is 10,000 at
• E)Minimum is 5,000 at

---

Definitions:

Opportunity Cost

The cost associated with not choosing the next best alternative when making a decision, representing the benefits one could have received by taking an alternative action.

Alternative Use

The value or potential benefit that is foregone as a result of using an asset or resource in a particular way instead of another possible way.

Sunk Costs

are past expenses that have already been incurred and cannot be recovered or changed, and thus should not affect future business decisions.

Avoidable Costs

Expenses that can be eliminated if a particular decision is made, not incurred in the absence of the decision.