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

Explain how might this process be improved, Abbott Manufacturing produces p...

Abbott Manufacturing produces plastic cases for solar photovoltaic panels and has decided to combine orders from customers to increase work order size, and thereby make one large p

How the job of industrial manager becomes more difficult, How the job of in...

How the job of industrial manager becomes more difficult? However, the job of industrial Manager becomes still more difficult because of: (i) Change in technology; (ii) C

Explain what are some types of software that can help, What are some types ...

What are some types of software that can help us protect employee information? How does this software interact with our current HR technology? Explain from a conceptual stand

What are complexities and risks involved with supply chains, Given the comp...

Given the complexities and risks involved with supply chains, might it make sense for a business organization to vertically integrate and be its own supply chain? Why or why not?

Describe difference between significance and meaningfulness, What is the di...

What is the difference between significance and meaningfulness? Which one is more important to experimental results and why do you think so?

Explaining each milestone using the smart criteria, Identify at least eight...

Identify at least eight milestones for WBS and A Gantt chart. Write a one-page paper describing each milestone using the SMART criteria. Discuss how determining these milestones mi

Explain about the organization and its resources, 1. How to characterize yo...

1. How to characterize your supervisor's approach to management? For example, which particular management tasks and roles does this person perform most often? What kinds of managem

Show role as an employee of an organization in the is field, Briefly descri...

Briefly describe your role as an employee of an organization in the IS field. Give examples of what you need to know about information systems and how it can help with your job per

Define the functional department integration, Q. Define the functional depa...

Q. Define the functional department integration in information system. All functional departments are integrated within one holistic information system. Well integrating manufa

Explain successful in developing a business model, Do you anticipate that F...

Do you anticipate that Facebook will ever be successful in developing a business model that monetizes their site traffic even further? When they had their public offering, the valu

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