Question: 1.Calculate a 3-months simple moving average, for each possible month of years 2019/2020/2021. Calculate the MAD, MSE and MAPE for this method. In addition to

1.Calculate a 3-months simple moving average, for each possible month of years 2019/2020/2021. Calculate the MAD, MSE and MAPE for this method. In addition to the formulas in the computer, show one manual calculation of a forecast of this method, for any month you choose (10 marks)

2.Calculate a 3-months weighted moving average with weighting of 5, 3, 2, for each possible month of year 2019/2020/2021. (5 for last month, 3 for the month before last, 2 for two months before last). Calculate the MAD, MSE and MAPE for this method. Show one manual calculation of a forecast of this method, for any month you choose. (15 marks)

3.Using the exponential smoothing method with ? = 0.8, calculate the forecast for each possible month of year 2019/2020/2021. Calculate the MAD, MSE and MAPE for this method. Assume that the forecast for January 2019 was 50. Show one manual calculation of a forecast of this method, for any month you choose. (15 marks)

1.Calculate a 3-months simple moving average, for each possible month of years

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

You manage a movie theater that can handle up to 8,000 patrons per week. The current demand, price, and elasticity for ticket sales, popcorn, soda, and candy are given in Figure 4-16. The theater...

Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the financial resources to hold high levels of inventory, and...

Case Study- Furnmart Inc. Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the financial resources to hold high...

Hello-I just need help with the last 2 questions (7-8) Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does not have the...

Hello-I just don'y understand the last three questions please (6-7-8) Furnmart Inc is a medium size Ontario Company, which supplies office furniture to different shops in the GTA. The company does...

The company does not have the financial resources to hold high levels of inventory, and therefore manufactures its furniture per sale orders. This strategy causes long delivery times (4-5 weeks) and...

Which of the following is NOT a current asset? a. Inventory b.Accounts receivable c. Cash d. A rent deposit expected to be received back in 3 months when a lease expires. e. All of these are current...

Why has there been so much controversy over currency translation methods for group accounting? Which method do you prefer?

Find the general solution for: x 2 d 2 y d x 2 + x d y d x - y = x 2 - 7 Consider the change o f variable: x = e t , then t = l n x , then the original equation becomes: d 2 y d t 2 - y = e 2 t - 7...

Write compare and contrast essay you can choose any topic just write an essay, includes intro, 2 body paragraphs and conclusion but just write on differences, not similarities. Choose any topic but...

For financial reporting, Clinton Poultry Farms has used the declining-balance method of depreciation for conveyor equipment acquired at the beginning of 2018 for $2,880,000. Its useful life was...

Norio Manufacturing uses powdered plastics (PPS) to manufacture a high-pressure board used in digital equipment, Flex 10. Information concerning its operation in June is as follows: Budgeted units of...

The sales budget often uses the prior years sales as a starting point, and then sales quantities are revised for various factors such as planned advertising and promotion, projected pricing changes,...

A manufacturer planned to use $82.00 of materials per unit produced, but in the most recent period it actually used $80.00 of material per unit produced. During this same period, the company planned...

both please Many critics charge that the North American marketing system causes to be higher than they would be under more "sensible" systems. Select one: O a. exports O b. prices O C. customer...

2. In this chapter, the reader should reflect on the following concepts: action strategies, values and criteria.

1. Too understand personal motivation.

3. Imagine three people you know relatively well. Consider which of the five positions they often use in the conversations they engage in with other people.