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 what is an industry, What is an industry? (a) Industry is a grou...

What is an industry? (a) Industry is a group of diverse businesses under common owners. (b) Industry is a group of firms whose products have same and similar attributes such

Explain tomorrow''s business environment, Write a job description for a pos...

Write a job description for a position in tomorrow's business environment

What are the receipts handling in the purchasing department, Q. What are th...

Q. What are the receipts handling in the purchasing department? Receipts handling: It is the responsibility of the purchasing department: a.     Shipping and transport manag

Would like for you to advice changes that would significant, Your boss woul...

Your boss would like for you to suggest changes that would significant shorten it. what would you suggest?

Explain what is the difference between idealism and realism, Provide a "rea...

Provide a "real world" example of moral philosophy. What is the difference between idealism and realism? Support your definitions with practical examples. How does moral philoso

Define the information security issues facing the government, Evaluate: Eva...

Evaluate: Evaluate the information security issues facing the government and identify its three biggest concerns. Application: Demonstrate how the government can use authentication

Line balancing, What do you understand by “line balancing”? What happens if...

What do you understand by “line balancing”? What happens if balance doesn’t exist

Explain social responsibility on the part of businesses, What are the argum...

What are the arguments for and against social responsibility on the part of businesses? Research the topic and discuss. In addition, which set of arguments is more compelling?

Describe some of the important factors new location, List and explain some ...

List and explain some of the important factors to be considered when selecting a new location for a hospital to be built from some potential site

Statistical Process Control (SPC), I have an excel assignment for the SPC, ...

I have an excel assignment for the SPC, so I want to know if you could do it and how much will it cost?

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