Please show work & formulas in Excel - thanks!

Problem 2 (10 points) Complete Computer (CC) is a retailer of computer equipment in Minneapolis with four retail outlets. Currently each outlet manages its ordering independently. Demand at each retail outlet averages are equal to the last 4 non-zero digits of your student ID# (in units per week). Each unit costs $300 and CC has a holding cost of 25%. The fixed cost of each order (administrative + transportation) is $1,000. Assume 50 weeks in a year. Build a spreadsheet model to answer the following questions (Make sure your answers are in text boxes independent of the spreadsheet model). a. Given that each outlet orders independently and gets its own delivery, calculate the optimal order size (EOQ) at each outlet. b. What is the average inventory at each outlet? c. CC is thinking of centralizing purchasing (for all four outlets). In this setting CC will place a single order (for all outlets) with the supplier. The supplier will deliver the order on a common truck to a transit point. Since individual requirements are identical across outlets, the total order is split equally and shipped to the retailers from this transit point. This entire operation has increased the fixed cost of placing an order to $1,800. What should the EOQ be for the set of all four outlets. d. What is the average inventory per outlet in the new CC system? e. Explain the change from part b to part d