Quarterly boat sales over a two-year period are provided in the table below. Suppose we expect year 3 to have an annual demand of 45. Usingthe multiplicative seasonal model, what is the forecasted value for quarter 2 in year 3? (Enter your answer rounded to the nearest wholenumber.)Boat SalesPeriodYear 1Yoar 2Quarter 18.8.Quarter 2Quarter 310111214Quarter 46.10

Year 1: Average demand = 8+10+12+94=9.75 Year 2: Average demand = 8+11+14+104=10.75

Answered: Quarterly boat sales over a two-year…

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

A distributor uses the following equation for forecasting demand of ski goggles: Y = 834 + 18*t, where t=0 in Spring of 2013. Each season is a period, so Summer 2013 would be t=1. His seasonal relatives are (Fall=1.2; Winter=1.4; Spring = 0.9; Summer= 0.8). What is his seasonalized forecast for Spring 2014? Plz do fast asap
Amalgamated Products which produces chemical materials has the following demand pattern for one of its key products. Weekly demand data is show below: Week Demand 1 1000 2 1250 3 800 4 1900 5 1640 6 2200 7 1870 8 2670 9 3210 10 2850 11 2200 12 2980 13 3790 14 4210 15 4716 Apply the Holt’s Model in forecasting the demand for period 16 What are the optimal values for alpha and beta if the decision-maker wishes to restrict both values to be between 0.25 and 0.65 What is the value of the minimized error term in this context? Show all related EXCEL plotsＢ Note: Include all EXCEL regression output and any plots
Please help with the correct answers in details: Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 19 12 17 10 18 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. (a) mean absolute error MAE = (b) mean squared error MSE = (c) mean absolute percentage error (Round your answer to two decimal places.) MAPE = % (d) What is the forecast for week 7?
B. The following table shows the number of televisions sold over the last ten years at a local electronic store. year TV sales 1 150 2 300 3 480 4 600 5 630 6 640 7 700 8 825 9 900 10 980 i. Using the trend projection, develop a formula to predict sales for years 11 and 12. Develop a table to calculate the slope and intercept. Please Show All Working. Use that formula to forecast television sales for years 11 and 12
The actual number of patients at Providence Emergency Medical Clinic for the first six weeks of this year follows: The value of the forecast is Week Actual No. of Patients 45 49 IT 56 40 44 55 Clinic administrator Dana Schniederjans wants you to forecast patient numbers at the clinic for week 7 by using this data. You decide to use a weighted moving average method to find this forecast. Your method uses four actual demand levels, with weights of 0.333 on the present period, 0.250 one period ago, 0.250 two periods ago, and 0.167 three periods ago. a) What is the value of your forecast? patients (round your response to two decimal places). 123456
1. Favors Distribution Company purchases small imported trinkets in bulk, packages them, and sells them to retail stores. They are conducting an inventory control study of all their items. The following data for the year 2006 are for one such item, which is not seasonal. [10 Points] Month Sales Jan Feb 18 19 Mar Apr May Jun 17 21 20 19 Jul 20 Aug 23 a. Use trend projection to estimate the relationship between time and sales (state the trend line equation in this problem). b. Calculate forecasts for February 2007, April 2007, and February 2008
The figures below show the sales of hairdryers in one shop over the last 3 months. Month 1: 140 Month 2: 197 Month 3: 150 Calculate the forecast for month 4 using exponential smoothing assuming that the forecast for the first month is 120 and the smoothing constant alpha = 0.8. Write the answer to 2 decimal places.
Consider the following yearly demand values for a particular product. Year Demand 1 360 389 3 410 4 381 368 374 (a) Produce forecast for year 4,5,6, and 7 by using 3-week moving average. (b) Produce forecast for year 4,5,6, and 7 by using 3-week weighted moving average where weights are as follows; wt–3 = .1, wt-2 = .3, and wt-1 = .6. (c) Produce forecast for year 4,5,6, and 7 by using exponential smoothing with a = .2. Please assume that the forecast for the first year is 360.
The most naive forecast can is quite valuable in leading to an organization’s success because it is most widely understood by senior managers. True or False
Apply the moving average with base m=4 forecasting technique of the data to estimate the demand in week 13.
With the multiplicative seasonal method of forecasting: the seasonal amplitude is a constant, regardless of the magnitude of average demand. there can be only four seasons in the time-series data. the times series cannot exhibit a trend. seasonal factors are multiplied by an estimate of average demand to arrive at a seasonal forecast.
The Yummy Ice Cream Company projects the demand for ice cream by using first-order exponential smoothing. Last week the forecast was 100,000 gallons of ice cream, and 90,000 gallons was actually sold. Using alpha=.1, prepare a forecast for next week. Calculate the forecast using Alpha=.2 and Alpha=.3 for this problem. Which values of Alpha gave the best forecast, assuming actual demand for next week ends up being 95,000 gallons?

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