2. Unbalanced. Provide the transportation model for the calculation of cost given the following data:Use the Stepping Stone Method to solve the following. Use degeneracy method or dummy method if necessary. 2. UNBALANCED. Provide the transportation model for the calculation of cost given thefollowing data:To=>3SupplyL6FromA200L7B300L5L5L6300Demand400200100-END-

Answered: Image /qna-images/answer/9960c664-6afd-4e0f-9bd6-d844a86484f1.jpg

Answered: 2. UNBALANCED. Provide the…

2. UNBALANCED. Provide the transportation model for the calculation of cost given the following data: To> 3 Supply From A 200 300 LS L5 L6 300 Demand 400 200 100 2.

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

Weighted factor methodUse the table to calculate the most ideal X coordinate for supermarket Point Quantity offered/requested Transportation costs Coordinate X Coordinate Y Supermarket 1 3,000 0.04 4 8 Supermarket 2 3,500 0.04 7 2 Supermarket 3 2,000 0.07 3 5 Supermarket 4 1,500 0.07 7 4 Supermarket 5 1,200 0.07 6 8
7. Novelis at Oswego NY supplies rolled aluminum sheets to Ford Motor's Kansas City plant to make F150 truck. The transportation manager of Novelis needs to choose from rail, waterway, and truck. The following information are gathered to make the transportation mode decision: Transportation Mode Transit Time, Days Rate $/cwt Shipment Size, cwt Rail 15 $2.50 12,000 Waterway 20 $0.80 200,000 4 $12.50 4,000 Truck The annual transportation volume is 2.5 million cwt. The value of aluminum is $500 per cwt. Inventory carrying cost for both companies is 20% per year. Please calculate the total logistics costs (transportation, inventory at Novelis, inventory at Ford, inventory in transit), and decide which transportation mode should be selected. (20 points)
Q2. Pharmaceutical company producing asingle product sold it through five agencies situated in different cities. All of sudden there rouse a demand for the product in another five cities that didn't agency of the company. The company is now facing the problem of deciding on how to assign the existing agencies in order to dispatch the product to needy cities in such a waythat the travelling distance is minimized. The distance between the surplus and deficit cities in kilometer is given the following table. Surplus city Deficit cities Deficit cites A1 160 130 115 190 200 B1 135 120 130 160 175 C1 140 110 125 170 185 D1 50 50 80 80 110 E1 55 35 80 80 105 Determine the optimum assignment schedule.
JuicyJuicy Company is a dairy manufacturing company in Serdang, Malaysia. This company isthe supplier of dairy products to a number of hypermarkets in the Serdang area. It is critical thateach order be delivered (shipped) and arrive at a specified time to ensure the quality of theirproducts and a good relationship with the buyers. However, for the past two weeks the productscannot reach the location on time. Resulted to that, they are getting many complaints from thecustomers and considering to switch to other suppliers. Thus, the company must overcome theproblem as quickly as possible. (a) Recommend a suitable quality tool that could identify the problem and to monitor thebusiness performance. Please explain and justify your suggestion. (b) Develop the selected tool (answer in part (a)) to show how it can clarify all possiblecauses and solution to the issue.
Monczka-T rcnt Shipping is t he logistics vendorfor Handfield Manufacturing Co. in Ohio. Handfield has dailyshipments of a power-steering pump from its Ohio plant to an autoassembly line in Alabama. The value of the standard shipment is$250,000. Monczka-Trent has two options: ( I) its standard 2-dayshipment or (2) a subcontractor who will team drive overnightwith an effective delivery of one day. The extra driver costs $175.Handfield's holding cost is 35% annually for this kind of inventory.a) Which option is more economical?b) What productio n issues a re not included in the datapresented?
2) Using the cost table of the transportation problem shown below, do the following: a) Develop the appropriate LP model of the problem. WAREHOUSE PLANT A B C D DEMAND 1 5 10 7 20 200 2 3 12 5 25 400 3 8 10 10 18 600 4 7 8 12 30 1000 SUPPLY 200 500 300 1000
The Bright Company wants to figure out the best way to ship their new product, Flying Widgets, from their factories through their warehouses to their retail outlets. They would like to set up a Transhipment table so they can use POM to find the least cost shipping routes. They have hired you to set up the Transhipment table based on the information below. You will be paid handsomely if you can come up with the correct table. Shipping Costs Shipping Costs 01 02 03 04 Wi W2 W3 W1 4. 2 F1 4 W2 4 F2 4 2 W3 4. 3. 4. Also, Flying Widgets can be shipped from Factory 1 to Factory 2 for $3 per unit. Factory 1 can produce 300 units and factory 2 can produce 100 units. Outlet 1 demand is 50 units, Outlet 2 is 150 units, Outlet 3 is 100 units, and Outlet 4 is 100 units.
What is the initial total cost of the given transportation model if an Intuitive Approach method is applied? DESTINATION SOURCE DEMAND O 3050 O 3140 O 3045 O 3040 X Y N 4 P 75 8 12 S 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
Ancient history of logistics distribution regarding probability?
3. Figure 1 Daily Subway and Bus Use in Five Major Cities 0.75 0.5 0.25 Subway OBus London Tokyo Singapore Hong Kong Figure 2 Subway vs. Bus Ridership, New York City OBus Subway 1970 1980 1990 2000 2010 Information in figure I suggests that public transportation users in London Information in Figure I supports the author's point that buses are growing in popularity as a means of urban transport by indicating that A) take subways and buses at similar rates. B) are unusually reliant on buses. C) take at least one subway trip daily. D) take subways at about the same rate as people A) many people around the world take at least one bus trip every day. B) bus ridership surpasses subway ridership in some major cities. C) people in Tokyo make far more trips by bus daily than they do trips by subway. D) the number of bus trips taken by people in major cities has substantially increased. in New York. 2 Which of the following statements about bus use in New York City is best supported by…
es Problem 11-4 (LO2) An appliance manufacturer has a plant near Toronto that receives small electric motors from a manufacturer located in Winnipeg. The demand for motors is 118,000 units per year. The cost of each motor is $125. The motors are purchased in lots of 3.400 units. The ownership of motors transfers to the appliance manufacturer in Winnipeg. The question is which mode of transportation, truck or train, the appliance manufacturer should use to bring the motors from Winnipeg to Toronto. The railroad company charges $3 per motor. and it takes approximately seven days by train. The trucking company charges $5 per motor, but it takes only three days. The appliance manufacturer will keep 1,400 units as safety stock if a truck is used and 2.500 units as safety stock if a train is used for transportation. Assume 365 days per year. If the holding cost rate is 25 percent of unit cost per year, which mode of transportation will minimize total transportation and in-transit and safety…
Problem 15-2 (Algo) Determine which shipping alternative would be most economical to ship 100 boxes of parts when each box has a price of $200 and holding costs are 30 percent of price, given this shipping information: overnight, $300, two-day, $260, six-day, $180. (Round your intermediate calculations to 2 decimal places.) Two day O Overnight O Six day