question 2

Please study Chapter 4.3 Operations Management Applications before attempting this question. Western Family Steakhouse offers a variety of low-cost meals and quick service. Other than management, the steakhouse operates with two full-time emplovees who work 8 hours per day. The rest of the emplovees are part-time emplovees who are scheduled for 4- hour shifts during peak meal times. On Saturdavs the steakhouse is open from 11:00 a.m. to 10:00 D.m. Management wants to develop a schedule for part-time emplovees 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. Time Total Number of Employees Needed 11:00 a.m.-Noon Noon1:00 p.m. 1:00p.m.-2:00p.m. 9 2:00 p.m.-3:00p.m. 3:00p.m.-4:00p.m. 3 4:00 p.m.-5:00p.m. 5:00 p.m.-6:00 p.m. 6 6:00 p.m.-7:00p.m. 12 7:00p.m.-8:00p.m. 12 8:00 p.m.-9:00 p.m. 7 9:00 pm-10:00p.m. 7 One full-time employee comes on duty at 11:00 a.m., works 4 hours, takes an hour off, and returns for another 4 hours. The other full- time employee comes to work at 1:00p.m. and works the same 4-hours-on, 1-hour-off, 4-hours-on pattern. 1. Develop a minimum-cost schedule for part-time employees. 2. What is the total payroll for the part-time employees? How many part-time shifts are needed? Use the surplus variables to comment on the desirability of scheduling at least some of the part-time employees for 3-hour shifts. 3. Assume that part-time employees can be assigned either a 3-hour or a 4-hour shift. Develop a minimum-cost schedule for the part-time employees. How many part-time shifts are needed, and what is the cost savings compared to the previous schedule? Build an LP model for this problem (insert a textbox in an Excel worksheet and type in the LP model by defining decision variables. clearly stating the objective function and the constraints) to answer the above questions. Then, enter your model into the same Excel worksheet and solve it using Excel solver. Save your Excel file under your full name and then upload your file