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

Don't use plagiarized sources. Get Your Custom Essay on

Inventory management

Just from $13/Page

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.