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

What is the relationship among companies and profit motives, What is the re...

What is the relationship between companies, profit motives, competition and private property?

Explain what are best practices of college, What are Best Practices of coll...

What are Best Practices of college/university communications to students

Explain sarbanes-oxley act promote ethical behaviour, Identify three of the...

Identify three of the criminal penalties that can be charged under the Sarbanes-Oxley Act. How do these sections of the Sarbanes-Oxley Act promote ethical behaviour by corporations

Derive the demand functions of agent for good, 1. An agent has a utility fu...

1. An agent has a utility function over goods 1 and 2 of the form U = x c 1 x d 2 where c is your individual number and d is your minimum number. The agent's income is equal t

Explain operations applications are least prominent, Operations application...

Operations applications are least prominent for distributors, wholesales, manufacturers or retailers?

Explain valuing health care, Valuing Health Care" Please respond to the fol...

Valuing Health Care" Please respond to the following: •Determine the best way to leverage value from health IM / IT investments in today's health care environment. Provide specific

Work measurement, Work Measurement: Work  measurement  goes  hand in  ...

Work Measurement: Work  measurement  goes  hand in  with  method  design. Whereas the method design  are directed towards the study  of the components of a single or multiple

Rock’n Bands: A Project Management Decision-making G, Ask queRock’n Bands: ...

Ask queRock’n Bands: A Project Management Decision-making Gamestion #Minimum 100 words accepted#

Explain impact of globalization and information technology, Assess the impa...

Assess the impact of globalization and information technology on the creation of small businesses. Determine if and how these two trends have helped or hindered the growth of small

Principle of scheduling, Principle of Scheduling First Principle optim...

Principle of Scheduling First Principle optimum Task Size : scheduling tens to achieve its maximum efficient task sizes are small and all tasks are of the same order of magnit

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