Each day, workers at the Gotham City Police Department work two 6-hour shifts chosen from midnight to 6AM, 6AM to noon, noon to 6PM and 6PM to midnight. The following numbers of workers are needed during each shift:
1. 15 from midnight to 6AM
2. 5 from 6AM to noon
3. 12 from noon to 6PM
4. 6 from 6PM to midnight
Workers whose two shifts are consecutive are paid $12 per hour, whereas workers whose shifts are not consecutive are paid $18 per hour. Determine how to minimize the cost of meeting the daily workforce demands of Gotham City police department.
This solution provides a simple Excel Solver solution for the problem attached in an .xls file.