ACCESSED IN$-$CLASS EXERCISE $2$: WORKFORCE BALANCING

Workforce Balancing

Task

$1.$ This is a group In$-$Class assignment, which will be assessed $(4\%).$ In your group, you are required to produce a workforce plan to best achieve

the daily production schedule for the distribution center, in the detailed scenario below. Assume that the DC has implemented a training schedule

of cross training, and direct workers can be employed in any of the direct areas. Develop a plan to achieve the daily workload.

Scenario

$$ The date is Feb $6,2024$

$$ The workload for the day has just been announced:

o $28$ Containers need to be unloaded

o $860$ Pallet putaways

o $47$ Store shipments $$ deadline for meeting the transportation cut$-$off is $11\mathrm{.}59$pm$.$

o $9,500$ Picks

o $500$ Pallet replenishments from storage to pick location

o $500$ SKU$$s planned for Cycle Counting

$$ Sector $$ Retail

$$ Operating hours $2$ shifts, $8$ hours a day Mon$-$Fri, $6\mathrm{.}30$am $11\mathrm{.}30$pm$.$ Assume that the workforce is split equally between the $2$ shifts.

$$ Staff $155$

o Indirect $(29)$:

$$ Management $7$

$$ Clerical $10$

$$ Maintenance $4$

$$ Janitorial $4$

$$ Battery Changer $2$

$$ Security $2$

o Direct $(126)$:

$$ Receivers $35$

$$ Inventory $6$

$$ Putaway$/$Replenishment drivers $15$

$$ Pickers $25$

$$ Shippers $45$

Logistics I

SAIT Polytechnic $$ School of Business Page $2$

$$ Productivity

o Pallet Putaway productivity $15$ pallets$/$hour

o Pallet Replenishment productivity $15$ pallets$/$hour

o Picking productivity $30$ picks$/$hour

o Inventory Count productivity $15$ SKU$$s$/$hour

o Inbound Receipts $$ productivity $15$ man$-$hours per container.

o Outbound Shipping $$ productivity $10$ man$-$hours per shipment.

Submission

$2.$ Submit soft copy to Brightspace $($D$2$L $$ AICE$-2$: Workforce Balancing$)$ by $11\mathrm{.}59$pm Feb $09,2024,$ the plan is to be formatted in Excel using

formulas. Expectations are that the report will detail:

a$.$ All calculations.

b$.$ Where your workers will be assigned to work.

c$.$ If you can meet the daily task, and if not, what trade$-$offs$/$actions are you prepared to make?

Remember, failure to achieve the daily task is not an option! Hiring staff or getting temporary workers is not an option; think about jobs you

may have had $$ what happened when there was too much work, or someone called in sick, what did your Manager ask of anyone working?