Please review the current MOD Price Calculation below. These calculations were taken from BAGS (pricing UOM = M). The pricing calculations for RL and LB items are similar but not exactly the same. Need to establish:
- Are we continuing with all of the current Upcharges?
- Are we adding/changing anything in the calculation?
- Can we simplify the pricing calculation?
- Easiest way to switch between different pricing UOM's?
- Assigns Mfg Facility based on destination zip code and each plant's mfg capabilities
- Calculates Operation Details for Primary and Alternate Work Centers based for the Mfg Facility assigned to this job
- Determines Box and/or Core quantities and item numbers
- Calculates package weight and width/length/weight tolerances
- Establishes BOM including resin/concentrate percentages,item numbers, $/LB, and quantity (in lbs)
- Calculates Minimum Quote Weight (Standard or Color job)
- Determines Quote's Non-Matl Disc%, Minimum Qty & Weights for up to 3 price breaks
- Determines each price break's non-material discount% (based on work center capacity)
- Calculates Draw Length Upcharge
- Gets Non-Material $/lb from table bottomseal/sideweld table based on gauge and bubblesize
- Calculates quote's Non Material $
- Calculates quote's Material $ (resins)
- Calculates quote's color concentrate $ (color jobs only)
- Calculates quote's antistatic concentrate $ (antistat jobs only)
- Calculates quote's slip concentrate $ (slip additive jobs only)
- Calculates quote's Antiblock concentrate $ (antiblock additive jobs only)
- Calculates quote's UVI/UVA concentrate $ (UVI/UVA additive jobs only)
- Calculates quote's Metallocene concentrate $ (metallocene additive jobs only)
- Sums above 12-18 for Total Material $
- Calculates Color Upcharge (color jobs only)
- Calculates Price Class Upcharge (NEPB customers only)
- Calculates Full Gauge Upcharge (FG jobs only)
- Calculates Order, Packaging, and Shipment Weights, determines #Pallets, and calculates Freight$ (for PPD jobs)
- Calculates Venting Upcharge (vented jobs only)
- Calculates Folded Bag Upcharge (v-boarded jobs only)
- Calculates Packaging Upcharges: Non-standard pallets, #Packages, Pallet Hgt, Pallet Wgt (non-standard packaging jobs only)
- We will assume that these charges are going to go away, Owen will confirm with Dawn.
- Calculates Poly Lining Upcharge (for polylined cases)
- Calculates BOR Boxing Upcharge (for individually boxed rolls)
- Applies Misc$ (+/- per pricing Uom) (for discounts or add'l upcharges determined by management)
- Calculates a Subtotal of the above charges, then applies the Quote Adjustment %, if any (determined by sales org/customer) *** see list of customers below
- Calculates Printing Upcharge (for printed jobs only)
- Calculates the Total Quote Price from all charges above
- Calculates each of the 3 price break prices using the same logic as above (simplified in some calculations
The following 8 customers are using the Quote Adjustment%:
09:51:45 MAR 28 2013 1
SlsOrg# Name..................... Quote Adj Pct Quote Adj Custs
01*10301 UNISOURCE - JACKSONVILLE 1.00
01*1120 MORRISETTE PAPER CO. 1.00
01*1215 PACIFIC PACKAGING PROD. 2.00
01*150 ASSOCIATED PACKAGING 1.00
01*2955 KENT H. LANDSBERG CO 2.00
01*5294 RYNEL LIMITED 25.00
01*586 CROWN PACKAGING 1.00
01*8370 PYRAMID PACKAGING INC. 1.00 890134