Homework Answers
EXCEL FORMULA:
Add Answer to:
Wk Qu. 10-13 The table below shows the sales of widgets... The table below shows the...
8. The table below shows the past 10 weeks of actual sales (y) and forecast sales...
8. The table below shows the past 10 weeks of actual sales (y) and forecast sales for the next period (Øt+1): Forecast for Week Sales next period 400 400 430 420 440 460 406 408.80 415.04 424.03 427.23 435.78 434.62 440 470 430 435.70 9 440 420 432.56 10 If the actual sales for week 11 were 410, what would the Exponential Smoothing model predict for the sales in week 12 for a=0.20? Page 19 of 20
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past...
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Year Sales 2005 2006 2007 2008 2009 450 495 518 563 580 Forecasted Sales 410.00 422.00 443.90 466.13 495.19 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 73.76 sales (round...
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 165 197 156 140 215 238 210 176 Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number) Quarter Forecast 10 12
The following table shows the past two years of quarterly sales information. Assume that there are...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year QUARTER 1 2 3 4 5 6 7 В SALES 161 191 158 136 217 234 210 170 Use time series decomposition to forecast quarterly sales for the next year. (Do not round Intermediate calculations. Round your answers to the nearest whole number) Forecast Quarter 9 10 11 12
The following table shows the actual demand observed over the last 4 years
The following table shows the actual demand observed over the last 4 years: ...
The following table shows the actual demand observed over the last 4 years:
The following table shows the actual demand observed over the last 4 years: Year1234Demand88410Using exponential smoothing with a = 0.40 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place)Year12345Forecast (ES)7.0Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers) Year2345Forecast (NA)
Problem 3-26 The following table shows the past two years of quarterly sales information Assume that...
Problem 3-26 The following table shows the past two years of quarterly sales information Assume that there are both trend and seasonal factors and that the seasonal cycle is one year QUARTER 1 2 3 4 5 SALES 162 199 158 140 216 239 205 198 8 Use time series decom on to forecast quarterly sales for the next year (Do not round Intermediate calculations. Round your answers to the nearest whole number Quarter 9 10 11 12
The following table shows the actual demand observed over the last 11 years Year 10 11...
The following table shows the actual demand observed over the last 11 years Year 10 11 Demand 7 4 Using exponential smoothing with α = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 round your responses place) one decimal Year 2 4 10 12 Forecast 6.0
As you can see in the following table, demand for heart transplant surgery at Washington General...
As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: Year 1 2 3 4 5 Heart Transplants 45.0 50.0 55.0 54.0 58.0 The director of medical services predicted 6 years ago that demand in year 1 would be 41.0 surgeries. a) Using exponential smoothing with alpha of 0.60 and the given forecast for year 1, the forecasts for years 2 through 6 are...
Can anyone help me with this question in Production System ? 4) The table below shows...
Can anyone help me with this question in Production System ?
4) The table below shows the monthly sales of laptops at a local branch of a major technology and media retail store. I 1 2 3 4 5 6 8 9 10 11 12 Sales 186 75 72 83 132 65 110 90 67 92 98 73 FMA4) 8926 85.5 8939.1296. 6126819 Fa=0.1 86 a. Determine the one-step-ahead forecast using the four most recent sales figures, MA(4). (Use the...
8. The table below shows the past 10 weeks of actual sales (y) and forecast sales for the next period (Øt+1): Forecast for Week Sales next period 400 400 430 420 440 460 406 408.80 415.04 424.03 427.23 435.78 434.62 440 470 430 435.70 9 440 420 432.56 10 If the actual sales for week 11 were 410, what would the Exponential Smoothing model predict for the sales in week 12 for a=0.20? Page 19 of 20
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (a) of 0.30 and a starting forecast of 410.00, the following sales forecast has been developed: Year Sales 2005 2006 2007 2008 2009 450 495 518 563 580 Forecasted Sales 410.00 422.00 443.90 466.13 495.19 The MAD for a forecast developed using exponential smoothing with a = 0.30 is 73.76 sales (round...
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year. QUARTER SALES 165 197 156 140 215 238 210 176 Use time series decomposition to forecast quarterly sales for the next year. (Do not round intermediate calculations. Round your answers to the nearest whole number) Quarter Forecast 10 12
The following table shows the past two years of quarterly sales information. Assume that there are both trend and seasonal factors and that the seasonal cycle is one year QUARTER 1 2 3 4 5 6 7 В SALES 161 191 158 136 217 234 210 170 Use time series decomposition to forecast quarterly sales for the next year. (Do not round Intermediate calculations. Round your answers to the nearest whole number) Forecast Quarter 9 10 11 12
The following table shows the actual demand observed over the last 4 years: Year1234Demand88410Using exponential smoothing with a = 0.40 and a forecast for year 1 of 7.0, provide the forecast from periods 2 through 5 (round your responses to one decimal place)Year12345Forecast (ES)7.0Provide the forecast from periods 2 through 5 using the naive approach (enter your responses as whole numbers) Year2345Forecast (NA)
Problem 3-26 The following table shows the past two years of quarterly sales information Assume that there are both trend and seasonal factors and that the seasonal cycle is one year QUARTER 1 2 3 4 5 SALES 162 199 158 140 216 239 205 198 8 Use time series decom on to forecast quarterly sales for the next year (Do not round Intermediate calculations. Round your answers to the nearest whole number Quarter 9 10 11 12
The following table shows the actual demand observed over the last 11 years Year 10 11 Demand 7 4 Using exponential smoothing with α = 0.30 and a forecast for year 1 of 6.0, provide the forecast from periods 2 through 12 round your responses place) one decimal Year 2 4 10 12 Forecast 6.0
Can anyone help me with this question in Production System ?
4) The table below shows the monthly sales of laptops at a local branch of a major technology and media retail store. I 1 2 3 4 5 6 8 9 10 11 12 Sales 186 75 72 83 132 65 110 90 67 92 98 73 FMA4) 8926 85.5 8939.1296. 6126819 Fa=0.1 86 a. Determine the one-step-ahead forecast using the four most recent sales figures, MA(4). (Use the...
Most questions answered within 3 hours.
-
"electron-withdrawing substituents on carbon encourage back
donation", then on the next page he says that "greater...
asked 1 minute from now -
On December 31, 2016, the shareholders’ equity section of the
balance sheet of R & L...
asked 7 minutes ago -
16.7
At t=0s a small "upward" (positive y) pulse centered at x = 5.0
m is...
asked 20 minutes ago -
Twitter Users and News: A poll conducted in 2013 found that 52%
of U.S. adult Twitter...
asked 35 minutes ago -
How
would I know whether a given amino acid has an ionizable group or
not? please...
asked 43 minutes ago -
True or false?
True False The function of the enzyme acyl CoA
synthetase is the ATP-dependent coupling...
asked 43 minutes ago -
Nadia Corporation adjusts its debt so that its interest coverage
(EBIT/Interest) remains constant at 3. Nadia’s...
asked 45 minutes ago -
In a clinical trial, 20 out of 600 patients taking a
prescription drug complained of flulike...
asked 51 minutes ago -
7. How many types of nuclear processes can produce energy? 8.
How many types of radioactive...
asked 55 minutes ago -
For both the Sn2 and Sn1 reaction
conditions:
Structure | Rxn (Y/N) at room T° Rxn...
asked 56 minutes ago -
11. In cell N2, enter a formula using the IF function and a
structured reference to...
asked 55 minutes ago -
There is X-linked mutations in flies in this example. You need
to determine the inheritence pattern...
asked 57 minutes ago