Formulate the problem as an integer programming model

Assignment Help Operation Management

Reference no: EM131124635

The sheriff has been asked by the county commissioner to increase weekend patrols in the lake region during the summer months. The sheriff has proposed the following weekly schedule, shifting deputies from weekday assignments to weekends:

Day Sun. Mon. Tues. Wed. Thurs. Fri. Sat.

Assignments 6 4 3 3 5 5 6

Develop a weekly sork-shift schedule of duty tours, providing 2 consecutive days off per week for each officer. Formulate the problem as an integer programming model to minimize the number of officer need, and solve using Excel solver. (Provide excel sheet too)

Reference no: EM131124635

Questions Cloud

Considering allocating students to dorms by lottery : The University of Massachusetts (Amherst) is considering allocating students to dorms by lottery. This will make it harder for groups to sort by dorm (e.g. an “Asian dorm,” an “African American dorm”, etc.). Is this a good idea? Justify your opinion.

Assume there are no time value of money concerns : A high school student is trying to decide what to do after high school. She could get a job, where she expects to make an average of $25,000 per year over the next 10 years. She assumes she will have no problems finding a job. Assume there are no tim..

Individual learning in crisis management situations : Discuss why team learning is as important as individual learning in crisis management situations. What is meant by the idea of building resilience through redundancy? Has to be 200 or more words with intext citations and references.

According poisson process with intensity : Customers arrive to the store according a Poisson process with intensity λ = 1 customers per hour. Let N[0,t] be the number of arrivals between [0,t]. (a) Find the probability P(N[0,2] = 2,N[2,3] = 1|N[0,6] = 6). (b) Let Ti be the arrival time of the..

Formulate the problem as an integer programming model : The sheriff has been asked by the county commissioner to increase weekend patrols in the lake region during the summer months. The sheriff has proposed the following weekly schedule, shifting deputies from weekday assignments to weekends: Develop a w..

Anticipation of its two for the price of one fare promotion : Sunset Airlines is reviewing its check-in procedures in anticipation of its "two for the price of one" fare promotion. Presently, a single clerk spends an average of three minutes per passenger checking luggage and issuing boarding passes. What is th..

Good strategic and service plan attempt to bring rationality : Good strategic and service plans attempt to bring rationality and stability to an organization. However even the best plans can be influenced by trends and changes in the healthcare marketplace. What are some ways that management can respond to these..

Explains the rationale for your code to management : After completing the Ethics Code from Week 5, write an essay around 3-5 pages (excluding the title and reference page) that explains the rationale for your code to management. In other words, why did you include the points you did?

Determine the number of containers : A manager wants to determine the number of containers to use for incoming parts for a kanban system to be installed next month. The process will have a usage rate of 68 pieces per hour. Because the process is new, the manager has assigned an ineffici..

User Account

All Pages