Preview

Forecasting: Regression Analysis and Exponential Smoothing

Satisfactory Essays
Open Document
Open Document
592 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Forecasting: Regression Analysis and Exponential Smoothing
Demand Forecasting Problems

Simple Regression

a) RCB manufacturers black & white television sets for overseas markets. Annual exports in thousands of units are tabulated below for the past 6 years. Given the long term decline in exports, forecast the expected number of units to be exported next year.
|Year |Exports |Year |Exports |
|1 |33 |4 |26 |
|2 |32 |5 |27 |
|3 |29 |6 |24 |

b) A small hospital is planning for future needs in its maternity wing. The data below show the number of births in each of the past eight years.
|Year |Births |Year |Births |
|1 |565 |5 |615 |
|2 |590 |6 |611 |
|3 |583 |7 |610 |
|4 |597 |8 |623 |

Use simple linear regression to forecast the annual number of births for each of the next three years. Determine the coefficient of determination for the data and interpret its meaning.

Moving Averages

IPC’s Plant estimates weekly demand for its many materials held in inventory. One such part, the CTR 5922, is being studied. The most recent 12 weeks of demand for the CTR 5922 are :
|Week |Demand in units |Week |Demand in units |
|1 |169 |7
Continue Reading
View Writing Issues

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Forecasting
    • 492 Words
    • 2 Pages

    Forecasting

    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 20 X 2, a value of 2 to the data for 20 X 3, and a value of 3 to the data for 20 X 4. For exponential smoothing, assume that the last forecast for fiscal year 20 X 4 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?…

    • 492 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Best Essays

    Select Harvest Limited Executive Summary
    • 3025 Words
    • 13 Pages

    Select Harvest Limited Executive Summary

    Select Harvest Limited is an Australian company listed on the Australian Securities Exchange. Its main business operations are the producing, manufacturing, distributing and marketing of almond products. The company has over 11 000 acres of its own orchards (either owned or leased) and manages a further 34 000 acres. The share price has experienced severe fluctuations over the past, from a high…

    • 3025 Words
    • 13 Pages
    Best Essays
    Read More
  • Good Essays

    Decision Science 412
    • 776 Words
    • 4 Pages

    Decision Science 412

    The X23910 model mobile phone sales have been as follows in the last 6 months. What is your forecast for the sales of this phone in month 7? Use the appropriate Naive method............1412…

    • 776 Words
    • 4 Pages
    Good Essays
    Read More
  • Powerful Essays

    Tanglewood Case 2
    • 1369 Words
    • 6 Pages

    Tanglewood Case 2

    b. Fill in the empty cells in the forecast of labor availabilities in Table 1.1. (see below)…

    • 1369 Words
    • 6 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    HS AL2 L3 S1 02 11 UT Part 2 Student D
    • 196 Words
    • 1 Page

    HS AL2 L3 S1 02 11 UT Part 2 Student D

    c. Use the equation to predict the population in the year 2013. Show your work.…

    • 196 Words
    • 1 Page
    Satisfactory Essays
    Read More
  • Good Essays

    Gm545 Week 2 Case Study
    • 574 Words
    • 3 Pages

    Gm545 Week 2 Case Study

    (b1.) Refer to the data in the above Scenario. What is the size of the labor force in the United States for the given year?…

    • 574 Words
    • 3 Pages
    Good Essays
    Read More
  • Good Essays

    Economics Quiz Paper
    • 1504 Words
    • 7 Pages

    Economics Quiz Paper

    A contractor developed a multiplicative time-series model to forecast the number of contracts in future quarters, using quarterly data on number of contracts during the 3-year period from 2006 to 2008. The following is the resulting regression equation: ln = 3.37 + 0.117 X - 0.083 Q1 + 1.28 Q2 + 0.617 Q3 where is the estimated number of contracts in a quarter X is the coded quarterly value with X = 0 in the first quarter of 2006. Q1 is a dummy variable equal to 1 in the first quarter of a year and 0 otherwise. Q2 is a dummy variable equal to 1 in the second quarter of a year and 0 otherwise. Q3 is a dummy variable equal to 1 in the third quarter of a year and 0 otherwise. 16-1. The best interpretation of the constant 3.37 in the regression equation is: A. the fitted value for the first quarter of 2006, after to seasonal adjustment, is 103.37. B. the fitted value for the first quarter of 2006, prior to seasonal adjustment, is log10 3.37. C. the fitted value for the first quarter of 2006, prior to seasonal adjustment, is 103.37. D. the fitted value for the first quarter of 2006, after to seasonal adjustment, is log10 3.37. 16-2. The best interpretation of the coefficient of X (0.117) in the regression equation is: A. the quarterly compound growth rate in contracts is around 11.7%. B. the quarterly compound growth rate in contracts is around 30.92%. C. the annual compound growth rate in contracts is around 30.92%. D. the annual compound growth rate in contracts is around…

    • 1504 Words
    • 7 Pages
    Good Essays
    Read More
  • Good Essays

    Variable Cost and Company
    • 1030 Words
    • 5 Pages

    Variable Cost and Company

    The company is now in the process of preparing a production budget for the third quarter. Past experience has shown that end-of-month inventories of finished goods must equal 10% of the next month’s sales. The inventory at the end of June was 3,000 units.…

    • 1030 Words
    • 5 Pages
    Good Essays
    Read More
  • Satisfactory Essays

    Week 3 Assignment 2
    • 718 Words
    • 3 Pages

    Week 3 Assignment 2

    1. Use Excel or other calculation software to input the data to calculate an estimated regression. Then, from the calculation provided, interpret the coefficient of determination, indicating how it will influence your decision to open the pizza business in your town or community. Explain any additional variables that may improve the coefficient of determination.…

    • 718 Words
    • 3 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Forecasting Indice
    • 1263 Words
    • 6 Pages

    Forecasting Indice

    Another step in the evaluation process of a topic becoming a policy is also within the bounds of Healthcare and in particular the Affordable Healthcare Act that has recently been passed. The Affordable Healthcare Act began as a topic for politicians to stand on simply…

    • 1263 Words
    • 6 Pages
    Better Essays
    Read More
  • Satisfactory Essays

    Economic Forecasting
    • 323 Words
    • 2 Pages

    Economic Forecasting

    The study of macroeconomics demonstrates how individuals purchase, sell, and use raw materials to drive the economy around the globe. A useful source of data could be attained from the International Monetary Fund (IMF) where a person could gather current or historic data. After the collection of the data a researcher could utilize the International Monetary Funds website to see a forecast of any certain country. On the IMF website there are several choices for data such as International Financial Statics, Principal Global Indicators, and World Economic Outlook Databases. This informational data is useful for the inflation of good and services, tracking the market value of goods and services (gross domestic product), and other macroeconomic indicators for more than 200 countries.…

    • 323 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Powerful Essays

    Financial and Economic Forecasting
    • 3798 Words
    • 16 Pages

    Financial and Economic Forecasting

    B. The government would be interested in this forecast for many reasons. By forecasting the civilian unemployment rate, the government can have an idea of how stable the economy will be in the upcoming years.…

    • 3798 Words
    • 16 Pages
    Powerful Essays
    Read More
  • Satisfactory Essays

    Math Paper
    • 336 Words
    • 2 Pages

    Math Paper

    3) A formula in the form y = mx + b models the cost, y, of a four year college x years after 2007. Would you expect m to be positive, negative, or zero? Explain your answer.…

    • 336 Words
    • 2 Pages
    Satisfactory Essays
    Read More
  • Better Essays

    Forecasting Best Practices
    • 2091 Words
    • 9 Pages

    Forecasting Best Practices

    "Effective demand planning and sales forecasting across the supply chain can bring a host of benefits. Specifically, it can help improve labor productivity, reduce head count, cut inventories, and speed up production flows, and increase revenues and profits.…

    • 2091 Words
    • 9 Pages
    Better Essays
    Read More
  • Powerful Essays

    Forecast Assumptions
    • 1576 Words
    • 7 Pages

    Forecast Assumptions

    Myer decided to change their business strategy due to the poor performance in the prior years (appendix A). First, they are planning to focus on customer satisfaction by investing more than $600 million for capital and the implementation costs of the new strategy (Myer Holdings Limited 2015). Second, they are expanding the range of their brands and focusing on the big and well-known names such as Calvin Klein and Nine West to achieve the new strategy (Low 2016). Third, they are planning to invest more in omni-channel capability and they already took the first step when they joined eBay this year (Mitchell 2016). Finally, they are planning to expand their market internationally to…

    • 1576 Words
    • 7 Pages
    Powerful Essays
    Read More

Related Topics