Question

In: Operations Management

2. Audie Murphy Apparel (AMA) produces patriotic shirts in three colors: red, blue, and white. The...

2. Audie Murphy Apparel (AMA) produces patriotic shirts in three colors: red, blue, and white. The monthly demand for each color is 3,000 units. Each shirt requires 1/2 pound of raw cotton. The cotton costs AMA $2.70 per pound. The transportation time from the supplier to AMA is 2 weeks. It costs AMA $100 to place each order and the annual holding cost percentage for AMA is 20 percent of the cost per pound.

a. What is the optimal order quantity of cotton? Round intermediate calculations to 2 decimal places (e.g., $18.61) and your answer to the nearest whole number.

Optimal order quantity _____ pounds

b. How many orders will AMA place during the next year? Round intermediate calculations to 2 decimal places (e.g., $18.61) and your answer to 2 decimal places (e.g., 108.37 times).

Number of orders ______

c. How frequently should the company order cotton? This is sometimes called the time between orders (TBO). Round intermediate calculations to 2 decimal places (e.g., $18.61) and your answer to 2 decimal places (e.g., once every 4.13 months).

Company orders once every ______months

d. Assuming that the first order is needed on April 1, when should AMA place the order?

a. March 15th

b. April 1st

c. April 15th

e. What is the annual holding cost when the optimal quantity (part a) is ordered? Round intermediate calculations to 2 decimal places (e.g., $18.61) and your answer to the nearest whole number.

Annual holding cost________per year

f. What is the resulting annual ordering cost when the optimal quantity (part a) is ordered? Round intermediate calculations to 2 decimal places (e.g., $18.61) and your answer to the nearest whole number.

Annual ordering cost ______

g. If the annual holding cost percentage was only 5 percent, how would it affect the annual number of orders, the optimal order size, and the average inventory?

If the holding cost is lower, then the batch size would be larger/smaller -
Thus, the average inventory would be larger/smaller and
the number of orders would be larger/smaller -

Solutions

Expert Solution

2.

Monthly demand of shirts = 3000*3 = 9000

Monthly demand of cotton = 9000*(1/2) = 4500 pounds

Annual demand of cotton D = 4500*12 = 54000

Ordering cost S = 100

Price per pound of cotton P = 2.70

Holding cost H = 0.20*2.70 = 0.54

Lead time L = 2 weeks or ½ month

a)

Optimal order quantity Q = sqrt(2DS/H) = sqrt(2*54000*100/0.54) = 4472.13 or 4472 pounds

b)

Number of orders placed = 54000/4472.13 = 12.07 or 12 orders

c)

The company should order cotton every 4472.13/4500 = 0.99 months

d)

Lead time is 2 weeks so the order should be placed 2 weeks prior to the requirement. That is 15th March.

e)

Annual holding cost AHC = HQ/2 = 0.54*4472.13/2 = 1207.47 or $1207 per year

f)

Annual ordering cost AOC = DS/Q = 54000*100/4472.13 = 1207.47 or $1207 per year

g)

The relationship between order quantity and the holding cost is inverted. This means as the holding cost increases by X times, the order quantity is reduces by sqrt(X) times, keeping everything constant.

If the holding cost is reduce to 5% then the order quantity will increase. 5% is 0.25 times the previous 20%. This means the order quantity will increase by inverse of sqrt(0.25) = 0.5 times. That is 1/0.5 = 2 times.

If the holding cost is lower, then the batch size would be larger

Thus the average inventory would be larger

The number of orders would be smaller


Related Solutions

