Need help on how to solve this with the solver tool and equations to put in.

Store Name: Owner Name: Spring 2020 Finest Flora Flowers Salina Flores Job Order Individual shops offer a fresh flower arrangement service to businesses. Finest Flora Flowers staff members daily prepare arrangements and deliver the product to the business customers. The new business is quite profitable for on-time deliveries. However, it is common that a late delivered order is rejected resulting in a loss of profit and potentially a loss of future sales. In order to reduce the average hours late, the manager Salina has created a spreadsheet to aid in determining the schedule for these orders. The worksheet JobOrder lists the jobs in order they were received. Employee Scheduling The employees enjoy working for Finest Flora Flowers as a part-time sales representatives. However, the part-time employees each need to work at least 3 days per week to maintain their sales expertise but no more than 4 days per week (to avoid paying benefits). The garden nursary needs only 2 or 3 employees per day. Salina has consistently collected information on sales by each part-time sales representative. Surprisingly, each person seems to have a pattern of selling better on some days than others. The average sales by each sales representative by day is listed on the Employee Scheduling worksheet. Use SOLVER and this information to determine when each employee should work in order to maximize total sales. NOTE: An assignment problem is a special case of the transportation problem. The 'total employees needed' correspond to 'total demand' on the transportation model. Constrain all the changeable cells as binary. A value of 1 means the employee is working on a particular day and a zero means the employee is not working on that particular day. Use the Simplex LP solving method for quick results. (13 x fx B C D E Average Daily Sales by Sales Staff (do not change these values) Employees Days Mon Tue Wed Thu Milton $ 990 $ 630 $ 999 $ 909 Salina ###### $ 945 $ 909 ###### Lilly $ 630 $ 999 $ 873 $ 972 Neil $ 999 $ 909 ###### $ 873 Elliott $ 972 $ 990 $ 630 $ 999 Fri $ 630 $ 972 ###### $ 945 $ 909 Sat $ 990 ###### ###### $ 873 $ 630 $ $ $ $ $ Sun 1,035 630 747 972 990 10 11 Work Assignment Table Total Days Scheduled per Week 12 Mon Tue Wed Thu Fri Sat Sun 13 14 15 Employees Days Milton Salina Lilly Neil Elliott Number of employees scheduled per day 16 17 18 19 Max Sales= 20 21 Store Name: Owner Name: Spring 2020 Finest Flora Flowers Salina Flores Job Order Individual shops offer a fresh flower arrangement service to businesses. Finest Flora Flowers staff members daily prepare arrangements and deliver the product to the business customers. The new business is quite profitable for on-time deliveries. However, it is common that a late delivered order is rejected resulting in a loss of profit and potentially a loss of future sales. In order to reduce the average hours late, the manager Salina has created a spreadsheet to aid in determining the schedule for these orders. The worksheet JobOrder lists the jobs in order they were received. Employee Scheduling The employees enjoy working for Finest Flora Flowers as a part-time sales representatives. However, the part-time employees each need to work at least 3 days per week to maintain their sales expertise but no more than 4 days per week (to avoid paying benefits). The garden nursary needs only 2 or 3 employees per day. Salina has consistently collected information on sales by each part-time sales representative. Surprisingly, each person seems to have a pattern of selling better on some days than others. The average sales by each sales representative by day is listed on the Employee Scheduling worksheet. Use SOLVER and this information to determine when each employee should work in order to maximize total sales. NOTE: An assignment problem is a special case of the transportation problem. The 'total employees needed' correspond to 'total demand' on the transportation model. Constrain all the changeable cells as binary. A value of 1 means the employee is working on a particular day and a zero means the employee is not working on that particular day. Use the Simplex LP solving method for quick results. (13 x fx B C D E Average Daily Sales by Sales Staff (do not change these values) Employees Days Mon Tue Wed Thu Milton $ 990 $ 630 $ 999 $ 909 Salina ###### $ 945 $ 909 ###### Lilly $ 630 $ 999 $ 873 $ 972 Neil $ 999 $ 909 ###### $ 873 Elliott $ 972 $ 990 $ 630 $ 999 Fri $ 630 $ 972 ###### $ 945 $ 909 Sat $ 990 ###### ###### $ 873 $ 630 $ $ $ $ $ Sun 1,035 630 747 972 990 10 11 Work Assignment Table Total Days Scheduled per Week 12 Mon Tue Wed Thu Fri Sat Sun 13 14 15 Employees Days Milton Salina Lilly Neil Elliott Number of employees scheduled per day 16 17 18 19 Max Sales= 20 21