Spreadsheet: 104084d1301704306-calculate-sales-forecast-using-multiple-criteria-2011forecast
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 | Same | New | GDP | Same |  |  |  |  |  |  |  |  |  | 1 | BACOOR | 336036.695 | 433250.1250000001 | 209326.78 |  |  |  |  |  |  |  |  |  | 978613.6000000001 |  | 1 | BACOOR | 1.06 | 1.1 | 1.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.1030090899048127
 | 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 | New | GDP | GDP | New |  |  |  |  |  |  |  |  |  | 2 | BAGUIO | 280810.475 | 327878.2 | 376224.94 |  |  |  |  |  |  |  |  |  | 984913.615 |  | 2 | BAGUIO | 1.1 | 1.04 | 1.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2366202037562728
 | 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 | GDP | GDP | New | GDP |  |  |  |  |  |  |  |  |  | 3 | BALIWAG | 351898.3 | 0 | 0 |  |  |  |  |  |  |  |  |  | 351898.3 |  | 3 | BALIWAG | 1.04 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0.1829121348285697
 | 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 | GDP | New | Same |  |  |  |  |  |  |  |  |  |  | 4 | BATANGAS | 791688.7083333334 | 303166.6 | 0 |  |  |  |  |  |  |  |  |  | 1094855.308333333 |  | 4 | BATANGAS | 6.591446136895668 | 1.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4056199338468098
 | 5 | BICUTAN | 237314.75 | 390159.5 | 682826.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1310301 |  | 109191.75 |  |  | 5 | BICUTAN | New | Same | Same |  |  |  |  |  |  |  |  |  |  | 5 | BICUTAN | 261046.225 | 413569.07 | 723796.355 |  |  |  |  |  |  |  |  |  | 1398411.65 |  | 5 | BICUTAN | 1.1 | 1.06 | 1.06 |  |  |  |  |  |  |  |  |  | 1.067244587312381
 | 6 | CALAMBA |  |  |  |  |  | 0 |  |  |  | 430193.5 | 153960.25 | 301439.5 | 885593.25 |  | 221398.3125 |  |  | 6 | CALAMBA | Same | Same | New |  |  |  |  |  |  |  |  |  |  | 6 | CALAMBA | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 6 | CALAMBA |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0.8939642531527124
 | 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 | Same | New | GDP |  |  |  |  |  |  |  |  |  |  | 7 | CLARK | 408762.235 | 355960.275 | 444850.38 |  |  |  |  |  |  |  |  |  | 1209572.89 |  | 7 | CLARK | 1.06 | 1.1 | 1.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2273005825365687
 | 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 | New | GDP | GDP |  |  |  |  |  |  |  |  |  |  | 8 | DASMARINAS | 791688.7083333334 | 466867.44 | 901652.7000000001 |  |  |  |  |  |  |  |  |  | 2160208.848333334 |  | 8 | DASMARINAS | 4.454934898800765 | 1.04 | 1.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3125667877203273
 | 9 | DELGADO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 9 | DELGADO | GDP | GDP | New |  |  |  |  |  |  |  |  |  |  | 9 | DELGADO | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 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 | GDP | New | Same |  |  |  |  |  |  |  |  |  |  | 10 | FAIRVIEW | 252705.44 | 616770 | 574995.9400000001 |  |  |  |  |  |  |  |  |  | 1444471.38 |  | 10 | FAIRVIEW | 1.04 | 1.1 | 1.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2177434062820858
 | 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 | New | Same | Same |  |  |  |  |  |  |  |  |  |  | 11 | HARRISON | 791688.7083333334 | 335464.295 | 367372.68 |  |  |  |  |  |  |  |  |  | 1494525.683333333 |  | 11 | HARRISON |  | 1.06 | 1.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5966091201916515
 | 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] | Same | Same | New |  |  |  |  |  |  |  |  |  |  | 12 | [NAME] | 791688.7083333334 | 0 | 310669.7 |  |  |  |  |  |  |  |  |  | 1102358.408333333 |  | 12 | [NAME] | 24.51124518818952 | 0 | 1.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.4128152083555293
 | 13 | MALL OF ASIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 13 | MALL OF ASIA | Same | New | GDP |  |  |  |  |  |  |  |  |  |  | 13 | MALL OF ASIA | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 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 | New | GDP | GDP |  |  |  |  |  |  |  |  |  |  | 14 | MAKATI | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 14 | MAKATI | 15.41900298633428 | 0 |  | 0 |  | 0 |  | 0 |  |  | 0 | 0 | 5.508625978188768
 | 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 | GDP | GDP | New |  |  |  |  |  |  |  |  |  |  | 15 | MARILAO | 506831.26 | 256807.2 | 466525.675 |  |  |  |  |  |  |  |  |  | 1230164.135 |  | 15 | MARILAO | 1.04 | 1.04 | 1.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2392347095694048
 | 16 | MEGAMALL | 35367.5 | 0 | 9597 | 0 | 0 | 19194 | 0 | 0 | 0 | 93570 | 0 | 0 | 157728.5 |  | 13144.04166666667 |  |  | 16 | MEGAMALL | GDP | New | Same |  |  |  |  |  |  |  |  |  |  | 16 | MEGAMALL | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 16 | MEGAMALL | 22.38463867486628 |  | 0 |  |  | 0 |  |  |  | 0 |  |  | 5.019312986133345
 | 17 | MORONG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 17 | MORONG | New | Same | Same |  |  |  |  |  |  |  |  |  |  | 17 | MORONG | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 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 | Same | Same | New |  |  |  |  |  |  |  |  |  |  | 18 | NAGA | 791688.7083333334 | 213930.26 | 0 |  |  |  |  |  |  |  |  |  | 1005618.968333333 |  | 18 | NAGA | 19.98330809196273 | 1.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 0.5401127057604536
 | 19 | NORTH EDSA |  |  |  |  |  | 0 |  |  |  | 566749 | 5940 | 96609 | 669298 |  | 167324.5 |  |  | 19 | NORTH EDSA | Same | New | GDP |  |  |  |  |  |  |  |  |  |  | 19 | NORTH EDSA | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 19 | NORTH EDSA |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 1.18286429711927
 | 20 | NOVALICHES | 18396.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18396.75 |  | 1533.0625 |  |  | 20 | NOVALICHES | New | GDP | GDP |  |  |  |  |  |  |  |  |  |  | 20 | NOVALICHES | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 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 | GDP | GDP | New |  |  |  |  |  |  |  |  |  |  | 21 | PAMPANGA | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 21 | PAMPANGA | 32.30261779926693 | 0 |  |  | 0 |  |  |  |  |  |  |  | 5.83000694672013
 | 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 | GDP | New | Same |  |  |  |  |  |  |  |  |  |  | 22 | QUIAPO | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 22 | QUIAPO |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3327139947202211
 | 23 | [NAME] | 25048.5 | 84092 | 0 | 205051.5 | 0 | 176978 | 262420.25 | 271141 | 219760.5 | 48073.5 | 126382.75 | 71068 | 1490016 |  | 124168 |  |  | 23 | [NAME] | New | Same | Same |  |  |  |  |  |  |  |  |  |  | 23 | [NAME] | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 23 | [NAME] | 31.60623224278234 | 0 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.5313289980331307
 | 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 | Same | Same | New |  |  |  |  |  |  |  |  |  |  | 24 | ROSARIO | 394748.505 | 356283.225 | 0 |  |  |  |  |  |  |  |  |  | 751031.73 |  | 24 | ROSARIO | 1.06 | 1.06 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2248889036612597
 | 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 | Same | New | GDP |  |  |  |  |  |  |  |  |  |  | 25 | SAN LAZARO | 652716.995 | 828890.9750000001 | 889174.52 |  |  |  |  |  |  |  |  |  | 2370782.49 |  | 25 | SAN LAZARO | 1.06 | 1.1 | 1.04 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2283058479297328
 | 26 | SAN PABLO |  |  |  |  |  | 0 |  |  | 362686.5 | 43947.75 | 60193 | 93742 | 560569.25 |  | 112113.85 |  |  | 26 | SAN PABLO | New | GDP | GDP |  |  |  |  |  |  |  |  |  |  | 26 | SAN PABLO | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 26 | SAN PABLO |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 1.412294214021432
 | 27 | SOUTHMALL |  |  |  | 8337.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14997.75 | 23335.5 |  | 2592.833333333333 |  |  | 27 | SOUTHMALL | GDP | GDP | New |  |  |  |  |  |  |  |  |  |  | 27 | SOUTHMALL | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  | 0 | 33.92636576603601
 | 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 | GDP | New | Same |  |  |  |  |  |  |  |  |  |  | 28 | STA MESA | 555858.68 | 1461747.1 | 838595.9450000001 |  |  |  |  |  |  |  |  |  | 2856201.725000001 |  | 28 | STA MESA | 1.04 | 1.1 | 1.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.2276951156908044
 | 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 | New | Same | New |  |  |  |  |  |  |  |  |  |  | 29 | STA ROSA | 791688.7083333334 | 813588.9550000001 | 360180.15 |  |  |  |  |  |  |  |  |  | 1965457.813333333 |  | 29 | STA ROSA | 12.16391961793552 | 1.06 | 1.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3220809437400895
 | 30 | SUCAT |  |  | 277578 | 598090 | 639037.25 | 394302.25 | 232841.75 | 220696 | 276351.25 | 147908.5 | 159318 | 144086.75 | 3090209.75 |  | 309020.975 |  |  | 30 | SUCAT | Same | New | Same |  |  |  |  |  |  |  |  |  |  | 30 | SUCAT | 791688.7083333334 | 0 | 294232.68 |  |  |  |  |  |  |  |  |  | 1085921.388333333 |  | 30 | SUCAT |  |  | 1.06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3514070164115343
 | 31 | TANAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | TANAY | New | Same | GDP |  |  |  |  |  |  |  |  |  |  | 31 | TANAY | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 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 | Same | GDP | New |  |  |  |  |  |  |  |  |  |  | 32 | TARLAC | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 32 | TARLAC |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.186002257299705
 | 33 | TAYTAY | 122694 | 122694 | 122694 | 122694 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 2090776 |  | 174231.3333333333 |  |  | 33 | TAYTAY | GDP | Same | New |  |  |  |  |  |  |  |  |  |  | 33 | TAYTAY | 791688.7083333334 | 0 | 0 |  |  |  |  |  |  |  |  |  | 791688.7083333334 |  | 33 | TAYTAY | 6.45254623969659 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.3786578324666695
 |  |  | 4499994.25 | 7195906 | 7105830 | 10309919 | 9333560.5 | 10733572 | 9814992.75 | 10132524.25 | 9881697.5 | 6943798.5 | 4572182.5 | 8389318.25 | 98913295.5 |  | 8242774.625 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22210255.10166666 | 7184173.720000001 | 6757598.445 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36152027.26666667
` | 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