Requisition Worksheet/Planning Calculation

Jonathan2708Jonathan2708 Member Posts: 552
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

Comments

  • i4tosti4tost Member Posts: 208
    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?
  • Jonathan2708Jonathan2708 Member Posts: 552
    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
  • i4tosti4tost Member Posts: 208
    what dates you placed when calculated?
  • Jonathan2708Jonathan2708 Member Posts: 552
    Order Date : 23/04/2008
    Ending Date : 31/12/2008
    Use Forecast : 2008
    Exclude Forecast Before : <Blank>
  • i4tosti4tost Member Posts: 208
    Have you any sales that are already posted?
  • Jonathan2708Jonathan2708 Member Posts: 552
    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
Sign In or Register to comment.