Forecasting Using Indices

In: Business and Management

Submitted By texanbrat
Words 592
Pages 3
Forecasting Using Indices
Tricia Thedford
QRB 501/Quantitative Reasoning for Business
March 4, 2012
Vinata Kulkarni, PhD

Forecasting using indices
Forecasting is an integral part of business. Forecasting allows investors to see anticipated growth/decline in a business. An accurate forecast will also allow a business to respond appropriately should a problem be evident in the desired business plan. Forecasting can be done on all data within a financial statement or can target specific areas, depending on the information desired. Investors as well as business executives have a need to see where a company is headed when making future business decisions.
The dictionary defines the word forecast as “to anticipate, calculate, or predict (some future event or condition) usually as a result of rational study and analysis of available pertinent data” (Merriam-Webster, Inc., 2002, para 2). One should review all data available for making an accurate business forecast. In researching Dell, Inc., inventory history the following data was obtained:

Dell, Inc. historical inventories data | 2011 | 2010 | Period | Amount | Period | Amount | October 31 | 1.40 billion | October 31 | 1.29 billion | July 31 | 1.35 billion | July 31 | 1.37 billion | April 30 | 1.28 billion | April 30 | 1.18 billion | January 31 | 1.30 billion | January 31 | 1.05 billion | 2009 | 2008 | Period | Amount | Period | Amount | October 31 | 952 million | October 31 | 1.11 billion | July 31 | 839 million | July 31 | 1.10 billion | April 30 | 842 million | April 30 | 1.26 billion | January 31 | 867 million | January 31 | 1.10 billion |

Note. Table adapted from data provided by YCharts, copyright 2012.

Using the data above the method of forecasting was to take the average for each period and find the percentage of growth/decline. The percentage multiplied against the…...

Similar Documents


...periodic, FIFO, LIFO) Collect four years of inventory data from each organization. If you are not abel to find data, you may also use the University of Phoenix Material: Summer Historical Inventory Data or University of Phoenix Material: Winter Historical Inventory Data. Collaborate as a team to compare the inventory systems. Write a summary which includes: • 250- to 350-word description of each inventory system. • 350- to 700-word comparison describing the advantages and disadvantages of each system. Format your summary consistent with APA guidelines. 04/23/2013 5 Week Three: Visual Representation of Quantities Details Due Points Objectives 3.1 Construct histograms and bivariate plots. 3.2 Determine the value of a slope by using the slope-intercept formula. 3.3 Conduct a linear regression analysis. 04/30/2013 N/A Readings Read Ch. 6 & 9 of Quantitative Reasoning for Business. Read Topics 2–3 & 5 of Quantitative Reasoning. 04/30/2013 N/A In-Class Exercises 1. In-Class Team Exercise There will be an In-Class graded Team Exercise in this course, usually during the first hour of the class session when we do a Team Exercise/Team Activity that will help you understand the objectives of the weekly material. For example, article discussion, or discussion about your professional experience to apply concepts in this course. The exercise will not be given in advance, it will be provided to you in class. 2. In-Class Individual Exercise There will be an In-Class......

Words: 534 - Pages: 3


...Forecasting Methods Genius forecasting - This method is based on a combination of intuition, insight, and luck. Psychics and crystal ball readers are the most extreme case of genius forecasting. Their forecasts are based exclusively on intuition. Science fiction writers have sometimes described new technologies with uncanny accuracy. There are many examples where men and women have been remarkable successful at predicting the future. There are also many examples of wrong forecasts. The weakness in genius forecasting is that its impossible to recognize a good forecast until the forecast has come to pass. Some psychic individuals are capable of producing consistently accurate forecasts. Mainstream science generally ignores this fact because the implications are simply to difficult to accept. Our current understanding of reality is not adequate to explain this phenomena. Trend extrapolation - These methods examine trends and cycles in historical data, and then use mathematical techniques to extrapolate to the future. The assumption of all these techniques is that the forces responsible for creating the past, will continue to operate in the future. This is often a valid assumption when forecasting short term horizons, but it falls short when creating medium and long term forecasts. The further out we attempt to forecast, the less certain we become of the forecast. The stability of the environment is the key factor in determining whether trend extrapolation is an appropriate......

Words: 1639 - Pages: 7


...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 20X2 $ 5,500,000 20X3 6,000,000 20X4 6,750,000 20X2-X4 6,083,333 20X5 6,083,333 = $2,277,776 3 I followed Rule 3. Older data are less important than more recent data. I decided to only go back three years so I......

