two questions underneath the table pictured. the drops downs are the same for both!

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. Mon Tue Wed Thu Fri Sat Regular Staff Demand 10 8 9 Sun 16 8 16 18 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 $289 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 c D E F G H B 1 Input Parameters 2 3 Regular Staff Demand Mon 10 Tue 8 Thu Wed 9 8 Fri 16 Sat 18 Sun 16 2 5 Staff No Show Rate 5% 6 7 Busyness Level 1 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 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 22 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking here ia Consider the Have A Flat problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Number of Staff Showed Up" (Cell C16) for Monday Thu Select 12 Daily Staff Maximum Pay $280 13 14 Calculations 15 Mon Tue Wed Thu Fri Sat 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 here . Consider the Have-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construc "Number of Staff Showed Up" (Cell C16) for Monday. [ Select) Select] Select) Select =MING =MAX =( GenBinomial =RANDBETWEEN GenPoisson -GenUniform =Gen Triangular GenNormal GenTablet simParameter SimOutput ForGTE 2 3 B C D E F G H Mon Tue Wed Thu C aily Staff Minimum Pay ily Staff Maximum Pay $200 $280 as Mon Tue Wed Thu Fri Sat ber of Staff Showed Up Extra Staff Need Humber of Staff Needed ber of Daily Staff Hired - Staff Salary per Person Daily Staff Pay Total Daily Staff Pay ad the problem statement and the excel spreadsheet by clicking here ve-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construc Ef Showed Up" [Select ] C3 D3 [Select] [Select] E3 F3 G3 H3 13 C5 C11 C12 1-C5 C3:13 C7:F7 C8:F8 C9:F9 0 1 A E F G H arameters Wed Thu Regular Sta Fri 16 9 8 Sat 18 Sun 16 aily Staff Minimum Pay aily Staff Maximum Pay $200 $280 ins Mon Tue Wed Thu Fri Sat hber of Staff Showed Up Extra Staff Need Vumber of Staff Needed mber of Daily Staff Hired Staff Salary per Person Daily Staff Pay Total Daily Staff Pay . ad the problem statement and the excel spreadsheet by clicking here ave-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, constru Ff Showed Up" (Cell C16) for Monday. Select ] ,C3 Select] ,D3 [Select) E3 F3 G3 ,H3 13 , C5 C11 C12 1-C5 C3:13 A D ,C7:F7 H rameters C8:F8 C9:F9 Mon Tue 0 Fri Sat St Regular Staff Demand 10 1 B . 8 y Staff Maximum Pay $280 Mon Tue Wed Thu Fri Sat Sun er of Staff Showed Up Extra Staff Need umber of Staff Needed Der of Daily Staff Hired Staff Salary per Person Daily Staff Pay Total Daily Staff Pay ed the problem statement and the excel spreadsheet by clicking here o. we-A-Flag problem statement and the excel spreadsheet screenshot above. Usipa dendan contact Showed Up" (Cell C16) for Monday. [Select ] ) C3) + [Select) Select) D3) E3) . 3 F3) G3) 1 ts H3) , 13) C5) C11) ,C12) 1-C5) C3:13) ,c7:F7) C8F8) C9:F9) 0) 1) A B E F rameters Wed Thu Mon 10 Tue 8 Regular Staff Demand 9 8 c B D E G H 1 Input Parameters 2 Mon Tue Wed Thu Fri Sat Sun 3 Regular Staff Demand 10 8 9 8 16 18 16 4 5 Staff No Show Rate 5% 6 7 Busyness Level 1 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 here to Consider the Have A Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra Staff Need" (Cell C17)for Monday Select Select [Select Set 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. Mon Tue Wed Thu Fri Sat Regular Staff Demand 10 8 9 Sun 16 8 16 18 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 $289 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 c D E F G H B 1 Input Parameters 2 3 Regular Staff Demand Mon 10 Tue 8 Thu Wed 9 8 Fri 16 Sat 18 Sun 16 2 5 Staff No Show Rate 5% 6 7 Busyness Level 1 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 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 22 Total Daily Staff Pay You can download the problem statement and the excel spreadsheet by clicking here ia Consider the Have A Flat problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Number of Staff Showed Up" (Cell C16) for Monday Thu Select 12 Daily Staff Maximum Pay $280 13 14 Calculations 15 Mon Tue Wed Thu Fri Sat 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 here . Consider the Have-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construc "Number of Staff Showed Up" (Cell C16) for Monday. [ Select) Select] Select) Select =MING =MAX =( GenBinomial =RANDBETWEEN GenPoisson -GenUniform =Gen Triangular GenNormal GenTablet simParameter SimOutput ForGTE 2 3 B C D E F G H Mon Tue Wed Thu C aily Staff Minimum Pay ily Staff Maximum Pay $200 $280 as Mon Tue Wed Thu Fri Sat ber of Staff Showed Up Extra Staff Need Humber of Staff Needed ber of Daily Staff Hired - Staff Salary per Person Daily Staff Pay Total Daily Staff Pay ad the problem statement and the excel spreadsheet by clicking here ve-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construc Ef Showed Up" [Select ] C3 D3 [Select] [Select] E3 F3 G3 H3 13 C5 C11 C12 1-C5 C3:13 C7:F7 C8:F8 C9:F9 0 1 A E F G H arameters Wed Thu Regular Sta Fri 16 9 8 Sat 18 Sun 16 aily Staff Minimum Pay aily Staff Maximum Pay $200 $280 ins Mon Tue Wed Thu Fri Sat hber of Staff Showed Up Extra Staff Need Vumber of Staff Needed mber of Daily Staff Hired Staff Salary per Person Daily Staff Pay Total Daily Staff Pay . ad the problem statement and the excel spreadsheet by clicking here ave-A-Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, constru Ff Showed Up" (Cell C16) for Monday. Select ] ,C3 Select] ,D3 [Select) E3 F3 G3 ,H3 13 , C5 C11 C12 1-C5 C3:13 A D ,C7:F7 H rameters C8:F8 C9:F9 Mon Tue 0 Fri Sat St Regular Staff Demand 10 1 B . 8 y Staff Maximum Pay $280 Mon Tue Wed Thu Fri Sat Sun er of Staff Showed Up Extra Staff Need umber of Staff Needed Der of Daily Staff Hired Staff Salary per Person Daily Staff Pay Total Daily Staff Pay ed the problem statement and the excel spreadsheet by clicking here o. we-A-Flag problem statement and the excel spreadsheet screenshot above. Usipa dendan contact Showed Up" (Cell C16) for Monday. [Select ] ) C3) + [Select) Select) D3) E3) . 3 F3) G3) 1 ts H3) , 13) C5) C11) ,C12) 1-C5) C3:13) ,c7:F7) C8F8) C9:F9) 0) 1) A B E F rameters Wed Thu Mon 10 Tue 8 Regular Staff Demand 9 8 c B D E G H 1 Input Parameters 2 Mon Tue Wed Thu Fri Sat Sun 3 Regular Staff Demand 10 8 9 8 16 18 16 4 5 Staff No Show Rate 5% 6 7 Busyness Level 1 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 here to Consider the Have A Flag problem statement and the excel spreadsheet screenshot above. Using dropdowns, construct "Extra Staff Need" (Cell C17)for Monday Select Select [Select Set