PIVOT Brief_.pptx

PPTX presentation 4 MB Posted

Attached to
Substation (Primary 4), Redstone Arsenal, AL
Solicitation number
W9127825R0020
Issued by

About this file

This is a PowerPoint presentation from February 2022 by David M. Curry, Regional Chief of Contracting for the Southwestern Division, introducing P.I.V.O.T. (Prices Include Variation Over Time), a new pre-award pricing and source selection methodology for federal contracts.

The presentation outlines how P.I.V.O.T. addresses challenges in the construction market caused by COVID-19, including rapid price increases, contractors' reluctance to hold prices, and decreased competition. The methodology involves defining multiple pricing periods after solicitation closing, assigning weights to each period, and using one of three scaling approaches: percentage scaling, index pricing, or vendor parlay. Contractors must submit prices for all defined periods, with the Total Adjusted Price (TAP) used for evaluation purposes in Best Value Trade Off source selections. The approach is not suitable for Lowest Price Technically Acceptable (LPTA) or sealed bid actions. The presentation indicates the Southwestern Division was planning to pilot P.I.V.O.T. on four new contract awards, with mandatory Strategic Command Office peer review required on first implementations regardless of dollar value.

View the file

On GovTribe

Work with this file

  • Download the original file
  • Contacts named in this file
  • Similar government files
  • Ask GovTribe AI about this file

Text version

P.I.V.O.T. source selection and pricing methodology

David M. Curry Regional Chief of Contracting Southwestern Division Date: 14 February 2022 v21

CURRENT SITUATION

COVID-19 impacts continue to expand, negatively impacting markets for everything from simple commodities to highly skilled labor, resulting in higher prices, longer acquisition schedules, increased frequency of requests for additional customer funding, less contractor willingness to hold prices and decreased competition as vendors withdraw offers and/or exit the Federal marketplace entirely.

PROBLEM STATEMENT

Current statutes, regs and policies are devoid of a simple PRE-award alternative to hedge market pricing risk while fostering competition.

OUR PORTFOLIO IS VULNERABLE…

Source: Association of General Contractors of America (AGC)

...ITS DIFFICULT TO KEEP PACE…

8/21 8/20 10/20 2/21 6/21 4/21 4/20 6/20 12/20 10/21 Lumber and plywood 39% 35% Plastic construction products ‘Bid price’ (new nonres building construction) 12% 65% 133% Copper and brass mill shapes Steel mill products Gypsum products 24% Aluminum mill shapes 40% April 2020 – October 2021

Source: The Associated General Contractors of America, Inc., BLS current employment statistics, https://www.bls.gov/ces/

New nonres building construction 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 0 -1.5612802498047513E-3 4.6838407494144757E-3 2.3419203747073489E-3 7.8064012490237564E-4 -7.8064012490237564E-4 7.8064012490237564E-4 7.8064012490237564E-4 3.1225604996097246E-3 4.6838407494144757E-3 8.5870413739265756E-3 2.2638563622170225E-2 2.8103044496487078E-2 2.8883684621389672E-2 4.9180327868852548E-2 5.2302888368462273E-2 5.07416081186573E-2 0.1249024199843872 Lumber and plywood 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 2.1037181996086021E-2 8.8551859099804273E-2 0.1687866927592955 0.30821917808219162 0.53326810176125228 0.44422700587084141 0.29011741682974551 0.39090019569471623 0.56213307240704502 0.63698630136986312 0.75293542074363995 0.89285714285714268 1.2181996086105673 1.2054794520547945 0.83268101761252455 0.51663405088062619 0.34540117416829741 0.38845401174168298 Aluminum mill shapes 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 -3.8223721191680785E-2 -4.7779651489600901E-2 -3.3164699269252418E-2 -1.1804384485666073E-2 2.5295109612141653E-2 2.1922428330522797E-2 2.5295109612141653E-2 5.9021922428330521E-2 8.7689713322091023E-2 0.10399100618324901 0.12591343451377182 0.18605958403597522 0.22765598650927488 0.27037661607644742 0.28780213603147831 0.33501967397414273 0.38560989319842603 0.40472175379426645 Plastic Construction Products 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 -4.3308791684709534E-4 -5.6301429190126085E-3 -1.2992637505414091E-3 6.0632308358597037E-3 2.0355132091814589E-2 3.8977912516240797E-2 4.4608055435253278E-2 4.4608055435253278E-2 5.3702901689042896E-2 6.7128627111303588E-2 9.4413165872672081E-2 0.15071459506279766 0.1792983975747077 0.22000866175833686 0.26548289302728445 0.3040277176266783 0.32178432221741005 0.35426591598094404 Copper and brass mill shapes 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 3.0411943599668863E-3 3.9535526679568736E-2 0.1105888858169754 0.15067735692562897 0.18523638374343379 0.20486591097594697 0.22394249377937517 0.32153718551285598 0.35996682333425489 0.36217860105059441 0.48603815316560689 0.51727951340890233 0.65275089853469714 0.67044512026541347 0.65468620403649436 0.67155100912358323 0.65385678739286723 0.65330384296378219 Steel mill products 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 -2.5613660618996857E-2 -3.1483457844183591E-2 -3.5218783351120567E-2 -5.229455709711852E-2 -5.1760939167556121E-2 -3.6819637139807924E-2 -1.3874066168623234E-2 5.2294557097118367E-2 0.10992529348986123 0.22091782283884742 0.42155816435432214 0.65528281750266792 0.71718249733191031 0.83244397011739579 1.0128068303094984 1.1147278548559232 1.220384204909285 1.3271077908217717 Gypsum 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 2.8142589118198163E-3 1.8761726078798183E-3 -2.5015634771732688E-3 -8.1300813008130784E-3 -8.7554721701063511E-3 -7.8173858661663535E-3 2.6266416510318878E-2 2.7829893683552147E-2 6.1288305190744109E-2 6.7854909318323914E-2 8.3176985616009891E-2 0.12132582864290184 0.14790494058786743 0.18323952470293922 0.21294559099437138 0.21919949968730446 0.21919949968730446 0.24108818011257024

...THERE IS SOME IMPROVEMENT…