Words: 707 - Pages: 3


...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

Forecasting Gold Prices Using Multiple Linear Regression Method

...Forecasting Gold Prices Using Multiple Linear Regression Method Z. Ismail, 2A. Yahya and 1A. Shabri Department of Mathematics, Faculty of Science 2 Department of Basic Education, Faculty of Education University Technology Malaysia, 81310 Skudai, Johor Malaysia 1 1 Abstract: Problem statement: Forecasting is a function in management to assist decision making. It is also described as the process of estimation in unknown future situations. In a more general term it is commonly known as prediction which refers to estimation of time series or longitudinal type data. Gold is a precious yellow commodity once used as money. It was made illegal in USA 41 years ago, but is now once again accepted as a potential currency. The demand for this commodity is on the rise. Approach: Objective of this study was to develop a forecasting model for predicting gold prices based on economic factors such as inflation, currency price movements and others. Following the melt-down of US dollars, investors are putting their money into gold because gold plays an important role as a stabilizing influence for investment portfolios. Due to the increase in demand for gold in Malaysian and other parts of the world, it is necessary to develop a model that reflects the structure and pattern of gold market and forecast movement of gold price. The most appropriate approach to the understanding of gold prices is the Multiple Linear Regression (MLR) model. MLR is a study on the relationship between a single......

Words: 3920 - Pages: 16

Forecasting with Indices

...Forecasting with Indices Forecasting is a tool that a company can use to predict trends or patterns based on the data available from previous years, quarters or periods. Forecasting can assist a company with a wealth of information, such as where cuts need to be made, where increases need to be made. Forecasting can even aid a company with what product to carry or discontinue and when would be a good time for a sale. Calculating Averages Taking the monthly sales for the last four years of Honda’s sales, the author entered this information into Excel, and formulated this chart: | Year | Year | Year | Year | average by month | Month | 1 | 2 | 3 | 4 | monthly index | 1 | 98,511 | 71,031 | 67,479 | 76,269 | 78,323 | 2 | 115,397 | 71,575 | 80,671 | 98,059 | 91,426 | 3 | 138,734 | 88,379 | 108,262 | 133,650 | 117,256 | 4 | 135,180 | 101,129 | 113,697 | 124,799 | 118,701 | 5 | 167,997 | 98,344 | 117,173 | 90,773 | 118,572 | 6 | 142,539 | 100,420 | 106,627 | 83,892 | 108,370 | 7 | 138,744 | 114,690 | 112,437 | 80,502 | 111,593 | 8 | 146,855 | 161,439 | 108,729 | 82,321 | 124,836 | 9 | 96,626 | 77,229 | 97,361 | 89,532 | 90,187 | 10 | 85,864 | 85,502 | 98,811 | 98,333 | 92,128 | 11 |......

Words: 746 - Pages: 3

Forecasting the Quarterly Rice Production in the Province of Iloilo Using Different Forecasting Models

...alive; as mentioned above, it is the food for survival, so just an inkling of inadequacy means a bigger problem of scarcity. Thus, this paper focuses on forecasting the quarterly production of palay in Iloilo Province with the use of some forecasting techniques. While it may be easier to estimate production by the use of personal judgment, yet it is more accurate to apply these forecasting techniques. Forecasting production is a critical subject to endure, since a slight decline or lowering steadily suggests an imperative move to review all the inherent deficiencies occurring as to why such happens. Moreover, this paper also addresses the question on the sufficiency of palay to compete with the swelling population of the province because from these forecasted figures, the Iloilo government can heighten their awareness on the issue and eventually make the appropriate actions. Variables used in this paper involves the actual quarterly palay production for 10 years starting from the first quarter of 2004. So, overall there is a total of 40 periods incorporated in this paper. Throughout this study, palay pertains to rice as well as rice refers to palay. CHAPTER II Objectives of the Study Generally, this study aims to determine the quarterly rice production in the Province of Iloilo from 2004 to 2013 using different forecasting techniques. Iloilo, being one of the country's top ten achievers in rice production (SunStar, 2012) and with its promising export-potential......

Words: 8603 - Pages: 35


