Recommendation to the leadership of freedom mobile

Assignment Help Operation Management

Reference no: EM132247426

Suppose that Freedom Mobile needs to build a set of cell towers to provide signal for residents of the Northern and Eastern Ontario. A number of potential locations for building the towers have been determined. The choice of these locations is based on several factors, including how well the tower blends in to the surrounding environment and the height of the terrain. The towers have a fixed range, and due to budget constraints only a limited number of them can be built. Given these restrictions, the company wishes to provide coverage to as large a fraction of the population as possible. To simplify the problem, the company has split the area it wishes into a set of regions, each of which has a known population. The goal is then to choose at which of the potential sites the company should build cell towers to provide coverage to as many people as possible. Assume that a total budget of 2 million dollars is available.

Region- Population (thousands)

1 - 523

2 - 690

3 - 420

4 - 1010

5 - 1200

6 850

7 400

8 1008

9 950

Tower Cost (hundred thousand) Regions Covered by Each Tower

1 4.2 1,2,6

2 6.1 1,8,9

3 5.2 3,4,5,6

4 5.5 3,6,7

5 4.8 1,3,7,8,9

6 9.2 4,5,9

1. Formulate algebraically a Binary/Integer Programming (BIP) model for this problem.

2. Use Excel Solver to solve the resulting BIP. (Include both formulation and answer report)

3. Describe clearly the optimal solution to this problem using a managerial statement to make a recommendation to the leadership of Freedom Mobile.

Reference no: EM132247426

Questions Cloud

The antitrust case on at and t-t mobile merger : In 2011, the second-largest US mobile wireless carrier AT&T (with a 25% market share) proposed to merger with the fourth-largest carrier T-Mobile,

Relations effort to improve organization public image : Which you evaluate a public relations effort to improve an organization's public image in the past year.

Formulate weighted goal programming : Formulate a weighted goal programming that can be used to minimize the penalty incurred by the company.

Describe the different marketing communication tools : Describe the different marketing communication tools you see being used? Which do you think s the most effictive?

Recommendation to the leadership of freedom mobile : Describe clearly the optimal solution to this problem using a managerial statement to make a recommendation to the leadership of Freedom Mobile.

Authority and control over the people at departmental : A person in power has the authority and control over the people at departmental, group or the whole organization.

Description of challenging professional experience : Post a description of positive professional experience when you felt motivated to perform at your best and a description of challenging professional experience

Company successfully in existing market segments : What are the benefits and risks of expanding into new market segments after having established the company successfully in existing market segments?

Agents actions can be implied through the principal actions : The principal's ratification of an agents actions can be implied through the principal's actions.

User Account

All Pages