Northcutt Bikes: The Forecasting Problem Essay

500 words - 2 pages

Northcutt Bikes: The Forecasting Problem

Jan Northcutt is the owner of bike shop named after her. She has been owner this business for over 20 years. She started to notice that the quality of her bikes that she was purchasing for her to sale were declining while the prices she was paying was going up. The features that she preferred on the bikes were impossible obtain quickly. Instead of panicking or placing blame on somebody else she met the problem head on. Jan started to buy all the necessary parts needed for her bike and rented a separate garage assisted by two helpers. She ended selling the bike shop as demand grew and lease a fairly large facility to house her inventory. As the operation increase, she backward integrated ...view middle of the document...


Multiple regression or MR (Y is forecast, X’s are period and base) MAD ≈ 45.096
Simple regression or SR (deseasonalize demand, seasonal forecast, X is period) MAD ≈ 32.403
Exponential Smoothing or ES (adjusted for trend and seasonality) MAD ≈ 13.258

Forecast for January – April 2012
Month | Mean Base | Period | MR | SR | ES |
January | 0.61 | 49 | 825.27 | 745.12 | 720.56 |
February | 0.88 | 50 | 1107.05 | 1082.68 | 1039.50 |
March | 0.87 | 51 | 1105.66 | 1078.04 | 1027.69 |
April | 1.05 | 52 | 1296.43 | 1310.32 | 1240.31 |

Exponential smoothing forecast will provide lowest MAD. The disadvantages with this method is it has to be updated frequently once a month.
Jan’s knowledge of the market could be used to add additional variable to multiple regression. Also, she can other cautiously adjust forecasts and ad monthly increments to the forecast to react to latest information, provided that is not too costly.
The approach that may be the most feasible in Jan’s situation is quicker response may lead to reduce lead times. She could possibly implement online ordering. For her supplier, she could reduce lead times and set contracts. Jan could upgrade her information systems allowing her information to get to the right customer. The people that she employs she can increase flexibility and when needed hire temporary work.
Jan operation in my personal opinion has not grown too large she can control if she does these things. Delegate effectively task that need to be accomplished. Improve her information systems and improve lead times. Utilize different method of operation to best fit each style of bike that she sales. If all these suggestion is used effectively Jan should have no problem managing her large operation.

Other assignments on Northcutt Bikes: The Forecasting Problem

Cross Function Essay

1663 words - 7 pages used for viewing the flow of the processes involved in producing the product. It is a very useful tool for seeing the totality of the operation and for identifying potential problem areas. There is no exact format for designing the chart. The flowchart can be very simple or very detailed. 7. Understand current technological advancements and how they impact process and product design. 
 Different types of technologies can significantly

Ducati Corse Essay

1339 words - 6 pages ) frequent face-to-face communication  Data-Driven approach to problem solving - Ducati effectively used data related to lap times, top speeds, average speeds etc. to assess how its bikes were performing vis à vis its competitors. Additionally the on-board sensors provided data on engine speed, oil, engine and tire temperatures etc. The engineers also received feedback from riders themselves. All these sources of data were used in identifying any

New Neighbor Request From Sootilicioux Suew

959 words - 4 pages Section A. A1. There are two types of statistics that are often referred to when making a statistical decision or working on a statistical problem. Descriptive statistics utilize numerical and graphical methods to look for patterns in data set, to summarize the information revealed in a data set and to present information in a convenient form that individuals can use to make decisions (Singpurwalla, 2013).Descriptive statistics main goal is

Week 1 Hcs 405

421 words - 2 pages , employee management, regulatory compliance, reducing costs, forecasting, and so forth? o What successes are enabled by an adequate understanding or appropriate application of the skill, concept, procedure, or tool? o What risks or failures are associated with an inadequate understanding or inappropriate application of the skill, concept, procedure, or tool? Save the completed worksheet as a Microsoft® Word document with your

Global Supply Chain Management

1595 words - 7 pages capacity to hold goods bought on any type of promotion, including quantity discounts, truckload discounts and canvass period discounts What if the distributor passes the discount along to the retailers? What is the value of the promotion game? 11 Barilla SpA Part A (continued) To address this problem, the director of logistics suggests the implementation of Just-in-Time Distribution (JITD), with Barilla’s distributors. Under the proposed

