Laddawn.com : Bottle Bags - Layflat

Created by Lee Carter, last modified by Jason Burke on Jan 19, 2021


a. Target release:
b. Technical specifications:

DRAFT

c. UI specifications:
d. Ticket #:
e. Marketing info:Go >>


I. Technical specifications

  1. New Catalog Code or Existing? New
    1. If new, where should it be placed in Level 2 menu?  Poly Bags (After Gusset and before Clean Room bags) 

  2. What is the Yield calculation for this new category? (This is needed for Berry file transfers.)
    1. Nominal = (Width*Length*(Gauge*0.9))/15
    2. Full Gauge = (Width*Length*Gauge)/15
  3. Do we have Stock Items in this Category?  No    If Yes:
    1. Can these be sampled?  No
    2. What is the maximum Sample quantity?  N/A
    3. What is the sample Unit of Measure? (ie, bags, feet)  N/A

  4. Widget Level 2 – Dimensions:
    1. Width ranges:  25 - 54"
    2. Depth enabled?  If Yes:  No
      1. Depth Ranges:
    3. Length ranges:  45 - 75"
    4. Gauge ranges:  1.5 - 2.5
    5. Full gauge:
      1. Non-Printed – Default Value:  Nominal
      2. Non-Printed – Changeable?  Yes, full gauge is available
      3. Printed – Default Value:  N/A
      4. Printed – Changeable?  N/A
      5. Stock Items are:  Full Gauge or Nominal  N/A
      6. Exceptions (ie, <=1mil must be FG):  None

  5. Widget  Level 3:
    1. Materials Menu:  
      1. Enabled?  No
      2. What is the default? LLDPE
      3. If enabled, which options are allowed for Materials and Additives?  N/A
    2. Color Menu:
      1. Enabled?  Yes
      2. What is the default?  Clear
      3. If enabled, which color/opacities are allowed?  Medium_Blue Tint only
    3. Registered Printing Allowed? __No__  If YES:
      1. Width Ranges:
      2. Length Ranges:
      3. Gauge Ranges:
      4. Material Restrictions?
      5. Color/Opacity Restrictions?
    4. Is Venting Allowed? ¬__ No____   If YES:
      1. Which Vent Hole Types are allowed?
      2. Which Placement Options are allowed?
      3. Which Alignment Options are allowed?
      4. Nbr of Holes Min/Max Range (include calculation, if any)
      5. Inches From Side (include calculation, if any)
      6. Inches from Bottom (include calculation, if any)
      7. Inches Between Holes (include calculation, if any)
    5. Packaging Menu:
      1. What is the default? (Cases or Rolls, Boxed)  Rolls, Cradlepacked
      2. Disabled after the default (so no changes can be made)?  No, Rolls Individually boxed is an option

  6. Minimum Quantity calculation:

    1. If Clear - Roundup(2000/FGYield,2)
    2. If Blue Tint - Roundup(3000/FGYield,2)
  7. Count:
    1. Default Count Calculation  =MROUND(3.14159*(14+3.35)*(14-3.35)/(4*'Roll Diameter Calc'!G19*2)/Length,10)
    2. Count Range (for validation)
      1. Max =MROUND(3.14159*(19.8+3.35)*(19.8-3.35)/(4*'Roll Diameter Calc'!G19*2)/Length,10)
      2. Min =MROUND(3.14159*(10.2+3.35)*(10.2-3.35)/(4*'Roll Diameter Calc'!G19*2)/Length,10)
    3. Range Multiples?  (ie, in multiples of 50)  10

  8. Pricing Unit of Measure (Thousands, Rolls, Cases) M

  9. Customer Pricing/Vendor Costing Model – provide calculation or attach Excel Spreadsheet:  Bottle Bags - Layflat.xls

  10. Quantity/Price Breaks:
    1. Standard Quantity Break calculation (if any):  Break quantities are in cells E9, F9, & G9
    2. Are Custom Breaks Allowed?  Yes

  11. Case or Roll Weight calculation (including packaging) – if on a roll, we need the core weight as well as the box weight. If in a case, we need the box weight:  =IF(I5="Cradlepacked",(Yield*(Count/1000)+1),(Yield*(Count/1000)+2))

  12. Freight Calculation:
    1. Is Freight from Spreadsheet?  Freight is paid for by Berry and will always be $0.  The cells in Row 16 show the zero dollar charge.
    2. If not from spreadsheet, what is the ‘from’ warehouse & carrier name?  Determined by Berry
    3. Do we allow shipments to Canada?  Yes

  13. Is Freight always included in the price (disable freight option)?  Always included

  14. Lead Time Days:
    1. Domestic:  28 Days
    2. Import:  N/A
    3. Registered Printed:  N/A

  15. Should an Import result be shown?  No

  16. Overrun Percentage:  +/- 10%

  17. Construction:
    1. Bottom Seal or Side Weld  Bottom Seal

  18. Image to display in Specifications area:  Image pending and will be provided by Berry

  19. Additional abbreviated text in internal item description? (ie, TAMPER EVIDENT, VAC POUCH)  None

  20. Advanced Search Keywords (for quick search entry at top of widget):
    1. Keywords: Bottle Bags, Bottle Bagging, Automatic Bottle Bagging
    2. Type of Search:
      1. We source custom and offer stock - choosing category via widget menu and incomplete dimensions, or via search box - produces all stock matches
      2. We only source custom - choosing category via widget menu or search box places cursor in first dimensionf field with tooltip about need for dimensions.

  21. YMAC instructions:  No YMACs

  22. Special Instructions:  None


II. User interface changes

III. QA requirements

IV. Change management and rollout planning


Creative brief?

Internal training and preparation? 

Coordinated with marketing campaign?