Can you please help with question 3, I have attached date in Exhibit 3 as well.

3. Assuming a service level of 99% for all parts, what will be the impact on the total inventory investment if the number of warehouses is reduced from 8 warehouses to 2? Reduced to 1? Assume that each of the 8 wacebouse has roughly equal demand and, when consolidating the warehouses, the total demand across all 8 warehouses is equally divided between the remaining warehouses. a. Using data from the case and Exhibit 3, complete the table below. Note that Exhibit 3 gives the standard deviation of the bi-weekly demand for 8, 2, and 1 wacehnusesrespectively. Use these values to calculate the m of weekly demand. (Hint: refer to the solved inventory problems document for additional examples) (2 points) m- Griffin Beaker Erlenmeyer Flask Average Weekly Demand mot Weekly Demand Calculations Average Pipeline for 1 lnvento warehouse W Average l nve ntory Total Average Inventory (all warehouses) b. Calculate the percentage savings in total average Inventory investment from warehouse consolidation for each product. Assume lead time stays constant at 1 week: i. from 8 warehouses to 2 warehouses. (0.5 points) ii. from 8 warehouses to 1 warehouse. (0.5 points)