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 (:
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
Please do not give solution in image format thanku
Short question 4- Leo manages a receiving station for rice. Farmers deliver their loads of rice with a rate of 150 tons per hour from 6:00 am to 2:00 pm. Leo can process them at a rate of 100 tons an hour. The station has room to hold only 200 tons of rice in inventory prior to processing. Once this space is filled, the farmers’ trucks must wait to dump their contents. Leo is considering using seasonal workers to help him with the processing of rice loads. When the seasonal workers are working, the processing rate increases to 125 tons per hour. The seasonal workers would start working at 10:00 am and finish working when the trucks stop waiting. At what time, Leo will finish processing loads of rice using these seasonal workers?
v Question Completion Status: Moving to another question will save this response. Question 2 Match the following terminologies to their corresponding definitions: A temporary endeavor undertaken to create a unique product, service, or result. A. Value chain v set of logically related collection of tasks performed to achieve a defined B. Project outcome. C. Procedure v A series of tasks that an organization performs to convert inputs to outputs. D. Product. v Reducing the number of employees to cut costs. E. Rightsizing. F. Cost Reduction G. Process. H. Supply Chain. AMoving to another question will save this response.