Source: The Associated General Contractors of America, Inc., BLS current employment statistics, https://www.bls.gov/ces/

...CONSTRUCTION LABOR ALSO DOWN…

Source: The Associated General Contractors of America, Inc., BLS current employment statistics, https://www.bls.gov/ces/

… AND IT’S NOT GOING AWAY SOON.

Source: Source: Association of General Contractors of America (AGC) and Bureau of Labor Statistics, www.bls.gov/ppi, producer price indexes for goods inputs to nonresidential construction (material costs) and new warehouse construction (bid prices)

RED = periods where cost changes exceed change in bid prices

Column1 38718 38749 38777 38808 38838 38869 38899 38930 38961 38991 39022 39052 39083 39114 39142 39173 39203 39234 39264 39295 39326 39356 39387 39417 39448 39479 39508 39539 39569 39600 39630 39661 39692 39722 39753 39783 39814 39845 39873 39904 39934 39965 39995 40026 40057 40087 40118 40148 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 43282 43313 43344 43374 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 Warehouse 38718 38749 38777 38808 38838 38869 38899 38930 38961 38991 39022 39052 39083 39114 39142 39173 39203 39234 39264 39295 39326 39356 39387 39417 39448 39479 39508 39539 39569 39600 39630 39661 39692 39722 39753 39783 39814 39845 39873 39904 39934 39965 39995 40026 40057 40087 40118 40148 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 43282 43313 43344 43374 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 7.0000000000000019E-3 -3.9999999999999949E-3 -7.0000000000000019E-3 3.9999999999999949E-3 1.8000000000000009E-2 1.9000000000000003E-2 2.5000000000000001E-2 2.4000000000000004E-2 -9.0000000000000045E-3 -4.8999999999999995E-2 -3.3999999999999996E-2 -3.5000000000000003E-2 -4.7E-2 -4.0999999999999995E-2 -3.6000000000000004E-2 -2.5999999999999995E-2 -2.7999999999999997E-2 -3.5000000000000003E-2 -0.03 -4.0999999999999995E-2 -2.5000000000000001E-2 -6.000000000000001E-3 0.01 2.9999999999999983E-3 0.02 0.02 2.7999999999999997E-2 2.6000000000000006E-2 4.200000000000001E-2 6.1000000000000006E-2 7.6000000000000012E-2 8.199999999999999E-2 8.6000000000000021E-2 3.6000000000000004E-2 -1.2999999999999998E-2 -3.5000000000000003E-2 -5.5E-2 -7.0999999999999994E-2 -9.4E-2 -8.8999999999999982E-2 -0.106 -0.113 -8.3000000000000004E-2 -7.2000000000000008E-2 -7.5999999999999998E-2 -1.7000000000000001E-2 1.8999999999999996E-2 4.4999999999999998E-2 7.4999999999999997E-2 8.5000000000000006E-2 0.10400000000000001 0.10399999999999998 0.105 8.5000000000000006E-2 5.1999999999999991E-2 4.3999999999999997E-2 4.2000000000000003E-2 4.7E-2 4.4999999999999998E-2 4.8999999999999995E-2 4.2999999999999997E-2 5.2999999999999999E-2 0.06 5.5E-2 5.7999999999999996E-2 6.6000000000000003E-2 6.4000000000000001E-2 5.2000000000000005E-2 5.5000000000000007E-2 3.0000000000000006E-2 2.4E-2 1.4999999999999999E-2 5.0000000000000001E-3 0 -1.1000000000000001E-2 -1.9E-2 -3.4000000000000002E-2 -4.0999999999999995E-2 -4.0999999999999995E-2 -2.6000000000000002E-2 -0.02 -6.000000000000001E-3 -1.4999999999999999E-2 -1.2000000000000002E-2 -1.4999999999999999E-2 -3.9999999999999992E-3 -1.3999999999999999E-2 -1.6E-2 -1.9000000000000003E-2 -1.3000000000000003E-2 -1.2E-2 -1.6E-2 -2.5000000000000001E-2 -2.1000000000000001E-2 -1.9E-2 -1.6E-2 -1.3000000000000001E-2 -2.2000000000000002E-2 -0.02 -1.2999999999999998E-2 -4.0000000000000018E-3 -3.0000000000000027E-3 -1.9999999999999974E-3 -5.0000000000000027E-3 -4.0000000000000018E-3 -1.3999999999999999E-2 -1.4999999999999999E-2 -3.2000000000000001E-2 -5.5999999999999994E-2 -5.800000000000001E-2 -5.4000000000000006E-2 -5.4000000000000006E-2 -4.2999999999999997E-2 -4.4999999999999998E-2 -4.8000000000000001E-2 -5.5999999999999994E-2 -7.0999999999999994E-2 -6.8999999999999992E-2 -6.5000000000000002E-2 -6.0999999999999999E-2 -4.2000000000000003E-2 -5.2000000000000005E-2 -0.05 -5.6999999999999995E-2 -5.800000000000001E-2 -4.9000000000000002E-2 -3.5000000000000003E-2 -0.03 -1.2E-2 -9.0000000000000011E-3 -9.0000000000000011E-3 6.9999999999999993E-3 0.02 3.1000000000000003E-2 2.2000000000000002E-2 2.7000000000000003E-2 1.4999999999999999E-2 3.9999999999999992E-3 -1.3999999999999999E-2 -3.9999999999999992E-3 3.000000000000007E-3 7.9999999999999984E-3 2.1000000000000005E-2 1.4999999999999999E-2 1.0000000000000005E-2 1.2000000000000002E-2 2.1000000000000001E-2 2.6999999999999996E-2 4.9000000000000002E-2 5.5999999999999994E-2 6.6000000000000003E-2 5.3999999999999992E-2 4.5999999999999999E-2 4.5999999999999999E-2 1.2000000000000002E-2 -5.0000000000000001E-3 -0.02 -1.6E-2 -1.3999999999999999E-2 -2.6000000000000002E-2 -4.6000000000000006E-2 -6.8000000000000005E-2 -6.5000000000000002E-2 -7.0999999999999994E-2 -7.9000000000000001E-2 -7.6999999999999999E-2 -5.6999999999999995E-2 -3.7000000000000005E-2 -2.5000000000000005E-2 -4.2999999999999997E-2 -6.8000000000000005E-2 -0.10099999999999999 -0.09 -4.9000000000000002E-2 -3.1000000000000003E-2 -5.0000000000000001E-3 1.3000000000000001E-2 1.3000000000000001E-2 0.01 2.7000000000000003E-2 5.1000000000000004E-2 8.6999999999999994E-2 0.13700000000000001 0.192 0.217 0.20800000000000002 0.16600000000000001 0.13700000000000001 0.11799999999999999 -9.9999999999997877E-4 pos 38718 38749 38777 38808 38838 38869 38899 38930 38961 38991 39022 39052 39083 39114 39142 39173 39203 39234 39264 39295 39326 39356 39387 39417 39448 39479 39508 39539 39569 39600 39630 39661 39692 39722 39753 39783 39814 39845 39873 39904 39934 39965 39995 40026 40057 40087 40118 40148 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 43282 43313 43344 43374 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 7.0000000000000019E-3 0 0 3.9999999999999949E-3 1.8000000000000009E-2 1.9000000000000003E-2 2.5000000000000001E-2 2.4000000000000004E-2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0.01 2.9999999999999983E-3 0.02 0.02 2.7999999999999997E-2 2.6000000000000006E-2 4.200000000000001E-2 6.1000000000000006E-2 7.6000000000000012E-2 8.199999999999999E-2 8.6000000000000021E-2 3.6000000000000004E-2 0 0 0 0 0 0 0 0 0 0 0 0 1.8999999999999996E-2 4.4999999999999998E-2 7.4999999999999997E-2 8.5000000000000006E-2 0.10400000000000001 0.10399999999999998 0.105 8.5000000000000006E-2 5.1999999999999991E-2 4.3999999999999997E-2 4.2000000000000003E-2 4.7E-2 4.4999999999999998E-2 4.8999999999999995E-2 4.2999999999999997E-2 5.2999999999999999E-2 0.06 5.5E-2 5.7999999999999996E-2 6.6000000000000003E-2 6.4000000000000001E-2 5.2000000000000005E-2 5.5000000000000007E-2 3.0000000000000006E-2 2.4E-2 1.4999999999999999E-2 5.0000000000000001E-3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 6.9999999999999993E-3 0.02 3.1000000000000003E-2 2.2000000000000002E-2 2.7000000000000003E-2 1.4999999999999999E-2 3.9999999999999992E-3 0 0 3.000000000000007E-3 7.9999999999999984E-3 2.1000000000000005E-2 1.4999999999999999E-2 1.0000000000000005E-2 1.2000000000000002E-2 2.1000000000000001E-2 2.6999999999999996E-2 4.9000000000000002E-2 5.5999999999999994E-2 6.6000000000000003E-2 5.3999999999999992E-2 4.5999999999999999E-2 4.5999999999999999E-2 1.2000000000000002E-2 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 1.3000000000000001E-2 1.3000000000000001E-2 0.01 2.7000000000000003E-2 5.1000000000000004E-2 8.6999999999999994E-2 0.13700000000000001 0.192 0.217 0.20800000000000002 0.16600000000000001 0.13700000000000001 0.11799999999999999 0 #REF! 38718 38749 38777 38808 38838 38869 38899 38930 38961 38991 39022 39052 39083 39114 39142 39173 39203 39234 39264 39295 39326 39356 39387 39417 39448 39479 39508 39539 39569 39600 39630 39661 39692 39722 39753 39783 39814 39845 39873 39904 39934 39965 39995 40026 40057 40087 40118 40148 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 42005 42036 42064 42095 42125 42156 42186 42217 42248 42278 42309 42339 42370 42401 42430 42461 42491 42522 42552 42583 42614 42644 42675 42705 42736 42767 42795 42826 42856 42887 42917 42948 42979 43009 43040 43070 43101 43132 43160 43191 43221 43252 43282 43313 43344 43374 43405 43435 43466 43497 43525 43556 43586 43617 43647 43678 43709 43739 43770 43800 43831 43862 43891 43922 43952 43983 44013 44044 44075 44105 44136 44166 44197 44228 44256 44287 44317 44348 44378 44409 44440 44470 1

