Use solver to determine an optimal work schedule

Assignment Help Operation Management

Reference no: EM13757516

Rachel Nolan surveyed her employee schedule for In a Day Drycleaners. She was having trouble keeping labor costs down while meeting demand. In a Day Drycleaners guarantees to have their customer's clothes cleaned within 24 hours. This means that their drop-off locations and cleaning facility must be staffed 7 days a week. The business has extended hours to permit their customer to drop off and pick up clothes early in the morning and later on their way home. THe management has worked out a deal with employees in which they work four consecutive days of 10 hours long and then get off three consecutive days. Base pay is $10 per hour. Hours worked on Saturday earn a 25% premium and hours worked on Sunday earn a 50% premium.

The following tables gives the worker requirements each day.

Monday: 14 Tuesday: 12 Wednesday: 12 Thursday: 14 Friday: 16 Saturday: 12 Sunday:5

a) Given the worker requirements listed, formulate a linear program to help them minimize their labor costs.

b) Use solver to determine an optimal work schedule.

Reference no: EM13757516

Questions Cloud

Manufacturing process consists of three sequential operation : A manufacturing process consists of three sequential operations. At maximum capacity, operation A can output 120 units per hour, Operation B can output 135 units per hour, and Operation C can output 130 units per hour.

Identify and explain the strong points of the managers : Identify and explain the strong points of the managers. Identify and explain areas in which improvement is needed

Create a driver class with a main method : Create a driver class with a main method that creates a course, adds several students, prints a roll, and prints the overall course test average

Managing change in guiding an organizational change : How can a leader use the Cummings and Worley's five dimensions of leading and managing change in guiding an organizational change?

Use solver to determine an optimal work schedule : Rachel Nolan surveyed her employee schedule for In a Day Drycleaners. She was having trouble keeping labor costs down while meeting demand. In a Day Drycleaners guarantees to have their customer's clothes cleaned within 24 hours. Given the worker req..

Definition and the importance of accurate data : Discuss the complexity of problem definition and the importance of accurate data to successfully apply quantitative analysis in management.

Low-technology-low-cost process consisting of hiring several : The product design group of Iyengar Electric Supplies, Inc., has determined that is needs to design a new series of switches. It must decide on one of three design strategies. The market forecast is for 200,000 units. A low-technology, low-cost proce..

Draw and label normal curve and use standard normal table : The adhesion of one 4400-horsepower diesel locomotive model varies in actual use according to a Normal distribution with mean ? = 0.37 and standard deviation ? = 0.04.

Different processes for making its product process : Jones Company is considering two different processes for making its product Process A has annual fixed cost of $150,000 and variable cost of $15.00 per unit of output. Process B has annual fixed cost of $250,000 and variable cost of $10.00 per unit o..

User Account

All Pages