Laddawn.com : Mattress Film

Created by Lee Carter, last modified on Nov 21, 2020


a. Target release:
b. Technical specifications:

DRAFT

c. UI specifications:
d. Ticket #:http://helpdesk/WorkOrder.do?woMode=viewWO&woID=58803&PORTALID=1
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?  Sheeting (After Containment Film)

  2. What is the Yield calculation for this new category? (This is needed for Berry file transfers.)  
    1. Nominal:  =((Width*12)*(Gauge*.9))/30
    2. Full Gauge:  =((Width*12)*Gauge)/30
  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:  80 - 126"
    2. Depth enabled?   No  If Yes:
      1. Depth Ranges:  N/A
    3. Length ranges:  N/A
    4. Gauge ranges:  2.5 - 4 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   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?  Low and Linear Low-Density Polyethylene Blend
      3. If enabled, which options are allowed for Materials and Additives? Disabled but Non Slip should be automatically selected
    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)?  Yes, no changes allowed

  6. Minimum Quantity calculation:  ROUNDUP((3000/(((Width*12)*Gauge)/30)/1000)*Roll Length,0)   **Gauge used in formula is always the full gauge entered)

  7. Count:
    1. Default Count Calculation  MROUND(3.14159*(14+3.8)*(14-3.8)/(4*'Roll Diameter Calc'!F9)/12,10)
    2. Count Range (for validation)
      1. Max Feet Per Roll:  =MROUND(3.14159*(19.8+3.8)*(19.8-3.8)/(4*'Roll Diameter Calc'!F9)/12,10)
      2. Min Feet Per Roll:  =MROUND(3.14159*(10.2+3.8)*(10.2-3.8)/(4*'Roll Diameter Calc'!F9)/12,10)
    3. Range Multiples?  (ie, in multiples of 50)  10

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

  9. Customer Pricing/Vendor Costing Model – provide calculation or attach Excel Spreadsheet:  Mattress Film.xls  

  10. Quantity/Price Breaks:
    1. Standard Quantity Break calculation (if any):  Price Break Quantities 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:  =((Yield/1000)*RollLength)+1


  1. Freight Calculation:
    1. Is Freight from Spreadsheet?  Freight will always be $0 but it is in the spreadsheet in row 16.  Freight is paid by Berry
    2. If not from spreadsheet, what is the ‘from’ warehouse & carrier name?
    3. Do we allow shipments to Canada?  Yes

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

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

  4. Should an Import result be shown?  No

  5. Overrun Percentage:  +/- 10%

  6. Construction:
    1. Bottom Seal or Side Weld  None, it is single wound sheeting with no seals

  7. Image to display in Specifications area:  Awaiting from Berry.  Update:  Jeff B requested from Berry

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

  9. Advanced Search Keywords (for quick search entry at top of widget):
    1. Keywords:   Mattress, LDPE Mattress Film, Packaging Film, Mattress Packaging
    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.

  10. YMAC instructions:  Show closest stock Mattress bags based on width

  11. Special Instructions:


II. User interface changes

III. QA requirements

IV. Change management and rollout planning


Creative brief?

Internal training and preparation? 

Coordinated with marketing campaign?