Forecasting for House Sales in Us

In: Business and Management

Submitted By rvn1280
Words 2230
Pages 9
Forecasting Project
House Sales in USA
Presented by:
Michelle Deets
Ravin Seju
Ankan Sinha

March 7, 2016
Professor Dawit Zerom
ISDS 526

Executive Summary
The data in the report “Monthly total houses sold in the United States for the period January
1978 through July 2007” is time series data representing sales in thousands of units. The data has not been seasonally adjusted. Our project was to produce forecasts of housing sales by creating a model using Forecast Pro’s Expert Selection Method. The model was generated by withholding 2 years of data and creating a forecast based upon the data from January 1978 to July 2005. We provided fit measures based upon MAPE and RMSE and evaluated the model’s accuracy MAPE,
RMSE, and GMRAE from Forecast Pro’s out-of-sample statistic evaluation table. The MAPE numbers show that the forecast expands from a 7.95% error at the beginning of the holdout period and quickly grows to 32% error within 24 months. The acceptability of this error depends upon which managers are using it. The housing industry touches many fields, from moving to painting to construction to land purchases. This large of an error might could be unacceptable given the amount of risk and resources involved in construction of new single family homes; a manager might prefer to only use the first 6 months of forecasted data to stay within a 10% error range. Looking at the results of the forecast’s graph, the actual data (Exhibit A, represented by the green line) shows that actual housing sales dropped from July 2005 to July 2007. However, our forecasting model predicted that housing sales would vacillate but reach steady seasonal peaks
(represented by the red line). Using this forecast could devastate a company if it invested with the thought that the houses would sell at predictable intervals. This holdout analysis shows that we cannot…...

Similar Documents

Demand Forecasting

...DEMAND FORECASTING: EVIDENCE-BASED METHODS Forthcoming in the Oxford Handbook in Managerial Economics Christopher R. Thomas and William F. Shughart II (Eds.) Subject to further revisions File: Demandforecasting-17-August-2011-clean.docx 17 August 2011 J. Scott Armstrong The Wharton School, University of Pennsylvania 747 Huntsman, Philadelphia, PA 19104, U.S.A. T: +1 610 622 6480 F: +1 215 898 2534 armstrong@wharton.upenn.edu Kesten C. Green International Graduate School of Business, University of South Australia City West Campus, North Terrace, Adelaide, SA 5000, Australia T: +61 8 8302 9097 F: +61 8 8302 0709 kesten.green@unisa.edu.au # words in body 10,053 (requested range was 6,000 to 9,000) ABSTRACT We reviewed the evidence-based literature related to the relative accuracy of alternative methods for forecasting demand. The findings yield conclusions that differ substantially from current practice. For problems where there are insufficient data, where one must rely on judgment. The key with judgment is to impose structure with methods such as surveys of intentions or expectations, judgmental bootstrapping, structured analogies, and simulated interaction. Avoid methods that lack evidence on efficacy such as intuition, unstructured meetings, and focus groups. Given ample data, use quantitative methods including extrapolation, quantitative analogies, rule-based forecasting, and causal methods. Among causal methods, econometric methods are useful given good theory, and few key...

Words: 12973 - Pages: 52

Forecasting and Environment Forecasting

...FORECASTING AND ENVIRONMENT FORECASTING Forecasting is essentially the study of internal and external forces that shapes demand and supply. The shape of the things to come will depend partially upon how one shapes the controllable factors. With different strategies, the forecasting will be different, offering multiple scenarios for management decision making. Forecasting is an estimate of sales in physical units for a specified future period under proposed marketing plan or programme and under the assumed set of economic and other forces outside the organization for which the forecast is made. Long term forecasts: Product diversification, sales, advertizing budgets, capacity planning and investment planning, Short term forecasts: Material control, loading and scheduling, and budgeting. Objectives of forecasting Short term objectives • • • • • • Formulation of production policy – Regular supply of material, Maximum utilization of machines, Regular availability of labour Formulation of pricing policy Proper control of sales Arrangement of finance Production capacity Labour requirements Long term objectives • Capital restructuring and resourcing Steps in forecasting demand Determining the objectives Period of forecasting – Short term or long term Collection and analysis of data – data to be collected, tabulated, analyzed and cross-checked by applying statistical or graphical techniques Study of correlation – between sales forecasts and sales promotion plans studying......

