Based on the output below, the forecast for time period 12 is: Intercept 5,620X100Two -267Three269Four2,289 a) 8309b) 8009c) 9109

Solution Step-by-Step Solution:Given the forecast model with the coefficients:Intercept: 5,620X:…

Answered: Based on the output below, the forecast…

Contemporary Marketing

18th Edition

ISBN:9780357033777

Author:Louis E. Boone, David L. Kurtz

Publisher:Louis E. Boone, David L. Kurtz

Chapter14: Pricing Strategies

Section14.2: Forecasting Demand

Problem 1LO

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
Using the output below, the forecast for time period 9 is: Intercept 5,620 X 100 Two -267 Three 269 Four 2,289 a) 5440 b) 6620 c) 6520 d) 5720
4) A small manufacturing firm has recorded a time series of the cost per unit for the firm's leading product over the past eight years. Year Cost/Unit($) 1 2 3 4 5 6 7 8 20 24.5 28.2 27.5 26.6 30 31 36 a) If you are not given a base value or trend, what would be the forecast for the year 10 made at the end of year 8 (a=0.2, ß=0.4). b) Forecast for the year 9 using 1) 5-month weighted average using 0.1,0.1,0.1,0.2,0.3, with the heaviest weight applied to the recent month 2) Exponential smoothing using a =0.2 and forecast of 21 for year 5 3) If a value was not provided in the question above, what value of a would you choose?
Y9
4.33 Storrs Cycles has just started selling the new Cyclone mountain bike, with monthly sales as shown in the table. First, co-owner Bob Day wants to forecast by exponential smoothing by initially setting February's forecast equal to January's sales with a = .1. Co-owner Sherry Snyder wants to use a three-period moving average. %3D BOB'S ERROR SHERRY'S ERROR SALES BOB SHERRY JANUARY 400 FEBRUARY 380 400 MARCH 410 APRIL 375 MAY a) Is there a strong linear trend in sales over time? b) Fill in the table with what Bob and Sherry each forecast for May and the earlier months, as relevant. c) Assume that May's actual sales figure turns out to be 405. Complete the table's columns and then calculate the mean absolute deviation for both Bob's and Sherry's methods. d) Based on these calculations, which method seems more accurate? PX
The number of internal disk drives (in million) made at a plant in Taiwan during the past 5 years follows: Year Disk Drives 1 142 2 156 3 184 4 204 5 210 a) Using simple linear regression the forecast for the number of disk drives to be made next year= 234.4 disk drives b) The mean squared error (mse) when using simple linear regression=[___] drives^2 (round your response to one decimal place)
Show the steps on excel to plot the graph and insert the equation on the graph
Given forecast errors of -5, -10, and +15, the MSE is: 116.67 900 0 175 350
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year 1 2 3 4 Mileage 3,000 4,000 3,450 3,750 3,700 a) Using a 2-year moving average, the forecast for year 6 = 3725 miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.45 and 0.55 (the weight of 0.55 is for the most recent period) = |3723 miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.45 and 0.55 = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)
The manager of a travel agency has been using a seasonally adjusted forecast to predict demand for packaged tours. The actual and predicted values are as follows: A. Compute MAD for the fifth period, then update it by period using exponentially smoothing with alpha 0.30 B. Compute a tracking signal for period 5 through 14 using the initial and updated mads. If limit of ± 3 are used.
The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year Mileage 1 3,050 2 4,050 3 3,450 4 3,850 5 3,700 a) Using a 2-year moving average, the forecast for year 6 = miles (round your response to the nearest whole number). b) If a 2-year moving average is used to make the forecast, the MAD based on this = miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.35 and 0.65 (the weight of 0.65 is for the most recent period) = miles (round your response to the nearest whole number). The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.35 and 0.65= miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.) d) Using exponential…

SEE MORE QUESTIONS

Recommended textbooks for you

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Marketing

ISBN:

9780357033791

Author:

Pride, William M

Publisher:

South Western Educational Publishing

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

SEE MORE TEXTBOOKS

Intercept	5,620
X	100
Two	-267
Three	269
Four	2,289

Based on the output below, the forecast for time period 12 is: Intercept 5,620 X 100 Two -267 Three 269 Four 2,289 a) 8309 b) 8009 c) 9109