Question: Based on the current forecasts, which of the forecast methods is optimal (performing best) based on the three Forecast Accuracy measurements. explain why M&M Sales

Based on the current forecasts, which of the forecast methods is optimal (performing best) based on the three Forecast Accuracy measurements. explain why

M&M Sales Trends (Cases Sold) M&M Sales Forecasting Tool 7500 7000 6500 & 6000 S500 2018 Actual 2019 Total Actual Sold 2019 Total Sold (Cases) Forecast (Cases) 5734 January 5801 5823 February 5945 5684 March 5700 7134 April 6958 6587 May 6520 5935 June 5785 6005 July 6102 6325 August 6459 6251 September 7210 October 6900 November 7059 December 2018 Sales January February March April May June July August September October November December Actual Growth 1.17% 2.10% 0.28%. -2.47% -1.02%. -2.53% 1.62%. 2.12% 2019 Forecas t Growth Over 2018 Only 5906 5998 5855 7348 6785 6113 6185 6515 6439 7426 7107 7271 Forecas 2019 2019 t3- Forecast 2019 Forecas month 3-Month Forecas t Exp. Moving Weighted Exp. Smoothi Averag Moving Smoothing with e Average ng Trend 7056 7042 6507 6643 6587 6398 6625 6753 6268 6125 6755 6884 5815 5794 6469 6432 6201 6378 6312 6227 6393 6487 6128 6004 6421 6240 6377 6402 6136 6091 6420 6452 6115 6217 6230 6173 #N/A #NIA #NIA #NIA #NIA #NIA #N/A #NIA #NIA #N/A #N/A #NIA Season Adjusm ent Factors 0.90 0.91 0.89 1.12 1.03 0.93 0.94 0.99 0.98 1.13 1.08 1.11 SOOD January February March April May August September October November December June July Month -- -- -- 2018 Actual Total Sold Cases 2019 Actual Total Sold (Cases) Apply Seasonality Adjust Forecast Growth Rate (Ta Forecast Weights: YTD Aggregate Growth R No 3.007 207 0.09% Foreca MAD st MSE Accura MAPE 179 47224 2.87% 647 536722 10.56% 579 493531 9.43% 474 318880 7.92% 522 408027 8.72% 30% 507 M&M Sales Trends and Forecast (Cases) 9000 7500 7000 6500 6000 5500 5000 January February March April May June July August September October November December Manth -2018 Actual Total Sold (Cases) --- 2019 Forecast Growth over 2018 Only - 2019 Forecast 3 Month Weighted Moving Average - 2019 Forecast Exp. Smoothing with Trend 2019 Actual Total Sold cases) -- 2019 Forecast 3-month Moving Average --- 2019 Forecast Exp. Smoothing

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!

3. Sales for September are 6,301 cases. Enter the September sales value into the correct cell in the forecast tool. a) What is the new YTD Aggregate Growth Rate? b) Based on the new data, which of...

The company has been purchasing cases of M&Ms based on the 3% over growth forecast for January 2020 through September 2020. This process means that the company purchases in advance the number of...

Spend analysis Stock-keeping unit (SKU) 10 Three-way match Utilization ty Images; @ monsity/ Getty Images Vendor master health care? iency? CHAPTER 17 applied, and what are the steps to fol-...

B32 Redstone Foods M&M Sales Forecasting Tool Duti Sectos IHIIIIII! RE WS INT SM PL 5433 180 ST BBS SO HE 21 Forest Aray R WIE w LINE TE NIE SH EEL IMORE WE / Forecasting Redstone Fonds MAM Soles...

Complete the following tasks in the Excel document. The questions will help you collect data and draw conclusions for your report. 1. Confirm that the following pre-set existing values are present....

Kindly summarize the below article: 6 Ways to Create an Effective Sales Forecast Max Freedman Contributing Writer Updated Mar 01, 2023 To be prepared for your company's future, you need to be able to...

read this report and answer questions provided: ICTE in Transportation and Logistics 2018 (ICTE 2018) Demand forecasting in pharmaceutical supply chains: A case study Galina Merkuryeva"*, Aija...

Market Demand Forecast Method Selection and Application: A Case Study in Hero MotoCorp Ltd. D K Choudhury Abstract: In this dynamic era, the market is very competitive and the demand for a product...

10-K Ford Motor Company Review Ford Motor Company's Form 10-K for 2012. Explain the purpose of a company?s 10-K and how it interprets the firm?s financial strength. Write a description of three...

2.Excel Ratio File spreadsheet: Using the SEC Financial Statements Ratios and Calculations, prepare a ratio analysis of your SEC corporation's current and prior year's financial statements. In...

Your company currently hauls 1 load a week from Chicago to Indianapolis and from Columbus back to Chicago. To balance the flow of trucks in and out of markets, you reposition trucks empty from...

October sales are projected to be $390,000. Sales are projected to increase by 10% in November and another 25% in December and then return to the October level in January. . 20% of sales are made in...

A project has an initial cash outflow of $ 6 0 0 followed by cash inflows of $ 2 0 0 , $ 2 0 0 , $ 4 0 0 , and $ 5 0 0 over years 1 to 4 , respectively. The discount rate is 9 percent. Which one of...

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...