Scenario

$$ The date is $5$ Feb $2024$

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

o $28$ Containers need to be unloaded

$860$ pallet Putaways

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

$9,500$ Picks

$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$

SAIT Polytechnic $$ School of Business Page $1$

Logistics I

o Direct $(126)$:

$$ Receivers $35$

$$ Inventory $-6$

$$ Putaway$/$Replenishment drivers $15$

$$ Pickers $25$

$$ Shippers $-45$

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

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

$$ Picking productivity $30$ picks$/$hour

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

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

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

Report

$2.$ Submit soft copy to Brightspace $($D$2$L $$ Workforce Balancing AICE$)$ by $11\mathrm{.}59$pm $5$ Feb $2024,$ the plan is to be formatted in Excel. 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?

Please ensure all group members are identified on the first page with SAIT registration numbers. Standard grading rubric for SCM Case

Analysis applies.