Spreadsheet: 784691d1655908496-multiple-ifs-on-providing-price-increase-based-on-annual-quarterly-or-semi-annually-price_increase_excel
Sheet: Data

 |  |  |  |  |  |  |  | Annually | 1 |  |  |  |  |  |  | Old Rates |  |  |  |  |  |  |  |  |  |  |  |  | New Rates
 |  |  |  |  |  |  |  | Semi-annually | 6
 |  |  |  |  |  |  |  | Quaterly | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun |  | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY23 |  |  |  |  |  |  |  |  |  |  |  |  | FY23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FY23 |  |  |  |  |  |  |  |  |  |  |  | Frequency
 |  |  |  |  |  |  |  | Frequency of increase | Frequency | [NAME] | Effective Date (MM/DD/YY) | 1st price increase % | 2nd price increase % | 3rd price increase % | 4th price increase % | P01 Old rate | P02 Old rate | P03 Old rate | P04 Old rate | P05 Old rate | [NAME] | P07 Old rate | P08 Old Rate | P09 Old rate | P10 Old Rate | P11 Old rate | P12 Old Rate | Total | P01 | P02 | P03 | P04 | P05 | P06 | P07 | P08 | P09 | P10 | P11 | P12 | Total | 12 month Impact |  | Latest Comment |  |  |  |  |  |  |  | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12
 |  |  |  |  |  |  |  | Semi-annually |  | Approved | 2022-07-01 00:00:00 | 0.097 | 0.04 |  |  | 50317.29857642756 | 58122.79250655506 | 43035.86996352076 | 62182.32687381041 | 38155.32785784871 | 50028.54064838548 | 36044.11903481081 | 36044.11903481081 | 54891.15311546103 | 45055.14879351352 | 66080.88489715316 | 66080.88489715316
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 16444.28522934745 | 81104.79683409409 | 88230.38939391875 | 46558.60855494861 | 44863.28609922319 | 58961.41905121665 | 44509.84224990264 | 44509.84224990264 | 67783.50065165487 | 55637.30281237829 | 81601.37745815486 | 81601.37745815486
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  | Quaterly |  | Approved | 2022-09-01 00:00:00 | 0.035 | 0.035 | 0.035 | 0.035 | 105525.012 | 291685.7864999999 | 240792.5960000001 | 199618.6301114059 | 202009.4189005579 | 214859.4084069759 | 154799.9999999999 | 154799.9999999999 | 235743.0485141545 | 193500.0000000001 | 283799.9999999999 | 283799.9999999999
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 89121.72369507227 | 96742.03680482839 | 169035.7679999999 | 134218.18414184 | 89540.49399221214 | 137909.7598147101 | 104129.0754096023 | 104129.0754096023 | 158576.9100518085 | 130161.344262003 | 190903.3049176043 | 190903.3049176043
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 53383.17899999997 | 65198.19599999997 | 86374.1755541368 | 82895.39210304039 | 72700.33871691259 | 143905.8363283932 | 63364.67999999999 | 63364.67999999999 | 96497.30511191137 | 79205.85000000003 | 116168.58 | 116168.58
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 238602.2753973488 | 267242.6696759611 | 510367.8572213585 | 405529.5323860014 | 435385.0411191544 | 305958.3594089496 | 231053.6131752883 | 231053.6131752883 | 351868.7541353533 | 288817.0164691097 | 423598.290821362 | 423598.290821362 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - GFS & Sysco have approved
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 39647.66856934074 | 12410.28122265033 | 19149.36192190285 | 22169.93517513559 | 21903.8007264667 | 19986.92171227683 | 15091.27156794915 | 15091.27156794915 | 22982.31502185604 | 18864.08945993649 | 27667.33120790682 | 27667.33120790682
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36287.68698260339 | 72868.0133569266 | 92882.03232633439 | 188379.7438745943 | 21072.23602827451 | 38482.89024461427 | 34657.26410373516 | 60891.08016705748 | 67440.2107864783 | 59697.13741868381 | 65666.85116055219 | 72036.53572312575
 |  |  |  |  |  |  |  | Annually |  |  | 2022-07-01 00:00:00 | 0.097 |  |  |  | 354889.9498209371 | 354889.9498209371 | 360678.6787400325 | 356819.5261273023 | 356819.5261273023 | 356794.2905731838 | 346013.8988116577 | 346013.8988116577 | 360542.8093770414 | 352960.373514572 | 369168.8144880391 | 369168.8144880391
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 29898.95331935185 | 37420.72208238387 | 30563.15014615797 | 38043.66 | 54941.77838293729 | 39973.84342455366 | 28800 | 28800 | 43859.17181658688 | 36000.00000000001 | 52800 | 52800
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-09-01 00:00:00 | 0.097 |  |  |  | 419468.7602232235 | 419468.7602232235 | 485700.6697321531 | 441546.0633928669 | 441546.0633928669 | 441257.3300698625 | 317913.1656428638 | 317913.1656428638 | 484146.1164821326 | 397391.4570535803 | 582840.8036785843 | 582840.8036785843 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - approved (Quebec - Sept 1; Ontario -Sept 5)
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.197 |  |  |  | 294903.196258815 | 389951.328844281 | 313433.8216019979 | 216627.0492800661 | 335796.207041231 | 279816.9039718757 | 201599.9999999999 | 201599.9999999999 | 307014.2027161082 | 252000.0000000001 | 369600 | 369600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - received customer approval April 15th
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 60904.60892907262 | 32749.22250562743 | 52124.01967135209 | 45973.7621340877 | 30702.460589993 | 49967.30428069207 | 36000 | 36000 | 54823.96477073361 | 45000 | 65999.99999999999 | 65999.99999999999
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 100951.7849539931 | 82628.14211420623 | 109869.8417171584 | 191443.6708673859 | 80305.7651589173 | 114924.7998455917 | 86774.43754865538 | 86774.43754865538 | 132147.7418657693 | 108468.0469358189 | 159086.4688392011 | 159086.4688392011
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 324085.635659723 | 200823.7399741867 | 390130.171931535 | 359753.719847441 | 218339.456140079 | 309797.2865402907 | 361151.9999999999 | 281952 | 339908.5815785482 | 378000 | 445302 | 445302 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - new price based on RFP bid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 105652.9757418448 | 116633.5551263438 | 405059.5165209912 | 195308.81487709 | 228262.4282839586 | 244880.3565048866 | 225637.1632159349 | 225637.1632159349 | 249905.5330731047 | 256375.3261843967 | 282012.8588028365 | 282012.8588028365
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 502269.6631543334 | 502269.6631543334 | 581575.3994418602 | 528704.908583509 | 528704.908583509 | 528359.1808377532 | 380667.5341801274 | 380667.5341801274 | 579713.9856459243 | 475834.417725159 | 697890.4793302318 | 697890.4793302318 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - GFS & Sysco have approved
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 8914.11797272267 | 28332.46142770089 | 26602.22759795062 | 18133.6559385533 | 23451.1964325932 | 24983.65214034604 | 19570.17027133395 | 19570.17027133395 | 29803.17570869084 | 24462.7128391675 | 35878.64549744564 | 35878.64549744564
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000 | 75000
 |  |  |  |  |  |  |  | Annually |  |  | 2022-07-01 00:00:00 | 0.08 |  |  |  | 726571.0753923524 | 722989.285731718 | 829308.055352238 | 873268.3209508361 | 869159.053080205 | 871358.4985342942 | 601904.5725375336 | 615475.1307265327 | 846832.3638690708 | 879880.9643158737 | 1154791.266589074 | 1182432.859427665 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | - submitted new cost change form (Apr 26)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 149521.5545 | 570633.3345949972 | 578832.47 | 171153.174281808 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3PL distribution change needed (LTL to 3PL) - Sept - Dec program
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-06-01 00:00:00 | 0.097 |  |  |  | 591064.120608185 | 527500.6992698321 | 529859.8985630099 | 518171.225875914 | 401212.9474188479 | 529002.1217342707 | 433816.2698260273 | 394540.7867602975 | 510686.7884805682 | 398218.0210407722 | 475296.932221372 | 440668.113681892 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed (will re-validate VA's and BOM's)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25956.28415300547 | 25956.28415300547 | 30054.64480874316 | 27322.40437158471 | 27322.40437158471 | 27304.53785830169 | 24590.16393442623 | 24590.16393442623 | 27234.95517671813 | 27322.40437158471 | 30054.64480874316 | 30054.64480874316
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 522364.8910372815 | 414289.2943916702 | 674181.412105463 | 516118.7315358795 | 493229.6433687693 | 391980.6700543527 | 376293.1714878409 | 488163.855676605 | 540668.7021538998 | 542404.7301835717 | 596645.3877301759 | 596644.3945804671 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Initial discussion - in Rd 2 of RFP - Awaiting feedback on RFP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68797.83615823291 | 63257.68000000001 | 61759.99999999999 | 77200 | 77200 | 77200 | 77200 | 77200 | 77200 | 77200 | 77200 | 84688.39999999998 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Re-discussing on 5/6- may move to pricing model with them buying select specialized items - Will potentially lower toll
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-04-01 00:00:00 | 0.2421 |  |  |  | 2673389.268292674 | 2667395.121951211 | 2663399.024390235 | 2673389.268292674 | 2683379.512195113 | 1982563.902439024 | 1982563.902439024 | 1982563.902439024 | 1982563.902439024 | 1982563.902439024 | 1982563.902439024 | 1982563.902439024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Approved by Nestle (21.4% Choc Lovers; 27.2% Choc Chip Bar)
 |  |  |  |  |  |  |  | Annually |  | Approved | 2022-07-01 00:00:00 | 0.097 |  |  |  | 175779.1669038551 | 133046.7191553936 | 180839.0386403348 | 212677.325088328 | 232124.39539348 | 163113.4559784194 | 146898.1692067221 | 146898.1692067221 | 162697.7788580727 | 163220.188007469 | 179542.206808216 | 179542.206808216 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 272810.5181550072 | 315885.8631268505 | 287168.966478955 | 287168.966478955 | 286981.1825605162 | 258452.0698310595 | 258452.0698310595 | 286249.8418452765 | 287168.966478955 | 315885.8631268505 | 346526.791850155 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Resubmitted additional pricing (9.7%+10%) -  Response on 5/3 was price increase rejected