Using a simple five-day moving average, calculate the daily forecasts for the last 15 days. In...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Using a simple five-day moving average, calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Question 2 - (3 marks) Using a weighted average of 0.30 [last day], 0.25 [2 days ago] 0.20 [3 days ago], 0.15 [4 days ago], 0.10 [5 days ago), calculate the forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? [Continue to the next page] Question 3 - (5 marks) Assume that the forecast for Monday of 4 weeks ago was 450 units. Using an Exponential Smoothing with a = 0.25, calculate the daily forecasts for the last 15 days. If a is unknown, find the best value of the smoothing coefficient (a) that results in the lowest MSE. Question 4-(4 marks) Using your forecast for the last 15 days in parts (b) and (c), calculate MAD, MSE and MAPE for each forecasting method. Between the forecasting methods in parts (b) and (c), which one would you choose? Why? Using a simple five-day moving average, calculate the daily forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? Question 2 - (3 marks) Using a weighted average of 0.30 [last day], 0.25 [2 days ago] 0.20 [3 days ago], 0.15 [4 days ago], 0.10 [5 days ago), calculate the forecasts for the last 15 days. In addition, what is the forecast for the Monday of this week? [Continue to the next page] Question 3 - (5 marks) Assume that the forecast for Monday of 4 weeks ago was 450 units. Using an Exponential Smoothing with a = 0.25, calculate the daily forecasts for the last 15 days. If a is unknown, find the best value of the smoothing coefficient (a) that results in the lowest MSE. Question 4-(4 marks) Using your forecast for the last 15 days in parts (b) and (c), calculate MAD, MSE and MAPE for each forecasting method. Between the forecasting methods in parts (b) and (c), which one would you choose? Why?
Expert Answer:
Related Book For
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Read the case study "Southwest Airlines," found in Part 2 of your textbook. Review the "Guide to Case Analysis" found on pp. CA1 - CA11 of your textbook. (This guide follows the last case in the...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Consider the case of J polluters and with abatement cost functions C j (e j ) and one pollution victim. Abatement costs are ordered from highest to lowest such that C 1 (e 1 )>C 2 (e 2 )>>C J (e J )....
-
Holtzman Company is in the process of preparing its financial statements for 2019. Assume that no entries for depreciation have been recorded in 2019. The following information related to...
-
After reading Homosexuals in the Churches, Id like to point out that I dont know any serious, capable exegetes who stumble over Saint Pauls denunciation of homosexuality. Only a fool (and there seem...
-
Using the facts in problem 21, the operating margin is: a. .1125 b. .32 c. 1.1 d. 1.6 e. None of the above
-
The City of Beverly Heights General Fund had the following transactions, among others, in 20X7: 1. Appropriations were made as follows: Personal Services . . . . . . . . . . . . . . . . . . . . . . ....
-
1. Computech Corporation is expanding rapidly and currentlyneeds to retain all of its earnings; hence, it does not paydividends. However, investors expect Computech to begin payingdividends, beginn 2...
-
The July transactions of Acorn Industries are described in Problem 7-2B. Problem 7-2B, Acorn Industries completes these transactions during July of the current year (the terms of all its credit sales...
-
1. Use the stock prices for Amazon and the index levels for the S&P 500 to estimate beta for Amazon (AMZN). 2. If the risk-free rate is 4.39% and the market risk premium is 6.75%, what is Amazon's...
-
In October of 2 0 1 9 Solea Company purchased a zero - emission automobile for $ 7 0 , 0 0 0 . The vehicle will be used exclusively in the company business. The Company uses a calendar - based...
-
How do you deliver and evaluate the presentation?
-
Raleigh Corporation had pretax GAAP income of $ 1 5 0 , 0 0 0 and an income tax rate of 2 5 % . Raleigh had a $ 3 , 0 0 0 credit balance in its Deferred Tax Liability account on January 1 , and a...
-
An equity manager conducted a stock screen on 5 , 0 0 0 U . S . stocks that comprise her investment universe. The results of the screen are presented in the table below. Criterion % of Stocks Meeting...
-
How can a telephone company use it mission statement to stand or phone company?
-
You are the manager of a U . S . company situated in Los Angeles and manages the import / export division of the company. The company distributes ( resells ) a variety of consumer products imported...
-
The following cost information was provided to you for analysis: September 12,000 Units Produced Costs: TIC TAC TOE TING August 10,000 P80,000 70.000 60.000 50,000 How much is the fixed cost per...
-
Refer to the first 100 minutes of the computer simulation of the current operation of Herr Cutter's barber shop presented in Figure 12.7 and summarized in Figure 12.8. Now consider the alternative of...
-
A major banking institution, Best Bank, plans to open a new branch office in Little-town. Preliminary estimates suggest that two tellers (and teller windows) should be provided, but this decision now...
-
Ralph Edmund loves steaks and potatoes. Therefore, he has decided to go on a steady diet of only these two foods (plus some liquids and vitamin supplements) for all his meals. Ralph realizes that...
-
Turbo Corporation had net income of \(\$ 30,000\) and other comprehensive income of \(\$ 0\) prior to the following two adjustments: Turbo Corporation discovered it has an unrealized holding loss of...
-
Lance Co. purchased 100 shares of Mallard common stock at \$20 per share on March 15, 2020. Mallard declared and paid a dividend of \(\$ 1.50\) per share in 2020. The market price on December 31,...
-
An investor purchased 100 shares of Mallard common stock at \(\$ 20\) per share on March 15, 2020. On December 31, 2020, the stock was quoted at \(\$ 19\) per share and declared and paid a dividend...
Study smarter with the SolutionInn App