CHALLENGES & IMPACTS

Rapidly increasing market prices = high risk for Defense Industrial Base (DIB).

DIB contractors (KTRs) reluctant to hold prices; e.g., was ~6mo, now ~60days.

Greater incidence of KTRs pulling out of acquisitions.

Widening gap between proposed prices and GOV cost estimates (IGEs).

Increasing number of Above Threshold Requests (ATRs).

Schedule impacts to update IGEs and/or seek additional funds.

KTRs shifting focus to state/municipal/residential/commercial in lieu of GOV.

Regulatory flexibilities focus on post-award: e.g., EPA, Variation in Quantity Rapid market changes make price and cost realism analyses difficult.

Determining prices fair and reasonable is a growing challenge, at best.

FEWER COMPETITORS…

WHO CANNOT HOLD PRICES AS LONG!

# DAYS

Proposals Current Challenge P.I.V.O.T.

Solicitation -30

$ 4

$ 3

$ 1 $ 2

PROPOSED SOLUTION

PIVOT = (Prices Include Variation Over Time) Goals: keep KTRs at the table, keep prices valid longer.

Fosters increased competition while addressing market pricing risk.

GOV/KTR partnership to share the unique risk profile of an acquisition.

New optional pre-award pricing and source selection methodology.

Basic idea: scale proposed prices OVER TIME as proposals age and market moves.

Current Approach New Approach

WHAT PIVOT IS NOT…

A template solution – instead, it will vary every time.

A silver bullet – it will not hedge all risks.

A hammer – everything isn’t a nail; this solution is a scalpel.

WHAT PIVOT IS…

Responsive – directly addresses competition & pricing risk.

Timely – available NOW, for immediate implementation on new awards.

Aligned – with existing statutory and regulatory constraints/flexibilities.

Dynamic – version 18 and counting, an evolving solution.

THE PIVOT PROCESS

BUILDING STRONG®

STEP 1: Define the Periods Thorough acquisition planning is critical to PIVOT success.

