15. The Vision Hospital is considering the purchase of a new Advance Scan machine. The decision will rest partly on the anticipate patients in the coming months. The numbers of patents during the past years are as follows: Year Number of patents(Actual) 1600 2200 2600 2800 2016 2017 2018 2019 2020 3100 Compute the forecast for the year 2021 using exponential smoothing with a forecast for the year 2016 of 1500 and a = 3

15. The Vision Hospital is considering the purchase of a new Advance Scan machine. The decision will rest partly on the anticipate patients in the coming months. The numbers of patents during the past years are as follows: Year Number of patents(Actual) 1600 2200 2600 2800 2016 2017 2018 2019 2020 3100 Compute the forecast for the year 2021 using exponential smoothing with a forecast for the year 2016 of 1500 and a = 3

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

Develop a 3-week moving average for the following time series Time Time Series Period Value |1 13 2 12 3 17 |4 15 6 15 15 Find the value for MSE. If needed round your intermediate calculations to no more than 2 decimal places. Round your final answer to 2 decimal places
Consider the following from an estate agent business: Month Houses Sold Jan 380 Feb 360 Mar 390 Apr 400 May 390 June 380 July 394 Aug 454 Sep 460 Oct 460 Nov 430 Dec 370 a) Calculate the three point moving averages (quarters) and seasonal variation for the above data b) A detective figures he has a one in nine chance of recovering stolen property. His out-of-pocket expenses for the investigation are $9,000. If he is paid his fee only if he recovers the stolen property, what should he charge clients in order to breakeven? c) At the races, your horse, has a probability of 1/20 of coming 151, 1/10 of coming 2nd and a probability of ¼ in coming 3rd. First place pays $4,500 to the winner, second place $3,500 and third place $1,500. Hence, is it worth entering the race if it costs $1,000? d) Your company plans to invest in a particular…
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 Pints Used 360 389 410 381 366 378 a) The forecasted demand for the week of October 12 using a 3-week moving average = 375 pints (round your response to two decimal places) b) Using a 3-week weighted moving average, with weights of 0.15, 0.25, and 0.60, using 0.60 for the most recent week, the forecasted demand for the week of October 12 = 150.10 pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.)
Tucson Machinery, Inc., manufactures numerically controlled machines, which sell for an average price of $14.0 million each. Sales for these NCMs for the past two years were as follows: Use Exhibit 3.10. QUARTER LAST YEAR I II III IV QUANTITY (UNITS) Y = 14 20 28 18 QUARTER THIS YEAR I II III IV QUANTITY (UNITS) 20 26 30 15 a. Find the equation of a simple linear regression line using Excel. (Round your answers to 3 decimal places.) > Answer is complete but not entirely correct. 18.535 X + 0.630 t
376.98 says its wrong
The Vision Hospital is considering the purchase of a new Advance Scan machine. The decision will rest partly on the anticipate patients in the coming months. The numbers of patents during the past years are as follows: Year Number of patents(Actual) 2016 1600 2017 2200 2018 2600 2019 2800 2020 3100 Compute the forecast for the year 2021 using exponential smoothing with a forecast for the year 2016 of 1500 and α = .3
Tom Simpson, Director of the Chamber of Commerce for Exeter township is investigating the past ten years of tourist visits to the area. The following data has been gathered on number of tourists who signed into the local information center. Year Number of tourists 1 700 2 248 3 633 4 458 5 1410 6 1588 7 1629 8 1301 9 1455 10 1989 What is the forecasts for Year 11 using the simple moving method? (show in calculations in excel file)
Pls do fast within 5 minutes and i will give like for sure Solution must be in typed form
Below is the number of complaints received in a department store for the first six months of operation: Month Complaints January February March April May June 37 48 84 96 114 148 If a three-month moving average is used to smooth this series, what would have been the forecast for July, rounded to the nearest whole number?
Apple Corporation is planning to produce their new product called the next generation low cost iPhone the said product will compete the product lines of Samsung, the management is hoping that it will further increase their revenue starting 2nd Quarter of 2021 Below is the historical data of actual sales and forecast of iPhone last 2020: Forecast Sales in Million Actual sales in Million Month Units Units Jan 51 55.3 Feb 52 54.1 Mar 53 62.3 Apr 55 61.1 May 57 58.6 June 60 59.2 July 62 67.3 Aug 65 70.2
The following table gives the number of pints of type A blood used at Damascus Hospital in the past 6 weeks: Week Of August 31 September 7 September 14 September 21 September 28 October 5 Week Of a) The forecasted demand for the week of October 12 using a 3-week moving average = pints (round your response to two decimal places). b) Using a 3-week weighted moving average, with weights of 0.10, 0.35, and 0.55, using 0.55 for the most recent week, the forecasted demand for the week October 12 pints (round your response to two decimal places and remember to use the weights in appropriate order the largest weight applies to most recent period and smallest weight applies to oldest period.) c) If the forecasted demand for the week of August 31 is 360 and a = 0.20, using exponential smoothing, develop the forecast for each of the weeks with the known demand and the forecast for the week of October 12 (round your responses to two decimal places). August 31 September 7 September 14 September 21…
I understand the moving average concept but not the weighted moving average and exponential smoothing