“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 2 Repair shop 1 Repair shop 2 500 Outlet 1 Repair shop 1 | 250 Repair shop 2 350 Outlet 3 Auction 1 550 Auction 2 600 300 500 450 650 450 Given the costs above, formulate this problem as a transshipment linear programming model to determine how many drones should be sent to each

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
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
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
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman