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 how to identify stakeholders within a project, Normal 0 ...

Normal 0 false false false EN-IN X-NONE X-NONE

Explain what pay level does the efficiency wage predict, What pay level doe...

What pay level does the efficiency wage predict? Does the theory accurately predict organization behaviour? Why or why not

Explain what are the boundary points of the feasible region, Maxwell Manufa...

Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below. Fliptop Model Tiptop Model Available Plastic 3 4

Explain method for a company to advertise, How does Facebook compare with T...

How does Facebook compare with Twitter in terms of a method for a company to advertise? Is the audience different for the two? Are the risks/rewards different?

Strategic service concept and service delivery system, Strategic Service Co...

Strategic Service Concept and Consideration of Service Delivery System Service has been singled out for particular attention. Product differentiation is a relatively visible

Explain for bill what an enterprise resource planning, Describe for Bill wh...

Describe for Bill what an Enterprise Resource Planning (ERP) solution would look like for his UMUC Pizza business and how his business could benefit from implementing an ERP soluti

Explain matching supply with demand, From "Matching Supply with Demand" Cac...

From "Matching Supply with Demand" Cachon/Terwiesch (Inventory Cost) A manufacturing company producing medical devices reported $60,000,000 in sales over the last year. At the e

Explain how do you approach the situation, In the middle of acquiring a new...

In the middle of acquiring a new company overseas, the deal hits a roadblock and your negotiation team is sent in. Based on the eight negotiation steps, how do you approach the sit

Explain patient incentives as well as provider outreach, Please summarize B...

Please summarize Blue Cross Blue Sheild Health Insurance, review members service, new/ current/ upcoming technology, accreditation or certifications and patient incentives as well

Operations Management: Sustainability and Supply Chain Manag, I have seven...

I have seven homework question that I''m trying to complete. 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