OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)
7th Edition
ISBN: 9780077835439
Author: Roger G Schroeder, M. Johnny Rungtusanatham, Susan Meyer Goldstein
Publisher: McGraw-Hill Education
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 10, Problem 6P

Using the data in problem 2, prepare exponentially smoothed forecasts for the following cases:

  1. a. α = .1 and F1 = 90
  2. b. α = .3 and F1 = 90

a)

Expert Solution
Check Mark
Summary Introduction

To develop: The exponential smoothed forecast

Introduction:

Exponential smoothing:

In the exponential smoothing forecast method, older data are given lesser importance, and newer data are given more importance. It is efficient in making short-term forecasts.

Explanation of Solution

Given information:

Forecast for period 1 (F1) = 90

Smoothing constant (α) = 0.1

Period Dt
1 92
2 127
3 106
4 165
5 125
6 111
7 178
8 97

Formula for exponential smoothing:

FPeriod=Ft+[α(Dt-Ft)]FPeriod=Forecast for the period calculated.Ft=ForecastedsalesDt=Previousdemandα=Smoothingconstant

Calculation of forecast:

The forecast for period 1 is 90.

Period 2:

F2=F1+[α(D1-F1)]=90+[0.1(92-90)]=90+(0.1×2)=90+0.2=90.2

The forecast for period 2 is 90.2.

Period 3:

F3=F2+[α(D2-F2)]=90.2+[0.1(127-90.2)]=90.2+(0.1×36.8)=90.2+3.68=93.9

The forecast for period 3 is 93.9.

Period 4:

F4=F3+[α(D3-F3)]=93.9+[0.1(106-93.9)]=93.9+(0.1×12.1)=93.9+1.21=95.1

The forecast for period 4 is 95.1.

Period 5:

F5=F4+[α(D4-F4)]=95.1+[0.1(165-95.1)]=95.1+(0.1×70.1)=95.1+7.01=102.1

The forecast for period 5 is 102.1.

Period 6:

F6=F5+[α(D5-F5)]=102.1+[0.1(125-102.1)]=102.1+(0.1×22.9)=102.1+2.29=104.4

The forecast for period 6 is 104.4.

Period 7:

F7=F6+[α(D6-F6)]=104.4+[0.1(111-104.4)]=104.4+(0.1×6.6)=104.4+0.66=105

The forecast for period 7 is 105.

Period 8:

F8=F7+[α(D7-F7)]=105+[0.1(178-105)]=105+(0.1×73)=105+7.3=112.3

The forecast for period 8 is 112.3.

b)

Expert Solution
Check Mark
Summary Introduction

To develop: The exponential smoothed forecast

Introduction:

Exponential smoothing:

In the exponential smoothing forecast method, older data are given lesser importance, and newer data are given more importance. It is efficient in making short-term forecasts.

Explanation of Solution

Given information:

Forecast for period 1 (F1) = 90

Smoothing constant (α) = 0.3

Period Dt
1 92
2 127
3 106
4 165
5 125
6 111
7 178
8 97

Formula for exponential smoothing:

FPeriod=Ft+[α(Dt-Ft)]FPeriod=Forecast for the period calculated.Ft=ForecastedsalesDt=Previousdemandα=Smoothingconstant

Calculation of forecast:

The forecast for period 1 is 90.

Period 2:

F2=F1+[α(D1-F1)]=90+[0.3(92-90)]=90+(0.3×2)=90+0.6=90.6

The forecast for period 2 is 90.6.

Period 3:

F3=F2+[α(D2-F2)]=90.6+[0.3(127-90.6)]=90.6+(0.3×36.8)=90.6+10.92=101.5

The forecast for period 3 is 101.5.

Period 4:

F4=F3+[α(D3-F3)]=101.5+[0.3(106-101.5)]=101.5+(0.3×4.5)=101.5+1.35=102.9

The forecast for period 4 is 102.9.

Period 5:

F5=F4+[α(D4-F4)]=102.9+[0.3(165-102.9)]=102.9+(0.3×62.1)=102.9+18.63=121.5

The forecast for period 5 is 121.5.

Period 6:

F6=F5+[α(D5-F5)]=121.5+[0.3(125-121.5)]=121.5+(0.3×3.5)=121.5+1.041=122.6

The forecast for period 6 is 122.6.

Period 7:

F7=F6+[α(D6-F6)]=122.6+[0.3(111-122.6)]=122.6+(0.3×(-11.6))=122.6-3.48=119.1

The forecast for period 7 is 119.1.

Period 8:

F8=F7+[α(D7-F7)]=119.1+[0.3(178-119.1)]=119.1+(0.3×58.9)=119.1+17.67=136.8

The forecast for period 8 is 136.8.

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
What is a bottleneck? Would you try to reduce a bottleneck? Why or why not? Please provide a reference
Your firm has been the auditor of Caribild Products, a listed company, for a number of years. The  engagement partner has asked you to describe the matters you would consider when planning the audit for  the year ended 31January 2022. During  recent visit to the company you obtained the following information: (a) The management accounts for the 10 months to 30 November 2021 show a revenue of $260 million and profit before tax of $8 million. Assume sales and profits accrue evenly throughout the year. In the year ended 31 January 2021 Caribild Products had sales of $220 million and profit before tax of $16 million. (b) The company installed a new computerised inventory control system which has operated from 1 June  2021. As the inventory control system records inventory movements and current inventory quantities, the company is proposing: (i) To use the inventory quantities on the computer to value the inventory at the year-end (ii) Not to carry out an inventory count at the year-end (c)…
Develop and implement a complex and scientific project for an organisation of your choice. please include report include the following: Introduction Background research to the project The 5 basic phases in the project management process Project Initiation Project Planning Project Execution Project Monitoring and Controlling Project Closing Conclusion

Chapter 10 Solutions

OPERATIONS MANAGEMENT IN THE SUPPLY CHAIN: DECISIONS & CASES (Mcgraw-hill Series Operations and Decision Sciences)

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
    Contemporary Marketing
    Marketing
    ISBN:9780357033777
    Author:Louis E. Boone, David L. Kurtz
    Publisher:Cengage Learning
    Text book image
    Practical Management Science
    Operations Management
    ISBN:9781337406659
    Author:WINSTON, Wayne L.
    Publisher:Cengage,
    Text book image
    Marketing
    Marketing
    ISBN:9780357033791
    Author:Pride, William M
    Publisher:South Western Educational Publishing
Text book image
Contemporary Marketing
Marketing
ISBN:9780357033777
Author:Louis E. Boone, David L. Kurtz
Publisher:Cengage Learning
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Marketing
Marketing
ISBN:9780357033791
Author:Pride, William M
Publisher:South Western Educational Publishing
Single Exponential Smoothing & Weighted Moving Average Time Series Forecasting; Author: Matt Macarty;https://www.youtube.com/watch?v=IjETktmL4Kg;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