The following data represents historic demand for steps in a beer supply chain. What level of inventory would need to be held at each step in order to expect a $95\%$ service level to each subsequent customer in the chain $($see attached excel sheet$)?$ If each piece of inventory costs $$1,$ how much TCO would be added to the supply chain for each tier to operate at a $99\%$ service level instead of $95\%?$ Calculate as a dollar value and as a percentage increase.

Service Level Calculation.xlsx Download Service Level Calculation.xlsx