Description |
*Scenario:*
* Raw Corn is used to produce:
** Corn-Starch with 80% cost allocation
** Fiber with 15% cost allocation
** Gluten with 5% cost allocation
* and Corn-Starch is used to produce
** Ethanol with 60% cost allocation
** High Fructose Corn Syrup with 40% cost allocation.
* Let's say $100 is adjusted for Raw Corn. It will distribute and escalate the cost adjustment like this:
** Corn-Starch = $80 (80% of $100)
*** Ethanol = $48 (60% of $80)
*** and High Fructose Corn Syrup = $32 (40% of $80)
** Fiber = $15 (15% of $100)
** Gluten = $5 (5% of $100)
*Expected:*
* Provide a new sql fn where it will return a table-matrix of the cost allocation.
** *Expected inputs:* *** Work Order Id (ex: WO-185)
*** Item Id (Consume item) (ex: #2 Yellow soybeans)
** *Expected output - table-valued function*
*** Item (Produce item or items)
*** % of the allocation
* The new fn will be used by {{uspICPostCostAdjustmentEscalate}}
!pastedImage_d110735_0.png!
|