Formulate an integer programming model using excel solver, Operation Management

Assignment Help:

New fire stations are to be located in a city and the major of the city wants to decide where to locate the 2 fire stations. For planning purposes, the region has been divided into five tracts, with no more than one fire station to be located in any given tract. The decisions to be made consist of the tracts to receive a fire station and the assignment of each of the tracts to one of the fire stations. The objective is to minimize the overall average of the response times to fires.

The following table gives the average response times to a fire in each tract if that tract is served by a station in a given tract. The bottom row gives the forecasted number of fires that will occur in each of the tracts per day.

Formulate an integer programming model for this problem and solve it using Excel Solver.


Related Discussions:- Formulate an integer programming model using excel solver

Factors for best path for data among two points on a network, Name three fa...

Name three factors that a router must consider when determining the best path for data between two points on a network?

Explain what are average weekly total costs, Given the following data for a...

Given the following data for a particular inventory item: Usage 500 units/week Ordering $40 per order Carrying Cost $.01 per unit per week Lead Time 3 weeks Price $.50 per unit a.

Describe trade-offs between the competitive dimensions, In your organizatio...

In your organization, describe how there are trade-offs between the competitive dimensions. Give examples.

Explain how many pounds of pepperoni would you order, Charlie's Pizza order...

Charlie's Pizza orders all of its pepperoni, olives, anchovies, and mozzarella cheese to be shipped directly from Italy. An American distributor stops by every eight weeks to take

Explain define the behaviour of leaders modelling excellence, Describe the ...

Describe the behaviours of leaders modelling excellence. How do you assess excellence and how does that inspire you to perform at higher level?

Substitute favourable market unfavourable market build, Karen Villagomez, p...

Karen Villagomez, president of Wright Industries, is considering whether to build a manufacturing plant in the Ozarks. Her decision is summarized in the following table: Alternativ

Explain what is the first goal of national unions, What is the first goal o...

What is the first goal of national unions? Elections in units where employees are not currently represented are called? Corporate goal achievement is facilitated or inhibited

Explain principles of relating to customers and co-workers, It is your firs...

It is your first day at ABC Computer Repair and a very angry customer walks into the shop. They instantly start yelling at you and telling you that one of the techs did not do a go

Find breakeven as well as target profit volume, Happy Ten Produces sports s...

Happy Ten Produces sports socks. The company has fixed expenses of $80,000 and variable expenses of $0.80 per package. Each package sells for $1.60. 1. Compute the contribution mar

Explain what is the value of the game, Consider the following two-person ze...

Consider the following two-person zero-sum game. Assume the two players have the same two strategy options. The payoff table shows the gains for Player A.               Player B

Write Your Message!

Captcha
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