solution
A North Face retail store in Chicago sells 500 jackets each month. Each jacket costs the store $100 and the company has an annual holding cost of 25 percent. The fixed cost of a replenishment order (including transportation) is $100. The store currently places a replenishment order every month for 500 jackets. What is the annual holding and ordering cost? On average, how long does a jacket spend in inventory? If the retail store wants to minimize ordering and holding cost, what order size do you recommend? How much would the optimal order reduce holding and ordering cost relative to the current policy?
Please show all formulas and work. Has to be done on Excel, please show me step by step! Attached is what I need.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

