Spreadsheet: 103899d1301563898-conditional-formula-for-2011-forecast-sample-no-2
Sheet: HWL

Homeworld Linen 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2011 Marketing Drives |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Growth
 | Homeworld Linen 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 Marketing Drives |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011 Sales Forecast
 | No. | Branch | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  | Ave. Sales |  |  | No. | Branch | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New | Same / New |  | 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 | 791688.7083333334 | 791688.7083333334 | 791688.7083333334 | 990408.38 | 791688.7083333334 | 1205733.88 | 1120579.46 | 1798899.96 | 1499698.46 | 791688.7083333334 | 791688.7083333334 | 791688.7083333334 | 12157141.09833333 |  | 1 | BACOOR | 2.497316642259362 | 2.0100573061962 | 3.933353661995215 | 1.04 | 1.176787375677424 | 1.04 | 1.04 | 1.04 | 1.04 | 3.486340713894626 | 1.287871449064476 | 1.110891414089149 | 1.279663434458413
 | 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 | 346868.6666666667 | 346868.6666666667 | 376224.94 | 670546.24 | 349399.7 | 532954.5 | 447489.38 | 346868.6666666667 | 346868.6666666667 | 346868.6666666667 | 346868.6666666667 | 346868.6666666667 | 4804695.426666667 |  | 2 | BAGUIO | 1.358765314339977 | 1.100236042937083 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.679753446029192 | 2.445109017139279 | 1.081525236959036 | 1.044796154979545 | 1.135087877176477 | 1.154302259132339
 | 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 | 351898.3 | 160322.1041666667 | 160322.1041666667 | 160322.1041666667 | 252603.78 | 160322.1041666667 | 182671.32 | 413407.02 | 251429.36 | 160322.1041666667 | 160322.1041666667 | 160322.1041666667 | 2574264.509166666 |  | 3 | BALIWAG | 1.04 |  | 1.793427476226566 | 2.637538266862439 | 1.04 | 1.111285507741131 | 1.04 | 1.04 | 1.04 | 1.711024116101651 |  | 1.148799169988207 | 1.338069030129146
 | 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 | 224934.5625 | 286630.24 | 224934.5625 | 353241.46 | 325251.94 | 226050.5 | 310700 | 224934.5625 | 229290.1 | 335525.58 | 224934.5625 | 224934.5625 | 3191362.6325 |  | 4 | BATANGAS | 1.872761399068342 | 1.04 | 1.74930979373526 | 1.04 | 1.04 | 1.04 | 1.04 | 1.053621824748111 | 1.04 | 1.04 | 1.318197368112613 | 2.840271135397233 | 1.182330021166341
 | 5 | BICUTAN | 237314.75 | 390159.5 | 682826.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1310301 |  | 109191.75 |  |  | 5 | BICUTAN |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BICUTAN | 246807.34 | 405765.88 | 710139.8200000001 | 109191.75 | 109191.75 | 109191.75 | 109191.75 | 109191.75 | 109191.75 | 109191.75 | 109191.75 | 109191.75 | 2345438.79 |  | 5 | BICUTAN | 1.04 | 1.04 | 1.04 |  |  |  |  |  |  |  |  |  | 1.79
 | 6 | CALAMBA |  |  |  |  |  | 0 |  |  |  | 430193.5 | 153960.25 | 301439.5 | 885593.25 |  | 221398.3125 |  |  | 6 | CALAMBA |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | CALAMBA | 221398.3125 | 221398.3125 | 221398.3125 | 221398.3125 | 221398.3125 | 221398.3125 | 221398.3125 | 221398.3125 | 221398.3125 | 447401.24 | 221398.3125 | 313497.08 | 2974881.445 |  | 6 | CALAMBA |  |  |  |  |  |  |  |  |  | 1.04 | 1.438022557770593 | 1.04 | 3.359196160314005
 | 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 | 443455.7083333333 | 443455.7083333333 | 444850.38 | 923029.38 | 443455.7083333333 | 509934.36 | 447228.86 | 496501.46 | 443455.7083333333 | 574052.18 | 443455.7083333333 | 630926.4 | 6243801.561666667 |  | 7 | CLARK | 1.149966925964512 | 1.370381229103912 | 1.04 | 1.04 | 2.246468592946262 | 1.04 | 1.04 | 1.04 | 1.430818449668179 | 1.04 | 1.901170862378923 | 1.04 | 1.173323033231648
 | 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 | 575932.6041666666 | 575932.6041666666 | 901652.7000000001 | 804085.36 | 1225300.44 | 575932.6041666666 | 694635.76 | 577328.96 | 971135.36 | 575932.6041666666 | 575932.6041666666 | 575932.6041666666 | 8629734.205 |  | 8 | DASMARINAS | 3.240847356609017 | 1.282954982539226 | 1.04 | 1.04 | 1.04 | 1.272224658238296 | 1.04 | 1.04 | 1.04 | 1.819598848926924 | 3.182075548145805 | 1.603240829987638 | 1.248660888236887
 | 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 | 552818.6458333334 | 583128 | 564146.96 | 885916.72 | 1044201.08 | 552818.6458333334 | 552818.6458333334 | 1311474.84 | 552818.6458333334 | 552818.6458333334 | 552818.6458333334 | 700106.68 | 8405886.155 |  | 10 | FAIRVIEW | 2.275104927170015 | 1.04 | 1.04 | 1.04 | 1.04 | 5.513547988424068 | 1.326726274938027 | 1.04 | 1.46823767180984 | 1.912422267943994 | 1.754627509978816 | 1.04 | 1.267125337027532
 | 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 | 208752.7708333333 | 329134.78 | 360441.12 | 208752.7708333333 | 346376.42 | 575538.34 | 208752.7708333333 | 208752.7708333333 | 208752.7708333333 | 217696.44 | 208752.7708333333 | 208752.7708333333 | 3290456.495833334 |  | 11 | HARRISON |  | 1.04 | 1.04 | 1.725229511019284 | 1.04 | 1.04 | 2.244888801066061 | 1.97473106963574 | 1.07248913503722 | 1.04 | 1.531051668793608 | 2.185709792198908 | 1.313538052172894
 | 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] | 222528.625 | 222528.625 | 293724.08 | 222528.625 | 298445.68 | 398408.66 | 437125.26 | 442628.94 | 263561.22 | 222528.625 | 222528.625 | 222528.625 | 3469065.59 |  | 12 | [NAME] | 6.889644416235797 | 1.30541737184357 | 1.04 | 1.216535233982069 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 5.585557856425702 | 6.396154896381248 | 1.406566239167673 | 1.299108369391429
 | 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 | 53398.8 | 11976.5 | 11976.5 | 24953.76 | 11976.5 | 24016.2 | 11976.5 | 12475.32 | 11976.5 | 11976.5 | 11976.5 | 17468.88 | 216148.46 |  | 14 | MAKATI | 1.04 | 2.101693428095113 |  | 1.04 |  | 1.04 |  | 1.04 |  |  | 1.109397434116067 | 1.04 | 1.503976259062887
 | 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 | 506831.26 | 428506.7083333333 | 441078.82 | 602161.56 | 428506.7083333333 | 428506.7083333333 | 654311.06 | 428506.7083333333 | 576253.86 | 444531.88 | 428506.7083333333 | 428506.7083333333 | 5796208.689999999 |  | 15 | MARILAO | 1.04 | 1.735336768854871 | 1.04 | 1.04 | 1.070332236998904 | 1.61593626987913 | 1.04 | 1.268144641198617 | 1.04 | 1.04 | 1.116332412623173 | 1.053490436579107 | 1.127210803098085
 | 16 | MEGAMALL | 35367.5 | 0 | 9597 | 0 | 0 | 19194 | 0 | 0 | 0 | 93570 | 0 | 0 | 157728.5 |  | 13144.04166666667 |  |  | 16 | MEGAMALL |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | MEGAMALL | 36782.2 | 13144.04166666667 | 13144.04166666667 | 13144.04166666667 | 13144.04166666667 | 19961.76 | 13144.04166666667 | 13144.04166666667 | 13144.04166666667 | 97312.8 | 13144.04166666667 | 13144.04166666667 | 272353.135 |  | 16 | MEGAMALL | 1.04 |  | 1.369599006634018 |  |  | 1.04 |  |  |  | 1.04 |  |  | 1.726721137904691
 | 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 | 155155.7291666667 | 209893.84 | 155155.7291666667 | 433976.14 | 155155.7291666667 | 189267 | 268903.18 | 161500.04 | 334940.32 | 155155.7291666667 | 155155.7291666667 | 155155.7291666667 | 2529414.895 |  | 18 | NAGA | 3.916343261605772 | 1.04 | 1.584766064549297 | 1.04 | 2.439843207401292 | 1.04 | 1.04 | 1.04 | 1.04 | 1.253745677740405 |  |  | 1.358535554667857
 | 19 | NORTH EDSA |  |  |  |  |  | 0 |  |  |  | 566749 | 5940 | 96609 | 669298 |  | 167324.5 |  |  | 19 | NORTH EDSA |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | NORTH EDSA | 167324.5 | 167324.5 | 167324.5 | 167324.5 | 167324.5 | 167324.5 | 167324.5 | 167324.5 | 167324.5 | 589418.96 | 167324.5 | 167324.5 | 2429988.46 |  | 19 | NORTH EDSA |  |  |  |  |  |  |  |  |  | 1.04 | 28.16910774410774 | 1.731976316906292 | 3.630652504564484
 | 20 | NOVALICHES | 18396.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18396.75 |  | 1533.0625 |  |  | 20 | NOVALICHES |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | NOVALICHES | 19132.62 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 1533.0625 | 35996.3075 |  | 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 | 25488.84 | 23395.32 | 11316.29166666667 | 11316.29166666667 | 92343.16 | 11316.29166666667 | 11316.29166666667 | 11316.29166666667 | 11316.29166666667 | 11316.29166666667 | 11316.29166666667 | 11316.29166666667 | 243073.9449999999 |  | 21 | PAMPANGA | 1.04 | 1.04 |  |  | 1.04 |  |  |  |  |  |  |  | 1.789999999999999
 | 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 | 198290.6041666667 | 198290.6041666667 | 198290.6041666667 | 198290.6041666667 | 198290.6041666667 | 299012.48 | 321146.54 | 198290.6041666667 | 229441.42 | 198290.6041666667 | 198290.6041666667 | 453413.74 | 2889339.013333333 |  | 22 | QUIAPO |  | 1.512808396497157 | 1.414214882172892 | 1.231255400839297 | 1.042785437474829 | 1.04 | 1.04 | 1.111407199920784 | 1.04 | 1.466020277334694 | 1.04128911802186 | 1.04 | 1.214269592465071
 | 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] | 124168 | 124168 | 124168 | 213253.56 | 124168 | 184057.12 | 272917.06 | 281986.64 | 228550.92 | 124168 | 131438.06 | 124168 | 2057211.36 |  | 23 | [NAME] | 4.957103219753678 | 1.476573276887219 |  | 1.04 |  | 1.04 | 1.04 | 1.04 | 1.04 | 2.582878300935027 | 1.04 | 1.747171722856982 | 1.380663939179176
 | 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 | 387300.42 | 349560.9 | 278297.3125 | 315511.56 | 278297.3125 | 351830.96 | 278297.3125 | 678842.84 | 492159.46 | 348292.36 | 278297.3125 | 278297.3125 | 4314985.0625 |  | 24 | ROSARIO | 1.04 | 1.04 | 2.137710542133391 | 1.04 |  | 1.04 | 1.301439933501062 | 1.04 | 1.04 | 1.04 | 2.226472011824497 | 4.677737460920429 | 1.292078911260297
 | 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 | 865353.25 | 865353.25 | 889174.52 | 875323.8 | 889843.76 | 1117683.58 | 1609239.32 | 865353.25 | 865353.25 | 964123.9400000001 | 865353.25 | 1097219.24 | 11769374.41 |  | 25 | SAN LAZARO | 1.405317238598943 | 1.148388152012392 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.391098354311187 | 1.051241051395029 | 1.04 | 2.093566604187722 | 1.04 | 1.133388244434667
 | 26 | SAN PABLO |  |  |  |  |  | 0 |  |  | 362686.5 | 43947.75 | 60193 | 93742 | 560569.25 |  | 112113.85 |  |  | 26 | SAN PABLO |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | SAN PABLO | 112113.85 | 112113.85 | 112113.85 | 112113.85 | 112113.85 | 112113.85 | 112113.85 | 112113.85 | 377193.96 | 112113.85 | 112113.85 | 112113.85 | 1610446.31 |  | 26 | SAN PABLO |  |  |  |  |  |  |  |  | 1.04 | 2.551071442792862 | 1.862572890535444 | 1.195983123893239 | 2.872876651725011
 | 27 | SOUTHMALL |  |  |  | 8337.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14997.75 | 23335.5 |  | 2592.833333333333 |  |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | SOUTHMALL | 2592.833333333333 | 2592.833333333333 | 2592.833333333333 | 8671.26 | 2592.833333333333 | 2592.833333333333 | 2592.833333333333 | 2592.833333333333 | 2592.833333333333 | 2592.833333333333 | 2592.833333333333 | 15597.66 | 50197.25333333333 |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  | 1.04 | 2.151111111111111
 | 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 | 1045331.208333333 | 1382015.44 | 1045331.208333333 | 1320809.36 | 1075429.68 | 1925550.9 | 1316935.36 | 1208027.6 | 1045331.208333333 | 1045331.208333333 | 1045331.208333333 | 1664616.98 | 15120041.36166667 |  | 28 | STA MESA | 1.955792894457755 | 1.04 | 1.32131700306914 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.117713794829601 | 1.532643141572944 | 11.85034982409601 | 1.04 | 1.205362890499073
 | 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 | 508531.0208333333 | 798238.22 | 508531.0208333333 | 699261.68 | 586480.4400000001 | 1017400.8 | 531834.68 | 604442.54 | 786306.04 | 508531.0208333333 | 508531.0208333333 | 508531.0208333333 | 7566619.504166665 |  | 29 | STA ROSA | 7.813336726332232 | 1.04 | 1.553067604965645 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.652942353156597 | 1.695825541821003 | 1.872411400332239 | 1.239947219569679
 | 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 | 309020.975 | 309020.975 | 309020.975 | 622013.6 | 664598.74 | 410074.34 | 309020.975 | 309020.975 | 309020.975 | 309020.975 | 309020.975 | 309020.975 | 4477875.455 |  | 30 | SUCAT |  |  | 1.113276178227381 | 1.04 | 1.04 | 1.04 | 1.327171673464917 | 1.400211036901439 | 1.118218119150899 | 2.089271238637401 | 1.939648846960168 | 2.144686968093874 | 1.449052270642794
 | 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 | 425633.925 | 425633.925 | 425633.925 | 425633.925 | 763406.02 | 966537.78 | 425633.925 | 425633.925 | 648975.86 | 425633.925 | 425633.925 | 511027.66 | 6295018.72 |  | 32 | TARLAC |  |  |  | 1.452447482647775 | 1.04 | 1.04 | 1.137144954388252 | 1.158356970577329 | 1.04 | 4.07580161735908 | 1.262680832128157 | 1.04 | 1.478974853801891
 | 33 | TAYTAY | 122694 | 122694 | 122694 | 122694 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 2090776 |  | 174231.3333333333 |  |  | 33 | TAYTAY |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | TAYTAY | 174231.3333333333 | 174231.3333333333 | 174231.3333333333 | 174231.3333333333 | 208000 | 208000 | 208000 | 208000 | 208000 | 208000 | 208000 | 208000 | 2360925.333333333 |  | 33 | TAYTAY | 1.420047706760994 | 1.420047706760994 | 1.420047706760994 | 1.420047706760994 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.04 | 1.12921007957492
 |  |  | 4499994.25 | 7195906 | 7105830 | 10309919 | 9333560.5 | 10733572 | 9814992.75 | 10132524.25 | 9881697.5 | 6943798.5 | 4572182.5 | 8389318.25 | 98913295.5 |  | 8242774.625 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9303765.613333335 | 9963846.932500001 | 9918438.215000004 | 11768944.99083333 | 11180518.46083333 | 12505063.8225 | 11248832.01083333 | 11841492.26416667 | 11407014.85666667 | 9891370.484166669 | 8731452.330833333 | 10361205.60333334 | 128121945.585
` | 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