Question: Western Family Steakhouse offers a variety of low cost meals and quick service. Other than management, the steakhouse operates with two full-time employees who work 8 hours per day. The rest of the employees are part-time employees who are scheduled for 4 hours shifts during peak meal times. On Saturdays the steakhouse is open from 11:00 Am to 10:00 pm. Management wants to develop a schedule for part-time employees that will minimize labor costs and still provide excellent customer service. The average wage rate for the Part-time employees is $7.60 per hour. The total number of full-time and part-time employees needed varies with the time of day as shown:

One full-time employee comes on duty at 11:00 am, works 4 hours, takes an hour off, and returns for another 4 hours. The other full-time employees comes to work at1:00 pm and work for the same 4 hours on, 1 hour off, 4 hours on pattern.

a- Develop a minimum-cost schedule for part time employees.

b- Formulate a linear programming model for the problem. You should show a complete LP model on a separate sheet, not on an Excel worksheet.

c- Solve the model using MS Excel Solver. (Include the worksheet and the answer sheet.)

Price: $2.99

Solution: The downloadable solution consists of 3 pages
Deliverable: Word Document