Problem a cellular phone company wants to locate two new

Assignment Help Operation Management

Reference no: EM13382511

Problem

A cellular phone company wants to locate two new communications towers to cover 4 regions. The company wants to minimize the cost of installing the two towers. The regions that can be covered by each tower site are indicated by a 1 in the following table:

	Tower Sites
Region	1	2	3	4
A		1		1
B	1		1	1
C	1	1	1
D	1			1
COST ($000s)	200	150	190	250

a) Word-process the linear programming model below.

Variables

X_i = 1, if the tower site 1 is selected and 0 otherwise.

wherei = 1, 2, 3 and 4

Objective Function

Constraints

b) Set up the spreadsheet for Excel Solver. Copy and paste the spreadsheet below.

c) Copy and paste the Answer report below.

d) Write the Optimal Solution below. Note: The Optimal Solutions must include the optimal values for the non-zero variables as well as the objective function.

Reference no: EM13382511

Questions Cloud

A railroad needs to move the maximum amount of material : a railroad needs to move the maximum amount of material through its rail network. the numbers given on the arcs are

A company needs to ship 100 units from seattle to denver at : a company needs to ship 100 units from seattle to denver at the lowest possible cost. the costs associated with

Finnish furniture manufactures tables in facilities located : finnish furniture manufactures tables in facilities located in three cities-reno denver and pittsburgh. the tables are

An investor has 500000 to invest and wants to maximize the : an investor has 500000 to invest and wants to maximize the money they will receive at the end of one year. they can

Problem a cellular phone company wants to locate two new : problem a cellular phone company wants to locate two new communications towers to cover 4 regions. the company wants to

The need for a centralized management structure that will : the need for a centralized management structure that will coordinate projects for organizations in the face of mounting

A project has an expected duration of 34 weeks with a : a project has an expected duration of 34 weeks with a critical path variance of 6. suppose the project network is given

You are required to submit an individual report of 3000 : you are required to submit an individual report of 3000 plusmn10 words which can be based on an organization or idea of

Part i interviewto gain an understanding of your selected : part i interviewto gain an understanding of your selected business units market position value proposition and

User Account

All Pages