Forecasting: Regression Analysis and Exponential Smoothing

Satisfactory Essays

Open Document

Open Document

View Writing Issues

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

You May Also Find These Documents Helpful

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
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
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
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
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
Satisfactory Essays
Ch8 Practice Leader Answeronly
- 437 Words
- 4 Pages
Ch8 Practice Leader Answeronly

Two pounds of material are required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs. Purchases of raw materials for May should be:…
- 437 Words
- 4 Pages
Satisfactory 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
MAT 540 Week 4 Homework
- 783 Words
- 6 Pages
MAT 540 Week 4 Homework

2. The manager of the Carpet City outlet needs to make an accurate forecast of the demand for SoftShag carpet (its biggest seller).If the manager does not order enough carpet from the carpet mill,customers will buy their carpet from one of Carpet City’s many competitors. The manager has collected the following demand data for the past 8 months:…
- 783 Words
- 6 Pages
Satisfactory 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
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 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
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
Better Essays
Warf Computers
- 1666 Words
- 7 Pages
Warf Computers

Recently developed Virtual Keyboard (VK) Planning to introduce the new product and expand the business To introduce the VK, Warf Computers will require significant outside investment…
- 1666 Words
- 7 Pages
Better 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

Related Topics