This is a single period inventory control problem where the demand is schocastic and follows normal distribution: the expected demand is 1000 units and the standard devision of the demand is 150 units. The suppliers have limited capacity and offer different unit wholesale price.

Please do it in Excel. I really need help formulating excel.

A B D E F G H j K L M N 1000 150 5 20 9 10 11 1 2 The mean of the demand 3 Standard devision of the demand 4 salvage value $ 5 Retail (selling) Price $ 6 7 8 Price/unit Capacity 9 Supplier 1 $ 500 10 Supplier 2 $ 500 11 Supplier 3 $ 500 12 13 14 15 16 17 12 This is a single period inventory control problem where the demand is schocastic and follows normal distribution: the expected demand is 1000 18 18 units and the standard devision of the demand is 150 units. The suppliers have limited capacity and offer different unit wholesale price. 19 20 Please answer the followings: 21 22 1. Calculate the optimum order quantity from supplier 1 if he/she has unlimited capacity 2 points 23 1. Calculate the optimum order quantity from supplier 2 if he/she has unlimited capacity 2 points 1. Calculate the optimum order quantity from supplier 3 if he/she has unlimited capacity 2 points 1. Calculate the optimum order quantity from the suppliers if their capacity is 500 units 4 points 26 27 20 28 29 24 25 30 31 32 33 34 35 36