Excel answer sheet
- 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. - 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 - 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:
- Using a three-week moving average, what is your forecast for week six?
a) 30
b) 35
c) 32.5
d) 25 - 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 - 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