GOV defines the NUMBER of “Periods” in the solicitation.

All time periods key off the solicitation closing date; i.e when proposals are due.

When using PIVOT, GOV must include at least (3) periods to spread the risk.

For proposals to be deemed acceptable, KTRs must submit prices for ALL periods.

GOV defines date RANGE of each period; tied to unique drivers of each acquisition.

Periods may be of equal or unequal lengths, GOV prerogative.

Ranges remain consistent across all CLINs.

Proposal ACME, Inc.

123 Elm St.

City, US 54321

CLIN 0001 …

CLIN 0002 …

CLIN 0003 …

TOTALS ……

$ 1,000 $ 5,000 $ 4,000

$10,000 $ 2,000 $ 8,000 $ 5,000

$15,000 $ 5,000 $ 17,000 $ 8,000

$30,000 Period 1 0-90 days Period 2 91-180 days Period 3 181-365 days

The number and length of periods are TAILORED to each unique acquisition.

Step 2: Define the Weights GOV defines weights for each period based on market price volatility over time.

Each weight represents GOV/KTR confidence in prices during a given period.

GOV cost estimates are tailored to align with same periods as the solicitation.

KTR prices remain valid for all periods, at prices proposed by period.

In competed actions, KTRs are NOT asked to extend prices at Period thresholds.

However, with sole source actions, GOV may negotiate flexibility, KTR prerogative.

PIVOT solicitations must clearly define the periods, weights and scaling alternative.

GOV weights are also TAILORED to each unique acquisition.

Example: prices in the next 90d are MUCH more predictable than 360d away, so Period 1 weights will be the highest.

High fidelity = Higher weight.

Step 3: Chose Scaling Approach Alternative #1 – Percentage Scaling.

GOV selects an appropriate percentage used to scale KTR prices.

KTRs use the GOV percentage to calculate prices for each period.

Two methods, one calculates from base price, one from previous period price.

Alternative #2 – Index Pricing.

GOV uses public domain economic index; e.g., Producer Price Index (PPI).

KTRs use the index rate to calculate prices for each period.

Best approach uses subsector specific index values to better align with req’t.

Example: “Non-residential construction PPI for OCT 21”.

Alternative #3 – Vendor Parlay.

Full KTR autonomy to choose prices by Period based on their modeling.

Price per period is based entirely on KTR’s own competition/risk model.

GOV price exposure is hedged by GOV selected period weights.

ALT1 – Percentage Scaling Example: Fixed Percentage

Mechanism to scale prices is simply a fixed percentage chosen by GOV.

Easier to align with actual regional prices compared to indices, which are typically all US.

2.2 2.42 Note: over time curve may prove more parabolic; presented in a linear fashion to underscore the fixed % value; however, slope may be linear depending on PDT approach.

ALT2 – Indexed Pricing Example: PPI * Previous Period Price

Like ALT1 except mechanism to scale prices is a well-known index available in public domain.

Very high fidelity with the contract requirement, but some indices are more current than others.

Note: over time curve may prove more parabolic; presented in a linear fashion to underscore the fixed index value, however, slope may be linear depending on PDT approach.

2.4 2.88

ALT1 and ALT 2 – RISKS Both % and index alternatives include forced scaling which may/may not cover KTR risks.

These forced lines introduce risk that KTRs may include near-term price premiums.

This is our current state, where GOV asks for 1 Firm Fixed Price…and then ask KTR to hold.

To protect their exposure, they are forced to include risk premiums.

If the curve below approximates a KTR’s real risk profile, i.e. how they see risk of a particular acquisition, using their financial models…

….and GOV “forces” a scaling alternative that doesn’t “cover” all risk in all periods, KTRs have no choice but to follow the provided slope and INCREASE their base offer to cover later period risks.

ALT3 – Vendor Parlay Example: KTR pricing by Period

KTR has TOTAL autonomy to customize proposed period prices and scaling.

Pricing for all periods are REQUIRED for proposal to be deemed acceptable.

KTRs enjoy autonomy…yet price is still subject to cost realism and balanced pricing analyses.

This approach most closely aligns with current Firm Fixed Price (FFP) single price model.

2.3 3.0

ALT3 – RISKS

Vendors may use sophisticated tools beyond USACE norms; Monte Carlo, game theory, etc.

However, Total Adjusted Price (TAP) helps mitigate this risk and ensure a level playing field.

Critical that KOs perform realism analysis at all CLINS and Periods to understand anomalies.

Apparent anomalies, such as identical prices across periods, MAY be a realism issue. May also point to savvy KTRs with valid price efficiencies.

Example 1: KTR may hold a price because they’re using existing supplies/inventory previously purchased at prices lower than current market.

Example 2: KTRs may have long-term pricing deals with material suppliers.

Example 3: KTRs may hold put options, locking price and allowing them to procure materials at much lower cost than their competitors.

RISK? Requires closer KO analysis by CLIN/Period.

Step 4: Tailor the Solicitation Package As part of a PIVOT solicitation, GOV provides KTRs with a fillable MS Excel Workbook.

KTRs fill in their prices by CLIN and by Period.

Workbook Periods, Ranges, and Weights align with published solicitation.

The Excel workbook automatically calculates:

Total Award Price by Period.

Total Adjusted CLIN Price by Period.

Total Adjusted Price (TAP); used solely for the evaluation.

Step 5: Evaluate Price With PIVOT, price evaluation focuses ONLY on the Total Adjusted Price (TAP).

TAP is a SUM of the weighted average calculations, by CLIN, by Period; see below.

The weighted average approach smooths period fluctuations, while mitigating market risks.

KTR award prices, by Period, are IRRELEVANT to the evaluation – TAP is the sole focus.

1) Calculate Adjusted Price by CLIN

2) Total Adjusted CLIN Prices = TAP

Step 6: Source Selection Best Value Trade Off (BVTO) is the required source selection methodology for PIVOT.

PIVOT is NOT for Lowest Price Technically Acceptable (LPTA) or sealed bid actions.

LPTA and IFB are not appropriate as award may go to offeror with a HIGHER TAP.

NOTE: TAP is NOT the award amount; TAP is ONLY used for price evaluation.

Contract award value is the total of the unweighted CLIN prices in period of award.

