Background: It was determined that the offers submitted by Logistics Unlimited LLC$.$ and Transport Depot Inc. received $$acceptable$$ ratings for both of the non$-$price factors and should undergo a price evaluation. Of the two $$acceptable$$ offers, the offer submitted by Transport Depot Inc. has the lowest total evaluated price. You must now document the rationale for the fair and reasonable price determination and recommend an offer for award. Assignment: $1.$ When performing the price evaluation, you identify that Transport Depot Inc.$$s total proposed price is $7\mathrm{.}27\%$ lower than the next low, acceptable offer and $8\mathrm{.}21\%$ lower than the estimated total price of $$8,500,000$ in the independent Government cost estimate $($IGCE$).$ Percentage price difference is calculated by: low price divided by high price and then times $100$ and subtract $100$ Transport Depot & IGCE: $($$$7,802,050/$ $$8,500,000)$ X$100-100=8\mathrm{.}21\%$ You decide that additional price analysis techniques will be required to determine if the price is fair and reasonable. You have the historical unit prices from the last container contract awarded in $2018$ with similar terms and conditions. Using the historical pricing and the table below, perform price indexing to calculate a price estimate for each of the items being purchased under the container solicitation. Use the Price Evaluation Worksheet to document your calculations. Metals and metal products $$ Metal Containers $2018160\mathrm{.}52019167\mathrm{.}52020162\mathrm{.}92021166\mathrm{.}5$