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

  Determine the mode for each given series

Given the following series of numbers, determine the mode for each series. Series A: 50, 45, 55, 55, 45, 50, 55, 45, 55 and Series B: 89, 87, 88, 83, 86, 82, 84.

  Circuit was in a dc steady state

Problem: The following circuit was in a DC steady state at t = 0- and the switch opened at t = 0.

  Write equations of three isoquants associated

If the prices of labor and capital are $20 and $60 per unit, respectively, find the least-cost combination of labor and capital for 360, 480, and 600 units of output.

  Discuss the change in behaviour as q increases

A model for the spruce budworm population u(t) is governed by du/dt = ru (1-u/q)-u2/(1+u2), Discuss the change in behaviour as q increases.

  Probability that an employee will have a cold next year

A. What is the probability that an employee will have a cold next year? b. Given that an employee is involved in an exercise program, what is the probability that he or she will get a cold next year?

  Problems basedn on probability issues

What is the probability that my right headlight will last for at least 1900 hours given that it has not failed after 950 hours?

  Linear programming model-optimal production scheduling mix

Formulate a linear programming model that can be used to determine the optimal production scheduling mix that yields the best contribution solution while meeting the inventory capacity restrictions of the division for the week.

  Changing the optimal product mix

What is the maximum increase in the sales quota without changing the optimal product mix? What is the change in the total profit if the profit per unit of PC is increased from 15 to 20

  The level of significance a normal distribution

What sampling distribution will you use? What assumptions are you making?

  Problem regarding the dynamic programming

A company is planning its advertising strategy for next year for its three major products. Since the three products are quite different, each advertising effort will focus on a single product.

  Question 11 consider efrons non-transitive dice where the 6

question 11 consider efrons non-transitive dice where the 6 faces as are in the table below.a suppose there are four

  Find the cost of the premier package to the nearest cent

The total cost of her new car was $34,290.08 which included the 6.5% sales tax. Find the cost of the Premier Package to the nearest cent.

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