Requisition Worksheet/Planning Calculation

Jonathan2708

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

i4tost

Hi,

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?

Jonathan2708

Hi,

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

i4tost

what dates you placed when calculated?

Jonathan2708

Order Date : 23/04/2008
Ending Date : 31/12/2008
Use Forecast : 2008
Exclude Forecast Before : <Blank>

i4tost

Have you any sales that are already posted?

Jonathan2708

Yes the item has invoiced sales as follows :

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