Posted: June 18th, 2021
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)=2100$
Place an order in 3 easy steps. Takes less than 5 mins.