7. The Atlantic Coast Conference (ACC) has four basketball games on a particular night. The conference office wants to assign four teams of officials to the four games in a way that will minimize the total distance traveled by the officials. The supply is always one team of officials, and the demand is for only one team of officials at each game. The distances in miles for each team of officials to each game location are shown in the following table: Game Sites Officials Raleigh Atlanta Durham Clemson A 210 90 180 160 B 100 70 130 200 C 175 105 140 170 D 80 65 105 120

7. The Atlantic Coast Conference (ACC) has four basketball games on a particular night. The conference office wants to assign four teams of officials to the four games in a way that will minimize the total distance traveled by the officials. The supply is always one team of officials, and the demand is for only one team of officials at each game. The distances in miles for each team of officials to each game location are shown in the following table: Game Sites Officials Raleigh Atlanta Durham Clemson A 210 90 180 160 B 100 70 130 200 C 175 105 140 170 D 80 65 105 120

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

KCS Ltd has got three production lines with the same production costs namely; K, L, and S whose production capacities are 140, 160, and 200 units respectively. These are marketed through four destinations B, C, J, and M having demands of 110, 150, 140, and 100 units respectively. The transportation cost between the production lines and market destinations are; K to B, K to C, K to J, K to M, L to B, L to C, L to J, L to M, S to B, S to C, S to J, and S to M as 18, 11, 13, 29, 19, 25, 15, 28, 24, 27, 19, and 12 respectively all costs are US dollars. a).Create a working table taking lines as rows and destinations as columns b). Determine the Cheapest route and Most expensive route to use c).Use the Northwest Corner Method to distribute the products d).Vogel’s Approximation Technique e).Compute their respective total costs incurred
ASAP PLEASE.. The distribution of goods from the source (factory) to the target (warehouse) will cause problems regarding TRANSPORT, namely how the goods are sent from the factory to the warehouse which produces minimum costs. If it is known that - the capacity of 3 factories is 40000, 30000 and 20000, - the need for 3 warehouses is 20000, 50000 and 30000 respectively. The cost of shipping goods from the factory to the warehouse is shown in the following table Solve the above TRANSPORTATION problems with VAM and MODI
A salesman for Healthproof Pharmaceutical Company travels each week from his office in Atlanta to one of five cities in the Southeast where he has clients. The travel time (in hours) between cities along interstate highways is shown along each branch in the following network: A. Determine the shortest route from Atlanta to each of the other five cities in the network. B. Assume that the network now represents six different communities in a city and that the local transportation authority wants to design a rail system that will connect all six communities with the minimum amount of track. The miles between each community are shown on each branch. Develop a minimal spanning tree for this problem.
The JPC Company has five different production jobs to complete next week. Five multipurpose machines, each with somewhat different characteristics are available. The estimated costs of completing each job on each of the five machines are as follows: Allocate each job to each machine for minimum cost: Job 2 was assigned to? what is total assignment cost?
Expedition companies headquartered in Bintaro want to developed its business in Medan, Balikpapan and Menado and will place 3 branch heads (Aria, Yuda and Roni) from several branch offices owned by the company in Central Java to set-up offices and run operations in 3 locations. Below is the cost to allocate the 3 branch heads to each location: branch head/ branch office Medan(3 Rp. 10.000) Balikpapan(3 Rp. 10.000) Manado (3 Rp. 10.000) ARIA 800 1100 1200 YUDA 500 1300 1300 RONI 500 1000 2300 a. Create a table using the assignment method.b. Based on the results of your calculations, what advice can you give to the most optimum company leaders of location placement of each branch head above? Explain why?c. What is the total optimum cost that must be incurred by the company to allocate to all branch offices of the company?
Grave City is considering the relocation of several police substations to obtain better enforcement in high-crime areas. The locations under consideration together with the areas that can be covered from these locations are given in the following table: Locations Areas A 1,4,7 B 1,3,5,7 C 1,2,5 D 2,5,6 E 3,4,7 F 4,6 Areas 2 and 6 must be covered by at least 2 locations. The rest of the areas must be covered by at least 1 location. What is the minimum number of locations?
NEED ALL 1. Nodes with only outflows (total outflows <= capcity) 2. Nodes with only inflows (total inflows >= demand) 3. Nodes with both outflows and inflows (total outflows = total inflows) 4. Network structure and flows (List of arcs in the network by (Origin, Destination) 5. Objective to minimize
Consider the following linear program. Max 2A + 3B s.t. 5A + 5B ≤ 350 Constraint 1 −1A + 1B ≤ 10 Constraint 2 1A + 3B ≥ 90 Constraint 3 A, B ≥ 0 Identify the optimal extreme point. What is the optimal solution? (A, B)= (30, 40) How much slack or surplus is associated with the nonbinding constraint? Constraint 3 is the nonbinding constraint. There is a surplus of _________ associated with this constraint. (THE QUESTION BEING ASKED)
The Thor International Company operates four factories that ship products to five warehouses. The shipping costs, requirements, and capacities are shown in the tableau below. Use the transportation method to find the shipping schedule that minimizes shipping cost. Factory Shipping Cost per Case to each Warehouse Capacity W1 W2 W3 W4 W5 Dummy F1 $4 $5 $4 $3 $6 $0 50,000 F2 $3 $4 $4 $5 $7 $0 80,000 F3 $3 $4 $5 $3 $5 $0 90,000 F4 $4 $6 $5 $6 $3 $0 40,000…
1. The approximate travel time for officiating crews for college basketball for four games scheduled for a weekend are shown in the following table: Game Site Crew Syracuse Buffalo Rochester Ithaca A 1.2 1.4 0.2 1.5 B 1.0 2.0 0.5 1.0 C 1.2 3.4 2.4 0.5 D 2.1 3.1 1.1 0.8 NOTE: Time in hours Use Excel to answer the following questions: What set of crew assignments will minimize travel time What is the total time required for the optimal assignment
Suisan Fish Company contracts with fishers in Hilo, Kona, and Puna, Big Island to purchase fishes. The fishes are cleaned and stored at the local processing facilities. Then the fishes are shipped to two plants, where they are cut, processed, and packaged as sushi and sashimi. The sushi and sashimi are then transported to three restaurants. The transportation costs per fish from the fishers to the plants and from the plants to the restaurants are summarized in the following tables: Determine the optimal shipments from fishers to plants and from plants to restaurants to minimize total transportation costs. Include the formulation and solver outputs. What would be the effect on the solutions if the capacity at each plant were 70 fishes?
Grave City is considering the relocation of several police substations to obtain better enforcement inhigh-crime areas. The locations under consideration together with the areas that can be covered fromthese locations are given in the following table: a) Formulate an integer programming model that could be used to find the minimum number oflocations necessary to provide coverage to all areas.b) Solve the problem in part (a).