Cell Reference Names
Width
Length
Gusset
Gauge
Quantity
Printed
Metallocene
FilmColor
Opacity
OnRolls
Count
DomesticPrice
DomesticTotalPrice
DomesticCost
DomesticFreight
DomFirstBreakQTY
DomFirstBreakPrice
DomFirstBreakTotalPrice
DomSecondBreakQTY
DomSecondBreakPrice
DomSecondBreakTotalPrice
DomThirdBreakQTY
DomThirdBreakPrice
DomThirdBreakTotalPrice
ImportPrice
ImportTotalPrice
ImportCost
ImportFirstBreakQTY
ImportFirstBreakPrice
ImportFirstBreakTotalPrice
ImportSeocondBreakQTY
ImportSecondBreakPrice
ImportSecondBreakTotalPrice
ImportThirdBreakQTY
ImportThirdBreakPrice
ImportThirdBreakTotalPrice
I. Technical specifications
- New Catalog Code or Existing? Existing: Can Liners - HD - Coreless & Can Liners - HD - Flat Packed.
- If new, where should it be placed in Level 2 menu?
- If new, where should it be placed in Level 2 menu?
- Do we have Stock Items in this Category? Yes
- Can these be sampled? Yes
- What is the maximum Sample quantity? 5
- What is the sample Unit of Measure? (ie, bags, feet) Bags
- Widget Level 2 – Dimensions:
- Width ranges: 19"-54"
- Depth enabled? No If Yes:
- Depth Ranges:
- Length ranges: 19"-80"
- Gauge ranges: 6 mics - 24 mics
- Full gauge:
- Non-Printed – Default Value:
- Non-Printed – Changeable?
- Printed – Default Value:
- Printed – Changeable?
- Stock Items are: Full Gauge or Nominal ?
- Exceptions (ie, <=1mil must be FG):
- Widget Level 3:
- Materials Menu:
- Enabled? No
- What is the default? High Density
- If enabled, which options are allowed for Materials and Additives?
- Color Menu:
- Enabled? Yes
- What is the default? Clear Film.
If enabled, which color/opacities are allowed? red color, red tint, white color, white tint, medium blue color, medium blue tint, leaf green color, leaf green tint, orange color, orange tint, buff tint, buff color, black color, black tint.
- Registered Printing Allowed? No
- Width Ranges:
- Length Ranges:
- Gauge Ranges:
- Material Restrictions?
- Color/Opacity Restrictions?
- Is Venting Allowed? ¬__No__
- Which Vent Hole Types are allowed?
normal, small, & butterfly - Which Placement Options are allowed?
User Specified - Which Alignment Options are allowed?
One side, both sides, center - Nbr of Holes Min/Max Range (include calculation, if any)
Same as in -house rules - Inches From Side (include calculation, if any)
Same as in-house - Inches from Bottom (include calculation, if any)
Same as in-house - Inches Between Holes (include calculation, if any)
Same as in-house
- Which Vent Hole Types are allowed?
- Packaging Menu:
- What is the default? (Cases or Rolls) Cases
- Disabled after the default (so no changes can be made)? Yes
- Materials Menu:
- Minimum Quantity calculation:
=round 475 / (((width*length)*(gauge/25.4))/15) to the nearest whole number. - Count:
- Default Count Calculation = if((round(20/(((width*length)*(gauge/25.4))/15,0))=0,200,(round(20/(((width*length)*(gauge/25.4))/15,0)*1000)
- Count Range (for validation)
- High range =if((round(42/(((width*length)*(gauge/25.4))/15,0))=0,200,(round(42/(((width*length)*(gauge/25.4))/15,0)*1000)
- Low range =if((round(7/(((width*length)*(gauge/25.4))/15,0))=0,200,(round(7/(((width)*length)*(gauge/25.4))/15,0)*1000)
- Range Multiples? (ie, in multiples of 50)
- Customer Pricing/Vendor Costing Model – provide calculation or attach Excel Spreadsheet:
- Quantity/Price Breaks:
- Standard Quantity Break calculation (if any): 2X, 3X, & 4X the minimum quantity.
- Are Custom Breaks Allowed? Yes
- Case Weight calculation (including packaging) : =((Width*Length)*(Gauge/25.4))*(Count/1000)+2
- Freight Calculation:
- Is Freight from Spreadsheet? Yes
- If not from spreadsheet, what is the ‘from’ warehouse & carrier name?
- Do we allow shipments to Canada? Yes
- Is Freight always included in the price (disable freight option)? Yes
- Lead Time Days:
- Domestic: 30
- Import (plain or printed): 95
- Domestic Random Printed: n/a
- Should an Import result be shown? Yes
- Overrun Percentage: 10%
- Construction:
- Star Seal
- Image to display in Specifications area For HDPE Layflats show the same image as the stock images for Can Liners HD Flat Packed. If coreless rolls is selected show same image as stock Can Liners HD Coreless Rolls.
- Additional abbreviated text in internal item description? (ie, TAMPER EVIDENT, VAC POUCH) HDPE Can Liners
- Advanced Search Keywords (for quick search entry at top of widget):
- Keywords: Same as current stock categories.
- Type of Search: Answer: i
- We source custom and offer stock - choosing category via widget menu and incomplete dimensions, or via search box - produces all stock matches
We only source custom - choosing category via widget menu or search box places cursor in first dimensionf field with tooltip about need for dimensions.
- YMAC instructions: Show Closest Related Can Liner Stock Size
- Special Instructions: Priced per thousand
II. User interface changes
None needed. The existing Can Liners menu will be used to access both stock and Marketplace.
III. QA requirements
IV. Change managment and rollout planning
Creative brief?
Internal training and preparation?
Coordinated with marketing campaign?