Introduction to Management Science please need specific answer. The spreadsheet
ID: 3278355 • Letter: I
Question
Introduction to Management Science
please need specific answer. The spreadsheet model (process) & algebraic model
Correct spreadsheet model, quality of spreadsheet model, correct algebraic model and explanations.
Learned
- Minimum spanning tree problem (MST, TSP)
- Travelling Salesman Problem (The Asymmetric TSP, The symmetric TSP)
- Facility Location problem (FLP)
Thanks a lot.
PLANET COLONIZATION (PuzzIoR) Colonizing a new planet where conditions are unpredictable and harsh is never easy. The primary concern when selecting a landing site for the first colony is the proximity to natural resources. Access to these valuable resources determines whether or not a new colony thrives or dies. The figure shows the front and rear views of a newly discovered planet. The planet has been divided into 20 areas, each of which is a potential landing site to establish a new colony. Some areas contain valuable resources (represented by colored icons) that are needed in order for the new colony to survive. Food is represented by the green ear of corn, Oxygen by the red 02, water by the blue drop, and energy by the orange lightning bolt. When choosing a landing site, it is best to minimize the distance between that site and the four needed resources. Distance is calculated by the number of units it takes to get to the resource. For example, if area 9 were selected as the landing site, the total travel distance required to reach all four resources would be 6 units (2 for Energy, 1 for Food, 1 for Water, and 2 for Oxygen) Which of the 20 areas is the best landing site to minimize the total distance you would have to travel to all four resources? 02Explanation / Answer
In this case we have to identify the landing site for best possible routes to get resources
so we will try trial and error method to identify the sites
and we start from area 1:
Landing site: area 1
total travel distance required to reach all resources: 8units (water 1, energy 1, food 2, oxygen 4)
Landing site : area 2
total traveling distance required : 8units (energy 0, water 2, food 3, oxygen 3)
Landing site: area 3
total traveling distance required: 12 units (energy 1, oxygen 2, water 4, food 5)
landing site : area 4
total traveling distance required: 10units (oxygen 1, water 3, energy 2, food 4)
Landing site : area 5
total traveling distance required: 14units (oxygen 2, energy 3, water 3, food 6)
landing site: area 6
total travelling distance required : 15units (water 2, oxyen 2, energy 4, food 7)
landing site : area 7
total traveling distance required: 6units (food 0, water 1, energy 2, oxygen 3)
landing site : area 8
total traveling distance: 7units(water 0, food 1, energy 2, oxygen 4)
landing site : area 9
total distance covered :6 units (given)
landing site :area 10
total distance covered :7 units(energy 1, oxygen 2, food 2, water 2)
landing site: area 11
distance covered: 8units (O2 1, food 2, energy 2, water 3)
landing site : area 12
distance covered :9units (energy 0, O2 2, water 3, food 4)
landing site: area 13
distance covered :7units (energy 1, oxygen 1, water 2, food 3)
landing site : area 14
distance covered: 8units (oxygen 0, water 2, energy 2, food 4)
landing site: area 15
distance covered: 9units (oxygen 1, water 1, energy 3, food 4)
landing site : area16
distance covered: 7units (water 0, oxygen 2, energy 3, food 2)
landing site : area 17
distance covered :9units (food 1, water 2, oxygen 2, energy 4)
landing site : area 18
distance covered:7units (water 1, oxygen 2, energy 2, food 2)
landing site : area 19
distance covered: 6units(oxygen 0, food 1, water 2, energy 3)
landing site: 20
distance covered: 7units (food 0, oxygen 1, water 3, energy 3)
therefore best landing sites are given in ascending order (best to worse)
areas:7,9,19,20,18,16,13,10,8,1,2,11,14,12,15,17,4, 3,5,6
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.