“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

College Algebra (MindTap Course List)
12th Edition
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:R. David Gustafson, Jeff Hughes
Chapter6: Linear Systems
Section6.8: Linear Programming
Problem 5SC: If during the following year it is predicted that each comedy skit will generate 30 thousand and...
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
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Intermediate Algebra
Intermediate Algebra
Algebra
ISBN:
9780998625720
Author:
Lynn Marecek
Publisher:
OpenStax College