Formulate this problem in excel and solve it. Retailer Staffing problem The campus store has decided to hire some students to work part time helping customers and performing various functions that used to be contracted out to outside vendors. There are two work shifts per day (AM and PM) and the store is open five days a week. Exactly one student must be assigned to each shift. To become sufficiently familiar with the store's operations, each student that is hired must work at least two shifts per week. The store has identified a pool of eight qualified students from which to hire. For each student, the store has estimated how much he or she would add to the store's profit, per shift worked. This information is shown in the table below. The table also marks each shift for which a particular student is available with a 1. Finally, it also gives the maximum number of shifts per week that each student can work. To maximize its profits, which students should the store hire and which shifts should each student work? Student Mon Tue Wed Thu Fri Max shifts Profit /Shift ($) AM PM AM PM AM PM AM PM AM PM CM 100 1 1 1 1 3 FI 50 1 1 1 1 1 4 GR 95 1 1 1 1 1 2 HS 75 1 1 1 1 2 JD 70 1 1 2 JE 90 1 1 1 2 SR 80 1 1 1 1 1 1 3 TR 85 1 1 1 2 Check your answer and layout: CM, GR, JE and SR work and maximum profit is 910