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 legal and ethical behaviour in marketing, Describe the difference b...

Describe the difference between legal and ethical behaviour in marketing. Give an example of each as it pertains to marketing

Explain what type of information must mititech''s suppliers, 1 To ensure th...

1 To ensure that its supply chain can handle a surge in demand, MitiTech should: a. hire additional manufacturing employees b. modify its design to speed up production time

Explain why sharing that information is important, Eight Glasses A Day: ...

Eight Glasses A Day: The EGAD Bottling Company has decided to introduce a new line of premium bottled water that will include several designer flavors. Marketing manager Georgia

What are the benefits of the total productive maintenance, What are the ben...

What are the benefits of the total productive maintenance? Benefits of Total productive maintenance (TPM): • Less equipment downtime and main stoppages in production providi

Dipict a competency model, Develop a competency model of a job held by a fr...

Develop a competency model of a job held by a friend, spouse or partner

Compute the productivity in sales revenue/labour expense, Sailmaster makes ...

Sailmaster makes high-performance sails for competitive windsurfers. Below is information about the inputs and outputs for one model, the Windy 2000. Units sold 1,217 Sale price ea

Developed a project and is interested in what, A company has developed a pr...

A company has developed a project and is interested in accelerating the schedule if possible. Below network diagram and tables show all information needed. Partial crashing is avai

Explain gender differences on the reading scores, You are in charge of a pr...

You are in charge of a project that is investigating the effects of gender differences on the reading scores of first, third, and fifth grades in three different school districts.

Explain what is the labor productivity, The weekly output of a fabrication ...

The weekly output of a fabrication process is shown below together with data for labor and material inputs. Standard selling price is $100 per unit. Overhead is charged weekly at t

., define the following key terms in product layout;product interval,produ...

define the following key terms in product layout;product interval,product duration and assembly line balancing

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