MYOB Greentree

HideShow

  • Contents
  • Index
  • Search
 
Display results with all search words

 

Sales Orders Plus Forecast


This calculation process applies to Sales Orders Plus Forecast demand generation:

  1. Determine the demand time fence:

    Calculate total gross requirements, by inventory item by date, as the quantity remaining greater than zero of all sales order line items with a delivery date less than or equal to, the demand time fence.

  2. Determine the end date.
  3. For each forecast period after the demand time fence and up to and including the end date:
    • Total, by inventory item by date, the quantity remaining greater than zero of all sales order line items with a delivery date greater than the demand time fence and less than or equal to the forecast period end date.
    • Total, by inventory item by date, the forecast quantity.
    • Create gross requirements as the sum of both sales order line item quantities and the forecast quantity.

Example

 

21/12/17

31/12/17

Time Fence

01/01/18

05/01/18

 

10/01/18

 

20/01/18

21/01/18

Forecast

 

 

 

<--------------------------------- 500 --------------------------------->

 

 

 

Sales Orders

15

75

 

40

50

 

100

 

200

 

 

 

 

Gross Req. ex Sales Orders

15

75

 

40

50

 

100

 

200

 

 

 

 

Gross Req. ex Forecast

 

 

 

500

 

 

 

 

 

 

 

 

 

Total Gross Requirements

15

75

 

540

50

 

100

 

200