Question 2: A manager has 7 part-time workers and needs to assign different working days to them. The maximum number of days each worker is available in each month is shown in the below table. The worker's salary is different based on their skill level as shown in the table. The senior-level and junior-level workers should work at least 10 and 15 days during the time period from January to May, respectively. There are only 13 working days in each month with exactly one worker on duty during these days. The manager needs to determine the number of days each worker should work per each month so that the total cost will be minimized. Formulate the problem and recommend the best plan to the manager? Worker Jan Junior 1 8 Junior 2 3 Junior 3 3 Junior 4 0 Senior 1 Senior 2 Senior 3 305 Number of days available Mar Apr 3 0 2 0 5 3 5 2 Feb 0 5 5 5 1 3 3 3 4 5 0 01 6 5 May 564NS 2 4 0 0 Pay rate per day $100 $110 $120 $90 $150 $130 $140

need algebric and excel

Question 2: A manager has 7 part-time workers and needs to assign different working days to them. The maximum number of days each worker is available in each month is shown in the below table. The worker's salary is different based on their skill level as shown in the table. The senior-level and junior-level workers should work at least 10 and 15 days during the time period from January to May, respectively. There are only 13 working days in each month with exactly one worker on duty during these days. The manager needs to determine the number of days each worker should work per each month so that the total cost will be minimized. Formulate the problem and recommend the best plan to the manager