EBK OPERATIONS MANAGEMENT
EBK OPERATIONS MANAGEMENT
12th Edition
ISBN: 9780100283961
Author: Stevenson
Publisher: YUZU
bartleby

Concept explainers

bartleby

Videos

Textbook Question
Book Icon
Chapter 3, Problem 4P

An electrical contractor’s records during the last five weeks indicate the number of job requests:

Chapter 3, Problem 4P, An electrical contractors records during the last five weeks indicate the number of job requests:

Predict the number of requests for week 6 using each of these methods:

a. Naive

b. A four-period moving average

c. Exponential smoothing with α = .30; use 20 for week 2 forecast

a)

Expert Solution
Check Mark
Summary Introduction

To forecast: The number of requests for week 6 using naïve approach.

Introduction: Forecasting is the planning process that helps to predict the future aspects of the business or operation using present or past data. It uses certain assumptions based the knowledge and experience of the management.

Explanation of Solution

Given information:

Given that an electrical contractor had the following job requests during the last five weeks

EBK OPERATIONS MANAGEMENT, Chapter 3, Problem 4P , additional homework tip  1

Forecast the number of requests for week 6 using the naïve approach as shown below.

Given that the number of job requests for week 5 was 22, the likely job requests for week 6 would also be 22.

b)

Expert Solution
Check Mark
Summary Introduction

To forecast: The number of requests for week 6 using a four-period moving average.

Introduction: Forecasting is the planning process that helps to predict the future aspects of the business or operation using present or past data. It uses certain assumptions based the knowledge and experience of the management.

Explanation of Solution

Given information:

Given that an electrical contractor had the following job requests during the last five weeks

EBK OPERATIONS MANAGEMENT, Chapter 3, Problem 4P , additional homework tip  2

Forecast the number of requests for week6 using a four period moving average as shown below.

Forecastforweek6=jobsweek2+jobsweek3+jobsweek4+jobsweek54

Substitute the values to obtain the forecast for week 6 as shown below.

Forecastforweek6=22+18+21+224=20.75

The forecast for week6 would be 20.75

c)

Expert Solution
Check Mark
Summary Introduction

To forecast: The number of requests for week 6 using a exponential smoothing.

Introduction: Forecasting is the planning process that helps to predict the future aspects of the business or operation using present or past data. It uses certain assumptions based the knowledge and experience of the management.

Explanation of Solution

Given information:

Given that an electrical contractor had the following job requests during the last five weeks

EBK OPERATIONS MANAGEMENT, Chapter 3, Problem 4P , additional homework tip  3

Forecast the number of requests for week6 using exponential smoothing as shown below.

Forecast the number of requests for week 6 using an exponential smoothing methodology, given that the forecast for week 2 was 20 and the actual job requests in week 2 was 22, and the exponential smoothing constant α=0.3 as shown below.

  • Given the week 2 forecast was 20, the actual number of jobs in week2 was 22 and the smoothing constant α was 0.3, prepare a forecast for week 3 as shown below.

Week3forecast=ForecastedWeek2jobs+0.3(ActualWeek2jobsForecastedWeek2jobs) Substitute the values and obtain the forecast

Week3forecast=20+0.3(2220)=20.6

Therefore, forecasted week3 job requests 20.6.

  • Given the week3 forecast was 20.6, the actual number of jobs was 18 and the smoothing constant α was 0.3, prepare a forecast for week4 as shown below.

Week4forecast=ForecastedWeek3jobs+0.3(ActualWeek3jobsForecastedWeek3jobs) Substitute the values and obtain the forecast

Week4forecast=20.6+0.3(1820.6)=19.82

Therefore, forecasted week4 job requests 19.82.

  • Given the week4 forecast was 19.82, the actual number of jobs was 21 and the smoothing constant α was 0.3, prepare a forecast for week5 as shown below.

Week5forecast=ForecastedWeek4jobs+0.3(ActualWeek4jobsForecastedWeek4jobs) Substitute the values and obtain the forecast

Week5forecast=19.82+0.3(2119.82)=20.17

Therefore, forecasted week5 job requests 20.17.

  • Given the week5 forecast was 20.17, the actual number of jobs was 22 and the smoothing constant α was 0.3, prepare a forecast for week 6 as shown below.

Week6forecast=ForecastedWeek5jobs+0.3(ActualWeek5jobsForecastedWeek5jobs) Substitute the values and obtain the forecast

Week6forecast=20.17+0.3(2220.17)=20.72

Therefore, the forecast for week 6 would be 20.72.

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
The annual demand for water bottles at Mega Stores is 500 units, with an ordering cost of Rs. 200 per order. If the annual inventory holding cost is estimated to be 20%. of unit cost, how frequently should he replenish his stocks? Further, suppose the supplier offers him a discount on bulk ordering as given below. Can the manager reduce his costs by taking advantage of either of these discounts? Recommend the best ordering policy for the store. Order size Unit cost (Rs.) 1 – 49 pcs. 20.00 50 – 149 pcs. 19.50 150 – 299 pcs. 19.00 300 pcs. or more 18.00
Help answer showing level work and formulas
I need to forecast using a 3-Period-Moving-Average-Monthly forecasting model which I did but then I need to   use my forecast numbers to generate a Master Production Schedule (MPS)  I have to Start with actual sales (my own test data numbers) for August-2022 Oct-2022 i need to create MPS to supply demand starting November-2022  April 2023  I just added numbers without applying formulas to the mps on the right side of the spreadsheet because I do not know how to do it. The second image is the example of what it should look like. Thank You.

Chapter 3 Solutions

EBK 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,
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