Example below: TAP = $13.2M; if we award in Period 2, award value = $13.3M.

Used in the award (if awarded in the 91-180d window after proposal receipt).

Used in the evaluation. Note, since this is not LPTA but instead is BVTO, the final selected source MAY have a higher TAP than other offerors.

Step 7: Contract Award As a BVTO source selection, the winning offeror’s TAP may be HIGHER than other offerors.

If awardee’s TAP is higher, the Source Selection Authority (SSA) TRADES price for other factor(s).

Comparatively, the awardee’s price in a period may be higher in some periods, lower in others.

Final award price is the awardee’s total prosed price in whatever period GOV awards.

In the example below, Vendor 1 has a higher TAP, but was still chosen for award by the SSA.

Vendor #1

Vendor #2

Step 7: Contract Award As a BVTO source selection, the winning offeror’s TAP may be HIGHER than other offerors.

If awardee’s TAP is higher, the Source Selection Authority (SSA) TRADES price for other factor(s).

Comparatively, the awardee’s price in a period may be higher in some periods, lower in others.

Final award price is the awardee’s total prosed price in whatever period GOV awards.

In the example below, Vendor 1 has a higher TAP, but was still chosen for award by the SSA.

Lowest award price can vary by period, thus BVTO.

SAMPLE SOLICITATION vs CONTRACT

NET AMT =

Period time frames are identical for all CLINS. KTR enters price for Period 1, then calculates/enters their prices for Period 2, 3 and 4. Errors are considered administrative and KTRs may be given the opportunity to correct.

In preparing the final contract award documents, GOV lines through all periods other than the award period, to highlight/codify for the contract and file.

NEXT STEPS

SWD Commander directive to advance PIVOT to assess/validate the methodology.

SWD identifying 4 new contract awards as PILOT for new PIVOT approach.

SCO peer review required on first PIVOT solicitation, regardless of $ value.

Heavy peer review focus on Section L & M to ensure clear communication to market.

PIVOT must be addressed in the Acquisition Plans/Strategies, as applicable.

RCC – PIVOT training for the workforce and enterprise.

RCC – Develop/deploy PIVOT videos in KnowledgeNow.

RCC – Briefing AGC and SAME organizations on PIVOT.

RCC – Soliciting contractor suggestions/feedback through Industry Days.

RCC – Periodic SCO IPRs on PIVOT status, pilots, lessons learned.

RCC – Tracking and reporting data on PIVOT use, lessons learned and results.

FEEDBACK PLEASE

BUILDING STRONG®

david.m.curry@usace.army.mil image4.png image5.png image6.png image7.png image8.png image10.png image11.png

Microsoft_Excel_Worksheet.xlsx Sheet1

New nonres building construction Lumber and plywood Aluminum mill shapes Plastic Construction Products Copper and brass mill shapes Steel mill products Gypsum 1 2 3

Apr-20 0.0% 0.0% 0.0% 0.0% 0.0% 0.0% 0.0%

May-20 0.0% 2.1% -3.8% -0.0% 0.3% -2.6% 0.3%

Jun-20 -0.2% 8.9% -4.8% -0.6% 4.0% -3.1% 0.2%

Jul-20 0.5% 16.9% -3.3% -0.1% 11.1% -3.5% -0.3%

Aug-20 0.2% 30.8% -1.2% 0.6% 15.1% -5.2% -0.8% WPU0721

Sep-20 0.1% 53.3% 2.5% 2.0% 18.5% -5.2% -0.9% ^Softwood and lumber

Oct-20 -0.1% 44.4% 2.2% 3.9% 20.5% -3.7% -0.8%

Nov-20 0.1% 29.0% 2.5% 4.5% 22.4% -1.4% 2.6% WPU057303

Dec-20 0.1% 39.1% 5.9% 4.5% 32.2% 5.2% 2.8% Diesel^

Jan-21 0.3% 56.2% 8.8% 5.4% 36.0% 11.0% 6.1%

Feb-21 0.5% 63.7% 10.4% 6.7% 36.2% 22.1% 6.8% WPU801 WPUSI004011 WPU102501 WPU0721 WPU102502 WPU1017 WPU137

Mar-21 0.9% 75.3% 12.6% 9.4% 48.6% 42.2% 8.3% 2/1/20 127.4 211.7 187.9 228.9 378.4 187.4 323.7

Apr-21 2.3% 89.3% 18.6% 15.1% 51.7% 65.5% 12.1% 3/1/20 127.3 218.8 185.7 231.3 372.8 188.7 324.9

May-21 2.8% 121.8% 22.8% 17.9% 65.3% 71.7% 14.8% 4/1/20 128.1 204.4 177.9 230.9 361.7 187.4 319.8

Jun-21 2.9% 120.5% 27.0% 22.0% 67.0% 83.2% 18.3% 5/1/20 128.1 208.7 171.1 230.8 362.8 182.6 320.7

Jul-21 4.9% 83.3% 28.8% 26.5% 65.5% 101.3% 21.3% 6/1/20 127.9 222.5 169.4 229.6 376.0 181.5 320.4

Aug-21 5.2% 51.7% 33.5% 30.4% 67.2% 111.5% 21.9% 7/1/20 128.7 238.9 172.0 230.6 401.7 180.8 319.0

Sep-21 5.1% 34.54% 38.6% 32.2% 65.4% 122.0% 21.9% 8/1/20 128.4 267.4 175.8 232.3 416.2 177.6 317.2

Oct-21 12.5% 38.8% 40.5% 35.4% 65.3% 132.7% 24.1% 9/1/20 128.2 313.4 182.4 235.6 428.7 177.7 317.0

10/1/20 128.0 295.2 181.8 239.9 435.8 180.5 317.3

11/1/20 128.2 263.7 182.4 241.2 442.7 184.8 328.2

12/1/20 128.2 284.3 188.4 241.2 478.0 197.2 328.7

1/1/21 128.5 319.3 193.5 243.3 491.9 208.0 339.4

2/1/21 128.7 334.6 196.4 246.4 492.7 228.8 341.5

3/1/21 129.2 358.3 200.3 252.7 537.5 266.4 346.4

