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

Presume that as a result of hr planning, Assume that as a result of HR plan...

Assume that as a result of HR planning, a mental hospital identifies a shortage of therapists but a surplus of case workers. Discuss the actions that you would take to address the

How performing the necessary paperwork, Annual demand for number 2 pencils ...

Annual demand for number 2 pencils at the campus store is normally distributed with mean 1,000 and standard deviation 250. The store purchases the pencils for 6 cents each and sell

Explain car rental agency that calculates rental charges, Create a project ...

Create a project for the local car rental agency that calculates rental charges. The agency that calculates $15 per day plus $0.12 per mile. Form: Use text boxes for the customer n

Level capacity plan, Level Capacity Plan The inventory size is varied ...

Level Capacity Plan The inventory size is varied keeping the workforce size and utilization of work constant. The number of workers ( working size) is kept constant throughout

Linear programming, Premier coatings Zambia ‘PCZ’ produce both interior and...

Premier coatings Zambia ‘PCZ’ produce both interior and exterior paints from two raw materials, Ml and M2. A market survey indicates that the daily demand for interior paint cannot

Computed marginal profit for various costing profiles, An HMO requests your...

An HMO requests your hospital services for its obstetrics division. It offers to pay your hospital $2,000 for a vaginal delivery without complications (DRG 373). You look at the St

Define potential risks and bottlenecks that occur in project, Briargrove ha...

Briargrove has agreed to your plan. The CLN Team is asking for a refined version of the plan making the corrections based on their recommendations. They are requesting a comprehens

What is diversification, What is Diversification? Ans: Diversificati...

What is Diversification? Ans: Diversification is guiding activities into different lines of business.

What is operations management, Q: What is operations management?  A: Ope...

Q: What is operations management?  A: Operations management is the planning, organising and control of systems which produce goods and services. It is one of the most important

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