Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Forecasts are usually classified by time horizon into which three categories?

21/12/2020 Client: saad24vbs Deadline: 3 days

Statistics, Data Analysis, and Decision Modeling


FOURTH EDITION


James R. Evans


9780558689766


Chapter 7 Forecasting


Introduction


QUALITATIVE AND JUDGMENTAL METHODS


Historical Analogy


The Delphi Method


Indicators and Indexes for Forecasting


STATISTICAL FORECASTING MODELS


FORECASTING MODELS FOR STATIONARY TIME SERIES


Moving Average Models


Error Metrics and Forecast Accuracy


Exponential Smoothing Models


FORECASTING MODELS FOR TIME SERIES WITH TREND AND SEASONALITY


Models for Linear Trends


Models for Seasonality


Models for Trend and Seasonality


CHOOSING AND OPTIMIZING FORECASTING MODELS USING CB PREDICTOR


REGRESSION MODELS FOR FORECASTING


Autoregressive Forecasting Models


Incorporating Seasonality in Regression Models


Regression Forecasting with Causal Variables


THE PRACTICE OF FORECASTING


BASIC CONCEPTS REVIEW QUESTIONS


SKILL-BUILDING EXERCISES


SKILL-BUILDING EXERCISES


PROBLEMS AND APPLICATIONS


CASE: ENERGY FORECASTING


APPENDIX: ADVANCED FORECASTING MODELS—THEORY AND COMPUTATION


Double Moving Average


Double Exponential Smoothing


Additive Seasonality


Multiplicative Seasonality


Holt–Winters Additive Model


Holt– –Winters Multiplicative Model


INTRODUCTION


One of the major problems that managers face is forecasting future events in order to make good decisions. For example, forecasts of interest rates, energy prices, and other economic indicators are needed for financial planning; sales forecasts are needed to plan production and workforce capacity; and forecasts of trends in demographics, consumer behavior, and technological innovation are needed for long-term strategic planning. The government also invests significant resources on predicting short-run U.S. business performance using the Index of Leading Indicators. This index focuses on the performance of individual businesses, which often is highly correlated with the performance of the overall economy, and is used to forecast economic trends for the nation as a whole. In this chapter, we introduce some common methods and approaches to forecasting, including both qualitative and quantitative techniques.


Managers may choose from a wide range of forecasting techniques. Selecting the appropriate method depends on the characteristics of the forecasting problem, such as the time horizon of the variable being forecast, as well as available information on which the forecast will be based. Three major categories of forecasting approaches are qualitative and judgmental techniques, statistical time-series models, and explanatory/causal methods.


Qualitative and judgmental techniques rely on experience and intuition; they are necessary when historical data are not available or when the decision maker needs to forecast far into the future. For example, a forecast of when the next generation of a microprocessor will be available and what capabilities it might have will depend greatly on the opinions and expertise of individuals who understand the technology.


Statistical time-series models find greater applicability for short-range forecasting problems. A time series is a stream of historical data, such as weekly sales. Time-series models assume that whatever forces have influenced sales in the recent past will continue into the near future; thus, forecasts are developed by extrapolating these data into the future.


Explanatory/causal models seek to identify factors that explain statistically the patterns observed in the variable being forecast, usually with regression analysis. While time-series models use only time as the independent variable, explanatory/causal models generally include other factors. For example, forecasting the price of oil might incorporate independent variables such as the demand for oil (measured in barrels), the proportion of oil stock generated by OPEC countries, and tax rates. Although we can never prove that changes in these variables actually cause changes in the price of oil, we often have evidence that a strong influence exists.


Surveys of forecasting practices have shown that both judgmental and quantitative methods are used for forecasting sales of product lines or product families, as well as for broad company and industry forecasts. Simple time-series models are used for short- and medium-range forecasts, whereas regression analysis is the most popular method for long-range forecasting. However, many companies rely on judgmental methods far more than quantitative methods, and almost half judgmentally adjust quantitative forecasts.