4/1/21 131.0 386.9 211.0 265.7 548.8 310.2 358.6

5/1/21 131.7 453.4 218.4 272.3 597.8 321.8 367.1

6/1/21 131.8

: * Preliminary. All indexes are subject to revision four months after original publication.

450.8

: * Preliminary. All indexes are subject to revision four months after original publication.

226.0

: * Preliminary. All indexes are subject to revision four months after original publication.

281.7

: * Preliminary. All indexes are subject to revision four months after original publication.

604.2

: * Preliminary. All indexes are subject to revision four months after original publication.

343.4

: * Preliminary. All indexes are subject to revision four months after original publication.

378.4

: * Preliminary. All indexes are subject to revision four months after original publication.

7/1/21 134.4

374.6

: * Preliminary. All indexes are subject to revision four months after original publication.

229.1

: * Preliminary. All indexes are subject to revision four months after original publication.

292.2

: * Preliminary. All indexes are subject to revision four months after original publication.

598.5

: * Preliminary. All indexes are subject to revision four months after original publication.

377.2

: * Preliminary. All indexes are subject to revision four months after original publication.

387.9

8/1/21 134.8

310.0

: * Preliminary. All indexes are subject to revision four months after original publication.

237.5

: * Preliminary. All indexes are subject to revision four months after original publication.

301.1

: * Preliminary. All indexes are subject to revision four months after original publication.

604.6

: * Preliminary. All indexes are subject to revision four months after original publication.

396.3

: * Preliminary. All indexes are subject to revision four months after original publication.

389.9

9/1/21 134.6

275.0

246.5

305.2

598.2

416.1

: * Preliminary. All indexes are subject to revision four months after original publication.

389.9

10/1/21 144.1 283.8 249.9 312.7 598 436.1 396.9 image12.png image13.png image14.png image15.png

Microsoft_Excel_Worksheet1.xlsx Sheet1

Column1 Warehouse pos WPUIP2300001 1 2 3

Jan-06 0.0% 0.7% 0.7% 0.7% WPUIP2300001 - WPU801101

Feb-06 0.0% -0.4% 0.0% -0.4%

Mar-06 0.0% -0.7% 0.0% -0.7%

Apr-06 0.0% 0.4% 0.4% 0.4%

May-06 0.0% 1.8% 1.8% 1.8%

Jun-06 0.0% 1.9% 1.9% 1.9%

Jul-06 0.0% 2.5% 2.5% 2.5% WPU801101 WPUIP231230

Aug-06 0.0% 2.4% 2.4% 2.4%

Sep-06 0.0% -0.9% 0.0% -0.9%

Oct-06 0.0% -4.9% 0.0% -4.9%

Nov-06 0.0% -3.4% 0.0% -3.4% FEBRUARY Warehouse Inputs

Dec-06 0.0% -3.5% 0.0% -3.5%

Jan-07 0.0% -4.7% 0.0% -4.7%

Feb-07 0.0% -4.1% 0.0% -4.1% Jan-06 109.7 98.7

Mar-07 0.0% -3.6% 0.0% -3.6% Feb-06 109.7 98.9

Apr-07 0.0% -2.6% 0.0% -2.6% Mar-06 109.7 99.5

May-07 0.0% -2.8% 0.0% -2.8% Apr-06 109.7 99.6

Jun-07 0.0% -3.5% 0.0% -3.5% May-06 109.8 100.7

Jul-07 0.0% -3.0% 0.0% -3.0% Jun-06 109.8 100.7

Aug-07 0.0% -4.1% 0.0% -4.1% Jul-06 110.4 100.7

Sep-07 0.0% -2.5% 0.0% -2.5% Aug-06 110.5 100.1

Oct-07 0.0% -0.6% 0.0% -0.6% Sep-06 110.5 98.8

Nov-07 0.0% 1.0% 1.0% 1.0% Oct-06 111.5 98.6

Dec-07 0.0% 0.3% 0.3% 0.3% Nov-06 111.4 98.3

Jan-08 0.0% 2.0% 2.0% 2.0% Dec-06 111.5 97.2

Feb-08 0.0% 2.0% 2.0% 2.0% Jan-07 111.0 96.9

Mar-08 0.0% 2.8% 2.8% 2.8% Feb-07 111.0 96.5

Apr-08 0.0% 2.6% 2.6% 2.6% Mar-07 110.9 97.0

May-08 0.0% 4.2% 4.2% 4.2% Apr-07 112.0 97.6

Jun-08 0.0% 6.1% 6.1% 6.1% May-07 111.9 98.3

Jul-08 0.0% 7.6% 7.6% 7.6% Jun-07 112.0 99.2

Aug-08 0.0% 8.2% 8.2% 8.2% Jul-07 111.2 99.3

Sep-08 0.0% 8.6% 8.6% 8.6% Aug-07 111.2 98.9

Oct-08 0.0% 3.6% 3.6% 3.6% Sep-07 111.2 98.9

Nov-08 0.0% -1.3% 0.0% -1.3% Oct-07 112.2 98.9

Dec-08 0.0% -3.5% 0.0% -3.5% Nov-07 112.1 98.5

Jan-09 0.0% -5.5% 0.0% -5.5% Dec-07 112.0 99.1

Feb-09 0.0% -7.1% 0.0% -7.1% Jan-08 112.4 99.9

Mar-09 0.0% -9.4% 0.0% -9.4% Feb-08 112.4 100.3

Apr-09 0.0% -8.9% 0.0% -8.9% Mar-08 112.5 100.5

May-09 0.0% -10.6% 0.0% -10.6% Apr-08 113.1 101.3

Jun-09 0.0% -11.3% 0.0% -11.3% May-08 113.2 101.2

Jul-09 0.0% -8.3% 0.0% -8.3% Jun-08 113.3 101.3

Aug-09 0.0% -7.2% 0.0% -7.2% Jul-08 114.9 101.2

Sep-09 0.0% -7.6% 0.0% -7.6% Aug-08 114.9 102.1

Oct-09 0.0% -1.7% 0.0% -1.7% Sep-08 114.9 102.7

Nov-09 0.0% 1.9% 1.9% 1.9% Oct-08 115.5 102.9

