An electrical contractor’s 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

Question

Want to see more full solutions like this?

Answer 1

Textbook Question

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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

c)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.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.

Answer 2

Textbook Question

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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

c)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.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!

Answer 3

Textbook Question

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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

c)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.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!

Answer 4

Textbook Question

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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

c)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.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!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

a)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

c)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.17)=20.72

Therefore, the forecast for week 6 would be 20.72.

Answer 8

a)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Answer 9

a)

Expert Solution

Answer 10

a)

Expert Solution

Answer 11

Expert Solution

Answer 12

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.

Answer 13

Explanation of Solution

Given information:

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Answer 14

b)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

Answer 15

b)

Expert Solution

Answer 16

b)

Expert Solution

Answer 17

Expert Solution

Answer 18

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.

Answer 19

Explanation of Solution

Given information:

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), Chapter 3, Problem 4P , additional homework tip 2

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

Forecast for week 6=jobs week2+jobs week3+jobs week4+jobs week54

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

Forecast for week 6=22+18+21+224=20.75

The forecast for week6 would be 20.75

Answer 20

c)

Expert Solution

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.17)=20.72

Therefore, the forecast for week 6 would be 20.72.

Answer 21

c)

Expert Solution

Answer 22

c)

Expert Solution

Answer 23

Expert Solution

Answer 24

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.

Answer 25

Explanation of Solution

Given information:

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

Loose Leaf for Operations Management (The Mcgraw-hill Series in Operations and Decision Sciences), 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.

Week3 forecast=Forecasted Week2jobs+0.3(Actual Week2 jobs−Forecasted Week2jobs) Substitute the values and obtain the forecast

Week3 forecast=20+0.3(22−20)=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=Forecasted Week3jobs+0.3(Actual Week3 jobs−Forecasted Week3jobs) Substitute the values and obtain the forecast

Week4 forecast=20.6+0.3(18−20.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=Forecasted Week4jobs+0.3(Actual Week4 jobs−Forecasted Week4jobs) Substitute the values and obtain the forecast

Week5 forecast=19.82+0.3(21−19.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=Forecasted Week5jobs+0.3(Actual Week5 jobs−Forecasted Week5jobs) Substitute the values and obtain the forecast

Week6 forecast=20.17+0.3(22−20.17)=20.72

Therefore, the forecast for week 6 would be 20.72.

Answer 26

Ch. 3.15 - Prob. 1.1RQ Ch. 3.15 - Prob. 1.2RQ Ch. 3.15 - Prob. 1.3RQ Ch. 3 - What are the main advantage that quantitative...Ch. 3 - What are some of the consequences of poor...Ch. 3 - List the specific weaknesses of each of these...Ch. 3 - Forecasts are generally wrong a. Why are forecasts...Ch. 3 - What is the purpose of establishing control limits...Ch. 3 - What factors would you consider in deciding...Ch. 3 - Contrast the use of MAD and MSE in evaluating...

An electrical contractor’s 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

Concept explainers

Videos

Explanation of Solution

Explanation of Solution

Explanation of Solution

Want to see more full solutions like this?

Chapter 3 Solutions