In: Operations Management
QUESTION 2 [9 marks]
The Amalgamated Parcel Service is open 7 days a week. The schedule of requirements is as follows:
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
6 3 5 3 7 2 3
Requirements
The Manager needs a workforce schedule that provides each employee with TWO consecutive daysoff per week and minimizes the total amount of slack capacity.
a. Prepare and present a work schedule highlighting the days off.
b. Indicate the total number of workers that the manager needs to schedule. (2 marks
Below is the screenshot of the LP table -
Below is the screenshot of the formula applied -
Below is the screenshot of the solver -
Below is the screenshot of the Result -