Discuss on Inventory Management

I’m stuck with proposing an LP model for this problem can u please walk me through developing the model “formulas for this”

A Retailer is facing the following yearly deterministic (demand are known in advance) demand for a given product sold a price of p=30 $/unit.

Month       1     2   3      4     5   6     7   8      9  10      11 12

Demand   120 65  220 10   0  150  60 100  0   200   50   20

 

The retailer is making the replenishment from a local supplier who sells the items at a per-unit cost of c=20$. Moreover, whenever the retailer makes an order from the supplier, he should pay a fixed transportation cost of 100 $ ( regardless of the quantity carried).

❑In addition to the purchasing cost and transportation cost, the store is also carrying a holding cost of h=0.20$/ unit/ month.

Assume the following

❑The amount of items held for one month is simplified as to leftover at the end of the month Max (Available Quantity at the beginning of the month -Demand), 0)

❑Assume that there is no Lead Time, if you order at any day you get your items same day

❑Retailer cannot make more than one order per month

❑Retailer must satisfy all the demand

the retailer wants to find the best replenishment strategy (When and How Much To order) to meet all demands at the minimum cost /highest profit.

To understand the cost dynamics consider the following example:

• If the retailer orders 200 units at month 1. The associated costs are as follows: Transportation Cost (100)+ Purchasing Cost (200*20=4000) +
• Holding Cost ( Leftover=(200-120)*0.2=80*0.2=16)=4016$
• If the retailer orders 100 units at month 1. The associated costs are as follows: Transportation Cost (100)+ Purchasing Cost (100*20=2000) + Holding Cost ( Leftover=(0)*0.2=0)=2100I’m stuck with proposing an LP model for this problem can u please walk me through developing the model “formulas for this”

  A Retailer is facing the following yearly deterministic (demand are known in advance) demand for a given product sold a price of p=30 $/unit.

  Month       1     2   3      4     5   6     7   8      9  10      11 12

  Demand   120 65  220 10   0  150  60 100  0   200   50   20

   

  The retailer is making the replenishment from a local supplier who sells the items at a per-unit cost of c=20$. Moreover, whenever the retailer makes an order from the supplier, he should pay a fixed transportation cost of 100 $ ( regardless of the quantity carried).

  ❑In addition to the purchasing cost and transportation cost, the store is also carrying a holding cost of h=0.20$/ unit/ month.

  Assume the following

  ❑The amount of items held for one month is simplified as to leftover at the end of the month Max (Available Quantity at the beginning of the month -Demand), 0)

  ❑Assume that there is no Lead Time, if you order at any day you get your items same day

  ❑Retailer cannot make more than one order per month

  ❑Retailer must satisfy all the demand

  the retailer wants to find the best replenishment strategy (When and How Much To order) to meet all demands at the minimum cost /highest profit.

  To understand the cost dynamics consider the following example:

  • If the retailer orders 200 units at month 1. The associated costs are as follows: Transportation Cost (100)+ Purchasing Cost (200*20=4000) +
  • Holding Cost ( Leftover=(200-120)*0.2=80*0.2=16)=4016$
  • If the retailer orders 100 units at month 1. The associated costs are as follows: Transportation Cost (100)+ Purchasing Cost (100*20=2000) + Holding Cost ( Leftover=(0)*0.2=0)=2100