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 are the implications of the connection, How critical is Vision...

How critical is Vision to Strategy and in your experience, how well has your organization%u2019s vision (assuming one is in place) been connected to the organizational strategy?

Models, under which topic in operations management are models found?

under which topic in operations management are models found?

Five forces in strategic business plan, Based on your analysis, select one ...

Based on your analysis, select one of the five forces and explain how Bill can incorporate his analysis of that force into his Strategic Business Plan (SBP).

Explain why are uniform laws like the ucita necessary, Why are uniform laws...

Why are uniform laws like the UCITA and the UETA necessary? Does it make any difference if these uniform laws are not enacted in every state? How should the law be applied to a dis

Explain your role as an employee of an organization, Describe your role as ...

Describe your role as an employee of an organization in the IS field. Give examples of what you need to know about information systems and how it can help with your job performance

What are the various managing inventory tools, Q. What are the various mana...

Q. What are the various managing inventory tools? Raw material Materials and elements used to assemble or manufacture finished goods. Work-in-progress Incomplete f

Explain benefits and variable pay, Benefits and Variable Pay Please respond...

Benefits and Variable Pay Please respond to the following- • Analyze the types of benefits usually available in the health care industry and determine which benefits are most im

Explain upper control limit for an r-chart, Twenty samples of subgroup size...

Twenty samples of subgroup size 3 (n=3) were collected for a variable measurement. Determine the upper control limit (UCL) for an R-chart if the mean of the sample ranges equals

Compute the slope and the intercept of the trend equation, Demand for a sur...

Demand for a surgical procedure at St. Elsewhere Hospital has increased steadily over the past few years: Year 1 2 3 4 5 Heart Transplants 45 50 52 56 61 Use the

Explain what is the economic order quality, Quick cheif cookers sell at an ...

Quick cheif cookers sell at an average [ace of 12500 per month. Each cooker costs the company $100. The annual carrying cost for each cooker is 10%. Each Each order that is place

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