...347 units. d. Develop a trend line for the demand for fertilizer using any computer software. e. You have now developed three different forecasts. These are a 3-year moving average, a weighted moving average, and a trend line. Which one would you use? Explain your answer. By observing the MAD in part (d), it can be observed that the value is the smallest among the 3 methods, hence I will choose the trend line as the forecast predicted is more accurate. Moreover the demand for the future can also be seen. 3-2 Sales of Cool-Man air conditioners have grown steadily during the past 5 years: Year Sales 1 440 2 465 3 520 4 573 5 586 6 ? The sales manager had predicted, before the business started, that year 1’s sales would be 410 air conditioners. a. Using exponential smoothing with a weights of a = 0.30, 0.60, and 0.90 develop forecasts for years 2 through 6. b. What effect did the smoothing constant have on the forecasts for Cool-Man air conditioners? As the smoothing constant move towards 1, the MAD between the data and forecast decreases enhancing the accuracy of the forecast predicted from 74.014 (a = 0.30), to 52.618 (a = 0.60), to 38.692 (a = 0.90). c. Which smoothing constant gives the most accurate forecast? By utilizing the smoothing constant of .90, it provides the most accurate forecast. d. Use a three-year moving average forecasting model to forecast the sales of Cool-Man air conditioners. e.......

Words: 837 - Pages: 4


...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

Forecasting Indices

...Forecasting with Indices Christopher L Kearney University of Phoenix QRB/501 Quantitative Reasoning for Business Maryam Boluri May 2, 2011 Forecasting with Indices This writer will begin by defining forecast and index while detailing the importance of both as they relate to the makeup of any company. This type of data can be financial or non-financial depending on what the company offers. Forecasting is a method used by companies to predict current and future trends. Many companies have realized this to be the backbone of the company because it predicts whether or not a company will break even and if a company does not break even decided whether the company will be up and running the following year. An index is a point of reference concerning numbers with common points. Indices are used to observe historical and short-term comparisons with percentages change commonly used. This week’s lesson entailed obtaining the Summer Historical Inventory Data from the materials area in the week two forum and converting the information into an index. The time series information is to be used to forecast the inventory needed for the upcoming year. To give a company a better view of making decision a month-to-month forecast is best because more information can be obtained over a shorter period. The Summer Historical Data obtained from University of Phoenix Material was converted into an index using Microsoft excel software. The data showed typical demand for summer highs......

Words: 489 - Pages: 2

Forecasting Significant Societal Events Using the Embers Streaming Predictive Analytics System

...ORIGINAL RESEARCH FORECASTING SIGNIFICANT SOCIETAL EVENTS USING THE EMBERS STREAMING PREDICTIVE ANALYTICS SYSTEM Andy Doyle,1 Graham Katz,1 Kristen Summers,1 Chris Ackermann,1 Ilya Zavorin,1 Zunsik Lim,1 Sathappan Muthiah,2 Patrick Butler,2 Nathan Self,2 Liang Zhao,2 Chang-Tien Lu,2 Rupinder Paul Khandpur,2 Youssef Fayed,3 and Naren Ramakrishnan2 Abstract Developed under the Intelligence Advanced Research Project Activity Open Source Indicators program, Early Model Based Event Recognition using Surrogates (EMBERS) is a large-scale big data analytics system for forecasting significant societal events, such as civil unrest events on the basis of continuous, automated analysis of large volumes of publicly available data. It has been operational since November 2012 and delivers approximately 50 predictions each day for countries of Latin America. EMBERS is built on a streaming, scalable, loosely coupled, shared-nothing architecture using ZeroMQ as its messaging backbone and JSON as its wire data format. It is deployed on Amazon Web Services using an entirely automated deployment process. We describe the architecture of the system, some of the design tradeoffs encountered during development, and specifics of the machine learning models underlying EMBERS. We also present a detailed prospective evaluation of EMBERS in forecasting significant societal events in the past 2 years. Introduction Anticipatory intelligence is considered to be one of the next......

Words: 6442 - Pages: 26

Forcasting and Indices

...Forecasting and Indices Forecasting is a process in which statements or conclusions are made regarding the outcome of events that have not yet happened. Forecasting is predicting what the could look like. There are many examples of forecasting. Estimating or predicting can be referred to as formal statistical methods that employ time series, cross-sectional or longitudinal data. Forecasting can be use to estimate a wide variety of issues, weather related events, the use of resources, sales, profit or loss and even staffing needs for a particular project. Coupling these findings with good planning can give a company a good indication of what the future should look like. Forecasting can use many different methods. Evaluating your objectives and conditions relevant to the individual situations can help in choosing the correct method to use. Another option is to use several methods and compare or combine the results, as many times, there is no one “best” method. “The forecast error is the difference between the actual value and the forecast value for the corresponding period. where E is the forecast error at period t, Y is the actual value at period t, and F is the forecast for period t. Measures of aggregate error: Mean absolute error (MAE) Mean Absolute Percentage Error (MAPE) Mean Absolute Deviation (MAD) Percent Mean Absolute Deviation (PMAD) Mean squared error (MSE) Root Mean squared error (RMSE) Forecast skill (SS) Average of Errors......

