a. Forecast demand for each week, including week 10, usingexponential smoothing with a 5 .5 (initial forecast 5 20).b. Compute the MAD.c. Compute the tracking signal. ANSWER A,B, C Sales of tablet computers at Ted Glickman's electron-ics store in Washington, D.C., over the past 10 weeks are shownin the table below:WEEKDEMANDWEEKDEMAND120629221736328822437925251028

Exponential smoothing is forecasting method which identifying the farecasting value based on the…

Answered: orecast demand for each week, including…

orecast demand for each week, including week 10, using exponential smoothing with a 5 .5 (initial forecast 5 20). b. Compute the MAD. c. Compute the tracking signal.

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

Related questions

Q: When creating a time series–based forecast for the amount of soda to be sold in thecafeteria next…

A: Step 1: When creating a time series–based forecast for the amount of soda to be sold in thecafeteria…

Q: Series forecasting for Business| The F-test used in testing the significance of a regression model…

A: The correct answer is

Q: is based on the principle of using only the last observation in a sequence of stable data as a…

A: Naive forecast is used to set all the value as the last observation value for the next period,…

Q: The following tabulations are actual sales of units for 6 months and a starting forecast in January.…

A: Find the given details below:

Q: Which type of analytics is used to know the effect of product price on sales. OA) predictive B)…

A: Analytics refers to the orderly examination of information, measurements, and data to infer…

Q: 17. Statistical and observational methods, where adequate data or settings are available in which to…

A: Forecasting: It means the prediction of the future period. The prediction will be done based on the…

Q: Judgmental forecasts have the following strengths, except___________. a. Can include “inside” and…

A: A prediction based on subjective data. A judgmental forecast is one that is made by someone who is…

Q: The ratio of MSE/MSR yields O a . SSRa O bNone C the Fstatistic O d . SST

A: The ratio of MSE/MSR yields

Q: Which of the following is used to describe the degree of forecast error? a. Median and Mode b. Mean…

A: Mean absolute percent error is the method to describe the degree of relationship between errors for…

Q: Suppose the three last values were 20, 19, 20respectively. Using the naive method, the next forecast…

A: It measures a process in which the realities of the end times are used as a prediction of the…

Q: 1. Which of the following forecasting methods is (are) more appropriate for the demand given in this…

A: In the process of forecasting, known data is used to model historical trends across time and make…

Q: Prepare a forecast for weeks 6 through 10 by using a 4-week moving average. (Enter your responses…

A: The moving average forecast is particularly useful for smoothing out fluctuations in data and…

Q: Evaluate what is the purpose of a forecast. What factors does a firm use to create its forecasts of…

A: Forecasting refers to predicting the future with the help of the data available to the company. The…

Q: (i) MAD (ii) MAPD (iii) RSFE

A: AS PER THE GUIDELINES, WE ARE ONLY ALLOWED TO SOLVE FIRST THREE SUB-PARTS OF A QUESTION. SO, I AM…

Q: Two different forecasting techniques (F1 and F2) were used to forecast demand for cases of bottled…

A: Find the given details below: Given details:Predicted…

Q: The two general approaches to forecasting are: O historical and associative. O judgmental and…

A: Qualitative forecasting: This approach involves using subjective judgments, opinions, and expert…

Q: Here,Alpha 0.2 1) find out the best alpha?

A: Given data is

Q: A particular forecasting model was used to forecast a six-month perio April May June July August…

A: The tracking signal is used to determine if there is biasness in the forecast or not.

Q: Define the following term: a. Economic of scale b. Diseconomies od scale c. Constraints

A: As per this Q, I would define various terms like Economics of scale, Diseconomies of scale, and…

Q: 16- Statistical forecasting models have the following weaknesses, except __________. a. Can be…

A: Forecasting refers to the process to predict the future values of a particular phenomenon. The…

Q: The MAD for Method 1 = thousand gallons (round your response to three decimal places)

A: MAD is often used as an alternative to other measures of dispersion, such as the variance or…

Q: The sales of XYZ company for the previous three periods are 45, 42, and 43 respectively. Estimate…

A: The following is the data provided: Period Data January 45 February 42 March 43 The…

Q: Consider the data below which includes sales data and the forecasts that would have been made using…

A: Given data is

Q: is based on the principle of using only the last observation in a sequence of stable data as a…

A: Option C is correct. The naive forecast is based on the principle of using only the last observation…

Q: 8. Averaging techniques are useful for: A. distinguishing between random and non-random variations…

A: Averaging techniques:The term "averaging techniques" refers to the approaches that are used in the…

Q: In January, a car dealer predicted February demand for 150Honda Accord. Actual February demand was…

A: a. The forecasted demand for March is 152.6. b. The forecasted demand for March is 153.9.

Q: What do we mean by forecast? b. Can a forecast have an error? Justify your answer.

A: Here, I would discuss the meaning of forecast and I would also explain whether a forecast could have…

Q: why forecasting is needed in business a. to ascertain resource requirements b. to project profit…

A: Forecasting is a form of making knowledgeable predictions by utilizing historical data as the major…

Q: A) What makes a forecast optimal?

A: A) Practically all administrative choices depend on Forecasting. Each choice becomes functional…

Q: A pizza chain wants to forecast the demand rate for each store for each hour in the day.What type of…

A: Forecasting is the tool or technique which uses the historical data as the inputs to make the…

Q: If we use a simple exponential smoothing method with ??=0.3, ??11=100 and ??12=120, what is your…

