Question: Please use the table below for answering questions (a), (b), and (c). weights 0.4 alpha (n=3) 0.6 0.4 DAY DEMAND Simple Weighted Exponential (t) (D)

Please use the table below for answering

Please use the table below for answering questions (a), (b), and (c). weights 0.4 alpha (n=3) 0.6 0.4 DAY DEMAND Simple Weighted Exponential (t) (D) Moving Avg Moving Avg Smoothing 1 497 2 496 497.0 3 504 496.6 4 508 499.0 500.8 499.6 5 518 5027 506.4 502.9 6 523 510.0 514.0 509.0 7 522 516.3 521.0 514.6 517 521.0 522.4 517.5 9 519 520.7 519.0 517.3 10 527 519.3 A 518.0 11 535 521.0 523.8 521.6 12 537 527.0 531.8 B 13 537 533.0 536.2 531.0 14 541 536.3 537.0 533.4 15 538.3 539.4 536.4 CON 00 (a) Find the value for 'A' in the table (keep 1 decimal place): (b) Find the value for 'B' in the table (keep 2 decimal places): ( (c) If demand on Day 12 were changed and the spreadsheet updated accordingly, will the following forecasts on Day 15 change? Please answer 'Yes' or 'No' in the blank. The Simple Moving Average forecast The Weighted Moving Average forecast

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!

Please use the table below for answering questions a . , b . , c . , and d weights 0 . 4 alpha ( n = 3 ) 0 . 6 0 . 4 DAY DEMAND Simple Weighted Exponential ( t ) ( Dt ) Moving Avg Moving Avg...

Get External Data / Refresh All The following table represents the daily demand for newspapers for the last 10 days. This data is also available in the Excel file in the tab named "Exhibit 3B". In...

QUESTION 1 Please download the attached Excel workbook, follow the instructions within, and enter resulting answers below. Answers should be to two decimals, unless otherwise indicated. Forecasting1:...

please help... the cells that I highlighted is the work I've done, but I'm not even sure I've done this properly and I have no idea what to do. this is the spreadsheet that I must work with (please...

Two - Chapter Three (six problems) Due: 11/12 #1 Accountants at the firm Walker and Walker believed that several traveling executives submit unusually high travel vouchers when they return from...

Linear Trend - Multiple Regression The average price per gallon of gasoline in major U.S. cities for each month during the years 1999-2001 are shown in the table below: Month 1999 2000 2001 January...

Information for Questions 1-2: The Instant paper Clip Company sells and delivers office supplies to various companies, schools, and agencies within a 30-mile radius of its warehouse. The office...

I have questions on "Chapter 17 Time Series Analysis and Forecasting. The questions is in the attachment; that are problem number 29 and 30 (it is on last three pages, not the multiple choice...

Would you be able to put together another monthly cash flow analysis, this time for year 1? INCOME STATEMENT Year 1 269,115.00 48,930.00 20,388.00 338,433.00 $ $ $ $ COGS $ 113,940.00 $ 125,940.00 $...

The Digby Company has just purchased $39,660,000 of plant and equipment that has an estimated useful life of 15 years. Suppose at the end of 15 years this plant and equipment can be salvaged for...

Diversification helps to: A ) Increase taxes B ) Eliminate all risk C ) Reduce unsystematic risk D ) Reduce return

What is an example of constructive feedback? provide reference