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

Do whole foods markets mission and vision, Do Whole Foods Markets mission/v...

Do Whole Foods Markets mission/vision and the core values as presented in cases Exhibit 1 and 3 really matter? Are they real or just cosmetic window dressing? What evidence can you

Explain importance of team preparation, • Prepare a 3 to 5 page paper discu...

• Prepare a 3 to 5 page paper discussing what conclusions you can reach on the importance of team preparation and member selection to the "Define" stage, and eventual success of Si

Explain what are liquidity ratios, Now let's continue our discussion about ...

Now let's continue our discussion about the financial aspects of owning your own business that are part of, by considering the idea of "ratio analysis". In considering "financial r

Explain cost variance and schedule variances for each task, You are the pro...

You are the project manager for the following project which started Feb. 1st, 2009. It is now March 1sr, 2009. Prepare a monthly status report for February 2009, using the project

Why job redesign requires organizational change, Job redesign requires orga...

Job redesign requires organizational change. What barriers to change exist within most organizations, and how might they be overcome? I know these are some barriers, but I don't fe

Operations system, what is operations system? explain the process of operat...

what is operations system? explain the process of operations system?

Draw a diagram of the factory and finding the maximum rate, Factory is a ba...

Factory is a bathtub with 50 gallons capacity, drain is outlet to market and can output 3 gallons per hour. Faucet is raw material input and allows materials in at a rate of 4 gall

Explain replacement are covered under the adea, Harvey Jameson was recently...

Harvey Jameson was recently terminated as comptroller at the age of 66 from Better Beef, Inc. His replacement is Tammy Parker, age 45. Because both he and his replacement are cover

Explain the economic order quantity, Question 1 In a net change MRP system ...

Question 1 In a net change MRP system requirements and schedules are considered rigid and never updated. Question 2 the customer grace period is a time-span having some specifie

Hospitality industry , Can I have a process strategy matrix , which has 5...

Can I have a process strategy matrix , which has 5 key performance objectives, people processes, technology and information in one of the accor chain hotel?

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