Solve the following questions USING EXCEL:

$8.$ Given the weekly demand data below, simulate the operation of a fixed$-$order$-$quantity inventory system with a reorder point of $60,$ an order quantity of $100,$ and a beginning inventory of $100.$ The lead time is one week. All orders are placed at the end of the week and backordering is not allowed. What is the average end$-$of$-$week inventory on hand and the sales lost? $(20$ Points$)$

$\backslash$table$[[$Week$,\backslash$table$[[$Beginning$],[$inventory$]],\backslash$table$[[$Quantity$],[$on$-$order$]],$Demand,$\backslash$table$[[$Ending$],[$inventory$]],\backslash$table$[[$Inventory$],[$position$]],\backslash$table$[[$Order$?],[($yes$/$no$)]],\backslash$table$[[$Lost$],[$Sales$]]],[1,100,,43,,,,],[2,,,35,,,,],[3,,,33,,,,],[4,,,22,,,,],[5,,,41,,,,],[6,,,40,,,,],[7,,,53,,,,],[8,,,47,,,,],[9,,,20,,,,],[10,,,49,,,,],[11,,,49,,,,],[12,,,63,,,,]]$