Use the Excel simulation file you created to determine the total loss and inventory level that minimizes cost $($and loss$)$ for the following demand pattern: mean of $120$ and standard deviation of $15.$ The new underage cost is $45$ and the overage cost is $15.$

You will need to use a trial$-$and$-$error approach $($also known as brute$-$force approach$).$

between $710$ and $720$

between $10$ and $20$

between $1500$ and $1600$

between $70$ and $80$

between $30$ and $40$

between $60$ and $70$

between $125$ and $135$

between $1510$ and $1520$

between $780$ and $820$

between $15$ and $45$