You are working for an outdoor apparel company and have been tasked with choosing order quantities for next season's line of ski jackets. For each jacket style, you have cost information as well as a forecast from the marketing department specifying the mean and standard deviation of expected demand, which you can assume will follow a normal distribution.
One of the jackets, the Algonquin Parka, has total landed cost of $90 per unit and will retail for $195. Any leftover jackets will be sold at a 60% discount off the retail price. According to marketing, the most likely value of demand (i.e. the mean of the demand distribution) is 2000 units, with a standard deviation of 300 units.
a. What is the underage cost, cu, i.e. the cost of not stocking an incremental unit that a customer would have wanted to buy? Round your answer to the nearest integer.
b. What is the overage cost, co, i.e. the cost of stocking an incremental unit that does not sell? Round your answer to the nearest integer.
c. What is the optimal order quantity for the Algonquin parka? Round your answer to the nearest integer.
Cost price(CP) = $90
Selling price(SP) = $195
Salvage value(V) = $195 - (60% of $195) = $195-$117 = $78
Average daily demand (d) = 2000 units
Standard deviation of daily demand (d) = 300
units
a) Underage cost(Cu) = SP-CP = $195-$90 = $105
b) Overage cost(Co) = CP-V = $90-$78 = $12
C) Service level = Cu/(Cu + Co) = 105/(105+12) = 105/117 = 0.90 = 90%
At 90% service level value of Z = 1.28
Optimal order quantity = d + Z × d
= 2000 + (1.28 × 300)
= 2000+384
= 2384 units
You are working for an outdoor apparel company and have been tasked with choosing order quantities...
Problem 3 Although your initial calculations were quite precise, you learn that Tegaderm experiences multiple stock-outs in the pharmacy. You have also learned that demand is actually variable; it has a mean of 80 dressings per day, with a daily standard deviation of 10. Additionally, 3M takes longer to ship than expected: it actually takes 10 days to receive an order. Please round to the nearest whole unit (for units, dollars can remain in dollar/cents) for this entire problem. You...
Please help! especially part c,d,e. I have found the answer for
part a and b, so please help me part c,d, and especially part
e!
part a answer:
Excel = Norm.Inv (0.889, 2500, 400)
= 2989
part b answer:
Excel
= Norm.inv (0.95, 2500, 400)
= 3158
ABC Sportswear company designs and sells wetsuits to the U.S. market. The designs of the wetsuits are updated each year. The process for updating the design typically starts in January the year before...
You have recently been promoted to Senior Consultant for the professional service firm, BUSI 2083 LLP thanks in part to the hard work in leading the engagement for your client Perfect Stitch. Your firm specializes in providing a wide variety of internal business solutions for different clients. After a weekend of celebrations from your promotion, a Senior Manager calls you into her office first thing Monday morning to help with a technology client who is making a tough decision about...
Subject: HRM
Introduction and Instructions
You have recently been hired as the Director of Human Resources
for Wilson Brothers Canada and have HR responsibility for all of
the company’s Canadian operations. Bob and John Wilson have asked
you to prepare a report for their review focusing specifically on
organizational behavior within the company. Review the Wilson
Brothers Case Scenario in depth and address the required topic
listed below in your analysis report. Marks are allocated for
thoroughness of coverage of...
Can you please provide the formula for the worksheet also.
CASE PROBLEMS Level 1- Analyzing Sales for Crèmes Ice Cream Judd Hemming is the eastern regional marketing manager for Crèmes Ice Cream. Eac quarter, he completes two separate analyses: an analysis comparing ice cream flavor sale volumes from all regional locations with the same quarter sales volumes from the previou year and an analysis comparing total sales in dollars, including mean, median, mode, and standard deviation, of sales by store....
SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the company's new line of single-serve coffee pods or to await results from the product's launch in the United States. Key strategic decisions include choosing the target market to focus on and determining the value proposition to emphasize. Important questions are also raised in regard to how the new product should be branded, the flavors to offer, whether Kraft should use traditional distribution channels or...