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 you prevent and fix such issues, Finding solutions to pro...

Finding solutions to problems is affected by how one frames the problem. In other words, what one thinks is wrong will influence what one believes the available solution(s) to be.

Explain what are the three governmental levels of correction, What are the ...

What are the three governmental levels of correctional systems?

Problems that can plague groups as organizations is groupth, One of the rec...

One of the recognized problems that can plague groups and organizations is groupthink. Do some research on the groupthink phenomenon? What is it? When does it occur? What are some

Process planning procedure, Process Planning Procedure  The process pl...

Process Planning Procedure  The process planning procedure has the followings steps as shows in figure as

Describe why you agree or disagree with the results, Write your formal anal...

Write your formal analysis of your Color Q self-assessment results. I will look for the following information What primary and secondary color type are you? (MY COLOR ARE GOL

Approaches to developing an operations strategy, Approaches to Developing a...

Approaches to Developing an Operations Strategy Approaches to developing an operations strategy specifically in service organisations:  1. The operations function is often

One philosopher''s approach to business ethics, Summary of chapter 2, readi...

Summary of chapter 2, reading 2.1. "ONE PHILOSOPHER'S APPROACH TO BUSINESS ETHICS" in a book MORAL ISSUES IN BUSINESS 12TH EDITION by William h. Shaw and Vincent Barry.

Routing procedure, Routing Procedure For a new product or part the rout...

Routing Procedure For a new product or part the routing procedure consists of seven principle steps: 1.The first step is to analyze the product or articles and fabricate int

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