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 comparison of processes with a direct adversary, 1. A simulation mo...

1. A simulation model goes one step further than possible with analysis tools, because it can show how the process performs ____________ over time. 2. A(n) ____________ is a met

Describe designing a database and relational schema, You viewed two video r...

You viewed two video resources, Designing a Database and Relational Schema of the "Priscilla/Dave" project. At the end of the logical design phase, there were five tables (Pet, Pet

[email protected], Ask qu2 The historical development of operations...

Ask qu2 The historical development of operations managementestion #Minimum 100 words accepted#

Explain flowchart uses symbols to represent, A process flowchart uses symbo...

A process flowchart uses symbols to represent which of the following?

Explain the marketing objective for a product in the, The marketing objecti...

The marketing objective for a product in the _____ stage of the product life cycle is to create consumer awareness and gain trial. introduction growth maturity decline

Determine the price to maximize profit, The Hickory Cabinet and Furniture C...

The Hickory Cabinet and Furniture Company has decided to concentrate on the production of chairs. The fixed cost per month of making chairs is $7,500, and the variable cost per cha

How an hr professional may designated that information, How an HR professio...

How an HR professional might designated that information/data as a critical result area? That's question. Reference where info came from.

Process Planning, Process Planning In the design of processes there is...

Process Planning In the design of processes there is a certain similarity to the design of products, in that there is a hierarchy of design stages. At the top level, process

Product layout., what is product interval time product duration?

what is product interval time product duration?

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