In this chapter, we focus on these three approaches to forecasting. Specifically, we will discuss the following:


Historical analogy and the Delphi method as approaches to judgmental forecasting


Moving average and exponential smoothing models for time-series forecasting, with a discussion of evaluating the quality of forecasts


A brief discussion of advanced time-series models and the use of Crystal Ball (CB) Predictor for optimizing forecasts


The use of regression models for explanatory/causal forecasting


Some insights into practical issues associated with forecasting


Qualitative and Judgmental Methods


Qualitative, or judgmental, forecasting methods are valuable in situations for which no historical data are available or for those that specifically require human expertise and knowledge. One example might be identifying future opportunities and threats as part of a SWOT (Strengths, Weaknesses, Opportunities, and Threats) analysis within a strategic planning exercise. Another use of judgmental methods is to incorporate nonquantitative information, such as the impact of government regulations or competitor behavior, in a quantitative forecast. Judgmental techniques range from such simple methods as a manager’s opinion or a group-based jury of executive opinion to more structured approaches such as historical analogy and the Delphi method.


Historical Analogy


One judgmental approach is historical analogy, in which a forecast is obtained through a comparative analysis with a previous situation. For example, if a new product is being introduced, the response of similar previous products to marketing campaigns can be used as a basis to predict how the new marketing campaign might fare. Of course, temporal changes or other unique factors might not be fully considered in such an approach. However, a great deal of insight can often be gained through an analysis of past experiences. For example, in early 1998, the price of oil was about $22 a barrel. However, in mid-1998, the price of a barrel of oil dropped to around $11. The reasons for this price drop included an oversupply of oil from new production in the Caspian Sea region, high production in non-OPEC regions, and lower-than-normal demand. In similar circumstances in the past, OPEC would meet and take action to raise the price of oil. Thus, from historical analogy, we might forecast a rise in the price of oil. OPEC members did in fact meet in mid-1998 and agreed to cut their production, but nobody believed that they would actually cooperate effectively, and the price continued to drop for a time. Subsequently, in 2000, the price of oil rose dramatically, falling again in late 2001. Analogies often provide good forecasts, but you need to be careful to recognize new or different circumstances. Another analogy is international conflict relative to the price of oil. Should war break out, the price would be expected to rise, analogous to what it has done in the past.


The Delphi Method


A popular judgmental forecasting approach, called the Delphi method, uses a panel of experts, whose identities are typically kept confidential from one another, to respond to a sequence of questionnaires. After each round of responses, individual opinions, edited to ensure anonymity, are shared, allowing each to see what the other experts think. Seeing other experts’ opinions helps to reinforce those in agreement and to influence those who did not agree to possibly consider other factors. In the next round, the experts revise their estimates, and the process is repeated, usually for no more than two or three rounds. The Delphi method promotes unbiased exchanges of ideas and discussion and usually results in some convergence of opinion. It is one of the better approaches to forecasting long-range trends and impacts.


Indicators and Indexes for Forecasting


Bottom of Form


Indicators and indexes generally play an important role in developing judgmental forecasts. Indicators are measures that are believed to influence the behavior of a variable we wish to forecast. By monitoring changes in indicators, we expect to gain insight about the future behavior of the variable to help forecast the future. For example, one variable that is important to the nation’s economy is the Gross Domestic Product (GDP), which is a measure of the value of all goods and services produced in the United States. Despite its shortcomings (for instance, unpaid work such as housekeeping and child care is not measured; production of poor-quality output inflates the measure, as does work expended on corrective action), it is a practical and useful measure of economic performance. Like most time series, the GDP rises and falls in a cyclical fashion. Predicting future trends in the GDP is often done by analyzing leading indicators—series that tend to rise and fall some predictable length of time prior to the peaks and valleys of the GDP. One example of a leading indicator is the formation of business enterprises; as the rate of new businesses grows, one would expect the GDP to increase in the future. Other examples of leading indicators are the percent change in the money supply (M1) and net change in business loans. Other indicators, called lagging indicators, tend to have peaks and valleys that follow those of the GDP. Some lagging indicators are the Consumer Price Index, prime rate, business investment expenditures, or inventories on hand. The GDP can be used to predict future trends in these indicators.


