Operations Management
Operations Management
13th Edition
ISBN: 9781259667473
Author: William J Stevenson
Publisher: McGraw-Hill Education
bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 21P

Two different forecasting techniques (F1 and F2) were used to forecast demand fern cases of bottled water Actual demand and the two sets of forecasts are as follows.

Chapter 3, Problem 21P, Two different forecasting techniques (F1 and F2) were used to forecast demand fern cases of bottled

a. Compute MAD for each set of forecast, Given your results, which forecast appears to be more accurate? Explain.

b. Compute the MSE for each set of forecasts. Given your results, which forecast appears to be more accurate?

c. In practice, either MAD or MSE would be employed to compute forecast errors. What factors might lead a manager to choose one rather than the other?

d. Compute MAPE for each data set. Which forecast appears to be more accurate?

a)

Expert Solution
Check Mark
Summary Introduction

To compute: Mean Average Deviation (MAD) for each set of forecasts.

Introduction: Mean Absolute Deviation (MAD) is the average distance between the data values and the mean. Mean Squared Error (MSE) is the average of the squares of the deviation and error.

Explanation of Solution

Given information:

Given the following data on demand and forecasts during two periods, decide which method gives more accurate results, by computing the Mean absolute deviation (MAD) for both the methods as shown below.

Operations Management, Chapter 3, Problem 21P , additional homework tip  1

Calculate the Mean absolute deviation (MAD) as shown below for the two methods:

Operations Management, Chapter 3, Problem 21P , additional homework tip  2

Compute the Mean absolute deviation (MAD) for the forecasting method F1 as shown below

MAD=|error|n

Substitute the value of |error|=32 and the value of n=8 to obtain the Mean absolute deviation (MAD)

MAD=328=4_

Compute the Mean absolute deviation (MAD) for the forecasting method F2 as shown below

MAD=|error|n

Substitute the value of |error|=24 and the value of n=8 to obtain the Mean absolute deviation (MAD)

MAD=248=3_

Between the two methods, the second forecasting method F2 has lower MAD and hence more accurate compared to the first method F1

b)

Expert Solution
Check Mark
Summary Introduction

To compute: Mean Squared Error (MSE) for each set of forecasts.

Introduction: Mean Squared Error (MSE) is the average of the squares of the deviation and error.

Explanation of Solution

Given information:

Given the following data on demand and forecasts during two periods, decide which method gives more accurate results, by computing the Mean squared error (MSE) for both the methods as shown below.

Operations Management, Chapter 3, Problem 21P , additional homework tip  3

Calculate the Mean squared error (MSE) as shown below for the two methods

Operations Management, Chapter 3, Problem 21P , additional homework tip  4

Compute the Mean squared error (MSE) for the forecasting method F1 as shown below

MSE=|error2|n1

Substitute the value of |error2|=176 and the value of n=8 to obtain the Mean squared error (MSE)

MSE=17681=25.14_

Compute the Mean squared error (MSE) for the forecasting method F2 as shown below

MSE=|error2|n1

Substitute the value of |error2|=106 and the value of n=8 to obtain the Mean squared error (MSE)

MSE=10681=15.14_

Between the two methods, the second forecasting method F2 has lower MSE and hence more accurate compared to the first method F1.

c)

Expert Solution
Check Mark
Summary Introduction

To determine: The factors that lead managers to choose any approach over another.

Introduction: Mean Squared Error (MSE) is the average of the squares of the deviation and error.

Explanation of Solution

MSE magnifies the error by squaring the difference. Therefore, MSE is able to quickly point out wrong forecasting models. However, both MAD and MSE are equally accurate in defining the errors in forecasting. It depends on the individual analyst to choose a particular method for decision making.

d)

Expert Solution
Check Mark
Summary Introduction

To compute: Mean Absolute Percentage Error (MAPE) for each set of forecasts.

Explanation of Solution

Compute the Mean Absolute Percentage Error (MAPE) as shown below.

Operations Management, Chapter 3, Problem 21P , additional homework tip  5

The absolute percentage error is computed by dividing the absolute error value by the actual demand figures.

The Mean Absolute Percentage Error (MAPE) is computed by adding the absolute percentage errors for the eight periods and dividing the sum by eight.

The calculations are shown above in the table derived, using Microsoft Excel.

