BUSN9970: Question 1: Cell Tower Optimization Challenge – Covering Problem : Prescriptive Analytics for Decision Making

Published: 17 Mar, 2025

Category	Assignment	Subject	Business
University	University of Kent (UOK)	Module Title	BUSN9970 Prescriptive Analytics for Decision Making

Question 1: Cell Tower Optimization Challenge – Covering Problem

Imagine you are part of a strategic planning team for a telecom company that aims to enhance mobile signal coverage in a bustling urban environment. The company has identified several potential locations for new cell towers, each with the capacity to provide coverage to surrounding areas. However, due to budget constraints, the company can only afford to build a limited number of towers. To tackle this challenge effectively, the city has been divided into several distinct regions, each with its own population density.

The following table illustrates which regions (columns) are covered by each cell tower site(rows).

BUSN9970 Prescriptive Analytics for Decision Making

Do You Need Assignment of This Question

Order Non Plagiarized Assignment

The cost to build a cell tower at each location site is stated in the following table.

BUSN9970 Prescriptive Analytics for Decision Making

The allocated budget is $20,000,000.

Objective:

The primary goal is to maximize the total population that receives reliable signal coverage from the towers.

Requirements:

Decision Variables: Clearly define the decision variables that will represent the locations of the cell towers.
Objective Function: Formulate an objective function that captures the essence of maximizing population coverage.
Constraints: Identify and explain any constraints that must be considered, including budget limitations and coverage range of the towers.

Your task is:

a. Devise an optimization model (mathematical formulation) that will help the company determine the most effective locations for the cell towers.
b. Code this model using OPL + Cplex and solve the problem.
c. Present the optimal solution and the optimal value and discuss the percentages of population covered and the budget utilised.

Request Answer of this Assignment

Share this with your Friends

Facebook

Instagram

Are you having trouble understanding BUSN9970 Prescriptive Analytics for Decision Making Assignment? Don't worry! We bring you the best online assignment help in UK. With our business management assignment help service, you will get original content that is AI-free and human-written. We complete your assignment before the deadline so that you can submit it without any stress. We also offer free assignment samples that will help you clear your concepts. Now stop stressing and get expert help! Order Now!

Top Assignment Services

Get 100% AI & Plagiarism Free Work, Connect With Our Writers Now!

Let's Book Your Work with Our Expert and Get High-Quality Content

BAE_6_NTI New Technology Innovation Assignment Brief 2025

BAE_6_NTI: Understand and be able to analyse the tech start up space, including various tech sectors, as well as the international corporate innovation space.

View or Download

BMGT2210 Creating a High Performance Workforce Assignment Brief

BMGT2210 Task 1: Using a case study approach, select two of the following HR functions. You may wish to consider the role of this professional function in relation to a single company or in terms of more than one organisation.

R/650/2920 – Unit 20: Organisational Behaviour Management Sem. 2 Assignment 1 Brief

Unit 20: Organizational culture is defined as a system of shared meaning held by members that distinguishes the organization from other organizations (Robin and Judge, 2018).

R/650/2920 – Unit 20: Organisational Behaviour Management Assignment 2 Brief 2025

BTEC Unit 20: LO1: Reflect on own personality and perceptions to understand how individual difference informs and influences management approaches. LO2: Apply content and process theories of motivation to create and maintain an effective workforce.

GBM5MSM Digital Marketing and Social Media for a Global Market Assignment Brief - UOS

GBM5MSM Task 1: Group Presentation 50% Marks Create a PowerPoint presentation in groups (equivalent to 500 words) to pitch your campaign, covering the targeted market, objectives, target audience, projected success, promotional mix, and potential positive impact (LO1,LO2, LO3, LO4).

BUS700 Economics Term 1 2025 – Individual Assessment 3 Brief

CMP111 Obtain the following macroeconomic data for Australia for the period 2002-2024: real GDP and real GDP growth rates, un employment rates, inflation rates, interest rates (cash rates), exchange rates (US$ per A$), exports and imports.

CMP111: Information Systems and Databases Assessment Brief 1

CMP111: Identify and define the requirements of a database system for a given scenario. Discuss industry standard information systems and database tools.

MECH419/928 Finite Element Methods in Engineering Assignment 1 Brief - UOW

MECH419/928: The assignment may be completed individually or by a group (of maximum 2 members). Members may be from the same or different tutorial groups.

ACC701 Financial Accounting T125 Brief KOI

This is a core subject for the Master of Accounting and the Master of Professional Accounting and elective subject for the Graduate Diploma of Business.