Data collected on the yearly registrations for a Six Sigma seminar at the Quality College Year 1 4.00 Year Forecast (000) 2 3 7.00 5.00 1 2 5.00 4.6 4 5 4.00 9.00 Registrations (000) a) Calculate the forecasted registrations for years 2 through 12 using exponential smoothing, with a smoothing constant (a) of 0.40 and a starting forecast of 5.00 for year 1 (round your responses to one dece place) 3 4 5.56 5.34 6 9.00 5 4.80 11 9 8 10 7 6.00 10.00 13.00 14.00 12.00 7 8 6 6.48 7.49 6.89 9 8.14 11 10 12 10.08 11.64 11.79 b) Mean absolute deviation based on the forecast developed using the exponential smoothing method (with a smoothing constant (a)= 0.40 and a starting forecast of F, = 5.00) is response to one decimal place). registrations (round your

Assume Sandra's forecasted ADR for the night is $1600.99. What would be her estimated total room revenue for this day? ADR = Total room revenue / Number of rooms sold

376.98 says its wrong

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)

A police station had to deploy a police officer for an emergency multiple times in the last four evenings. The t below shows the number of emergencies each evening. Weekday Number of calls each day Monday 10 Tuesday 2 Wednesday 12 Thursday 12 (Round your answer to 1 decimal place.) What would be their forecast for the emergencies on Friday using a two-day moving average approach? Forecast for Friday calls

Café Michigan's manager, Gary Stark, suspects that demand for mocha latte coffees depends on the price being charged. Based on historical observations, Gary has gathered the following data, which show the numbers of these coffees sold over six different price values: D Price $2.50 $3.40 $2.10 $4.30 $3.00 $4.10 Using simple linear regression and given that the price per cup is $1.75, the forecasted demand for mocha latte coffees will be cups (enter your response rounded to one decimal place). Number Sold 765 515 975 245 315 480

Give typed explanation Part 2: Using exponential smoothing, the forecasted demand for period 5 using the smoothing constant determined in image= ?

A concert promoter is forecasting this year's attendance for one of his concerts based on the following historical data:   Year Attendance Four Years ago 10,000 Three Years ago 12,000 Two Years ago 18,000 Last Year 20,000   What is this year's forecast using exponential smoothing with alpha = 0.2, if last year's smoothed forecast was 15,000?

Please answer fast please arjent help please

The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 10 months. Compute an exponentially smoothed forecast with an a value of .30. According to the result from Excel and/or POM-QM, the forecast for the month of January would be (type number only, two decimals) Month October November December January February March April May June July 733.25 Gasoline Demanded (gal.) 800 725 630 500 645 690 730 810 1,200 980