O A. 0.00%OB. 31.87%OC. 34.04%OD. cannot be calculated with the information givenOE. 39.64% A forecasting method has produced the following over the past five months. What is the mean absolute percentage error (MAPE)?Actual11OA. 0.00%B. 31.87%51781113Forecast131030668$7

Forecasting is knowing the outcome of future events by making predictions and estimates based on…

Answered: A forecasting method has produced the…

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

Asvnch Problem - Statistical Forecasting Data Set – Eunice BC Fashion Monthly Sales, in million units. Year Total Sales Year Total Sales 2010 38 2016 43 2011 41 2017 40 2012 40 2018 45 2013 45 2019 47 2014 50 2020 42 2015 42 2021 48 Questions: a. Find the naïve forecast. b. Use the 3 years moving average forecast. c. Have a 5 years weighted moving average. d. Develop forecast using exponential smoothing with a = 0.2. e. Determine the trend line equation and present the forecast. f. Find the best forecast for year 2022. Note: Use the first 5 years as the training samples and the last 5 years as the forecasting samples. Solve it in Excel Sheet/Sheet with Equations as possible.
Use the following data to determine the tracking signal for period 4. Actual Forecast 10 16 23 16 50 49 63 59 108 106 122 118 a. 1.333 b. 1.108 c. 0.742 d. 0.429
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
Problem 3-22 (Algo) Two independent methods of forecasting based on judgment and experience have been prepared each month for the past 10 months. The forecasts and actual sales are as follows:
a. What is the mean square error for time periods 2 through 4 using the average forecasting method? b. What is the mean absolute error for time periods 2 through 4 using the average forecasting method? c. What is the mean absolute percentage error for time period 2 through 4 using the average forecasting method? Round all answers to two decimal places. Time Period 1 2 3 4 Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Electric Bill 510 315 420 480 Average Forecast Forecast Error
Assume that your stock of sales merchandise is maintained based on the forecast demand. If the distributor's sales personnel call on the first day of each month, compute your forecast sales by each of the three methods requested here. June July August ACTUAL 144 184 210 a. Using a simple three-month moving average, what is the forecast for September? Note: Round your answer to 2 decimal places. Forecast for September b. Using a weighted moving average, what is the forecast for September with weights of 0.30, 0.40, and 0.30 for June, July, and August, respectively? Note: Do not round intermediate calculations. Round your answer to 2 decimal places. Forecast for September
Given the following original forecast and actual data: Month Actual Forecast Jan 600 Feb 475 Mar 550 Apr 575 May 643 Jun 662 Jul ??? ??? Using a 2 month weighted moving average with weights of 75% for the previous month and 25% for two months back, what is the forecast for July. Round your answer to 1 decimal place. 400 -- —— ——
The Toro Cutlery Company has collected monthly sales information below: MONTH January February March April The company is examining two forecasting methods, moving average and exponential smoothing for forecasting sales. a. What will the forecast be for January the following year using a three-, four-, and five-month moving averages? Do not round intermediate calculations. Round your answers to the nearest whole number. Forecast (January, 3-month MA): 87667 Forecast (January, 4-month MA): 72500 Forecast (January, 5-month MA): 69600 b. What will the forecast be for January the following year using exponential smoothing with a = 0.6? Assume the forecast for February this year is 25,000. Do not round intermediate calculations. Round your answer to the nearest whole number. SALES 25,000 18,000 43,000 110,000 MONTH May June July August SALES MONTH 84,000 September 28,000 October 97,000 November 58,000 December SALES 27,000 105,000 82,000 76,000
b5 need urgent in 15 minutes
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?
a. Using POM for Windows' least squares-linear regression module, develop a relationship to forecast production ratings from test scores. (Round your responses to three decis and include a minus sign if necessary.) Y= - 23 + .945 x where Y = Production rating and X = Test score. b. If a worker's test score was 54, what would be your forecast of the worker's production rating? 51. (Enter your response as an integer.) c. Comment on the strength of the relationship between the test scores and production ratings. The coefficient of correlation for the least-squares regression model is and the coefficient of determination is (Enter your responses rounded to three decimal places.) More info Test Score Production Rating Production Test Worker Worker Rating Score A 55 43 K 58 57 B 38 43 75 75 93 87 67 48 D 86 77 31 26 E 88 82 62 49 F 66 68 24 25 G 55 47 Q 78 84 Clear all Check 50 46 34 32 41 41 51 58 J 69 74 T 39 30 Print Done LLMN OPoRS
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows: Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a weighted average approach using 0.60 for August, 0.30 for July, and 0.10 for June.

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS

A forecasting method has produced the following over the past five months. What is the mean absolute percentage error (MAPE) Actual 11 5 11 7 13 O A. 0.00% OR 21 97% Forecast 13 10 8 6 8 4