A bank needs exactly two employees working each hour from 9 a.m. to 5 p.m. Workers can work the shifts and are paid the wages listed in the file P04_74.xlsx. For example, a worker working 9 a.m. to 2 p.m. is paid $42.00. Find an assignment of workers that provides enough workers at minimum cost. (Is it even possible to have exactly two employees working each hour? If not, make sure at least two are working each hour.) P04 74.xlsx Algemployees A bank needs exactly two employees working each hour from 9 a.m. to 5 p.m. Workers can work the shifts and are paid the wages listed in the file P04_74.xlsx. For example, a worker working 9 a.m. to 2 p.m. is paid $42.00. Find an assignment of workers that provides enough workers at minimum cost. (Is it even possible to have exactly two employees working each hour? If not, make sure at least two are working each hour.) 5 Problem 42 points 5 Problem s point 11 Numbers hired for various shifts 1) Numbrired able for hourly periods 12PM 3PM IPM 4PM 15 Employees w 16 Hours 12 9-10 18 10-11 19 11-12 2012-1 22 23 23 34 26 Totalcos P04 74.xlsx 1 Assigning employees 3 Shift 4 Hours 5 Cost 9 AM to 2 PM $50.00 9 AM to Noon $28.50 Noon to 3 PM $28.50 Noon to 5 PM $50.00 2PM to 5 PM $28.50 1 PM to 4 PM $28.50 3PM to 5 PM $18.00 A bank needs exactly two employees working each hour from 9 a.m. to 5 p.m. Workers can work the shifts and are paid the wages listed in the file P04_74.xlsx. For example, a worker working 9 a.m. to 2 p.m. is paid $42.00. Find an assignment of workers that provides enough workers at minimum cost. (Is it even possible to have exactly two employees working each hour? If not, make sure at least two are working each hour.) P04 74.xlsx Algemployees A bank needs exactly two employees working each hour from 9 a.m. to 5 p.m. Workers can work the shifts and are paid the wages listed in the file P04_74.xlsx. For example, a worker working 9 a.m. to 2 p.m. is paid $42.00. Find an assignment of workers that provides enough workers at minimum cost. (Is it even possible to have exactly two employees working each hour? If not, make sure at least two are working each hour.) 5 Problem 42 points 5 Problem s point 11 Numbers hired for various shifts 1) Numbrired able for hourly periods 12PM 3PM IPM 4PM 15 Employees w 16 Hours 12 9-10 18 10-11 19 11-12 2012-1 22 23 23 34 26 Totalcos P04 74.xlsx 1 Assigning employees 3 Shift 4 Hours 5 Cost 9 AM to 2 PM $50.00 9 AM to Noon $28.50 Noon to 3 PM $28.50 Noon to 5 PM $50.00 2PM to 5 PM $28.50 1 PM to 4 PM $28.50 3PM to 5 PM $18.00