Chapter 5, Problem 27QP

Transportation Problem (Solve using excel):   Acme Block Company has orders for 80 tons of concrete blocks at three suburban locations as follows:    Northwood -- 25 tons, Westwood -- 45 tons, and Eastwood -- 10 tons.  Acme has two plants, each of   which can produce 50 tons per week.  Delivery cost per ton from each plant to each suburban location is shown  in the attached image. How should end of week shipments be made to fill the above orders?

Cargo Loading. You are in charge of loading cargo ships for International Cargo Company (ICC) at a major East Coast port. You have been asked to prepare a loading plan for an ICC freighter bound for Africa. An agricultural commodities dealer would like to transport the following products aboard this ship:Commodity    Tons Available    Volume per Ton (cu.ft.)    Profit per Ton ($)1    4,000    40    702    3,000    25    503    2,000    60    604    1,000    50    80You can elect to load any or all of the available commodities. However, the ship has three cargo holds with the following capacity restrictions: Cargo Hold    Weight Capacity (tons)    Volume Capacity (cu.ft.)Forward    3,000    100,000Center    5,000    150,000Rear    2,000    120,000More than one type of commodity can be placed in the same cargo hold. However, because of balance considerations, the weight in the forward cargo hold must be within 10 percent of the weight in the rear cargo hold, and the center cargo hold…

Baton​ Rouge's Mt. Cedar Hospital is a​ large, private,​ 600-bed facility complete with​ laboratories, operating​ rooms, and​ X-ray equipment. In seeking to increase​ revenues, Mt.​ Cedar's administration has decided to make a​ 90-bed addition on a portion of adjacent land currently used for staff parking. The administrators feel that the​ labs, operating​ rooms, and​ X-ray department are not being fully utilized at present and do not need to be expanded to handle additional patients. The addition of 90 ​beds, however, involves deciding how many beds should be allocated to the medical staff​ (for medical​ patients) and how many to the surgical staff​ (for surgical​ patients).   The​ hospital's accounting and medical records departments have provided the following pertinent information. The average hospital stay for a medical patient is 8 days, and the average medical patient generates $2,280in revenues. The average surgical patient is in the hospital 5 days and generates $1,515 in…

The MidLands Trucking Company based in Louisvillehas eight trucks located throughout the Mideast that havedelivered their loads and are available for shipments. Through their Internet logistics site MidLands has re-ceived shipping requests from 12 customers. The follow-ing table shows the mileage for a truck to travel to a customer location, pick up the load, and deliver it. Determine the optimal assignment of trucks to customersthat will minimize the total mileage. Customers Truck A B C D E F G H I J K L1 500 730 620 410 550 600 390 480 670 710 440 5902 900 570 820 770 910 660 650 780 840 950 590 6703 630 660 750 540 680 750 810 560 710 1200 490 6504 870 1200 810 670 710 820 1200 630 700 900 540 6205 950 910 740 810 630 590 930 650 840 930 460 5606 1100 860 800 590 570 550 780 610 1300 840 550 7907 610 710 910 550 810 730 910 720 850 760 580 6308 560 690 660 640 720 670 830 690 880 1000 710 680

(a) Mohawk Valley Furniture Warehouse has purchased a retail outlet with six departments (A, B, C, D, E, and F), as shown below. The anticipated number of customers that move between the departments each week is given as follows: 70 and 50 customers move from department A to department B and F respectively; 100 customersmove from department B to department E; 70 customers move from department C to department B; 80 customers move from department D to department C; 40 and 30 customers move from department E to departments A and F respectively; and 60 and 100 customers move from department F to departments B and E respectively. The initial layout is given in the matrix below. (i) Construct the load summary chart for Mohawk's layout.) (ii) Evaluate the current layout in terms of non-adjacent loads.

A&B Transport Co. is a company that manages a food supply chain. The problem involves the delivery of cargo (canned peas) from four canneries (loading ports) to three destination ports, using tankers. Since the shipping costs are a major expense for the company, management is initiating a study to reduce them as much as possible. For the upcoming season, has come up with an estimation of the available output from each cannery. Furthermore, each destination port has also specific requirements for the total supply of peas that have to be satisfied. This information (in units of tanker loads), along with the shipping cost per tanker load for each loading - destination port combination, is given in Tables 1 and 2. The problem for the A&B Transport Co. is to determine the shipping strategy given the various loading - destination port combinations, so that the total shipping costs are minimised. Question 1 . A&B Transport Co is thinking of including in its strategy the shipment…

Kos Farms processes organic heirloom vegetables from its four processing plants where the vegetables are cleaned and packaged to its four warehouses. The following two tables show the capacities, forecasted demand, and processing and shipping costs.   Determine how many cases should be shipped from each processing plant to each warehouse to minimize the total processing and shipping costs.

The following network describes a transportation scenario in which there are four sources A, B, C, and D, and three destinations P, Q, and R. (The numbers next to each arrow represent the cost of transporting one unit from that particular source to the destination located at the other end of that arrow). Write the mathematical formulation of the problem. Use the Excel Solver to solve the problem. Generate the answer and sensitivity reports in Excel, and submit your Excel workbook as a separate attachment. Provide the solution obtained in the space provided. What is the optimal cost of transportation?

Microserve provides computer repair service on a contract basis to customers in five sections of the city. The five sections, the number of service contracts in each section, and the x and y coordinates of each section are as follows:   No. of   Coordinates Section Contracts   x   y   Parkview   70     5.2   8.3   Mt. Airy   200     3.6   3.0   Valley   70     13.6   7.2   Norwood   300     15.1   4.0   Southgate   170     13.8   8.7   Use the center-of-gravity method to determine an ideal location for a service center. Round your answers to two decimal places. Cx: ____________Cy: ____________   A supply chain manager faced with choosing among four possible locations has assessed each location according to the following criteria, where the weights reflect the importance of the criteria.       Location Criteria Weight 1 2 3 4 Raw material availability 0.06 P VG OK VG Infrastructute 0.07 P G VG OK Transportation costs 0.33 G P OK P Labor relations 0.25 VG G…