Purchase Solution

Fire department staffing optimization

Not what you're looking for?

Ask Custom Question

A fire department says that they must have full time firemen work on different days of the week. They must have 10 on mon, 11 on tues, 12 on wed, 13 on thurs, 14 on fri, 15 on sat and 16 on sun. Each fireman must work 5 (any 5) consecutive days and then have two days off. but sometimes they can work one day a week OT. each fireman is paid $100/day regular pay and if they work OT they get $125/day.

I need to minimize the cost of meeting the requirements above. The next constraint is that they can each only work one day OT. So if they work mon, tues, wed, thurs, fri, they could if needed work either sat OR sun. How do I set this up?

Purchase this Solution

Solution Summary

The solution provides full explanations and complete Excel solver program.

Solution Preview

I have provided detailed work in the attached Excel file. Use the Solver function (in Tools menu) in Excel to ...

Purchase this Solution


Free BrainMass Quizzes
Geometry - Real Life Application Problems

Understanding of how geometry applies to in real-world contexts

Probability Quiz

Some questions on probability

Multiplying Complex Numbers

This is a short quiz to check your understanding of multiplication of complex numbers in rectangular form.

Exponential Expressions

In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.

Solving quadratic inequalities

This quiz test you on how well you are familiar with solving quadratic inequalities.