Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Bantr Communications is trying to determine where to locate new 5G cell towers. Bantr has identified 9 potential site locations for its new 5G cell

image text in transcribedimage text in transcribed
Bantr Communications is trying to determine where to locate new 5G cell towers. Bantr has identified 9 potential site locations for its new 5G cell towers. Each site location can reach a different number of potential cell phone subscribers, and each site location has different requirements in terms of cost and labor required to build a new 5G cell tower. Bantr Communications has limitations on both its financial budget and the labor hours it has available. This information is contained in the Excel file linked here: 5GTowers2.xlsx _ Use the provided Excel file to develop an optimization model that will maximize the potential number of subscribers reached by choosing where Bantr Communications should build its 5G cell towers. You will need to use binary decision variables in your model. Bantr Communications cannot exceed its available financial budget or exceed the number of labor hours it currently has available. You must also include a constraint that if Bantr Communications chooses to build a cell tower at Site 3 then it MUST also build a cell tower at Site 2. If Bantr Communications chooses to not build a cell tower at Site 3, then there is no restriction on whether or not a cell tower is built at Site 2. What is the maximum number of potential subscribers reached by Bantr Communications if it meets these constraints?A B C D E F G H J K 1 56 Cell Towers 2 3 Parameters 4 Possible 56 Cell Tower Locations 5 Site 1 Site 2 Site 3 Site 4 Site 5 Site 6 Site 7 Site 8 Site 9 6 Potential Subscribers Reached 37,000 28,000 31,000 26,000 48,000 56,000 23,000 45,000 24,000 7 Costs (5 million) 3.5 2.9 3.2 1.8 4.1 5.2 2.4 4.8 2.6 8 Labor Required (hours) 420 360 540 300 450 480 120 400 200 9 10 Budget Available (5 million) 25 1'1 LaborAvailable (hours) 2800 12 13 Model 14 Site 3 Site 4 Site 5 Site 6 Site 7 15 Build Tower Here? "IE 1? Subscribers Reached 18 19 Budget Used (5 million) 20 Labor Used (hours) 21 2

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Topological Methods In Group Theory

Authors: Ross Geoghegan

1st Edition

1441925643, 978-1441925640

More Books

Students also viewed these Mathematics questions

Question

Why do living creatures die? Can it be proved that they are reborn?

Answered: 1 week ago