Purchase Order ( PO ) Forecasting

Purchase Order ( PO ) Forecasting

Purchase Order ( PO ) Forecasting

PO Forecasting uses a pre-defined formula for calculating the Forecasted Reorder Quantity (FRQ). 

The formula uses two variables (Evaluated Period and Forecasted Period, both in # of DAYS) which user will need to supply the value every time PO is created.

Formula:  ( Unit Sales from (Evaluated Period) * ( (Forecasted Period) / (Evaluated Period) ) ) – (On hand Quantity) = Forecasted Reorder Quantity.

Example:
Evaluated Period = 56 days
Unit Sales from Evaluated Period (calculated) = 50 units
Forecasted Period = 21 days
On hand Quantity = 12 units.

( Unit Sales from (EP) * ( (FP) / (EP) ) ) – (OH) = FRQ
( 50 * (21/56) ) – 12 = 6.75 --------- Round up ------> 7

7 is now the reorder quantity for this item.

    • Related Articles

    • Purchase order

      This tool can create and track both purchase orders and stock transfers to other locations. Upon receiving products with this tool, the amount will be added to on-hand quantity. Catalog >> Inventory management >> purchase order Add Purchase order ...

    • Delete Purchase order

      If you wish to delete a completed PO / ST, please follow these steps: Navigate to my.franpos.com -> Catalog -> Purchase Order. https://my.franpos.com/PurchaseOrder Search for the PO / ST that you wish to delete. Click on the trash can icon next to ...

    • Create a PO with stock units

      Creating a purchase order for stock units is similar to creating any other purchase order. Setup In order for the stock unit to be ordered in a PO, we need to associate the stock unit with a product. Please follow the steps below: Follow the guide on ...

    • Cancel Online Order and Subscription

      Cancel Online Order and Subscription This article helps you learn how to Cancel/Refund an Online and subscriptions orders. Any Online order for pickup/shipping/delivery will have Cancel Option Any Renewal subscription for Pick Up/Shipping/Delivery ...

    • eCommerce Order Fulfillment

      In this training, you will learn how to configure your register to receive online order tickets. On your register navigate to Settings >> eCommerce 1. Enable Receive ecommerce orders on this device to be notified with online order tickets. 2. Make ...