Instructions Homework 8: Scheduling Workforce: Page 285-286 Create a spreadsheet with two tabs. One labeled problem 1 and one labeled problem 5. 1st tab: Use the information in problem 1 (page 285) to create a schedule maximizing the number of weekend days off for employees for Bank 24. Hint - use the model we started in class as a starting point and add to it as needed. 2nd tab: Use the information in problem 5 (page 286) to develop a model that will minimize the daily teller costs for the Pine Valley Credit Union. Be sure to identify (or list) in some way the following: - Set objective - Changing cells - All constraints Due on Oct 25, 2023 11:59 PM Instructions Homework 8: Scheduling Workforce: Page 285-286 Create a spreadsheet with two tabs. One labeled problem 1 and one labeled problem 5. 1st tab: Use the information in problem 1 (page 285) to create a schedule maximizing the number of weekend days off for employees for Bank 24. Hint - use the model we started in class as a starting point and add to it as needed. 2nd tab: Use the information in problem 5 (page 286) to develop a model that will minimize the daily teller costs for the Pine Valley Credit Union. Be sure to identify (or list) in some way the following: - Set objective - Changing cells - All constraints Due on Oct 25, 2023 11:59 PM \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 5 & Number Starting: & Day Worker Starts: & Monday & Tuesday & Wednesday & Thursday & Friday & Saturday $ & Sunday \\ \hline 6 & & 7 Monday & 1 & 1 & 1 & 1 & 1 & 0 & \\ \hline 7 & 2 & 2. Tuesday & 0 & 1 & 1 & 1 & 1 & 1 & \\ \hline 8 & 0 & o Wednesday & 0 & 0 & 1. & 1 & 1 & 1 & 1 \\ \hline 9 & & 4 Thursday & 1 & 0 & 0 & 1 & 1 & 1. & 1 \\ \hline 10 & & 1 Friday & 1 & 1 & 0 & 0 & 1 & 1 & 1 \\ \hline 11 & & 2 Saturday & 1 & 1 & 1 & 0 & 0 & 1 & 1 \\ \hline 12 & & 6 Sunday & 1 & 1 & 1. & 1 & 0 & 0 & 1 \\ \hline 13 & & Number Working: & 20 & 18 & 17 & 19 & 14 & 9 & 13 \\ \hline 14 & & & & & & & & & \\ \hline 15 & a & Numbers Needed: & 17 & 13 & 15 & 17 & 9 & 9 & 12 \\ \hline \begin{tabular}{l} 16 \\ 17 \end{tabular} & & & & & & & & & \\ \hline \end{tabular} Instructions Homework 8: Scheduling Workforce: Page 285-286 Create a spreadsheet with two tabs. One labeled problem 1 and one labeled problem 5. 1st tab: Use the information in problem 1 (page 285) to create a schedule maximizing the number of weekend days off for employees for Bank 24. Hint - use the model we started in class as a starting point and add to it as needed. 2nd tab: Use the information in problem 5 (page 286) to develop a model that will minimize the daily teller costs for the Pine Valley Credit Union. Be sure to identify (or list) in some way the following: - Set objective - Changing cells - All constraints Due on Oct 25, 2023 11:59 PM Instructions Homework 8: Scheduling Workforce: Page 285-286 Create a spreadsheet with two tabs. One labeled problem 1 and one labeled problem 5. 1st tab: Use the information in problem 1 (page 285) to create a schedule maximizing the number of weekend days off for employees for Bank 24. Hint - use the model we started in class as a starting point and add to it as needed. 2nd tab: Use the information in problem 5 (page 286) to develop a model that will minimize the daily teller costs for the Pine Valley Credit Union. Be sure to identify (or list) in some way the following: - Set objective - Changing cells - All constraints Due on Oct 25, 2023 11:59 PM \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline 5 & Number Starting: & Day Worker Starts: & Monday & Tuesday & Wednesday & Thursday & Friday & Saturday $ & Sunday \\ \hline 6 & & 7 Monday & 1 & 1 & 1 & 1 & 1 & 0 & \\ \hline 7 & 2 & 2. Tuesday & 0 & 1 & 1 & 1 & 1 & 1 & \\ \hline 8 & 0 & o Wednesday & 0 & 0 & 1. & 1 & 1 & 1 & 1 \\ \hline 9 & & 4 Thursday & 1 & 0 & 0 & 1 & 1 & 1. & 1 \\ \hline 10 & & 1 Friday & 1 & 1 & 0 & 0 & 1 & 1 & 1 \\ \hline 11 & & 2 Saturday & 1 & 1 & 1 & 0 & 0 & 1 & 1 \\ \hline 12 & & 6 Sunday & 1 & 1 & 1. & 1 & 0 & 0 & 1 \\ \hline 13 & & Number Working: & 20 & 18 & 17 & 19 & 14 & 9 & 13 \\ \hline 14 & & & & & & & & & \\ \hline 15 & a & Numbers Needed: & 17 & 13 & 15 & 17 & 9 & 9 & 12 \\ \hline \begin{tabular}{l} 16 \\ 17 \end{tabular} & & & & & & & & & \\ \hline \end{tabular}