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 organizational strategy is analyze organizations, Organizational St...

Organizational Strategy is Critically evaluate information from core business functions to enhance organizational knowledge, how would you assess your mastery of this competency?

Explain what are your recommendation to resolve this lawsuit, Scenario: Com...

Scenario: Commerce Clause ABC Freightways maintained its principal place of business in Arkansas. However, they provided trucking services in all states west of the Mississippi

Explain being fired for sexual harassment, During the course of a day, empl...

During the course of a day, employee Jennifer Anniestown (an accountant) constantly opens and updates her Facebook account on her iPad, checks on her lottery ticket numbers, calls

Explain what is the probability that both are successful, DO NOT WORK A com...

DO NOT WORK A company is considering producing two new electronic games designed for the popular Gameboy toy. Based on market data, management believes there is a 60 percent chance

Design an appropriate control chart, This assignment requires you to look i...

This assignment requires you to look in some detail at one quality issue arising in your organisation. Some of the exercises in Units 4 and 5 have already suggested that you consid

Explain considerations in designing organisation structure, Explain main co...

Explain main considerations while designing the organisation structure. While designing the organisation structure, there are two major considerations:  - Differentiation an

Explain how can she be sure of her judgment, How can she be sure of her jud...

How can she be sure of her judgment? • How can she convince the marketers? • How should she act in this situation?

Explain stanley milgram''s famous experiment, Describe Stanley Milgram's fa...

Describe Stanley Milgram's famous experiment. What are its most significant implications?

Define current inventory control system for football helmets, Tune Football...

Tune Football Helmets Company is considering changing its current inventory control system for football helmets. The information regarding the helmets is given below. Demand = 2

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