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 when acquiring an innovative technology externally, Your company, a...

Your company, a large online high school, is planning to implement a new innovative social networking technology for their students. The technology would allow students to get to k

What is operations strategy, What is operations strategy? Operations ...

What is operations strategy? Operations strategy: According to Slack and Lewis the definition operations strategy: The total pattern of decisions that shape the long

Evaluate the performance of a bank holding company, The purpose of the proj...

The purpose of the project is to evaluate the performance of a bank holding company of your choice. 1. Choose a bank holding company. You can choose from Top 50 BHCs or find a b

Describe what the customer''s expectations, Explain what the customer's exp...

Explain what the customer's expectations are concerning the salesperson's attitude toward competition

Explain a risk of disciplining employees, A risk of disciplining employees ...

A risk of disciplining employees is that some employees retaliate. To avoid that risk, what organizational policies might encourage low-performing employees to leave while encourag

Explain the categories of problems, Describe the categories of problems tha...

Describe the categories of problems that have been found to be approached by Six Sigma methodology.

Explain relatively distinct leadership styles, Explain relatively distinct ...

Explain relatively distinct leadership styles. The three relatively distinct leadership styles are as follows: a)  Authoritarian - leader makes all decisions unilaterally an

Explain los angeles court syestem, I need Los Angeles Court Syestem. I need...

I need Los Angeles Court Syestem. I need orginal thought no plagerism or won't award points. Assignment Complete the following, placing it in a single Word document. You h

Explain what is the theoretical number of workstations, Tasks: A - 20 sec -...

Tasks: A - 20 sec - no precedence B - 7 sec - preceded by A C - 20 sec - preceded by B D - 22 sec - preceded by B E - 15 sec - preceded by C F - 10 sec - preceded by D G - 16 sec -

What are two aspects of self-concept, ------------- and--------------------...

------------- and---------------------are two related aspects of self-concept/1. Self-esteem, self-monitoring/2.self-esteem, self-assessment, 3 self moitoring;self-assessment/4 sel

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