Words: 352 - Pages: 2

Forecasting with Time Series

...Forecasting with Time Series QRB/501 Quantitative Reasoning for Business February 7, 2012 Forecasting with Time Series For most companies, forecasting is very important. Their future can be determined with forecasting and this also helps pin point the problems of the past. Forecasting can be done in many methods, depending on what exactly is being forecasted. A forecasting tool used to determine demand for various commodities or goods in a given marketplace over the course of a typical year (or a shorter time period). Such an index is based on data from previous years that highlights seasonal differences in consumption. In some industries, the seasonality index experiences huge swings. (Business Dictionary, 2012) This forecasting tool is known as seasonal indexing. Find the seasonal index for summer historical inventory data below. Summer Historical Inventory Data Summer historical inventory data measures monthly figures in units four times a year. Data forecasted helps the company with inventory demands for the following year. Organizations should average a certain amount each month for a four year forecast. Organizations estimate demand for that month for the fifth year. Companies should average demands each year, and display average demands per month for that year. Data helps provide the organization, an overview with demands from one year to another year (brainmass, 2004, 2011). Organizations should identify the sequence of......

Words: 1074 - Pages: 5


...weighting schemes exist. First, while most indices use capitalization-weighting, additional criteria are often taken into account, such as sales/revenue and net income (see the “Guide to the Dow Jones Global Titan 50 Index”, January 2006). Second, as an answer to the critiques of capitalization-weighting, equity indices with different weighting schemes have emerged, such as "wealth"-weighted (Morris, 1996), “fundamental”-weighted (Arnott, Hsu and Moore 2005), “diversity”-weighted (Fernholz, Garvy, and Hannon 1998) or equal-weighted indices. [edit] Indices and passive investment management There has been an accelerating trend in recent decades to create passively managed mutual funds that are based on market indices, known as index funds. Advocates claim that index funds routinely beat a large majority of actively managed mutual funds; one study[citation needed] claimed that over time, the average actively managed fund has returned 1.8% less than the S&P 500 index - a result nearly equal to the average expense ratio of mutual funds (fund expenses are a drag on the funds' return by exactly that ratio). Since index funds attempt to replicate the holdings of an index, they obviate the need for — and thus many costs of — the research entailed in active management, and have a lower churn rate (the turnover of securities which lose fund managers' favor and are sold, with the attendant cost of commissions and capital gains taxes). Indices are also a common basis for a related type...

Words: 605 - Pages: 3

Forecasting with Indices

...Forecasting with Indices Jamie Prather QRB/501 April 23rd, 2012 Measuring the winter historical inventory data for the next 12 months consists of preparing a simple exponential forecast method to determine the method of simple average during the 12 separate indices. The forecast was processed by Running mean Absolute Deviation (RMAD) was computed by taking the average of two one-year-wide averages that are offset by one period relative to each other. Computing the ratio divided by the moving average in each period. Running sum of forecast errors were computed by taking the differences between the actual and the forecast demand for the periods being evaluated. | | | | | | Alpha | 0.2 | | | | Month | 1 | 2 | 3 | 4 | | Forecast | ABS Value | RMAD | RSFE | TS | 1 | | 39800 | 32180 | 62300 | 189,480 | 189,480 | | | | | 2 | 57350 | 64100 | 38600 | 66500 | 226,550 | 189480 | 37070 | 37070 | 37,070 | 1 | 3 | 15400 | 47600 | 25020 | 31400 | 119,420 | 196894 | 77474 | 114544 | -40,404 | -0.35274 | 4 | 27700 | 43050 | 51300 | 36400 | 158,450 | 181399.2 | 22949.2 | 137493.2 | -63,353 | -0.46077 | 5 | 21400 | 39300 | 31790 | 16800 | 109,290 | 176809.4 | 67519.36 | 205012.6 | -130,873 | -0.63836 | 6 | 17100 | 10300 | 31100 | 18900 | 77,400 | 163305.5 | 85905.49 | 290918 | -216,778 | -0.74515 | 7 | 18000 | 45100 | 59800 | 35500 | 158,400 | 146124.4 | 12275.61 | 303193.7 | -204,502 | -0.67449 | 8 | 19800 | 46530 |......

Words: 310 - Pages: 2