Question: PLEASE SHOW ALL WORK 4. (20 points) A company has had the following sales record for the most recent six months: Month 1 2 Sales

PLEASE SHOW ALL WORK PLEASE SHOW ALL WORK 4. (20 points) A company has

4. (20 points) A company has had the following sales record for the most recent six months: Month 1 2 Sales 250 185 170 210 280 165 4 5 6 a. Use an exponential smoothing method with a = 0.3, to forecast sales in months 2 to 7. F2 F3 F4 FS F6 F7 b. Use a weighted three months moving average method to forecast sales in months 4 to 7. Let the weights be: 0.5 for the most recent demand W..., 0.3 for W.2, and 0.2 for W... F4 F5 F6 F7 c. Use a simple three months moving average method to forecast sales in months 4 to 7. F4 FS F6 F7 d. Calculate the mean absolute deviation (MAD) for (1) exponential smoothing. (2) weighted moving average, and (3) simple moving average. If you were to use MAD as the only criterion for evaluating the three forecasting methods, which one would you choose? Show all your work

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!

Given an array of four integers, write a program that populates a new array with the square of the elements in the given array. Assume $s0 stores the memory location of the first element of the given...

4. (20 points) A company has had the following sales record for the most recent six months: Month 1 2 3 4 5 6 Sales 250 185 170 210 280 165 d. Calculate the mean absolute deviation (MAD) for (1)...

4. (20 points) A company has had the following sales record for the most recent six months: Month 2 3 4 5 6 Sales 250 185 170 210 280 165 c. Use a simple three months moving average method to...

4. (20 points) A company has had the following sales record for the most recent six months: Month 1 2 3 4 5 6 Sales 250 185 170 210 280 165 a. Use an exponential smoothing method with a = 0.3, to...

Please help answer these questions and problem Quiz 2 Multiple choice (5 pts each) (highlight or clearly mark your answer) In a good internal control system, which of the following documents are...

A company has had the following sales record for the most recent six months: Month Units Sold 1 150 2 143 3 160 4 182 5 220 6 194 Assume the smoothing alpha equal to 0.4, and a forecast value for...

Jones Widget Company (JWC) incorporated near the end of 2013. Operations began in January of 2014. JWC prepares adjusting entries and financial statements at the end of each month. The statements...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

1. AB company is a manufacturing company whose best-selling are bolts and nuts. From 2019-2020 logistics says that the best-seller sizes have a mean diameter of % inches and a standard deviation of...

A person accidentally leaves a car with the lights on. If each of the two headlights uses 40W and each of the two taillights 6.W, for a total of 92W, how long will a fresh 12-V battery last if it if...

1 . In automobile collision insurance and health insurance, the insurance policy often has a provision calling for a deductible according to which the portion of any insured loss up to some fixed...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...