How do I do this using Solver?

Formula for this part:

Problem 1 - Staffing You have recently earned a promotion at the Mudsock Zoo, and you will be in charge of running the African animal exhibit. Thus, you are tasked with staffing your employees between the hours of 5am and 1am daily. Employees work eight-hour shifts. You have two types of employees: standard employees and trained employees. Due to safety regulations, only the trained employees are certified to handle the animals. The requirements for the number of employees needed are dependent on how many visitors are expected to pass through the exhibit during various hours. The zoo believes that the need for attendants between the hours of 5am and 1am are as in the table below: Period Time Employees Required 1 17 2 23 3 5am - 9am 9am -1pm 1pm - 5pm 5pm - 9pm 9pm - 1am 27 4 15 5 7 Attendants begin their shifts either at 5am, 9am, 1pm, or 5pm. The shifts are designated A, B, C, and Drespectively. The Zoo's policy is that at least 60% of the employees on any shift are trained. Standard employees are paid $17.50/hour and trained employees are paid $28.00/hour. Formulate as an integer program to determine the number of standard and trained employees that minimizes the total cost without violating any constraints. Note: A template is provided for this problem and is meant to give you an idea of how to format the linear program. The number of rows for constraints and columns for decision variables in the template is not the correct number required; you will have to add more. Other good formatting practices include adding a name for each decision variable and constraint. Problems 2 and 3 do not have an associated template and thus will need to be created from scratch with similar formatting to problem 1. Staffing Optimal Solution Objective Function Contraints: RHS $0.00 LHS 0.0 0.0 0.0 0.0 0.0 F7 fx =SUMPRODUCT(B$5:C$5,38:08) A B C D E F G H Nm 1 Staffing 2 3 4 Optimal Solution 5 Objective Function 6 Contraints: 7 $0.00 RHS ova 8 9 0.0 0.0 0.0 0.0 0.0 10 11 12 13 Problem 1 - Staffing You have recently earned a promotion at the Mudsock Zoo, and you will be in charge of running the African animal exhibit. Thus, you are tasked with staffing your employees between the hours of 5am and 1am daily. Employees work eight-hour shifts. You have two types of employees: standard employees and trained employees. Due to safety regulations, only the trained employees are certified to handle the animals. The requirements for the number of employees needed are dependent on how many visitors are expected to pass through the exhibit during various hours. The zoo believes that the need for attendants between the hours of 5am and 1am are as in the table below: Period Time Employees Required 1 17 2 23 3 5am - 9am 9am -1pm 1pm - 5pm 5pm - 9pm 9pm - 1am 27 4 15 5 7 Attendants begin their shifts either at 5am, 9am, 1pm, or 5pm. The shifts are designated A, B, C, and Drespectively. The Zoo's policy is that at least 60% of the employees on any shift are trained. Standard employees are paid $17.50/hour and trained employees are paid $28.00/hour. Formulate as an integer program to determine the number of standard and trained employees that minimizes the total cost without violating any constraints. Note: A template is provided for this problem and is meant to give you an idea of how to format the linear program. The number of rows for constraints and columns for decision variables in the template is not the correct number required; you will have to add more. Other good formatting practices include adding a name for each decision variable and constraint. Problems 2 and 3 do not have an associated template and thus will need to be created from scratch with similar formatting to problem 1. Staffing Optimal Solution Objective Function Contraints: RHS $0.00 LHS 0.0 0.0 0.0 0.0 0.0 F7 fx =SUMPRODUCT(B$5:C$5,38:08) A B C D E F G H Nm 1 Staffing 2 3 4 Optimal Solution 5 Objective Function 6 Contraints: 7 $0.00 RHS ova 8 9 0.0 0.0 0.0 0.0 0.0 10 11 12 13