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 ...

    • Franpos EDI: Walkthrough

      In this article, you will learn how to setup EDI for supported vendors (electronic ordering and invoicing), submit and receive the Purchase Order using EDI. List of currently supported Vendors/Distributors: Burgham Southeast Pet Sunburst Trueman ...

    • 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 ...