Words: 1008 - Pages: 5

In House Sales

...In-House Sales In-House Sales The front office plays a vital role in the success of all departments within the hotel. When a traveler is checking-in, they are usually thinking of other things than the necessities such as food and beverages. When the front office staff informs guest about all services provided by the hotel, guest will know what can be obtained. They will know how to get it when they want to. Your guest will never buy what they do not know you have to sell. Referring guest to purchase food and other services will only increase each department’s sales. When brainstorming, I would invite the front office staff and departments heads from most departments in the hotel. They can give insight to their products and offer solutions to presentation verbiage. Ideas for improving the point of sales office would be to review features and benefits of each department. Often, it is not enough to just tell the customer about the feature, but why then want to purchase what they are selling. I would also have some type of incentive plan for selling other departments, even if it was not financial incentives. Cross training the front office staff, even to a minimal degree, would also help to maximize each departments efforts. The front office is responsible for many functions. The hotel’s bottom line is certainly tied to the performance of the front office. Not only would sales increase, but the guest experience would increase as well. There are times when a person......

Words: 281 - Pages: 2

Forecasting

...TOPIC 1. FUNDAMENTALS OF ECONOMIC FORECASTING TOPIC I TOPIC I. FUNDAMENTALS OF ECONOMIC FORECASTING   Contents 1. Meaning of forecasting 2. Features, importance and limitations of forecasting 3. Forecast types   1. Meaning of forecasting Forecast is a likely, scientifically well-grounded opinion about the possible state of the events, objects or processes in the future. Forecasting is a process of making statements about events whose actual outcomes (typically) have not yet been observed. Forecasting is a process of predicting or estimating the future based on past and present data. Economic Forecasting is a process of making forecasts based on analysis of past trends and regularities of the economic processes. Economic forecasts can be carried out at a high level of aggregation – for example for GDP, inflation, unemployment or the fiscal deficit – or at a more disaggregated level, for specific sectors of the economy or even specific companies. Economic forecasting provides information about the potential future events and their consequences for the organization. It may not reduce the complications and uncertainty of the future. However, it increases the confidence of the management to make important decisions.   Economic forecasting includes the following steps: 1. Identifying items to be forecast. The items of socio-economic forecasting are the economic processes (for example, inflation, demand, supply), any indicator describing the company activity (for......

Words: 17426 - Pages: 70

Sales Forecasting

...350 prospective distributors in seven highly polluted cities of ). Forrespondents, random sampling was resorted to. For prospective distributors, however, their v~eavailability played an important part in their selection and consequent interviews. For the latter 'IMis.ABCLtd., who were also manufacturers and marketers of all types of car batteries, helped in ion ofprobable distributors in different Indian cities. S.ABCQMDR Launch Plan in Seven Indian Cities. [FORECASTING@ PLANNING] Mis. BChad designed and conducted a conceptual study, without samples, in predefined seven A loflndia. Thiswas only an opinion study, exploratory in nature and that too organised without samples. This isafast moving consumer item, which may be needed by two-wheeler owners / users to minimise ~due toenvironmental pollution. Local competitive brands are available. 10,000 Jective retailoutlets two-wheeler sers were identified and interviewed at random along with 350 randomly selected u - only in these cities. most probable sales: At conservativelevel, ABC projected a , Infirstyear: 6.76L users). (Only "Yes" category of prospective , Secondyear: 6.412 L (40 cent conversion per Besides of "May be category" of probable end-users). !d toberesorted to productquality and regular availability, integrated communication and distribution strategies and implemented. Considerable end-user and even retailer education have to be 1isedn a regular basis, for......

Words: 586 - Pages: 3

