Excel answer sheet
1. Which of the following is not an assumption of the EOQ model?
a) demand is known and constant
b) no shortages allowed.
c) lead time is determined by quantity ordered.
d) order quantity is received all at once.
2. A service level of 95% means there is a 0.95 probability.
a) Of meeting all demand
b) Of a stock-out
c) That supply will exceed demand
d) That demand will be met during the lead time
3. A company produces a product which is designed to weigh 10 oz., with a tolerance of + 0.5 oz. The process produces products with an average weight of 9.95 oz. and a standard deviation of 0.10 oz. The process capability ratio for this process is with z = 3.
a) 1.67
b) 0
c) 0.8333
d) -1.67
Given the following weekly demand figures below, answer the next 2 questions below:
4. Using a three-week moving average, what is your forecast for week six?
a) 30
b) 35
c) 32.5
d) 25
5. What is the exponentially smoothed forecast for week 2? (Use F1 = 25 and alpha = .2)
a) 21.0
b) 24.0
c) 32.0
d) 53.0
6. Companies often outsource to
a) Focus on core competencies.
b) Achieve greater flexibility.
c) Reduce costs.
d) All of the aboveWeek Demand
1 20
2 60
3 30
4 20
5 40