CASE PROBLEMS 13.2
The Texas Gladiators Apparel Store
The Texas Gladiators won the Super Bowl last year. As a result, sportswear such as hats, sweatshirts, sweatpants, and jackets with
the GladiatorsÂ’ logo are popular. The Gladiators operate an apparel store outside the football stadium. It is near a busy highway, so the store has heavy customer traffic throughout the year, not just on game days. In addition, the stadium has high school or college
football and soccer games almost every week in the fall, and base- ball games in the spring and summer. The most popular single item the stadium store sells is a red and silver baseball-style cap with the GladiatorsÂ’ logo on it. The cap has an elastic headband inside it, which conforms to different head sizes. However, the store has had a difficult time keeping the cap in stock, especially during the time between the placement and receipt of an order. Often customers come to the store just for the hat; when it is not in stock, customers are upset, and the store management believes they tend to go to other competing stores to purchase their GladiatorsÂ’ clothing. To rectify this problem, the store manager, Jessica James, would like to develop an inventory control policy that would ensure that customers would be able to purchase the cap 99% of the time they asked for it. Jessica has accumulated the following demand data for the cap for a 30-week period. (Demand includes actual sales plus a record of the times a cap has been requested but not available and an estimate of the number of times a customer wanted a cap when it was not available but did not ask for it.)
The store purchases the hats from a small manufacturing company in Jamaica. The shipments from Jamaica are erratic, with a lead time of 20 days.
In the past, Ms. James has placed an order whenever the stock got down to 150 caps.
What level of service does this re- order point correspond to?
What would the reorder point and safety stock need to be to achieve the desired service level?
Discuss how Jessica James might determine the order size of caps and what additional, if any, information would be needed to determine the order size.
I have attached the document with the Week/Demand Table for reference. I have to turn this assignment in on October 12th. Please advise if this case study can be finished by then. I appreciate your assistance.