please help due tonight. second picture is part of question 2. Use excel!

Assignment 6: Legistics Decisions Submit your solutions in an Excel file in Canvas. Must show all work to receive full credit. Retain colculations in all cells in your spreadsheet. Grade Question 1 (50\%) A company stores product in three regional warehouses (A, B and C). See the table below for current service level and forecast error. Assume demand is equal at each warehouse. a) What is the total safety stock required with the current arrangement, using three warehouses? b) Estimate the percentage reduction in safety stock which can be achieved if the three existing warehouses are consolidated into one central warehouse, while maintaining the same service level. Note: Use the following formula to determine forecast error at the centralized location. Centralizedforecasterror:=(A2+i2+c2) Question 2 (50%) Deliveries are planned from Depot location (D) to customer locations A, B, and C. The table below provides travel time (in hours) between locations. Use the Time-Saved Heuristic to recommend a route that minimizes total travel time. Determine the route and time for one truck to start at D, visit all three locations, and return to D. Note: An Excel template is provided with the assignment. Solution must demonstrate the Time-Saved Heuristic steps demonstrated in class and depicted in Figures 15.12 - 15.14 Assignment 6 - Question 2 Based on Chapter 15: Time-Saved Heuristic Deliveries are planned from Depot location (D) to customer locations A, B, and C Use the Time-Saved Heuristic to develop a route that minimizes total travel time. Determine the recommended route and time for one truck to start at D, visit all three locations, and return to D Route Pairings Time Say Prioritize Pairings and assien routes Recommended route and time: Optional problem (not graded): Determine the routes and pimes based on a 15-hr limit on vehicle time away from the depot Recommended routes and times