Posted: November 21st, 2022
The Texas Gladiators won the Super Bowl last year. As a result, sportswear such as hats, sweatshirts, sweatpants, and jackets with the Gladiator’s 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 baseball 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 some demand data for the cap for a 30-week period. The data is shown below. (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.
Questions:
1. In the past, Ms. James has placed an order whenever the stock got down to 150 caps. What level of service does this reorder point correspond to?
2. What would the reorder point and safety stock need to be to achieve the desired service level (99%)?
3. 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.
4. Base Case: Suppose that the carrying cost is $6/unit/year and ordering cost is $200/order. Assume that there are 52 weeks in a year. For this base case, compute an optimal order quantity, average inventory (when service level is 99%), annual number of orders, total inventory costs, and cycle time.
5. For the base case, construct a graph showing how annual carrying cost, ordering cost, and total cost changes due to the changes in order quantity.
6. Sensitivity Analysis: Construct table(s) and/or graph(s) that show how the optimal order quantity and total inventory costs change when (a) carrying cost varies from $4 to $8/unit/year and (b) ordering cost varies from $150 to $250/order.
Place an order in 3 easy steps. Takes less than 5 mins.