Spreadsheet: 103646d1301395428-perform-calculation-using-variable-percentage-based-on-other-cell-values-part-2-sample-no-2
Sheet: HWL

Homeworld Linen 2010 Official Gross Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2011 Marketing Drives |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Homeworld Linen 2010 Official Gross Sales
 | 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
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 1 | BACOOR | 348717.325 | 433250.1250000001 | 221403.325 | 1047547.325 | 740029.675 | 637647.7250000001 | 1185228.275 | 951341.3250000001 | 793109.7625000001 | 249791.3 | 676199.15 | 783926.8250000001 | 8068192.137500001
 | 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 | New | New | New | New | New | New | New | New | New | New | New |  |  | 2 | BAGUIO | 280810.475 | 346794.25 | 397930.225 | 354615.8 | 369557.3750000001 | 281850.9375 | 473306.075 | 227149.725 | 200000 | 352793.925 | 365196.15 | 336146.25 | 3986151.1875
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 3 | BALIWAG | 186100.0625 | 200000 | 200000 | 200000 | 133588.5375 | 200000 | 200000 | 218628.7125 | 132967.45 | 200000 | 200000 | 200000 | 2271284.7625
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 4 | BATANGAS | 200000 | 303166.6 | 200000 | 186810.3875 | 172008.2375 | 239091.875 | 328625 | 234835.7 | 242518.375 | 177441.4125 | 200000 | 200000 | 2684497.5875
 | 5 | BICUTAN | 237314.75 | 390159.5 | 682826.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1310301 |  | 109191.75 |  |  | 5 | BICUTAN | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 5 | BICUTAN | 130523.1125 | 214587.725 | 375554.7125 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 1620665.55
 | 6 | CALAMBA |  |  |  |  |  | 0 |  |  |  | 430193.5 | 153960.25 | 301439.5 | 885593.25 |  | 221398.3125 |  |  | 6 | CALAMBA | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 6 | CALAMBA | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 236606.425 | 200000 | 331583.45 | 2568189.875
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 7 | CLARK | 424187.225 | 355960.275 | 470514.825 | 488140.5375 | 217141.375 | 539353.65 | 473030.525 | 525145.775 | 340924.65 | 607170.5750000001 | 256579.4 | 333663 | 5031811.8125
 | 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 | New | New | New | New | New | New | New | New | New | New | New |  |  | 8 | DASMARINAS | 200000 | 493802.1 | 476835.5625000001 | 850474.9 | 647995.425 | 497966.975 | 734710.9 | 610636.4 | 513581.2000000001 | 348167.875 | 200000 | 395153.275 | 5969324.612500001
 | 9 | DELGADO |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 9 | DELGADO | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 9 | DELGADO |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 10 | FAIRVIEW | 267284.6 | 616770 | 596693.9 | 468513.65 | 552221.7250000001 | 200000 | 458346.6250000001 | 693568.425 | 414170.35 | 317973.975 | 346569.575 | 740497.4500000001 | 5672610.274999999 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40000
 | 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 | New | New | New | New | New | New | New | New | New | New | New |  |  | 11 | HARRISON | 200000 | 174061.6625 | 190617.9 | 200000 | 183179.8375 | 304371.2375 | 200000 | 200000 | 214107.575 | 230255.85 | 200000 | 200000 | 2496594.0625
 | 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] | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 12 | [NAME] | 200000 | 200000 | 310669.7 | 201212 | 315663.7 | 210696.8875 | 231172.0125 | 234082.6125 | 278766.675 | 200000 | 200000 | 200000 | 2782263.5875
 | 13 | MALL OF ASIA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 13 | MALL OF ASIA | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 13 | MALL OF ASIA |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 14 | MAKATI | 51345 | 5698.5 | 0 | 23994 | 0 | 23092.5 | 0 | 11995.5 | 0 | 0 | 10795.5 | 16797 | 143718 |  | 11976.5 |  |  | 14 | MAKATI | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 14 | MAKATI |  |  |  |  |  |  |  |  |  |  |  |  | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 15 | MARILAO | 536071.525 | 271623 | 466525.675 | 636901.65 | 440384.175 | 291693.05 | 346029.8875 | 371690.55 | 609499.275 | 470177.95 | 422237.475 | 447424.45 | 5310258.6625
 | 16 | MEGAMALL | 35367.5 | 0 | 9597 | 0 | 0 | 19194 | 0 | 0 | 0 | 93570 | 0 | 0 | 157728.5 |  | 13144.04166666667 |  |  | 16 | MEGAMALL | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 16 | MEGAMALL |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 17 | MORONG |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 17 | MORONG | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 17 | MORONG |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 18 | NAGA | 200000 | 222003.1 | 200000 | 229506.6125 | 200000 | 200186.25 | 142208.4125 | 200000 | 177131.9 | 200000 | 200000 | 200000 | 2371036.275
 | 19 | NORTH EDSA |  |  |  |  |  | 0 |  |  |  | 566749 | 5940 | 96609 | 669298 |  | 167324.5 |  |  | 19 | NORTH EDSA | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 19 | NORTH EDSA | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 311711.95 | 200000 | 200000 | 2511711.95
 | 20 | NOVALICHES | 18396.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18396.75 |  | 1533.0625 |  |  | 20 | NOVALICHES | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 20 | NOVALICHES |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 21 | PAMPANGA | 24508.5 | 22495.5 | 0 | 0 | 88791.5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 135795.5 |  | 11316.29166666667 |  |  | 21 | PAMPANGA | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 21 | PAMPANGA |  |  |  |  |  |  |  |  |  |  |  |  | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 22 | QUIAPO | 200000 | 200000 | 200000 | 200000 | 209170.225 | 158131.6 | 169837.1125 | 200000 | 242678.425 | 200000 | 209470.8 | 239786.1125 | 2429074.275
 | 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 | New | New | New | New | New | New | New | New | New | New | New |  |  | 23 | [NAME] | 100000 | 100000 | 100000 | 112778.325 | 100000 | 100000 | 144331.1375 | 149127.55 | 120868.275 | 100000 | 100000 | 100000 | 1327105.2875
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 24 | ROSARIO | 409644.675 | 369727.8750000001 | 200000 | 333714.15 | 200000 | 372128.9 | 235221.8 | 359003.425 | 260276.6375 | 368386.15 | 200000 | 200000 | 3508103.6125
 | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 25 | SAN LAZARO | 677347.8250000001 | 828890.9750000001 | 940473.05 | 925823.2500000001 | 941180.9 | 1182165.325 | 851040.025 | 684271.2250000001 | 905490.3 | 1019746.475 | 454673.175 | 1160520.35 | 10571622.875
 | 26 | SAN PABLO |  |  |  |  |  | 0 |  |  | 362686.5 | 43947.75 | 60193 | 93742 | 560569.25 |  | 112113.85 |  |  | 26 | SAN PABLO | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 26 | SAN PABLO | 112113.85 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 100000 | 199477.575 | 100000 | 100000 | 100000 | 1311591.425
 | 27 | SOUTHMALL |  |  |  | 8337.75 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 14997.75 | 23335.5 |  | 2592.833333333333 |  |  | 27 | SOUTHMALL | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 27 | SOUTHMALL |  |  |  |  |  |  |  |  |  |  |  |  | 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 | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 28 | STA MESA | 1045331.208333333 | 1461747.1 | 870241.0750000001 | 1397009.9 | 1137473.7 | 1018320.1875 | 1392912.4 | 1277721.5 | 1028764.55 | 750249.2250000001 | 200000 | 880326.2875000001 | 12460097.13333333
 | 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 | New | New | New | New | New | New | New | New | New | New | New |  |  | 29 | STA ROSA | 200000 | 422145.2125 | 360180.15 | 739603.7000000001 | 620315.8500000001 | 538048.5 | 562517.4500000001 | 639314.2250000001 | 415834.925 | 338417.2 | 329859.475 | 298750.65 | 5464987.3375
 | 30 | SUCAT |  |  | 277578 | 598090 | 639037.25 | 394302.25 | 232841.75 | 220696 | 276351.25 | 147908.5 | 159318 | 144086.75 | 3090209.75 |  | 309020.975 |  |  | 30 | SUCAT | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 30 | SUCAT | 200000 | 200000 | 305335.8 | 328949.5 | 351470.4875 | 433732.475 | 256125.925 | 242765.6 | 303986.375 | 200000 | 200000 | 200000 | 3222366.1625
 | 31 | TANAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A |  |  | 31 | TANAY | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 31 | TANAY |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | 32 | TARLAC |  |  |  | 293046 | 734044.25 | 929363.25 | 374300.5 | 367446.25 | 624015.25 | 104429.5 | 337087.5 | 491372.75 | 4255105.25 |  | 472789.4722222222 |  |  | 32 | TARLAC | New | New | New | New | New | New | New | New | New | New | New | New |  |  | 32 | TARLAC | 200000 | 200000 | 200000 | 322350.6 | 403724.3375 | 511149.7875 | 411730.55 | 404190.8750000001 | 686416.775 | 200000 | 370796.2500000001 | 540510.025 | 4450869.2
 | 33 | TAYTAY | 122694 | 122694 | 122694 | 122694 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 200000 | 2090776 |  | 174231.3333333333 |  |  | 33 | TAYTAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | TAYTAY | 200000 | 200000 | 200000 | 200000 | 208000 | 208000 | 208000 | 208000 | 208000 | 208000 | 208000 | 208000 | 2464000
 |  |  | 4498760.25 | 7195906 | 7105830 | 10309919 | 9333560.5 | 10733572 | 9814992.75 | 10132524.25 | 9881697.5 | 6943798.5 | 4572182.5 | 8389318.25 | 98912061.5 |  | 8242671.791666667 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6918131.883333333 | 8314530 | 7982975.9 | 10023952.2875 | 8743105.5625 | 8724535.3625 | 9604374.112500003 | 9231473.624999998 | 8788571.05 | 7486890.287500001 | 6139581.45 | 8596288.125 | 100554409.6458333
` | 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 provided that its greater than 200,000
 | 5 | If 2010 Sales is lower than 2010 ave.sales, 2011 forecast is equal to ave.sales provided that its greater than 200,000, if the average sales is lower than 200,000 by default it will take the minimum forecast of 200,000
 | 6 | If 2010 Sales is greater than 2010 ave.sales, 2011 forecast is equal to 2010 sales + growth factors