Forecasting

...FORECASTING FUNDAMENTALS Forecast: A prediction, projection, or estimate of some future activity, event, or occurrence. Types of Forecasts * Economic forecasts * Predict a variety of economic indicators, like money supply, inflation rates, interest rates, etc. * Technological forecasts * Predict rates of technological progress and innovation. * Demand forecasts * Predict the future demand for a company’s products or services. Since virtually all the operations management decisions (in both the strategic category and the tactical category) require as input a good estimate of future demand, this is the type of forecasting that is emphasized in our textbook and in this course. TYPES OF FORECASTING METHODS Qualitative methods: These types of forecasting methods are based on judgments, opinions, intuition, emotions, or personal experiences and are subjective in nature. They do not rely on any rigorous mathematical computations. Quantitative methods: These types of forecasting methods are based on mathematical (quantitative) models, and are objective in nature. They rely heavily on mathematical computations. QUALITATIVE FORECASTING METHODS Qualitative Methods ...

Words: 8098 - Pages: 33

Forecasting Monthly Sales

...blowing in the wind and the waves lapping at the shore. They also knew that hiring the right manager would al- low James and Deena the time to begin a semi-retirement in a corner of paradise. To make this happen, James and Deena would have to sell The Glass Slipper for the right price. The price of the business would be based on the value of the property and equipment, as well as projections of future income. A forecast of sales for the next year is needed to help in the determination of the value of the restaurant. Monthly sales for each of the past 3 years are provided in Table 5.14.   Questions 1. Prepare a graph of the data. On this same graph, plot a 12-month moving average forecast. Discuss any apparent trend and seasonal patterns.
 2. Use regression to develop a trend line that could be used to forecast monthly sales for the next year. Is the slope of this line consistent with what you observed in question 1? If not, discuss a possible explanation. 3. Use the multiplicative decomposition model on these data. Use this model to forecast sales for each month of the next year. Discuss why the slope of the trend equation with this model is so different from that of the trend equa- tion in question...

Words: 479 - Pages: 2

Importance of Sales Forecasting to the Entrepreneurial Start-Up Firm

...analysis………………………………………5 2.1 What is sales forecasting……………….……………………………...5 2.2 Importance of forecasting in a new B2C business………….…………5 2.3 What affects sales forecasting?..............................................................6 2.4 Techniques of sales forecasting…………………….…………………7 2.4.1 Judgmental methods……………………………………….7 2.4.2 Counting methods………………………………………….8 2.4.3 Newer methods…………………………………………….8 2.5 Adapting forecasting to the company……………………………………...9 3. Conclusion……………………………………………………………….….9 References…………………………….………………………………………10 LIST OF FIGURES Figure 1: Elements of sales forecasting………………………………………………………………..7 Figure 2: Forecasting techniques used in practice …………………………………………………….8 1. Introduction This report discusses the importance of sales forecasting to the entrepreneurial start-up firm in B2C market. The previous assignment discussed the case study on the new set up business related to food industry. The business idea was to create a website and a mobile application that allows office people to order healthy food by choosing every ingredient to suit their personal taste. The concept is quite new to the market so the management has to look into the future sales by implementing sales forecasting.  So, the aim and objectives of this report are as follows: Aim: ·         To discuss why sales forecasting is important to the entrepreneurial start-up business in B2C Objectives: * To explain the nature of forecasting......

Words: 2231 - Pages: 9

What They Didn't Teach Us in Sales Class

