Factory |
Supply |
Warehouse |
Demand |
Indianapolis |
15 |
Columbus |
10 |
Phoenix |
6 |
St. Louis |
12 |
New York |
14 |
Denver |
15 |
Atlanta |
11 |
Los Angeles |
9 |
|
Shipping Costs per case (In Dollars0 |
|||
From |
To Columbus |
To St. Louis |
To Denver |
To Los Angeles |
Indianapolis |
25 |
35 |
36 |
60 |
phoenix |
55 |
30 |
25 |
25 |
New York |
40 |
50 |
80 |
90 |
Atlanta |
30 |
40 |
66 |
75 |
a. the optimal schedule can be obtained as given below using VAM
Shipping Costs per case (In Dollars0 | |||||||||
From | To Columbus | To St. Louis | To Denver | To Los Angeles | Supply | Penalty1 | Penalty2 | penalty3 | penalty4 |
Indianapolis | 25 | 35 | 36 (15) | 60 | 15 | 10 | 10 | - | |
phoenix | 55 | 30 | 25 | 25 (6) | 6 | 0 | - | - | |
New York | 40 | 50 (12) | 80 | 90(2) | 14 | 10 | 10 | 10 | 40 |
Atlanta | 30 (10) | 40 | 66 | 75(1) | 11 | 10 | 10 | 36 | 35 |
Demand | 10 | 12 | 15 | 9 | 46 | ||||
penalty1 | 5 | 5 | 11 | 35 | |||||
penalty2 | 5 | 5 | 30 | 15 | |||||
penalty3 | 10 | 10 | - | 15 | |||||
penalty4 | - | 10 | - | 15 |
the optimal schedule is
From Indianapolis to Denver- 15 units
From phoenix to Los Angeles - 6 units
From New York to St. Louis- 12 units
From New York to Los Angeles- 2 units
From Atlanta to Columbus- 10 units
From Atlanta to Los Angeles- 1 unit
1. ABC pharmaceutical Company has four factories supplying four warehouses. The company’s management hires you as...
13. A tin box company has four factories that supply to 5 warehouses. The variable cost of manufacturing and shipment of one ton of product from each factory to each warehouse are shown in the matrix given below, Factory capacities and warehouse requirements are shown in the margin. After several iterations the solution obtained is also shown. Warehouses (Cost in Rs. per unit) A A B C D E Factories DMY Capacity 179 14 0 75 14 25 11 15...
International Paper Company has four warehouses at different cities: Buffalo, Detroit, Pittsburgh and Raleigh. They provide paper to five book publishers in Boston, New York, Chicago, Indianapolis and Memphis. The costs of shipping one box of paper, the amount of paper (in boxes) available at each warehouse, and the amount of paper ordered (in boxes) by each publisher are found in the table below: From / To Boston New York Chicago Indianapolis Memphis Supply Buffalo 9 7 11 12 13...
2. A company has factories at A, B and C which supply warehouses at D, E and F. Weekly factory capacities are 200, 160 and 90 units respectively. Weekly warehouse requirements (demands) are 180, 120 and 150 units respectively. Unit shipping costs are as follows: Factory A B C Demand D E F Capacity 16 20 1 2 | 200 14 8 18 160 26241690 180 120 150 450 Determine the optimum distribution for this company to minimize shipping costs.
The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows: Click on the datafile logo to reference the data. DATA file Albuquerque Atlanta Austin Baltimore Boston Charlotte Chicago Cincinnati Cleveland Columbus Dallas Denver Detroit El Paso Fresno Indianapolis 23.3 28.3 24.6 32.1 31.7 25.8 38.1 24.9 26.8 23.4 28.5 28.1 29.3 24.4 23.0 24.8 Jacksonville Kansas City Las Vegas Little...
To complete this project you have to make a presentation of 10 slides and a written report on the following: Transportation models and its usage. Analyze the following facility location case and solve it as a linear program formulation. Which of the new locations will yield the lowest cost for the firm in combination with the existing plants and warehouses? The Hardgrave Machine Company produces computer components at its plants in Cincinnati, Salt Lake City, and Pittsburgh. These plants have...
Why is L75 different than the Third Quartile? I can easily find 3rd Quartile using excel. I'm not sure how to find L75 though? Thank you!! The average number of minutes Americans commute to work is 27.7 minutes (Sterling's Best Places, April 13, 2012). The average commute time in minutes for 48 cities are as follows: Click on the datafile logo to reference the data. DATA file Albuquerque 23.3 Jacksonville 26.2 Phoenix 28.3 Atlanta 28.3 Kansas City 23.4 Pittsburgh 25.0...
You collect data on 26 metropolitan areas to analyze average monthly debt payments in terms of income and the unemployment rate. The data are shown in the accompanying table. Use Table 4 Income Metropolitan Area (in $1,000s) Unemployment et Washington, D.C. Seattle Baltimore Boston S1,285 1,135 1,133 1,133 1,104 1,098 1,076 1,045 1,024 1,017 1,011 1,011 989 986 970 957 $103.5 6.3% 82.2 89.5 75.9 93.4 75.5 73.1 68.2 75.1 78.3 84.0 78.3 San Francisco San Diego Sacramento Los Angeles...
BADM 3963 Transportation & Assignment models homework Write the formulations for #1, 2, 3 in a Word document NOTE: for decision variables, you may type them as X11, X12, X13 etc without subscripting format. Solve the transportation problems #4, 5 on the tables in the same Word document- show work on the table as well as reporting the solution and cost. Submit Word file in BB Assignment Due 4/25, 9pm 1. Consider a small company with three sources of supply:...
Question 2: How do the average credit scores of people living in various cities in the US differ? The file Credit Score Data of 143 American cities is provided in Canvas. Construct a histogram Create a Five Summary Report Calculate Mean, Variance and Standard Deviation What conclusion can you reach concerning the average credit scores of people living in different American cities? City State Average Credit Score Detroit Mi 743 New York NY 762 Minneapolis MN 787 Hartford CT 774...
The Language Is SQL The language is SQL 13- List full details of agents with first names having exactly three or four letters sorted by the state attribute. 14- List the first name, the last name, the address, the city, the state, the branch number, and the email of agents working in the branch 8005 and having email addresses from yahoo.com. 15-List the first name, the last name, the address, the city, the state, the branch number, and the email...