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 Settings

      This article provides a detailed explanation of all available Purchase Order (PO) settings and how each option affects purchasing, receiving, and inventory workflows. Enable Scanning on Receive Allows you to receive items on a Purchase Order using a ...

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

    • Purchase Orders - Create Purchase Orders for All Stores in Bulk

      In this article, we will explain how you can create multiple Purchase Orders for multiple stores in one bulk workflow. This eliminates the need to switch between individual stores and repeat the same process multiple times (for example, when creating ...