Indicators are often combined quantitatively into an index. The direction of movement of all the selected indicators are weighted and combined, providing an index of overall expectation. For example, financial analysts use the Dow Jones Industrial Average as an index of general stock market performance. Indexes do not provide a complete forecast, but rather a better picture of direction of change, and thus play an important role in judgmental forecasting.


The Department of Commerce began an Index of Leading Indicators to help predict future economic performance. Components of the index include the following:


•average weekly hours, manufacturing


•average weekly initial claims, unemployment insurance


•new orders, consumer goods and materials


•vendor performance—slower deliveries


•new orders, nondefense capital goods


•building permits, private housing


•stock prices, 500 common stocks (Standard & Poor)


•money supply


•interest rate spread


•index of consumer


•average weekly hours, manufacturing


•average weekly initial claims, unemployment insurance


•new orders, consumer goods and materials


•vendor performance—slower deliveries


•new orders, nondefense capital goods


•building permits, private housing


•stock prices, 500 common stocks (Standard & Poor)


•money supply


•interest rate spread


•index of consumer expectations (University of Michigan)


Business Conditions Digest included more than 100 time series in seven economic areas. This publication was discontinued in March 1990, but information related to the Index of Leading Indicators was continued in Survey of Current Business. In December 1995, the U.S. Department of Commerce sold this data source to The Conference Board, which now markets the information under the title Business Cycle Indicators; information can be obtained at its Web site (www.conference-board.org). The site includes excellent current information about the calculation of the index, as well as its current components.


Statistical Forecasting Models


Many forecasts are based on analysis of historical time-series data and are predicated on the assumption that the future is an extrapolation of the past. We will assume that a time series consists of T periods of data, At, = 1, 2, …, T. A naive approach is to eyeball a trend—a gradual shift in the value of the time series—by visually examining a plot of the data. For instance, Figure 7.1 shows a chart of total energy production from the data in the Excel file Energy Production & Consumption. We see that energy production was rising quite rapidly during the 1960s; however, the slope appears to have decreased after 1970. It appears that production is increasing by about 500,000 each year and that this can provide a reasonable forecast provided that the trend continues.


Figure 7.1 Total Energy Production Time Series


Figure 7.2 Federal Funds Rate Time Series


Time series may also exhibit short-term seasonal effects (over a year, month, week, or even a day) as well as longer-term cyclical effects or nonlinear trends. At a neighborhood grocery store, for instance, short-term seasonal patterns may occur over a week, with the heaviest volume of customers on weekends, and even during the course of a day. Cycles relate to much longer-term behavior, such as periods of inflation and recession or bull and bear stock market behavior. Figure 7.2 shows a chart of the data in the Excel file Federal Funds Rate. We see some evidence of long-term cycles in the time series.


Of course, unscientific approaches such as the “eyeball method” may be a bit unsettling to a manager making important decisions. Subtle effects and interactions of seasonal and cyclical factors may not be evident from simple visual extrapolation of data. Statistical methods, which involve more formal analyses of time series, are invaluable in developing good forecasts. A variety of statistically based forecasting methods for time series are commonly used. Among the most popular are moving average methods, exponential smoothing, and regression analysis. These can be implemented very easily on a spreadsheet using basic functions available in Microsoft Excel and its Data Analysis tools; these are summarized in Table 7.1. Moving average and exponential smoothing models work best for stationary time series. For time series that involve trends and/or seasonal factors, other techniques have been developed. These include double moving average and exponential smoothing models, seasonal additive and multiplicative models, and Holt–Winters additive and multiplicative models . We will review each of these types of models. This book provides an Excel add-in, CB Predictor, that applies these methods and incorporates some intelligent technology. We will describe CB Predictor later in this chapter.