A: Inventory management is the management in which raw materials and finished products are stored and…

Q: Use exponential smoothing with smoothing constant 0.4 to complete the table. b) Forecast the next…

A: THE ANSWER IS AS BELOW:

Q: 4. What is the difference between trend and seasonality in time series data? 5. Here are the errors…

A: Note: - Since the exact question that has to be answered is not specified, we will answer only the…

Q: Here are the errors associated with a particular forecast over the past five months, in…

A: Forecasting is a methodology that uses past information as input to make well-informed predictions…

Q: Assume that the data in columns A and B report the new constructions of residential homes, per…

A: Answer a Graph of the data is as under Answer b Draw a trendline in the graph of answer part a-…

Q: Please explain the calculation to get get the answers in the column provided?!

A: Forecasting is a technique used to predict future outcomes on the basis of past data. In businesses…

Q: Forecasts are generally wrong.a. Why are forecasts generally wrong?

A: Forecasting is used to predict future changes or demand patterns. Forecasting is the process of…

Q: Which of the following is important if forecasting is to have the desired positive effect on…

A: The correct answer is E. All of the above.All of the following are important if forecasting is to…

Q: Forecasting time horizons include:a) long range. b) medium range.c) short range. d) all of the…

A: Forecasting refers to making decisions and predicting on the basis of previous or past experiences.

Q: Sales for the past five months have been 15, 18, 12, 17, 13. Use the following methods to obtain a…

A: The last-value method is one of the simplest forecasting techniques. It involves taking the sales…

Question

a. Forecast demand for each week, including week 10, using
exponential smoothing with a 5 .5 (initial forecast 5 20).

b. Compute the MAD.

c. Compute the tracking signal.

ANSWER A,B, C

Sales of tablet computers at Ted Glickman's electron-
ics store in Washington, D.C., over the past 10 weeks are shown
in the table below:
WEEK
DEMAND
WEEK
DEMAND
1
20
6
29
2
21
7
36
3
28
8
22
4
37
9
25
25
10
28

Leveraging special tenchniques in analyzing historical data to predict future trends. Forecasting covers the methods and types of forecasting and their application to case studies.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2; forecasting using Exponential smoothing

VIEW

Step 3; Calculating MAD

VIEW

Step 4; Tracking signal

VIEW

Step by step

Solved in 4 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

a. Compute a four-week moving averages for the above time series. b. Compute the mean squared error (MSE) for the four-week moving average forecasts. c. Use α = 0.3 to compute the exponential smoothing values for the time series.
please answer all parts within 30 minutes..
Identify both statement, which is statement 1 and statement 2 whether it is true or false and provide references
Period 1 2 3 4 5 New Accounts Period 201 215 212 229 236 6 7 8 9 10 New Accounts Period 233 249 253 254 268 11 12 13 14 15 New Accounts 282 276 281 289 311
You manager gave you February 2021 actual sales and sales forecast. This is the only raw data you have access to. Which of the following is the most appropriate technique for forecasting March 2021's sales? a.Simple moving average b.Exponential smoothing c.Causal relationship forecasting d.Simple linear regression e.Weighted moving average
Respond to each of the items using the following time series data. Period Demand 144 2 172 3 157 4 160 144 181 7 160 8 176 9. 149 10 183 11 182 12 149 13 153 14 164 15 153 16 104 Click here for the Excel Data File b. Compute all possible forecasts using a five-period moving average. (Round your answers to 1 decimal place.) Absolute Period Demand 5-period SMA Errors 1 144 172 3 157 4. 160 5 144 181 7 160 8 176 9 149 10 183 11 182 12 149 13 153 14 164 LO
b. Prepare forecasts for June through September by using an exponential smoothing model with α = 0.4. Assume that the forecast for May was 2,100 (enter your responses rounded to the nearest whole number). Month March April May June July August September March April May June Demand Demand 120 2,030 1,110 4,210 3,260 5,830 c. Prepare forecasts for June through September by using an adjusted exponential smoothing model with α = 0.4 and ß = 0.2. Assume that the unadjusted forecast for May was 2,100 and the trend factor T₁ for May was 900 (enter your responses rounded to the nearest whole number). Month 120 2,030 1,110 4,210 Forecast 2,100 1704 2707 2928 4089 2,100 1,704 Unadjusted forecast Adjusted forecast
January February March April May June a. Calculate forecasts for the remaining five months using simple exponential smoothing with a = 0.4. February March April May June ACTUAL FORECAST 100 85 96 103 82 66 90 MAD Forecasts 91 93 97 91 81 b. Calculate the MAD for all the forecasts, including January's. (Round your answer to 1 decimal place.)
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error. b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error. c. Compare the average forecast error and MAD for the forecasting methods in parts a and b. Based on these error calculations, which of the two forecast methods would you recommend? Why?
Which of the following is not a step in the forecasting process? O a. select a forecasting model O b. eliminate all assumptions O c. determine the purpose and level of detail required O d. establish a time horizon O e. monitor the forecast GE 321
It is a forecasting method that uses interviews and surveys research and analysis of the market for a particular product/service which includes the investigation into customer inclinations. A study of various customer capabilities such as investment attributes and buying potential. O a. Liner projection O b. Market survey O c. Sales force composite O d. Delphi method
Which one of the forecasting methods is capable of handling large amounts of data and uncovering complex relationships? O a. Qualitative forecasting O b. Weather forecasting O c. Quantitative forecasting O d. Sales forecasting