A1-Problem 1 Solved - aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa PDF

Preview

Summary

aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa...

Description

Operations Manag

a) Formulate this problem as an LP model. b) Solve the problem by Excel. What is the best schedule? What is the total cost for the best schedule? Comments a) LP model Let F = Total number of full timers employed (after hiring and firing as needed) P1 = Numberof part-timers hired, who start their shift at 9 am P2 = Numberof part-timers hired, who start their shift at 10 am P3 = Numberof part-timers hired, who start their shift at 11 am

P4 = Numberof part-timers hired, who start their shift at 12 pm P5 = Numberof part-timers hired, who start their shift at 1 pm Objective: Min 75*(12+H-R)+24*(P1+P2+P3+P4+P5) s.t. 9AM - 10AM: F+P1 >= 10 10AM - 11AM: F+P1+P2 >= 12 11AM - 12PM: 0.5F+P1+P2+P3 >= 14 12AM - 1PM: 0.5F+P1+P2+P3+P4 >= 16 1PM - 2PM: F+P2+P3+P4+P5 >= 18 2PM - 3PM: F+P3+P4+P5 >= 17 3PM - 4PM: F+P4+P5 >= 15 4PM - 5PM: F+P5 >= 10 4*(P1+P2+P3+P4+P5)...