Lab Assignment: Application to Linear Programming: Riverside employee may employ people on full time or part time basis. Their opening hours are from 09.00 to XXXXXXXXXXAfter some research the bank...


1) Single Page report explaining the problem and your solution. You should also consider the sensitivity report to discuss, briefly any trade-offs between levels of service and cost.


2) Your completed excel workbook with a solution and sensitivity report.


3) Use solver in excel. (Simplex linear program)




Lab Assignment: Application to Linear Programming: Riverside employee may employ people on full time or part time basis. Their opening hours are from 09.00 to 19.00. After some research the bank has found that they need at least 1 staff member to serve 15 customers per hour: Time Period Number of Employees Time Expected Demand Staff Required 09:00--10:00 78 6 10:00--11:00 110 8 11:00--12:00 90 6 12:00--13:00 160 11 13:00--14:00 200 14 14:00--15:00 125 9 15:00--16:00 60 4 16:00--17:00 55 4 17:00--18:00 60 4 18:00--19:00 90 6 The employee can start at 09:00, 10:00, etc., but they must finish by 19:00. Full time employees work 4 hours, have 1 hour lunch, and then work a further 3 hours. They do not get paid for lunch hour. Part-time employees work 4 hours continuously. A full-time employee gets paid $18/hour and a part-time gets $17/hour. The bank wants to minimise the total cost and needs to find out how many full-time and part-time employees they should hire. They also want to know how many of them should start at 09.00, at 10:00. Etc., solve the problem using Linear Programming (LP) model. For Submission 1) One Page report explaining the problem and your solution. You should also consider the sensitivity report to discuss, briefly any trade-offs between levels of service and cost. 2) Your completed excel workbook with solution and sensitivity report. Lab Assignment: Application to Linear Programming: Riverside employee may employ people on full time or part time basis. Their opening hours are from 09.00 to 19.00. After some research the bank has found that they need at least 1 staff member to serve 15 customers per hour: Time Period Number of Employees Time Expected Demand Staff Required 09:00 -- 10:00 78 6 10 :00 -- 1 1 :00 110 8 11 :00 -- 12 :00 90 6 12 :00 -- 13 :00 160 11 13 :00 -- 14 :00 200 14 14 :00 -- 15 :00 125 9 15 :00 -- 16 :00 60 4 16 :00 -- 17 :00 55 4 17:00 -- 18:00 60 4 18:00 -- 19:00 90 6 The employee can start at 09:00, 10:00, etc., but they must finish by 19:00. Full time employees work 4 hours, have 1 hour lunch, and then work a further 3 hours. They do not get paid for lunch hour. Part - time employees work 4 hours continuously. A full - time employee gets paid $18/hour and a part - time gets $17/hour. The bank wants to minimise the total cost and needs to find out how many full - time and part - time employees they should hire. They also want to know how many of them should start at 09.00, at 10:00. Etc., solve the problem using Linear Programming (LP) model. For Submission 1) One Page report explaining the problem and your s olution. You should also consider the sensitivity report to discuss, briefly any trade - offs between levels of service and cost. 2) Your completed excel workbook with solution and sensitivity report. Lab Assignment: Application to Linear Programming: Riverside employee may employ people on full time or part time basis. Their opening hours are from 09.00 to 19.00. After some research the bank has found that they need at least 1 staff member to serve 15 customers per hour: Time Period Number of Employees Time Expected Demand Staff Required 09:00--10:00 78 6 10:00--11:00 110 8 11:00--12:00 90 6 12:00--13:00 160 11 13:00--14:00 200 14 14:00--15:00 125 9 15:00--16:00 60 4 16:00--17:00 55 4 17:00--18:00 60 4 18:00--19:00 90 6 The employee can start at 09:00, 10:00, etc., but they must finish by 19:00. Full time employees work 4 hours, have 1 hour lunch, and then work a further 3 hours. They do not get paid for lunch hour. Part-time employees work 4 hours continuously. A full-time employee gets paid $18/hour and a part-time gets $17/hour. The bank wants to minimise the total cost and needs to find out how many full-time and part-time employees they should hire. They also want to know how many of them should start at 09.00, at 10:00. Etc., solve the problem using Linear Programming (LP) model. For Submission 1) One Page report explaining the problem and your solution. You should also consider the sensitivity report to discuss, briefly any trade-offs between levels of service and cost. 2) Your completed excel workbook with solution and sensitivity report.
Jun 15, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here