Consider the EOQ Model for Multiple Products That Are Independent

question 51

Essay

Consider the EOQ model for multiple products that are independent except for a budget restriction. The following model describes this situation:
Let Dk = annual demand for product k
Ck = unit cost of product k
Sk = cost per order placed for product k
i = inventory carrying charge as a percentage of the cost per unit
B = the maximum amount of investment in goods
N = number of products
The decision variables are Qk, the amount of product k to order. The model is:

s.t.


a. Set up a spreadsheet model and for the following data:

b. Solve the problem using Excel Solver. (Hint: For Solver to find a solution, you need to start with decision variable values that are greater than 0.)

---

Definitions:

Halfway Houses

Living facilities that offer people with long-term mental health problems the opportunity to live in a structured, supportive environment while they are trying to reestablish employment and ties to family and friends.

Community-Based

Approaches or activities that are rooted in and directly involved with the local community, often emphasizing local participation and benefits.

Mental Health Problems

A wide range of conditions that affect mood, thinking, and behavior, leading to distress or impairment in daily functioning.

Incarcerated Inmates

Individuals who are held in a prison or jail as punishment for crimes they have been convicted of committing.