P
Pam
I am doing a creating an inventory reorder spreadsheet for
import products for my business class. I have the read
through old posting but I am having trouble with getting
a "normal" reorder quantity. Can anyone help me. I am
using Excel 2000.
Thanks,
Sales: (monthly)
EOM Inventory:
Safety Stock: average sales last year by quarter*10%*2
(months)
On Order: Product already ordered but not received yet.
Available Stock: Safety stock - EOM Inventory
ASD (3MO): Ave Sales per day for last three months.
Lead Times: 75 (order place and arrived at destination
Safety Days: # of days until the inventory is below the
safety level based upon rates of sale(ASD)
Safety Run Out: The date this will happen
Days to hold: # of days beyond the safety stock to see
stock held (15)
Reorder Point: # of items to order
import products for my business class. I have the read
through old posting but I am having trouble with getting
a "normal" reorder quantity. Can anyone help me. I am
using Excel 2000.
Thanks,
Sales: (monthly)
EOM Inventory:
Safety Stock: average sales last year by quarter*10%*2
(months)
On Order: Product already ordered but not received yet.
Available Stock: Safety stock - EOM Inventory
ASD (3MO): Ave Sales per day for last three months.
Lead Times: 75 (order place and arrived at destination
Safety Days: # of days until the inventory is below the
safety level based upon rates of sale(ASD)
Safety Run Out: The date this will happen
Days to hold: # of days beyond the safety stock to see
stock held (15)
Reorder Point: # of items to order