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

LSC-40049 Medical Microbiology Assessment Brief | Keele University

LSC-40049: 1. To provide you an opportunity to develop and evidence your ability to evaluate the current and future diagnostics for a specific disease/organism. 2. Introduce you to the benefits and limitations of using artificial intelligence (AI) technology to assist your work.

View or Download

COM7032M Artificial Intelligence Concepts Assignment Guidance

COM7032M Artificial Intelligence Concepts: Task One: GROUP BASED TASK (Group of three students maximum) This assignment aims at preparing you to develop a critical understanding in Artificial Intelligence in general, and Intelligent Tutoring Systems in specific.

L7 Project and Organisational Strategy Assignment Brief | University of Law

1. Understand how organisations deliver their strategic objectives through projects. 2. Understand the different approaches to project design and the situations where these approaches are more (or less) relevant.

MK998 International Services Marketing Sm2 Assignment Brief

MK998 Assignment Task: Develop a photo essay on the St Mungo Museum of Religious Life and Art which captures the following pre-defined elements of the experience

ARC 156 Massing Model of Building & Site: Drafting & Detailing – Steel & Masonry Assignment 4

This assignment asks students to make a massing model of the building and site with sustainable strategies. A massing model is a dimensionally accurate summary of the fundamental exterior forms of a building and how it relates to its site.

CHEM1136 – Forensic Science : Final Year Design Project 2024-25 | UoG

The objective is to produce ADO10 Industry specification diesel for sale to the UK market. Process Safety & Reliability are essential. Teams should aim to minimise product specification ‘giveaway’, an indication of over processing.

LCMB723 Human Capital Management L7 Assessment 1 Brief

Identify the factors that are more important to Gen X, Gen Y, and Gen Z in their receptivity to international assignments. (1,500 words). Critically discusses how factors such as culture, personality and skills/experience may impact generational differences. (1,000 words).

LBR7456 Global Public Health: A Social Context Approach Module Assessment Information

LBR7456: LO1: Define and appraise the term global health and critically discuss the role of globalization, global institutions and global health governance that influence health at global, national and local levels

LCMB7002 Financial Management L7 Essay Assessment Brief

This assignment is comprised of two discrete tasks that each align with one of the learning outcomes described above. One is an informal report based on a five-year evaluation of the financial management and performance of a London Stock Exchange (LSE) FTSE 100 listed company. This report relates to learning outcome one. The second task, covering learning outcome two, is an essay on a particular aspect of financial making and the main issues and theoretical frameworks related to the topic.

Fundamentals of Senior Management, Assessment Portfolio | UWS

This module is assessed through a Portfolio weighted 70% and an Individual Essay weighted at 30%. To pass the module you need to pass each component with at least 40% but overall