Sat A B D E F G H 1 1 Input Parameters 2 Mon Tue Wed Thu Fri Sun 3 Regular Staff Demand 10 8 9 8 16 18 16 4 5 Staff No Show Rate 5% 6 7 Busyness Level 2 3 4 8 Extra Staff Requirement 0 1 2 3 9 Probability 65% 20% 10% 5% 10 11 Daily Staff Minimum Pay $200 12 Daily Staff Maximum Pay $280 13 14 Calculations 15 Mon Tue Wed Thu Fri Sat Sun 16 Number of Staff Showed Up 17 Extra Staff Need 18 Number of Staff Needed 19 Number of Daily Staff Hired 20 Daily Staff Salary per Person 21 Daily Staff Pay 22 23 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking Click to open: Consider the Have-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra Staff Need" (Cell C17) for Monday