Write the optimal solution

Assignment Help Operation Management

Reference no: EM13217120

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: EM13217120

Questions Cloud

Examine real-world business problems : Analyze real-world business problems and generate recommendations for action. Integrate accounting, marketing, finance, management, and economics into a strategic business analysis.

Prepare the optimal solution : Write the Optimal Solution and the Optimal Solutions should include the optimal values for the non-zero variables as well as the objective function.

Determine the range of values : Two slender rods of negligible weight are pin-connected at A and attached to the 18-lb block B and the 80-lb block C. The coefficient of static friction is 0.55 between all surfaces of contact. Determine the range of values of P for which equilibr..

Define the federal motor carrier safety administration : Lonestar Trucking, a large freight servicing the Southwest, learns from reading in the industry trade magazine that the Federal Motor Carrier Safety Administration (FMCSA) has proposed a regulation change.

Write the optimal solution : 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.

Calculate the magnitude of the force : the cable from C to D prevents the plate and shaft from turning, and the weight of the assembly is carried by hearing A.

State consumer behavior and discuss the underlying premise : Define consumer behavior and discuss the underlying premise of consumer behavior, the marketing concept. Why is consumer behavior rooted in the marketing concept? How does customer value and customer satisfaction play into the marketing concept?

Determine the time duration t of the elevator run : The main elevator A of the CN Tower in Toronto rises about 349 m and for most of its run has a constant speed of 22 km/h. Assume that both the acceleration and deceleration have a constant magnitude of g/3 and determine the time duration t of the ..

Calculate the height h to which the ball rises : A ball is thrown vertically up with a velocity of 91 ft/sec at the edge of a 190-ft cliff. Calculate (a) the height h to which the ball rises and (b) the total time t after release for the ball to reach the bottom of the cliff.

User Account

All Pages