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

Introduction to the operations function, Introduction to the Operations Fun...

Introduction to the Operations Function Firstly, consider the economy where gross domestic product (GDP) has been subdivided into its major divisions which are agriculture, ma

Explain why is following up important with participants, Why is following u...

Why is following up important with participants who did not show up for their scheduled participation in your research?

Explain the basic economic order quantity, The basic Economic Order Quantit...

The basic Economic Order Quantity (EOQ) model can be considered a special case of the Economic Production Quantity (EPQ) model under which of the following condition? Answer The

Explain choosing a new piece of equipment, The following table shows the cr...

The following table shows the critical factors in a company's decision on choosing a new piece of equipment. Calculate the breakeven volume and utilization for each option and then

Explain product life cycle, How does a product life cycle differ from a pro...

How does a product life cycle differ from a product life cycle?

Layout, what are the objectives that an operation should could consider in ...

what are the objectives that an operation should could consider in order to ensure a good layout

How to find the optimum number of units, A manufacturing company sells its ...

A manufacturing company sells its products directly to customers and operates 5 days a week, 52 weeks a year. The production department of this company can produce at the rate of 6

Explain technology intensive should you make it, When you're creating a onl...

When you're creating a online site, how busy, technology intensive should you make it

Attributes for the role of operations manager, 1. List the following 10 att...

1. List the following 10 attributes in the order you consider them necessary for the role of operations manager: people skills; eye-for-detail; mathematical skill; strategic thinke

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