Please show all formulas and work assosiated

U$.$S$.$ Airfilter has hired you as a supply chain consultant. The company makes air filters for residential heating and air$-$conditioning systems. These filters are made in a single plant located in Louisville, Kentucky, in the United States. They are distributed to retailers through wholesale centers in $100$ locations in the United States, Canada, and Europe. You have collected the following data relating to the value of inventory in the U$.$S$.$ Airfilter supply chain: