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 ealculate the re$-$order points for each of the items:

$\backslash$table$[[,\backslash$table$[[$Average Daily$],[$Demand $($Units$)]],\backslash$table$[[$Replenishment$],[$Cycles $($days$)]],,\backslash$table$[[$Re$-$Order Point$],[$Quantity$]]],[$A$-001,30,5,,],[$B$-002,210,2,,],[$C$-003,680,30,,],[$D$-004,5,150,,],[$D$-005,1,200,90,,],[,,,,]]$