SY Manufacturers (SYM) is producing T-shirts in three colors: red, blue, and white. The monthly demand...
SY Manufacturers (SYM) is producing T-shirts in three colors: red, blue, and white. The monthly demand for each color is 4,400 units. Each shirt requires 0.80 pound of raw cotton that is imported from the Luft-Geshfet-Textile (LGT) Company in Brazil. The purchasing price per pound is $2.00 (paid only when the cotton arrives at SYM's facilities) and transportation cost by sea is $0.40 per pound. The traveling time from LGT’s facility in Brazil to the SYM facility in the United...
SY Manufacturers (SYM) is producing T-shirts in three colors: red, blue, and white. The monthly demand...
SY Manufacturers (SYM) is producing T-shirts in three colors: red, blue, and white. The monthly demand for each color is 1,457 units. Each shirt requires 0.75 pound of raw cotton that is imported from the Luft-Geshfet-Textile (LGT) Company in Brazil. The purchasing price per pound is $8.30 (paid only when the cotton arrives at SYM's facilities) and transportation cost by sea is $0.70 per pound. The traveling time from LGT’s facility in Brazil to the SYM facility in the United...
Joint cost allocation Rosie’s Roses produces three colors of roses: red, white, and peach. The roses...
Joint cost allocation Rosie’s Roses produces three colors of roses: red, white, and peach. The roses are produced jointly in the same garden, and aggregately cost a total of $110 per harvest. One harvest produces 80 red roses, 70 white roses, and 50 peach roses. Rosie also noted that the peach roses require a fertilizer that is twice as expensive as the fertilizer required by the white and red roses. However, due to the structure of the shared garden space,...
PYTHON PROGRAMMING The colors red, blue, and yellow are known as the primary colors because they...
PYTHON PROGRAMMING The colors red, blue, and yellow are known as the primary colors because they cannot be made by mixing other colors. When you mix two primary colors, you get a secondary color, as shown here: Red and blue = purple Red and yellow = orange Blue and yellow = green For this program, you will employ list data structures to store a group of objects by designing a program that prompts the user to enter the names of...
Twelve chairs are to be painted. The available colors are Red, Blue, Green, and Yellow, and...
Twelve chairs are to be painted. The available colors are Red, Blue, Green, and Yellow, and every chair must be painted with one color. Assuming that all coloring schemes are equally likely, what is the probability that one color is not used and there are at least two chairs of every other color ? (The answer is 0.25) Can anyone explain to me why ?
An urn has 2 red, 5 white, and 4 blue balls in an urn and two...
An urn has 2 red, 5 white, and 4 blue balls in an urn and two are drawn one after another without replacement. What is the probability that the two balls are both red given that they are the same color?
Patriot Co. manufactures and sells three products: red, white, and blue. Their unit selling prices are...
Patriot Co. manufactures and sells three products: red, white, and blue. Their unit selling prices are red, $20; white, $35; and blue, $65. The per unit variable costs to manufacture and sell these products are red, $12; white, $22; and blue, $50. Their sales mix is reflected in a ratio of 5:4:2 (red:white:blue). Annual fixed costs shared by all three products are $250,000. One type of raw material has been used to manufacture all three products. The company has developed...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $46; white, $76; and blue, $101. The per unit variable costs to manufacture and sell these products are red, $31; white, $51; and blue, $71. Their sales mix is reflected in a ratio of 2:2:1 (red:white:blue). Annual fixed costs shared by all three products are $141,000. One type of raw material has been used to manufacture all three products. The company has developed...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $47; white, $77; and blue, $102. The per unit variable costs to manufacture and sell these products are red, $32; white, $52; and blue, $72. Their sales mix is reflected in a ratio of 5:4:2 (red:white:blue). Annual fixed costs shared by all three products are $142,000. One type of raw material has been used to manufacture all three products. The company has developed...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are...
National Co. manufactures and sells three products: red, white, and blue. Their unit sales prices are red, $53; white, $83; and blue, $108. The per unit variable costs to manufacture and sell these products are red, $38; white, $58; and blue, $78. Their sales mix is reflected in a ratio of 5:4:2 (red:white:blue). Annual fixed costs shared by all three products are $148,000. One type of raw material has been used to manufacture all three products. The company has developed...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT