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 decision alternatices and various levels of demand, The following p...

The following payoff table provides profits based on various possible decision alternatices and various levels of demand at Amber Gardner's software firm

Explain decision quality requirement that is significant, A large municipal...

A large municipality (250,000 citizens) is trying to decide where to locate a new community recreational center. The problem is relatively unstructured. There is a decision quality

Describe what is the chocolate raw material safety stock, Christian runs a ...

Christian runs a small chocolate shop. He manages his chocolate raw material using a periodic review system. Daily demand has a mean of 100 pounds and standard deviation of 10 poun

Define customer benefits, In this writing assignment, you will create a bro...

In this writing assignment, you will create a brochure advertising your services as a data repository. Research commercial data repositories. Be sure to understand this business mo

Scope, what are the scope of operation research

what are the scope of operation research

Sequence problem, how to calculate idletime of each row

how to calculate idletime of each row

Explain sow contains words such as nearly or approximately, If the customer...

If the customers SOW contains words such as nearly or approximately, then: Answer The project manager uses his discretion in determining the meaning The sponsor uses his d

Explain how to perform a swot analysis, Watch the video, How to Perform a S...

Watch the video, How to Perform a SWOT Analysis, and then conduct a SWOT analysis using the Starbucks' Global Quest 2006: Is the Best Yet to Come? case provided in the Course Mater

Explain value chain analysis according to porter, Explain value chain analy...

Explain value chain analysis according to Porter. According to Porter’s value chain analysis: Value chain analysis (VCA) is a position audit element which examines the in

Explain the operation of a subway sandwich shop, Using the concepts that yo...

Using the concepts that you learned in online explanation of control theory, describe the operation of a Subway sandwich shop. Be sure to describe which of the Control Theory's wou

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