Dec-09 0.0% 4.5% 4.5% 4.5% Nov-08 115.5 103.4

Jan-10 0.0% 7.5% 7.5% 7.5% Dec-08 115.5 103.4

Feb-10 0.0% 8.5% 8.5% 8.5% Jan-09 116.5 104.4

Mar-10 0.0% 10.4% 10.4% 10.4% Feb-09 116.5 104.9

Apr-10 0.0% 10.4% 10.4% 10.4% Mar-09 116.6 105.7

May-10 0.0% 10.5% 10.5% 10.5% Apr-09 118.0 106.9

Jun-10 0.0% 8.5% 8.5% 8.5% May-09 118.1 108.5

Jul-10 0.0% 5.2% 5.2% 5.2% Jun-09 118.3 109.1

Aug-10 0.0% 4.4% 4.4% 4.4% Jul-09 118.8 109.3

Sep-10 0.0% 4.2% 4.2% 4.2% Aug-09 118.9 108.9

Oct-10 0.0% 4.7% 4.7% 4.7% Sep-09 119.0 109.0

Nov-10 0.0% 4.5% 4.5% 4.5% Oct-09 121.5 109.9

Dec-10 0.0% 4.9% 4.9% 4.9% Nov-09 121.7 108.8

Jan-11 0.0% 4.3% 4.3% 4.3% Dec-09 121.7 107.8

Feb-11 0.0% 5.3% 5.3% 5.3% Jan-10 122.7 107.5

Mar-11 0.0% 6.0% 6.0% 6.0% Feb-10 122.6 108.0

Apr-11 0.0% 5.5% 5.5% 5.5% Mar-10 122.8 109.1

May-11 0.0% 5.8% 5.8% 5.8% Apr-10 124.5 110.5

Jun-11 0.0% 6.6% 6.6% 6.6% May-10 124.7 110.4

Jul-11 0.0% 6.4% 6.4% 6.4% Jun-10 124.8 109.6

Aug-11 0.0% 5.2% 5.2% 5.2% Jul-10 125.7 110.1

Sep-11 0.0% 5.5% 5.5% 5.5% Aug-10 125.7 109.7

Oct-11 0.0% 3.0% 3.0% 3.0% Sep-10 125.9 109.7

Nov-11 0.0% 2.4% 2.4% 2.4% Oct-10 126.3 109.5

Dec-11 0.0% 1.5% 1.5% 1.5% Nov-10 126.4 109.4

Jan-12 0.0% 0.5% 0.5% 0.5% Dec-10 126.6 109.7

Feb-12 0.0% 0.0% 0.0% 0.0% Jan-11 127.2 110.1

Mar-12 0.0% -1.1% 0.0% -1.1% Feb-11 127.4 109.4

Apr-12 0.0% -1.9% 0.0% -1.9% Mar-11 127.3 108.5

May-12 0.0% -3.4% 0.0% -3.4% Apr-11 128.1 105.3

Jun-12 0.0% -4.1% 0.0% -4.1% May-11 128.1 105.5

Jul-12 0.0% -4.1% 0.0% -4.1% Jun-11 127.9 107.6

Aug-12 0.0% -2.6% 0.0% -2.6% Jul-11 128.7 109.0

Sep-12 0.0% -2.0% 0.0% -2.0% Aug-11 128.4 110.5

Oct-12 0.0% -0.6% 0.0% -0.6% Sep-11 128.2 111.7

Nov-12 0.0% -1.5% 0.0% -1.5% Oct-11 128.0 111.9

Dec-12 0.0% -1.2% 0.0% -1.2% Nov-11 128.1

: * Preliminary. All indexes are subject to revision four months after original publication.

111.9

Jan-13 0.0% -1.5% 0.0% -1.5% Dec-11 128.2

113.8

Feb-13 0.0% -0.4% 0.0% -0.4% Jan-12 128.4

116.6

Mar-13 0.0% -1.4% 0.0% -1.4% Feb-12 128.8

118.8

Apr-13 0.0% -1.6% 0.0% -1.6% Mar-12

May-13 0.0% -1.9% 0.0% -1.9% Apr-12

Jun-13 0.0% -1.3% 0.0% -1.3% May-12

Jul-13 0.0% -1.2% 0.0% -1.2% Jun-12

Aug-13 0.0% -1.6% 0.0% -1.6% Jul-12

Sep-13 0.0% -2.5% 0.0% -2.5% Aug-12

Oct-13 0.0% -2.1% 0.0% -2.1% Sep-12

Nov-13 0.0% -1.9% 0.0% -1.9% Oct-12

Dec-13 0.0% -1.6% 0.0% -1.6% Nov-12

Jan-14 0.0% -1.3% 0.0% -1.3% Dec-12

Feb-14 0.0% -2.2% 0.0% -2.2% Jan-13

Mar-14 0.0% -2.0% 0.0% -2.0% Feb-13

Apr-14 0.0% -1.3% 0.0% -1.3% Mar-13

May-14 0.0% -0.4% 0.0% -0.4% Apr-13

Jun-14 0.0% -0.3% 0.0% -0.3% May-13

Jul-14 0.0% -0.2% 0.0% -0.2% Jun-13

Aug-14 0.0% -0.5% 0.0% -0.5% Jul-13

Sep-14 0.0% -0.4% 0.0% -0.4% Aug-13

Oct-14 0.0% -1.4% 0.0% -1.4% Sep-13

Nov-14 0.0% -1.5% 0.0% -1.5% Oct-13

Dec-14 0.0% -3.2% 0.0% -3.2% Nov-13

Jan-15 0.0% -5.6% 0.0% -5.6% Dec-13

Feb-15 0.0% -5.8% 0.0% -5.8% Jan-14

Mar-15 0.0% -5.4% 0.0% -5.4% Feb-14

Apr-15 0.0% -5.4% 0.0% -5.4% Mar-14

May-15 0.0% -4.3% 0.0% -4.3% Apr-14

Jun-15 0.0% -4.5% 0.0% -4.5% May-14

Jul-15 0.0% -4.8% 0.0% -4.8% Jun-14

Aug-15 0.0% -5.6% 0.0% -5.6% Jul-14

