Laddawn.com : Machine Grade Top Sheeting - Custom

Created by Lee Carter, last modified by Judy Ascensao on Oct 01, 2020


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? Custom and Stock are a new catalog code being launched together
    1. If new, where should it be placed in Level 2 menu? Under continuous sheeting - listed after single wound and before centerfold

  2. What is the Yield calculation for this new category? (This is needed for Berry file transfers.)  Yield is calculated per 1000 ft and will need to be adjusted to get a weight per roll.  (That formula is (Yield/1000) * Roll Length in feet)

    1. Nominal - ((Width * 12) * (Gauge * .9)) / 30
    2. Full Gauge - ((Width * 12) * Gauge) / 30

10/1/20 (Judy) - I am using the standard yield calculation for stretch:

  • Width x Feet per Roll x (gauge / 100000) x .4 x Count
  1. Do we have Stock Items in this Category?   Yes   If Yes: (New Items 13960 & 13970)
    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

  2. Widget Level 2 – Dimensions:
    1. Width ranges:  56 - 76
    2. Depth enabled?  No  If Yes:
      1. Depth Ranges:  N/A
    3. Length ranges:  N/A - Disabled
    4. Gauge ranges:  1 - 8 mil
    5. Full gauge:
      1. Non-Printed – Default Value:  Nominal
      2. Non-Printed – Changeable?  Yes
      3. Printed – Default Value:  N/A
      4. Printed – Changeable?  N/A
      5. Stock Items are:  Full Gauge or Nominal  Nominal
      6. Exceptions (ie, <=1mil must be FG): None

  3. Widget  Level 3:
    1. Materials Menu:
      1. Enabled?  No
      2. What is the default?  Anti Static AmineFree Clear/Color 2%
      3. If enabled, which options are allowed for Materials and Additives? 
    2. Color Menu:
      1. Enabled?  Yes
      2. What is the default?  Clear
      3. If enabled, which color/opacities are allowed? White and Black in Tint, Color, and Opaque
    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)?  Rolls Boxed

  4. Minimum Quantity calculation:  Different minimums based on color.

    1. Clear - ROUNDUP(2000 / Full Gauge Roll Weight,0)
    2. Color - ROUNDUP(3000 / Full Gauge Roll Weight,0)
  5. Count:  
    1. Default Count Calculation  
      1. Nominal
        1. MROUND(3.14159*(10+3.8)*(10-3.8)/(4*((Gauge*.9)/1000))/12,50)
      2. Full Gauge
        1. MROUND(3.14159*(10+3.8)*(10-3.8)/(4*(Gauge/1000))/12,50)
    2. Count Range (for validation)
      1. Nominal 
        1. Max Per Roll - MROUND(3.14159*(13.9+3.8)*(13.9-3.8)/(4*((Gauge*.9)/1000))/12,10)
        2. Min Per Roll - MROUND(3.14159*(8.1+3.8)*(8.1-3.8)/(4*((Gauge*.9)/1000))/12,10)
      2. Full Gauge
        1. Max Per Roll - MROUND(3.14159*(13.9+3.8)*(13.9-3.8)/(4*(Gauge/1000))/12,10)
        2. Min Per Roll - MROUND(3.14159*(8.1+3.8)*(8.1-3.8)/(4*(Gauge/1000))/12,10)
    3. Range Multiples?  (ie, in multiples of 50) 10

  6. Pricing Unit of Measure (Thousands, Rolls, Cases)  Roll

  7. Customer Pricing/Vendor Costing Model – provide calculation or attach Excel Spreadsheet:  Machine Grade Top Sheeting.xls

  8. Quantity/Price Breaks:
    1. Standard Quantity Break calculation (if any):  This varies based on if the bag is film is colored or not but will be listed in cells E9, F9, and G9
    2. Are Custom Breaks Allowed?  Yes

  9. 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:

    1. Cradlepacked = ((Yield/1000) * Roll Length) + 1
    2. Rolls Boxed = ((Yield/1000) * Roll Length) + 2
  10. Freight Calculation:
    1. Is Freight from Spreadsheet?  Yes
    2. If not from spreadsheet, what is the ‘from’ warehouse & carrier name?  Freight is always $0 but has a cell on the spreadsheet.  Berry chooses best carrier
    3. Do we allow shipments to Canada?  Yes

  11. Is Freight always included in the price (disable freight option)?  Yes

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

  13. Should an Import result be shown?  No

  14. Overrun Percentage:  +/- 10%

  15. Construction:
    1. Bottom Seal or Side Weld  N/A - no seal

  16. Image to display in Specifications area:  To be provided when available

  17. Additional abbreviated text in internal item description? (ie, TAMPER EVIDENT, VAC POUCH)  Match Purple and Detailed descriptions of stock items

  18. Advanced Search Keywords (for quick search entry at top of widget):
    1. Keywords:   Sheeting, Machine Grade Sheeting, Top Sheet, Top Sheeting
    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.

  19. YMAC instructions:  The two stock options 13960 & 13970

  20. Special Instructions:  Must be 2.5 mil full Gauge or 2.9 mil nominal in order to be opaque


II. User interface changes

III. QA requirements

IV. Change management and rollout planning


Creative brief?

Internal training and preparation? 

Coordinated with marketing campaign?