The Port of Savannah is considering an expansion of its container terminal. The port has experienced the following container throughput during the past 12 years, expressed as TEUs (i.e., 20-foot equivalent units, a standard unit of measure for containers): Year TEUs (1,000s) 1 526.1 2 549.4 3 606.0 4 627.0 5 695.7 6 734.9 7 761.1 8 845.4 9 1,021.1 10 1,137.1 11 1,173.6 12 1,233.4 a. Develop a linear trend line forecast for these data and forecast the number of TEUs for year 13. b. How strong is the linear relationship for these data?

The Port of Savannah is considering an expansion of its container terminal. The port has experienced the following container throughput during the past 12 years, expressed as TEUs (i.e., 20-foot equivalent units, a standard unit of measure for containers): Year TEUs (1,000s) 1 526.1 2 549.4 3 606.0 4 627.0 5 695.7 6 734.9 7 761.1 8 845.4 9 1,021.1 10 1,137.1 11 1,173.6 12 1,233.4 a. Develop a linear trend line forecast for these data and forecast the number of TEUs for year 13. b. How strong is the linear relationship for these data?

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter4: Linear Programming Models

Section4.8: Data Envelopment Analysis (dea)

Problem 42P

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?
A ready-to-drink juice manufacturing Plant had recorded a total annual production of 11,124,095.87 L of product with an annual water usage of 108,009 cu.m for the year 2019. In the year 2020, the Plant had produced 9,720,885.51 L using 82,103 cu.m of water. The Plant expresses its water use efficiency (WUE) in terms of volume of water used/volume of product produced and the goal is to achieve a WUE of 9.5. a) What is the Plant's WUE in the year 2019? b) What is the Plant's WUE in the year 2020?
The City of High Point is buying new school buses for the local school system. High Point has found two models of school buses that it is interested in. Eagle Mover costs $80,000 to buy and uses diesel fuel, with an average fuel efficiency of 10 miles per gallon. Eagle Mover has an operating cost of $.28 per mile. Yellow Transport, a hybrid bus, costs $105,000 to buy and uses diesel fuel and battery power, getting an average of 22 miles per gallon. Yellow Transport has an operating cost of $.32 per mile. The distance traveled annually is determined to be 25,000 miles, with the expected life of either bus to be 10 years. The average diesel price is $3.50 per gallon.
Cost Allocation; Cost Shifting In the last several years, airlines have succeeded in boosting profits by adding fees for previously free services such as in-flight snacks and meals, checked baggage, priority boarding, and other services. These fees have caused some shifts in customer behavior, as more airline passengers bring their own snacks on the airline and pack a smaller bag that is acceptable for “carry-on”. By using carry-on luggage, the airline customer can save $25 or more in baggage-checking fees. This situation has resulted in a cost shifting for passengers, airlines, and airport security. As the number of checked bag decreases, the cost of baggage handling for the airlines decreases (and revenues increase for those bags that are checked). In contrast, the costs and delays in security checkpoints increase as security personnel must check additional carry-on bags, causing delays for passengers and the need for additional security personnel to handle the increased number of…
Silicon Valley Transport Commission (SVTC) has a fleet of maintenance vehicles that includes cars, vans, and trucks. SVTC is currently evaluating four different approaches to help them maintain their fleet of cars and vans efficiently at the lowest possible cost. Their options are: (1) No preventive maintenance at all and repair vehicle components when they fail; (2) Take oil samples at regular intervals and perform whatever preventive maintenance is indicated by the oil analysis; (3) Perform an oil change on a regular basis on each vehicle and perform repairs when needed; (4) perform oil changes at regular intervals, take oil samples regularly, and perform maintenance repairs as indicated by the sample analysis. Option #1 costs nothing to implement and results in two possible outcomes: There is a .10 probability that a defective component will occur, requiring emergency maintenance at a cost of $1,200, or there is a chance that no defects will occur and no maintenance will be…
The operations manager for an auto supply company is evaluating the potential purchase of a new machine for the production of a transmission component. Current manufacturing costs are fixed costs of $11,000 and a variable cost of $0.50 per unit. The new machine would have fixed cost of $4,000 and a variable cost of $0.75 per unit. Each component is sold for $1.50 per unit. (use a excel file to show all calculations) 1.Develop two separate models in your spreadsheet to calculate Total Profit for each option.The models must be flexible and able to calculate Total profit for any Quantity produced. 2.Find the break-even quantity for each option 3. Graph the Total profit for each option vs Quantity (both lines on one graph) Show Quantity from 0 to 50,000 4.Write an interpretation of your graph
Palisades Eco-Park is a small ecological reserve that admits a relatively small number of visitors on any day, but provides both educational and entertaining lectures, exhibitions, and opportunities to observe nature. The company has collected the following data on labor costs and number of visitors to the park over the last 30 months. Month Labor Cost Visitors 1 $ 26,720 2,600 2 $ 37,555 3,964 3 $ 41,361 4,299 4 $ 32,751 3,398 5 $ 36,022 3,630 6 $ 33,811 3,336 7 $ 33,139 3,372 8 $ 39,671 4,093 9 $ 39,912 4,222 10 $ 48,568 5,463 11 $ 43,627 4,551 12 $ 40,390 4,289 13 $ 35,644 3,694 14 $ 34,330 3,573 15 $ 38,260 3,836 16 $ 27,424 3,210 17 $ 31,732 5,195 18 $ 31,005 4,260 19 $ 28,552 3,689 20 $ 31,049 4,546 21 $ 26,588 3,058 22 $ 25,515 2,744 23 $ 29,899 4,997 24 $ 31,204 5,838 25 $ 29,099 3,964 26 $ 32,795 5,007 27 $ 29,650 4,572 28 $ 30,970 4,665 29 $ 29,429 3,841 30 $ 28,846 3,174 Required: a. Estimate the labor…
Many students have their lunch and dinner in the Student Canteen in the school For many years, it has been the most-frequented canteen at the university. However, users of the canteen often report dissatisfaction with it. Identify one or more problems, suggest some possible solutions, then decide which of these solutions is the best and support your position. (Apart from the chef problems )!!!!!!
Techno Corporation is currently manufacturing an item at variable costs of $5 per unit. Annual fixed costs of manufacturing this item are $140,000. The current selling price of the item is $10 per unit, and the annual sales volume is 30,000 units.a. Techno can substantially improve the item’s quality by installing new equipment at additional annual fixed costs of $60,000. Variable costs per unit would increase by $1, but, as more of the better-quality product could be sold, the annual volume would increase to 50,000 units. Should Techno buy the new equipment and maintain the current price of the item? Why or why not?b. Alternatively, Techno could increase the selling price to $11 per unit. However, the annual sales volume would be limited to 45,000 units. Should Techno buy the new equipment and raise the price of the item? Why or why not?
Reliable Transportation Company limited is involved in the transportation of products for several manufactures island wide. In recent times the Government of Jamaica through the China Harbour Engineering Company (CHEC) has been involved in road infrastructural development island wide. Senior management of Reliable transportation has established several nodal points throughout the island including at the 2 major airports and they have hired you in the capacity of consultant to operations. Briefly state (Bullet points) to the senior management team three main types of risks and mitigation strategies as Reliable transports a shipment between 3 nodes.
DuLarge Marine manufactures diesel engines for shrimp trawlers and other small commercial boats. One of their automated machines has caused several problems. Over the past 30 weeks, the machine has broken down as indicated below. Each time the machine breaks down, the firm loses an average of $3,000 in time and repair expenses. If preventive maintenance were implemented, it is estimated that an average of only one breakdown per week would occur. The cost of preventive maintenance is $1,000 per week. Number of breakdowns per week 0 1 2 3 4 Frequency (Number of weeks that breakdowns occurred) 8 3 5 9 5 What is the weekly total maintenance cost of this program? Given the following data, find the expected breakdown cost. The cost per breakdown is $200. Number of breakdowns per week 0 1 2 3 4 Weekly frequency 5 12 10 18 5 13) Great Southern Consultants Group's computer system has been down several times over the…