Mac’s Warehouse is a large discount store that operates 7 days per week. The store needs the following number of full-time employees working each day of the week: Day Number of Employees Day Number of Employees Sunday 47 Thursday 34 Monday 22 Friday 43 Tuesday 28 Saturday 53 Wednesday 35 Each employee must work 5 consecutive days each week and then have 2 days off. For example, any employee who works Sunday through Thursday has Friday and Saturday off. The store currently has a total of 60 employees available to work. Mac’s has developed the following set of prioritized goals for employee scheduling: (1) The store would like to avoid hiring any additional employees. (2) The most important days for the store to be fully staffed are Saturday and Sunday. (3) The next most important day to be fully staffed is Friday. (4) The store would like to be fully staffed the remaining 4 days in the week. a. Formulate a goal programming model to determine the number of employees who should begin their 5-day workweek each day of the week to achieve the store’s objectives. b. Solve this model by using the computer.

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

Mac’s Warehouse is a large discount store that operates 7 days per week. The store needs the following
number of full-time employees working each day of the week:
Day Number of Employees Day Number of Employees
Sunday 47 Thursday 34
Monday 22 Friday 43
Tuesday 28 Saturday 53
Wednesday 35 Each employee must work 5 consecutive days each week and then have 2 days off. For example,
any employee who works Sunday through Thursday has Friday and Saturday off. The store currently
has a total of 60 employees available to work. Mac’s has developed the following set of
prioritized goals for employee scheduling:
(1) The store would like to avoid hiring any additional employees.
(2) The most important days for the store to be fully staffed are Saturday and Sunday.
(3) The next most important day to be fully staffed is Friday.
(4) The store would like to be fully staffed the remaining 4 days in the week.
a. Formulate a goal programming model to determine the number of employees who should
begin their 5-day workweek each day of the week to achieve the store’s objectives.
b. Solve this model by using the computer.

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Optimization models
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
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.