Determine how to minimize the number of police officers

Assignment Help Operation Management

Reference no: EM132199630

During each 4-hour period, the Smalltown police force requires the following number of on-duty police officers:

Eight from midnight to 4 a.m.

Seven from 4 a.m. to 8 a.m.

Six from 8 a.m. to noon

Six from noon to 4 p.m.

Five from 4 p.m. to 8 p.m.

Four from 8 p.m. to midnight

Each police officer works two consecutive 4-hour shifts. Determine how to minimize the number of police officers needed to meet Smalltown’s daily requirements. Please solve in Excel.

Reference no: EM132199630

Questions Cloud

Going public has underwritten its initial public offering : Your solar panel manufacturing and installation company, Solar Co. Inc., is in the process of "going public," has underwritten its Initial Public Offering (IPO)

Explain the principle value of two vision statements : Research the mission and vision statements of different fortune 500 companies.

What is the rate of return for the annual permit : Semester permits cost $186 due on August 15th and January 15th. Assuming monthly compounding, what is the rate of return for the annual permit

Identify the target market for the site : THT2112 Digital Marketing for Tourism and Hospitality - Students are to select any Tourism or Hospitality marketspaces to find an organization or enterprise

Determine how to minimize the number of police officers : Determine how to minimize the number of police officers needed to meet Smalltown’s daily requirements.

What the change in required real rate of return : What does the data suggest about the change in required real rate of return on 10 year Treasury securities? Explain

Explain integrative negotiation : An explanation of the seven factors that facilitate successful integrative negotiation. A description of the four key steps in the integrative process.

What actual or potential problems can you identify : What actual or potential problems can you identify? Describe at least five problems and provide the rationale for each.

Non-profit organisation that implements marketing concept : Find a non-profit organisation that implements the marketing concept. What is the exhange taking place?

User Account

All Pages