# Question: Fancy Paints is a small paint store Fancy Paints stocks

Fancy Paints is a small paint store. Fancy Paints stocks 200 different SKUs (stock-keeping units) and places replenishment orders weekly. The order arrives one month (let's say four weeks) later. For the sake of simplicity, let's assume weekly demand for each SKU is Poisson distributed with mean 1.25. Fancy Paints maintains a 95 percent in-stock probability.

a. What is the average inventory at the store at the end of the week?

b. Now suppose Fancy Paints purchases a color-mixing machine. This machine is expensive, but instead of stocking 200 different SKU colors, it allows Fancy Paints to stock only five basic SKUs and to obtain all the other SKUs by mixing. Weekly demand for each SKU is normally distributed with mean 50 and standard deviation 8. Suppose Fancy Paints maintains a 95 percent in-stock probability for each of the five colors. How much inventory on average is at the store at the end of the week?

c. After testing the color-mixing machine for a while, the manager realizes that a 95 percent in-stock probability for each of the basic colors is not sufficient: Since mixing requires the presence of multiple mixing components, a higher in-stock probability for components is needed to maintain a 95 percent in-stock probability for the individual SKUs. The manager decides that a 98 percent in-stock probability for each of the five basic SKUs should be adequate. Suppose that each can costs $14 and 20 percent per year is charged for holding inventory (assume 50 weeks per year). What is the change in the store's holding cost relative to the original situation in which all paints are stocked individually?

a. What is the average inventory at the store at the end of the week?

b. Now suppose Fancy Paints purchases a color-mixing machine. This machine is expensive, but instead of stocking 200 different SKU colors, it allows Fancy Paints to stock only five basic SKUs and to obtain all the other SKUs by mixing. Weekly demand for each SKU is normally distributed with mean 50 and standard deviation 8. Suppose Fancy Paints maintains a 95 percent in-stock probability for each of the five colors. How much inventory on average is at the store at the end of the week?

c. After testing the color-mixing machine for a while, the manager realizes that a 95 percent in-stock probability for each of the basic colors is not sufficient: Since mixing requires the presence of multiple mixing components, a higher in-stock probability for components is needed to maintain a 95 percent in-stock probability for the individual SKUs. The manager decides that a 98 percent in-stock probability for each of the five basic SKUs should be adequate. Suppose that each can costs $14 and 20 percent per year is charged for holding inventory (assume 50 weeks per year). What is the change in the store's holding cost relative to the original situation in which all paints are stocked individually?

**View Solution:**## Answer to relevant Questions

Strohrmann, a large-scale bakery in Pennsylvania, is laying out a new production process for their packaged bread, which they sell to several grocery chains. It takes 12 minutes to bake the bread. How large an oven is ...Consider the following excerpts from a Wall Street Journal article on Burger King (Beatty, 1996): Burger King intends to bring smiles to the faces of millions of parents and children this holiday season with its "Toy Story" ...A small economic consulting firm has four employees, Alice, Bob, Cathy, and Doug. The firm offers services in four distinct areas, Quotas, Regulation, Strategy, and Taxes. At the current time Alice is qualified for Quotas, ...Consider the PhiladelphiaLos Angeles flight discussed in Q16.5. Assume the available capacity is 200 seats and there is no overbooking. The high fare is $675 and the low fare is $375. Demand for the low fare is abundant ...Australian bauxite ore is shipped 3,000 kilometers to New Zealand in a bulk cargo ship. The ship carries 300,000 metric tonnes of ore and consumers 1,400,000 liters of fuel oil on the journey. Fuel oil emits 38.2 kgs CO 2 ...Post your question