Table 7.1 Excel Support for Forecasting


Excel Functions Description


TREND (known_y’s, known_x’s, new_x’s, constant)


Returns values along a linear trend line


LINEST(known_y’s, known_x’s, new_x’s, constant, stats)


Returns an array that describes a straight line that best fits the data


FORECAST(x, known_y’s, known_x’s)


Calculates a future value along a linear trend


Analysis Toolpak


Description


Moving average Projects forecast values based on the


average value of the variable over a specific number of preceding periods


Exponential smoothing Predicts a value based on the forecast for the


prior period, adjusted for the error in that prior forecast


Regression Used to develop a model relating time-series data to a set of


variables assumed to influence the data


Forecasting Models for Stationary Time Series


Two simple approaches that are useful over short time periods when trend, seasonal, or cyclical effects are not significant are moving average and exponential smoothing models.


Moving Average Models


The simple moving average method is based on the idea of averaging random fluctuations in the time series to identify the underlying direction in which the time series is changing. Because the moving average method assumes that future observations will be similar to the recent past, it is most useful as a short-range forecasting method. Although this method is very simple, it has proven to be quite useful in stable environments, such as inventory management, in which it is necessary to develop forecasts for a large number of items.


Specifically, the simple moving average forecast for the next period is computed as the average of the most recent k observations. The value of k is somewhat arbitrary, although its choice affects the accuracy of the forecast. The larger the value of k, the more the current forecast is dependent on older data; the smaller the value of k, the quicker the forecast responds to changes in the time series. (In the next section, we discuss how to select k by examining errors associated with different values.)


For instance, suppose that we want to forecast monthly burglaries from the Excel file Burglaries since the citizen-police program began. Figure 7.3 shows a chart of these data. The time series appears to be relatively stable, without trend, seasonal, or cyclical effects; thus, a moving average model would be appropriate. Setting k = 3, the three-period moving average forecast for month 59 is:


Moving average forecasts can be generated easily on a spreadsheet. Figure 7.4 shows the computations for a three-period moving average forecast of burglaries. Figure 7.5 shows a chart that contrasts the data with the forecasted values. Moving average forecasts can also be obtained from Excel’s Data Analysis options (see Excel Note: Forecasting with Moving Averages).


Figure 7.3 Monthly Burglaries Chart


In the simple moving average approach, the data are weighted equally. This may not be desirable because we might wish to put more weight on recent observations than on older observations, particularly if the time series is changing rapidly. Such models are called weighted moving averages. For example, you might assign a 60% weight to the most recent observation, 30% to the second most recent observation, and the remaining 10% of the weight to the third most recent observation. In this case, the three-period weighted moving average forecast for month 59 would be:


EXCEL NOTE Forecasting with Moving Averages


From the Analysis group, select Data Analysis then Moving Average. Excel displays the dialog box shown in Figure 7.6. You need to enter the Input Range of the data, the Interval (the value of k), and the first cell of the Output Range. To align the actual data with the forecasted values in the worksheet, select the first cell of the Output Range to be one row below the first value. You may also obtain a chart of the data and the moving averages, as well as a column of standard errors, by checking the appropriate boxes. However, we do not recommend using the chart or error options because the forecasts generated by this tool are not properly aligned with the data (the forecast value aligned with a particular data point represents the forecast for the next month) and, thus, can be misleading. Rather, we recommend that you generate your own chart as we did in Figure 7.5. Figure 7.7 shows the results produced by the Moving Average tool (with some customization of the forecast chart to show the months on the x-axis). Note that the forecast for month 59 is aligned with the actual value for month 58 on the chart. Compare this to Figure 7.5 and you can see the difference.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

University Coursework Help
Homework Guru
Helping Hand
Top Essay Tutor
Writer Writer Name Offer Chat
University Coursework Help

ONLINE

University Coursework Help

