Hi,
I'm trying to prove in my head the quantity the requisition worksheet is suggesting to purchase, but I can't quite reconcile it. The details are :
Inventory : 10605
On Sales Order (730) :
18/03/08 1
19/03/08 2
25/03/08 1
03/04/08 1
17/04/08 720
18/04/08 2
22/04/08 2
23/04/08 1
April Forecast : 2800
May Forecast : 3000
June Forecast : 4500
July Forecast : 2800
The planning parameters are simply Lot-for-Lot, reorder cycle 2W and nothing else.
The requisition worksheet is suggesting a quantity of 2209 to be delivered for 1st July. But by my workings :
10605 - 4 (March orders) - 2800 (April) - 3000 (May) - 4500 (June) = 301 Which would mean a quantity of 2499 would be required to meet the forecast for July of 2800.
Can anybody shed a light on where I'm going wrong.
Many thanks,
Jonathan
0
Comments
what situation of purchase, production and transfer orders?
do you use only one location? are all info for this location?
have you set up of stockkeeping unit?
This is a very basic scenario :
- The item is only ever purchased, no production orders, no transfer orders
- Yes all demand and inventory is based at one location only
- Stockkeeping units are not used
Thanks,
Jonathan
Ending Date : 31/12/2008
Use Forecast : 2008
Exclude Forecast Before : <Blank>
04/03/08 240
05/03/08 1
10/03/08 289
13/03/08 3
17/03/08 971
19/03/08 1
01/04/08 2
10/04/08 288
Ah, the invoiced sales for April (2 + 288) = 290 which is the difference between my calc and the suggested amount (2449 - 2209) = 290!
Many thanks for your help
Jonathan