Spreadsheet model-kps communications

Assignment Help Engineering Mathematics
Reference no: EM13962409

KPS Communications is planning to bring wireless Internet access to the town of Ames, Iowa. Using a geographic information system, KPS has divided Ames into the following 5 by 5 grid. The values in each block of the grid indicate the expected annual revenue (in $1,000s) that KPS will receive if it provides wireless Internet service to the geographic area represented by each block.

Expected Annual Revenue by Area (in $1,000s)

$34

$43

$62

$42

$34

$64

$43

$71

$48

$65

$57

$57

$51

$61

$30

$32

$38

70

$56

$40

$68

$73

$30

$56

$44

KPS can build wireless towers in any block in the grid at a cost of $150,000 per tower. Each tower can provide wireless service to the block it is in and to all adjacent blocks. (Blocks are considered to be adjacent if they share a side. Blocks touching only at corner points are not considered adjacent.) KPS would like to determine how many towers to build and where to build them to maximize profits in the first year of operations. (If a block can receive wireless service from two different towers, the revenue for that block should be counted only once.)

a. Create a spreadsheet model for this problem and solve it.

b. What is the optimal solution and how much money will KPS make in the first year?

c. Suppose KPS is required to provide wireless service to all of the blocks. What is the optimal solution and how much money will KPS make in the first year?

Reference no: EM13962409

Questions Cloud

Linear programming problem using graphical method : Find the complete (including values for slack variables) optimal solution to this linear programming problem using. graphical method
Determine the tension in the wire : A spherical buoy is tied to the sea bed by a steel wire so that exactly half the buoy is above the water surface. If the diameter of the buoy is 1.3m and the mass of the buoy is 20kg:- determine the tension in the wire.
Find equilibrium points and sketch them in the phase plane : A pendulum is modeled by a mass m, attached to one end of a light rod of lenght l, whose other end is attached to an axis. Write down the equation of motion (Newton's Law) modeling the pendulum. Rewrite the model as a system of two first order equ..
Determine the mutual inductance m between the two coils. : Starting from Ampere's law, calculate the self inductance of the coil, assuming that the cross sectional area of the coil is sufficiently small that we can assume that the magnetic field has constant strength inside the coil.
Spreadsheet model-kps communications : KPS Communications is planning to bring wireless Internet access to the town of Ames, Iowa. Using a geographic information system, KPS has divided Ames into the following 5 by 5 grid. The values in each block of the grid indicate the expected annu..
Purchase of the theatrical lighting system : If you were the purchasing agent for CSU what actions would you recommend regarding the purchase of the theatrical lighting system
Find the tension t in the cable and the horizontal : The system in the picture is in equilibrium. A concrete block of mass 225 kg hanfs from the end of the uniform strut whose mass is 45.0 kg. Find (a) the tension T in the cable and the (b) horizontal and (c) vertical force components on the strut f..
Show that the magnetic field at any point p : Derive an expression for the magnetic field at distance r from the axis where r
Calculate the length of the proposed section of train track : Determine how long it will take the milk to completely drain from the vat - Calculate the length of the proposed section of train track - Find the percentage of customers who have to wait more than 4 minutes.

Reviews

Write a Review

Engineering Mathematics Questions & Answers

  Prime number theorem

Dirichlet series

  Proof of bolzano-weierstrass to prove the intermediate value

Every convergent sequence contains either an increasing, or a decreasing subsequence.

  Antisymmetric relations

How many relations on A are both symmetric and antisymmetric?

  Distributed random variables

Daily Airlines fies from Amsterdam to London every day. The price of a ticket for this extremely popular flight route is $75. The aircraft has a passenger capacity of 150.

  Prepare a system of equations

How much money will Dave and Jane raise for charity

  Managing ashland multicomm services

This question is asking you to compare the likelihood of your getting 4 or more subscribers in a sample of 50 when the probability of a subscription has risen from 0.02 to 0.06.]  Talk about the comparison of probabilities in your explanation.

  Skew-symmetric matrices

Skew-symmetric matrices

  Type of taxes and rates in spokane wa

Describe the different type of taxes and their rates in Spokane WA.

  Stratified random sample

Suppose that in the four player game, the person who rolls the smallest number pays $5.00 to the person who rolls the largest number. Calculate each player's expected gain after one round.

  Find the probability density function

Find the probability density function.

  Develop a new linear programming for an aggregate production

Linear programming applied to Aggregate Production Planning of Flat Screen Monitor

  Discrete-time model for an economy

Discrete-time model for an economy

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