Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

1. Is seasonal exponential smoothing the best model for forecasting Urban Run athletic wear? Why? 2. Explain what has happened to the data for Urban

1. Is seasonal exponential smoothing the best model for forecasting Urban Run athletic wear? Why? 2. Explain what has happened to the data for Urban Run. What are the consequences of continuing to use seasonal exponential smoothing? What model would you use? Generate a forecast for the 4 quarters of the 4th year using your model. Determine your forecast error and the inventory consequences. 3. Is exponential smoothing with trend the best model for forecasting 5-pocket cargo jeans? Why? 4. What method would you use to forecast monthly cargo jean demand for the second year given the previous year?s monthly demand? Explain why you selected your approach. Generate the forecasts for each month of the second year with your method. Determine your forecast error and the inventory consequences. image text in transcribed

CASE: Bram-Wear Lenny Bram, owner and manager of BramWear, was analyzing performance data for the men's clothing retailer. He was concerned that inventories were high for certain clothing items, meaning that the company would potentially incur losses due to the need for significant markdowns. At the same time, they had run out of stock for other items early in the season. Some customers appeared frustrated by not finding the items they were looking for and needed to go elsewhere. Lenny knew that the problem, though not yet serious, needed to be addressed immediately. Background BramWear was a retailer that sold clothing catering to young, urban, professional men. It primarily carried upscale, casual attire, as well as a small quantity of outwear and footwear. Its success did not come from carrying a large product variety, but from a very focused style with an abundance of sizes and colors. BramWear had extremely good financial performance over the past 5 years. Lenny had attributed the company's success to a group of excellent buyers. The buyers seemed able to accurately target the style preferences of their customers and correctly forecast product quantities. One challenge was keeping up with customer buying patterns and trends. The Data To determine the source of the problem Lenny had requested forecast and sales data by product category. Looking at the sheets of data, it appeared that the problems was not with the specific styles or items carried in stocks; rather, the problem appeared to be with the quantities ordered by the buyers. Specifically, the problem centered on two items: an athletic shoe called Urban Run and the 5pocket cargo jeans. Demand for Urban Run Athletic Shoe Quarter I Year 1 Demand 10 Year 2 Demand 14 Year Demand 20 Year Demand 30 II 29 31 26 31 III 26 29 28 33 IV 15 18 30 35 Urban Run was a popular athletic shoe that had been carried by BramWear for the past 4 years. Quarterly data for the past 4 years are shown in the table. The company seemed to always be out of stock of this athletic shoe. The model used by buyers to forecast sales for this item had been seasonal exponential smoothing. Looking at the data, Lenny wondered if this was the best method to use. It seemed to work well in the beginning but now he was not so sure. The data for the 5pocket cargo jean seemed to also point to a forecasting problem. When the product was introduced last year it was expected to have a large upward trend. The buyers believed the trend would continue and used an exponential smoothing model with trend to forecast sales. However, they seemed to have too much inventory of this product. As with the Urban Run athletic shoe, Lenny wondered it the right forecasting model was being applied to the data. It seemed he would have to dig out his old operations management text to solve this problem. Demand for 5-Pocket Cargo Jeans January Year 1 Demand 36 Year 2 Demand 98 February 42 101 March 56 97 April 75 99 May 85 100 June 94 95 July 101 107 August 108 104 September 105 98 October 114 104 November 111 100 December 110 102 Month Case Questions 1. Is seasonal exponential smoothing the best model for forecasting Urban Run athletic wear? Why? 2. Explain what has happened to the data for Urban Run. What are the consequences of continuing to use seasonal exponential smoothing? What model would you use? Generate a forecast for the 4 quarters of the 4th year using your model. Determine your forecast error and the inventory consequences. 3. Is exponential smoothing with trend the best model for forecasting 5pocket cargo jeans? Why? 4. What method would you use to forecast monthly cargo jean demand for the second year given the previous year's monthly demand? Explain why you selected your approach. Generate the forecasts for each month of the second year with your method. Determine your forecast error and the inventory consequences. 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting

Authors: John Hoggett, John Medlin, Keryn Chalmers, Claire Beattie, Andreas Hellmann, Jodie Maxfield

10th Edition

073036321X, 978-0730363217

Students also viewed these Accounting questions