URGENT PLEASE HELP I WILL LIKE

MUST BE FORMATTED ON EXCEL

4. 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 customers 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. a. Given the worker requirements listed in the table above, formulate a linear program to help them minimize their labor costs. b. Use Solver to determine an optimal work schedule