...What They Didn’t Teach Us in Sales Class – Extra Credit Assignment 1. Should Rick Lester "turn in his keys"? Turning in his keys after only one month on the job (to include one week working alone), would be premature and unwise. Rick must realize that all jobs are challenging even with an abundance of knowledge and experience/expertise. A salesperson’s job is even more challenging given the long hours, hard work and the “calloused’ treatment of salespeople by buyers. Rick must exercise patience, perseverance and determination in order to successfully develop the skills necessary to successfully overcome these challenges which will enable him to become a better provider for his family and a better salesperson to Nabisco. 2. How should Mr. Brown handle this situation? What should he say to Rick? As the Division Sales Manager, one would surmise that this was not Mr. Brown’s first case of a new recruit “quitting before testing the waters.” There must have been valid reasons for making an employment offer to Rick. It is therefore incumbent on Mr. Brown to have a one-on-one meeting with Rick in an effort to understand his reasons for quitting. Having spent his first three weeks of employment with Mr. Brown, he is most likely the only person that Rick probably feels comfortable with or looked up to (more so before his inconsiderate comment). He should offer some encouragement and inspiration – positive reinforcement, focusing on his strengths and the reasons......

Words: 508 - Pages: 3

Forecasting

...FORECASTING - a method for translating past experience into estimates of the future. Forecasting is the process of making statements about events whose actual outcomes (typically) have not yet been observed. A commonplace example might be estimation of the expected value for some variable of interest at some specified future date. Prediction is a similar, but more general term. Both might refer to formal statistical methods employing time series, cross-sectional or longitudinal data, or alternatively to less formal judgemental methods. Usage can differ between areas of application: for example in hydrology, the terms "forecast" and "forecasting" are sometimes reserved for estimates of values at certain specific future times, while the term "prediction" is used for more general estimates, such as the number of times floods will occur over a long period. Risk and uncertainty are central to forecasting and prediction; it is generally considered good practice to indicate the degree of uncertainty attaching to forecasts. The process of climate change and increasing energy prices has led to the usage of Egain Forecasting of buildings. The method uses Forecasting to reduce the energy needed to heat the building, thus reducing the emission of greenhouse gases. Forecasting is used in the practice of Customer Demand Planning in every day business forecasting for manufacturing companies. The discipline of demand planning, also sometimes referred to as supply chain forecasting, embraces...

Words: 3665 - Pages: 15

Activity 3.6 Group Case Study: Forecasting Monthly Sales

...plan to bring them closer to their dream. They decided to sell The Glass Slipper and open a bed and breakfast on a beautiful beach in Mexico. While this would mean that work was still in their future, they could wake up in the morning to the sight of the palm trees blowing in the wind and the waves lapping at the shore. They also knew that hiring the right manager would allow James and Deena the time to begin a semi-retirement in a corner of paradise. To make this happen, James and Deena would have to sell The Glass Slipper for the right price. The price of the business would be based on the value of the property and equipment, as well as projections of future income. A forecast of sales for the next year is needed to help in the determination of the value of the restaurant. Monthly sales for each of the past 3 years are provided in the table below....

Words: 364 - Pages: 2

Forecasting

...4/13/2015 Forecasting ­ Research Papers ­ Hapikampr Login Join The Research Paper Factory Join Search Browse Saved Papers Search over 100,000 Essays Home Page  »  Business and Management Forecasting In: Business and Management Forecasting Forecasting HSM/260 University of Phoenix 06/20/2013 Exercise 9.1 The following data represent total personnel expenses for the Palmdale Human Service Agency for past four fiscal years: 20X1 $5,250,000 20X2 $5,500,000 20X3 $6,000,000 20X4 $6,750,000 Forecast personnel expenses for fiscal year 20X5 using moving averages, weighted moving averages, exponential smoothing, and time series regression. For moving averages and weighted moving averages, use only the data for the past three fiscal years. For weighted moving averages, assign a value of 1 to the data for 20X2, a value of 2 to the data for 20X3, and a value of 3 to the data for 20X4. For exponential smoothing, assume that the last forecast for fiscal year 20X4 was $6,300,000. You decide on the alpha to be used for exponential smoothing. For time series regression, use the data for all four fiscal years. Which forecast will you use? Why                         Moving Averages Fiscal Year                           Expenses          Please login to view the full essay... Essay's Statistics Submitted by: hapikampr Date shared: 08/07/2013 10:35 AM Words: 707 Pages: 3 20X2                                     $ 5,500,000           ......

Words: 400 - Pages: 2