Hi dear, I am ready to do your homework in a reasonable price.

$62 Chat With Writer
Homework Guru

ONLINE

Homework Guru

Hi dear, I am ready to do your homework in a reasonable price and in a timely manner.

$62 Chat With Writer
Helping Hand

ONLINE

Helping Hand

I am an Academic writer with 10 years of experience. As an Academic writer, my aim is to generate unique content without Plagiarism as per the client’s requirements.

$60 Chat With Writer
Top Essay Tutor

ONLINE

Top Essay Tutor

I have more than 12 years of experience in managing online classes, exams, and quizzes on different websites like; Connect, McGraw-Hill, and Blackboard. I always provide a guarantee to my clients for their grades.

$65 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

South cheshire private hospital - Fiona looney irish daily mail - Sqa higher music concepts - BIO - Testout power supply lab - Percent relative average deviation - Bni referral slip education - Transition to the Nursing profession - Assignment - Bada bing bail bonds brownsville tx - MHA500 MOD 4 - In marketing, advertisements or salespeople can activate a consumer's purchase decision process by - Pedagogy of the oppressed chapter 2 - How many cm in 1 km - Monty python and the holy grail latin - Which one of the following statements is incorrect - Port pirie court case list - Ge india industrial private limited - Carrier network service tool windows 10 - Acute red eye ppt - Teuer furniture a case solution - Clayton hotel zhengzhou standard - Ge lighting control relay panel - Maternity case studies for nursing students - Center of pressure fluid mechanics lab report - Amazon global sourcing and procurement - Hank williams the third three shades of black - Cloud computing concepts technology & architecture - Discussion - Shmoop dulce et decorum est - Of mice and men ppt - Robert arias recently inherited a stock portfolio - Discuss - Aqa gcse english literature controlled assessment - Myob accounting plus v11 download - How to draw an indifference curve - 2006 crf250x oil capacity - Iosr journal of applied chemistry - Http www facebook com help contact php show_form delete_account 60 - University of virginia health system case study solution - Stat 101 worksheet confidence intervals answers - Rigorous two phase locking - Http psychology about com od apastyle a apageneral htm - After watching the video clip, answer the following questions: - Trouble in the truss construction shop critical thinking - Current Article Analysis 1 - Andrew chinn tell the good news - Comm skills for criminal justice week 5 discussion - Mkt 100 assignment 2 situation analysis - Modified monash model map wa - Armstrong feather edge skirting - Nursing - Long forest nature conservation reserve - Competitive profile matrix example - What does the ghost of banquo represent - Active harmonic filter price list - Apa project management - Lifespan development john santrock 16th edition - Theoretical framework in research example - Mark 8 29 worksheet gcu - Moreton bay council pd online - Biology microscope lab letter e answers - Allianz oshc claim online - 5/1 - Program Reflection 2 - The rush to crack the internet spy network worksheet answers - Task dimensions job analysis - Target brand proactiv - Acs professional code of ethics - Adhd 2 - Becoming Deviant - Mysterious stone monument in georgia - Case study 2 - Faceit anti cheat internal error 225 - Negotiation lewicki 6th edition pdf - Hcf starter extras with optical - Corporal punishment in queensland schools - A juggler performs in a room whose ceiling is - Goal setting by margaret hockett answers - Essay - 2d nand vs 3d nand performance - Susan cain ted talk introverts - Accounting cycle problems and solutions - Comparative language analysis essay example - TEACHING STRATEGIES FOR DIVERSE LEARNERS ESSAY INSTRUCTIONS - Oxford wordlist 1 100 - Introducingnt com - City of monroe continuous problem solution - Gender schema theory psychology - Cost accounting 14th edition - Week 6 ass - Secret knock detecting door lock ppt - Logistics management assignment - 02.03 the anti federalists assessment - Discussion - Compensation management system in multinational companies - A midsummer night's dream project - Economics Class Due Today - Quiz - Centurylink communications llc voip