Supply Chain Engineering

***Please Solve Using Excel***

Weekly demand for private label washing machines at Karstadt, a German department store chain, is normally distributed with a mean of 600 and a standard deviation of 300. Karstadt currently has a supply source in China that delivers machines at a cost of 200 euro. The lead time required by the supplier is normally distributed with a mean of nine weeks and a standard deviation of six weeks. A European supplier has offered to deliver washing machines with a guaranteed lead time of one week at a cost of 250 euro. Karstadt has a holding cost of 20 percent and targets a cycle service level of 98 percent. Should Karstadt accept the local supplier's offer