An appliance store sells a mixer with popular demand. The initial shock was 25 mixers. Inventory policy: order a size of 25 mixers when the inventory level drops to 10 mixers (reorder level). Lead time = 2 weeks (for order to arrive) Costs: - Holding : $1/unit/week, Ordering : $45/order, Back order: $5/unit/week the observed probability of both #of customers I demand per week): # of customers 0 I 2 3 4 Probability. 0.1 0.3 0.25 0.2 0.15 demand/customer 1. 2 3 4 Probability 0.1 0.15 0.4 0.35 NB: we can't place a new order before receiving an earlier one. Simulate the process based on weekly steps, considering costs of: Ordering, holding & back order and total. (Using goal seeking tool on Excel)