{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["How to Use the Tool","General Warehouse Information","Calculations"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":17,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"How to Use the Tool","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"General Warehouse Information","index":1,"n_rows":108,"n_cols":9,"rows_kept":108,"cut":false,"hidden":false,"merged":[[107,1,107,3],[103,1,103,2],[5,1,5,3],[13,1,13,3],[26,1,26,3],[45,1,45,3],[98,1,98,2],[79,1,79,3],[101,1,101,2],[102,1,102,2],[89,1,89,3],[96,1,96,3],[44,1,44,3],[99,1,100,2],[57,1,57,3]]}
[]
[]
[null,null,null,"www.highjump.com"]
[]
[]
[null,"HighJump WMS Savings Calculator"]
[null,"COMPANY INFO"]
[null,"Annual growth rate",0.05,"Will impact NPV calculation"]
[null,"Planning horizon",3,"Will impact NPV calculation"]
[null,"NPV discount rate",0.15,"Will impact NPV calculation"]
[null,"Labor burden rate",0.4,"Factors into labor costs"]
[null,"Type of distribution operation",null,"Will impact order fulfillment gain assumption"]
[]
[null,"Labor Cost"]
[null,"WAREHOUSE"]
[null,"Warehouse worker hourly wage",12]
[null,"Total hourly burdened cost of labor",{"$f":"C16+(LB*C16)","v":16.8}]
[]
[null,"CLERICAL"]
[null,"Clerical hourly wage",11]
[null,"Total hourly burdened cost of labor",{"$f":"C20+(LB*C20)","v":15.4}]
[]
[null,"CUSTOMER SERVICE"]
[null,"Customer service hourly wage",10]
[null,"Total hourly burdened cost of labor",{"$f":"C24+(LB*C24)","v":14}]
[]
[null,"Order Statistics"]
[null,"PICKING STATS","AVERAGE","PEAK"]
[null,"Number of sales orders per day",300,400]
[null,"Number of lines per order",2,2]
[null,"Number of full carton picks per order",2,2]
[null,"Number of full pallet picks per order",0,0]
[null,"Number of units picked per order",20,40]
[null,"Number of shipped cartons per order",3,7]
[]
[null,"RECEIVING STATS","AVERAGE","PEAK"]
[null,"Number of purchase orders per day",5,8]
[null,"Number of lines per PO",100,150]
[null,"Number of cartons per PO",1500,2000]
[null,"Number of pallets per PO",0,0]
[null,"Number of units per PO",10000,10000]
[]
[null,"Length of peak season (in months)",3]
[]
[null,"Warehouse Staffing"]
[null,"Resources are based on the number of 8-hour shifts. If one resource spends 4 hours per day on a task, then the quantity is .5"]
[null,"STAFF","AVERAGE","PEAK"]
[null,"Pickers",10,12]
[null,"Packers",2,3]
[null,"Stock handlers",3,3]
[null,"Shippers",2,2]
[null,"Receivers",2,4]
[]
[null,"CLERICAL","AVERAGE","PEAK"]
[null,"Receipt confirmations",1,1.5]
[null,"Pick confirmations",1,1.5]
[]
[null,"Physical Inventory Count Data"]
[null,"Warehouse personnel for the following functions:"]
[null,null,"Pickers"]
[null,null,"Packers"]
[null,null,"Stock handlers"]
[null,null,"Shippers"]
[null,null,"Receivers"]
[null,"Data entry clerks for the following functions"]
[null,null,"Receipt confirmations"]
[null,null,"Pick confirmations"]
[]
[null,"Shift 3"]
[null,"Warehouse personnel for the following functions"]
[null,null,"Pickers"]
[null,null,"Packers"]
[null,null,"Stock handlers"]
[null,null,"Shippers"]
[null,null,"Receivers"]
[null,"Data entry clerks for the following functions"]
[null,null,"Receipt confirmations"]
[null,null,"Pick confirmations"]
[]
[null,"Physical Inventory Count Data"]
[null,"PHYSICAL","QUANTITY"]
[null,"Number of counts per year",1]
[null,"Number of actual staff counting",12]
[null,"Number of count days",4]
[]
[null,"CLERICAL",null,null,null,null,null,null,0]
[null,"Number of administrative personnel",3]
[null,"Number of days required for admin",5,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,"Warehouse Accuracy Data"]
[null,"ACCURACY","QUANTITY"]
[null,"Number of mis-shipments per day",2]
[null,"Average cost per mis-shipment",150]
[null,"Number of miss-shipments per day",2]
[null,"Average cost per mis-shipment",150]
[]
[null,"Vendor Compliance"]
[null,"EDI"]
[null,"Do your customers require EDI?"]
[null,"Do your customers require UCC-128 shipping labels for ASN compliance?"]
[]
[null,"Number of data entry clerks employed to cross-reference UCC numbers and items?",null,1]
[null,"Number of resources dedicated to the UCC packing and labeling process?",null,1]
[null,"Compliance fines value last year?",null,30000]
[]
[]
[]
[null,"www.highjump.com"]

{"sheet":"Calculations","index":2,"n_rows":134,"n_cols":6,"rows_kept":134,"cut":false,"hidden":false,"merged":[[133,2,133,5],[131,1,131,5],[129,3,129,4],[96,3,96,5],[4,2,4,5],[37,3,37,4],[39,2,39,5]]}
[null,null,null,null,"Annual Savings","NPV"]
[null,null,null,"Conservative",{"$f":"+F36","v":340350},{"$f":"+D38","v":932263.04347826098}]
[null,null,null,"Aggressive",{"$f":"+F128","v":606897.49800000002},{"$f":"+D130","v":1662371.4075652177}]
[]
[null,null,"Quick Calculations: Hard Savings Analysis"]
[null,null,"Your Current Warehouse Costs"]
[null,null,null,null,"RESOURCE COST"]
[null,null,"RESOURCE FUNCTION","% of total ","Cost/day","Cost/year"]
[null,null,"Picking",{"$f":"F9/GT","v":0.42775330806693429},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C48*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D48*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":1478.4},{"$f":"261*E9","v":385862.40000000002}]
[null,null,"Packing/checking",9.7216660924303241E-2,{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C49*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D49*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":336},87696]
[null,null,"Stock handling",0.1166599931091639,{"$f":"(('General Warehouse Information'!C50*BCLW*8)*((12-PKS)/12))+(('General Warehouse Information'!D50*BCLW*8)*((PKS/12)))","v":403.20000000000005},105235.20000000001]
[null,null,"Shipping",7.7773328739442593E-2,{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C51*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D51*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":268.8},70156.800000000003]
[null,null,"Receivers",0.1166599931091639,{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C52*8)   /     ((261*((12-PKS)/12))*PON))*PON)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D52*8)   /     ((261*(PKS/12))*POP))*POP))/2","v":403.20000000000005},105235.20000000001]
[null,null,"Data entry clerks: Warehouse ops",8.0203745262550183E-2,{"$f":"((('General Warehouse Information'!C55*BCLD*8)*((12-PKS)/12))+(('General Warehouse Information'!D55*BCLD*8)*((PKS/12))))+((('General Warehouse Information'!C56*BCLD*8)*((12-PKS)/12))+(('General Warehouse Information'!D56*BCLD*8)*((PKS/12))))","v":277.20000000000005},72349.200000000012]
[null,null,"Physical count labor",7.1515704587993192E-3,"---",{"$f":"+('General Warehouse Information'!C82*'General Warehouse Information'!C83*'General Warehouse Information'!C84)*BCLW*8","v":6451.2000000000007}]
[null,null,"Data entry clerks: Physical count",2.0486269543435547E-3,"---",{"$f":"'General Warehouse Information'!C87*'General Warehouse Information'!C88*BCLD*8","v":1848}]
[null,null,"Data entry clerks: EDI",3.5646109005577853E-2,{"$f":"'General Warehouse Information'!D102*BCLD*8","v":123.2},{"$f":"261*E17","v":32155.200000000001}]
[null,null,"EDI warehouse labor",3.8886664369721297E-2,{"$f":"'General Warehouse Information'!D103*BCLW*8","v":134.4},{"$f":"261*E18","v":35078.400000000001}]
[null,null,"Total warehouse-related labor costs per year",null,null,{"$f":"SUM(F9:F18)","v":902067.6}]
[]
[null,null,"COST OF MIS-SHIPMENTS",null,"Per day","Per year"]
[null,null,"Number of mis-shipments",null,{"$f":"'General Warehouse Information'!C94","v":2},{"$f":"261*E22","v":522}]
[null,null,"Total mis-shipment cost ",null,{"$f":"E22*MS","v":300},{"$f":"F22*MS","v":78300}]
[]
[null,null,"Savings from Eliminating Functions/Reducing Errors"]
[null,null,"RESOURCE FUNCTION","Your estimate","Cost/day","Savings/year"]
[null,null,"Packing/checking ",1,{"$f":"E10","v":336},{"$f":"261*E27*D27","v":87696}]
[null,null,"Shipping ",1,{"$f":"E12","v":268.8},{"$f":"261*E28*D28","v":70156.800000000003}]
[null,null,"Data entry clerks: Warehouse ops",1,{"$f":"E14","v":277.20000000000005},{"$f":"261*E29*D29","v":72349.200000000012}]
[null,null,"Data entry clerks: Physical count",1,null,{"$f":"F16*D30","v":1848}]
[null,null,"Data entry clerks: EDI",1,{"$f":"E17","v":123.2},{"$f":"261*E31*D31","v":32155.200000000001}]
[null,null,"Added EDI warehouse labor",1,{"$f":"E18","v":134.4},{"$f":"261*E32*D32","v":35078.400000000001}]
[null,null,"Total labor savings (assumes you eliminate these functions)",null,null,{"$f":"SUM(F27:F30)","v":232050}]
[null,null,"Total savings in mis-shipment reduction",null,null,{"$f":"F23","v":78300}]
[null,null,"Savings from compliance fines elimination",null,null,{"$f":"'General Warehouse Information'!D104","v":30000}]
[null,null,"Total hard savings per year (conservative)",null,null,{"$f":"SUM(F33:F35)","v":340350}]
[]
[null,null,"NPV1 Over Planning Horizon",{"$f":"NPV(DR,F36*(1+GR)*PH)","v":932263.04347826098}]
[]
[null,null,"Productivity Gains Analysis"]
[null,null,"Your Current Order Fulfillment Costs"]
[null,null,null," RESOURCE COST"]
[null,null,"RESOURCE FUNCTION","% of total ","Cost/day","Cost/year"]
[null,null,"Picking costs",{"$f":"+E44/E49","v":0.55991516436903488},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C48*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D48*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":1478.4},{"$f":"261*E44","v":385862.40000000002}]
[null,null,"Packing/checking costs",{"$f":"+E45/E49","v":0.12725344644750794},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C49*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D49*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":336},87696]
[null,null,"Stock handling costs",{"$f":"+E46/E49","v":0.15270413573700953},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C50*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D50*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":403.20000000000005},105235.20000000001]
[null,null,"Shipping costs",{"$f":"+E47/E49","v":0.10180275715800635},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C51*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D51*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":268.8},70156.800000000003]
[null,null,"Data entry clerk",{"$f":"+E48/E49","v":5.8324496288441136E-2},{"$f":"(((((261*((12-PKS)/12))*BCLD*'General Warehouse Information'!C56*8)   /     ((261*((12-PKS)/12))*OrdersN))*OrdersN)   +    ((((261*((PKS)/12))*BCLD*'General Warehouse Information'!D56*8)   /     ((261*(PKS/12))*OrdersP))*OrdersP))/2","v":154},40194]
[null,null,"Total labor costs",{"$f":"SUM(D44:D48)","v":0.99999999999999978},{"$f":"SUM(E44:E48)","v":2640.4000000000005},689144.40000000014]
[]
[null,null,"Current pick lines per hour",{"$f":"(('General Warehouse Information'!C29*'General Warehouse Information'!C30)/(('General Warehouse Information'!C48+'General Warehouse Information'!C49)*8)*(12-PKS)/12) + (('General Warehouse Information'!D29*'General Warehouse Information'!D30)/(('General Warehouse Information'!D48+'General Warehouse Information'!D49)*8)*(PKS)/12)","v":6.354166666666667}]
[]
[null,null,null,"PROCESS COST"]
[null,null,"FULFILLMENT ACTIVITY","% of total ","Cost/day","Cost/year"]
[null,null,"Traveling",0.55000000000000004,{"$f":"+E$49*D55","v":1452.2200000000005},{"$f":"+F$49*D55","v":379029.4200000001}]
[null,null,"Searching",0.15,{"$f":"+E$49*D56","v":396.06000000000006},{"$f":"+F$49*D56","v":103371.66000000002}]
[null,null,"Extracting",0.1,{"$f":"+E$49*D57","v":264.04000000000008},{"$f":"+F$49*D57","v":68914.440000000017}]
[null,null,"Paperwork and other",0.2,{"$f":"+E$49*D58","v":528.08000000000015},{"$f":"+F$49*D58","v":137828.88000000003}]
[null,null,"Total labor costs",{"$f":"SUM(D55:D58)","v":1},{"$f":"SUM(E55:E58)","v":2640.4000000000005},{"$f":"SUM(F55:F58)","v":689144.40000000014}]
[null,null,null,0.35]
[]
[null,null,"Order Fulfillment Assumptions & Potential Savings"]
[null,null,"FULFILLMENT ACTIVITY",null,"Improvement Assumption","Your estimate"]
[null,null,"Traveling",null,0.4,0.6]
[null,null,"Searching",null,0.4,0.9]
[null,null,"Extracting",null,0.1,0.1]
[null,null,"Paperwork and other",null,{"$f":"F67","v":0.9},0.9]
[]
[null,null,null,"                ANNUAL DOLLARS"]
[null,null,"FULFILLMENT ACTIVITY","Before WMS ","After WMS ","Savings"]
[null,null,"Traveling",{"$f":"F55","v":379029.4200000001},{"$f":"D71-(D71*F64)","v":151611.76800000004},{"$f":"D71-E71","v":227417.65200000006}]
[null,null,"Searching",{"$f":"F56","v":103371.66000000002},{"$f":"D72-(D72*F65)","v":10337.165999999997},{"$f":"D72-E72","v":93034.494000000021}]
[null,null,"Extracting",{"$f":"F57","v":68914.440000000017},{"$f":"D73-(D73*F66)","v":62022.996000000014},{"$f":"D73-E73","v":6891.4440000000031}]
[null,null,"Paperwork and other",{"$f":"F58","v":137828.88000000003},{"$f":"D74-(D74*F67)","v":13782.888000000006},{"$f":"D74-E74","v":124045.99200000003}]
[null,null,"Total labor costs",{"$f":"SUM(D71:D74)","v":689144.40000000014},{"$f":"SUM(E71:E74)","v":237754.81800000006},{"$f":"SUM(F71:F74)","v":451389.58200000011}]
[]
[null,null,"Your Current Receiving & Put-away Costs"]
[null,null,null,null,"RESOURCE COST"]
[null,null,"RESOURCE FUNCTION","% of total ","Cost/day","Cost/year"]
[null,null,"Data entry clerk",{"$f":"+F80/F82","v":0.45454545454545453},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C55*8)   /     ((261*((12-PKS)/12))*PON))*PON)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D55*8)   /     ((261*(PKS/12))*POP))*POP))/2","v":168},{"$f":"261*E80","v":43848}]
[null,null,"Stock handling for put-away",{"$f":"+F81/F82","v":0.54545454545454553},{"$f":"(((((261*((12-PKS)/12))*BCLW*'General Warehouse Information'!C50*8*0.5)   /     ((261*((12-PKS)/12))*PON))*PON)   +    ((((261*((PKS)/12))*BCLW*'General Warehouse Information'!D50*8*0.5)   /     ((261*(PKS/12))*POP))*POP))/2","v":201.60000000000002},{"$f":"261*E81","v":52617.600000000006}]
[null,null,"Total labor costs",{"$f":"SUM(D79:D81)","v":1},{"$f":"SUM(E79:E81)","v":369.6},{"$f":"SUM(F79:F81)","v":96465.600000000006}]
[]
[null,null,null,null,"PROCESS COST"]
[null,null,"RECEIVING ACTIVITY","% of total ","Cost/day","Cost/year"]
[null,null,"Sorting and reconciling",0.55000000000000004,{"$f":"D86*E82","v":203.28000000000003},{"$f":"D86*F82","v":53056.080000000009}]
[null,null,"Put-away travel",0.15,{"$f":"D87*E82","v":55.440000000000005},{"$f":"D87*F82","v":14469.84}]
[null,null,"Paperwork and other",0.3,{"$f":"D88*E82","v":110.88000000000001},{"$f":"D88*F82","v":28939.68}]
[null,null,"Total labor costs",{"$f":"SUM(D85:D88)","v":1},{"$f":"SUM(E85:E88)","v":369.6},{"$f":"SUM(F85:F88)","v":96465.600000000006}]
[]
[null,null,"Receiving & Put-away Assumptions & Potential Savings"]
[null,null,"RECEIVING ACTIVITY",null,"Improvement assumption","Your estimate"]
[null,null,"Sorting and reconciling",null,0.25,0.25]
[null,null,"Put-away",null,0.2,0.2]
[null,null,"Paperwork and other",null,0.2,0.85]
[]
[null,null,null,"               ANNUAL DOLLARS"]
[null,null,"RECEIVING ACTIVITY","Before WMS ","After WMS ","Savings"]
[null,null,"Sorting and reconciling",{"$f":"F86","v":53056.080000000009},{"$f":"D99-(D99*F93)","v":39792.060000000005},{"$f":"D99-E99","v":13264.020000000004}]
[null,null,"Put-away",{"$f":"F87","v":14469.84},{"$f":"D100-(D100*F94)","v":11575.871999999999},{"$f":"D100-E100","v":2893.9680000000008}]
[null,null,"Paperwork and other",{"$f":"F88","v":28939.68},{"$f":"D101-(D101*F95)","v":4340.9520000000011},{"$f":"D101-E101","v":24598.727999999999}]
[null,null,"Total labor costs",{"$f":"SUM(D98:D101)","v":96465.600000000006},{"$f":"SUM(E98:E101)","v":55708.884000000005},{"$f":"SUM(F98:F101)","v":40756.716}]
[]
[null,null,"Error Reduction"]
[null,null,"COST OF MIS-SHIPMENTS",null,"Per day","Per year"]
[null,null,"Number of mis-shipments",null,{"$f":"'General Warehouse Information'!C94","v":2},{"$f":"261*E106","v":522}]
[null,null,"Total mis-shipment cost ",null,{"$f":"E106*MS","v":300},{"$f":"F106*MS","v":78300}]
[]
[null,null,"Total Savings"]
[null,null,"FUNCTION"]
[null,null,"Picking",null,null,{"$f":"D75-E75","v":451389.58200000005}]
[null,null,"Receiving and put-away",null,null,{"$f":"F102","v":40756.716}]
[null,null,"Error reductions",null,null,{"$f":"+F107","v":78300}]
[null,null,"Compliance fines elimination",null,null,{"$f":"'General Warehouse Information'!D104","v":30000}]
[null,null,"Eliminate physical inventory count elimination",null,null,{"$f":"+F15","v":6451.2000000000007}]
[]
[null,null,"SOFT SAVINGS"]
[null,null,"More productive sales time",null,null,0]
[null,null,"Fewer lost sales because of inaccurate inventory",null,null,0]
[null,null,"Fewer lost customers because of errors",null,null,"$"]
[null,null,"Reduced demurrage charges",null,null,0]
[null,null,"Reduced expediting",null,null,0]
[null,null,"Improved space utilization",null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,"Total Speculative Annual Savings (aggressive)",null,null,{"$f":"SUM(F111:F127)","v":606897.49800000002}]
[]
[null,null,"NPV2 Over Planning Horizon",{"$f":"NPV(DR,F128*(1+GR)*PH)","v":1662371.4075652177}]
[]
[null,"Click here for RADIO BEACON contact information."]
[]
[null,null,"HighJump Inc.         www.highjump.com"]