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

Xi = 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

Reviews

Write a Review

 

Operation Management Questions & Answers

  What characteristics of data are represented in e-r diagram

Conceptual Modeling looks at how the data is structured and what the characteristics of the data are. What characteristics of data are represented in an E-R diagram?

  In what ways does this benefit a project

Some companies choose not to tie resources to their projects. In what ways does this benefit a project? In what ways does this hinder a project?

  What role does language competencies play in addressing

What role does language competencies play in addressing the challenges in managing a global business?

  Discuss the role of sensitivity analysis in lp

Discuss the role of sensitivity analysis in LP. Under what circumstances is it needed and under what conditions do you think it is not necessary?

  Company competitive advantage please respond to the

company competitive advantage please respond to the followingbullpropose two ways that a company can gain a competitive

  Set up the cost calcuations in the spreadsheet

You may want to try using Excel Solver to find a solutions remember that your final solution need an interger number of lines and an interger number of overtime hours for each quaters (solutions that requires 8.9134 lines and 1.256 hours of overti..

  What is expected value

What is expected value? How do consumers factor expected value into their decision making?

  Determine the recommended order quantity

The GAC company is considering the purchase of a special shipment of portable air conditioners manufacted in japan. each unit will cost 80 and it will be sold for 125.

  Examine the ways in which the obligations ideals and effects

Examine the ways in which the obligations, ideals, and effects that you have outlines might conflict with one another, and propose how you would resolve those conflicts.

  Why it is important to the corporate development process

For this discussion, research and find one corporate university (that is not Hamburger U) and identify how that program is used and why it is important to the corporate development process.

  Solution to linear programming model

Frank Hurley is the farmer with 250 acres on which he wishes to plant wheat and corn to maximize his expected return for season. Based upon the output, what key points would you recommend to Frank?

  Determine the marketing planning process

Understand the key elements of business marketing including product, price, distribution, and promotion and determine the marketing planning process, market segmentation, and the development of the key elements of a marketing strategy.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd