Case Study Brief

Page 1 of 3
School of Accounting, Information Systems and Supply Chain

OMGT2287 Supply Chain Modelling and Design
Assessment 2 Case Study Brief

The factory in Victoria produces a variety of goods based on orders from clients. It owns several
machines which require machine operators to manage. In the next production period, the
production manager has chosen to use five stations to fulfill the orders. Based on the types of
orders and machines, the production manager has determined the minimum number of machine
operators at each station across the five days as shown below.

Station 1 Station 2 Station 3 Station 4 Station 5
Monday 1 2 2 3 1
Tuesday 2 3 1 2 1
Wednesday 2 3 1 2 2
Thursday 1 1 2 4 2
Friday 1 2 3 3 1
Saturday 2 4 1 2 1
Sunday 2 4 1 1 2

Due to the nature of the orders, all machine operators are on contracts that will last until the end
of the production period. Each machine operator will be required to work 12 hours per day. To
reduce fatigue, risks and decreased performance, they will be working only four days per week.
The salary will be $25.71 per hour. The machine operators will work at the same station until the
end of the contract.

Page 2 of 3
The production manager has compiled a list of 20 machine operators to be recruited for the next
production period as shown in the table below. The manager also manually arranged the station
for each operator to be working on.

Operator Working Days Station
1 Mon–Thu 4
2 Wed–Fri, Sun 4
3 Tue–Fri 4
4 Wed, Thu, Sat, Sun 5
5 Wed–Sat 3
6 Tue, Wed, Fri, Sun 1
7 Thu–Sun 2
8 Sun–Tue, Fri 3
9 Mon, Tue, Thu, Sat 4
10 Mon–Wed, Sat 1
11 Thu–Sun 1
12 Tue, Wed, Sat, Sun 1
13 Mon, Tue, Thu, Fri 3
14 Mon–Thu 2
15 Tue–Fri 5
16 Fri–Mon 2
17 Tue, Wed, Sat, Sun 2
18 Mon, Thu, Fri, Sun 1
19 Mon, Wed, Fri, Sat 4
20 Mon, Wed, Thu, Sun 5

Page 3 of 3
The manager is, however, not confident in the arrangement above and would like to ask you to
do the following tasks before starting the recruitment.
Develop a spreadsheet model that automatically arranges the machine operators
assigned to each station for the next production period.
Highlight the differences in the arrangements done by the production manager and by
your spreadsheet model.
Make sensible recommendations based on the findings.
Document how you developed the spreadsheet model in the report in case the
requirements need to be changed in the future.