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

Discuss fully collection credit company, 1. Elton is a limited partner in D...

1. Elton is a limited partner in Destiny Tours, a limited partnership. Collection Credit Company, a Destiny creditor, claims that Eton is subject to personal liability for Destiny'

State you views about supply chain management, Q. State you views about sup...

Q. State you views about supply chain management? Strategies to attain greater integration of the supply chain through raw material to the eventual final sale and disposal of a

Project, I want to start my simulation modeling project but I dont how to s...

I want to start my simulation modeling project but I dont how to start. I already have the company to do about it is Tissue Manufacturing will you please assist

Explain organizational culture serves in organizations, Organizational cult...

Organizational culture serves what purpose in organizations?

Explain inventory decreases and inventory increases, What happens to invent...

What happens to inventory as the number of kanban cards increases? Inventory decreases Inventory increases Inventory remains the same The number of kanban cards has no

Define how a researcher goes about determining sample size, Discuss how a r...

Discuss how a researcher goes about determining sample size. Provide specific examples to support your ideas

Explain supply process improvements, Supply Process Improvements examine...

Supply Process Improvements examine the steps of the supply process in Chapter 4 of the text and identify a project where improvements could be made in one or more of the steps.

Line balancing, what happens if line balancing does not exist

what happens if line balancing does not exist

Explain valuing health care, Valuing Health Care" Please respond to the fol...

Valuing Health Care" Please respond to the following: •Determine the best way to leverage value from health IM / IT investments in today's health care environment. Provide specific

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