Promotion-Day Staffing Plan Problem Type: Non-Smooth Use the…

Prоmоtiоn-Dаy Stаffing Plаn Problem Type: Non-Smooth Use the provided starter Excel spreadsheet (link above). The spreadsheet already includes formulas, the objective cell, and the constraint calculations. An e-commerce distributor is planning staffing for a one-day promotion event. The starter spreadsheet already contains the IF / MIN / MAX logic for bottlenecks, late orders, and piecewise penalties. Use Solver to minimize total daily cost. All staffing decisions must be nonnegative integers: Pickers, Packers, and Temporary Packing Teams. Demand and productivity Item Value Orders due today (base case) 1,500 Orders picked per picker 250 Orders packed per packer 220 Temporary team productivity Temp Teams Hired Productivity Rule Fewer than 2 teams 180 orders per team 2 or more teams 210 orders per team Cost data Cost Item Amount Picker labor cost (per picker) $180 Packer labor cost (per packer) $170 Temp team cost (per team) $850 Temp mobilization fee (if any temp team is hired) $500 Late-order penalty policy Late Orders Penalty Rule 0 to 100 late orders $4 per late order More than 100 late orders $400 + $10 for each late order above 100 Limits and constraints Limit / Rule Value Floor-space slots available 32 Training budget points 900 Maximum allowed late orders 300 Picker upper bound 8 Packer upper bound 8 Temp team upper bound 4 Staffing code (used for code questions) Code Digit Place Represents Hundreds digit Number of Pickers Tens digit Number of Packers Ones digit Number of Temp Teams Example: Pickers = 6, Packers = 7, Temp Teams = 0 → staffing code = 670.