Forecasting

Assignment Help Operation Management
Reference no: EM13930222

Forecasting

Using the data below,

a) Use a 3-month moving average model to forecast sales for periods 6-11.

b) Use a 5-month moving average model to forecast sales for periods 6-11.

c) Use an exponential smoothing model with a =.2 to forecast sales for periods 6-11. Assume a forecast of 65,000 for period 5.

d) Use an exponential smoothing model with a =.6 to forecast sales for periods 6-11. Assume a forecast of 65,000 for period 5.

e) Compare the forecasts in (a)-(d) for periods 6 - 10. Which is best? Why? Support your answer with appropriate statistics.

f) Starting with your solution to part (d), complete a double smoothing model for periods 6 -10 for sales. Again, assume a forecast of 65,000 for period 5.

Note: Do parts a-d, and f using Excel.

Period Sales

1 $35,725

2 $47,180

3 $54,965

4 $63,220

5 $66,315

6 $57,730

7 $62,700

8 $60,025

9 $74,590

10 $83,900

2. See the posted Excel file with OU tuition data from 2000 - 2014. You have a daughter who is currently in 7thgrade. She hopes to attend OU right after she finishes high school. Given the data in the attached file, use a linear model to forecast her TOTAL associated 4-year tuition and mandatory fees (rounded to the nearest $1,000). Use the data set that reflects your residency status.

 

If you use the 'trendline' option to generate the linear model, I'd suggest using t as the independent variable. Otherwise, Excel will generate your trend line equation using scientific notation and you'll have to change the formatting to get the exact number you need.

Note: The data does NOT include study abroad tuition and program fees. When you finish the problem, pick your jaw up off the floor and proceed to Problem #3.

3. The table below shows historical data regarding actual and projected inventory levels.

Period

1

2

3

4

5

6

7

8

Actual

50

70

60

-20

-10

65

60

85

Forecasted

40

65

70

80

70

75

50

80

  • For periods 1 - 8, on average, did the forecast underestimate or overestimate? And, by how many units, on average, did the forecast underestimate /overestimate per period? You must justify your answer with calculations.
  • For periods 1 - 8, the forecast deviated from actual by an average of _______ units per period. You must justify your answer with calculations.(Note- deviation can be negative or positive)

c) When forecasting inventory levels, a large forecast error in any month can lead to big shortages or large quantities sitting in warehouse. In this particular case, which performance measure would be best to evaluate various forecasting methods for monthly ending inventory - BIAS, MAD or MSE? Justify your answer.


Attachment:- Copy of OU Tuition Data for Question 2.xlsx

Reference no: EM13930222

Questions Cloud

Practice writing sql queries : What would my query look like? Although you don't need to build any tables with data, it would help to do this so you can test your sql query. In order to better understand sql you need to practice writing sql.
Use while-loop when number of iterations is not known : Your program should conform to the following constraints. · Use a while-loop when the number of iterations is not known before loop execution.
Evaluation of the leader by referring to concepts : Assignment Below is your assignment for this subject. Please read the brief and instructions thoroughly. Using relevant theories and models critically evaluate and analyse the leadership of a 21st century leader of a (business, government or not-f..
How can an acceptable use policy help to mitigate the risks : What measures do you think can be taken to reduce these risks that you have identified? How can an acceptable use policy help to mitigate the risks
Forecasting : Forecasting Using the data below, a) Use a 3-month moving average model to forecast sales for periods 6-11. b) Use a 5-month moving average model to forecast sales for periods 6-11.
Creating a list of shapes stored in an array : A Sample program is provided that creates a list of shapes stored in an array. This program uses classes: Shapes, Square, Rectangle and ShapesList.
Consultant economist by the nt government : You have been employed as a Consultant Economist by the NT Government in particular the NT Police and NT Health Departments. You have been asked to advise about the affects of
Does the choice of the method make a difference : Use a 0.05 significance level to test the claim that success is independent of the method used. If someone wants to stop smoking, does the choice of the method make a difference?
Differences between different types of functional assessment : Read only the first five pages in the Herzinger & Campbell (2007) article: Comparing Functional Assessment Methodologies: A Quantitative Synthesis.

Reviews

Write a Review

 

Operation Management Questions & Answers

  Are they especially important in user-oriented ideation

What types of information might be obtained from this source? Review lead users. Are they especially important in user-oriented ideation?

  Why is it important to try to fill in the gaps

When interviewing, why is it important to try to fill in the gaps in a candidate's employment history?

  Forming operation in which the workpart is reduced

K=35,000lb/in^2 and n=0.40 for a metal used in a forming operation in which the workpart is reduced in cross-sectional area by stretching

  What elements define value for customers of romulus plant

What elements define value for the customers of the Romulus plant? What is the role of logistics and logistics consider-ations in the success of the Romulus plant?

  Opportunity to interview for prestigious position

Marissa arrived early for her job interview. She was very excited about the opportunity to interview for a prestigious position. As she got out of the car, she got a run in her pantyhose. She was pleased to see a convenience store down the road and w..

  Creating abc classification system

Boreki Enterprise has the following 10 items in inventory. CEO Theodore Boreki asks you to divide these items into an ABC classification

  Discuss three issues that can deter high performance

Discuss three issues that can deter high performance when outsourcing a project.

  What are some of traditional international trade theories

What is globalization, and what are some of the traditional international trade theories that support the concept of globalization? List the major drivers of globalization and provide three examples of each. Explain at least four effects of globaliza..

  What quality related trade offs might there be between

What quality related trade offs might there be between having a single large, centralized produce processing facility and having many small, decentralized produce  processing facilities?

  Assignment on evaluation of business operations

You are the human resources (HR) manager for a public organization and you are conducting a New Hire Orientation session for all new employees. Last week, you analyzed the organization, including its strengths and weaknesses, as well as its missio..

  Write down some conversation taboos which they should be

write 400-600 words that respond to the following questions with your thoughts ideas and comments. this will be the

  Competitive procurement dollar amounts

Organizations may also set a procurement process based on competitive procurement dollar amounts. Find a case study that discusses procurement, and then discuss and analyze the procurement cycle.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd