Spreadsheet: 129494d1321634713-excel-2007-combining-if-then-with-rounding-excel-help_111811
Sheet: Sheet1

PUMP | LINE | Family | STANDARD COST | 12 MO  SALES |  | MIN |  |  | RUN |  |  | MAX
 |  |  |  |  | Weekly | Qty | Weeks On Hand | $ | Qty | X Per Year | $ | Qty | Weeks On Hand | $
MM-43 | cnc | 25 | 38.8469 | 88 | 1.692307692307692 | 13.53846153846154 | 8 | 525.9272615384615 |  | 1 | 3418.5272 | 101.5384615384615 | 60 | 3944.454461538461
MM354-367S | cnc | 0 | 13.4761 | 88 | 1.692307692307692 | 13.53846153846154 | 8 | 182.4456615384615 |  | 1 | 1185.8968 | 101.5384615384615 | 60 | 1368.342461538462
M68149014AA | cnc | 189 | 115.7456 | 75 | 1.442307692307692 | 11.53846153846154 | 8 | 1335.526153846154 |  | 1 | 8680.92 | 86.53846153846153 | 60 | 10016.44615384615
M68148833AA | cnc | 189 | 115.3281 | 75 | 1.442307692307692 | 11.53846153846154 | 8 | 1330.708846153846 |  | 1 | 8649.6075 | 86.53846153846153 | 60 | 9980.316346153846
MM-71C | cnc | 71C | 48.273 | 73 | 1.403846153846154 | 11.23076923076923 | 8 | 542.1429230769231 |  | 1 | 3523.929 | 84.23076923076923 | 60 | 4066.071923076923
MM130 | cnc | 132 | 46.0172 | 73 | 1.403846153846154 | 11.23076923076923 | 8 | 516.8085538461538 |  | 1 | 3359.2556 | 84.23076923076923 | 60 | 3876.064153846154
MM10176 | cnc | 176 | 61.7062 | 69 | 1.326923076923077 | 10.61538461538461 | 8 | 655.0350461538461 |  | 1 | 4257.727800000001 | 79.61538461538461 | 60 | 4912.762846153846
MM-90A | cnc | 90A | 44.2278 | 69 | 1.326923076923077 | 10.61538461538461 | 8 | 469.4951076923077 |  | 1 | 3051.7182 | 79.61538461538461 | 60 | 3521.213307692308
MM10070-800SS | cnc | 10070 | 207.0518 | 66 | 1.269230769230769 | 10.15384615384615 | 8 | 2102.372123076923 |  | 1 | 13665.4188 | 76.15384615384616 | 60.00000000000001 | 15767.79092307692
M73277-93 | cnc | 79HVLS_HMT | 46.2685 | 63 | 1.211538461538461 | 9.692307692307692 | 8 | 448.4485384615385 |  | 1 | 2914.9155 | 72.6923076923077 | 60.00000000000001 | 3363.364038461539
MM10990 | cnc | 10770 | 56.1321 | 61 | 1.173076923076923 | 9.384615384615385 | 8 | 526.7781692307693 |  | 1 | 3424.0581 | 70.38461538461539 | 60 | 3950.83626923077
MM346 | cnc | 346 | 55.1312 | 58 | 1.115384615384615 | 8.923076923076923 | 8 | 491.9399384615385 |  | 1 | 3197.6096 | 66.92307692307692 | 59.99999999999999 | 3689.549538461538
MM139 | cnc | 139 | 43.8767 | 56 | 1.076923076923077 | 8.615384615384615 | 8 | 378.0146461538461 |  | 1 | 2457.0952 | 64.61538461538461 | 60 | 2835.109846153846
MM10774 | cnc | 10774 | 39.0247 | 54 | 1.038461538461539 | 8.307692307692308 | 8 | 324.2052 |  | 1 | 2107.3338 | 62.30769230769231 | 59.99999999999999 | 2431.539
MM-89 | cnc | 89 | 42.3488 | 51 | 0.9807692307692307 | 7.846153846153846 | 8 | 332.2752 |  | 1 | 2159.7888 | 58.84615384615385 | 60 | 2492.064
MM10550C | cnc | 10550C | 37.4759 | 51 | 0.9807692307692307 | 7.846153846153846 | 8 | 294.0416769230769 |  | 1 | 1911.2709 | 58.84615384615385 | 60 | 2205.312576923077
MM-90N | cnc | 152 | 72.1281 | 50 | 0.9615384615384616 | 7.692307692307693 | 8 | 554.8315384615385 |  | 1 | 3606.405 | 57.69230769230769 | 60 | 4161.236538461539
MM187S | cnc | 187 | 52.6701 | 49 | 0.9423076923076923 | 7.538461538461538 | 8 | 397.051523076923 |  | 1 | 2580.8349 | 56.53846153846154 | 60 | 2977.886423076923
[NAME] | cnc | 94C | 47.5608 | 49 | 0.9423076923076923 | 7.538461538461538 | 8 | 358.5352615384616 |  | 1 | 2330.4792 | 56.53846153846154 | 60 | 2689.014461538462
MM-79D | cnc | 79D | 21.8128 | 48 | 0.9230769230769231 | 7.384615384615385 | 8 | 161.0791384615385 |  | 1 | 1047.0144 | 55.38461538461539 | 60 | 1208.093538461538
MM-41 | cnc | 41 | 51.1899 | 46 | 0.8846153846153846 | 7.076923076923077 | 8 | 362.2669846153846 |  | 1 | 2354.7354 | 53.07692307692308 | 60.00000000000001 | 2717.002384615385
MM-27B | cnc | 27 | 80.9817 | 45 | 0.8653846153846154 | 6.923076923076923 | 8 | 560.6425384615385 |  | 1 | 3644.1765 | 51.92307692307692 | 59.99999999999999 | 4204.819038461538
MM10050-825SS | cnc | 10050 | 304.257 | 42 | 0.8076923076923077 | 6.461538461538462 | 8 | 1965.968307692308 |  | 1 | 12778.794 | 48.46153846153846 | 60 | 14744.76230769231
MM-67 | cnc | 67 | 38.0673 | 41 | 0.7884615384615384 | 6.307692307692307 | 8 | 240.1168153846154 |  | 1 | 1560.7593 | 47.30769230769231 | 60 | 1800.876115384616
MM-79CHV | cnc | 79C | 27.8708 | 40 | 0.7692307692307693 | 6.153846153846154 | 8 | 171.5126153846154 |  | 1 | 1114.832 | 46.15384615384615 | 59.99999999999999 | 1286.344615384615
MM10050-700CT | cnc | 10050 | 308.4469 | 39 | 0.75 | 6 | 8 | 1850.6814 |  | 1 | 12029.4291 | 45 | 60 | 13880.1105
MM-50 | cnc | 50 | 48.7431 | 37 | 0.7115384615384616 | 5.692307692307693 | 8 | 277.4607230769231 |  | 1 | 1803.4947 | 42.69230769230769 | 60 | 2080.955423076923
M73159-12 | cnc | 79HVLS_HMT | 27.4283 | 37 | 0.7115384615384616 | 5.692307692307693 | 8 | 156.1303230769231 |  | 1 | 1014.8471 | 42.69230769230769 | 60 | 1170.977423076923
MM177 | cnc | 177 | 62.8583 | 36 | 0.6923076923076923 | 5.538461538461538 | 8 | 348.1382769230769 |  | 1 | 2262.8988 | 41.53846153846154 | 60.00000000000001 | 2611.037076923077
MM190HV | cnc | 190 | 54.3094 | 36 | 0.6923076923076923 | 5.538461538461538 | 8 | 300.790523076923 |  | 1 | 1955.1384 | 41.53846153846154 | 60.00000000000001 | 2255.928923076923
MM-61 | cnc | 61 | 21.3795 | 34 | 0.6538461538461539 | 5.230769230769231 | 8 | 111.8312307692308 |  | 1 | 726.903 | 39.23076923076923 | 60 | 838.7342307692309
MM-28GS | cnc | 28 | 59.6066 | 32 | 0.6153846153846154 | 4.923076923076923 | 8 | 293.4478769230769 |  | 1 | 1907.4112 | 36.92307692307692 | 59.99999999999999 | 2200.859076923077
MM351 | cnc | 351 | 69.2706 | 31 | 0.5961538461538461 | 4.769230769230769 | 8 | 330.3674769230769 |  | 1 | 2147.3886 | 35.76923076923077 | 59.99999999999999 | 2477.756076923077
[NAME] | cnc | 342 | 51.5245 | 31 | 0.5961538461538461 | 4.769230769230769 | 8 | 245.7322307692308 |  | 1 | 1597.2595 | 35.76923076923077 | 59.99999999999999 | 1842.991730769231
MM-40 | cnc | 25 | 44.9706 | 26 | 0.5 | 4 | 8 | 179.8824 |  | 1 | 1169.2356 | 30 | 60 | 1349.118
MM-96A | cnc | 96A | 35.5354 | 25 | 0.4807692307692308 | 3.846153846153846 | 8 | 136.6746153846154 |  | 1 | 888.3850000000001 | 28.84615384615385 | 60 | 1025.059615384615
MM-25 | cnc | 25 | 40.4931 | 24 | 0.4615384615384616 | 3.692307692307693 | 8 | 149.5129846153846 |  | 1 | 971.8344 | 27.69230769230769 | 60 | 1121.347384615385
MM-79BHV | cnc | 79HV | 27.5278 | 23 | 0.4423076923076923 | 3.538461538461538 | 8 | 97.40606153846153 |  | 1 | 633.1394 | 26.53846153846154 | 60.00000000000001 | 730.5454615384616
MM-67A | cnc | 67 | 37.7984 | 22 | 0.4230769230769231 | 3.384615384615385 | 8 | 127.9330461538461 |  | 1 | 831.5648 | 25.38461538461538 | 60 | 959.4978461538461
MM-63L | cnc | 63 | 17.1904 | 22 | 0.4230769230769231 | 3.384615384615385 | 8 | 58.18289230769231 |  | 1 | 378.1888 | 25.38461538461538 | 60 | 436.3716923076923
MM-51 | cnc | 50 | 52.8554 | 21 | 0.4038461538461539 | 3.230769230769231 | 8 | 170.7636 |  | 1 | 1109.9634 | 24.23076923076923 | 60 | 1280.727
MM-64 | cnc | 64 | 23.8637 | 21 | 0.4038461538461539 | 3.230769230769231 | 8 | 77.09810769230769 |  | 1 | 501.1377000000001 | 24.23076923076923 | 60 | 578.2358076923077
MM-27D | cnc | 27D | 74.7996 | 20 | 0.3846153846153846 | 3.076923076923077 | 8 | 230.1526153846154 |  | 1 | 1495.992 | 23.07692307692308 | 59.99999999999999 | 1726.144615384615
MM-23A | cnc | 23A | 39.9488 | 20 | 0.3846153846153846 | 3.076923076923077 | 8 | 122.9193846153846 |  | 1 | 798.976 | 23.07692307692308 | 59.99999999999999 | 921.8953846153846
M73277-92 | cnc | 79 | 33.5282 | 20 | 0.3846153846153846 | 3.076923076923077 | 8 | 103.1636923076923 |  | 1 | 670.564 | 23.07692307692308 | 59.99999999999999 | 773.7276923076922
MM-75 | cnc | 75 | 36.5487 | 16 | 0.3076923076923077 | 2.461538461538462 | 8 | 89.96603076923077 |  | 1 | 584.7792 | 18.46153846153846 | 59.99999999999999 | 674.7452307692306
MM10990C | cnc | 10778C | 51.8105 | 15 | 0.2884615384615384 | 2.307692307692307 | 8 | 119.5626923076923 |  | 1 | 777.1574999999999 | 17.30769230769231 | 60 | 896.7201923076922
MM10050-750SS | cnc | 10050 | 291.2969 | 14 | 0.2692307692307692 | 2.153846153846154 | 8 | 627.4087076923076 |  | 1 | 4078.1566 | 16.15384615384615 | 60 | 4705.565307692307
MM-79A | cnc | 79 | 24.5171 | 14 | 0.2692307692307692 | 2.153846153846154 | 8 | 52.80606153846153 |  | 1 | 343.2394 | 16.15384615384615 | 60 | 396.0454615384615
[NAME] | cnc | 4G7V 6621 BB | 360.6878 | 13 | 0.25 | 2 | 8 | 721.3756 |  | 1 | 4688.9414 | 15 | 60 | 5410.317
MM254 | cnc | 147 | 32.6575 | 11 | 0.2115384615384615 | 1.692307692307692 | 8 | 55.26653846153846 |  | 1 | 359.2325 | 12.69230769230769 | 60 | 414.4990384615384
M73159-11 | cnc | 79 | 18.3267 | 10 | 0.1923076923076923 | 1.538461538461539 | 8 | 28.19492307692308 |  | 1 | 183.267 | 11.53846153846154 | 59.99999999999999 | 211.4619230769231
MM105 | cnc | 27 | 71.1957 | 9 | 0.1730769230769231 | 1.384615384615385 | 8 | 98.57866153846155 |  | 1 | 640.7613 | 10.38461538461539 | 60.00000000000001 | 739.3399615384616
MM-67C | cnc | 67 | 37.3555 | 9 | 0.1730769230769231 | 1.384615384615385 | 8 | 51.723 |  | 1 | 336.1995 | 10.38461538461539 | 60.00000000000001 | 387.9225
MM-37R | cnc | 37 | 74.0369 | 7 | 0.1346153846153846 | 1.076923076923077 | 8 | 79.73204615384616 |  | 1 | 518.2583 | 8.076923076923077 | 60 | 597.9903461538462
MM181 | cnc | 181 | 48.7886 | 7 | 0.1346153846153846 | 1.076923076923077 | 8 | 52.54156923076923 |  | 1 | 341.5202 | 8.076923076923077 | 60 | 394.0617692307692
MM10055-825SS | cnc | 10055 | 307.0102 | 6 | 0.1153846153846154 | 0.9230769230769231 | 8 | 283.3940307692308 |  | 1 | 1842.0612 | 6.923076923076923 | 60 | 2125.455230769231
MM10070-900SS | cnc | 10070 | 201.3238 | 6 | 0.1153846153846154 | 0.9230769230769231 | 8 | 185.8373538461539 |  | 1 | 1207.9428 | 6.923076923076923 | 60 | 1393.780153846154
[NAME] | cnc | 27 | 83.0705 | 5 | 0.09615384615384616 | 0.7692307692307693 | 8 | 63.90038461538462 |  | 1 | 415.3525 | 5.769230769230769 | 59.99999999999999 | 479.2528846153846
MM-79C | cnc | 79C | 24.4293 | 5 | 0.09615384615384616 | 0.7692307692307693 | 8 | 18.79176923076923 |  | 1 | 122.1465 | 5.769230769230769 | 59.99999999999999 | 140.9382692307692
MM10055-750SS | cnc | 10055 | 294.0501 | 4 | 0.07692307692307693 | 0.6153846153846154 | 8 | 180.9539076923077 |  | 1 | 1176.2004 | 4.615384615384615 | 59.99999999999999 | 1357.154307692308
MM350 | cnc | 350 | 57.5309 | 4 | 0.07692307692307693 | 0.6153846153846154 | 8 | 35.40363076923077 |  | 1 | 230.1236 | 4.615384615384615 | 59.99999999999999 | 265.5272307692308
MM-79G | cnc | 79D | 21.8928 | 4 | 0.07692307692307693 | 0.6153846153846154 | 8 | 13.47249230769231 |  | 1 | 87.5712 | 4.615384615384615 | 59.99999999999999 | 101.0436923076923
MM-58H | cnc | 58 | 20.5983 | 4 | 0.07692307692307693 | 0.6153846153846154 | 8 | 12.67587692307692 |  | 1 | 82.3932 | 4.615384615384615 | 59.99999999999999 | 95.0690769230769
MM-96F | cnc | 96F | 66.6917 | 3 | 0.0576923076923077 | 0.4615384615384616 | 8 | 30.78078461538461 |  | 1 | 200.0751 | 3.461538461538462 | 60 | 230.8558846153846
[NAME] | cnc | 70 | 31.0191 | 3 | 0.0576923076923077 | 0.4615384615384616 | 8 | 14.31650769230769 |  | 1 | 93.0573 | 3.461538461538462 | 60 | 107.3738076923077
MM10055-700CT | cnc | 10055 | 311.2001 | 2 | 0.03846153846153846 | 0.3076923076923077 | 8 | 95.75387692307693 |  | 1 | 622.4002 | 2.307692307692307 | 59.99999999999999 | 718.1540769230769
MM10070-1000SS | cnc | 10070 | 253.7752 | 1 | 0.01923076923076923 | 0.1538461538461539 | 8 | 39.04233846153846 |  | 1 | 253.7752 | 1.153846153846154 | 59.99999999999999 | 292.8175384615384
MM10077-800SS | cnc | 10077 | 233.1534 | 1 | 0.01923076923076923 | 0.1538461538461539 | 8 | 35.86975384615385 |  | 1 | 233.1534 | 1.153846153846154 | 59.99999999999999 | 269.0231538461538
MM10077-900SS | cnc | 10077 | 227.4254 | 1 | 0.01923076923076923 | 0.1538461538461539 | 8 | 34.98852307692308 |  | 1 | 227.4254 | 1.153846153846154 | 59.99999999999999 | 262.413923076923