I need help with figuring our the data that goes into yellow highlighted areas on this supply chain project.

SCM 201: Week 3 Inventory Assignment Due Date: Last day of Week 3 by 11:30PM Section # 1: Creating an Excel Spreadsheet to Calculate Re-Order Problem # 1: Calculate the re-order point quantity given a condition of certainty Company XYZ has the following items with average daily demand and replenishment cycle times as outlined in the chart below. The assumption is that demand and the cycle time do not fluctuate demand is certain). Create an Excel Spreadsheet in the format shown below and calculate the re-order points for each of the items: Re-Order Point Quantity Item # A-001 B-002 C-003 D-004 D-005 Average Daily Replenishment Demand (Units) Cycles (days) 30 5 210 2 680 30 5 150 1,200 90 Problem # 2: Calculate re-order point quantity given a condition of uncertainty ( Assume that Company XYZ is no longer confident in the demand pattern and the replenishment cycle times being certain or constant. So, the Manager decides to keep some Safety stock on hand to ensure that they do not run out of stock when conditions are uncertain. Create an Excel Spreadsheet in the format shown below and calculate the re-order points for each of the items: Required Safety Average Daily Replenishment Stock On-Hand Re-Order Point Item # Demand (Units) Cycles (days) (Units) Quantity A-001 30 5 90 B-002 210 2 630 C-003 680 30 2,100 D-004 5 150 150 D-005 1,200 90 12,000 Section # 2: Creating an Excel Spreadsheet to Calculate Economic Order Quantity (E00) Problem # 1: Creating an Excel Spreadsheet to calculate the Annual demand in units, annual demand in dollars, the (EOQ) Economic Order Quantity in units and the number of orders per year required for each item below. Requirements for this Problem: 1. Create a Spreadsheet like the table below. 2. Calculate the annual demand in units for each item (Assumption - use 360 days per year to calculate annual demand). 3. Calculate the annual demand in dollars for each item (Assumption - use 360 days per year to calculate annual demand)