Texas State Sales Tax Forecasting

...MBA 643-17 April - May 2015 Problem-Solving Skills Assignment One Texas State sales Tax Forecasting Due Date May 22, 2015 A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are compiled and the state controller uses them to project future revenues for the state budget. One particular category of goods is classified as Retail Trade. Four years of quarterly data (in millions) for one particular area of southeast Texas follows. Quarter | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4 | 1 | 218 | 225 | 234 | 250 | 2 | 247 | 254 | 265 | 283 | 3 | 245 | 255 | 264 | 289 | 4 | 292 | 299 | 327 | 356 | 1. Compute seasonal indices for each quarter for year 5 based on CMA. Seasonal indices can be calculated using this formula: (sum of average value for Qx divided by number of data). Therefore seasonal indices for quarters in year five will be: Q1 = (88.148 + 88.51 + 87.98)/3 = 88.21% Q2 = (98.68 + 98.51 + 97.29)/3 = 98.16% Q3 = (97.46 + 98.31 + 96.17)/3 = 97.31% Q4 = (115.35 + 114.17 + 117.30)/3 = 115.6% 2. Deseasonalize the data and develop a trend line of the deseasonalized data. Quarter | Sales | Index | Deseasonalised data | 1 | 218 | 0.8821 | 247.1 | 2 | 247 | 0.9816 | 251.6 | 3 | 245 | 0.9716 | 252.2 | 4 | 292 | 1.1561 | 252.6 | 5 | 225 | 0.8821 | 255.1 | 6 | 254 | 0.9816 | 258.8 | 7 | 255 | 0.9716 | 262.5 | 8 | 299 | 1.1561 | 258.6 | 9 | 234 | 0.8821 | 265.3 | 10 | 265 | 0.9816 |......

Words: 584 - Pages: 3

Forecasting

...Forecasting Accurate forecasting was the key element for our company’s success. We were able to forecast the demand and avoid overproduction. Even though all our products were stocked out at the end of the year, we did not lose much sales because the forecast was accurate and our plant utilization was maximized to the complete second shift. The pricing of the products was another major factor for our forecasting. We priced our products by looking at our sales revenue, income statement, R&D spending and the competition in each segment. Our product Cake for example, was dominating the traditional segment in the last few years. We sold almost 4000 units in 2016. We could use the revenue that generated from sales and spend portion of it on R&D. Since this product was dominating the segment and high awareness, we believe we could receive more sales if we increase the price. At the end of 2007, we sold 500 more units than the year before. However, we decreased the price of our products that are in more competitive markets. In the high end segment, we spent more R&D cost on Cid and Cid2. Cid was the segment leader, and we tried to make Cid2 a close competitor within the company. We also decreased the price since the competitors had listed lower prices for their products. By doing that, we gained more customers awareness and helped us gain more sales. When we make decision for unit sales forecast, we looked for the growth rate in each segment. This number shows......

Words: 436 - Pages: 2

Logistics Management - the Issues Involved in the Case Are Sales Forecasting, Strategic Sourcing, Selection

... What made SCL a leader in the logistics industry? Q2. Discuss the strategies adopted by SCL for its survival in the competitive scenario. Q3. Comment on the contributions of SCL to society. Q4. What steps the company should take to globalize its network reach? Q5. Discuss the strategies adopted by SCL for expansion. Q1. Analyze the case in view of the logistics outsourcing practices of the ISL. Q2. Discuss the importance of logistics outsourcing with reference to supply chain management. Q3. Suggest strategies for further strengthening the supply chain of ISL. Q4. The participants/students are expected to have a clear understanding of Supply Chain and Logistics Management concepts. Q5. The issues involved in the case are Sales Forecasting, Strategic Sourcing, Selection of Warehousing Service Provider, Transportation Mode and other nuances in Logistics Management. Need Answer Sheet of this Question paper, contact aravind.banakar@gmail.com www.mbacasestudyanswers.com ARAVIND – 09901366442 – 09902787224...

Words: 250 - Pages: 1