Managerial Eco

2032 words - 9 pages ? 11- What is multicolllinearity ? How can researcher detect this problem ? What is the impact of this problem on the regression estimate ? What steps can be taken to deal with this problem? 12- What is meant by " naïve" forecasting methods ? Describe some of the methods that falls within this category . 13- Indicate whether each of the following statement is (T) or (F) . Explain Why? a. When the law of diminishing

Econ

4124 words - 17 pages necessities 15. A free-rider problem arises when a good is (A) Nonrival (B) Nondepletable (C) Nonexcludable (D) produced in a competitive market (E) produced in a monopolistic market 16. According to the production possibilities curve above, which of the following is true? (A) The opportunity cost of producing another unit of good Y in terms of good X increases as more of good Y is produced. (B) The opportunity cost

Mba Thessis

5063 words - 21 pages Consumer Decision Process and Problem recognition LEARNING OBJECTIVES 1) Understand the impact of purchase involvement on the decision process. 2) Know the various types of decision making used by consumers. 3) Know what problem recognition is, how it occurs, and how it fits into the consumer decision-making process. 4) Know how to measure problem recognition. 5) Understand how marketing strategy can be developed

Illustrious Corp Case Study

645 words - 3 pages Case: Illustrious Corporation Supply Chain Management January 3, 2013 I. Statement of the Problem/Key Strategic Issue Illustrious Corporation is a small assembly shop for the X500 product. Nancy Barfield, the production planner has been preparing the operating plan for the next 10 weeks. The first component for X500 is the H590 which they purchase from other local company but are then returned to the supplier due to the number of

Debate Topics

8488 words - 34 pages were provided with those bikes. Each rider signed the standard waiver provided by CBTR; indicating that they would hold the company harmless from any injuries received as a result of the bike ride – except in cases of gross negligence on the part of the Company. One of the reasons that the bikes being used that day were discontinued is that the manufacturer was never able to completely pinpoint a problem that caused the bike to stop

Eastern Gear Inc Case Study

978 words - 4 pages Exhibit 1, Material E is the most common material as it had $110,000 in usage in 2011. Problem #3 – Processing time. After receiving the materials, the production process takes about two weeks. However, recently production time has increased to four weeks without any indication as to the reasoning for the increase. Production processing needs to re-evaluated to determine the exact cause for the increase in production time. Based on forecasting

Similar Documents

Northcutt Bikes Case Study

1061 words - 5 pages Executive Summary Northcutt Bikes is a bike manufacturer and a service provider of bike parts to the many retail businesses that sell Northcutt bikes. Northcutt Bikes has a warehouse that is 95% utilized however they have an order fulfillment rate of less than 80%. This has caused a loss of revenue due to orders being cancelled when needed parts are not in stock. To resolve the problem, we looked at 3 alternatives including establishing

Mba Student Essay

3636 words - 15 pages Competition Bikes, Inc. Competition Bikes, Inc. makes bicycles for professional and other highly accomplished riders who compete in bike races, biathlons, and triathlons. Sixty percent of all race winners have been victorious using a Competition Bikes, Inc. bicycle when at least ten percent of the entrants were also using a Competition Bikes, Inc. bicycle. This extraordinary success rate consistently is a topic of conversation among racers and

Rjet Task 1 Essay

4378 words - 18 pages Bikes, Inc. answer is to keep a large amount of inventory on hand, even during the slow periods; this however keeps money tied up over the month. I believe the answer to this problem is that the company should be purchasing materials on an as needed basis, which will bring the inventory into the building just prior to it being needed on the production floor. Another area for error is that the parts are left on the production floor for the entire

Harley Davidson Case Study

2941 words - 12 pages consideration and assumptions which are related to data provided in the case. Factors consideration for Forecasting: * Consistent increase in total registration of motorbikes worldwide from 1993 to 1995. * Increase in market growth in US 12.33%, in Europe 8.7% and in Japan/Australia 4.41%. * Harley has increased its capacity from 37,000 bikes in 1986 to 119000 bikes in 1996 with an average increase of 12.48% each year and yet they