The number of students enrolled at Orchid Valley Elementary has been steadily increasing over the past five years. The school board would like to forecast enrollment for years 6 & 7 in order to better plan capacity. Use a linear trend line to forecast enrollment for years 6 & 7. Year Enrollment 1 220 2 245 3 256 4 289 5 310

The number of students enrolled at Orchid Valley Elementary has been steadily increasing over the past five years. The school board would like to forecast enrollment for years 6 & 7 in order to better plan capacity. Use a linear trend line to forecast enrollment for years 6 & 7. Year Enrollment 1 220 2 245 3 256 4 289 5 310

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter9: Decision Making Under Uncertainty

Section: Chapter Questions

Problem 46P

See similar textbooks

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Under what conditions might a firm use multiple forecasting methods?
Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 3 year moving average? What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?
Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361 What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?
12.4. The chairperson of the department of management at Tech wants to forecast the number of students who will enroll in operations management next semester in order to determine how many sections to schedule. The chair has accumulated the following enrollment data for the past eight semesters: Students Enrolled Semester in OM 1 270 2 310 250 4 290 370 6. 410 7 400 8. 450 a. Compute a three-semester moving average forecast for semesters 4 through 9. b. Compute the exponentially smoothed forecast (a = .20) for the enrollment data. c. Compare the two forecasts using MAD and indicate the most accurate. 3.
As you can see in the following table, demand for heart transplant surgery at Washington General Hospital has increased steadily in the past few years: Year 1 2 3 4 5 Heart Transplants 48.0 50.0 52.0 57.0 58.0 The director of medical services predicted 6 years ago that demand in year 1 would be 44.0 surgeries. a) Using exponential smoothing with α of 0.60 and the given forecast for year 1, the forecasts for years 2 through 6 are (round your responses to one decimal place): Year 1 2 3 4 5 6 Forecast 44.0 nothing nothing nothing
Give typed answer Question: Use an exponential smoothing model with a =.4 to forecast issues remediated for periods 6-10. (Assume a beginning forecast of 320 for period 5). 1. Forecast Period 6 (August) : ? 2. Forecast Period 7 (September) : ? 3. Forecast Period 8 (October) : ? 4. Forecast Period 9 (November) : ? 5. Forecast Period 10 (December) : ?
3) Seasonality: The following data represent dinner sales at a busy restaurant. Use linear regression to predict sales for each day of week 5 and the total sales for week 5. Estimate the percentage of weekly sales that occur over the weekend (include Friday, Saturday, and Sunday). Finally, determine which days of the week are increasing and decreasing in sales, using the slopes of the LR lines. Week Mon Wed Fri Sat Sun Tue 177 170 Thu 190 Total 270 152 180 321 386 166 218 203 402 427 167 333 357 229 3 158 170 170 205 163 173 158 225 349 433 212 a) Graph the seasonal data and attach the graph to this page. b) Determine the slope for each day of the week. Mon Tue Wed Thu Fri Sat Sun Total Slope c) Estimate the percentage of weekend sales in week 5: d) For which day are sales increasing the fastest? e) For which day are sales decreasing the fastest?
In the past, Peter Kelle's tire dealership in Baton Rouge sold an average of 1,200 radials each year. In the past 2 years, 240 and 260, respectively were sold in fall, 350 and 310 in winter, 140 and 165 in spring, and 300 and 635 in summer. With a major expansion planned, Kelle projects sales next year to increase to 1,200 radials. Based on next year's projected sales, what is the demand for summer going to be (enter your responses as whole numbers): 468 250 330 153
The manager of Redline Trucking believes that the demand for tires used on his trucks is closely related to the number of miles driven. He has collected the following data covering the past four months. Month 1 2 3 4 Tires Used 100 150 120 80 Miles Driven 15,000 20,000 17,000 11,000 Write an algebraic equation forecasting the demand for tires. Indicate and explain the independenet and dependant variables and the parameters used in your equation.
Sales of Volkswagen's popular Beetle have grown steadily at auto dealerships in Nevada during the past 5 years (see table below). Using exponential smoothing with a smoothing constant (α) of 0.30 and a starting forecast of 420.00, the following sales forecast has been developed: Year Sales Forecasted Sales 1 460 420.00 2 510 432.00 3 520 455.40 Using smoothing constants of 0.60 and 0.90, develop forecasts for the sales of VW Beetles. Use MAD to determine which of the three smoothing constants (0.30, 0.60, or 0.90) gives the most accurate forecast. The MAD for a forecast developed using exponential smoothing with α=0.30 is nothing sales. (Round your response to two decimal places.)