solve for (C17) all dropdowns included

Have-A-Flag is a flag theme restaurant. The restaurant has varying numbers of waitstaff based on the day of the week. Mr. Sheldon, the owner of the restaurant, estimates that there is a 5% chance that individual staff will not show up to work. Mr. Sheldon still pays his staff even if they cannot make it work (such a nice person). The table below presents the number of staff each day Tue Mon Wed Thu Fri Sun Sat 8 18 8 16 16 10 9 Regular Staff Demand Although Mr. Sheldon assigns staff based on data, some days are busier than usual. Mr. Sheldon has four levels of busyness. At level 1. as long as everyone shows up for the day, no need for extra staff. However, at level 4. Mr. Sheldon needs to bring three additional staff given that everyone showed up for the work. Mr. Sheldon has an outstanding reputation and can hire any number of daily staff. Salary for the daily staff varies from day-to-day, but it is the same for everyone. Mr. Sheldon pays a minimum of $200 and a maximum of $280 per day. Each value in between is equally likely Mr. Sheldon is considering hiring additional full-time employees. To make a final decision, he wants to know the average weekly amount he is paying for daily staff A B G Nm 8 5 3 8 9 11 C D E F G H 1 Input Parameters 2 Mon Tue Wed Thu Fri Sat Sun 3 Regular Staff Demand 10 9 8 16 18 16 4 Staff No Show Rate 5% 6 7 Busyness Level 1 2 4 Extra Staff Requirement 0 1 2 3 Probability 65% 20% 10% 5% 10 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 Extra Staff Need Number of Staff Needed Number of Daily Staff Hired Daily Staff Salary per Person 21 Daily Staff Pay 22 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking here Consider the Have A Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra Staff Need" (Cell C17) for Monday, 17 18 19 20 23 MINO Select Select) Select U -N Thu Sun 16 H ameters Mon Tue Wed 3 Sat Regular Staff Demand 10 8 9 8 18 4 16 5 Staff No Show Rate 5% 6 7 Busyness Level 1 2 3 8 Extra Staff Requirement 0 1 2 3 9 Probability 65% 20% 1096 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 Rehne niceaff Needed Select MING Staff Hired MAXO per Person en Binomia y Staff Pay RANDDETWEEN -Gen Polsson y Staff Pay GenUniform en Triangular GenNormalt statement and the excel spreadsheet by clicking here Centable blem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra sim Parameter day =SimOutput Select eller un C D E F G H Fri A B 1 Input Parameters 2 3 Regular Staff Demand 4 5 Staff No Show Rate Mon 10 Tue 8 Wed 9 Thu 8 Sat 18 Sun 16 16 5% 6 7 4 8 Busyness Level Extra Staff Requirement Probability 1 0 2 1 20% 3 2 10% 9 65% 3 5% 10 11 12 13 Daily Staff Minimum Pay Daily Staff Maximum Pay $200 $280 Wed Thu Fri Sat Sun 14 Calculations 15 Select) 16 C3 Number of Staffs 03 17 Extra E3 18 Number of sti F3 03 19 Number of Daily H3 20 Daily Staff Salary 13 21 Dail: C5 C11 22 012 23 Total Dail 1-CS 03:13 You can download the problem C7 F7 CB:F8 Consider the Have A-Flag prot Staff Need" (Cell C17) for Moni 1 Select Select C9 F9 Isheet by clicking here readsheet screenshot above. Using dropdowns, construct "Extra Select . Select D E F G H Mon Tue Wed Thu 10 Fri 16 Sat 18 8 Sun 16 9 8 5% B 1 Input Parameters 2 3 Regular Staff Demand 4 5 Staff No Show Rate 6 7 Busyness Level 8 Extra Staff Requirement 9 Probability 10 11 Daily Staff Minimum Pay Daily Staff Maximum Pay 1 0 65% 2 1 20% 3 2 10% 3 5% $200 12 13 $280 Fri C3 Sat Sun H3 14 Calculations 15 Mon Tue Select] 16 Number of Staff Showed Up 17 03 Extra Staff Need .E3 18 Number of Staff Needed .F3 19 Number of Daily Staff Hired .63 20 Daily Staff Salary per Person .13 21 Daily Staff Pay . C5 22 23 Total Daily Staff Pay 1-C5 C313 You can download the problem statement and the excel spread . C7-F7 Consider the Have-A-Flag problem statement and the excel spr CBFB .CO:F9 Staff Need" (Cell C17) for Monday 0 .1 Select Select Select] .011 .C12 ng dropdowns, construct Extra Select G H Mon Fri 16 Sat 18 Sun 16 4 A E F 1 Input Parameters 2 Tue Wed Thu 3 Regular Staff Demand 10 8 9 8 4 5 Staff No Show Rate 5% 6 7 Busyness Level 1 2 3 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 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 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking bere Consider the Have A Flag problem statement and the excel spreadsheet screenshot above. Usi Staff Need" (Cell C17) for Monday Select ) 16 C3) 03) E3) F3) 63) H3) 13) C5) CIN C12) 1-C5) 03:13) C7 F7 CBF80 C9 FO) 0) 1) Select Select Have-A-Flag is a flag theme restaurant. The restaurant has varying numbers of waitstaff based on the day of the week. Mr. Sheldon, the owner of the restaurant, estimates that there is a 5% chance that individual staff will not show up to work. Mr. Sheldon still pays his staff even if they cannot make it work (such a nice person). The table below presents the number of staff each day Tue Mon Wed Thu Fri Sun Sat 8 18 8 16 16 10 9 Regular Staff Demand Although Mr. Sheldon assigns staff based on data, some days are busier than usual. Mr. Sheldon has four levels of busyness. At level 1. as long as everyone shows up for the day, no need for extra staff. However, at level 4. Mr. Sheldon needs to bring three additional staff given that everyone showed up for the work. Mr. Sheldon has an outstanding reputation and can hire any number of daily staff. Salary for the daily staff varies from day-to-day, but it is the same for everyone. Mr. Sheldon pays a minimum of $200 and a maximum of $280 per day. Each value in between is equally likely Mr. Sheldon is considering hiring additional full-time employees. To make a final decision, he wants to know the average weekly amount he is paying for daily staff A B G Nm 8 5 3 8 9 11 C D E F G H 1 Input Parameters 2 Mon Tue Wed Thu Fri Sat Sun 3 Regular Staff Demand 10 9 8 16 18 16 4 Staff No Show Rate 5% 6 7 Busyness Level 1 2 4 Extra Staff Requirement 0 1 2 3 Probability 65% 20% 10% 5% 10 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 Extra Staff Need Number of Staff Needed Number of Daily Staff Hired Daily Staff Salary per Person 21 Daily Staff Pay 22 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking here Consider the Have A Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra Staff Need" (Cell C17) for Monday, 17 18 19 20 23 MINO Select Select) Select U -N Thu Sun 16 H ameters Mon Tue Wed 3 Sat Regular Staff Demand 10 8 9 8 18 4 16 5 Staff No Show Rate 5% 6 7 Busyness Level 1 2 3 8 Extra Staff Requirement 0 1 2 3 9 Probability 65% 20% 1096 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 Rehne niceaff Needed Select MING Staff Hired MAXO per Person en Binomia y Staff Pay RANDDETWEEN -Gen Polsson y Staff Pay GenUniform en Triangular GenNormalt statement and the excel spreadsheet by clicking here Centable blem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra sim Parameter day =SimOutput Select eller un C D E F G H Fri A B 1 Input Parameters 2 3 Regular Staff Demand 4 5 Staff No Show Rate Mon 10 Tue 8 Wed 9 Thu 8 Sat 18 Sun 16 16 5% 6 7 4 8 Busyness Level Extra Staff Requirement Probability 1 0 2 1 20% 3 2 10% 9 65% 3 5% 10 11 12 13 Daily Staff Minimum Pay Daily Staff Maximum Pay $200 $280 Wed Thu Fri Sat Sun 14 Calculations 15 Select) 16 C3 Number of Staffs 03 17 Extra E3 18 Number of sti F3 03 19 Number of Daily H3 20 Daily Staff Salary 13 21 Dail: C5 C11 22 012 23 Total Dail 1-CS 03:13 You can download the problem C7 F7 CB:F8 Consider the Have A-Flag prot Staff Need" (Cell C17) for Moni 1 Select Select C9 F9 Isheet by clicking here readsheet screenshot above. Using dropdowns, construct "Extra Select . Select D E F G H Mon Tue Wed Thu 10 Fri 16 Sat 18 8 Sun 16 9 8 5% B 1 Input Parameters 2 3 Regular Staff Demand 4 5 Staff No Show Rate 6 7 Busyness Level 8 Extra Staff Requirement 9 Probability 10 11 Daily Staff Minimum Pay Daily Staff Maximum Pay 1 0 65% 2 1 20% 3 2 10% 3 5% $200 12 13 $280 Fri C3 Sat Sun H3 14 Calculations 15 Mon Tue Select] 16 Number of Staff Showed Up 17 03 Extra Staff Need .E3 18 Number of Staff Needed .F3 19 Number of Daily Staff Hired .63 20 Daily Staff Salary per Person .13 21 Daily Staff Pay . C5 22 23 Total Daily Staff Pay 1-C5 C313 You can download the problem statement and the excel spread . C7-F7 Consider the Have-A-Flag problem statement and the excel spr CBFB .CO:F9 Staff Need" (Cell C17) for Monday 0 .1 Select Select Select] .011 .C12 ng dropdowns, construct Extra Select G H Mon Fri 16 Sat 18 Sun 16 4 A E F 1 Input Parameters 2 Tue Wed Thu 3 Regular Staff Demand 10 8 9 8 4 5 Staff No Show Rate 5% 6 7 Busyness Level 1 2 3 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 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 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking bere Consider the Have A Flag problem statement and the excel spreadsheet screenshot above. Usi Staff Need" (Cell C17) for Monday Select ) 16 C3) 03) E3) F3) 63) H3) 13) C5) CIN C12) 1-C5) 03:13) C7 F7 CBF80 C9 FO) 0) 1) Select Select