Explore BrainMass
Share

Explore BrainMass

    Minimizing cost using Excel Solver

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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.

    © BrainMass Inc. brainmass.com October 9, 2019, 4:46 pm ad1c9bdddf
    https://brainmass.com/statistics/descriptive-statistics/minimizing-cost-using-excel-solver-40661

    Attachments

    Solution Summary

    This solution provides a simple Excel Solver solution for the problem attached in an .xls file.

    $2.19