Spreadsheet: 716436d1612207757-formula-to-only-calculate-if-that-cell-is-marked-act-otherwise-zero-out-excelforum
Sheet: Sheet2

Scenario A
 | January | February | March | April | May | June | July | August | September | October | November | December
Total Company
Division 1
Region A | 65382 | 69199 | 60168 | 70076.41197774015 | 76065.33967459128 | 78350.14446059566 | 82520.70399536751 | 90867.02023651187 | 70720.39559854765 | 70117 | 73679 | 56515
Region B | 49466 | 50014 | 45702 | 51824.94393464326 | 53238.98704736405 | 63945.68015992721 | 56250.64869069148 | 61186.60201177871 | 47498.85272574052 | 55718 | 54869 | 49513.55365016301
Region C | 87377 | 89299 | 75627 | 82803.59492267213 | 76315.79001026491 | 91145.92027030425 | 89620.08230681498 | 78865.54204635772 | 71966.57546694032 | 79136 | 82372 | 67816
Region D | 37906 | 40312 | 35649 | 38656.13408321063 | 40896.93680014006 | 56318.33387796635 | 55066.33781238947 | 49794.98092567053 | 37921.25853955421 | 42285 | 41369 | 39751.54226059934
Division 2
Region E | 47188 | 49675 | 43921 | 48907.94532915232 | 46389.62643175908 | 58791.72507756263 | 66544.53791058577 | 70805.09996805617 | 61978.60192490852 | 58254 | 54943 | 44349
Region F | 48163 | 51091 | 45214 | 49201.10222235444 | 49499.34611539767 | 63515.91421547666 | 67494.94311588365 | 72514.52805205587 | 61518.54177019584 | 58590 | 55857 | 45250
Region G | 33527 | 35952 | 31481 | 35044.36331793104 | 33034.38162165243 | 41323.14273226756 | 47879.5342895618 | 45290.42055822181 | 44490.09955514269 | 41673 | 39957 | 34765
Region H | 26894 | 28714 | 25019 | 27379.65339386649 | 27088.97491655096 | 32012.37739760971 | 34424.90738161343 | 33275.83181194679 | 32276.09570667755 | 29188 | 29519 | 23812
Region I | 16441 | 17141 | 14637 | 15311.54202994706 | 16534.12355163569 | 18773.71687922155 | 23035.38037652745 | 22124.89460123905 | 21470.7329489343 | 19428 | 19655 | 15463
Division 3
Region J | 47505 | 51844 | 45961 | 46273.62676607849 | 50561.6254137859 | 48543.07203769976 | 46528.07034266491 | 54946.54752870989 | 50953.78369030051 | 57711 | 52628 | 45538
Region K | 25044 | 25652 | 23797 | 27785.16991558855 | 31474.16357615999 | 30249.93937090285 | 31031.48938663396 | 35189.67702482668 | 29712.6520663719 | 31020 | 29519 | 25549
Region L | 33480 | 35094 | 31608 | 34493.25600978025 | 36819.98166038891 | 38398.83967335484 | 38056.7704332996 | 40312.20608584314 | 35457.11520738716 | 39400 | 36482 | 36124.32723374967
Region M | 11356 | 12670 | 10951 | 11948.90977953821 | 12171.88684687082 | 11587.20180989641 | 11767.37720559568 | 13103.16880382065 | 11642.57268025658 | 14020 | 13052 | 10604
Region N | 21543 | 22679 | 20732 | 20745.84990328769 | 23320.53716955232 | 22012.10133834819 | 21385.03816510278 | 24434.80022171211 | 24032.03589274881 | 26335 | 24529 | 20110
Region O | 11857 | 12049 | 10825 | 11777.34207730246 | 14072.74799545323 | 14897.28763112042 | 14404.23703233569 | 16138.56711617223 | 14607.55524686061 | 15551 | 13104 | 13342.95511393418
Scenario B
Total Company
Division 1
Region A | 75000 | 69199 | 60168 | 42321 | 50992 | 59264 | 61893 | 67637 | 64746 | 70117 | 73679 | 56515
Region B | 75000 | 50014 | 45702 | 23139 | 29938 | 39610 | 41658 | 41537 | 40722 | 55718 | 54869 | 33775
Region C | 75000 | 89299 | 75627 | 41716 | 45862 | 59183 | 62916 | 62657 | 65313 | 79136 | 82372 | 67816
Region D | 75000 | 40312 | 35649 | 20151 | 24865 | 36506 | 38295 | 37088 | 33711 | 42285 | 41369 | 25138
Division 2
Region E | 50000 | 49675 | 43921 | 48907.94532915232 | 46389.62643175908 | 58791.72507756263 | 66544.53791058577 | 70805.09996805617 | 61978.60192490852 | 58254 | 54943 | 44349
Region F | 50000 | 51091 | 45214 | 49201.10222235444 | 49499.34611539767 | 63515.91421547666 | 67494.94311588365 | 72514.52805205587 | 61518.54177019584 | 58590 | 55857 | 45250
Region G | 50000 | 35952 | 31481 | 35044.36331793104 | 33034.38162165243 | 41323.14273226756 | 47879.5342895618 | 45290.42055822181 | 44490.09955514269 | 41673 | 39957 | 34765
Region H | 50000 | 28714 | 25019 | 27379.65339386649 | 27088.97491655096 | 32012.37739760971 | 34424.90738161343 | 33275.83181194679 | 32276.09570667755 | 29188 | 29519 | 23812
Region I | 50000 | 17141 | 14637 | 15311.54202994706 | 16534.12355163569 | 18773.71687922155 | 23035.38037652745 | 22124.89460123905 | 21470.7329489343 | 19428 | 19655 | 15463
Division 3
Region J | 33000 | 51844 | 45961 | 22973 | 28500 | 30860 | 34891 | 54588 | 50832 | 57711 | 52628 | 45538
Region K | 33000 | 25652 | 23797 | 17007 | 21025 | 22389 | 23138 | 23630 | 29242 | 31020 | 29519 | 25549
Region L | 33000 | 35094 | 31608 | 19426 | 22418 | 26533 | 29261 | 37676 | 35267 | 39400 | 36482 | 26059
Region M | 33000 | 12670 | 10951 | 5558 | 6971 | 7735 | 9280 | 12994 | 11588 | 14020 | 13052 | 10604
Region N | 33000 | 22679 | 20732 | 10063 | 13163 | 14178 | 16632 | 24271 | 23535 | 26335 | 24529 | 20110
Region O | 33000 | 12049 | 10825 | 6627 | 8302 | 10185 | 11340 | 16071 | 14568 | 15551 | 13104 | 8944