Union Airways is adding more flights to and from its hub airport and so needs to hire additional customer service agents. • The five authorized eight-hour shifts and staffing costs per agent are Shift 1: 6am to 2pm $170 per agent Shift 2: 8am to 4pm $160 per agent Shift 3: 12pm to 8pm $175 per agent Shift 4: 4pm to 12am $180 per agent Shift 5: 10pm to 6am $195 per agent 2 • The volume of calls varies throughout the 24-hour day. The requirements in agents for every 2-hour interval (based on past data) are summarized as 6-8 8-10 10-12 12-2 2-4 4-6 6-8 8-10 10-12 12-6 48 79 65 87 64 73 82 43 52 15 • Formulate the problem as a Linear Programming problem. • How many agents should Union Airways assign to each shift to achieve least cost? (solve using excel).
Please provide excel sheet using solver.