Calculate ROQ for Profitable Investment Buys (ibcalc)
Module Name |
ibcalc.pc |
Description |
Calculate ROQ for Profitable Investment Buys |
Functional Area |
Replenishment |
Module Type |
Business Processing |
Module Technology |
ProC |
Catalog ID |
RMS249 |
Wrapper Script |
rmswrap_multi.ksh |
Design Overview
The batch program is the calculation engine for investment buy processing. It identifies investment buy (IB) opportunities and calculates recommended order quantities (ROQs) that will meet the target return-on-investment (ROI)
This module will calculate forward buy opportunities using:
-
Carrying costs
-
Ordering parameters
-
Deals – future and expiring
-
Cost changes – future
-
Forecasts
-
Inventory levels
-
Target ROI (return on investment)
The deals and cost change components will be contained on the future cost table. This table will hold a record for each future date that has a costing event (for example, a cost change, deal activation/deactivation). This process utilizes the default costing bracket and default deal thresholds in the calculations.
The pre-processing for this batch in the prepost program sets the status of investment buy from 'W' (worksheet) to 'U' (unprocessed).