↑Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below:Week 1Demand 205 6 7 8 9 1024 30 36 24 26 282423 28 38a) The forecast for weeks 2 through 10 using exponential smoothing with a 0.60 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places):7Week1 2 3 4 5Demand 20 23 28 38 24Forecast 20.0366308249 1026 28b) For the forecast developed using exponential smoothing (a=0.60 and initial forecast 20.0), the MAD-sales (round your response to two decimal places).c) For the forecast developed using exponential smoothing (a=0.60 and initial forecast 20.0), the tracking signal =(round your response to two decimal places).

Given that:Initial Forecast = 20Remember the formula for calculating Forecast =Error = Demand -…

Answered: Sales of tablet computers at Ted…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

The Florida Company was flooded by a Hurricane and somehow lost part of their forecasting data. The missing values in the following table must be recalculated from the remaining data. Exponential smoothing constant of 0.20 is used for both the forecast and updated MAD. NOTE: All forecast, error, MAD, and TS values should be rounded to the nearest hundredth (two decimal after dot, for example 99.99)
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 2 3 1 Demand 19 23 29 4 36 5 6 7 8 9 10 26 28 35 24 24 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.60 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places): Week 1 2 3 4 Demand 19 23 29 36 Forecast 19.0 5 6 7 26 28 35 8 9 10 24 30 24 b) For the forecast developed using exponential smoothing (a=0.60 and initial forecast 19.0), the MAD = sales (round your response to two decimal places). c) For the forecast developed using exponential smoothing (x=0.60 and initial forecast 19,0), the tracking signal = (round your response to two decimal places).
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: 4 Week 1 Demand 20 5 6 7 24 29 35 8 9 10 22 24 28 36 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.60 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): 8 Week 1 Demand 20 Forecast 20.0 2 3 20 29 6 7 29 35 22 2 20 3 29 4 36 5 24 9 10 24 28
The actual monthly demand of special pizza in the past 6 months were: 392, 355, 406, 427, 282, 394 If a four-month moving average forecasting model is used to generate forecasts, what is the value of the Mean Absolute Percent Error (in percent)? Use at least 4 decimals.
Sales of tablet computers at Ted Glickman's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 20 23 29 38 25 29 36 24 26 29 a) The forecast for weeks 2 through 10 using exponential smoothing with α = 0.50 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 20 23 29 38 25 29 36 24 26 29 Forecast 20.0 b) For the forecast developed using exponential smoothing (α = 0.50 and initial forecast 20.0), the MAD = sales (round your response to two decimal places). c) For the forecast developed using exponential smoothing (α = 0.50 and initial forecast 20.0), the tracking…
Following are two weekly forecasts made by two different methods for the number of gallons of gasoline, in thousands, demanded at a local gasoline station. Also shown are actual demand levels, in thousands of gallons: Week Forecast Method 1 Actual Demand 1 0.95 0.72 2 1.08 0.98 3 0.92 1.07 4 1.17 1.04 Week Forecast Method 2 Actual Demand 1 0.80 0.72 2 1.21 0.98 3 0.88 1.07 4 1.17 1.04 Part 2 The MAD for Method 1 = enter your response here thousand gallons (round your response to three decimal places).
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 2 1 Demand 19 21 3 29 Week 1 2 Demand. 19 21 Forecast 19.01 4 38 3 29 5 25 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 19.0 are (round your responses to two decimal places); 4 38 7 6 28 36 5 25 8 9 10 24 24 30 6 7 28 36 8 9 10 24 24 30
answer a,b, and c
An analyst must decide between two different forecasting techniques for weekly sales of roller blades: a linear trend equation and the nalve approach. The linear trend equation is F₂ =126-21t, and it was developed using data from periods 1 through 10. Based on data for periods 11 through 20 as shown in the table, which of these two methods has the greater accuracy of MAD and MSE are used? (Round your intermediate calculations and final answers to 2 decimal places.) t 12345671819 38 20 Units Sold 146 146 148 144 153 149 154 157 162 166 Click here for the Excel Data File MAD (Naive) MAD (Linear) MSE (Naive) MSE (Linear) provides forecasts with less average error and less average squared error.
Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 702 2 711 3 714 4 701 5 689 6 711 The Period 6 forecast by using weighted moving average with weights of 0.05, 0.25, 0.40, and 0.30 = (in 2 decimal places)
The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the Deborah Bishop Company in Des Moines: Month May June July August September October Actual Demand 108 80 108 115 105 114 125 120 Forecast Demand 100 100 97 101 104 104 108 107 November December For the given forecast, the tracking signal = MADS (round your response to two decimal places). 4
Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 20 2 20 Week 1 Demand 20 Forecast 20.0 3 29 4 37 4 37 5 24 2 3 29 20 6 30 7 8 37 24 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): 5 6 30 24 7 37 9 24 8 24 10 28 9 24 10 28

SEE MORE QUESTIONS

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS