Skip to main content
EOQ & ROP Calculation
Ranking Table
- Product Ranking Table for Corporate and by Branch including required Turns and Safety Stock Factor based on Annual Sales Dollars or Units.
- Use of dollars or units determined by billing parameter setting.
Purchasing Parameters
- Default Timer for new product added
- Weeks Active
- Number of Weeks with Activity
- Weighting Weeks
- EOQ and ROP rounding
- ROP and EOQ corporate or store
- Use Demand Smoothing
- Internal Review
- ROP/EOQ Use – DC or Corporate
- Branch Replenishment from DC – B/S/N
Ranking Calculation
- Ranking calculated based on Unit Sales or Dollar Sales according to Billing Parameter setting screen 4 – Sales Rank Basis (U/$)
- Run once for all locations
- Calculate Active Weeks from first receipt date to current date
- Ignore items without a first receipt date
- Calculate sales value by week for weighting weeks using invoice costing based on billing parameter setting, screen 2 invoice costing Average or Last (P6)
- Sum these values and the rank will set when the total sales value is less than the next value in the rank parameters.
- The sum of the sales value for all branches is used to calculate the corporate sales rank
Calculate EOQ Values
- This is done for each branch separately
- Age Week Sales
- If Reorder Allowed = N, S or K do nothing
- If Reorder Lock not 0 do nothing
- Calculate the Active Weeks
- Only done for products that have a first receipt date
- Active weeks from First Receipt to current
- If the Active Weeks is > Weeks Active parameter use the parameter value
- If the Active Weeks is 0 do nothing
- Calculate Annual Unit Sales = previous 52 weeks sales.
- If Active weeks is < 52 calculate annual units as sum of previous 52 weeks * 52 / Active Weeks.
- Weeks with Activity = Weeks in Active Weeks that have sales not = 0
- If Weeks with Activity < Number of Weeks with Activity move zero to Vendor and Transfer EOQ
- Assign the EOQ
- Based on the ranking parameter for the part divide the annual unit sales by the turns parameter giving the EOQ Vendor and Transfer.
Calculate Lead Time by Part
- Use the number of receiving’s set on the supplier record. If blank or 0 then default of 8 is used
- Calculate the average lead time for the most recent number receiving’s of the part.
- Compare the average lead time to the highest number of days and add the lower of the difference or 25% of the average lead time.
Calculate ROP Values
- Use DC lead time from branch record.
- If Lock value = 99 do nothing
- Does not use RANK-CUTOFF value
- Reduce the lock value by 1
- Calculate active weeks from first receipt date to current date
- Sum the sales units for the Weighting weeks.
- Compute the daily sales = total sales by week / (weighting weeks * 6). It was decided early on that only 6 business days per week should be used for the daily sales calculation.
- Using the sales ranking and lead time for the part calculate the Vendor ROP. Daily Sales * (Lead Time + Internal Review Time). Round this value based on Purchasing Paramenter settings. Add safety stock percentage and round again.
- Calculate the DC ROP value as Daily Sales * DC Lead Time, then round based on purchasing parameter setting. Add safety stock percentage and round again.
Calculate Corporate Values
- Add the Vendor EOQ for all locations and put the total as the Corporate EOQ
- Add the Vendor ROP for all locations and put the total as the Corporate ROP
Daily Suggested Order
- The daily suggested order calculation can be based the DC or Corporate ROP/EOQ
- Recalculates for all parts each day with the exception of parts on outstanding suggested orders where the order quantity has been modified and not ordered yet.
- Suggested order will buy direct to branch based on supplier setting
- Do not order product set as N for reorder allowed unless there is a customer backorder.
- DC available quantity for replenishment to branches calculated based parameter Branch Replenishment from DC.
- Transfers it the quantity available is equal to or less than the ROP DC order the DC EOQ – Qty Available + ROP DC base on DC Available Quantity. Use branch purchase quantity for transfers
- Corporate Vendor Orders compare the DC available quantity to the Corporate ROP and order when the available is less that the corporate ROP