a)
To determine: To determine the least square regression equation.
Introduction:
b)
To determine: The estimated sales tax collection when the new car registration total is 22,000.
c)
To determine: The correlation coefficient (r) and coefficient of determination (r2).
Want to see the full answer?
Check out a sample textbook solutionChapter 4 Solutions
Principles of Operations Management: Sustainability and Supply Chain Management, Student Value Edition Plus MyLab Operations Management with Pearson eText -- Access Card Package (10th Edition)
- Under what conditions might a firm use multiple forecasting methods?arrow_forwardGrace owns and operates a chain of 12 vegetable protein "hamburger" restaurants in northern Luzon. Sales figures and advertising expenses for the stores are provided in the table below. Sales are given in millions of dollars; advertising expenses are in tens of thousands of dollars. Calculate a regression line for the data. What is your forecast of sales for a store with advertising spending of $240,000? $300,000? Vince Coffee chain sells temperature-controlled smart mugs at $150 each. The monthly sales of mugs for the last twelve months were: Given: Month Sales January 825 February 756 March 808 April 950 May 678 June 875 July 695 August 589 September 690 October 890 November 1030 December 1525 a. Compute a 3-month moving average demand forecast for each month from June through December. b. Compute a 5-month moving average demand forecast for each month from June through December. c. Calculate the MSE…arrow_forwardUse regression analysis to forecast the point at which Swansonneeds to '·build out" the top two floors of the new building,namely, when demand will exceed 16,000 births.arrow_forward
- What are the similarities and differences between ridge regression and forecasting?arrow_forward24,000-seat arena that is home to the city’s professional basketball and ice hockey teams and that hosts a variety of concerts, trade shows, and conventions throughout the year. The hotel has experienced the following occupancy rates for the past 9 years, since the coliseum opened. Compute an exponentially smoothed forecast with an α value of .20. According to the result from Excel and/or POM-QM, the forecast for the year 5 would be (type number only, two decimals) 1 83 2 78 3 75 4 81 5 86 6 85 7 89 8 90 9 86arrow_forward(8 points) Infoworks is a large computer discount store that sells computers and ancillary equipment and software in the town where a State University is located. Infoworks has collected historical data on computer sales and printer sales for the past 10 years, as follows: Develop a linear regression model relating printer sales to computer sales in order to forecast printer demand in year 11 if 1,300 computers are sold. Develop a moving-average model with n = 3 to forecast printer demand in year 11 Develop an exponential smoothing model with α = .30 to forecast printer demand in year 11. Compare your result in a, b, c. Which model would you choose and why?arrow_forward
- The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year 1 2 3 4 5 Mileage 3,000 3,950 3,500 3,750 3,800 Part 2 a) Using a 2-year moving average, the forecast for year 6 = 37753775 miles (round your response to the nearest whole number). Part 3 b) If a 2-year moving average is used to make the forecast, the MAD based on this = enter your response here miles (round your response to one decimal place). (Hint: You will have only 3 years of matched data.)arrow_forwardThe Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to be driven next year. The miles driven during the past 5 years are as follows: Year 1 2 3 4 5 Mileage 3,000 3,950 3,500 3,750 3,800 Part 2 a) Using a 2-year moving average, the forecast for year 6 = 37753775 miles (round your response to the nearest whole number). Part 3 b) If a 2-year moving average is used to make the forecast, the MAD based on this = 7575 miles (round your response to onedecimal place). (Hint: You will have only 3 years of matched data.) Part 4 c) The forecast for year 6 using a weighted 2-year moving average with weights of 0.40 and 0.60 (the weight of 0.60 is for the most recent period) = 37803780 miles (round your response to the nearest whole number). Part 5 The MAD…arrow_forwardSelecting from MAD, MAPD, MSE, E, and , which measure of forecast accuracy do you consider superior? Why?arrow_forward
- Explain how does adjusted exponential smoothing different from exponential smoothing?arrow_forwardfor the last week, daily high temperatures in st.louis were as follows: 93, 94, 93, 95, 96, 88 and 90. i. calculate the mean absolute deviation based on a 2-day moving average. ii. compute the mean squared error for the 2-day moving average. iii. calculate the mean absolute percent error fort he 2-day moving average.arrow_forwardExplain how is moving average approach related to exponential smoothing?arrow_forward
- Contemporary MarketingMarketingISBN:9780357033777Author:Louis E. Boone, David L. KurtzPublisher:Cengage LearningMarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing