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 baggage check-in of a small airline, From "Matching Supply with Dem...

From "Matching Supply with Demand" - Cachon/Terwiesch Consider the baggage check-in of a small airline. Check in data indicate that from 9am to 10am, 255 passengers checked in.

Explain management developer, Business knowledge competencies are particula...

Business knowledge competencies are particularly important for which human resource role? Answer A) management developer B) employee advocate C) strategic partner D) functional exp

Explain competencies required of hr management, Review the competencies req...

Review the competencies required of HR management and recommend at least two additional areas in which HR managers should be competent. Provide specific examples to support your re

Feedback - advantages of statistical process control, Feedback - Advantages...

Feedback - Advantages of Statistical Process Control  SPC is a clear example of negative-feedback system control, providing management with timely information on the state of

Simulation problem, neater eater hamburger joints frequency distribution op...

neater eater hamburger joints frequency distribution operation research problem

Explain organizational complexity affect human behaviour, Given the multipl...

Given the multiple components (subsystems) of the organizational system model, organizations might be said to be complex. Drawing from your own work and organizational experiences

Operational Management, I have a take home exam that I need to be solved 10...

I have a take home exam that I need to be solved 100 % correct , please . I need it within 23 hours EXACTLY from now please . Thank you so much and I am really looking forward to s

Explain what is the probability distribution of the time, Consider a queuin...

Consider a queuing system with 2 types of customers. Type 1 customers arrive according to a Poisson process with a mean rate of 5 per hour. Type 2 customers arrive according to a P

Explain the quality control implications of the major change, in a 3-4 page...

in a 3-4 page paper answer the following: Q1. Describe the quality control implications of the major changes that have taken place in food chains today compared to the past. Q2. Wh

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