Sep-15 0.0% -7.1% 0.0% -7.1% Aug-14

Oct-15 0.0% -6.9% 0.0% -6.9% Sep-14

Nov-15 0.0% -6.5% 0.0% -6.5% Oct-14

Dec-15 0.0% -6.1% 0.0% -6.1% Nov-14

Jan-16 0.0% -4.2% 0.0% -4.2% Dec-14

Feb-16 0.0% -5.2% 0.0% -5.2% Jan-15

Mar-16 0.0% -5.0% 0.0% -5.0% Feb-15

Apr-16 0.0% -5.7% 0.0% -5.7% Mar-15

May-16 0.0% -5.8% 0.0% -5.8% Apr-15

Jun-16 0.0% -4.9% 0.0% -4.9% May-15

Jul-16 0.0% -3.5% 0.0% -3.5% Jun-15

Aug-16 0.0% -3.0% 0.0% -3.0% Jul-15

Sep-16 0.0% -1.2% 0.0% -1.2% Aug-15

Oct-16 0.0% -0.9% 0.0% -0.9% Sep-15

Nov-16 0.0% -0.9% 0.0% -0.9% Oct-15

Dec-16 0.0% 0.7% 0.7% 0.7% Nov-15

Jan-17 0.0% 2.0% 2.0% 2.0% Dec-15

Feb-17 0.0% 3.1% 3.1% 3.1% Jan-16

Mar-17 0.0% 2.2% 2.2% 2.2% Feb-16

Apr-17 0.0% 2.7% 2.7% 2.7% Mar-16

May-17 0.0% 1.5% 1.5% 1.5% Apr-16

Jun-17 0.0% 0.4% 0.4% 0.4% May-16

Jul-17 0.0% -1.4% 0.0% -1.4% Jun-16

Aug-17 0.0% -0.4% 0.0% -0.4% Jul-16

Sep-17 0.0% 0.3% 0.3% 0.3% Aug-16

Oct-17 0.0% 0.8% 0.8% 0.8% Sep-16

Nov-17 0.0% 2.1% 2.1% 2.1% Oct-16

Dec-17 0.0% 1.5% 1.5% 1.5% Nov-16

Jan-18 0.0% 1.0% 1.0% 1.0% Dec-16

Feb-18 0.0% 1.2% 1.2% 1.2% Jan-17

Mar-18 0.0% 2.1% 2.1% 2.1% Feb-17

Apr-18 0.0% 2.7% 2.7% 2.7% Mar-17

May-18 0.0% 4.9% 4.9% 4.9% Apr-17

Jun-18 0.0% 5.6% 5.6% 5.6% May-17

Jul-18 0.0% 6.6% 6.6% 6.6% Jun-17

Aug-18 0.0% 5.4% 5.4% 5.4% Jul-17

Sep-18 0.0% 4.6% 4.6% 4.6% Aug-17

Oct-18 0.0% 4.6% 4.6% 4.6% Sep-17

Nov-18 0.0% 1.2% 1.2% 1.2% Oct-17

Dec-18 0.0% -0.5% 0.0% -0.5% Nov-17

Jan-19 0.0% -2.0% 0.0% -2.0% Dec-17

Feb-19 0.0% -1.6% 0.0% -1.6% Jan-18

Mar-19 0.0% -1.4% 0.0% -1.4% Feb-18

Apr-19 0.0% -2.6% 0.0% -2.6% Mar-18

May-19 0.0% -4.6% 0.0% -4.6% Apr-18

Jun-19 0.0% -6.8% 0.0% -6.8% May-18

Jul-19 0.0% -6.5% 0.0% -6.5% Jun-18

Aug-19 0.0% -7.1% 0.0% -7.1% Jul-18

Sep-19 0.0% -7.9% 0.0% -7.9% Aug-18

Oct-19 0.0% -7.7% 0.0% -7.7% Sep-18

Nov-19 0.0% -5.7% 0.0% -5.7% Oct-18

Dec-19 0.0% -3.7% 0.0% -3.7% Nov-18

Jan-20 0.0% -2.5% 0.0% -2.5% Dec-18

Feb-20 0.0% -4.3% 0.0% -4.3% Jan-19

Mar-20 0.0% -6.8% 0.0% -6.8% Feb-19

Apr-20 0.0% -10.1% 0.0% -10.1% Mar-19

May-20 0.0% -9.0% 0.0% -9.0% Apr-19

Jun-20 0.0% -4.9% 0.0% -4.9% May-19

Jul-20 0.0% -3.1% 0.0% -3.1% Jun-19

Aug-20 0.0% -0.5% 0.0% -0.5% Jul-19

Sep-20 0.0% 1.3% 1.3% 1.3% Aug-19

Oct-20 0.0% 1.3% 1.3% 1.3% Sep-19

Nov-20 0.0% 1.0% 1.0% 1.0% Oct-19

Dec-20 0.0% 2.7% 2.7% 2.7% Nov-19

Jan-21 0.0% 5.1% 5.1% 5.1% Dec-19

Feb-21 0.0% 8.7% 8.7% 8.7% Jan-20

Mar-21 0.0% 13.7% 13.7% 13.7% Feb-20

Apr-21 0.0% 19.2% 19.2% 19.2% Mar-20

May-21 0.0% 21.7% 21.7% 21.7% Apr-20

Jun-21 0.0% 20.8% 20.8% 20.9% May-20

Jul-21 0.0% 16.6% 16.6% 16.6% Jun-20

Aug-21 0.0% 13.7% 13.7% 13.7% Jul-20

Sep-21 0.0% 11.8% 11.8% 11.8% Aug-20

Oct-21 0.0% -0.1% 0.0% -0.1% Sep-20

Oct-20

Nov-20

Dec-20

Jan-21

Feb-21

: * preliminary image16.png image17.png image18.png image19.png image20.png image21.png image22.png image23.png image24.png image25.png image26.png image27.png image28.png image29.png image30.png image31.png image32.png image33.png image34.png image35.png image36.png image37.png image38.png image39.png image40.png image41.png image42.png image43.png image44.png image45.png image46.jpeg image47.png image48.png image49.png image50.png image51.png image1.png image2.png image3.png

File details come from the government source that posted it. Updated .