MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
6th Edition
ISBN: 9781119256830
Author: Amos Gilat
Publisher: John Wiley & Sons Inc
Bartleby Related Questions Icon

Related questions

Question

Transshipment 

please use excel sheet for the answer 

"Droning on" is a company that refurbishes crashed drones (a surprisingly large market!). They
buy 15 damaged drones at each of two auctions each week held at different locations. It then
transports the drones to repair shops it contracts with. When they are restored to Droning on's
specifications, they sell 10 each to three different used drone outlets. There are various costs
associated with the transportation prices from each auction to each repair shop. Also, there are
transportation costs from the repair shops to the used drone outlets. Droning On is concerned
with minimizing its total cost given the costs in the table below.
Outlet 1
Outlet 2
Repair shop 1 Repair shop 2
500
Outlet 3
Auction 1 550
Auction 2 600
Repair shop 1
Repair shop 2 350
250
500
300
650
450
450
Given the costs above, formulate this problem as a transshipment linear programming model to
determine how many drones should be sent to each
expand button
Transcribed Image Text:"Droning on" is a company that refurbishes crashed drones (a surprisingly large market!). They buy 15 damaged drones at each of two auctions each week held at different locations. It then transports the drones to repair shops it contracts with. When they are restored to Droning on's specifications, they sell 10 each to three different used drone outlets. There are various costs associated with the transportation prices from each auction to each repair shop. Also, there are transportation costs from the repair shops to the used drone outlets. Droning On is concerned with minimizing its total cost given the costs in the table below. Outlet 1 Outlet 2 Repair shop 1 Repair shop 2 500 Outlet 3 Auction 1 550 Auction 2 600 Repair shop 1 Repair shop 2 350 250 500 300 650 450 450 Given the costs above, formulate this problem as a transshipment linear programming model to determine how many drones should be sent to each
Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Recommended textbooks for you
Text book image
MATLAB: An Introduction with Applications
Statistics
ISBN:9781119256830
Author:Amos Gilat
Publisher:John Wiley & Sons Inc
Text book image
Probability and Statistics for Engineering and th...
Statistics
ISBN:9781305251809
Author:Jay L. Devore
Publisher:Cengage Learning
Text book image
Statistics for The Behavioral Sciences (MindTap C...
Statistics
ISBN:9781305504912
Author:Frederick J Gravetter, Larry B. Wallnau
Publisher:Cengage Learning
Text book image
Elementary Statistics: Picturing the World (7th E...
Statistics
ISBN:9780134683416
Author:Ron Larson, Betsy Farber
Publisher:PEARSON
Text book image
The Basic Practice of Statistics
Statistics
ISBN:9781319042578
Author:David S. Moore, William I. Notz, Michael A. Fligner
Publisher:W. H. Freeman
Text book image
Introduction to the Practice of Statistics
Statistics
ISBN:9781319013387
Author:David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:W. H. Freeman