helpplease I need it in excel 7. Freight car loadings over a 12-year period at a busy port are as follows:WeekNumberWeekNumberWeekNumber220350134602458.360144752809.400155004275103801651030011420175256.3101245018541a. Determine a linear trend line for expected freight car loadings.b. Use the trend equation to predict expected loadings for weeks 20 and 21.c. The manager intends to install new equipment when the volume exceeds 800 loadings per week.Assuming the current trend continues, the loading volume will reach that level in approximatelywhat week?7.

Given data: Week Number 1 220 2 245 3 280 4 275 5 300 6 310 7 350 8 360 9 400…

Answered: 7. Freight car loadings over a 12-year…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter5: Network Models

Section5.5: Shortest Path Models

Problem 32P

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?
The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.
Freight car loadings over a 12-year period at a busy port are as follows:Week Number Week Number Week Number1 220 7 350 13 4602 245 8 360 14 4753 280 9 400 15 5004 275 10 380 16 5105 300 11 420 17 5256 310 12 450 18 541a. Determine a linear trend line for expected freight car loadings.b. Use the trend equation to predict expected loadings for weeks 20 and 21.c. The manager intends to install new equipment when the volume exceeds 800 loadings per week.Assuming the current trend continues, the loading volume will reach that level in approximatelywhat week?
Freight car loadings over an 18-week period at a busy port are as follows:Weeks Loadings (lbs) Weeks Loadings (lbs) Weeks Loadings (lbs) 1 370 7 415 13 450 2 380 8 425 14 455 3 390 9 435 15 475 4 380 10 425 16 485 5 390 11 435 17 495 6 395 12 445 18 505a. Determine a linear trend line for expected freight car loadings.b. Use the above trend equation to predict expected loadings for Weeks 20 & 21.c. The manager intends to install new equipment when the volume exceeds 950 loadings per week. Assuming the current trend continues, in which week…
Problem 7 At Treasure Wine Estates in Napa, CA the Sales and Marketing Department have developed a linear trend equation that can be used to predict sales of its popular wine brands. Ft 90+ 12.5t Where F₁ = Annual sales (000 bottles) t = years A. Are annual sales increasing or decreasing? B. By how much? C. Predict annual sales for year 8 using the equation Note: round your answer
Suppose a four-period weighted average is being used to forecast demand. Weights for the periods are as follows: wt-4 = 0.1, wt-3 = 0.2, wt-2 = 0.3 and wt-1 = 0.4. Demand observed in the previous four periods was as follows: At-4 = 380, At-3 = 410, At-2 = 390, and At-1 = 400. What will be the demand forecast for period t?
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.
4 Trinity General Hospital had the following number of patient admissions during the past 8 weeksWeek Patient Admissions1 1202 1453 954 1125 1306 1107 1008 140 a. Develop a 3-week weighted average forecast forWeek 4 through 9 with weightsW1 = 0.2W2 = 0.3W3 = 0.5 b. Forecast patient admissions for week 9 using simpleexponential smoothing with α = 0.2. Assume that the forecast for Week 2 (F2) is the naïve forecast.

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

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

Contemporary Marketing

Marketing

ISBN:

9780357033777

Author:

Louis E. Boone, David L. Kurtz

Publisher:

Cengage Learning

SEE MORE TEXTBOOKS