Determine the mininnun number of firefighter needed on shift

Assignment Help Operation Management

Reference no: EM131953287

In a small suburban town, firefighters work 8-hour shifts. Assume there are 6 shifts each day that are divided into six 4-hour periods. The minimum number of firefighters needed on each shift is illustrated below.

Shift Number of Firefighters Needed

Midnight-4 a.m. 5

4 a.m.-8 a.m. 6

8 a.m.-Noon 10

Noon-4 p.m. 12

4 p.m.-8 p.m. 8

8 p.m.-Midnight 5

Firefighters must report to work at the beginning of the above time periods and must work eight consecutive hours.

Formulate the given problem scenario as a linear program so as to determine the mininnun number of firefighters needed on each shift.

Solve the problem using Microsoft Excel Solver.

For the formulation, provide a complete description of the decision variables used along with their units and also label the constraints mentioned in the problem as completely as possible.

Also, the Excel setup should provide clearly labeled values used for the decision variables, constraints, and objective function.

Reference no: EM131953287

Questions Cloud

How does panera bread create value for customers : What are some ways you think Panera Bread earns the trust of its public? How does Panera Bread create value for customers?

For what range would b be superior : The finished items sell for $22.000 each. At what volume of output would the two locations have the same total cost?

Describe the life cycle of your organism : Describe the life cycle of your organism. Evolution is best understood as heritable change over time, or descent with modification.

What range of stock prices generates a profit : Call: strike price $30, term three months, price $3; Put: strike price $30, term three months, price $4. Stock price is $29.

Determine the mininnun number of firefighter needed on shift : Formulate the given problem scenario as a linear program so as to determine the mininnun number of firefighters needed on each shift.

Find what will be the new price of the bonds : With 15 years to maturity, if yield to maturity goes down substantially to 8 percent, what will be the new price of the bonds?

Wage increases should be based solely on performance measure : Explain the following statement: "Wage increases should be based solely on performance measures." How does the supervisor develop clear guidelines

What type of organization structure would be value : What type of organization structure would be of most value to this firm in its initial efforts to go international? Briefly describe the organization structure

Identify the components of an accounting information system : What role do accountants play in today's information intensive organizations - Identify the components of an accounting information system

User Account

All Pages