Spreadsheet: 104083d1301702730-calculate-sales-forecast-using-multiple-criteria-sample-no-2
Sheet: HWL

Homeworld Linen 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2011 Marketing Drives |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2011 Sales Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Growth
 | Homeworld Linen 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | 2011 Sales Forecast |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Growth
 | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | Ave. Sales |  |  |  |  | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP | Same / New / GDP |  | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | 1 | BACOOR | 317015.75 | 393863.75 | 201275.75 | 952315.75 | 672754.25 | 1159359.5 | 1077480.25 | 1729711.5 | 1442017.75 | 227083 | 614726.5 | 712660.75 | 9500264.5 |  | 791688.7083333334 |  |  | 1 | BACOOR |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | BACOOR |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 1 | BACOOR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2 | BAGUIO | 255282.25 | 315267.5 | 361754.75 | 644756 | 335961.25 | 512456.25 | 430278.25 | 206499.75 | 141862.25 | 320721.75 | 331996.5 | 305587.5 | 4162424 |  | 346868.6666666667 |  |  | 2 | BAGUIO |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | BAGUIO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2 | BAGUIO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 3 | BALIWAG | 338363.75 | 0 | 89394.25 | 60784.75 | 242888.25 | 144267.25 | 175645.5 | 397506.75 | 241759 | 93699.5 | 0 | 139556.25 | 1923865.25 |  | 160322.1041666667 |  |  | 3 | BALIWAG |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | BALIWAG |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 3 | BALIWAG | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 | 4 | BATANGAS | 120108.5 | 275606 | 128584.75 | 339655.25 | 312742.25 | 217356.25 | 298750 | 213487 | 220471.25 | 322620.75 | 170638 | 79194.75 | 2699214.75 |  | 224934.5625 |  |  | 4 | BATANGAS |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | BATANGAS |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 4 | BATANGAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 5 | BICUTAN | 237314.75 | 390159.5 | 682826.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1310301 |  | 109191.75 |  |  | 5 | BICUTAN |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BICUTAN |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 5 | BICUTAN | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 0
 | 6 | CALAMBA |  |  |  |  |  | 0 |  |  |  | 430193.5 | 153960.25 | 301439.5 | 885593.25 |  | 221398.3125 |  |  | 6 | CALAMBA |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | CALAMBA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 6 | CALAMBA |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 7 | CLARK | 385624.75 | 323600.25 | 427740.75 | 887528.25 | 197401.25 | 490321.5 | 430027.75 | 477405.25 | 309931.5 | 551973.25 | 233254 | 606660 | 5321468.5 |  | 443455.7083333333 |  |  | 7 | CLARK |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | CLARK |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 7 | CLARK | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 8 | DASMARINAS | 177710.5 | 448911 | 866973.75 | 773159 | 1178173.5 | 452697.25 | 667919 | 555124 | 933784 | 316516.25 | 180992.75 | 359230.25 | 6911191.25 |  | 575932.6041666666 |  |  | 8 | DASMARINAS |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | DASMARINAS |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 8 | DASMARINAS | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 9 | DELGADO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 9 | DELGADO |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | DELGADO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 9 | DELGADO
 | 10 | FAIRVIEW | 242986 | 560700 | 542449 | 851843 | 1004039.5 | 100265.5 | 416678.75 | 1261033.5 | 376518.5 | 289067.25 | 315063.25 | 673179.5 | 6633823.75 |  | 552818.6458333334 |  |  | 10 | FAIRVIEW |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | FAIRVIEW |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 10 | FAIRVIEW | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 11 | HARRISON | 0 | 316475.75 | 346578 | 121000 | 333054.25 | 553402.25 | 92990.25 | 105712 | 194643.25 | 209323.5 | 136346 | 95508 | 2505033.25 |  | 208752.7708333333 |  |  | 11 | HARRISON |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | HARRISON |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 11 | HARRISON |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 12 | [NAME] | 32299 | 170465.5 | 282427 | 182920 | 286967 | 383085.25 | 420312.75 | 425604.75 | 253424.25 | 39840 | 34791 | 158207 | 2670343.5 |  | 222528.625 |  |  | 12 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 12 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 13 | MALL OF ASIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 13 | MALL OF ASIA |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | MALL OF ASIA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 13 | MALL OF ASIA
 | 14 | MAKATI | 51345 | 5698.5 | 0 | 23994 | 0 | 23092.5 | 0 | 11995.5 | 0 | 0 | 10795.5 | 16797 | 143718 |  | 11976.5 |  |  | 14 | MAKATI |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | MAKATI |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 14 | MAKATI | 0 | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 0
 | 15 | MARILAO | 487337.75 | 246930 | 424114.25 | 579001.5 | 400349.25 | 265175.5 | 629145.25 | 337900.5 | 554090.25 | 427434.5 | 383852.25 | 406749.5 | 5142080.5 |  | 428506.7083333333 |  |  | 15 | MARILAO |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | MARILAO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 15 | MARILAO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 16 | MEGAMALL | 35367.5 | 0 | 9597 | 0 | 0 | 19194 | 0 | 0 | 0 | 93570 | 0 | 0 | 157728.5 |  | 13144.04166666667 |  |  | 16 | MEGAMALL |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | MEGAMALL |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 16 | MEGAMALL | 0 |  | 0 |  |  | 0 |  |  |  | 0 |  |  | 0
 | 17 | MORONG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 17 | MORONG |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | MORONG |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 17 | MORONG
 | 18 | NAGA | 39617.5 | 201821 | 97904.5 | 417284.75 | 63592.5 | 181987.5 | 258560.75 | 155288.5 | 322058 | 123753.75 | 0 | 0 | 1861868.75 |  | 155155.7291666667 |  |  | 18 | NAGA |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | NAGA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 18 | NAGA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0
 | 19 | NORTH EDSA |  |  |  |  |  | 0 |  |  |  | 566749 | 5940 | 96609 | 669298 |  | 167324.5 |  |  | 19 | NORTH EDSA |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | NORTH EDSA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 19 | NORTH EDSA |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 20 | NOVALICHES | 18396.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18396.75 |  | 1533.0625 |  |  | 20 | NOVALICHES |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | NOVALICHES |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 20 | NOVALICHES
 | 21 | PAMPANGA | 24508.5 | 22495.5 | 0 | 0 | 88791.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 135795.5 |  | 11316.29166666667 |  |  | 21 | PAMPANGA |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | PAMPANGA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 21 | PAMPANGA | 0 | 0 |  |  | 0 |  |  |  |  |  |  |  | 0
 | 22 | QUIAPO | 0 | 131074.5 | 140212.5 | 161047.5 | 190154.75 | 287512 | 308794.75 | 178414 | 220616.75 | 135257.75 | 190428 | 435974.75 | 2379487.25 |  | 198290.6041666667 |  |  | 22 | QUIAPO |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | QUIAPO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 22 | QUIAPO |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 23 | [NAME] | 25048.5 | 84092 | 0 | 205051.5 | 0 | 176978 | 262420.25 | 271141 | 219760.5 | 48073.5 | 126382.75 | 71068 | 1490016 |  | 124168 |  |  | 23 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 23 | [NAME] | 0 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 24 | ROSARIO | 372404.25 | 336116.25 | 130184.75 | 303376.5 | 0 | 338299 | 213838 | 652733.5 | 473230.25 | 334896.5 | 124994.75 | 59494 | 3339567.75 |  | 278297.3125 |  |  | 24 | ROSARIO |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | ROSARIO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 24 | ROSARIO | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 25 | SAN LAZARO | 615770.75 | 753537.25 | 854975.5 | 841657.5 | 855619 | 1074695.75 | 1547345.5 | 622064.75 | 823173 | 927042.25 | 413339.25 | 1055018.5 | 10384239 |  | 865353.25 |  |  | 25 | SAN LAZARO |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | SAN LAZARO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 25 | SAN LAZARO | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 26 | SAN PABLO |  |  |  |  |  | 0 |  |  | 362686.5 | 43947.75 | 60193 | 93742 | 560569.25 |  | 112113.85 |  |  | 26 | SAN PABLO |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | SAN PABLO |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 26 | SAN PABLO |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0
 | 27 | SOUTHMALL |  |  |  | 8337.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14997.75 | 23335.5 |  | 2592.833333333333 |  |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 | 28 | STA MESA | 534479.5 | 1328861 | 791128.25 | 1270009 | 1034067 | 1851491.25 | 1266284 | 1161565 | 935240.5 | 682044.75 | 88211 | 1600593.25 | 12543974.5 |  | 1045331.208333333 |  |  | 28 | STA MESA |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | STA MESA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 28 | STA MESA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 29 | STA ROSA | 65085 | 767536.75 | 327436.5 | 672367 | 563923.5 | 978270 | 511379.5 | 581194.75 | 756063.5 | 307652 | 299872.25 | 271591.5 | 6102372.25 |  | 508531.0208333333 |  |  | 29 | STA ROSA |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | STA ROSA |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 29 | STA ROSA | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 30 | SUCAT |  |  | 277578 | 598090 | 639037.25 | 394302.25 | 232841.75 | 220696 | 276351.25 | 147908.5 | 159318 | 144086.75 | 3090209.75 |  | 309020.975 |  |  | 30 | SUCAT |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | SUCAT |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 30 | SUCAT |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 31 | TANAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | TANAY |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | TANAY |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 31 | TANAY
 | 32 | TARLAC | 1234 |  |  | 293046 | 734044.25 | 929363.25 | 374300.5 | 367446.25 | 624015.25 | 104429.5 | 337087.5 | 491372.75 | 4256339.25 |  | 425633.925 |  |  | 32 | TARLAC |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | TARLAC |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 32 | TARLAC |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 33 | TAYTAY | 122694 | 122694 | 122694 | 122694 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 2090776 |  | 174231.3333333333 |  |  | 33 | TAYTAY |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | TAYTAY |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 33 | TAYTAY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 4499994.25 | 7195906 | 7105830 | 10309919 | 9333560.5 | 10733572 | 9814992.75 | 10132524.25 | 9881697.5 | 6943798.5 | 4572182.5 | 8389318.25 | 98913295.5 |  | 8242774.625 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
` | Forecast Parameters
 | 1 | If marketing drive is blank grow 2011 forecast by 4% (GDP)
 | 2 | If marketing drive is same grow 2011 forecast by 6% (Like marketing programs running on the same period last year i.e. Jan 2010 bundling program=Jan 2011 bundling program)
 | 3 | If marketing drive is new grow 2011 forecast by 10% (GDP + entirely new program/ no marketing drives 2010: with marketing drives 2011)
 | 4 | If 2010 Sales is lower than 2010 ave.sales, 2011 forecast is equal to ave.sales + growth parameters
 | 5 | If average 2010 sales is lower than the 2011 forecast with growth parameters then follow forecast