Laddawn.com : Functional Specs - MOD Price Calculation

This routine will be called by the web (results area) when it is known that a MOD item can be manufactured. It will also be called from 'saved items' and/or cart for repricing for quantity/zip code changes or when expired. This process determines the BOM, Routing, and MOD item price along with up to 3 price breaks. The new routine will also include pricing for Marketplace items, which is manufactured outside by a vendor. Marketplace items at this time only include Zip Tops. Eventually, there will be flags associated with this program to do the following:

First time price/bom/routing based on current resin prices
Re-price (due to qty change) using original resin prices (because quote is within 14 days of creation and hasn't expired yet)
Re-price using current resin prices (expired quote, ashad quote being created)
Price/Price Breaks Only (for results area)

At minimum, the following info will need to be passed along by this program for quote/configuration creation:

All BOM item number and quantities that will be needed to create this item
All routing information, including Operation#1 and Operation#2 details and Labor Info
All price details (Non-Material$, Material$, Shipping$, all Upcharge$)

The current MOD price calculation goes through the following steps in the order shown:

Quote Adj Pct from Avante (criteria 401):
1. Format: MD4
2. Default: Null
3. Validation: This is passed from Avante or the Web and is used for +/- quote price adjustment. No prompting. This is set based on billto customer or sales organization. See QUOS4000.3PS for logic that sets both the Quote Adj Pct and Preferred Pricing Flag.
Preferred Resin Price? (criteria 442):
1. If SLSORG.USR<16>=1 (pref pricing) and Custom Item not found in SLSORG.USR<17> (exception items), then Preferred Resin Price = Y (see QUOS4000.3PS)
Draw Length Table Name (criteria 396):
1. see Functional Specs - Shop for details
2. This is not needed for FURN
3. This is not needed for SOR or ROLLSHEET
4. This is not needed for ROLLTUBE
Minimum Length w/No Upcharge (criteria 398):
1. If not Sleeves and Construction=Bottomseal: From Draw Length Table, column MIN_NO_UPCHG, using Bubblesize
2. This is not needed for FURN
3. This is not needed for SOR or ROLLSHEET
4. This is not needed for ROLLTUBE
Assigns Mfg Facility (criteria 143) (CALL WEB.ASSIGN.MFGPLANT): based on destination zip code and each plants mfg capabilities:
1. Reads table MFG_PLANTS for the Primary, Secondary, Backup, and Last Mfg Plant assignment based on the destination zip code. Table is by range of zip codes. (criteria 296,297,298,448)
2. If micro-perforation job, Mfg Location is set to STERLING
3. If not a micro-perf job, EPCS9008.1 is executed to determine the closest plant that is capable of producing the product. EPCS9008.1 needs to know if the job is bottomseal or sideweld and which plants can produce the job with that seal. All of this information is available by calling WEB.BSEAL.SWELD.
4. SHEETING/ROLLSHEET/SOR have same rules
5. TUBING/ROLLTUBE have same rules
Exclude LLDPE? (criteria 283) - LLDPE is excluded under any of the following conditions:
1. If True Gaue > 6.00 and Width+Depth > 60.00 and and Mfg Facility = Sterling
2. If True Gauge > 5.00 and Width+Depth > 70.00 and Mfg Facility = Sterling
3. If True Gauge > 4.00 and Width+Depth > 80.00 and Mfg Facility = Sterling
4. If True Gauge > 3.00 and Width+Depth > 110.00 and Mfg Facility = Sterling
5. If True Gauge > 6.00 and Width+Depth > 80.00 (any facility)
6. If True Gauge > 5.00 and Width+Depth > 110.00 (any facility)
7. If True Gauge > 4.00 and Width+Depth > 120.00 (any facility)
8. If True Gauge > 3.00 and Width+Depth > 134.00 (any facility)
9. If True Gauge > 2.00 and Width+Depth > 140.00 (any facility)
10. If Bottomseal and Width+Depth < 8.00
11. If Bottomseal and Width+Depth < 9.00 and Entered Gauge < 3.00
12. If Sideweld and Mfg Facility = Sterling SOR/ROLLSHEET/ROLLTUBE don't have this rule (but can never be sideweld anyway)
13. If Width+Depth < 12.00 and Mfg Facility = Texas and Entered Gauge < 4.00
14. If Width+Depth < 10.00 and Mfg Facility = Texas
15. If Bottomseal and Width+Depth < 12.00 and Mfg Facility = Iowa SOR/ROLLSHEET/ROLLTUBE don't test for Bottomseal (always bottomseal)
16. If Bottomseal and Width+Depth < 13.00 and Mfg Facility = Iowa and Entered Gauge < 3.00 SOR/ROLLSHEET/ROLLTUBE don't test for Bottomseal (always bottomseal)
17. FURN only has 2 rules, which use Length instead of Width:
  1. If True Gauge > 5.00 and Length+Depth > 70.00 and Mfg Facility = Sterling
  2. If True Gauge > 4.00 and Length+Depth > 80.00 and Mfg Facility = Sterling
LLDPE Warning Message (criteria 100):
1. If Exclude LLDPE=Y and LLD, displays warning msg: Due to the size of this bag, there will be a nominal reduction to the amount of linear low density in this item
Operation Table Name (criteria 31) (CALL WEB.OPER.TABLEINFO):
1. Based on True Gauge, Mfg Facility, and Seal (bottomseal/sideweld), assigns operation table name. ie, If true gauge is 1.00 and Sterling facility and 1up Sideweld, table name would be assigned as SW.90-1.1-1UP. Each facility has a separate table for bottomseal, 1up sideweld,, 2up sideweld, singlewound sheeting, and true gauge range. The base gauge (lower range) is retained for later use when calculating maximum cycles for the primary and alternate work centers (in this example .90 would be the base gauge):
2. First part of table name defines the Plant and Seal: BS=Sterling Bottomseal,SW=Sterling Sideweld, SWS=Sterling Singlewound Sheeting, BT=Texas Bottomseal, SWT=Texas Sideweld, SWST=Texas Singlewound Sheeting, BI=Iowa Bottomseal, SWI=Iowa Sideweld, SWSI=Iowa Singlewound Sheeting, BN=Nevada Bottomseal, SWSN=Nevada Singlewound Sheeting (Nevada doesn't manufacture sideweld)
3. Second part of table name is the lower gauge range. All rules are >= lower range
4. Third part of table name is the upper gauge range. All rules are < high range
5. Fourth part of table name (sideweld only) is the 'nbr up'
6. Sideweld 1up and 2up tables exist for Sterling (SW), Texas (SWT), and Iowa (SWI) for True Gauge Ranges: .90-1.1, 1.1-1.3, 1.3-1.7, 1.7-2.6, 2.6-3.5, 3.5-4.0
7. Bottomseal tables exist for Sterling (BS), Texas (BT), Iowa (BI), and Nevada (BN) for True Gauge Ranges: .75-.90, .90-1.1, 1.1-1.3, 1.3-1.7, 1.7-2.6, 2.6-3.5, 3.5-4.5, 4.5-5.5, 5.5-7.2, 7.2-8.0
8. It doesn't matter which order the following rules are executed in. A prior program has already determined whether it is sideweld 1up/2up or bottomseal and what plant to make it in:
  1. Sterling Sideweld .90 - 4mil in order of true gauge ranges. Checks for 1up and 2up.
  2. Sterling Bottomseal .75 - 8mil in order of true gauge ranges.
  3. Texas Sideweld .90 - 4mil in order of true gauge ranges. Checks for 1up and 2up.
  4. Texas Bottomseal .75 - 8mil in order of true gauge ranges
  5. Iowa Bottomseal .75 - 8mil in order of true gauge ranges
  6. Iowa Sideweld ,90 - 4mil in order of true gauge ranges. Checks for 1up and 2up.
  7. Reno Bottomseal .75- 8mil in order of true gauge ranges (Reno currently does not have a sideweld line)
9. FURN - follows same rules as Bags
10. SHEETING/ROLLSHEET/SOR - Centerfold and Gusseted use bottomseal tables (same logic as BAGS), but Singlewound sheeting uses SWS (Sterling), SWST (Texas), SWSI (Iowa), or SWSN (Nevada) tables.
11. TUBING/ROLLTUBE - follows same rules as Bags
Minimum Lbs (criteria 35):
1. If color job and bubblesize >= 30 <= 58: Minimum = 1000
2. If color job and bubblesize > 58: Minimum = 5000
3. If color job and bubblesize < 30 or not color job: Get minimum lbs from operation table based on bubblesize CALL WEB.OPER.TABLEINFO to get MIN.LBS
4. FURN - follows same rules as BAGs, except bubblesize for FURN is LENGTH
5. ROLLSHEET/ROLLTUBE: This is recalc'd after Minimum #Rolls is calculated (see #12 below)
Min Wgt Due (Color) (criteria 106)- this isn't needed ... it does the same thing that Minimum Lbs above does, so is redundent.
Yield per 1000 Bags (criteria 18):
1. (Width + Depth) x Length x Entered Gauge / 15 (MD3)
2. FURN - same calc as BAGS (because furn has no depth so it's length x width)
3. SOR - If singlewound perforated sheeting: ((Width+Depth) x Length x Entered Gauge / 15) / 2 (MD3). Centerfold and Gusseted perforated Sheeting has same rules as BAGS
4. SHEETING/ROLLSHEET:
  1. Singlewound Continuous Sheeting: (Width x True Gauge) x .4 x (Feet per Roll / 1000)
  2. Centerfold Continuous Sheeting, and Gusseted Continuous Sheeting: (Width+Depth) x True Gauge x .8 x (Feet per Roll / 1000).
5. TUBING: (Width+Depth) x True Gauge x .8 x (Feet per Roll / 1000) *** this is roll wgt (yield)–continuous isn't per 1000 bags
Minimum Nbr of Bags (or Rolls) (criteria 53,110,107):
1. Minimum Lbs / Yield per 1000 Bags* (MD2)
  1. *Yield per 1000 Bags (Case/Roll Wgt) for BAGS & FURN:& SOR Centerfold/Gusseted (Width+Depth) x Length x Entered Gauge / 15
  2. *Yield per 1000 Bags f(Case/Roll Wgt) or SOR-Singlewound: ((Width+Depth) x Length x Entered Gauge / 15) / 2 (MD3)
  3. *Yield per 1000 Bags (case/roll wgt) for TUBING, Continuous Centerfold Sheeting, and Gusseted Sheeting: (Width+Depth) x True Gauge x .8 x (Feet per Roll / 1000)
  4. *Yield per 1000 Bags (case/roll wgt) for Continuous Singlewound Sheeting: (Width x True Gauge) x .4 x (Feet per Roll / 1000)
2. ROLLSHEET (min #rolls) - Minimum Lbs / Roll Wgt + .49 (MD0) (Yield above is same as criteria 192 below, which for rollsheet is calc'd before min nbr of rolls). Then calcs a new Minimum Lbs (criteria 35 above): Minimum #Rolls x Roll Wgt (MD1)
3. ROLLTUBE (min #rolls) - Minimum Lbs / Roll Wgt + .49 (MD0) (same as rollsheet). Then calcs a new Minimum Lbs (criteria 35 above): Minimum #Rolls x Roll Wgt (MD1) (same as rollsheet)
Case/Roll Weight (criteria 192):
1. ((Width + Depth) x Length x True Gauge / 15) x (Bags per RLCS / 1000) (MD1)
2. FURN - same calc as bags
3. SOR:
  1. Centerfold/Gusseted - same calc as BAGS
  2. Singlewound: ((Width + Depth) x Length x True Gauge / 30) x (Bags per RLCS / 1000) (MD1)
4. ROLLSHEET: (this calc is done before Minimum Nbr of Rolls above)
  1. Centerfold or Gusseted: (Width + Depth) x True Gauge x .8 x (feet per roll / 1000)
  2. Singlewound: (Width x True Gauge) x .4 x (feet per roll / 1000)
  3. Minimum Lbs (criteria 35 above) is recalculated for ROLLSHEET - (Minimum Nbr of Rolls x Roll Weight) (MD1)
5. ROLLTUBE: (Width+Depth) x True Gauge x .8 x (Feet per Roll / 1000) (MD1)
Quote Quantity (criteria 6):
1. Entered by user (must be >= minimum qty) - BAGS - entered in Uom "M"
2. FURN - (must be >= minimum qty) - entered in UOM "M"
3. SOR - (must e >= minimum qty) - entered in UOM "M"
4. ROLLSHEET - (must be >= minimum #rolls) - entered in UOM "RL"
5. ROLLTUBE - (must be >= minimum #rolls) - entered in UOM "RL"
Price Break1 Custom Qty (criteria 352):
1. Custom Break1 Qty entered by user (overrides standard price breaks) - Range Min Qty to 2000 'M'; ROLLSHEET/ROLLTUBE-Range Min #rolls to 9999 for 'RL'
Price Break2 Custom Qty (criteria 353):
1. Custom Break2 Qty entered by user (overrides standard price breaks) - Range Custom Break2 Qty to 2000 'M'. ROLLSHEET/ROLLTUBE- Range Min #rolls to 9999 for 'RL'
Price Break3 Custom Qty (criteria 354):
1. Custom Break3 Qty entered by user (overrides standard price breaks) - Range Custom Break3 Qty to 2000. ROLLSHEET/ROLLTUBE- 'M' Range Min #rolls to 9999 for 'RL'
Roll LengthxGauge (criteria 190):

If BOR and Depth=0 and Not Folded in Half: Length / 12 x Bags Per Roll x True Gauge x 2 (MD0)
If BOR and Depth > 0 and Not Folded in Half OR BOR and Depth=0 and Folded: Length / 12 x Bags Per Roll x True Gauge x 4 (MD0)
If BOR and Depth > 0 and Folded: Length / 12 x Bags Per Roll x True Gauge x 8 (MD0)
In Cases: 0
FURN:
1. If Depth=0 and Not Folded: (Width / 12) x Bags Per Roll x True Gauge x 2 (MD0)
2. If Depth=0 and Folded in Half: (Width / 12) x Bags Per Roll x True Gauge x 4 (MD0)
SOR:

If Singlewound: (Length / 12 x Feet per Roll x True Gauge (MD0)
If Centerfold - same calc as BAGS a. above (BOR,D=0,Not Folded)
If Gusseted - Length / 12 x Feet Per Roll x True Gauge x 4 (MD0)

ROLLSHEET:
1. Singlewound: Feet per Roll x True Gauge (MD0)
2. Centerfold: (Feet per Roll x True Gauge) x 2 (MD0)
3. Gusseted: (Feet per Roll x True Gauge) x 4 (MD0)
ROLLTUBE:
1. If Depth=0: Feet per Roll x True Gaue x 2 (MD0)
2. If Depth > 0: Feet per Roll x True Gauge x 4 (MD0)

Box Table Name (criteria 193):
1. If BOR and Cradlepacked: KRADTAB
2. If BOR and LxG < 1500: BOXTAB1
3. If BOR and LxG >= 1500 < 1900: BOXTAB2
4. If BOR and LxG >= 1900 < 2350: BOXTAB3
5. If BOR and LxG >= 2350 < 2900: BOXTAB4
6. If BOR and LxG >= 2900 < 3350: BOXTAB5
7. If BOR and LxG >= 3350 < 3900: BOXTAB6
8. If BOR and LxG >= 3900 < 4500: BOXTAB7
9. If BOR and LxG >= 4500 < 5150: BOXTAB8
10. If BOR and LxG >= 5150 < 6200: BOXTAB9
11. If BOR and LxG >= 6200 < 8500: BOXTAB10
12. If BOR and LxG >= 8500 < 12500: BOXTAB11
13. If Cases and Width < 10.00: BOXTAB12
14. If Cases and Width >= 10.00: BOXTAB13
15. FURN - has same rules as BAGS-BOR (FURN is always on a roll)
16. SOR/ROLLSHEET - have same rules as BAGS-BOR (SOR/ROLLSHEET are always on a roll)
17. ROLLTUBE - has same rules as BAGS-BOR (always on a roll)
Cubic Inches (criteria 205):
1. If Cases and Depth=0: (Width + Depth x Length x True Gauge / 15) x (Bags per Case / 1000) x 45 (MD0)
2. If Cases and Depth > 0: (Width + Depth x Length x True Gauge / 15) x (Bags per Case / 1000) x 48 (MD0)
3. If BOR: 0
4. FURN - is always on a roll so doesn't need this calculation
5. SOR/ROLLSHEET - are always on a roll so don't need this calculation
6. ROLLTUBE - always on a roll so doesn't need this calculation
MAX SKID (criteria 452): *** needed for Carts area
1. If BOR and Cradlepacked: From Roll Diameter Table, MAXPKG Column, using LxG FURN has same rule, SOR/ROLLSHEET/ROLLTUBE have same rule
2. If BOR and Not Cradlepacked: From Roll Diameter Table, MAXPKG Column, using Folded Width FURN has same rule but uses Folded Length instead of Folded Width; SOR/ROLLSHEET/ROLLTUBE have same rule, except use Width instead of Folded Width
3. If Not BOR (case packed): From Roll Diameter Table, MAXPKG Column, using Cubic Inches FURN doesn't need this rule - always on a roll; SOR/ROLLSHEET don't need - always on a Roll
4. Note: roll diameter table determined in WEB.PACKOUT.RANGES
Made-To-Order Stock? (criteria 300):
1. If PARMS(8)<7>='MTO' then "Y" in this field. Today this is based on a user-set flag, set by the c/e dept in Avante Quote Entry. This will be automatically set going forward if we find a single stock match.
Nbr of Cases or Rolls (criteria 204):
1. Quote Qty Ordered x 1000 / Bags per CaseorRoll + .49 (MD0-rounded up to a whole number) *** calculation for Quantity in Uom 'M'
2. FURN - same calc as Bags (uom=M)
3. SOR - same calc as Bags (uom=M)
4. ROLLSHEET /ROLLTUBE- this isn't needed as a calc because qty ordered is in Rolls (UOM=RL)
Order Total Pounds (criteria 55):
1. Qty Ordered x Yield per 1000 Bags (MD1) *** calculation for Quantity in Uom 'M'
2. FURN - same calc as Bags (uom=M)
3. SOR - same calc as Bags (uom=M)
4. ROLLSHEET/ROLLTUBE - same calc as Bags: Qty Ordered (in rolls) x Roll Wgt (uom=RL, but yield per 1000 bags (roll wgt) has special logic for rollsheet/ROLLTUBE)
Low Width Tolerance (criteria 268):
1. Get from WIDTH_TOL table, column LOW_TOL, using Width+Depth
2. Low Width Tolerance = (Width + Depth) - Low Tolerance from table
3. SOR/ROLLSHEET/ROLLTUBE - have same rules/calcs as BAGS
4. FURN:
  1. If Width < 120.00: get from WIDTH_TOL table, column LOW_TOL, using Length. Low Width Tolerance=Width - Low Tolerance from Table
  2. If Width >= 120.00: Width - (Width x .02)
High Width Tolerance (criteria 269):
1. Get from WIDTH_TOL table, column HIGH_TOL, using Width+Depth
2. High Width Tolerance = (Width + Depth) + High Tolerance from table
3. SOR/ROLLSHEET/ROLLTUBE have same rules/calcs as BAGS
4. FURN:
  1. If Width < 120.00: get from WIDTH_TOL table, column HIGH_TOL, using Width. High Width Tolerance=Width + High Tolerance from Table
  2. If Width >= 120.00: Width + (Width x .02)
Low Length Tolerance (criteria 270):
1. If Length < 120.00: get from LENGTH_TOL table, column LOW_TOL, using Length. Low Length Tolerance=Length - Low Tolerance from Table
2. If Length >= 120.00: Length - (Length x .02)
3. ROLLSHEET/ROLLTUBE - don't need this calc - they don't have a length. S/b Null
4. SOR - has same rules/calcs as BAGS
5. FURN:
  1. Get from LENGTH_TOL table, column LOW_TOL, using Length
  2. Low Length Tolerance = Length - Low Tolerance from table
High Length Tolerance (criteria 271):
1. If Length < 120.00: get from LENGTH_TOL table, column HIGH_TOL, using Length. High Length Tolerance=Length + High Tolerance from Table
2. If Length >= 120.00: Length + (Length x .02)
3. ROLLSHEET/ROLLTUBE - don't need this calc - they don't have a length. S/b Null
4. SOR - has same rules/calcs as BAGS
5. FURN:
  1. Get from LENGTH_TOL table, column HIGH_TOL, using Length
  2. High Length Tolerance = Length + High Tolerance from table
Film Only? (criteria 231) - Operation Swapping for Tubing-only Work Centers (bags can't run on these lines):
1. If Bottomseal: Get Y/N flag from operations table, "Film?" Column, based on bubblesize FURN has same rule; SOR/ROLLTUBE has same
2. If Sideweld, set to "N" FURN doesn't need this rule - always bottomseal; SOR doesn't need-always BSeal
Operation#1 (criteria 32):
1. Get from Operations Table, OPER1 column, for bubblesize
Premix? (criteria 372):

Get from MAXLBS Table, PREMIX column, for Operation#1

Resin Table Row Nbr (criteria 154): *** MUST INCLUDE NEW MATERIALS IN THIS LOGIC. NOTE: I didn't include in this list of rules the obsolete masks 220-300 that pertained to PAS

If Material=Standard, Clear, Metallocene=N, Width+Depth < 18.00: Row=1
If Material=Standard, Clear, Metallocene=Y, and Width+Depth < 18.00: Row=19
If Material=Standard, Clear, Width+Depth >= 18.00, Sideweld: Row=2
If Material=Standard, Clear, Width+Depth >= 18.00, Bottomseal, Mfg Facility=Sterling: Row=3
If Material=Standard, Clear, Width+Depth >= 18.00, Bottomseal, Mfg Facility=Texas: Row=4
If Material=Standard, Clear, Width+Depth >= 18.00, Bottomseal, Mfg Facility=Iowa or Reno: Row=5
If Material=Standard, Color Job, Width+Depth < 18.00, Sideweld: Row=2
If Material=Standard, Color Job, Bottomseal, Width+Depth < 18.00, Mfg Facility is not Sterling, Exclude LLDPE=N: Row=4
If Material=Standard, Color Job, Bottomseal, Width+Depth < 18.00, Mfg Facility is not Sterling, Exclude LLDPE=Y: Row=2 ***THIS CAN BE COMBINED WITH k. - one says = Sterling and one says # Sterling. Remove test on mfg facility ROLLSHEET doesn't have this rule
If Material=Standard, Color Job, Bottomseal, Width+Depth < 18.00, Mfg Facility=Sterling, Exclude LLDPE=N: Row=3
If Material=Standard, Color Job, Bottomseal, Width+Depth < 18.00, Mfg Facility=Sterling, Exclude LLDPE=Y: Row=2 ROLLSHEET doesn't have Mfg Facility test on this rule – combine this with i. above and remove Mfg Facility=Sterling so it will work for BAGS and ROLLSHEET/ROLLTUBE.
If Material=Standard, Color Job, Width+Depth >= 18.00, Bottomseal, Mfg Facility=Sterling: Row=3
If Material=Standard, Color Job, Width+Depth >= 18.00, Sideweld: Row=2
If Material=Standard, Color Job, Width+Depth >= 18.00, Bottomseal, Mfg Facility=Texas: Row=4
If Material=Standard, Color Job, Width+Depth >= 18.00, Bottomseal, Mfg Facility=Iowa or Reno: Row=5
If Material=LLD, Specific LLD=Std Hexene Blend, Mfg Facility=Sterling: Row=20 *** NO LONGER WHS SPECIFIC-keep one of these rules without the Mfg Facility test
If Material=LLD, Specific LLD=Std Hexene Blend, Mfg Facility=Texas: Row=20 *** NO LONGER WHS SPECIFIC
If Material=LLD, Specific LLD=Std Hexene Blend, Mfg Facility=Iowa or Reno Row=20 *** NO LONGER WHS SPECIFIC
If Material=LLD, Specific LLD=Octene, Mfg Facility=Sterling: Row=6
If Material=LLD, Specific LLD=Octene, Mfg Facility=Texas: Row=7
If Material=LLD, Specific LLD=Octene, Mfg Facility=Iowa or Reno: Row=8
If Material=Anti Static, Specific AS=AMFPink, Mil Spec, Premix=Y, Metallocene=N, Anti Block=No, UVI/UVA=N: Row=11
If Material=Anti Static, Specific AS=AMFPink, Mil Spec, W+D < 20, and (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Row=10 SOR/ROLLSHEET/ROLLTUBE don't have W+D<20 but everything else matches
If Material=Anti Static, Specific AS=AMFPink, Mil Spec, W+D >= 20, and (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Row=21 SOR/ROLLSHEET/ROLLTUBE don't have this because above rule doesn't have the >=20 test. always goes to row 10 (so will need a separate rule)
If Material=Anti Static, Specific AS=AMFPink, Other Pct, Linear Low Density: Row=3
If Material=Anti Static, Specific AS=AMFPink, Other Pct, AS%=6, Std Low Density, Premix=Y, Metallocene=N, Antiblock=N, UVI/UVA=N: Row=11
If Material=Anti Static, Specific AS=AMFPink, Other Pct, AS%=6, Std Low Density, W+D < 20, (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y) OR If Material=Anti Static, Specific AS=AMFPink, Other Pct, AS%=6, Std Low Density, Sideweld, (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Row=10 SOR/ROLLSHEET/ROLLTUBE have same rule with exception of W+D < 20 test and SIDEWELD test
If Material=Anti Static, Specific AS=AMFPink, Other Pct, AS%=6, Std Low Density, W+D >= 20, Bottomseal, (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Row=21 SOR/ROLLSHEET/ROLLTUBE don't need this rule since aa. above doesn't test for W+D < 20 or sideweld
If Material=Anti Static, SpecificAS=AMFPink, Other Pct, AS% not 6, Std Low Density, (W+D < 20 OR Sideweld): Row=10 SOR/ROLLSHEET/ROLLTUBE have same rule with exception of W+D < 20 AND sideweld
If Material=Anti Static, SpecificAS=AMFPink, Other Pct, AS% not 6, W+D >= 20, Bottomseal, Std Low Density: Row=21 SOR/ROLLSHEET/ROLLTUBE don't need this rule since ac. above doesn't test for W+D < 20 or sideweld
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Milspec, W+D >=18 < 20: Row=10 SOR/ROLLSHEET/ROLLTUBE don't have <20 on this rule .. just has >=18
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Milspec, W+D >= 20: Row=21 SOR/ROLLSHEET/ROLLTUBE don't need this rule since ae. above doesn't test for < 20.
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Milspec, W+D < 18: Row=19
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Other Pct, Linear Low Density: Row=3
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Other Pct, Std Low Density, W+D >=18 <20 OR If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Other Pct, Std Low Density, W+D >=18, Sideweld: Row=10 SOR/ROLLSHEET/ROLLTUBE don't have < 20 rule or second rule w/SIDEWELD test
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Other Pct, Std Low Density, W+D >=20, Bottomseal: Row=21 SOR/ROLLSHEET/ROLLTUE don't need this rule since ai. above doesn't test for < 20
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color=None, Other Pct, Std Low Density, W+D <18: Row=19
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color Job, Milspec, W+D <20: Row=10 SOR/ROLLSHEET/ROLLTUBE don't have <20 test
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color Job, Milspec, W+D >=20: Row=21 SOR/ROLLSHEET/ROLLTUBE don't need this since al. above doesn't test for <20
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color Job,Other Pct, Linear Low Density: Row=3
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color Job, Other Pct, Std Low Density, W+D <20 OR If Material=Anti Static,SpecificAS=AMF Clear/Color, Color Job, Other Pct, Std Low Density, Sideweld: Row=10 SOR/ROLLSHEET/ROLLTUBE don't have <20 test or sideweld test
If Material=Anti Static,SpecificAS=AMF Clear/Color, Color Job,Other Pct, Std Low Density, W+D >= 20, Bottomseal: Row=21 SOR/ROLLSHEET/ROLLTUBE don't need this since ao. above doesn't test for <20 or sideweld
If Material=Postal Appr: Row=12
If Material=VCI and Clear and W+D < 18: Row=13
If Material=VCI and Clear and W+D >= 18: Row=14
If Material=VCI and Color=Std Blue VCI: Row=15
If Material=VCI and Color=Std Yellow VCI: Row=16 ***YELLOW VCI DISCONTINUED
If Material=VCI and not Std Blue VCI (other color): Row=14
If Material=Clarity and Metallocene=N: Row=1
If Material=Clarity and Metallocene=Y: Row=19
If Material=Non Slip and Exclude LLDPE=N: Row=17
If Material=Non Slip and Exclude LLDPE=Y and Mfg Facility=Sterling: Row=18 ***these 3 rules aren't dependent on mfg facility any longer so can be combined
If Material=Non Slip and Exclude LLDPE=Y and Mfg Facility=Iowa or Reno: Row=18
If Material=Non Slip and Exclude LLDPE=Y and Mfg Facility=Texas: Row=18
If Material=Non Scratch and Exclude LLDPE=N: Row=22
If Material=Non Scratch and Exclude LLDPE=Y: Row=23
FURN rules:
1. If Material=Standard, Clear, Mfg Facility=Sterling: Row 3
2. If Material=Standard, Clear, Mfg Facility=Texas: Row 4
3. If Material=Standard, Clear, Mf Facility=Iowa or Reno: Row 5
4. If Material=Standard, Color Job, Mfg Facility=Sterling: Row 3
5. If Material=Standard, Color Job, Mfg Facility=Texas: Row 4
6. If Material=Standard, Color Job, Mfg Facility=Iowa or Reno: Row 5
7. If Material=LLD, Specific LLD=Std Hexene Blend, Mfg Facility=Sterling: Row=20 *** NO LONGER WHS SPECIFIC
8. If Material=LLD, Specific LLD=Std Hexene Blend, Mfg Facility=Texas: Row=20 *** NO LONGER WHS SPECIFIC
9. If Material=LLD, Specific LLD=Std Hexene Blend, Mfg Facility=Iowa or Reno Row=20 *** NO LONGER WHS SPECIFIC
10. If Material=LLD, Specific LLD=Octene, Mfg Facility=Sterling: Row=6
11. If Material=LLD, Specific LLD=Octene, Mfg Facility=Texas: Row=7
12. If Material=LLD, Specific LLD=Octene, Mfg Facility=Iowa or Reno: Row=8
13. If Material=Anti Static, Specific AS=PAS, Mil Spec, Premix=Y, Metallocene=N, Anti Block=N, UVI/UVA=N: Row=9 **PAS OBSOLETE
14. If Material=Anti Static, Specific AS=PAS, Mil Spec, and (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Row=21 **PAS OBSOLETE
15. If Material=Anti Static, Specific AS=PAS, Other Pct, and Linear Low Density: Row=3 **PAS OBSOLETE
16. If Material=Anti Static, Specific AS=PAS, Other Pct, AS%=6, Std Low Density, Premix=Y, Metallocene=N, Anti Block=N, UV/UVA=N: Row=9 **PAS OBSOLETE
17. If Material=Anti Static, Specific AS=PAS, Other Pct, AS%=6, Std Low Density, (Premix=N OR Metallocene=Y OR Anti Block=Y or UVI/UVA=Y): Row=21 **PAS OBSOLETE
18. If Material=Anti Static, Specific AS=Pink, Other Pct, AS% is not 6, Std Low Density: Row=21
19. If Material=Anti Static, Specific AS=AmineFree Pink, Mil Spec, Premix=Y, Metallocene=N, Anti Block=N, UVI/UVA=N: Row=11
20. If Material=Anti Static, Specific AS=AmineFree Pink, Mil Spec, and (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Row=21
21. If Material=Anti Static, Specific AS=AmineFree Pink, Other Pct, and Linear Low Density: Row=3
22. If Material=Anti Static, Specific AS=AmineFree Pink, Other Pct, AS%=6, Std Low Density, Premix=Y, Metallocene=N, Anti Block=N, UV/UVA=N: Row=11
23. If Material=Anti Static, Specific AS=AmineFree Pink, Other Pct, AS%=6, Std Low Density, (Premix=N OR Metallocene=Y OR Anti Block=Y or UVI/UVA=Y): Row=21
24. If Material=Anti Static, Specific AS=AmineFree Pink,Other Pct, AS% is not 6, Std Low Density: Row=21
25. If Material=Anti Static, Specific AS=AmineFree Clear,Mil Spec: Row=21
26. If Material=Anti Static, Specific AS=AmineFree Clear,Other Pct, Linear Low Density: Row=3
27. If Material=Anti Static, Specific AS=AmineFree Clear,Other Pct, Std Low Density: Row= 21
28. If Material=Anti Static, Specific AS=AmineFree Color,Mil Spec: Row=21
29. If Material=Anti Static, Specific AS=AmineFree Color,Other Pct, Linear Low Density: Row=3
30. If Material=Anti Static, Specific AS=AmineFree Color,Other Pct, Std Low Density: Row=21
31. If Material=Postal Approved: Row=12
32. If Material=VCI and Color=Clear: Row=14
33. If Material=VCI and Color=Std Blue VCI: Row=15
34. If Material=VCI and Color=Std Yellow VCI: Row=16 ***THIS IS OBSOLETE
35. If Material=VCI and Color is not Std Blue or Std Yellow: Row=14
36. If Material=Clarity and Metallocene=N: Row=1
37. If Material=Clarity and Metallocene=Y: Row=19
38. If Material=Non Slip and Exclude LLDPE=N: Row=17
39. If Material=Non Slip and LLDPE=Y and Mfg Facility=Sterling: Row=18
40. If Material=Non Slip and LLDPE=Y and (Mfg Facility=Iowa or Reno): Row=18
41. If Material=Non Slip and LLDPE=Y and Mfg Facility=Texas: Row=Row=18
42. If Material=Non Scratch and LLDPE=N: Row=22
43. If Material=Non Scratch and LLDPE=Y: Row=23

Resin Type (Heat Profile) (criteria 232):
1. From table SPLIT_RESIN, column RESTYPE, using Resin Table Row Nbr
Resin Swapcode (criteria 374):
1. From table SPLIT_RESIN, column SWAPCODE, using Resin Table Row Nbr
Operation1 Table Feet/Minute (criteria 235):
1. From Operation Table, column OP1_FPM, using bubblesize (MD0)
Operation1 Feet/Minute Factor (criteria 236):
1. From Operation Table, column OP1_FPMFCT, using bubblesize (MD1)
Operation#2 (criteria 233):
1. From Operation Table, column OPER2, using bubblesize
Operation2 Table Feet/Minute (criteria 237):
1. From Operation Table, column OP2_FPM, using bubblesize (MD0)
Operation2 Feet/Minute Factor (criteria 238):
1. From Operation Table, column OP2_FPMFCT, using bubblesize (MD1)
Operation1 Table Max Cycles/Minute (criteria 239):
1. If Bottomseal, Depth=0: From Operation Table, column LF_MAXCPM, using bubblesize (MD0) ***this is only rule that FURN has
2. If Bottomseal, Depth >0: From Operation Table, column GU_MAXCPN, using bubblesize (MD0)
3. If Sideweld: From Operation Table, column OP1_MAXCPN, using bubblesize (MD0)
4. SOR/ROLLSHEET/ROLLTUBE don't need max cycles
Operation1 Max Cycles/Minute Factor (criteria 240):
1. If Bottomseal, Depth=0: From Operation Table, column LF_CPMFCT, using bubblesize (MD1) ***this is only rule that FURN has
2. If Bottomseal, Depth >0: From Operation Table, column GU_CPMFCT, using bubblesize (MD1)
3. If Sideweld: From Operation Table, column OP1_CPMFCT, using bubblesize (MD1)
4. SOR/ROLLSHEET/ROLLTUBE don't need max cycles
Operation2 Table Max Cycles/Minute (criteria 263):
1. If Bottomseal: Uses same value as Oper1 max cpm (criteria 239) (MD0)
2. If Sideweld: From Operation Table, column OP2_MAXCPM, using bubblesize (MD0)
3. SOR/ROLLSHEET/ROLLTUBE don't need max cycles
Operation2 Max Cycles/Minute Factor(criteria 264):
1. If Bottomseal: Uses same value as Oper1 max cpm factor (criteria 240) (MD1) ***this is only rule that FURN has
2. If Sideweld: From Operation Table, column OP2_CPMFCT, using bubblesize (MD1)
3. SOR/ROLLSHEET/ROLLTUBE don't need max cycles
Operation1/Operation2 Swap (criteria 234):
1. If Film Only=Y and Depth > 0 and True Gauge > 4: Null out Operation2 (oper2,fpm,fpmfct,maxcpm,maxcpmfct)
2. If Operation1=EXT600, Heat Profile=C or D, Material not Standard OR Operation1=EXT400, Width < 8, Gauge < 3 OR Oper1=EXT400, Width < 6, Gauge >=3 OR Oper1=EXT400, Vented=Y OR Oper1=TX07, Heat Profile=C or D OR Oper1=IA08, Heat Profile= C or D: Operation1 (all 5 fields) are set to Operation2 data and Operation2 data is nulled out
3. If Oper2=EXT600, Heat Profile=C or D, Material not Standard or OPER2=TX07, Heat Profile = C or D or OPER2-IA08, Heat Profile = C or D: Nulls out Operation2 (oper2,fpm,fpmfct,maxcpm,maxcpmfct)
4. If W+D >= 60, Case Packed: Operation1 (all 5 fields0 are set to Operation2 data and Operation2 data is nulled out
5. BAGS ONLY - ADDED 10/23/13: If Primary Operation=EX1800 and Bags on Roll=N and Depth <= 0: Swap operation1 and operation2 data for the following:
  1. Operation Nbr (operation1 becomes operation 2 and operation 2 becomes operation1)
  2. Operation1 Feet per Minute and Operation2 Feet per Minute (criteria 235 & 237)
  3. Operation1 Feet per Minute Factor and Operation2 Feet per Minute Factor (criteria 236 & 238)
  4. Operation1 Max Cycles per Minute and Operation2 Max Cycles per Minute (criteria 263 & 239)
  5. Operation1 Cycles per Minute Factor and Operation2 Cycles per Minute Factor (criteria 264 & 240)
6. FURN:
  1. If Film Only=Y OR Operation#2 = EX1500: All Operation2 data is nulled out
  2. If Operation#1 = EXT600 and Heat Profile=C OR Operation#1=EXT600 and Heat Profile=D OR Operation#1=EX1500 OR Operation#1=IA10 and (Length > 78.00 or Fold Bags in Half=Y): Operation1 (all 5 fields) are set to Operation2 data and Operation2 data is nulled out.
  3. If Operation#2 = EXT600 and Heat Profile=C OR Operation#2=EXT600 and Heat Profile=D OR Operation#2=IA10 and (Length > 78.00 or Fold Bags in Half=Y): All operation2 data is nulled out
7. SOR:
  1. If Film Only=Y: Null out Operation2, Operation2 Feet/Min and Operation2 Feet/Minute Factor
  2. If Oper1=EXT600, Heat Profile=C or D, Material not Standard or OPER1=TX07, Heat Profile = C or D or OPER1=IA08, Heat Profile = C or D OR OPER1=IA10 and Width > 78.00: Sets Operation1 data = Operation2 data, then nulls out operation2 data
  3. If Oper2=EXT600, Heat Profile=C or D, Material not Standard or OPER2=TX07, Heat Profile = C or D or OPER2=IA08, Heat Profile = C or D OR OPER2=IA10 and Width > 78.00: Nulls out Operation2 data
8. ROLLSHEET/ROLLTUBE:
  1. If Film Only=Y, Heat Profile=C, D or F, Material is not Standard OR Film Only=Y and Depth > 0: Nulls out Operation2 Data
  2. If Film Only=Y, Heat Profile=A or B, Depth=0 OR Film Only=Y, Material=Standard, Depth=0: Sets Operation1=Operation2 Data and Operation2 Data=Operation1 Data (swaps them)
  3. If Oper1=EXT600, Heat Profile=C or D, Material is not Standard OR Oper1=TX07, Heat Profile=C or D OR Oper1=IA08 Heat Profile=C or D OR Oper1=IA10, Width > 78.00: Sets Oper1 Data = Oper2 Data, then nulls out Oper2 Data
  4. If Oper2=EXT600, Heat Profile=C or D, Material is not Standard OR Oper2=TX07, Heat Profile=C or D OR Oper2=IA08 Heat Profile=C or D OR Oper2=IA10, Width > 78.00: Nulls out Operation2 Data
Operation1 Maximum Cycles (criteria 241):
1. Oper1 Table Max Cycles Per Min - (True Gauge - Base Gauge x Oper1 CPM Factor) (MD0)
2. SOR/ROLLSHEET/ROLLTUBE don't need max cycles
Operation2 Maximum Cycles (criteria 265):
1. Oper2 Table Max Cycles per Min - (True Gauge - Base Gauge x Oper2 CPM Factor) (MD0)
2. SOR/ROLLSHEET/ROLLTUBE don't need max cycles
Operation1 Feet per Minute (criteria 244):
1. Oper1 Table FPM - (True Gauge - Base Gauge x Oper1 FPM Factor) (MD0)
Operation1 Cycles per Minute (criteria 242):

If Bottomseal: Operation1 Feet per Minute / (Length / 12) (MD0) ** This is only rule SOR has
If Sideweld: Operation1 Feet per Minute / (Width / 12) (MD0) **This is only rule FURN has
ROLLSHEET/ROLLTUBE don't need cycles per min

Temp Operation1 Cycles per Minute (criteria 247):
1. If not Sleeves and Operation1 Cycles Per Minute > Operation1 Max Cycles: Use Oper1 Max Cycles
2. If Sleeves OR Oper1 Cycles Per Minute <= Oper1 Max Cycles: Use Oper1 Cycles Per Minute
3. SOR/ROLLSHEET/ROLLTUBE don't need cycles per min
Temp Operation1 Feet per Minute (criteria 248):
1. If not Sleeves and Oper1 Cycles Per Minute > Oper1 Max Cycles: Temp Oper1 CPM / Oper1 CPM x Oper1 FPM (MD0)
2. If Sleeves OR Oper1 Cycles Per Minute <= Oper1 Max Cycles: Use Operation1 Feet Per Minute
3. SOR/ROLLSHEET/ROLLTUBE don't have max cycles - USE OPER1 FPM
Operation2 Feet Per Minute (criteria 245):
1. Oper2 Table FPM - (True Gauge - Base Gauge x Oper2 FPM Factor) (MD0)
Operation2 Cycles per Minute (criteria 246):

If Bottomseal: Operation2 Table Feet per Minute / (Length / 12) **This is only rule SOR has
If Sideweld: Operation2 Table Feet per Minute / (Width / 12) ***this is only rule that FURN has

Temp Operation2 Cycles per Minute (criteria 249):
1. If not Sleeves and Operation2 Cycles Per Minute > Operation2 Max Cycles: Use Oper2 Max Cycles
2. If Sleeves OR Oper2 Cycles Per Minute <= Oper2 Max Cycles: Use Oper2 Cycles Per Minute
3. SOR/ROLLSHEET don't need max cycles
Temp Operation2 Feet per Minute (criteria 250):
1. If not Sleeves and Oper2 Cycles Per Minute > Oper2 Max Cycles: Temp Oper2 CPM / Oper2 CPM x Oper2 FPM (MD0)
2. If Sleeves OR Oper2 Cycles Per Minute <= Oper2 Max Cycles: Use Operation2 Feet Per Minute
3. SOR/ROLLSHEET don't need max cycles - USE OPER2 FPM
Operation1 Max Lbs (criteria 251):
1. From MAXLBS Table, column MAX_LBS, using Operation#1
Operation2 Max Lbs (criteria 252):
1. From MAXLBS Table, column MAX_LBS, using Operation#2
Feet Per Roll/Case (criteria 262):
1. If Bottomseal: Bags Per RollCase x (Length / 12) (MD0) ** This is only rule SOR has
2. If Sideweld: Bags Per RollCase x (Width / 12) (MD0) ***this is only rule that FURN has
3. ROLLSHEET/ROLLTUBE - This is the Packout Field (user-entered) for continuous sheeting/tubing
Lbs Per Hour (Oper1) (criteria 253):
1. If Bottomseal OR (Sideweld, TX1up Passed, Sterling 2up Failed, Iowa 2up Failed) OR (Sideweld, Sterling 1up Passed, Texas 2up Failed, Iowa 2up Failed) OR (Sideweld, Iowa 1up Passed, Sterling 2up Failed, Texas 2up Failed): Oper1 Feet per Min x 60 x CaseRoll Weight / Feet per RollCase (MD0) **SOR/ROLLSHEET use this calc for Centerfold or Gusseted. For singlewound, same calc except * 120 instead of * 60; ROLLTUBE uses this calc
2. If Sideweld, Texas 2up Passed OR Sideweld, Sterling 2up Passed OR Sideweld, Iowa 2up Passed: Oper1 Feet per Min x 60 x CaseRoll Weight / Feet per Rollcase x 2 (MD0) SOR/ROLLSHEET/ROLLTUBE don't have this rule
3. FURN: Oper1 Feet per Min x 60 x CaseRoll Weight / Feet per Rollcase (MD0)
Operation2 Sideweld - 1up or 2up? (criteria 266):
1. If Sideweld: From Operation Table, column 1OR2UP, using bubblesize
2. If Bottomseal: Null (not needed)
3. Furn doesn't need this
4. SOR /ROLLSHEET/ROLLTUBE don't need this - can't be sideweld
Lbs Per Hour (Oper2) (criteria 254):
1. If Bottomseal: Oper2 Feet per Min x 60 x CaseRoll Weight / Feet per RollCase (MD0) ***this is only rule FURN has **SOR/ROLLSHEET use this calc for Centerfold or Gusseted. For singlewound, same calc except * 120 instead of * 60; ROLLTUBE uses this calc
2. If Sideweld: Oper2 Feet per Min x 60 x CaseRoll Weight / Feet per Rollcase x Oper2 Sideweld 1up or 2up (MD0) SOR/ROLLSHEET/ROLLTUBE don't have this rule
Final Lbs per Hour-Operation#1 (criteria 255):
1. If Lbs Per Hour (Oper1) > Operation1 Max Lbs: Use Operation1 Max Lbs
2. If Lbs Per Hour (Oper1) <= Operation1 Max Lbs: Use Lbs Per Hour (Oper1)
Final Lbs per Hour-Operation#2 (criteria 256)
1. If Lbs Per Hour (Oper2) > Operation2 Max Lbs: Use Operation2 Max Lbs
2. If Lbs Per Hour (Oper2) <= Operation2 Max Lbs: Use Lbs Per Hour (Oper2)
Final Cycles per Minute-Operation#1 (criteria 257):
1. If Lbs Per Hour (Oper1) > Operation1 Max Lbs: Operation1 Max Lbs / Lbs Per Hour (Oper1) x Temp Oper1 Cycles per Min (MD0)
2. If Lbs Per Hour (Oper1) <= Operation1 Max Lbs: Use Temp Oper1 Cycles per Min
3. SOR/ROLLSHEET/ROLLTUBE don't need cycles per minute
Final Feet per Minute-Operation#1 (criteria 258):
1. If Lbs Per Hour (Oper1) > Operation1 Max Lbs: Operation1 Max Lbs / Lbs Per Hour (Oper1) x Temp Oper1 Feet per Minute (MD0)
2. If Lbs Per Hour (Oper1) <= Operation1 Max Lbs: Use Temp Oper1 Feet per Minute
Final Cycles per Minute-Operation#2 (criteria 259):
1. If Lbs Per Hour (Oper2) > Operation2 Max Lbs: Operation2 Max Lbs / Lbs Per Hour (Oper2) x Temp Oper2 Cycles per Min (MD0)
2. If Lbs Per Hour (Oper2) <= Operation2 Max Lbs: Use Temp Oper2 Cycles per Min
3. SOR/ROLLSHEET/ROLLTUBE don't need cycles per minute
Final Feet per Minute-Operation#2 (criteria 260):
1. If Lbs Per Hour (Oper2) > Operation2 Max Lbs: Operation2 Max Lbs / Lbs Per Hour (Oper2) x Temp Oper2 Feet per Minute (MD0)
2. If Lbs Per Hour (Oper2) <= Operation2 Max Lbs: Use Temp Oper2 Feet per Minute
Operation Rate[Lbs/Hour] (criteria 33):
1. Use Final Lbs per Hour-Operation#1 (MD1)
Operation Time Reqd[Hrs/M] (criteria 39):
1. Width + Depth x Length x True Gauge / 15 / Operation Rate[Lbs/Hour] (MD3)
2. SOR/ROLLSHEET/ROLLTUBE: CSRL Wgt / Operation Rate[Lbs/Hour] x Nbr of Rolls (which is quote qty) (MD2)
Color Indicator (criteria 51);
1. If Color=Clear or no Opacity or Std Blue VCI or Std Yellow VCI (yellow is discontinued): NONE
2. If Color is not Clear and Materials is not VCI: Color that was chosen from list
3. If Material=VCI and Other Colors: Color that was chosen from Second color list
Color Concentrate Item Nbr (criteria 59):
1. If Color Indicator = NONE: NONE
2. If Color Indicator # NONE: From KONCENTRATE Table, column ITM_NBR, using Color Indicator
Color Concentrate $/LB (criteria 60):
1. If Color Indicator = NONE: 0
2. If Color Indicator # NONE and Preferred Resin Price # Y: From KONCENTRATE Table, column MATL_$, using Color Indicator
3. If Color Indicator # NONE and Preferred Resin Price = Y: From KONCENTRATE Table, column PREF_$, using Color Indicator
Color Concentrate % Reqd (criteria 61):
1. If Color Indicator = NONE: 0
2. If Color Indicator # NONE and Opacity = Tint: From KOLOR_PCT Table, column TINT, using True Gauge
3. If Color Indicator # NONE and Opacity = Color and Color = White: From KOLOR_PCT, column COLORW, using True Gauge
4. If Color Indicator # NONE and Opacity = Color: From KOLOR_PCT Table, column COLOR, using True Gauge
5. If Color Indicator # NONE and Opacity = Opaque: From KOLOR_PCT, column OPAQUE, using True Gauge
Box1 Qty Per (criteria 194):
1. If BOR and Cradlepacked: From Box Table, column BOXQTY1, using Roll LxG ***FURN/SOR/ROLLSHEET/ROLLTUBE have same rule-always BOR
2. If BOR (not cradlepacked): From Box Table, column BOXQTY1, using Folded Width (Width/2) **FURN uses Length instead of Width-always BOR; SOR/ROLLSHEET/ROLLTUBE use Width-always BOR
3. If Case Packed: From Box Table, column BOXQTY1, using Cubic Inches **FURN doesn't need, SOR/ROLLSHEET/ROLLTUBE don't need
Box1 Item Nbr (criteria 195):
1. If BOR, Cradlepacked, and Box1 Qty Per > 0: From Box Table, column ITEMNO1, using Roll LxG ** FURN/SOR/ROLLSHEET/ROLLTUBE use same rule-always BOR
2. If BOR and Box1 Qty Per > 0: From Box Table, column ITEMNO1, using Folded Width (Width/2) **FURN uses folded length - always BOR, SOR/ROLLSHEET/ROLLTUBE use Width-always BOR
3. If Case Packed and Box1 Qty Per > 0: From Box Table, column ITEMNO1, using Cubic Inches **FURN/SOR/ROLLSHEETROLLTUBE don't need
4. If Box1 Qty Per <= 0: NONE
Box2 Qty Per (criteria 196):
1. If BOR and Cradlepacked: 0 ***FURN/SOR/ROLLSHEET/ROLLTUBE have same rule - always BOR
2. If BOR and Not Cradlepacked: From Box Table, column BOXQTY2, using Folded Width (Width/2) ***FURN uses length instead of width - always BOR; SOR/ROLLSHEET/ROLLTUBE use Width instead - always BOR
3. If Case Packed: From Box Table, column BOXQTY1, using Cubic Inches ***FURN/SOR/ROLLSHEET/ROLLTUBE don't need this
Box2 Item Nbr (criteria 197):
1. If BOR, Cradlepacked: NONE ***FURN/SOR/ROLLSHEET/ROLLTUBE use same rule - always BOR
2. If BOR and Box2 Qty Per > 0 and Not Cradlepacked: From Box Table, column ITEMNO2, using Folded Width (Width/2) ***FURN uses folded length instead of folded width - always BOR; SOR/ROLLSHEET/ROLLTUBE use width instead of folded width
3. If Case Packed and Box2 Qty Per > 0: From Box Table, column ITEMNO2, using Cubic Inches ***FURN doesn't need; SOR/ROLLSHEET/ROLLTUBE don't need
4. If Box2 Qty Per <= 0: NONE
Box1 Total Qty Reqd (criteria 198):
1. If Box1 Qty Per > 0, Cradlepacked, Folded Width < 70.00: Nbr of CSRL x Box1 Qty Per + .49 (MD0) FURN has same rules/calc except uses Folded Length instead of Folded Width; SOR/ROLLSHEET use width instead of folded width and ROLLSHEET/ROLLTUBE Nbr of Rolls is the Quote Qty
2. If Box1 Qty Per > 0, Cradlepacked, Folded Width >= 70.00: Box1 Qty Per x 1.5 x Nbr of CSRL(MD0) FURN has same rules/calc except uses Folded Length instead of Folded Width; SOR/ROLLSHEET uses width instead of folded width and ROLLSHEET/ROLLTUBE Nbr of Rolls is the Quote Qty
3. If Box1 Qty Per >= 1: Nbr of CSRL x Box1 Qty Per + .49 (MD0) FURN/SOR/ROLLSHEET - same rule; ROLLSHEET/ROLLTUBE Nbr of Rolls is the Quote Qty
4. If Box1 Qty Per > 0 < 1 (bundles), Not Cradlepacked: Nbr of CSRL x Box1 Qty Per FURN/SOR/ROLLSHEET - same rule; ROLLSHEET/ROLLTUBE Nbr of Rolls is the Quote Qty
5. If Box1 Qty Per <= 0: 0 FURN/SOR/ROLLSHEET/ROLLTUBE - same rule
Box2 Total Qty Reqd (criteria 199):
1. If Cradlepacked: 0
2. If Box2 Qty Per >= 1: Nbr of CSRL x Box2 Qty Per + .49 (MD0) ROLLSHEET/ROLLTUBE Nbr of CSRL is quote qty
3. If Box2 Qty Per > 0 < 1 (bundles), Not Cradlepacked: Nbr of CSRL x Box2 Qty Per ROLLSHEET/ROLLTUBE Nbr of CSRL is quote qty
4. If Box2 Qty Per <= 0: 0
Box Core Item Nbr (criteria 200):
1. If BOR, Depth > 0, Width > 48.00, Width-Depth > 40.00, CSRL Wgt > 80.00, Not Folded in Half OR Bags on a Roll, CSRL Wgt > 150.00: Use Core Item# 004976 SOR/ROLLSHEET/ROLLTUBE have this rule but don't need to check for BOR or folded in half
2. If Bags on a Roll: From BOX_CORES Table, column CORE, using Folded Width (width/2) SOR/ROLLSHEET/ROLLTUBE use Width (not folded width)
3. If Case Packed: NONE (no core reqd) SOR/ROLLSHEET/ROLLTUBE don't have this rule - always BOR
4. FURN:
Box Core Qty (criteria 201):
1. If Box Core Item Nbr = 004974 and Folded Width <= 42.00: Folded Width / 48 x Nbr of Rolls (MD1)
2. If Box Core Item Nbr = 004974 and Folded Width > 42.00: Nbr of Rolls
3. Items d-p below have been re-written due to the elimination of 48" cores. See new logic below, which replaces d-p. a and b above and q and r below remain the same:
4. If Box Core Item Nbr = 004975 and Folded Width <= 54.00: Folded Width / 60 x Nbr of Rolls (MD1)
5. If Box Core Item Nbr = 004975 and Folded Width > 54.00: Nbr of Rolls
6. If Box Core Item Nbr = 004977 and Folded Width <= 78.00: Nbr of Rolls
7. If Box Core Item Nbr = 004977 and Folded Width > 78.00: Nbr of Rolls
8. If Box Core Item Nbr = 004976 and Folded Width >= 6.10 <= 33.25: Nbr of Rolls / 3 (MD1)
9. If Box Core Item Nbr = 004976 and Folded Width < 6.10: Folded Width / 100 x Nbr of Rolls (MD1)
10. If Box Core Item Nbr = 004976 and Folded Width > 33.25 <= 49.75: Nbr of Rolls / 2 (MD1)
11. If Box Core Item Nbr = 004976 and Folded Width > 49.75: Nbr of Rolls
12. If Box Core Item Nbr = NONE (case packed): 0 SOR/ROLLSHEET/ROLLTUBE don't need this - always BOR
13. If Box Core Item Nbr = 004970 and Folded Width >= 53.00: Nbr of Rolls
14. If Box Core Item Nbr = 004970 and Folded Width >= 26.00 <= 28.00: Nbr of Rolls / 2 (MD1)
15. If Box Core Item Nbr = 004970 and Folded Width >= 17.00 <= 19.00: Nbr of Rolls / 3 (MD1)
16. If Box Core Item Nbr = 004970 and Folded Width >= 35.00 <= 37.00: Nbr of Rolls / 1.5 (MD1)
17. If Box Core Item Nbr = 004979 and Folded Width >= 43.00: Nbr of Rolls
18. If Box Core Item Nbr = 004979 and Folded Width >= 21.00 <= 23.00: Nbr of Rolls / 2 (MD1)
19. NEW LOGIC:
  1. If Box Core Item Nbr = 004975 and Folded Width <= 6.60: Nbr of Rolls / 9 (MD1)
  2. If Box Core Item Nbr = 004975 and Folded Width > 6.60 <= 7.50: Nbr of Rolls / 8 (MD1)
  3. If Box Core Item Nbr = 004975 and Folded Width > 7.50 <= 8.50: Nbr of Rolls / 7 (MD1)
  4. If Box Core Item Nbr = 004975 and Folded Width > 8.60 <= 10.00: Nbr of Rolls / 6 (MD1)
  5. If Box Core Item Nbr = 004975 and Folded Width > 10.40 <= 12.00: Nbr of Rolls / 5 (MD1)
  6. If Box Core Item Nbr = 004975 and Folded Width > 13.00 <= 15.00: Nbr of Rolls / 4 (MD1)
  7. If Box Core Item Nbr = 004975 and Folded Width > 17.30 <= 20.00: Nbr of Rolls / 3 (MD1)
  8. If Box Core Item Nbr = 004975 and Folded Width > 26.00 <= 30.00: Nbr of Rolls / 2 (MD1)
  9. If Box Core Item Nbr = 004975 and Folded Width > 52.00: Nbr of Rolls
  10. If Box Core Item Nbr = 004975 (doesn't meet above rules): Folded Width / 60 x Nbr of Rolls (MD1)
  11. If Box Core Item Nbr = 004977: Nbr of Rolls
  12. If Box Core Item Nbr = 004976 and Folded Width >= 6.10 <= 33.25: Nbr of Rolls / 3 (MD1)
  13. If Box Core Item Nbr = 004976 and Folded Width < 6.10: Folded Width / 100 x Nbr of Rolls (MD1)
  14. If Box Core Item Nbr = 004976 and Folded Width > 33.25 <= 49.75: Nbr of Rolls / 2 (MD1)
  15. If Box Core Item Nbr = 004976 and Folded Width > 49.75: Nbr of Rolls
  16. If Box Core Item Nbr = NONE: 0
  17. If Box Core Item Nbr = 004970 and Folded Width <= 6.75: Nbr of Rolls / 8 (MD1)
  18. If Box Core Item Nbr = 004970 and Folded Width > 6.75 <= 7.70: Nbr of Rolls / 7 (MD1)
  19. If Box Core Item Nbr = 004970 and Folded Width > 7.70 <= 9.00: Nbr of Rolls / 6 (MD1)
  20. If Box Core Item Nbr = 004970 and Folded Width > 9.20 <= 10.80: Nbr of Rolls / 5 (MD1)
  21. If Box Core Item Nbr = 004970 and Folded Width > 11.50 <= 13.50: Nbr of Rolls / 4 (MD1)
  22. If Box Core Item Nbr = 004970 and Folded Width > 15.30 <= 18.00: Nbr of Rolls / 3 (MD1)
  23. If Box Core Item Nbr = 004970 and Folded Width > 23.00 <= 27.00: Nbr of Rolls / 2 (MD1)
  24. If Box Core Item Nbr = 004970 and Folded Width > 46.00: Nbr of Rolls
  25. If Box Core Item Nbr = 004970 (doesn't meet above rules): Folded Width / 54 x Nbr of Rolls (MD1)
20. FURN:
21. Items iii-vi and x-xiii below have been re-written due to the elimination of 48" cores. See new logic below, which replaces these. i and II as well as vii-ix remain the same:
  1. If Box Core Item Nbr = 004974 and Folded Length <= 42.00: Folded Length / 48 x Nbr of Rolls (MD1)
  2. If Box Core Item Nbr = 004974 and Folded Length > 42.00: Nbr of Rolls
  3. If Box Core Item Nbr = 004975 and Folded Length <= 54.00: Folded Length / 60 x Nbr of Rolls (MD1)
  4. If Box Core Item Nbr = 004975 and Folded Length > 54.00: Nbr of Rolls
  5. If Box Core Item Nbr = 004977 and Folded Length <= 78.00: Nbr of Rolls
  6. If Box Core Item Nbr = 004977 and Folded Length > 78.00: Nbr of Rolls
  7. If Box Core Item Nbr = 004976 and Folded Length <= 33.25: Nbr of Rolls / 3 (MD1)
  8. If Box Core Item Nbr = 004976 and Folded Length > 33.25 <= 49.75: Nbr of Rolls / 2 (MD1)
  9. If Box Core Item Nbr = 004976 and Folded Length > 49.75: Nbr of Rolls
  10. If Box Core Item Nbr = 004970 and Folded Length >= 53.00: Nbr of Rolls
  11. If Box Core Item Nbr = 004970 and Folded Length >= 26.00 <= 28.00: Nbr of Rolls / 2 (MD1)
  12. If Box Core Item Nbr = 004970 and Folded Length >= 35.00 <= 37.00: Nbr of Rolls / 1.5 (MD1)
  13. If Box Core Item Nbr = 004970 and Folded Length >= 43.00: Nbr of Rolls
  14. NEW FURN LOGIC:
    1. If Box Core Item Nbr=004975 and Folded Length >=24.00 <=26.00 OR >30.00 <=52.00: Folded Length / 60 x Nbr of Rolls (MD1)
    2. If Box Core Item Nbr=004975 and Folded Length > 26.00 <= 30.00: Nbr of Rolls / 2 (MD1)
    3. If Box Core Item Nbr=004975 and Folded Length > 52.00: Nbr of Rolls
    4. If Box Core Item Nbr=004977: Nbr of Rolls
    5. If Box Core Item Nbr=004970 and Folded Length > 46.00: Nbr of Rolls
    6. If Box Core Item Nbr=004970 and Folded Length > 27.00 <= 46.00: Folded Length / 54 x Nbr of Rolls (MD1)
    7. If Box Core Item Nbr=004970 and Folded Length >= 24.00 <= 27.00: Nbr of Rolls / 2 (MD1)
    8. If Box Core Item Nbr=004979 and Folded Length >= 43.00: Nbr of Rolls
22. SOR - has same rules/calcs as bags (except where noted) with exception that it uses Width everywhere instead of Folded Width Same changes as BAGS
23. ROLLSHEET/ROLLTUBE - have same rules/calcs as bags (except where noted) with exception that it uses Width everywhere instead of Folded Width and Nbr of Rolls is the Quote Qty Ordered Same changes as BAGS
Box Core Plug Item Nbr (criteria 202):
1. If Case Packed: NONE SOR/ROLLSHEET/ROLLTUBE don't need - always BOR
2. If Bags on a Roll: Use item 004980
Box Core Plug Qty (criteria 203):
1. If Bags on a Roll: Nbr Rolls x 2 ROLLSHEET/ROLLTUBE-same rule-Nbr Rolls is the Quote Qty Ordered
2. If Case Packed: 0 SOR/ROLLSHEET/ROLLTUBE don't need - always BOR
Package Weight (criteria 261):
1. If Case Packed: Pkg Wgt for Box1 + Pkg Wgt for Box2 (from PKG_WEIGHTS Table, column WGT, using Box1 Item Nbr and Box2 Item Nbr) ROLLTUBE doesn't have this rule (always BOR)
  If BOR and Box Core Item Nbr is not 004976: Folded Width x .05 (MD1) ROLLTUBE has this rule, except uses Width instead of folded width and always BOR
2. If BOR and Box Core Item Nbr = 004976: Folded Width x .09 (MD1) ROLLTUBE has this rule, except uses Width instead of folded width and always BOR
3. FURN:
  1. If Folded Length < 84.00 and Roll Wgt <= 150.00 Lbs: Folded Length * .05
  2. If Folded Length >= 84.00 and Roll Wgt > 150.00 Lbs: Folded Length * .09
4. SOR/ROLLSHEET:
  1. If Depth > 0, Width > 48.00, Width-Depth > 40.00, Roll Wgt > 80.00: Width x .09 (MD1)
  2. If Width >= 6.10 < 84.00 and Roll Wgt <= 150.00: Width x .05 (MD1)
  3. If Width >= 84.00 OR Width < 6.10 OR Roll Wgt > 150.00: Width x .09 (MD1)
Low Weight (10%) Tolerance (criteria 273):
1. CSRL Wgt x .9 + Package Wgt (MD1)
Low Weight (4%) Tolerance (criteria 449):
1. CSRL Wgt x .96 + Package Wgt (MD1)
Target Wgt (criteria 272):
1. CSRL Wgt + Package Wgt (MD1)
High Weight (10%) Tolerance (criteria 274):
1. CSRL Wgt x 1.1 + Package Wgt (MD1)
High Weight (4%) Tolerance (criteria 450):
1. CSRL Wgt x 1.04 + Package Wgt (MD1)
BOR Add'l Pkg Wgt (criteria 301):
1. If Case Packed OR BOR and Cradlepacked OR BOR and Width+Depth < 54.00: 0 ***60.00 was changed to 54.00 5/2013 for Iowa line 10 FURN-Rule is Cradlepacked and Length+Depth < 54.00; SOR/ROLLSHEET/ROLLTUBE have same rule as BAGS (always BOR)
2. If BOR and Not Cradlepacked and Width+Depth >= 54.00: Box1 Wgt (scored sheet) + (Box2 Wgt (end cap) x 2) Note: Box Wgts from Table PKG_WEIGHTS, column WGT, using Box1 Item# and Box2 Item# ***60.00 was changed to 54.00 5/2013 for Iowa line 10 FURN-Rule is Not Cradlepacked and Length+Depthy >= 54.00; SOR/ROLLSHEET/ROLLTUBE have same rule as BAGS-always BOR
Get Resin %Reqd of all Resins needed for Job:
1. Hexene Pct Reqd (criteria 155): From SPLIT_RESIN Table, column HEXENE, using Resin Table Row Nbr
2. Octene Pct Reqd (criteria 156): From SPLIT_RESIN Table, column OCTENE, using Resin Table Row Nbr
3. Liner Pct Reqd (criteria 157): From SPLIT_RESIN Table, column LINER, using Resin Table Row Nbr
4. Repro Pct Reqd (criteria 159): From MAXLBS Table, column PCT REPRO, using Operation#1
5. PAS Pct Reqd (criteria 160): *** NO LONGER NEEDED - OBSOLETE
6. Aminefree Pink Pct Reqd (criteria 161):
  1. If SpecAS = AmineFree Pink and Milspec and (Premix=N OR Metallocene=Y OR Antiblock=Y OR UVI/UVA=Y): Use .06 (6%)
  2. If SpecAS = AmineFree Pink and Other Pct and ASPct # 6 OR SpecAS = AmineFree Pink and Linear Low Density OR SpecAS = AmineFree Pink and Other Pct and (Metallocene=Y OR AntiBlock=Y OR Premix=N OR UVI/UVA=Y): AntiStat Pct / 100 (MD3)
7. AntiStat Pct Reqd (criteria 162):
  1. If Material=Postal Approved: From SPLIT_RESIN Table, column ANTI-STAT, using Resin Table Row Nbr
  2. If Material=Anti Static, SpecAS=AmineFree Clear/Color, Milspec: Use .06 (6%)
  3. If Material=Anti Static, SpecAS-AmineFree Clear/Color, Other Pct: User Entered AS Pct / 100
8. Slip Pct Reqd (criteria 163):
  1. If High Slip=Y, Gauge > 1.50, Material is not Non Scratch OR High Slip=Y, Gauge > 1.00, Material is not Non Scratch, Case Packed OR High Slip=Y, Gauge > 1.00, Metallocene=N: Use .01 (1%) FURN/ROLLSHEET/ROLLTUBE rules for .01: If High Slip=Y, Gauge > 1.50, Material is not Non Scratch OR High Slip=Y, Gauge > 1.00, Material is not Non Scratch, Metallocene=N
  2. If High Slip=Y, Gauge <= 1.00, Material is not Non Scratch OR High Slip=Y, Gauge <= 1.50, Material is not Non Scratch, BOR, Metallocene=Y: Use .02 (2%)
  3. If Material=Non Scratch, High Slip=N: Use .03 (3%)
  4. If Material=Non Scratch, High Slip=Y: Use .04 (4%)
  5. If Material is not Non Scratch, High Slip=N: 0
9. Clarity Pct Reqd (criteria 165): From SPLIT_RESIN Table, column CLARITY, using Resin Table Row Nbr
10. Bareback Pct Reqd (criteria 166): From SPLIT_RESIN Table, column BAREBK, using Resin Table Row Nbr
11. Bareback Low Density Pct Reqd (criteria 158): From SPLIT_RESIN Table, column BRBKLOWD, using Resin Table Row Nbr
12. Anti-Block Pct Reqd (criteria 178): From SPLIT_RESIN Table, column ANTI-BLOCK, using Resin Table Row Nbr
13. VCI Clear Pct Reqd (criteria 213): From SPLIT_RESIN Table, column VCICLEAR, using Resin Table Row Nbr
14. VCI Blue Pct Reqd (criteria 214): From SPLIT_RESIN Table, column VCIBLUE, using Resin Table Row Nbr
15. VCI Yellow Pct Reqd (criteria 214): *** NO LONGER NEEDED
16. SlipBlock Pct Reqd (criteria 291): This is calculated by criteria 290 (slipblock swap) and fed back to this criteria
17. FURN/ROLLSHEET/ROLLTUBE have same rules as BAGS unless otherwise noted
18. SOR has all same rules as BAGS
Reduce Resin by UVI% (criteria 174):
1. If Resin Swapcode = 1 and UVI/UVA=Y: Clarity Pct Reqd = Clarity Pct Reqd - UVI/UVA Pct (Reduce Clarity%)
2. If Resin Swapcode = 3 and UVI/UVA=Y: Hexene Pct Reqd = Hexene Pct Reqd - UVI/UVA Pct (Reduce Hexene%)
3. If Resin Swapcode = 4 and UVI/UVA=Y: Liner Pct Reqd = Liner Pct Reqd - UVI/UVA Pct (Reduce Liner%)
4. If Resin Swapcode = 5 and UVI/UVA=Y: Octene Pct Reqd = Octene Pct Reqd - UVI/UVA Pct (Reduce Octene%)
5. If Resin Swapcode = 8 and UVI/UVA=Y: Bareback Pct Reqd = Bareback Pct Reqd - UVI/UVA Pct (Reduce Bareback%)
6. If Resin Swapcode = 9 and UVI/UVA=Y: Low Density Bareback Pct Reqd = Low Density Bareback Pct Reqd - UVI/UVA Pct (Reduce Low Density Bareback%)
7. iF UVI/UVA=N: 0
Reduce Resin by Metallocene% (criteria 277):
1. If Resin Swapcode = 1 and Metallocene=Y and Heat Profile is not A: Clarity Pct Reqd = Clarity Pct Reqd - Metallocene Pct (Reduce Clarity)
2. If Resin Swapcode = 1 and Metallocene=Y and Heat Profile = A: Clarity Pct Reqd = Clarity Pct Reqd - Metallocene Pct (Reduce Clarity) Also change Heat Profile to "B"
3. If Resin Swapcode = 3 and Metallocene=Y and Heat Profile is not A: Hexene Pct Reqd = Hexene Pct Reqd - Metallocene Pct (Reduce Hexene)
4. If Resin Swapcode = 3 and Metallocene=Y and Heat Profile = A: Hexene Pct Reqd = Hexene Pct Reqd - Metallocene Pct (Reduce Hexene) Also change Heat Profile to "B"
5. If Resin Swapcode = 4 and Metallocene=Y and Heat Profile is not A: Liner Pct Reqd = Liner Pct Reqd - Metallocene Pct (Reduce Liner)
6. If Resin Swapcode = 4 and Metallocene=Y and Heat Profile = A: Liner Pct Reqd = Liner Pct Reqd - Metallocene Pct (Reduce Liner) Also change Heat Profile to "B"
7. If Resin Swapcode = 5 and Metallocene=Y and Heat Profile is not A: Octene Pct Reqd = Octene Pct Reqd - Metallocene Pct (Reduce Octene)
8. If Resin Swapcode = 5 and Metallocene=Y and Heat Profile = A: Octene Pct Reqd = Octene Pct Reqd - Metallocene Pct (Reduce Octene) Also change Heat Profile to "B"
9. If Resin Swapcode = 6 and Metallocene=Y and Heat Profile is not A: ***NOT NEEDED (PAS%)
10. If Resin Swapcode = 6 and Metallocene=Y and Heat Profile = A: ***NOTE NEEDED (PAS%)
11. If Resin Swapcode = 7 and Metallocene=Y and Heat Profile is not A: AmineFree Pink Pct Reqd = AmineFree Pink Pct Reqd - Metallocene Pct (Reduce AmineFree Pink)
12. If Resin Swapcode = 7 and Metallocene=Y and Heat Profile = A: AmineFree Pink Pct Reqd = AmineFree Pink Pct Reqd - Metallocene Pct (Reduce AmineFree Pink) Also change Heat Profile to "B"
13. If Resin Swapcode = 8 and Metallocene=Y and Heat Profile is not A: Bareback Pct Reqd = Bareback Pct Reqd - Metallocene Pct (Reduce Bareback)
14. If Resin Swapcode = 8 and Metallocene=Y and Heat Profile = A: Bareback Pct Reqd = Bareback Pct Reqd - Metallocene Pct (Reduce Bareback) Also change Heat Profile to "B"
15. If Resin Swapcode = 9 and Metallocene=Y and Heat Profile is not A: Low Density Bareback Pct Reqd = Low Density Bareback Pct Reqd - Metallocene Pct (Reduce Low Density Bareback)
16. If Resin Swapcode = 9 and Metallocene=Y and Heat Profile = A: Low Density Bareback Pct Reqd = Low Density Bareback Pct Reqd - Metallocene Pct (Reduce Low Density Bareback) Also Change Heat Profile to "B"
17. If Metallocene=N: 0
Reduce Resin - LLDPE (criteria 284):
1. If Exclude LLDPE=Y and Heat Profile=D and Hexene% >= .50 and Resin Swapcode=3:
  1. Hexene Pct Reqd = Hexene Pct Reqd - .35
  2. Liner Pct Reqd = Liner Pct Reqd + .35
  3. Change Heat Profile to "B"
2. If Exclude LLDPE=Y and Heat Profile=D and Hexene% >= .40 < .50 and Resin Swapcode=3:
  1. Hexene Pct Reqd = Hexene Pct Reqd - .25
  2. Liner Pct Reqd = Liner Pct Reqd + .25
  3. Change Heat Profile to "B"
3. If Exclude LLDPE=Y and Heat Profile=D and Hexene% >= .35 < .40 and Resin Swapcode=3:
  1. Hexene Pct Reqd = Hexene Pct Reqd - .20
  2. Liner Pct Reqd = Liner Pct Reqd + .20
  3. Change Heat Profile to "B"
4. If Exclude LLDPE=Y and Heat Profile=D and < .35 and Resin Swapcode=3:
  1. Hexene Pct Reqd = Hexene Pct Reqd - .15
  2. Liner Pct Reqd = Liner Pct Reqd + .15
  3. Change Heat Profile to "B"
5. If Exclude LLDPE=Y and Heat Profile=D and Octene% >= .50 and Resin Swapcode=5:
  1. Octene Pct Reqd = Octene Pct Reqd - .35
  2. Liner Pct Reqd = Liner Pct Reqd + .35
  3. Change Heat Profile to "B"
6. If Exclude LLDPE=Y and Heat Profile=D and Octene% >= .40 < .50 and Resin Swapcode=5
  1. Octene Pct Reqd = Octene Pct Reqd - .25
  2. Liner Pct Reqd = Liner Pct Reqd + .25
  3. Change Heat Profile to "B"
7. If Exclude LLDPE=Y and Heat Profile=D and Octene% >= .35 < .40 and Resin Swapcode=5:
  1. Octene Pct Reqd = Octene Pct Reqd - .20
  2. Liner Pct Reqd = Liner Pct Reqd + .20
  3. Change Heat Profile to "B"
8. If Exclude LLDPE=Y and Heat Profile=D and Octene% < .35 and Resin Swapcode=5:
  1. Octene Pct Reqd = Octene Pct Reqd - .15
  2. Liner Pct Reqd = Liner Pct Reqd + .15
  3. Change Heat Profile to "B"
9. If Exclude LLDPE=N OR Heat Profile is not D: 0
Reduce Resin by AntiBlock (criteria 164):
1. If Resin Swapcode = 1 and Antiblock=Y: Clarity Pct Reqd = Clarity Pct Reqd - .01
2. If Resin Swapcode = 3 and Antiblock=Y: Hexene Pct Reqd = Hexene Pct Reqd - .01
3. If Resin Swapcode = 4 and Antiblock=Y: Liner Pct Reqd = Liner Pct Reqd - .01
4. If Resin Swapcode = 5 and Antiblock=Y: Octene Pct Reqd = Octene Pct Reqd - .01
5. If Resin Swapcode = 6 and Antiblock=Y: NOT NEEDED (PAS%)
6. If Resin Swapcode = 7 and Antiblock=Y: AmineFree Pink Pct Reqd = AmineFree Pink Pct Reqd - .01
7. If Antiblock=N: 0
Reduce Resin by High Slip (criteria 64):
1. If Resin Swapcode = 1, High Slip=Y, Gauge > 1.5 OR Swapcode=1, HighSlip=Y, Gauge > 1, BOR=N OR Swapcode=1, High Slip=Y, Gauge > 1, Metallocene=N: Clarity Pct Reqd = Clarity Pct Reqd - .01
2. If Resin Swapcode = 1, High Slip=Y, Gauge <= 1.0 OR Swapcode=1, HighSlip=Y, Gauge <= 1.5, BOR=Y, Metallocene=Y: Clarity Pct Reqd = Clarity Pct Reqd - .02
3. If Resin Swapcode = 3, High Slip=Y, Gauge > 1.5 OR Swapcode=3, HighSlip=Y, Gauge > 1, BOR=N OR Swapcode=3, High Slip=Y, Gauge > 1, Metallocene=N: Hexene Pct Reqd = Hexene Pct Reqd - .01
4. If Resin Swapcode = 3, High Slip=Y, Gauge <= 1.0 OR Swapcode=3, HighSlip=Y, Gauge <= 1.5, BOR=Y, Metallocene=Y:Hexene Pct Reqd = Hexene Pct Reqd - .02
5. If Resin Swapcode = 4, High Slip=Y, Gauge > 1.5 OR Swapcode=4, HighSlip=Y, Gauge > 1, BOR=N OR Swapcode=4, High Slip=Y, Gauge > 1, Metallocene=N: Liner Pct Reqd = Liner Pct Reqd - .01
6. If Resin Swapcode = 4, High Slip=Y, Gauge <= 1.0 OR Swapcode=4, HighSlip=Y, Gauge <= 1.5, BOR=Y, Metallocene=Y:Liner Pct Reqd = Liner Pct Reqd - .02
7. If Resin Swapcode = 5, High Slip=Y, Gauge > 1.5 OR Swapcode=5, HighSlip=Y, Gauge > 1, BOR=N OR Swapcode=5, High Slip=Y, Gauge > 1, Metallocene=N: Octene Pct Reqd = Octene Pct Reqd - .01
8. If Resin Swapcode = 5, High Slip=Y, Gauge <= 1.0 OR Swapcode=5, HighSlip=Y, Gauge <= 1.5, BOR=Y, Metallocene=Y:Octene Pct Reqd = Octene Pct Reqd - .02
9. If Resin Swapcode = 8 and Material = Non Scratch: Bareback Pct Reqd = Bareback Pct Reqd - Slip Pct Reqd
10. If Resin Swapcode = 9 and Material = Non Scratch: Low Density Bareback Pct Reqd=Low Density Bareback Pct Reqd - Slip Pct Reqd
11. If High Slip=N and Material is not Non Scratch: 0
Reduce Resin-Color Concentrate (criteria 76):
1. If Resin Swapcode = 3 and Color Conc Pct Reqd > 0: Hexene Pct Reqd = Hexene Pct Reqd - Color Conc Pct Reqd
2. If Resin Swapcode = 4 and Color Conc Pct Reqd > 0: Liner Pct Reqd = Liner Pct Reqd - Color Conc Pct Reqd
3. If Resin Swapcode = 5 and Color Conc Pct Reqd > 0: Octene Pct Reqd = Octene Pct Reqd - Color Conc Pct Reqd
4. If Resin Swapcode = 8 and Color Conc Pct Reqd > 0: Bareback Pct Reqd = Bareback Pct Reqd - Color Conc Pct Reqd
5. If Resin Swapcode = 9 and Color Conc Pct Reqd > 0: Low Density Bareback Pct Reqd = Low Density Bareback Pct Reqd - Color Conc Pct Reqd
6. If Color Conc Pct Reqd <= 0: 0
Slipblock Code Is (criteria 289):
1. From SPLIT_RESIN Table, column SLIPCODE, using Resin Table Row Nbr
Slipblock Resin Swap (criteria 290):
1. If True Gauge <= 1.00, Slipblock Code=1, High Slip=N OR Entered Gauge <= 1.50, Slipblock Code=1, BOR, Metallocene=Y, High Slip=N: Clarity Pct Reqd = Clarity Pct Reqd - .02, then set Slipblock Pct Reqd = .02
2. If True Gauge <= 1.00, Slipblock Code=3, High Slip=N OR Entered Gauge <= 1.50, Slipblock Code=3, BOR, Metallocene=Y, High Slip=N: Hexene Pct Reqd = Hexene Pct Reqd - .02, then set Slipblock Pct Reqd = .02
3. If True Gauge <= 1.00, Slipblock Code=4, High Slip=N OR Entered Gauge <= 1.50, Slipblock Code=4, BOR, Metallocene=Y, High Slip=N: Liner Pct Reqd = Liner Pct Reqd - .02, then set Slipblock Pct Reqd = .02
4. If True Gauge <= 1.00, Slipblock Code=5, High Slip=N OR Entered Gauge <= 1.50, Slipblock Code=5, BOR, Metallocene=Y, High Slip=N: Octene Pct Reqd = Octene Pct Reqd - .02, then set Slipblock Pct Reqd = .02
Reduce Resin-AntiStat (criteria 81):
1. If Material is not Anti Static: 0 (no swap needed)
2. If Material = Pink Antistat and Resin Swapcode=3: NO LONGER NEEDED
3. If Material = AmineFree Pink and Resin Swapcode=3: Hexene Pct Reqd=Hexene Pct Reqd - AmineFree Pink Pct Reqd
4. If Material = Pink Antistat and Resin Swapcode=4: NO LONGER NEEDED
5. If Material = AmineFree Pink and Resin Swapcode=4: Liner Pct Reqd=Liner Pct Reqd - AmineFree Pink Pct Reqd
6. If Material = AmineFree Clear/Color and Resin Swapcode=3: Hexene Pct Reqd=Hexene Pct Reqd - Antistat Pct Reqd
7. If Material = AmineFree Clear/Color and Resin Swapcode=4: Liner Pct Reqd=Liner Pct Reqd - Antistat Pct Reqd
8. If Material = AmineFree Clear/Color and Color=Clear and Resin Swapcode=1: Clarity Pct Reqd=Clarity Pct Reqd - Antistat Pct Reqd
Repro Swap (criteria 276):
1. If Mfg Facility=STERLING, #Resins Needed <=3, Resin Swapcode=3, Repro Pct Reqd > 0 OR Mfg Facility is not STERLING, #Resins Needed <=5, Resin Swapcode=3, Repro Pct Reqd > 0: Hexene Pct Reqd=Hexene Pct Reqd - Repro Pct Reqd
2. If didn't meet above criteria, zero out Repro Pct Reqd
Hexene Item Nbr (criteria 167):
1. If Hexene Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, Using "HEXENE"
2. If Hexene Pct Reqd <= 0: NONE
Octene Item Nbr (criteria 168):
1. If Octene Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, Using "OCTENE"
2. If Octene Pct Reqd <= 0: NONE
Liner Item Nbr (criteria 169):
1. If Liner Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, Using "LINER"
2. If Liner Pct Reqd <= 0: NONE
Bareback-Low Density Item Nbr (criteria 170):
1. If Bareback Low Density Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, Using "BBK-LOWDEN"
2. If Bareback Low Density Pct Reqd <= 0: NONE
Repro Item Nbr (criteria 171):
1. If Repro Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, Using "REPRO"
2. If Repro Pct Reqd <= 0: NONE
PAS Item Nbr (criteria 172): NO LONGER NEEDED
AmineFree Pink Item Nbr (criteria 173):
1. If AmineFree Pink Pct Reqd > 0 and (Resin Swpcode=6 or Resin Swapcode=7): From DATA_RESIN Table, column ITEM_NBR, using AMFREEPINK
2. If AmineFree Pink Pct Reqd > 0 and (Resin Swapcode=3 or Resin Swapcode=4): From KONCENTRATE Table, column ITEM_NBR, using "Amfree_Pink"
3. If AmineFree Pink Pct Reqd <= 0: NONE
Anti Static Item Nbr (criteria 62):
1. If Anti Static Pct Reqd > 0: From KONCENTRATE Table, column ITM_NBR, using "Anti_Static"
2. If Anti Static Pct Reqd <= 0: NONE
Slip Item Nbr (criteria 63):
1. If Slip Pct Reqd > 0: From KONCENTRATE Table, column ITM_NBR, using "Slip"
2. If Slip Pct Reqd <= 0: NONE
Clarity Item Nbr (criteria 65):
1. If Clarity Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, using "CLARITY"
2. If Clarity Pct Reqd <= 0: NONE
Bareback Item Nbr (criteria 66):
1. If Bareback Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, using "BAREBACK"
2. If Bareback Pct Reqd <= 0: NONE
Anti Block Item Nbr (criteria 179):
1. If Anti Block Pct Reqd >0 OR Anti Block=Y: From KONCENTRATE Table, column ITM_NBR, using "Anti_Block"
2. If Anti Block Pct Reqd <=0 and Anti Block=N: NONE
UVI/UVA Item Nbr (criteria 93):
1. If UVI/UVA = Y: From KONCENTRATE Table, column ITM_NBR, using "UVI_UVA"
Metallocene Item Nbr (criteria 279):
1. If Metallocene=Y: From KONCENTRATE Table, column ITM_NBR, using "Metallocene"
VCI Clear Item Nbr (criteria 216):
1. If VCI Clear Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, using "VCICLEAR"
2. If VCI Clear Pct Reqd <= 0: NONE
VCI Blue Item Nbr (criteria 217):
1. If VCI Blue Pct Reqd > 0: From DATA_RESIN Table, column ITEM_NBR, using "VCIBLUE"
2. If VCI Clear Pct Reqd <= 0: NONE
VCI Yellow Item Nbr (criteria 218): NO LONGER NEEDED
Slip Block Item Nbr (criteria 292):
1. If Slip Block Pct Reqd > 0: From KONCENTRATE Table, column ITM_NBR, using "Slip_Block"
2. If Slip Block Pct Reqd <= 0: NONE
Printer Ink Item Nbr (criteria 434):
1. If Printed=Y: From PRINTER_INK Table, column ITM_NBR, using Print Ink Color
Printer Ink Qty (criteria 440):

If Printed=Y: Executes SOPS9147.6 Image Height, Image Width, Bag Length, and Qty Ordered FURN passes Bag Width instead of Bag Length; ROLLSHEET/ROLLTUBE passes 2 add'l pieces of data: Feet Per Roll & Nbr of Rolls - also passes "RL" for Bag Length (because continuous)

Hexene $/LB (criteria 67):
1. If Hexene Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "HEXENE"
2. If Hexene Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "HEXENE"
3. If Hexene Pct Reqd <= 0: 0
Octene $/LB (criteria 68):
1. If Octene Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "OCTENE"
2. If Octene Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "OCTENE"
3. If Octene Pct Reqd <= 0: 0
Liner $/LB (criteria 69):
1. If Liner Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "LINER"
2. If Liner Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "LINER"
3. If Liner Pct Reqd <= 0: 0
Bareback-Low Density $/LB (criteria 70):
1. If Bareback LD Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "BBK-LOWDEN"
2. If Bareback LD Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "BBK-LOWDEN"
3. If Bareback LD Pct Reqd <= 0: 0
Repro $/LB (criteria 71):
1. If Repro Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "REPRO"
2. If Repro Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "REPRO"
3. If Repro Pct Reqd <= 0: 0
PAS $/LB (criteria 72): ***NO LONGER NEEDED
AmineFree Pink $/LB (criteria 73):
1. If AMF Pink Pct Reqd > 0, Resin Swapcode=6 or 7, and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "AMFREEPINK"
2. If AMF Pink Pct Reqd > 0, Resin Swapcode=6 or 7, and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "AMFREEPINK"
3. If AMF Pink Pct Reqd > 0, Resin Swapcode=3 or 4, and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "Amfree_Pink"
4. If AMF Pink Pct Reqd > 0, Resin Swapcode=3 or 4, and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "Amfree_Pink"
5. If AMF Pink Pct Reqd <= 0: 0
Anti-Static $/LB (criteria 74):
1. If Antistatic Pct Reqd > 0 and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "Anti_Static"
2. If Antistatic Pct Reqd > 0 and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "Anti_Static"
3. If Antistatic Pct Reqd <= 0: 0
Slip $/LB (criteria 75):
1. If Slip Pct Reqd > 0 and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "Slip"
2. If Slip Pct Reqd > 0 and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "Slip"
3. If Slip Pct Reqd <= 0: 0
Clarity $/LB (criteria 77):
1. If Clarity Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "CLARITY"
2. If Clarity Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "CLARITY"
3. If Clarity Pct Reqd <= 0: 0
Bareback $/LB (criteria 78):
1. If Bareback Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "BAREBACK"
2. If Bareback Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "BAREBACK"
3. If Bareback Pct Reqd <= 0: 0
Anti Block $/LB (criteria 180):
1. If (Anti Block Pct Reqd > 0 OR Antiblock=Y) and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "Anti_Block"
2. If (Anti Block Pct Reqd > 0 OR Antiblock=Y) and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "Anti_Block"
3. If Anti Block Pct Reqd <= 0 and Antiblock=N: 0
UVI/UVA $/LB (criteria 175):
1. If UVI/UVA=Y and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "UVI_UVA"
2. If UVI/UVA=Y and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "UVI_UVA"
3. If UVI/UVA=N: 0
Metallocene $/LB (criteria 280):
1. If Metallocene=Y and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "Metallocene"
2. If Metallocene=Y and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "Metallocene"
3. If Metallocene=N: 0
VCI Clear $/LB (criteria 219):
1. If VCI Clear Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "VCICLEAR"
2. If VCI Clear Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "VCICLEAR"
3. If VCI Clear Pct Reqd <= 0: 0
VCI Blue $/LB (criteria 220):
1. If VCI Blue Pct Reqd > 0 and Preferred Resin Price=N: From DATA_RESIN Table, column MATL_$, using "VCIBLUE"
2. If VCI Blue Pct Reqd > 0 and Preferred Resin Price=Y: From DATA_RESIN Table, column PREF_$, using "VCIBLUE"
3. If VCI Blue Pct Reqd <= 0: 0
VCI Yellow $/LB (criteria 221): NO LONGER NEEDED
Slipblock $/LB (criteria 293):
1. If Slipblock Pct Reqd > 0 and Preferred Resin Price=N: From KONCENTRATE Table, column MATL_$, using "Slip_Block"
2. If Slipblock Pct Reqd > 0 and Preferred Resin Price=Y: From KONCENTRATE Table, column PREF_$, using "Slip_Block"
3. If Slipblock Pct Reqd <= 0: 0
Calc Lbs Needed for each Resin/Concentrate (for BOM):
1. Color Concentrate (criteria 86): Color Conc Pct Reqd x Order Total Lbs (MD2)
2. Hexene (criteria 79): Hexene Pct Reqd x Order Total Lbs (MD2)
3. Octene (criteria 80): Octene Pct Reqd x Order Total Lbs (MD2)
4. Liner (criteria 90): Liner Pct Reqd x Order Total Lbs (MD2)
5. Bareback-Low Density (criteria 82): Bareback Low Density Pct Reqd x Order Total Lbs (MD2)
6. Repro (criteria 83): Repro Pct Reqd x Order Total Lbs (MD2)
7. PAS (criteria 84): ***NO LONGER NEEDED
8. AmineFree Pink (criteria 88): AmineFree Pink Pct Reqd x Order Total Lbs (MD2)
9. Anti Static Concentrate (criteria 87): Anti Static Pct Reqd x Order Total Lbs (MD2)
10. Slip Concentrate (criteria 89): Slip Pct Reqd x Order Total Lbs (MD2)
11. Clarity (criteria 85): Clarity Pct Reqd x Order Total Lbs (MD2)
12. Bareback (criteria 91): Bareback Pct Reqd x Order Total Lbs (MD2)
13. VCI Clear (criteria 222): VCI Clear Pct Reqd x Order Total Lbs (MD2)
14. VCI Blue (criteria 223): VCI Blue Pct Reqd x Order Total Lbs (MD2)
15. VCI Yellow (criteria 224): ***NO LONGER NEEDED
16. Anti Block Concentrate (criteria 181): If AntiBlock=Y, Order Total Lbs x .01 else Anti Block Pct Reqd (from resin table) x Order Total Lbs (MD2)
17. UVI/UVA Concentrate (criteria 176): UVI/UVA Pct Reqd x Order Total Lbs (MD2)
18. Metallocene (criteria 281): Metallocene Pct Reqd x Order Total Lbs (MD2)
19. Slipblock (criteria 294): Slipblock Pct Reqd x Order Total Lbs (MD2)
Actual Minimum Wgt (criteria 125): *** DON'T REALLY NEED ANYMORE - USE C35-MINIMUM LBS

If Min Wgt Due (Color) > Minimum Lbs: Use Min Wgt Due (color) ***DON'T NEED THIS ANY LONGER. CAN'T HAPPEN
If Min Wgt Due (Color) <= Minimum Lbs: Use Minimum Lbs

Minimum Rolls x2, x3, x4 (Minimum Qty for 3 breaks) (criteria 118,121,123):
1. This is for ROLLSHEET/ROLLTUBE only. It calcs the minimum #rolls for the 3 qty breaks (needed in the non-material discount% logic below). This is instead of Min Qty for Break1-3 below for other items that is calc'd by EPCS9007.1. EPCS9007.1 isn't executed for sheeting or tubing.
2. Minimum Qty for Break1 = ((Minimum Lbs / Roll Wgt) + .49) x 2
3. Minimum Qty for Break2 = ((Minimum Lbs / Roll Wgt) + .49) x 3
4. Minimum Qty for Break3 = ((Minimum Lbs / Roll Wgt) + .49) x 4
Non-Material Discount Pct (criteria 19):
1. If Operation#1 > 0 (should always have): Execute EPCS9007.1 passing warehouse#, Operation#1, Actual Min Nbr Bags, Qty Ordered, and Minimum Lbs (instead of Actual Min Wgt) in PARAMS. The program returns:
  1. Non Material Disc% (MD2)
  2. Backlog Days (passed to critiera 444 below)
  3. Min Qty for Break 1 (passed to criteria 118 below)
  4. Min Qty for Break 2 (passed to criteria 121 below)
  5. Min Qty for Break 3 (passed to criteria 123 below)
  6. Min Lbs for Break 1 (passed to criteria 36 below)
  7. Min Lbs for Break 2 (passed to criteria 37 below)
  8. Min Lbs for Break 3 (passed to criteria 38 below)
2. ROLLSHEET/ROLLTUBE - Use old 2x, 3x, 4x minimum qty logic: (doesn't call EPCS9007.1 and get returns for Min Qty or Min Lbs)
  1. If Quote Qty (#rolls) < Minimum Qty for Break1: 0% Discount
  2. If Quote Qty (#rolls) >= Minimum Qty for Break1 < Minimum Qty for Break2: 5% Discount
  3. If Quote Qty (#rolls) >= Minimum Qty for Break2 < Minimum Qty for Break3: 10% Discount
  4. If Quote Qty (#rolls) >= Minimum Qty for Break3: 15% Discount
Work Center Backlog Days (criteria 444):
1. Returned from EPCS9007.1 and passed into this criteria
2. ROLLSHEET/ROLLTUE - don't need this
Min Qty for Break1(criteria 118):
1. Returned from EPCS9007.1 and passed into this criteria
2. ROLLSHEET/ROLLTUBE - this was done right before the non-material discount% because it is needed to calc the discount
Min Qty for Break2 (criteria 121):
1. Returned from EPCS9007.1 and passed into this criteria
2. ROLLSHEET/ROLLTUBE - this was done right before the non-material discount% because it is needed to calc the discount
Min Qty for Break3 (criteria 123):
1. Returned from EPCS9007.1 and passed into this criteria
2. ROLLSHEET/ROLLTUBE - this was done right before the non-material discount% because it is needed to calc the discount
Quantity Break1 (criteria 355):
1. If Custom Break Qty1 > 0 (user entered): Use Custom Break Qty1
2. If Custom Break Qty1 <= 0: Use Min Qty for Break1
Quantity Break2 (criteria 356): ** Tests are done on BrkQty1 because maybe only entered 1 custom break
1. If Custom Break Qty1 > 0 (user entered): Use Custom Break Qty2
2. If Custom Break Qty1 <= 0: Use Min Qty for Break2
Quantity Break3 (criteria 357): ** Tests are done on BrkQty1 because maybe only entered 1 custom break
1. If Custom Break Qty1 > 0 (user entered): Use Custom Break Qty3
2. If Custom Break Qty1 <= 0: Use Min Qty for Break3
Quantity Break1 Non-Matl Disc% (criteria 358)
1. If Quantity Break1 > 0: Execute EPCS9007.1 passing warehouse#, Operation#1, Actual Min Nbr Bags, Quantity Break1 in PARAMS. From the program, we take PARMS(36)<2>:
  1. Discount Multplier (1-disc%)
2. ROLLSHEET/ROLLTUBE - If Quantity Break1 < Minimum Qty for Break1 : 1 (0%)
3. ROLLSHEET/ROLLTUBE - If Quantity Break1 >= Minimum Qty for Break1 < Minimum Qty for Break2: .95 (5%)
4. ROLLSHEET/ROLLTUBE - If Quantity Break1 >= Minimum Qty for Break2 < Minimum Qty for Break3: .90 (10%)
5. ROLLSHEET/ROLLTUBE - If Quantity Break1 >= Minimum Qty for Break3: .85 (15%)
Quantity Break2 Non-Matl Disc% (criteria 359):
1. If Quantity Break2 > 0: Execute EPCS9007.1 passing warehouse#, Operation#1, Actual Min Nbr Bags, Quantity Break2 in PARAMS. From the program, we take PARMS(36)<2>:
  1. Discount Multplier (1-disc%)
2. ROLLSHEET/ROLLTUBE - If Quantity Break2 < Minimum Qty for Break1 : 1 (0%)
3. ROLLSHEET/ROLLTUBE - If Quantity Break2 >= Minimum Qty for Break1 < Minimum Qty for Break2 : .95 (5%)
4. ROLLSHEET/ROLLTUBE - If Quantity Break2 >= Minimum Qty for Break2 < Minimum Qty for Break3: .90 (10%)
5. ROLLSHEET/ROLLTUBE - If Quantity Break2 >= Minimum Qty for Break3 : .85 (15%)
Quantity Break3 Non-Matl Disc% (criteria 360):
1. If Quantity Break3 > 0: Execute EPCS9007.1 passing warehouse#, Operation#1, Actual Min Nbr Bags, Quantity Break3 in PARAMS. From the program, we take PARMS(36)<2>:
  1. Discount Multplier (1-disc%)
2. ROLLSHEET/ROLLTUBE - If Quantity Break3 < Minimum Qty for Break1 : 1 (0%)
3. ROLLSHEET/ROLLTUBE - If Quantity Break3 >= Minimum Qty for Break1 < Minimum Qty for Break2: .95 (5%)
4. ROLLSHEET/ROLLTUBE - If Quantity Break3 >= Minimum Qty for Break2 < Minimum Qty for Break3 : .90 (10%)
5. ROLLSHEET/ROLLTUBE - If Quantity Break3 >= Minimum Qty for Break3: .85 (15%)
Minimum Lbs x Break1 (criteria 36):
1. Passed from EPCS9007.1 via 'Calc Non-Material Disc% (criteria 19) in PARMS8< 36,7>
2. ROLLSHEET/ROLLTUBE: Minimum Lbs x 2 (MD1) **EPCS9007.1 isn't executed
Minimum Lbs x Break2 (criteria 37):
1. Passed from EPCS9007.1 via 'Calc Non-Material Disc% (criteria 19) in PARMS8< 36,8>
2. ROLLSHEET/ROLLTUBE: Minimum Lbs x 3 (MD1) **EPCS9007.1 isn't executed
Minimum Lbs x Break3 (criteria 38):
1. Passed from EPCS9007.1 via 'Calc Non-Material Disc% (criteria 19) in PARMS8< 36,9>
2. ROLLSHEET/ROLLTUBE: Minimum Lbs x 4 (MD1) **EPCS9007.1 isn't executed
Qty Break1 Weight (criteria 361): (Test is on Price Break1 Qty)
1. If Price Break1 Custom Qty > 0: Quantity Break1 x Yield per 1000 Bags
2. If Price Break1 Custom Qty <= 0: Use MinLbsxBreak1(criteria 36) ROLLSHEET/ROLLTUBE-Minimum Lbs x 2 (MD1)
Qty Break2 Weight (criteria 362): (Test is on Price Break1 Qty)
1. If Price Break1 Custom Qty > 0: Quantity Break2 x Yield per 1000 Bags
2. If Price Break1 Custom Qty <= 0: Use MinLbsxBreak2(criteria 37) ROLLSHEET/ROLLTUBE-Minimum Lbs x 3 (MD1)
Qty Break3 Weight (criteria 363): (Test is on Price Break1 Qty)
1. If Price Break1 Custom Qty > 0: Quantity Break3 x Yield per 1000 Bags
2. If Price Break1 Custom Qty <= 0: Use MinLbsxBreak3(criteria 38) ROLLSHEET/ROLLTUBE-Minimum Lbs x 2 (MD1)
Draw Length Upcharge Pct (criteria 400):
1. If Not Sleeves, Bottomseal, and Length < Minimum Length with No Upcharge: (Minimum Length with no Upcharge - Length) / Length
2. If Not Sleeves OR Sideweld OR Length >= Minimum Length with No Upcharge: 0
3. FURN doesn't have this criteria
4. SOR/ROLLSHEET/ROLLTUBE don't have this criteria
Non-Material $/LB (criteria 34):
1. Add the Draw Length Upcharge to the Non-Material $/LB from the table: (Draw Length Upcharge Pct x (Non Matl $/LB from Operation Table, column NON_MATL$, using Bubblesize)) + (Non Matl $/LB from table)
2. FURN - Just uses table entry: Operation Table, column NON_MATL$, using Bubblesize
3. SOR/ROLLSHEET/ROLLTUBE - Just use table entry: Operation Table, column NON_MATL$, using Bubblesize
Total Non-Material $$ (criteria 40):
1. (Order Total Lbs x Non-Material $/LB) x (1 - Non Material Discount Pct) (MD2)
Total Resin $$ (criteria 41):
1. Hexene $/LB x Hexene Lbs +
2. Octene $/LB x Octene Lbs +
3. Liner $/LB x Liner Lbs +
4. Bareback Low Density $/LB x BarebackLow Density LBS +
5. Repro $/LB x Repro Lbs +
6. PAS $/LB x PAS Lbs (no longer needed) +
7. AmineFree Pink $/LB x AmineFree Pink Lbs +
8. Clarity $/LB x Clarity Lbs +
9. Bareback $/LB x Bareback Lbs +
10. VCI Clear $/LB x VCI Clear Lbs +
11. VCI Blue $/LB x VCI Blue Lbs +
12. VCI Yellow $/LB x VCI Yellow LBS (no longer needed) +
13. Slipblock $/LB x Slipblock Lbs
14. MD3
Color Concentrate $$ (criteria 94):
1. Color Concentrate $/LB x Color Concentrate Lbs (MD3)
Anti Static Concentrate $$ (criteria 95):
1. Anti Static Concentrate $/LB x Anti Static Concentrate Lbs (MD3)
Slip Concentrate $$ (criteria 97):
1. Slip Concentrate $/LB x Slip Concentrate Lbs (MD3)
Anti Block Concentrate $$ (criteria 182):
1. Anti Block $/LB x Anti Block Lbs (MD3)
UVI/UVA Concentrate $$ (criteria 177):
1. UVI/UVA $/LB x UVI/UVA Lbs (MD3)
Metallocene $$ (criteria 282):
1. Metallocene $/LB x Metallocene Lbs
Total Material $$ (criteria 42):
1. Total Resin $$ +
2. Color Concentrate $$ +
3. Anti Static Concentrate $$ +
4. Slip Concentrate $$ +
5. Anti Block Concentrate $$ +
6. UVI/UVA Concentrate $$ +
7. Metallocene $$
8. MD3
Color Upcharge (criteria 135):
1. If Color Job and Order Total Lbs < 5000.00: Order Total Lbs x .05 (MD3)
2. If Color Job and Order Total Lbs >= 5000.00: Order Total Lbs x .03 (MD3)
3. If not a color job: 0
Price Class Upcharge (criteria 45):
1. If Price Class = 01 (Laddawn): 0
2. If Price Class = 02 (NEPB): (Total Non-Material $$ + Total Material $$ + Color Upcharge) x .20 (MD3)
Full Gauge Upcharge Base (criteria 101):
1. Total Non-Material $$ + Total Material $$ + Price Class Upcharge + Color Upcharge (MD2)
Full Gauge Upcharge (criteria 43):
1. If Full Gauge: Full Gauge Upcharge Base x .10
2. If not Full Gauge: 0
3. ROLLSHEET/ROLLTUBE - If Full Gauge=Y: Full Gauge Upcharge Base x 0.00 ...12/6/13 - David confirmed with Owen that we will continue to bypass full gauge upcharges for ROLLSHEET and ROLLTUBE
Order Wgt w/Packaging & Skids (criteria 120):
1. Executes SOPS9097.2 passing in PARAMS: Width (FURN pass Length), BOR Flag (FURN/SOR/ROLLSHEET/ROLLTUBE pass null), Full Gauge?, Cradlepacked?, Entered Gauge, True Gauge, Package Weight, Order Total Lbs, Nbr of CSRL (ROLLSHEET/ROLLTUBE-this is quote qty), Box1 Item Nbr, Box2 Item Nbr, "1" (ROLLSHEET/ROLLTUBE pass "0" instead of "1").
2. SOPS9097.2 returns New Order Weight including pkg and skids (in PARMS(8)<5>), #Pallets (passed to criteria 322 from PARMS(8)<8>), and Order Wgt with Pkg (not incl skids - passed to criteria 324 from PARMS(8)<9>)
Order Wgt w/Packaging (criteria 324):
1. Passed from criteria 120 above (from SOPS9097.2). This weight doesn't include skid weight
Nbr of Pallets (criteria 322):
1. Passed from criteria 120 above (from SOPS9097.2)
Total Shipping $$ (criteria 21):
1. If FOB: 0
2. If Prepaid: Executes SOPS9097.1, passing Whs#, Zip Code, and Order Wgt w/Packaging&Skids. Accepts Freight$ from PARMS(8) field 3. (MD2)
Venting Upcharge (criteria 323):
1. If Vented and Mfg Facility = Sterling: From Table PKG_CHARGES, column FLAT RATE-MA, using VENTING
2. If Vented and Mfg Facility = Texas: From Table PKG_CHARGES, column FLAT RATE-TX, using VENTING
3. If Vented and Mfg Facility = Iowa: From Table PKG_CHARGES, column FLAT RATE-IA, using VENTING
4. If not Vented: 0.00
Folded Bag Upcharge (criteria 413):
1. If Fold Bags in Half and Mfg Facility=Sterling: From Table PKG_CHARGES, column FLAT RATE-MA, using FOLDED
2. If Fold Bags in Half and Mfg Facility=Texas: From Table PKG_CHARGES, column FLAT RATE-TX, using FOLDED
3. If Fold Bags in Half and Mfg Facility=Iowa: From Table PKG_CHARGES, column FLAT RATE-IA, using FOLDED
4. If Not Folded: 0.00
5. FURN/SOR/ROLLSHEET/ROLLTUBE don't need this
Calculate all Packaging Upcharges (criteria 316):
1. If Not Std Pallet OR Nbr Pkgs per Pallet > 0 OR Max Stacked Hgt > 0 OR Max Wgt per Pallet > 0 OR Not Std Cartons OR Individually Boxed, BOR=Y and Width (FURN uses Length) >= 14.00: Executes SOPS9097.3 passing the following via PARAMS:
  1. PARAMS<1> = Warehouse
  2. PARAMS<2> = Order Wgt w/Packaging
  3. PARAMS3 = Nbr of Pallets
  4. PARAMS<4> = Std Pallet?
  5. PARAMS<5> = Nbr of Pkgs per Pallet
  6. PARAMS<6> = Max Stacked Pallet Hgt (in inches)
  7. PARAMS<7> = Max Wgt per Pallet
  8. PARAMS<8> = Std Cartons? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Standard Cartons" because always on a Roll
  9. PARAMS<9> = Std Roll Pkg?
  10. PARAMS<10>=Nbr of Rolls ROLLSHEET/ROLLTUBE pass Quote Qty
  11. PARAMS<11>=On Rolls? ROLLSHEET/ROLLTUBE-always Y
  12. PARAMS<12>=Width FURN passes Length
  13. PARAMS<13>=Box1 Total Qty Reqd
  14. PARAMS<14>=Box1 Item Nbr
  15. PARAMS<15>=Box2 Total Qty Reqd
  16. PARAMS<16>=Box2 Item Nbr
  17. NOTE: SOPS9097.3 needs to be copied to WEB. program, then all packaging upcharges except for Export Pallets removed. This logic will now be called from the Cart area, where Non-standard pallet types and #pkgs/hgt/wgt can be chosen. We will no longer be charging for extra pallets due to #pkgs/hgt/wgt choices
2. Received back from SOPS9097.3:
  1. Non Std Pallet Charge in PARMS(8)<10> - passed on to criteria 321
  2. #Pkgs Upcharge in PARMS(8)<11> - passed on to criteria 326
  3. Pallet Hgt Upcharge in PARMS(8)<12> - passed on to criteria 329
  4. Pallet Wgt Upcharge in PARMS(8)<13> - passed on to criteria 332
  5. Poly Lining Upcharge in PARMS(8)<14> - passed on to criteria 333 FURN doesn't need this
  6. Individually Boxed Upcharge in PARMS(8)<15> - passed on to criteria 334
Non-Std Pallet Upcharge (criteria 321): We will only be charging for Export Pallets
1. Receives Upcharge $$ from calculation above
Non-Std #Pkgs Upcharge (criteria 326): This charge is obsolete
1. Receives Upcharge $$ from calculation above
Non-Std Height Upcharge (criteria 329): This charge is obsolete
1. Receives Upcharge $$ from calculation above
Non-Std Weight Upcharge (criteria 332): This charge is obsolete
1. Receives Upcharge $$ from calculation above
Poly Line Upcharge (criteria 333):
1. Receives Upcharge $$ from calculation above
BOR Boxing Upcharge (criteria 334):
1. Receives Upcharge $$ from calculation above
Total Misc $$ (criteria 103):
1. Order Qty x Miscellaneous $$ (MD2) Note: Misc$ is currently entered in item's UOM (ie, M or RL or LB)
Subtotal for Adjustment $ (criteria 404):
1. (Order Total Lbs x Non-Matl $/LB) x (1 - Non-Matl Disc%) + Material $$ + Shipping $$ + NEPB Price Class Upcharge + Full Gauge Upcharge + Color Upcharge + Total Misc $$ + Non-Std Pallet Upchg + Venting Upchg + #Pkgs Upchg + Hgt Upchg + Wgt Upchg + Poly Line Upchg + BOR Boxing Upchg + Folded Upchg
Calc Adjust $$ and Adjust $$/LB (criteria 405):
1. If Quote Adjust% is not 0 (can be + or -): Executes SOPS9125.1 passing Quote Adj% from Avante, Subtotal for Adj$, Order Total Lbs
2. Adjustment $/LB returned from SOPS9125.1 in PARMS(8)<20>
3. Calcs new Non Matl $/lb: Adjust $/LB + Non-Matl $/LB -> passed back to Non Matl $/LB field
4. Calcs new Total Non Material $$: (Order Total Lbs x New Non Matl $/lb calc'd in (c.) above) x (1 - Non Matl Disc%) (MD2) -> passed back to Total Non Material $$
Printing Upcharge (criteria 435):
1. If Printed: (Non Material $$ + Material $$ + Full Gauge Upchg + Color Upchg + Price Class Upchg + Non Std Pallet Upchg + Venting Upchg + #Pkgs Upchg + Hgt Upchg + Wgt Upchg + Poly Line Upchg + BOR Box Upchg + Folded Upchg) -> this $$ is passed to SOPS9147.5 along with:
  1. Image Height
  2. Image Width
  3. Ink Item#
  4. Bag Length FURN passes Bag Width; ROLLSHEET/ROLLTUBE pass "RL" (continuous)
  5. Qty Ordered
  6. Total Calc'd above
  7. Whs#
  8. ROLLSHEET/ROLLTUBE only - passes Nbr of Feet per Roll
  9. ROLLSHEET/ROLLTUBE only - passes Nbr of Rolls (which is the quote qty)
2. Printing Upchg $$ passed back from SOPS9147.5 in PARMS(8)<29>
TOTAL PRICE (criteria 46) *** This is an extended amount, not a unit price:
1. Total Non-Material $$ +
2. Total Material $$ +
3. Total Shipping $$ +
4. Price Class Upcharge +
5. Full Gauge Upcharge +
6. Color Upcharge +
7. Total Misc $$ +
8. Non-Std Pallet Upcharge +
9. Venting Upcharge +
10. Non-Std #Pkgs Upcharge +
11. Non-Std Height Upcharge +
12. Non-Std Weight Upcharge +
13. Poly Line Upcharge +
14. BOR Boxing Upcharge +
15. Folded Bag Upcharge +
16. Printing Upcharge
Unit of Measure (criteria 99):
1. Set to 'M' for BAGS, FURN, and SOR
2. Set to "RL" for ROLLSHEET and ROLLTUBE
3. Set to "LB" for SHEETING and TUBING *** these will not be part of Phase I of new site

************** Price Breaks ********************

Note: Price Break Quantities are either up to 3 custom quantities selected by the customer or the next 3 quantity breaks where the non-material disc% given is > than the previous break price.

Price Break Non-Material $/LB(criteria 112):
1. Get Non-Material $/LB from Operation Table again from column NON_MATL$, using Bubblesize
2. Non-Material $/Lb + (Draw Length Upcharge% x Non-Material $/Lb) (MD3)
3. this has to be recalc'd because criteria 34 above has already had a quote adj% applied to it (it is passed back from criteria 405-Calc Quote Adj$)
4. FURN gets from table again (doesn't have draw length upcharge)
5. SOR/ROLLSHEET/ROLLTUBE get from table again (don't have draw length upcharge)
Price Break Material $/LB (criteria 113):
1. Total Material $$ / Order Total Pounds (MD2)
Price Break Price Class Upcharge $/Lb (criteria 115):
1. Price Class Upcharge / Order Total Pounds (MD2)
Price Break Full Gauge Upcharge $/Lb (criteria 116):
1. Full Gauge Upcharge / Order Total Pounds (MD4)
Price Break Full Gauge Upcharge Pct (criteria 131):
1. If Full Gauge: 0.10
2. If Nominal Gauge: 0.00
3. ROLLSHEET/ROLLTUBE don't have this
Price Break Price Class Pct (criteria 132):
1. Laddawn Customer: 0.00
2. NEPB Customer: 0.20
3. ROLLSHEET/ROLLTUBE don't have this
Price Break Misc $/Lb (criteria 117):
1. Total Misc $$ / Order Total Pounds (MD2)
Price Break Color Upcharge $/Lb (criteria 139):
1. Color Upcharge / Order Total Pounds (MD3)
$/Lb Less NonMtl/Shipping (criteria 120):
1. ROLLSHEET/ROLLTUBE has following formula, but doesn't appear to use it anywhere:
2. Price Class $/lb + Full Gauge $/Lb + Misc $/Lb + Material $/Lb + Color Upchg $/Lb
Break1 - Color Upcharge (criteria 136):
1. If Color Job and Qty Break1 Weight < 5000.00: Qty Break1 Weight x .05 (MD3)
2. If Color Job and Qty Break1 Weight >= 5000.00: Qty Break1 Weight x .03 (MD3)
3. If Clear Job: 0.00
Break1 - Nbr of RL/CS (criteria 286):
1. ((Quantity Break1 x 1000) / Bags per Cs/Rl) + .49 (always round up to MD0)
2. ROLLSHEET/ROLLTUBE don't have this (because Break1 Nbr of Rolls has already been calc'd since Uom is RL). This calc is only needed for custom items in Uom "M".
Break1 - Wgt w/Packaging & Skids (criteria 341):
1. Break1 Wgt with no Pkg = Quantity Break1 x Yield per 1000 Bags
2. Execute SOPS9097.2 to calculate weight that includes packaging & skids, passing in:
  1. Width FURN passes Length
  2. BOR Flag FURN passes "Y" (always on a roll); SOR/ROLLSHEET/ROLLTUBE pass null but s/b Y (always on roll)
  3. Full Gauge Flag
  4. Cradlepack Flag
  5. Entered Gauge
  6. True Gauge
  7. Package Weight
  8. Break1 Weight (calc'd above)
  9. Break1 - Nbr of RL/CS ROLLSHEET/ROLLTUBE pass Quantity Break1 (because in rolls)
  10. Box1 Item#
  11. Box2 Item#
  12. Not At True Gauge ("1" for BAGS, FURN, SOR because weight is calc'd at entered gauge regardless of FG flag); ROLLSHEET/ROLLTUBE pass "0".
3. Wgt with Pkg & Skids included is accepted back in this criteria via PARMS(8)<5>
4. Break1 Nbr of Pallets is accepted back in PARMS(8)<8> and passed on to criteria 325
5. Order Wgt with Pkg (no skids) is accepted back in PARMS(8)<9> and passed on to criteria 335
Break1 - Nbr of Pallets (criteria 325):
1. Data is passed here from criteria 341 above
Break1 - Weight w/Pkg (criteria 335):
1. Data is passed here from criteria 341 above
Break1 - BOR Box1 Qty (criteria 379):
1. If Box1 Qty Per > 0, Cradlepacked, Width (FURN uses Length) < 70.00 OR Box1 Qty Per >= 1: Break1 Nbr of RL/CS x Box1 Qty Per + .49 (always round up to MD0)
2. If Box1 Qty Per > 0, Cradlepacked, Width (FURN uses Length) >= 70.00: (Box1 Qty Per x 1.5) x Break1 Nbr of RL/CS (MD0)
3. If Box1 Qty Per > 0 < 1 (bundles) and Not Cradlepacked: Break1 Nbr of RL/CS x Box1 Qty Per (MD2)
4. If Box1 Qty Per <= 0: 0
Break1 - BOR Box2 Qty (criteria 380):
1. If Cradlepacked: 0
2. If Box2 Qty Per >= 1: (Break1 Nbr of RL/CS x Box2 Qty Per) + .49 (always round up to MD0)
3. If Box2 Qty Per > 0 < 1 (bundles) and Not Cradlepacked: Break1 Nbr of RL/CS x Box2 Qty Per (MD2)
4. If Box1 Qty Per <= 0: 0
Break1 - Total Pkg Upcharge (criteria 327):
1. If Quantity Break1 <= 0: 0
2. If Quantity Break1 > 0: Execute SOPS9097.3 passing same variables as shown above, except swap order info (like qty, wgt) for Break1 info:
  1. PARAMS<1> = Warehouse
  2. PARAMS<2> = Break1 Wgt w/Packaging
  3. PARAMS3 = Break1 Nbr of Pallets
  4. PARAMS<4> = Std Pallet?
  5. PARAMS<5> = Nbr of Pkgs per Pallet
  6. PARAMS<6> = Max Stacked Pallet Hgt (in inches)
  7. PARAMS<7> = Max Wgt per Pallet
  8. PARAMS<8> = Std Cartons? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Standard Cartons" - always on a roll
  9. PARAMS<9> = Std Roll Pkg?
  10. PARAMS<10>=Break1 Nbr of Rolls/Cases
  11. PARAMS<11>=On Rolls? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Y" - always on a roll
  12. PARAMS<12>=Width FURN passes Length
  13. PARAMS<13>=Break1 BOR Box1 Qty
  14. PARAMS<14>=Box1 Item Nbr
  15. PARAMS<15>=Break1 BOR Box2 Qty
  16. PARAMS<16>=Box2 Item Nbr
Break1 - Shipping $$ (criteria 114):
1. If Not Prepaid OR Quantity Break1 <= 0: 0
2. If Prepaid: Execute SOPS9097.1 passing warehouse, zipcode and Break1 Wgt w/Packaging & Skids
3. Ship$ sent back in PARMS(8)< 3>
Break1 - Subtotal (criteria 402):
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break1 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break1 Wgt = Quantity Break1 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break1 Wgt
5. Total Material $$ = Material $/lb x Break1 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break1 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. Break Misc $$ = Misc $$ x Quantity Break1
13. Subtotal = Subtotal + Break Misc $$
14. Subtotal = Subtotal + Break1 Shipping $$
15. Subtotal = Subtotal + Venting Upcharge
16. Subtotal = Subtotal + Break1 Total Pkg Upcharge
17. Final Subtotal = Subtotal + Break1 Folded Bag Upcharge
Break1 - Adjust $/LB (criteria 403):
1. If Quote Adj Pct from Avante # 0 (it can be + or -); Execute SOPS9125.1 passing Quote Adj Pct from Avante, Break1 Subtotal, and Qty Break1 Wgt
2. Information is passed back via PARMS(8)<20>
3. If Quote Adj Pct = 0: 0
Break 1 - Printing Upcharge (criteria 436):

If Printed = N: 0
If Printed = Y:

Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break1 Non-Matl Disc%
Material $/lb = Total Material $$ / Order Total Lbs
Break1 Wgt = Quantity Break1 x Yield per 1000 Bags
Total Non-Material $$ = Discounted Non-Matl $/LB x Break1 Wgt
Total Material $$ = Material $/lb x Break1 Wgt
Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
Subtotal = Subtotal + Break1 Color Upcharge
Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
Subtotal = Subtotal + Break Full Gauge Upcharge $
note: We don't include Misc$ or Shipping$ in this subtotal
Subtotal = Subtotal + Venting Upcharge
Subtotal = Subtotal + Break1 Total Pkg Upcharge
Subtotal = Subtotal + Break1 Folded Bag Upcharge
Discounted Adjust $/Lb = Break1 Adjust $/Lb x Quantity Break1 Non-Matl Disc%
Adjust $$ = Break1 Wgt (from above iii.) x Discounted Adjust $/Lb
Final Subtotal = Subtotal + Adjust $$
Execute SOPS9147.5 passing: SHOP.IMAGEHGT, SHOP.IMAGEWID, Printer Ink Item#, Length (FURN passes Width; ROLLSHEET/ROLLTUBE pass "RL"), Quantity Break1, Final Subtotal, Warehouse
Break1 Printing Upcharge will be returned in PARMS(8)<29>

Break1 - Total Price (criteria 119):
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break1 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break1 Wgt = Quantity Break1 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break1 Wgt
5. Total Material $$ = Material $/lb x Break1 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break1 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. Break Misc $$ = Misc $$ x Quantity Break1
13. Subtotal = Subtotal + Break Misc $$
14. Subtotal = Subtotal + Break1 Shipping $$
15. Subtotal = Subtotal + Venting Upcharge
16. Subtotal = Subtotal + Break1 Total Pkg Upcharge
17. Subtotal = Subtotal + Break1 Folded Bag Upcharge
18. Discounted Adjust $/Lb = Break1 Adjust $/Lb x Quantity Break1 Non-Matl Disc%
19. Adjust $ = Discounted Adjust $/Lb x Break1 Wgt
20. Subtotal = Subtotal + Adjust $
21. Total Price = Subtotal + Break1 Printing Upcharge (MD4)
Break1 - Price/M (unit price) (criteria 126):
1. Break1 Total Price / Quantity Break1 (MD4)
Break2 - Color Upcharge (criteria 137):
1. If Color Job and Qty Break2 Weight < 5000.00: Qty Break2 Weight x .05 (MD3)
2. If Color Job and Qty Break2 Weight >= 5000.00: Qty Break2 Weight x .03 (MD3)
3. If Clear Job: 0.00
Break2 - Nbr of RL/CS (criteria 287):
1. ((Quantity Break2 x 1000) / Bags per Cs/Rl) + .49 (always round up to MD0)
2. ROLLSHEET/ROLLTUBE don't have this (because Break2 Nbr of Rolls has already been calc'd since Uom is RL). This calc is only needed for custom items in Uom "M".
Break2 - Wgt w/Packaging & Skids (criteria 342):
1. Break2 Wgt with no Pkg = Quantity Break2 x Yield per 1000 Bags
2. Execute SOPS9097.2 to calculate weight that includes packaging & skids, passing in:
  1. Width FURN passes Length
  2. BOR Flag FURN pass "Y" - always on a roll; SOR/ROLLSHEET/ROLLTUBE pass null but s/b Y (always on roll)
  3. Full Gauge Flag
  4. Cradlepack Flag
  5. Entered Gauge
  6. True Gauge
  7. Package Weight
  8. Break2 Weight (calc'd above)
  9. Nbr of RL/CS ROLLSHEET/ROLLTUBE pass Quantity Break2 (because in rolls)
  10. Box1 Item#
  11. Box2 Item#
  12. Not At True Gauge ("1" for BAGS, FURN, SOR because weight is calc'd at entered gauge regardless of FG flag) ROLLSHEET/ROLLTUBE pass "0"
3. Wgt with Pkg & Skids included is accepted back in this criteria via PARMS(8)<5>
4. Break2 Nbr of Pallets is accepted back in PARMS(8)<8> and passed on to criteria 328
5. Break2 Wgt with Pkg (no skids) is accepted back in PARMS(8)<9> and passed on to criteria 330
Break2 - Nbr of Pallets (criteria 328):
1. Data is passed here from criteria 342 above
Break2 - Weight w/Pkg (criteria 330):
1. Data is passed here from criteria 342 above
Break2 - BOR Box1 Qty (criteria 381):
1. If Box1 Qty Per > 0, Cradlepacked, Width (FURN uses Length) < 70.00 OR Box1 Qty Per >= 1: Break2 Nbr of RL/CS x Box1 Qty Per + .49 (always round up to MD0)
2. If Box1 Qty Per > 0, Cradlepacked, Width (FURN uses Length) >= 70.00: (Box1 Qty Per x 1.5) x Break2 Nbr of RL/CS (MD0)
3. If Box1 Qty Per > 0 < 1 (bundles) and Not Cradlepacked: Break2 Nbr of RL/CS x Box1 Qty Per (MD2)
4. If Box1 Qty Per <= 0: 0
Break2 - BOR Box2 Qty (criteria 382):
1. If Cradlepacked: 0
2. If Box2 Qty Per >= 1: (Break2 Nbr of RL/CS x Box2 Qty Per) + .49 (always round up to MD0)
3. If Box2 Qty Per > 0 < 1 (bundles) and Not Cradlepacked: Break2 Nbr of RL/CS x Box2 Qty Per (MD2)
4. If Box1 Qty Per <= 0: 0
Break2 - Total Pkg Upcharge (criteria 331):
1. If Quantity Break2 <= 0: 0
2. If Quantity Break2 > 0: Execute SOPS9097.3 passing same variables as shown above, except swap order info (like qty, wgt) for Break2 info:
  1. PARAMS<1> = Warehouse
  2. PARAMS<2> = Break2 Wgt w/Packaging
  3. PARAMS3 = Break2 Nbr of Pallets
  4. PARAMS<4> = Std Pallet? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Standard Cartons" - always on a roll
  5. PARAMS<5> = Nbr of Pkgs per Pallet
  6. PARAMS<6> = Max Stacked Pallet Hgt (in inches)
  7. PARAMS<7> = Max Wgt per Pallet
  8. PARAMS<8> = Std Cartons?
  9. PARAMS<9> = Std Roll Pkg?
  10. PARAMS<10>=Break2 Nbr of Rolls/Cases
  11. PARAMS<11>=On Rolls? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Y" - always on a roll
  12. PARAMS<12>=Width FURN passes Length
  13. PARAMS<13>=Break2 BOR Box1 Qty
  14. PARAMS<14>=Box1 Item Nbr
  15. PARAMS<15>=Break2 BOR Box2 Qty
  16. PARAMS<16>=Box2 Item Nbr
Break2 - Shipping $$ (criteria 44):
1. If Not Prepaid OR Quantity Break2 <= 0: 0
2. If Prepaid: Execute SOPS9097.1 passing warehouse, zipcode and Break2 Wgt w/Packaging & Skids
3. Ship$ sent back in PARMS(8)< 3>
Break2 - Subtotal (criteria 407):
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break2 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break2 Wgt = Quantity Break2 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break2 Wgt
5. Total Material $$ = Material $/lb x Break2 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break2 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. Break Misc $$ = Misc $$ x Quantity Break2
13. Subtotal = Subtotal + Break Misc $$
14. Subtotal = Subtotal + Break2 Shipping $$
15. Subtotal = Subtotal + Venting Upcharge
16. Subtotal = Subtotal + Break2 Total Pkg Upcharge
17. Final Subtotal = Subtotal + Break2 Folded Bag Upcharge
Break2 - Adjust $/LB (criteria 406):
1. If Quote Adj Pct from Avante # 0 (it can be + or -); Execute SOPS9125.1 passing Quote Adj Pct from Avante, Break2 Subtotal, and Qty Break2 Wgt
2. Information is passed back via PARMS(8)<20>
3. If Quote Adj Pct = 0: 0
Break 2 - Printing Upcharge (criteria 437):
1. If Printed = N: 0
2. If Printed = Y:
1. 1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break2 Non-Matl Disc%
  2. Material $/lb = Total Material $$ / Order Total Lbs
  3. Break2 Wgt = Quantity Break2 x Yield per 1000 Bags
  4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break2 Wgt
  5. Total Material $$ = Material $/lb x Break2 Wgt
  6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
  7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
  8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
  9. Subtotal = Subtotal + Break2 Color Upcharge
  10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
  11. Subtotal = Subtotal + Break Full Gauge Upcharge $
  12. note: We don't include Misc$ or Shipping$ in this subtotal
  13. Subtotal = Subtotal + Venting Upcharge
  14. Subtotal = Subtotal + Break2 Total Pkg Upcharge
  15. Subtotal = Subtotal + Break2 Folded Bag Upcharge
  16. Discounted Adjust $/Lb = Break2 Adjust $/Lb x Quantity Break2 Non-Matl Disc%
  17. Adjust $$ = Break2 Wgt (from above iii.) x Discounted Adjust $/Lb
  18. Final Subtotal = Subtotal + Adjust $$
  19. Execute SOPS9147.5 passing: SHOP.IMAGEHGT, SHOP.IMAGEWID, Printer Ink Item#, Length(FURN passes Width; ROLLSHEET/ROLLTUBE pass "RL"), , Quantity Break2, Final Subtotal, Warehouse
  20. Break2 Printing Upcharge will be returned in PARMS(8)<29>
Break2 - Total Price (criteria 122):
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break2 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break2 Wgt = Quantity Break2 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break2 Wgt
5. Total Material $$ = Material $/lb x Break2 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break2 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. Break Misc $$ = Misc $$ x Quantity Break2
13. Subtotal = Subtotal + Break Misc $$
14. Subtotal = Subtotal + Break2 Shipping $$
15. Subtotal = Subtotal + Venting Upcharge
16. Subtotal = Subtotal + Break2 Total Pkg Upcharge
17. Subtotal = Subtotal + Break2 Folded Bag Upcharge
18. Discounted Adjust $/Lb = Break2 Adjust $/Lb x Quantity Break2 Non-Matl Disc%
19. Adjust $ = Discounted Adjust $/Lb x Break2 Wgt
20. Subtotal = Subtotal + Adjust $
21. Total Price = Subtotal + Break2 Printing Upcharge (MD4)
Break2 - Price/M (unit price) (criteria 127):
1. Break2 Total Price / Quantity Break2 (MD4)
Break3 - Color Upcharge (criteria 138):
1. If Color Job and Qty Break3 Weight < 5000.00: Qty Break3 Weight x .05 (MD3)
2. If Color Job and Qty Break3 Weight >= 5000.00: Qty Break3 Weight x .03 (MD3)
3. If Clear Job: 0.00
Break3 - Nbr of RL/CS (criteria 288):
1. ((Quantity Break3 x 1000) / Bags per Cs/Rl) + .49 (always round up to MD0)
2. ROLLSHEET/ROLLTUBE don't have this (because Break3 Nbr of Rolls has already been calc'd since Uom is RL). This calc is only needed for custom items in Uom "M".
Break3 - Wgt w/Packaging & Skids (criteria 343):
1. Break3 Wgt with no Pkg = Quantity Break3 x Yield per 1000 Bags
2. Execute SOPS9097.2 to calculate weight that includes packaging & skids, passing in:
  1. Width FURN passes Length
  2. BOR Flag FURN pass "Y" - always on a roll; SOR/ROLLSHEET/ROLLTUBE pass null but s/b Y (always on roll)
  3. Full Gauge Flag
  4. Cradlepack Flag
  5. Entered Gauge
  6. True Gauge
  7. Package Weight
  8. Break3 Weight (calc'd above)
  9. Nbr of RL/CS ROLLSHEET/ROLLTUBE pass Quantity Break1 (because in rolls)
  10. Box1 Item#
  11. Box2 Item#
  12. Not At True Gauge ("1" for BAGS, FURN, SOR because weight is calc'd at entered gauge regardless of FG flag) ROLLSHEET/ROLLTUBE pass "0"
3. Wgt with Pkg & Skids included is accepted back in this criteria via PARMS(8)<5>
4. Break3 Nbr of Pallets is accepted back in PARMS(8)<8> and passed on to criteria 336
5. Break3 Wgt with Pkg (no skids) is accepted back in PARMS(8)<9> and passed on to criteria 337
Break3 - Nbr of Pallets (criteria 336):
1. Data is passed here from criteria 343 above
Break3 - Weight w/Pkg (criteria 337):
1. Data is passed here from criteria 343 above
Break3 - BOR Box1 Qty (criteria 383):
1. If Box1 Qty Per > 0, Cradlepacked, Width (FURN uses Length) < 70.00 OR Box1 Qty Per >= 1: Break3 Nbr of RL/CS x Box1 Qty Per + .49 (always round up to MD0)
2. If Box1 Qty Per > 0, Cradlepacked, Width (FURN uses Length) >= 70.00: (Box1 Qty Per x 1.5) x Break3 Nbr of RL/CS (MD0)
3. If Box1 Qty Per > 0 < 1 (bundles) and Not Cradlepacked: Break3 Nbr of RL/CS x Box1 Qty Per (MD2)
4. If Box1 Qty Per <= 0: 0
Break3 - BOR Box2 Qty (criteria 384):
1. If Cradlepacked: 0
2. If Box2 Qty Per >= 1: (Break3 Nbr of RL/CS x Box2 Qty Per) + .49 (always round up to MD0)
3. If Box2 Qty Per > 0 < 1 (bundles) and Not Cradlepacked: Break3 Nbr of RL/CS x Box2 Qty Per (MD2)
4. If Box1 Qty Per <= 0: 0
Break3 - Total Pkg Upcharge (criteria 338):
1. If Quantity Break3 <= 0: 0
2. If Quantity Break3 > 0: Execute SOPS9097.3 passing same variables as shown above, except swap order info (like qty, wgt) for Break3 info:
  1. PARAMS<1> = Warehouse
  2. PARAMS<2> = Break3 Wgt w/Packaging
  3. PARAMS3 = Break3 Nbr of Pallets
  4. PARAMS<4> = Std Pallet? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Standard Cartons" - always on a roll
  5. PARAMS<5> = Nbr of Pkgs per Pallet
  6. PARAMS<6> = Max Stacked Pallet Hgt (in inches)
  7. PARAMS<7> = Max Wgt per Pallet
  8. PARAMS<8> = Std Cartons?
  9. PARAMS<9> = Std Roll Pkg?
  10. PARAMS<10>=Break3 Nbr of Rolls/Cases
  11. PARAMS<11>=On Rolls? FURN/SOR/ROLLSHEET/ROLLTUBE pass "Y" - always on a roll
  12. PARAMS<12>=Width FURN passes Length
  13. PARAMS<13>=Break3 BOR Box1 Qty
  14. PARAMS<14>=Box1 Item Nbr
  15. PARAMS<15>=Break3 BOR Box2 Qty
  16. PARAMS<16>=Box2 Item Nbr
Break3 - Shipping $$ (criteria 285):
1. If Not Prepaid OR Quantity Break3 <= 0: 0
2. If Prepaid: Execute SOPS9097.1 passing warehouse, zipcode and Break3 Wgt w/Packaging & Skids
3. Ship$ sent back in PARMS(8)< 3>
Break3 - Subtotal (criteria 408):
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break3 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break3 Wgt = Quantity Break3 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break3 Wgt
5. Total Material $$ = Material $/lb x Break3 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break3 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. Break Misc $$ = Misc $$ x Quantity Break3
13. Subtotal = Subtotal + Break Misc $$
14. Subtotal = Subtotal + Break3 Shipping $$
15. Subtotal = Subtotal + Venting Upcharge
16. Subtotal = Subtotal + Break3 Total Pkg Upcharge
17. Final Subtotal = Subtotal + Break3 Folded Bag Upcharge
Break3 - Adjust $/LB (criteria 409):
1. If Quote Adj Pct from Avante # 0 (it can be + or -); Execute SOPS9125.1 passing Quote Adj Pct from Avante, Break3 Subtotal, and Qty Break3 Wgt
2. Information is passed back via PARMS(8)<20>
3. If Quote Adj Pct = 0: 0
Break 3 - Printing Upcharge (criteria 438):

If Printed = N: 0
If Printed = Y:
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break3 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break3 Wgt = Quantity Break3 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break3 Wgt
5. Total Material $$ = Material $/lb x Break3 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break3 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. note: We don't include Misc$ or Shipping$ in this subtotal
13. Subtotal = Subtotal + Venting Upcharge
14. Subtotal = Subtotal + Break3 Total Pkg Upcharge
15. Subtotal = Subtotal + Break3 Folded Bag Upcharge
16. Discounted Adjust $/Lb = Break3 Adjust $/Lb x Quantity Break3 Non-Matl Disc%
17. Adjust $$ = Break3 Wgt (from above iii.) x Discounted Adjust $/Lb
18. Final Subtotal = Subtotal + Adjust $$
19. Execute SOPS9147.5 passing: SHOP.IMAGEHGT, SHOP.IMAGEWID, Printer Ink Item#, Length (FURN passes Width; ROLLSHEET/ROLLTUBE pass "RL"), , Quantity Break3, Final Subtotal, Warehouse
20. Break3 Printing Upcharge will be returned in PARMS(8)<29>

Break3 - Total Price (criteria 124):
1. Discounted Non-Matl $/LB = Price Break Non-Material $/LB x Quantity Break3 Non-Matl Disc%
2. Material $/lb = Total Material $$ / Order Total Lbs
3. Break3 Wgt = Quantity Break3 x Yield per 1000 Bags
4. Total Non-Material $$ = Discounted Non-Matl $/LB x Break3 Wgt
5. Total Material $$ = Material $/lb x Break3 Wgt
6. Subtotal Material & Non Material = Total Non-Material $$ + Total Material $$
7. Break Price Class Upcharge = Price Break Price Class Pct x Subtotal Material & Non Material
8. Subtotal = Subtotal Material & Non-Matl + Break Price Class Upcharge
9. Subtotal = Subtotal + Break3 Color Upcharge
10. Break Full Gauge Upcharge $ = Subtotal x Price Break Full Gauge Upcharge Pct
11. Subtotal = Subtotal + Break Full Gauge Upcharge $
12. Break Misc $$ = Misc $$ x Quantity Break3
13. Subtotal = Subtotal + Break Misc $$
14. Subtotal = Subtotal + Break3 Shipping $$
15. Subtotal = Subtotal + Venting Upcharge
16. Subtotal = Subtotal + Break3 Total Pkg Upcharge
17. Subtotal = Subtotal + Break3 Folded Bag Upcharge
18. Discounted Adjust $/Lb = Break3 Adjust $/Lb x Quantity Break3 Non-Matl Disc%
19. Adjust $ = Discounted Adjust $/Lb x Break3 Wgt
20. Subtotal = Subtotal + Adjust $
21. Total Price = Subtotal + Break3 Printing Upcharge (MD4)
Break3 - Price/M (unit price) (criteria 128):
1. Break3 Total Price / Quantity Break3 (MD4)