1 Topic by rini (edited by rini 03/21/2008 11:47:17 pm)

  • rini
  • Member
  • Offline
  • Registered: 03/21/2008
  • Posts: 13

Topic: Forecasting/Re-order/item deliverytimes

Hi

I've been testing FA for a few hours now and it basiclly does what i need so i dont need to contiue develop my own project further. hoorayy!! smile

1; Now, i our firm we sell items that have long deliverytimes, from 6 weeks to 3 month.
And cuz of this, we're in constant need of forecasting on a per daily, weekly and monthly routine.

Today we take the dalie sales and use the past 30/90 days to generate forecasting as per this:

(Current stock / (previous 30 days sales))
+
(Current stock / (prev 90 days)/3)
/2 = approx monthly sales

Manuel work today, but was going to be automated in my project.

Example: Stock = 1000 units, forecasting approx 300 units sold/month, when it drops to 900 (or equivalent weeks in forecasting vs deliverytime - 3month in this case) it would generate alertmail.

Example2: In the next few months sales increases, and when the stock is 1800 and projected sales are 500 per month, it would generate alert at 1500 (deliverytime 3 month).
---

2; Adding deliverytimes to items or items to be assemblyd so you can tie that in to expected re-ordering alerts.

--
Hope anyone understand my bad writings.

Regards,
Rikard