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

Serena just visited a restaurant for dinner. During the dinner time, she overheard two customers saying that company TXL will expect its workforce to go on strike next week, which will halt manufacturing and distribution of products. When Serena gets back home, she immediately uses this information to update her analyst forecast on company TXL from a “buy” to a “sell”. Please explain which Standard is violated.
A manager uses this equation to predict demand for landscaping services: Ft= 10 + 5t. Over the past eight periods, demand has been as follows:Period, t 1 2 3 4 5 6 7 8Demand 15 21 23 30 32 38 42 47Is the forecast performing adequately? Explain.
is a method that utilizes the principle of using only the last observation in a sequence of stable data as a forecast for the next period Oa Associative forecast Ob. Exponentially smoothed forecast Oc Naive Od. Moving average forecast
The number of patients coming to the Healthy Start Maternity clinic has been increasing steadilyover the past eight months. You are provided with some historical data as follows:Month Clinic attendance(in thousands)1 3.42 3.93 4.54 5.05 5.86 5.97 6.58 6.7b. Use simple linear regression to forecast annual demand for months 9 and 10 by using thetabular method to:-i. Derive the values for the intercept and slope. ii. Derive the linear regression equation. iii. Plot the linear regression line. iv. Develop a forecast of the clinic attendance for months 9 and 10.
George has forecasted that annual demand for his sailboats in year 5 will equal 6,000 sailboats Based on the given data and using the multiplicative seasonal model, the demand level for George's sailboats in the spring of year 5 will be nothing sailboats (enter a whole number). Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
In January a battery dealer pridicts February demand of 2000 2 charger battery whereas the actual demand was 1756 unit of batteries , using a smoothing constant of alpha 0.34, the dealer wishes to forecast the march demand using the exponential smoothing model ?
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
4. The yearly demand for units manufactured by the Orion Company Limited has been as follows:Year Units Year Units1 520 5 8602 830 6 9403 520 7 9904 750 8 850Required:i. Prepare a forecast for year 5 through 8 by using a three-year simple moving average.What is the forecast for year 9?ii. Calculate the Cumulative Frequency Error (CFE), Mean Absolute Deviation (MAD),Mean Squared Error (MSE), and Mean Absolute Percentage Error (MAPE) as at the endof year 8.
The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past 8 months: Demand for Soft Shag Month Carpet (1,000 yd.) 1 8 2 12 3 7 4 9 5 15 6 11 7 10 8 12 Compute the exponentially smoothed forecast (a = .20) for the given data. Compute an adjusted exponentially smoothed forecast (with a = .20 and β = .20) for the given data
Forecast sales for the 11th period. For leveling, use exponential smoothing 0.20 and moving average 3 for averaging; and linear and exponential functions for trend data. Assume an initial exponential forecast of 600 units in period 2 if you decide to use it (i.e., no forecast for period 1). Period 1 2 3 4 5 6 7 8 9 10 Sales 648 590 631 769 745 856 300 962 990 1100
Please do not give solution in image format thanku
Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with a = 0.4. Forecast the number of calls for week 6, which is next week. Week Actual Service Calls 26 2 34 38 4 27 5 35 The forecast for week 6 is service calls. (Enter your response rounded to two decimal places.)

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