With Delivrd’s ATP, you can predict stock shortages in the future and expected future spend, based on a demand forecast and actual purchase order data. It will show available stock in the future, by each month, starting from the current month.
To view the ATP, go to the Products page and click the ... button under Actions next to the product that you are going to check, and then select ATP.
The report displays the ATP vector by month, receipts, demand, and ATP.
- Month: The month for which you are going to calculate the ATP.
- Receipts: The number of open future receipts for the current month. To view the receipts, click this number in the column.
Note: To display receipts in the ATP report, you need to specify the Estimated Delivery Date in the order header and then release the order.
Please also note that ATP also uses the delivery date from purchase order lines, which can be different from the estimated delivery date in the header. You can specify the delivery date either in the order header or lines. The date in the lines is more strong, so if both header and line date exist, the system considers only the line date.
- Demand: Enter the expected demand in the corresponding field.
- ATP: The ATP is calculated automatically according to this formula: last month ATP + current month receipts - current month demand.
- Expected Spend: Amount that is expected to be spent during the month.
- Total Value: Total value of the order lines.
The ATP of the first month (current month) is the current inventory in all inventory locations minus the demand. It should be the partial quantity from the current day of the month until the end of this month. If we are exactly in the middle of the month (15th), and the forecast is 20, then the demand for the current month should show 10 + the number of open future receipts for this month (expected delivery date is later than today). Here is an example:
- Month: 12/18
- Receipts: 30
- Demand: 20
- Current stock in all locations: 120
Based on this data, the ATP will be (120-18+30)=132.