(A) Determine How to Minimize the Total Cost of Meeting

question 14

Essay

(A) Determine how to minimize the total cost of meeting the next 3 quarters' demand. Assume that 1000 usable units are available at the beginning of quarter 1.
​
(B) Referring to (A), the company wants to know how much money it would be worth to decrease the percentage of unsuitable items and/or the percentage of items that spoil. Write a short report that provides relevant information. Base your report on two uses of the SolverTable add-in: one where the percentage of unsuitable items decreases and the percentage of items that spoil stays at 10%; and one where the percentage of unsuitable items stays at 20% and the percentage of items that spoil decreases.

---

Definitions:

Zero Price

A situation where a product or service is offered to consumers at no cost, often as a part of a promotional strategy or business model.

Demand Curve

A graph showing the relationship between the price of a product and the quantity of the product that consumers are willing to purchase.

Loanable Funds

The total resources or funds available for borrowing in the financial markets, encompassing both savings and any additional credit provided by banks.

Interest Rate

The proportion of a loan that is charged as interest to the borrower, typically expressed as an annual percentage of the loan amount.