Hire

.lt

Tiklso link

Need Supply Chain Expert to Explain Ordering Quantity Formula - Upwork

Būsena UŽDARYTA
Biudžetas 501-1000 Eur
Sukurta: 2018-06-16
Baigiasi: 2018-06-23
Siūlo: Nėra
Apibūdinimas: Hello,


We have developed a spreadsheet that allows us to input daily consumption, inventory on hand and then based on # of days of cushion, # of days of turnaround and days between deliveries, it will predict how much product should be ordered to ensure they do not run out of inventory before their next shipment and maintains a cushion at their store.  


The problem we are running into is when we test the equation on what to order on a calendar, it does not work.  I'd like to speak with someone that can explain to me the equation we need to use to figure out how much to order based on the days of cushion and order frequency (Weekly, monthly, etc).


Our current formula:


Order Quantity Formula = if I<R then D*(T+O+C)-I


R = Reorder Point

I = On Hand Inventory

D = Daily Sales

T =  Days it takes to Turnaround

O = # of days between deliveries

C = Days of Cushion

Budget: $25

Posted On: June 16, 2018 04:00 UTC
Category: Data Science & Analytics > Other - Data Science & Analytics

Skills: Supply Chain Management
Location Requirement: Only freelancers located in the United States may apply.

Country: United States
click to apply

Darbo Tipas(ai):
  • PHP
  • CSS
Duomenų Bazė:
Operacinė Sistema: Linux
Siūlymų Skaičius: 0
Siūlosi Žinutės Kaina Trukmė Įvertinimas Informacija