The second forecasting method F2 has a lower MAPE of 4.11% compared to the first forecasting method F1 which gives a MAPE value of 5.34%. Therefore, the second method is more accurate.

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
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:
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 in the attached screenshot. Required: Compute the MAD and MSE for each forecast. Does either forecast seem superior? Explain.
14 Community General Hospital finds itself treating many bicycle accident victims. Data from the last seven 24-hour periods is shown below:   Day                  Bicycle Victims 1                                  8 2                                  14 3                                  8 4                                  14 5                                  18 6                                  15   With an alpha value of 0.31  and a starting forecast in day 3 equal to the 21 , what is the exponentially smoothed forecast for day 4?  (Round  to two decimal places)  15 What is the exponentially smoothed forecast for day 5?     (Round  to two decimal places) 16

Chapter 3 Solutions

Operations Management

Ch. 3 - What advantages as a forecasting tool does...Ch. 3 - How does the number of periods in a moving average...Ch. 3 - What factors enter into the choice of a value for...Ch. 3 - Prob. 11DRQCh. 3 - Explain how using a centered moving average with a...Ch. 3 - Contrast the terms sales and demand.Ch. 3 - Contrast the reactive and proactive approaches to...Ch. 3 - Explain how flexibility in production systems...Ch. 3 - How is forecasting in the context of a supply...Ch. 3 - Which type of forecasting approach, qualitative or...Ch. 3 - Prob. 18DRQCh. 3 - Choose the type of forecasting technique (survey,...Ch. 3 - Explain the trade-off between responsiveness and...Ch. 3 - Who needs to be involved in preparing forecasts?Ch. 3 - How has technology had an impact on forecasting?Ch. 3 - It has been said that forecasting using...Ch. 3 - What capability would an organization have to have...Ch. 3 - When a new business is started, or a patent idea...Ch. 3 - Discuss how you would manage a poor forecast.Ch. 3 - Omar has beard from some of his customers that...Ch. 3 - Give three examples of unethical conduct involving...Ch. 3 - A commercial baker, has recorded sales (in dozens)...Ch. 3 - National Scan, Inc., sells radio frequency...Ch. 3 - A dry cleaner uses exponential smoothing to...Ch. 3 - An electrical contractors records during the last...Ch. 3 - A cosmetics manufacturer s marketing department...Ch. 3 - Prob. 6PCh. 3 - Freight car loadings ova a 12-year period at a...Ch. 3 - Air travel on Mountain Airline for the past 18...Ch. 3 - a. Obtain the linear trend equation for the...Ch. 3 - After plotting demand for four periods, an...Ch. 3 - A manager of a store that sells and installs spas...Ch. 3 - The following equation summarizes the trend...Ch. 3 - Compute seasonal relatives for this data the SA...Ch. 3 - A tourist center is open on weekends (Friday,...Ch. 3 - The manager of a fashionable restaurant open...Ch. 3 - Obtain estimates of daily relatives for the number...Ch. 3 - A pharmacist has been monitoring sales of 2...Ch. 3 - New car sales for a dealer in Cook County,...Ch. 3 - The following table shows a tool and die companys...Ch. 3 - An analyst must decide between two different...Ch. 3 - Two different forecasting techniques (F1 and F2)...Ch. 3 - Two independent methods of forecasting based on...Ch. 3 - Long-Life Insurance has developed a linear model...Ch. 3 - Timely Transport provides local delivery service...Ch. 3 - The manager of a seafood restaurant was asked to...Ch. 3 - The following data were collected during a study...Ch. 3 - Lovely Lawns Inc., intends to use sales of lawn...Ch. 3 - The manager of a travel agency has been using a...Ch. 3 - Refer to the data in problem 22 a. Compute a...Ch. 3 - The classified department of a monthly magazine...Ch. 3 - A textbook publishing company has compiled data on...Ch. 3 - A manager has just receded an valuation from an...Ch. 3 - A manager uses this equation to predict demand for...Ch. 3 - A manager uses a trend equation plus quarterly...Ch. 3 - ML MANUFACTURING ML Manufacturing makes various...Ch. 3 - ML MANUFACTURING ML Manufacturing makes various...Ch. 3 - HIGHLINE FINANCIAL SERVICES, LTD. Highline...
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
    Text book image
    Contemporary Marketing
    Marketing
    ISBN:9780357033777
    Author:Louis E. Boone, David L. Kurtz
    Publisher:Cengage Learning
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Forecasting 2: Forecasting Types & Qualitative methods; Author: Adapala Academy & IES GS for Exams;https://www.youtube.com/watch?v=npWni9K6Z_g;License: Standard YouTube License, CC-BY
Introduction to Forecasting - with Examples; Author: Dr. Bharatendra Rai;https://www.youtube.com/watch?v=98K7AG32qv8;License: Standard Youtube License