Question: 2. Given the following data, use exponential smoothing ( = .1) to develop a demand forecast for period 4. What is the forecast? Period Demand

2. Given the following data, use exponential smoothing ( = .1) to develop a demand forecast for period 4. What is the forecast?

Period Demand Forecast (using Exponential Smoothing, = 0.1)

1 500 (Hint: Use Nave method to get started)

2 600

3 200

4 F4 = ?

a) 569

b) 470

c) 541

d) 551

e) 479

Please show work and use Excel if needed. Thank you.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

Name: Score: Management Science Do Not Use Excel Software EXAMINATION 2 1. Registration numbers for an accounting seminar over the past 10 weeks are shown below: Week 1 2 3 4 5 6 7 8 9 10...

Q:

Name: Score: Management Science Show all of your work Do Not Use Statistical Software Packages EXAMINATION 2 1. Registration numbers for an accounting seminar over the past 10 weeks are shown below:...

Q:

6. Given the following data, use exponential smoothing (a=0.2) to develop a demand forecast for period 3. Assume the forecast for the initial period is 4. What is the forecast for period 3? Period...

Q:

Given the following data, use exponential smoothing ) = ( 0 . 3 0 to develop a demand forecast. Assume the forecast for the initial period is 9 . \ table [ [ Period , 1 , 2 , 3 , 4 , 5 , 6 ] , [...

Q:

Given the following data, use exponential smoothing (=0.30) to develop a demand forecast. Assume the forecast for the initial period is 4 . The exponential smoothing forecast is (round your responses...

Q:

Given the following data, use exponential smoothing (=0.30) to develop a demand forecast. Assume the forecast the initial period is 7 . The exponential smoothing forecast is (round your responses to...

Q:

Given the following data, use exponential smoothing (=0.30) to develop a demand forecast. Assume the forecast for the initial period is 6 . The exponential smoothing forecast is (round your responses...

Q:

Given the following data, use exponential smoothing (=0.20) to develop a demand forecast. Assume the forecast for the initial period is 6 . The exponential smoothing forecast is (round your responses...

Q:

Given the following data, use exponential smoothing (=0.20) to develop a demand forecast. Assume the forecast for the initial period is 6 . The exponential smoothing forecast is (round your responses...

Q:

Given the following data, use exponential smoothing (=0.10) to develop a demand forecast. Assume the forecast for the initial period is 9. The exponential smoothing forecast is (round your responses...

Q:

Briefly explain the rules of debits and credits as they relate to assets, liabilities, equity, revenue, and expenses. Do debits always increase an account? Do credits always decrease an account? Give...

Q:

A person deposits $150 per month into a savings account for 2 years. If $75 is withdrawn in months 5, 7 and 8 (in addition to the deposits), construct the cash flow diagram to determine how much will...

Q:

What challenges might healthcare administrators face when preparing and maintaining budgets?

Q:

Mary has $255,906 accumulated in a 401K plan. The fund is earning a low, but safe, 3% per year. The withdrawals will take place at the end of each year starting a year from now. How soon will the...