Share
Report
35Hi!
A bit of background info:
We have a supermarket kind of warehouse that has over 1500 products including fruit and vegetables. Every week we see a slight increase in our sales, but the items that are sold can be different based on season but also weather. We order from different vendors at least every week.
Problem:
We want to use requisition worksheets to calculate what we have to order per vendor per location. We have set up our items with a 'Fixed reorder point' so we know when it goes below that point we have to order it. But as our demand is growing this Fixed order point is changing every week. Is it possible to have BC look back to our historical data and figure out that we'll sell more or less in the upcoming weeks? (We have the 'Sales and Inventory Forecast' set up, but it on pretty much all our items says 'variance too high'). But then also have it automatically put in the Demand Forecast so we can take that in account for our Requisition Worksheet?
Side Question:
For fruit and vegetables we see that we sell more on Mondays and Tuesdays then other days for example. We order fruit and veg every day, but we'd like BC to tell us what to put on the PO's. How can we specify that the ordering has to be more/less based on the day of the week. Is it possible to perhaps have a demand forecast per day for fruit and veg, but do weekly for the other items?
All responses (
Answers (
