Directions: Solve the following problems and submit the solutions in Microsoft Excel.

"Artists' Advantage" sells painting supplies. 2080 units of the most basic brush for watercolors, the T100, are sold a year. The order cost is $30 per order, and the holding cost is $3.00 per box. The lead time for an order is 3 weeks, and the standard deviation of demand is 6 boxes per week.

1. What is the optimal order quantity of brushes? (5 marks)
2. What is the optimal number of orders per year? (5 marks)
3. Compute the period that most closely matches this EOQ. (5 marks)
4. What value of z should be used if A1 wishes to achieve a cycle-service level of 98 percent? (5 marks)
5. Using the period from part c, compute the target inventory level T. How much safety stock of brushes does this provide? How does this compare to the safety stock if a continuous review system is used? (10 marks)