{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sales Channel Analysis"],"not_rendered":{"defined_names":28,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Sales Channel Analysis","index":0,"n_rows":48,"n_cols":8,"rows_kept":48,"merged":[[49,1,49,7]]}
[]
[]
[null," Sales Channel Analysis"]
[null,"For January, 2010"]
[]
[{"$nulls":3},"Annual ","Annual ","% of Total","Avg Units ","Avg Dollars "]
[{"$nulls":3},"Unit Volume ","Dollar Volume ","Sales ","per Month ","per Month "]
[null,"Company Retail Outlets"]
[null,null,"Freeport",{"v":1000000,"d":"1,000,000 "},{"v":20000000,"d":"$20,000,000"},{"$f":"IF(AND(SUM(D9),SUM(E9)),SUM(E9)/SUM($E$13),\"\")","v":{"v":0.18518518518518517,"d":"18.5%"}},{"$f":"IF(SUM(F9),D9/12,\"\")","v":{"v":83333.33333333333,"d":"83,333 "}},{"$f":"IF(SUM(G9),+E9/12,\"\")","v":{"v":1666666.6666666667,"d":"$1,666,667"}}]
[null,null,"Fall River",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"30,000,000 "},{"$f":"IF(AND(SUM(D10),SUM(E10)),SUM(E10)/SUM($E$13),\"\")","v":{"v":0.2777777777777778,"d":"27.8%"}},{"$f":"IF(SUM(F10),D10/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G10),+E10/12,\"\")","v":{"v":2500000,"d":"2,500,000 "}}]
[null,null,"Orlando",{"v":2000000,"d":"2,000,000 "},{"v":40000000,"d":"40,000,000 "},{"$f":"IF(AND(SUM(D11),SUM(E11)),SUM(E11)/SUM($E$13),\"\")","v":{"v":0.37037037037037035,"d":"37.0%"}},{"$f":"IF(SUM(F11),D11/12,\"\")","v":{"v":166666.66666666666,"d":"166,667 "}},{"$f":"IF(SUM(G11),+E11/12,\"\")","v":{"v":3333333.3333333335,"d":"3,333,333 "}}]
[null,null,"Baltimore",{"v":900000,"d":"900,000 "},{"v":18000000,"d":"18,000,000 "},{"$f":"IF(AND(SUM(D12),SUM(E12)),SUM(E12)/SUM($E$13),\"\")","v":{"v":0.16666666666666666,"d":"16.7%"}},{"$f":"IF(SUM(F12),D12/12,\"\")","v":{"v":75000,"d":"75,000 "}},{"$f":"IF(SUM(G12),+E12/12,\"\")","v":{"v":1500000,"d":"1,500,000 "}}]
[null,null,"Total",{"$f":"IF(SUM(D9:D12),SUM(D9:D12),\"\")","v":{"v":5400000,"d":"5,400,000 "}},{"$f":"IF(SUM(E9:E12),SUM(E9:E12),\"\")","v":{"v":108000000,"d":"$108,000,000"}},{"$f":"IF(AND(SUM(D13),SUM(E13)),E13/$E$48,\"\")","v":{"v":0.1581259150805271,"d":"15.8%"}},{"$f":"IF(SUM(G9:G12),SUM(G9:G12),\"\")","v":{"v":450000,"d":"450,000 "}},{"$f":"IF(SUM(H9:H12),SUM(H9:H12),\"\")","v":{"v":9000000,"d":"$9,000,000"}}]
[null,"Independent Retail Outlets"]
[null,null,"North Conway",{"v":1100000,"d":"1,100,000 "},{"v":21000000,"d":"$21,000,000"},{"$f":"IF(AND(SUM(D15),SUM(E15)),SUM(E15)/SUM($E$19),\"\")","v":{"v":0.1926605504587156,"d":"19.3%"}},{"$f":"IF(SUM(F15),D15/12,\"\")","v":{"v":91666.66666666667,"d":"91,667 "}},{"$f":"IF(SUM(G15),+E15/12,\"\")","v":{"v":1750000,"d":"$1,750,000"}}]
[null,null,"Nashua",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"30,000,000 "},{"$f":"IF(AND(SUM(D16),SUM(E16)),SUM(E16)/SUM($E$19),\"\")","v":{"v":0.27522935779816515,"d":"27.5%"}},{"$f":"IF(SUM(F16),D16/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G16),+E16/12,\"\")","v":{"v":2500000,"d":"2,500,000 "}}]
[null,null,"Washington, DC",{"v":2000000,"d":"2,000,000 "},{"v":40000000,"d":"40,000,000 "},{"$f":"IF(AND(SUM(D17),SUM(E17)),SUM(E17)/SUM($E$19),\"\")","v":{"v":0.3669724770642202,"d":"36.7%"}},{"$f":"IF(SUM(F17),D17/12,\"\")","v":{"v":166666.66666666666,"d":"166,667 "}},{"$f":"IF(SUM(G17),+E17/12,\"\")","v":{"v":3333333.3333333335,"d":"3,333,333 "}}]
[null,null,"New Bedford",{"v":900000,"d":"900,000 "},{"v":18000000,"d":"18,000,000 "},{"$f":"IF(AND(SUM(D18),SUM(E18)),SUM(E18)/SUM($E$19),\"\")","v":{"v":0.1651376146788991,"d":"16.5%"}},{"$f":"IF(SUM(F18),D18/12,\"\")","v":{"v":75000,"d":"75,000 "}},{"$f":"IF(SUM(G18),+E18/12,\"\")","v":{"v":1500000,"d":"1,500,000 "}}]
[null,null,"Total",{"$f":"IF(SUM(D15:D18),SUM(D15:D18),\"\")","v":{"v":5500000,"d":"5,500,000 "}},{"$f":"IF(SUM(E15:E18),SUM(E15:E18),\"\")","v":{"v":109000000,"d":"$109,000,000"}},{"$f":"IF(AND(SUM(D19),SUM(E19)),E19/$E$48,\"\")","v":{"v":0.1595900439238653,"d":"16.0%"}},{"$f":"IF(SUM(G15:G18),SUM(G15:G18),\"\")","v":{"v":458333.3333333334,"d":"458,333 "}},{"$f":"IF(SUM(H15:H18),SUM(H15:H18),\"\")","v":{"v":9083333.333333334,"d":"$9,083,333"}}]
[null,"Salaried Sales Force"]
[null,null,"Northeast",{"v":1100000,"d":"1,100,000 "},{"v":21000000,"d":"$21,000,000"},{"$f":"IF(AND(SUM(D21),SUM(E21)),SUM(E21)/SUM($E$25),\"\")","v":{"v":0.1926605504587156,"d":"19.3%"}},{"$f":"IF(SUM(F21),D21/12,\"\")","v":{"v":91666.66666666667,"d":"91,667 "}},{"$f":"IF(SUM(G21),+E21/12,\"\")","v":{"v":1750000,"d":"$1,750,000"}}]
[null,null,"Mid-Atlantic",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"30,000,000 "},{"$f":"IF(AND(SUM(D22),SUM(E22)),SUM(E22)/SUM($E$25),\"\")","v":{"v":0.27522935779816515,"d":"27.5%"}},{"$f":"IF(SUM(F22),D22/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G22),+E22/12,\"\")","v":{"v":2500000,"d":"2,500,000 "}}]
[null,null,"Southeast",{"v":2000000,"d":"2,000,000 "},{"v":40000000,"d":"40,000,000 "},{"$f":"IF(AND(SUM(D23),SUM(E23)),SUM(E23)/SUM($E$25),\"\")","v":{"v":0.3669724770642202,"d":"36.7%"}},{"$f":"IF(SUM(F23),D23/12,\"\")","v":{"v":166666.66666666666,"d":"166,667 "}},{"$f":"IF(SUM(G23),+E23/12,\"\")","v":{"v":3333333.3333333335,"d":"3,333,333 "}}]
[null,null,"West",{"v":900000,"d":"900,000 "},{"v":18000000,"d":"18,000,000 "},{"$f":"IF(AND(SUM(D24),SUM(E24)),SUM(E24)/SUM($E$25),\"\")","v":{"v":0.1651376146788991,"d":"16.5%"}},{"$f":"IF(SUM(F24),D24/12,\"\")","v":{"v":75000,"d":"75,000 "}},{"$f":"IF(SUM(G24),+E24/12,\"\")","v":{"v":1500000,"d":"1,500,000 "}}]
[null,null,"Total",{"$f":"IF(SUM(D21:D24),SUM(D21:D24),\"\")","v":{"v":5500000,"d":"5,500,000 "}},{"$f":"IF(SUM(E21:E24),SUM(E21:E24),\"\")","v":{"v":109000000,"d":"$109,000,000"}},{"$f":"IF(AND(SUM(D25),SUM(E25)),E25/$E$48,\"\")","v":{"v":0.1595900439238653,"d":"16.0%"}},{"$f":"IF(SUM(G21:G24),SUM(G21:G24),\"\")","v":{"v":458333.3333333334,"d":"458,333 "}},{"$f":"IF(SUM(H21:H24),SUM(H21:H24),\"\")","v":{"v":9083333.333333334,"d":"$9,083,333"}}]
[null,"Channel 4"]
[null,null,"Northeast",{"v":1100000,"d":"1,100,000 "},{"v":21000000,"d":"$21,000,000"},{"$f":"IF(AND(SUM(D27),SUM(E27)),SUM(E27)/SUM($E$31),\"\")","v":{"v":0.1926605504587156,"d":"19.3%"}},{"$f":"IF(SUM(F27),D27/12,\"\")","v":{"v":91666.66666666667,"d":"91,667 "}},{"$f":"IF(SUM(G27),+E27/12,\"\")","v":{"v":1750000,"d":"$1,750,000"}}]
[null,null,"Mid-Atlantic",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"30,000,000 "},{"$f":"IF(AND(SUM(D28),SUM(E28)),SUM(E28)/SUM($E$31),\"\")","v":{"v":0.27522935779816515,"d":"27.5%"}},{"$f":"IF(SUM(F28),D28/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G28),+E28/12,\"\")","v":{"v":2500000,"d":"2,500,000 "}}]
[null,null,"Southeast",{"v":2000000,"d":"2,000,000 "},{"v":40000000,"d":"40,000,000 "},{"$f":"IF(AND(SUM(D29),SUM(E29)),SUM(E29)/SUM($E$31),\"\")","v":{"v":0.3669724770642202,"d":"36.7%"}},{"$f":"IF(SUM(F29),D29/12,\"\")","v":{"v":166666.66666666666,"d":"166,667 "}},{"$f":"IF(SUM(G29),+E29/12,\"\")","v":{"v":3333333.3333333335,"d":"3,333,333 "}}]
[null,null,"West",{"v":900000,"d":"900,000 "},{"v":18000000,"d":"18,000,000 "},{"$f":"IF(AND(SUM(D30),SUM(E30)),SUM(E30)/SUM($E$31),\"\")","v":{"v":0.1651376146788991,"d":"16.5%"}},{"$f":"IF(SUM(F30),D30/12,\"\")","v":{"v":75000,"d":"75,000 "}},{"$f":"IF(SUM(G30),+E30/12,\"\")","v":{"v":1500000,"d":"1,500,000 "}}]
[null,null,"Total",{"$f":"IF(SUM(D27:D30),SUM(D27:D30),\"\")","v":{"v":5500000,"d":"5,500,000 "}},{"$f":"IF(SUM(E27:E30),SUM(E27:E30),\"\")","v":{"v":109000000,"d":"$109,000,000"}},{"$f":"IF(AND(SUM(D31),SUM(E31)),E31/$E$48,\"\")","v":{"v":0.1595900439238653,"d":"16.0%"}},{"$f":"IF(SUM(G27:G30),SUM(G27:G30),\"\")","v":{"v":458333.3333333334,"d":"458,333 "}},{"$f":"IF(SUM(H27:H30),SUM(H27:H30),\"\")","v":{"v":9083333.333333334,"d":"$9,083,333"}}]
[null,"Wholesalers / Company Owned Distributors"]
[null,null,"New York",{"v":1100000,"d":"1,100,000 "},{"v":21000000,"d":"$21,000,000"},{"$f":"IF(AND(SUM(D33),SUM(E33)),SUM(E33)/SUM($E$37),\"\")","v":{"v":0.1926605504587156,"d":"19.3%"}},{"$f":"IF(SUM(F33),D33/12,\"\")","v":{"v":91666.66666666667,"d":"91,667 "}},{"$f":"IF(SUM(G33),+E33/12,\"\")","v":{"v":1750000,"d":"$1,750,000"}}]
[null,null,"Nashua",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"30,000,000 "},{"$f":"IF(AND(SUM(D34),SUM(E34)),SUM(E34)/SUM($E$37),\"\")","v":{"v":0.27522935779816515,"d":"27.5%"}},{"$f":"IF(SUM(F34),D34/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G34),+E34/12,\"\")","v":{"v":2500000,"d":"2,500,000 "}}]
[null,null,"Washington, DC",{"v":2000000,"d":"2,000,000 "},{"v":40000000,"d":"40,000,000 "},{"$f":"IF(AND(SUM(D35),SUM(E35)),SUM(E35)/SUM($E$37),\"\")","v":{"v":0.3669724770642202,"d":"36.7%"}},{"$f":"IF(SUM(F35),D35/12,\"\")","v":{"v":166666.66666666666,"d":"166,667 "}},{"$f":"IF(SUM(G35),+E35/12,\"\")","v":{"v":3333333.3333333335,"d":"3,333,333 "}}]
[null,null,"Charleston, NC",{"v":900000,"d":"900,000 "},{"v":18000000,"d":"18,000,000 "},{"$f":"IF(AND(SUM(D36),SUM(E36)),SUM(E36)/SUM($E$37),\"\")","v":{"v":0.1651376146788991,"d":"16.5%"}},{"$f":"IF(SUM(F36),D36/12,\"\")","v":{"v":75000,"d":"75,000 "}},{"$f":"IF(SUM(G36),+E36/12,\"\")","v":{"v":1500000,"d":"1,500,000 "}}]
[null,null,"Total",{"$f":"IF(SUM(D33:D36),SUM(D33:D36),\"\")","v":{"v":5500000,"d":"5,500,000 "}},{"$f":"IF(SUM(E33:E36),SUM(E33:E36),\"\")","v":{"v":109000000,"d":"$109,000,000"}},{"$f":"IF(AND(SUM(D37),SUM(E37)),E37/$E$48,\"\")","v":{"v":0.1595900439238653,"d":"16.0%"}},{"$f":"IF(SUM(G33:G36),SUM(G33:G36),\"\")","v":{"v":458333.3333333334,"d":"458,333 "}},{"$f":"IF(SUM(H33:H36),SUM(H33:H36),\"\")","v":{"v":9083333.333333334,"d":"$9,083,333"}}]
[null,"Wholesalers / Independent Distributors"]
[null,null,"Springfield",{"v":1100000,"d":"1,100,000 "},{"v":21000000,"d":"$21,000,000"},{"$f":"IF(AND(SUM(D39),SUM(E39)),SUM(E39)/SUM($E$43),\"\")","v":{"v":0.1926605504587156,"d":"19.3%"}},{"$f":"IF(SUM(F39),D39/12,\"\")","v":{"v":91666.66666666667,"d":"91,667 "}},{"$f":"IF(SUM(G39),+E39/12,\"\")","v":{"v":1750000,"d":"$1,750,000"}}]
[null,null,"Cambridge",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"30,000,000 "},{"$f":"IF(AND(SUM(D40),SUM(E40)),SUM(E40)/SUM($E$43),\"\")","v":{"v":0.27522935779816515,"d":"27.5%"}},{"$f":"IF(SUM(F40),D40/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G40),+E40/12,\"\")","v":{"v":2500000,"d":"2,500,000 "}}]
[null,null,"Chicago",{"v":2000000,"d":"2,000,000 "},{"v":40000000,"d":"40,000,000 "},{"$f":"IF(AND(SUM(D41),SUM(E41)),SUM(E41)/SUM($E$43),\"\")","v":{"v":0.3669724770642202,"d":"36.7%"}},{"$f":"IF(SUM(F41),D41/12,\"\")","v":{"v":166666.66666666666,"d":"166,667 "}},{"$f":"IF(SUM(G41),+E41/12,\"\")","v":{"v":3333333.3333333335,"d":"3,333,333 "}}]
[null,null,"San Francisco",{"v":900000,"d":"900,000 "},{"v":18000000,"d":"18,000,000 "},{"$f":"IF(AND(SUM(D42),SUM(E42)),SUM(E42)/SUM($E$43),\"\")","v":{"v":0.1651376146788991,"d":"16.5%"}},{"$f":"IF(SUM(F42),D42/12,\"\")","v":{"v":75000,"d":"75,000 "}},{"$f":"IF(SUM(G42),+E42/12,\"\")","v":{"v":1500000,"d":"1,500,000 "}}]
[null,null,"Total",{"$f":"IF(SUM(D39:D42),SUM(D39:D42),\"\")","v":{"v":5500000,"d":"5,500,000 "}},{"$f":"IF(SUM(E39:E42),SUM(E39:E42),\"\")","v":{"v":109000000,"d":"$109,000,000"}},{"$f":"IF(AND(SUM(D43),SUM(E43)),E43/$E$48,\"\")","v":{"v":0.1595900439238653,"d":"16.0%"}},{"$f":"IF(SUM(G39:G42),SUM(G39:G42),\"\")","v":{"v":458333.3333333334,"d":"458,333 "}},{"$f":"IF(SUM(H39:H42),SUM(H39:H42),\"\")","v":{"v":9083333.333333334,"d":"$9,083,333"}}]
[null,"Other"]
[null,null,"On-Line / Mail Order",{"v":1500000,"d":"1,500,000 "},{"v":30000000,"d":"$30,000,000"},{"$f":"IF(AND(SUM(D45),SUM(E45)),SUM(E45)/SUM($E$47),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(SUM(F45),D45/12,\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(G45),+E45/12,\"\")","v":{"v":2500000,"d":"$2,500,000"}}]
[{"$nulls":5},{"$f":"IF(AND(SUM(D46),SUM(E46)),SUM(E46)/SUM($E$47),\"\")","v":""},{"$f":"IF(SUM(F46),D46/12,\"\")","v":""},{"$f":"IF(SUM(G46),+E46/12,\"\")","v":""}]
[null,null,"Total",{"$f":"IF(SUM(D45:D46),SUM(D45:D46),\"\")","v":{"v":1500000,"d":"1,500,000 "}},{"$f":"IF(SUM(E45:E46),SUM(E45:E46),\"\")","v":{"v":30000000,"d":"$30,000,000"}},{"$f":"IF(SUM(F45:F46),SUM(F45:F46),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(SUM(G45:G46),SUM(G45:G46),\"\")","v":{"v":125000,"d":"125,000 "}},{"$f":"IF(SUM(H45:H46),SUM(H45:H46),\"\")","v":{"v":2500000,"d":"$2,500,000"}}]
[null,"Totals for all Channels",null,{"$f":"IF(SUM(D13,D19,D25,D31,D37,D43,D47),SUM(D13,D19,D25,D31,D37,D43,D47),\"\")","v":{"v":34400000,"d":"34,400,000 "}},{"$f":"IF(SUM(E13,E19,E25,E31,E37,E43,E47),SUM(E13,E19,E25,E31,E37,E43,E47),\"\")","v":{"v":683000000,"d":"$683,000,000"}},{"$f":"IF(AND(SUM(D48:E48),SUM(E48)),SUM(E48)/SUM(E48),\"\")","v":{"v":1,"d":"100.0%"}},{"$f":"IF(SUM(F48),D48/12,\"\")","v":{"v":2866666.6666666665,"d":"2,866,667 "}},{"$f":"IF(SUM(G48),+E48/12,\"\")","v":{"v":56916666.666666664,"d":"$56,916,667"}}]