Problem 7At Treasure Wine Estates in Napa, CA the Sales and Marketing Department have developed alinear trend equation that can be used to predict sales of its popular wine brands.Ft 90+ 12.5tWhereF₁ = Annual sales (000 bottles)t = yearsA. Are annual sales increasing or decreasing?B. By how much?C. Predict annual sales for year 8 using the equationNote: round your answer

Given data is Linear trend equation: Ft=90+12.5t A linear trend equation can be formed by taking the…

Answered: Problem 7 At Treasure Wine Estates in…

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

Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 20 2 20 Week 1 Demand 20 Forecast 20.0 3 29 4 37 4 37 5 24 2 3 29 20 6 30 7 8 37 24 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.55 and a week 1 initial forecast of 20.0 are (round your responses to two decimal places): 5 6 30 24 7 37 9 24 8 24 10 28 9 24 10 28
The actual demand of a product for six months are summarized in the table below: Month (t) Demand Dt 1 80 2 90 3 70 4 100 5 70 6 90 Find three months weighted moving averages by assuming the weights, W1 =1, W2 = 0.4 and W3 = 0.5 ii. Compute the mean forecast error iii. Compute the mean square error (MSE) iv. Compute the mean absolute deviation (MAD). v. Mean absolute percent error (MAPE)
b. The following table shows the number of televisions sold over the last ten years at a local electronic store. YEAR 1 2 3 4 5 6 TV SALES 150 300 480 600 630 640 700 825 900 980 7 8 9 10 i. Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all working. You will need to develop a table to calculate the slope and the intercept. ii. Use that formula to forecast television sales for years 11 and 12.
Mr Brown a small-scale manufacturer of musical instruments thinks that the demand for guitars may be related to the number of television appearances by the popular group Maroon 5 during the previous month. He has collected the data shown in the table attached; Using the least squares regression method derive a forecasting equation. Determine the estimate for guitar sales if Maroon 5 performed on TV nine times last month?
The Tech power plant burns coal and natural gas to generate steam and electricity for all campus buildings. The annual coal consumption at the plant has increased annually for the past 6 years due to an aggressive campus building program. The following table shows the annual coal consumption: Year Coal Consumption (tons) 1 25000 2 23000 3 28000 4 35000 5 37000 6 42000 Develop a linear trend model to forecast coal consumption for the 7 th year. Don't answer by pen paper and don't use chatgpt otherwise we will give dounvote
Sales of industrial vacuum cleaners at Larry Armstrong Supply Co. over the past I 3 months are shown below: a) Using a moving average with three periods, determine the demand for vacuum cleaners for next February.b) Using a weighted moving average with three periods, determine the demand for vacuum cleaners for February. Use 3, 2, and l for the weights of the most recent, second most recent, and third most recent periods, respectively. For example, if you were forecasting the demand for February, November would have a weight of l, December would have a weight of 2, and January would have a weight of3.c) Using MAD, determine which is the better forecast.d) What other factors might Armstrong consider in forecasting sales?
Use exponential smoothing with trend adjustment to forecast demand for period 11. Let α = 0.5, � = 0.3, and let the initial trend value be 12 and the initial forecast be 200
Demand for oil changes at Garcia's Garage has been as follows: Number of Oil Changes January 44 February 49 March 66 IT April 59 May 53 June 58 59 63 Month July August a. Use simple linear regression analysis to develop a forecasting model for monthly demand. In this application, the dependent variable, Y, is monthly demand and the independent variable, X, is the month. For Janu The forecasting model is given by the equation Y=+x. (Enter your responses rounded to two decimal places) J Show Transcribed Text >. Use the model to forecast demand for September, October, and November. Here, X=9, 10, and 11, respectively. (Enter your responses rounded to two decimal places.) Forecast for the number of Oil Changes Show Transcribed Text Month September October November can you do all the parts please corrrect
The monthly demand for units manufactured by the Acme Rocket Company has been as follows:Month Units Month UnitsMay 100 September 105June 80 October 110July 110 November 125August 115 December 120a. Use the exponential smoothing method to forecast the number of units for June to January. The initial forecast for May was 105 units; α = 0.2.b. Calculate the absolute percentage error for each month from June through December and the MAD and MAPE of forecast error as of the end of December.c. Calculate the tracking signal as of the end of December. What can you say about the performance of your forecasting method?
c. Prepare a naive forecast for periods 2 through 11 using the given sales data. Compute each of the following; (1) MSE, (2) MAD, (3) tracking signal at month 10, and (4) 2s control limits. (Negative values should be indicated by a minus sign. Round your answers to 2 decimal places.) Answer is complete but not entirely correct. MSE MAD Tracking signal Control limits 0 ± I+ 28.33 X 1,221.88 x -1.25 69.91
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
The following are the sales figures for 2018 through 2020 for a product. Data for ayear is available in two halves of the year, months January through June, and thenJuly through December (Half-year 2). Suppose we are interested in setting up a forecasting model using the exponentialsmoothing method for stationary processes with seasonality.a) Initialize the system based on the data provided for 2018 and 2019.b) Suppose the smoothing factors are ?= 0.1 and ?= 0.1. Forecast and update forthe first half of 2020 and then the second half of 2020 by incorporating the sales forthe first half of 2020 . Calculate the MAD based on 2020actuals and forecasts.c) Forecast sales for the two halves of 2021.

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