Implement your model in a spreadsheet and solve it

Assignment Help Mathematics
Reference no: EM131248139

Eric Brown is responsible for upgrading the wireless network for his employer. He has identified seven possible locations to install new nodes for the network. Each node can provide service to different regions within the corporate campus. The cost of installing each node and the regions that can be served by each node are summarized:

Node 1: Regions 1,2,5 Cost $700

Node 2: Regions 3,6,7 Cost $600

Node 3: Regions 2,3,7,9 Cost $900

Node 4: Regions 1,3,6,10 Cost $1250

Node 5: REgions 2,4,6,8 Cost $850

Node 6: Regions 4,5,8,10 Cost $1000

Node 7: Regions 1,5,7,8,9 Cost $1100

Formulate an ILP for this problem

Implement your model in a spreadsheet and solve it

What is the optimal solution?

Reference no: EM131248139

Questions Cloud

Using present worth analysis : You want to start a restaurant business. Your initial investment is $10,000, borrowed at 4% annual rate. Your cash flow for (at the end of) years 1, 2, 3, 4 and 5 are respectively $2400, $3100, $2100, $4300 and $5000. Using Present worth analysis..
Challenges in establishing a network connection : In your option what are the challenges in establishing a network connection between two points over a large distance, describe your own knowledge of this network configuration.
Using to reduce the chance of having bad debts : Companies need to consider how to represent bad debt on their financial statements, as well as how to deal with it operationally. What method would you use to account for bad debts on the financial statement? What components of an operational approac..
What device do you most often use for your favorite program : What device do you most often use for your favorite program watching or other chosen media? Do you agree that you favor the device that gives you access to the information and programming that most meets your needs?
Implement your model in a spreadsheet and solve it : Eric Brown is responsible for upgrading the wireless network for his employer. He has identified seven possible locations to install new nodes for the network.
What views the mind as a complex symbol-manipulating system : According to __________, the child's mind, body, and physical and social worlds form an integrated system that guides mastery of new skills.
Uses job-order costing system with plant wide predetermined : Sharpton Fabricators Corporation manufactures a variety of parts for the automotive industry. The company uses a job-order costing system with a plant wide predetermined overhead rate based on direct labor-hours. what effect would this new rate have ..
Describe ryan tax consequences with respect to the purchase : Ryan, a lawyer, purchases shares of corporate stock for $20,000 in December of Year 1. At the end of Year 2, they are worth $17,000. He sells the shares in October of Year 3 for $13,000. Describe Ryan's tax consequences with respect to the purchas..
How should the venture capital contract be structured : Write the two incentive constraints in the presence of a venture capitalist and show that financing is feasible. - How should the venture capital contract be structured if these conditions are not satisfied?

Reviews

Write a Review

Mathematics Questions & Answers

  Write an integral that will give the total number of gallons

A car moving at a speed of v mph achieves 24 + 0.1v mpg (miles per gallon) for v between 20 and 60 mph. Your speed as a function of time, t, in hours, is given by v=50(t/t+1). Write an integral that will give the total number of gallons of gas con..

  How much dinitrogen pentoxide will remain after 30 minutes

How much dinitrogen pentoxide will remain after 30 minutes? How long will it take until 0.01 M of dinitrogen pentoxide remains?

  Asymptotes of the below function

Find the maximum and minimum, changes in concavity, intervals of increasing and decreasing, and asymptotes of the below function.y = xex

  Compute license plate sample space and probability

A mini license plate for a toy car must consist number followed by two letters. Each letter must must be a C, A or R. Each number must be a 3 or 7 Repetition of letters is permitted. License plate sample space and probability

  Determine the number of sample points in the sample space

One colored marker -red, yellow, or green - is selected and a coin is tossed. Use the counting principle to determine the number of sample points in the sample space.

  Asymptotes of trigonometric functions and graph

Asymptotes of trigonometric functions and Graph y = csc( 0.5x + pi/2) and y = cos( 0.5x + pi/2) on one set of coordinate axes.

  Use the equation of least squares line to predict percentage

Use the equation of least squares line to predict percentage

  Determine the average number of comparisons

Determine the average number of comparisons used over all m permutations.

  Plot the means and describe how the means vary with tool

Multiply each measurement by 0.04 to convert from millimeters to inches. Plot the means and run a two-way ANOVA using the transformed measurements. Summarize what parts of the analysis have changed and what parts have remained the same.

  Explain how to rephrase it in terms of an euler circuit

Describe the famous Königsberg bridge problem and explain how to rephrase it in terms of an Euler circuit.

  The number of women who use a computer at work

The number of women who use a computer at work in Elbonia can be modeled by the equation y = 8,793x + 18,001, where x is the number of years from now. How many Elbonian women will be using a computer at work 10 years from now if this trend continues?

  How fast is the distance between the two cars changing

A road running north to south crosses a road going east to west at the point P. How fast is the distance between the two cars changing?

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