Alinear programming computer package is needed. 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-hour shifts during peak meal times. On Saturdays the steakhouse is open from 11:00 a.m. to 10:00 p.m. 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. Min 11:00 am-Noon Noon-1:00p.m 1:00p.m.-2:00p.m. 2:00 pm-3:00p.m. 3:00p.m.-4:00p.m. 4:00 pm-5:00p.m. 5:00 pm-6:00p.m. 6:00 pm-7:00p.m. 7:00 pm-8:00p.m. 8:00p.m.-9:00p.m &.L. 11:00 am Noon 1:00 pm 2:00p.m. 3:00p.m. 4:00p.m. 5:00p.m. 6:00 pm. 7:00p.m. Min 8:00 pm. 9:00 pm-10:00p.m. 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 employee comes to work at 1:00 p.m. and works the same 4-hours-on, 1-hour-off, 4-hours-on pattern. (a) Develop a minimum-cost schedule for part-time employees. (Let x,- the number of part-time employees who start work beginning at hour/where /-1-11:00 a.m.,/-2-Noon, etc). 9:00 pm. ₂₂ 20 Find the optimal solution. Wyyyy x₂ - ( This answer has not been graded t Time 11:00a.m. Noon 1:00p.m. 2:00p.m. 3:00p.m. 4:00p.m. 5:00 pm. 6:00 pm. (b) What is the total payroll (in $) for the part-time employees? $ How many part-time shifts are needed? 7:00 pm. Number of Employees Needed Use the surplus variables to comment on the desirability of scheduling at least some of the part-time employees for 3-hour shifts. 8:00p.m. 9 9:00 pm. 9 9 (c) 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. (Let x, be the same variables from part a. Let y, the number of part-time employees who start work beginning at hour /where-1- 11:00 am,/-2-Noon, etc). 3 3 3 $ 6 12 12 7 7 XyX² ₂² ₂² ¥ y Y q ¥g Yg Yy Yg Y Z 0 ** Find the optimal solution. * * * * * * * *۰ ۰ ۰ ۰ ۰ ۰ gr 12 - ۷۷۰ ۷۶ ۷۷ ۷) - ( How many part-time shifts are needed, and what is the cost savings (in $) compared to the previous schedule? part-time shifts needed cost savings

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question
A linear programming computer package is needed.
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-hour shifts
during peak meal times. On Saturdays the steakhouse is open from 11:00 a.m. to 10:00 p.m. 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.
Min
s.t.
11:00 a.m.-Noon
Noon-1:00p.m.
1:00 p.m.-2:00 p.m
2:00 p.m.-3:00p.m.
3:00 pm 4:00 p.m.
4:00 p.m.-5:00p.m.
5:00 p.m.-6:00 p.m.
6:00 pm-7:00p.m.
11:00a.m.
7:00 p.m-8:00p.m.
8:00 p.m.-9:00 p.m.
1:00 pm.
Noon
2:00 pm.
3:00 pm.
4:00p.m.
5:00 pm.
6:00 pm.
7:00 pm.
9:00 pm-10:00p.m.
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:00 p.m. and works the same 4-hours-on, 1-hour-off, 4-hours-on pattern.
(a) Develop a minimum-cost schedule for part-time employees. (Let x, the number of part-time employees who start work beginning at hour / where i-1 -11:00 a.m., / -2- Noon, etc).
8:00p.m.
9:00 pm.
Min
Find the optimal solution.
X X X X X X X X) - (
s.t.
This answer has not been graded yet.
Time
11:00 a.m.
Noon
1:00 pm.
2:00 pm.
3:00 p.m.
4:00p.m.
5:00p.m.
Number of
Employees
Needed
(b) What is the total payroll (in $) for the part-time employees?
$
6:00 pm.
How many part-time shifts are needed?
shifts
Use the surplus variables to comment on the desirability of scheduling at least some of the part-time employees for 3-hour shifts.
7:00p.m.
9
8:00p.m.
9
(c) 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. (Let x, be the same variables from part a. Let y, the number of part-time employees who start work beginning at hour
/where i 1 11:00 a.m., /2 - Noon, etc).
9
3
3
$
3
6
12
12
7
7
9:00 p.m.
X₂ X ₂² X X X X X X ² V ₂² V ₂² V ₁ Y ² X ² Vg Vy Yg YgZO
Find the optimal solution.
۷۰ ۷۰ ۷۶۰ ۷۶۰ ۷۰ ۷۰) -
Yo ( [
How many part-time shifts are needed, and what is the cost savings (in $) compared to the previous schedule?
part-time shifts needed
cost savings
Transcribed Image Text:A linear programming computer package is needed. 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-hour shifts during peak meal times. On Saturdays the steakhouse is open from 11:00 a.m. to 10:00 p.m. 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. Min s.t. 11:00 a.m.-Noon Noon-1:00p.m. 1:00 p.m.-2:00 p.m 2:00 p.m.-3:00p.m. 3:00 pm 4:00 p.m. 4:00 p.m.-5:00p.m. 5:00 p.m.-6:00 p.m. 6:00 pm-7:00p.m. 11:00a.m. 7:00 p.m-8:00p.m. 8:00 p.m.-9:00 p.m. 1:00 pm. Noon 2:00 pm. 3:00 pm. 4:00p.m. 5:00 pm. 6:00 pm. 7:00 pm. 9:00 pm-10:00p.m. 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:00 p.m. and works the same 4-hours-on, 1-hour-off, 4-hours-on pattern. (a) Develop a minimum-cost schedule for part-time employees. (Let x, the number of part-time employees who start work beginning at hour / where i-1 -11:00 a.m., / -2- Noon, etc). 8:00p.m. 9:00 pm. Min Find the optimal solution. X X X X X X X X) - ( s.t. This answer has not been graded yet. Time 11:00 a.m. Noon 1:00 pm. 2:00 pm. 3:00 p.m. 4:00p.m. 5:00p.m. Number of Employees Needed (b) What is the total payroll (in $) for the part-time employees? $ 6:00 pm. How many part-time shifts are needed? shifts Use the surplus variables to comment on the desirability of scheduling at least some of the part-time employees for 3-hour shifts. 7:00p.m. 9 8:00p.m. 9 (c) 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. (Let x, be the same variables from part a. Let y, the number of part-time employees who start work beginning at hour /where i 1 11:00 a.m., /2 - Noon, etc). 9 3 3 $ 3 6 12 12 7 7 9:00 p.m. X₂ X ₂² X X X X X X ² V ₂² V ₂² V ₁ Y ² X ² Vg Vy Yg YgZO Find the optimal solution. ۷۰ ۷۰ ۷۶۰ ۷۶۰ ۷۰ ۷۰) - Yo ( [ How many part-time shifts are needed, and what is the cost savings (in $) compared to the previous schedule? part-time shifts needed cost savings
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 10 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.