1.) Old Wildcat Bourbon has two distilleries and two bottling plants across the state of Kentucky. The distilleries ship barrels of bourbon to the bottling plants in order for the product to be bottled and sold. The cost per barrel of shipping the bourbon from each distillery to each bottling plant is given in the following table: To: From: Versailles $20 $35 Richmond $32 $15 Athens Paris The distillery in Athens will produce 250 barrels each month, and the distillery in Paris will produce 400 barrels each month, and every barrel produced must be bottled immediately. The Versailles plant can bottle up to 300 barrels each month, and the Richmond plant can bottle up to 350 barrels each month. How many barrels should be shipped from each distillery to each bottling plant in order to minimize the shipping cost?

1.) Old Wildcat Bourbon has two distilleries and two bottling plants across the state of Kentucky. The distilleries ship barrels of bourbon to the bottling plants in order for the product to be bottled and sold. The cost per barrel of shipping the bourbon from each distillery to each bottling plant is given in the following table: To: From: Versailles $20 $35 Richmond $32 $15 Athens Paris The distillery in Athens will produce 250 barrels each month, and the distillery in Paris will produce 400 barrels each month, and every barrel produced must be bottled immediately. The Versailles plant can bottle up to 300 barrels each month, and the Richmond plant can bottle up to 350 barrels each month. How many barrels should be shipped from each distillery to each bottling plant in order to minimize the shipping cost?

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

Qn1. Find the optimal solution to the transportation problem using MODI method. Warehouses Supply WI W2 W3 W4 P1 19 30 50 12 Plants 5. 2. P2 70 30 40 60 P3 40 10 60 20 3. 15 Demand 4)
4. Companies A, B, and C supply components to three plants (F, G, and H) via two crossdocking facilities (D and E). It costs $4 to ship from D regardless of final destination and $3 to ship to E regardless of supplier. Shipping to D from A, B, and C costs $3, $4, and $5, respectively, and shipping from E to F, G, and H costs $10, $9, and $8, respectively. Suppliers A, B, and C can provide 200, 300 and 500 units respectively and plants F, G, and H need 350, 450, and 200 units respectively. Crossdock facilities D and E can handle 600 and 700 units, respectively. Logistics Manager, Aretha Franklin, had previously used "Chain of Fools" as her supply chain consulting company, but now turns to you for some solid advice. Set up the solution in Excel and solve with Solver. What are total costs?
Here is the initial tableau (by the NorthWest method) of a Min transportation problem. 1 2 3 Demand 19 Dual(v) 1 15 9 S1: 11 10 14 0 S2: 0 S3: B 0 B 3 N 15 Demanders 2 8 0 9 12 188 15 9 21 5 N 0 B 0 B 13 10 8 8 20 3 0 20 -4 N -6 N 0 B 17 7 5 4 0 0 1 -14 N -8 N 0 B Supply Dual(u) 0 (188 188 188 188 Using the Loop method fill in the values of the next tableau Each 2x2 matrix is the relevant square in the tableau. 9 (For grading convenience, in bottom right corner of each box use 1 for "B" and 0 for "N") 22 188 188 188 30 -4 2
1.
Problem 1. The number of salespeople assigned to work during a shift is apportioned based on the average number of customers during that shift. Apportion 20 salespeople given the information below. Shift Morning Midday Afternoon Evening The average number of customers 95 305 435 515 Determine the apportionment using Hamilton’s Method Jefferson’s Method Webster Method Huntington-Hill Method
2. A company has plants at locations A, B and C with the daily capacity to produce chemicals to a maximum of 3000 kg, 1000 kg and 2000 kg respectively. The cost of production (per kg) are P800, P900 and P750 respectively. Customer's requirement of chemicals per day is as follows: Customer Chemical Required Price offered 2000 200 2 1000 215 3 2500 225 1000 200 Transportation cost per kg from plant locations to customer's place is given in table. Customer 2 3 A 5 7 10 12 Plant B 3 4 2 с 3 Find the transportation schedule that minimizes the total transportation cost.
"A chipboard company has 4 factories, Mazatenango, Retalhuleu, Escuintla and Xela. It has four major distributors of its chipboards, which are distributor 1, distributor 2, distributor 3 and distributor 4: Mazatenango Retalhuleu Escuintla Xela DEMAND D1 10 16 19 12 350 D2 12 10 18 15 300 D3 15 22 10 10 250 D4 20 10 12 20 200 SUPPLY 150 150 350 250 1) Formulate the problem as a transportation problem, solve it with the three methods and find the optimal cost for this problem. methods and find the optimal cost for this transportation problem. (remember to go through all possible routes). IN THIS CASE USE MINIMUM TRANSPORTATION COST - LEAST COST METHOD
Jk.335. Propiem 14-8 Rent'R Cars is a multisite car rental company in the city. It is trying out a new "return the car to the location most convenient for you" policy to improve customer service. But this means that the company has to constantly move cars around the city to maintain required levels of vehicle availability. The supply and demand for economy cars, and the total cost of moving these vehicles between sites, are shown below. From To A B C Demand D $9 9 5 50 From/To $8 Candidate solution A B C Total shipped Cost A - B C Total costs 8 3 60 $6 8 3 25 $5 D 0 10 a. Find the solution that minimizes moving costs using Microsoft Excel. (Leave no cells blank - be certain to enter "0" wherever required.) Supply 50 40 75 30 165 165 E F G Supply $
Please this
20. Suppose that one wishes to schedule vehicles from a central depot to five customer locations. The cost of making trips between each pair of locations is given in the following matrix. (Assume that the depot is location 0.) Cost Matrix (c) то 1 2 3 4 5 75 33 10 30 15 42 F 1 35 20 R 2 18 58 3 40 20 M 4 25 Assume that these costs correspond to distances between locations and that each vehicle is constrained to travel no more than 50 miles on each route. Find the routing suggested by the savings method. 20
5
LM.91 XYZ Company is rethinking the way it ships to its 74 customers in another city 222 miles away. Current Shipping/Delivery Method They currently hire an LTL (less-than-truckload) carrier to pick up and deliver these shipments. Each customer order shipped via LTL carrier costs $126. Alternate Shipping/Delivery Method A 3PL (third-party logistics provider) has approached XYZ Company and suggested that they make full truckload (TL) shipments from their facility to the 3PL's warehouse in the customers' city. The 3PL would then break the bulk shipment (TL or truckload shipment) into individual customer orders to be shipped locally by an LTL carrier. The relative data for this alternate shipping method are as follows: • Full TL shipment cost (222 miles) = $740 Average weight per customer order = 500 Ibs. • Warehouse break-bulk fee (per 100 lbs., a.k.a. per "hundred weight") = $13 • Local LTL delivery fee (per customer order) = $38 What is the total cost of delivering to all customers via…