I just need the last one please (: **Problem #2**The table below shows the actual sales of Product X by Company Y from January to December of 2019, as presented in Problem #1.| Month | Actual Sales (# of Product X) | 2-Month Moving Average Forecast - Sales (# of Product X) | Absolute Value of Errors ||---------|-------------------------------|--------------------------------------------------------|--------------------------|| Jan/19 | 1,860 | | || Feb/19 | 2,033 | | || Mar/19 | 3,556 | | || Apr/19 | 4,211 | | || May/19 | 6,250 | | || Jun/19 | 7,990 | | || Jul/19 | 10,250 | | || Aug/19 | 9,850 | | || Sep/19 | 9,980 | | || Oct/19 | 9,990 | | || Nov/19 | 7,895 | | || Dec/19 | 5,353 | | || Jan/20 | | | |### Instructionsa) **Calculate the 2-month Moving Average Forecast** for sales from March/2019 to January/2019 and enter them in the table above.b) **Calculate the Absolute Value of Error** for every forecasted month, from March/2019 to January/2020. Enter those values on the table above.c) **Calculate the Mean Absolute Deviation (MAD), the Mean Squared Error (MSE),** and **the Mean Absolute Percent Error (MAPE)** for the 2-month Moving Average Forecast you created for Product X from March/2019 to January/2020.d) **Create a table** that shows the MAD, MSE, and MAPE values you obtained for the Naïve Forecast and for the 2-month Moving Average Forecast. Which method would you recommend and why?

Calculate the 2-month Moving Average Forecast for sales from March/2019 to a) January/2019 and enter them in the table above. b) January/2020. Enter those values on the table above. c) Mean Absolute Percent Error (MAPE) for the 2-month Moving Average Forecast you created for Product X from March/2019 to January/2020. Calculate the Absolute Value of Error for every forecasted month, from March/2019 to - Calculate the Mean Absolute Deviation (MAD), the Mean Squared Error (MSE) and the - Create a table that shows the MAD, MSE and MAPE values you obtained for the Naïve d) Forecast and for the 2-month Moving Average Forecast. Which method would you recommend and why?

Calculate the 2-month Moving Average Forecast for sales from March/2019 to a) January/2019 and enter them in the table above. b) January/2020. Enter those values on the table above. c) Mean Absolute Percent Error (MAPE) for the 2-month Moving Average Forecast you created for Product X from March/2019 to January/2020. Calculate the Absolute Value of Error for every forecasted month, from March/2019 to - Calculate the Mean Absolute Deviation (MAD), the Mean Squared Error (MSE) and the - Create a table that shows the MAD, MSE and MAPE values you obtained for the Naïve d) Forecast and for the 2-month Moving Average Forecast. Which method would you recommend and why?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Name the three parts of a typical queing system?
Question Completion Status: Moving to the next question prevents changes to this answer. Question 6 Which of the following is one of the changes faced by many public agencies in recent years? O budget cuts O increased resources expanded priorities increase in employees A Moving to the next question prevents changes to this answer.
QUESTION 29 Matt wasn't very impressed when Corinne walked into the interview ten minutes late looking like she just woke up. He didn't realize that she had flown in from Denver for the interview and her plane was delayed and her luggage had been lost. What is affecting Matt's perceptual accuracy? a. first-impression error b. Pollyanna principle C. perceptual defense d. similarity error
(10 pts) Consolidated Mining Company mines zinc ore at two locations: Blue Mesa (New Mexico) and Dry Pass (Washington State). Once mined, each ton of ore must be moved to one of two processing plants, one near Boise (Idaho), and the other in West Texas. The processed ore is then shipped to three customers, Galvanic Industries, MunchCo, and American Metals. These customers require 600, 400, and 700 tons per day of processed ore, respectively. Blue Mesa can produce up to 800 tons of ore per day at a cost of $12/ton. Dry pass can produce up to 1000 tons of ore per day at a cost of $10/ton. The Boise plant can process up to 1000 tons of ore per day at a cost of $17/ton. The West Texas plant can handle up to 700 tons per day at $15/ton. Shipping costs per ton between the mines, plants, and customers are given in the following two tables: From Blue Mesa From Dry Pass To GalvanicTo MunchCoTo American Metals Shipping cost to Boise$ 4.5$ 3.50 Shipping cost from Boise$ 2.25$ 3.35$ 6.00…
Text Book Question 4C-12 Please answer the question fully and do not use CHAT GPT. I will report if I am not given honest help. I am struggling with these questions and am in need to get the best help to prepare for my final. So please be wise and do honest work in helping me. Thanks! - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Given the table (see picture) If the indirect cost savings is $1,300,000 per week a) Draw the network diagram b) What is the critical path?c) Provide the steps and process to crash this project d) What is the maximum time that this project can be crashed, what is the total crashing cost, and what is the new duration? e) Provide the final network diagram (using the maximum crash time)
Explain the role of phase diagrams in understanding the microstructural evolution of metallic alloys during heat treatment processes. How does this knowledge contribute to optimizing mechanical properties such as hardness and toughness in engineering materials? (69 words)
I will give a great review/rating! Thank you (:
ACTIVITY 6.2 | Work Ethics Assuming you are already working, list the Do's and Don'ts in the workplace in the table below. DONT's DO's 1. 2. 3. 4.
Question 15 Crowdsourcing is one of many means of Idea screening, O True O False Moving to another question will save this response. TOSHI
QUESTION 1: BASIC COMMUNICATION PRINCIPLES 11 Define the term communication (6) 1.2 Choose an item from COLUMN B that matches a description in COLUMN A. Write only the letter (A-L) next to the question number (1.2.1–1.2.10) in the ANSWER BOOK COLUMN A 1.2.1. The form of non - verbal communication that relies on the eyes of the sender COLUMN B A. Acoustic semiology 1.2.2. Words used to establish rapport B. Visual semiology C. phatic communication 1.2.3. The way people use space and distance to communicate ideas D. interpersonal communication 1.2.4. The transmission of messages between individuals E. graphic representation 1.2.5. A staff member reads her newspaper during F. direct written communication lunch hour G. indirect written communication 1.2.6. A bar chart is used to indicate the number of employees who resign every month H. kinesics Rody) 1.2.7. When a card system is introduced to monitor employees' punctuality I. receiver 1.2.8. A siren hoots to indicate that lunch time has…
Question 36 of 50 When is it a good idea to avoid using a template to write to a customer on social media? The customer is very emotional about a service failure. A problem is likely to generate a high volume of contacts. ○ You want to adopt a writing style that is unique to you. The customer needs detailed instructions to fix their issue.
Please do not give solution in image format thanku