Sports Obermeyer
Essay by 24 • January 28, 2011 • 1,135 Words (5 Pages) • 4,801 Views
Executive Summary
There were multiple issues weighing heavily on the mind Wally, a VP at Sports Obermeyer, in November of 1992. Sports Obermeyer, a successful manufacturer of ski apparel was having trouble planning the manufacturing levels of its various skiwear items for 1993-94 based on whatever scant information it had on the end customers’ likes and dislikes. Waiting to make these decisions till after the Las Vegas trade show, the one event which would give reliable retailer feedback, would prove very costly given the extremely long lead times of it’s suppliers in Hong Kong and China. In the past, Sports Obermeyer had relied on a group of company managers, called the “buying committee” to make a consensus forecast on the demand of for each of the company’s various products but it’s track was not particularly impressive. In the 1991-92 season, for e.g, some women’s parka styles outsold the original forecast by 200%, while sales of other styles amounted to less than 15% of the forecasted amount [Ref 1] [Exhibit 1]. Going forward the company needed a more reliable way to forecast demand before seeing orders, reduce lead times and decide on the production levels of it’s suppliers in Hong Kong and China.
Question 1:
Is 20000 units the correct amount to anticipate making in total? Why or why not?
20000 may not be the correct amount to anticipate as more analysis will have to be done to determine the optimal quantity of each style of parka, based on the overage and underage costs associated with each style of parka. Also, given that the actual standard deviation was historically twice the forecasted standard deviation injects a lot of risk of incurring overage and underage costs when going with just the average. More analysis is done in answering the following question.
Question 2:
Using the sample data given in Exhibit 10, make a recommendation for how many units of each style Wally Obermeyer should order during the initial phase of production. Assume that all ten styles in the sample problem are made in Hong Kong and that Obermeyer’s initial production commitment must be 10000 units. (Ignore price differences among styles in your initial analysis).
We first calculate the cost of underage and cost of overage for the various styles:
Cost of underage = profit lost because of lost sales.
Cost of overage = loss incurred by selling at sub manufacturing prices.
We know that the estimated profit on each parka that Obermeyer sold = 24%
We know that the estimated loss on each parka that Obermeyer sold at discount = 8%
Therefore, Cost of underage = 0.24
Cost of overage = 0.08
The critical ratio Cu/(Cu+Co) = 0.24/0.32 = 0.75.
Hence Obermeyer should stock up enough items to satisfy all the seasonal demand with probability 0.75. The optimal Q* is the 75th percentile of the demand distribution of each style of parka, which is:
Q* = (std-dev)*(Z-value) + mean
Z value = 0.67449. From this the optimal Q* for each style is given in the following table (highlighted in bold)
Style Forecast Average Forecast St. Dev Unit Price Cu Co Cu/(Cu+Co) Z-value optimal prod level
Seduced 4017 1113 73 17.52 5.84 0.75 0.67449 4767.707092
Assault 2525 680 90 21.6 7.2 0.75 0.67449 2983.65303
Electra 2150 807 173 41.52 13.84 0.75 0.67449 2694.313228
Anita 3296 2094 93 22.32 7.44 0.75 0.67449 4708.381537
Daphne 2383 1394 148 35.52 11.84 0.75 0.67449 3323.238712
Entice 1358 496 80 19.2 6.4 0.75 0.67449 1692.546916
Gail 1017 388 110 26.4 8.8 0.75 0.67449 1278.702023
Isis 1042 646 99 23.76 7.92 0.75 0.67449 1477.720379
Teri 1100 762 123 29.52 9.84 0.75 0.67449 1613.96119
Stephanie 1113 1048 133 31.92 10.64 0.75 0.67449 1819.865258
If we were to sum the optimal quantities of all the styles, it would come to about 26360 units, the half of which is way more than 10000, a constraint which the company must adhere to in the first phase. To find the optimal quantities we’ll need to find out a way of maximizing profits when ordering just 10000 in phase 1. This now becomes a case of a resource-constrained multiple product system, where the inventory space has become a constraint. We also need to make sure that Obermeyer honors the minimum order quantity required by the Hong Kong’s supplier. We can multiply the recommended optimal ordering level for each style by (20000/26360) thus ensuring that the total sum will exceed 20000 but which may not maximize profits.
rec prod level constant multi profit
4767.707092 3617.367928 63376.29
2983.65303 2263.765489 48897.33
2694.313228 2044.236794 84876.71
4708.381537 3572.356278 79734.99
...
...