The ABC Corporation has collected the following data on its sales in the past 4 weeks....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
The ABC Corporation has collected the following data on its sales in the past 4 weeks. The company only operates from Monday to Friday. 4 Weeks Ago 3 Weeks ago 2 weeks Ago Last week Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Demand 372 462 597 147 282 552 507 642 237 165 642 408 552 237 462 642 531 732 372 336 Question 1 - (3 marks) 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? 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? The ABC Corporation has collected the following data on its sales in the past 4 weeks. The company only operates from Monday to Friday. 4 Weeks Ago 3 Weeks ago 2 weeks Ago Last week Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday Period 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Demand 372 462 597 147 282 552 507 642 237 165 642 408 552 237 462 642 531 732 372 336 Question 1 - (3 marks) 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? 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:
Answer rating: 100% (QA)
Question 1 Using a simple fiveday moving average the daily forecasts for the last 15 days are as follows 1 Week 2 Monday Forecast 372 462 597 147 282 5 372 2 Week 2 Tuesday Forecast 462 597 147 282 55... View the full 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
-
The table shows the retail market share of passenger cars from Ford Motor Company as a percentage of the U.S. market. A mathematical model for this data is given by f(x) = -0.0206x2 + 0.548x + 16.9...
-
(10 points) Given that ry + xy = 1. 1. Find a solution of the differential equation that satisfies the initial condition y(1) = 10. Answer: y = 2. Find a solution of the differential equation that...
-
A researcher wanted to find out if there was difference between older movie goers and younger movie goers with respect to their estimates of a successful actors income. The researcher first...
-
What are the institutional features that appear to have delayed the implementation of IFRS in India?
-
The financial statements of adidas (DEU) and Puma (DEU) are presented in Appendices B and C, respectively. The complete annual reports, including the notes to the financial statements, are available...
-
Nova Limited is a well-known manufacturer of coldpressed olive oil in Cyprus. The company's unique value proposition is that olives are crushed into a paste by using stone grinders and then pressed...
-
Lake Company has the following results of operations on December 31, 2020. 1. Pretax GAAP income in 2020 , its first year of operations, totals \(\$ 100,000\). Taxable income is \(\$ 90,000\). 2....
-
Cole Inc. owns shares of Marlin Corporation stock classified as available-for-sale securities. At December 31, 2010, the available-for-sale securities were carried in Coles accounting records at...
-
Helen Factory provides a 2-year warranty with one of its products which was first sold in 2020. Helen sold $1,440,000 of products subject to the warranty. Helen expects $180,000 of warranty costs...
-
1. Are the four intrinsic characteristics the best ones to base the relationship performance measures for Donnell Truong Ventures? If not, what characteristics would be more suitable? In either case,...
-
2. Does the surveillance camera present any ethical or legal problems? Why or why not? 3. Explain any other legal issues regarding employee or employer rights that might apply. 4. Do you think the...
-
Revenue $62,500 Sales Discounts $3,900 Sales Returns $2,400 Freight $1,200 Net Sales $55,000 Cost of Goods Sold $7,800 Gross Profit Given the information provided, what is the gross margin analysis?
-
Monthly Benefits The Social Security Administration has a computerized service that determines your benefits because Social Security benefits are based on a fairly complicated formula. In fact, the...
-
Read the attached mini case "Is Micro-Fulfillment The Next Big Bet For Malls, Retailers and Restaurants?" Using this case as a guide, research your own example of a specifc strategy (with specific...
-
If you had to come up with a public relations campaign to encourage people to contact their representatives and participate, What would it look like and how would it be designed?
-
Andreas Broszio just started as an analyst for Credit Suisse in Geneva, Switzerland. He receives the following quotes for Swiss francs (CHF) against the dollar (USD) for spot, 1 month forward, 3...
-
Provide a definition for the following concepts in one line (on separate lines) . Avoid copy and paste from web sources instead try to a paraphrase. You don't need to respond to your peers in this...
-
An 8.0 kg crate is pulled 5.0 m up a 30 incline by a rope angled 18 above the incline. The tension in the rope is 120 N, and the crates coefficient of kinetic friction on the incline is 0.25. a. How...
-
The Morton Ward Company is considering the introduction of a new product that is believed to have a 50-50 chance of being successful. One option is to try out the product in a test market, at an...
-
Reconsider the Wyndor Glass Co. case study introduced in Section 2.1. Suppose that Bill Tasto (Wyndor's vice president for manufacturing) now has found a way to provide a little additional production...
-
The Nori & Leets Co. is one of the major producers of steel in its part of the world. It is located in the city of Steel-town and is the only large employer there. Steel-town has grown and prospered...
-
List some tax advantages of retirement investing.
-
Go to the Web site of Yahoo! Finance (http://finance.yahoo.com). Enter the ticker symbol for Home Depot (HD) and Lowes (LOW). For each firm, click on Profile and note the ratio for Profit Margin (the...
-
Describe why you should itemize deductions as opposed to taking the standard deduction.
Study smarter with the SolutionInn App