Unformatted text preview: period.) For the purpose of this lab, we assume you can hire staff in fraction, i.e. some tellers might not work full month. (What if you can not hire staff in fraction? Then it is an integer programming problem, and much harder to solve optimally.) Please formulate the LP problem first and then use Excel Solver to generate the optimal workforce plan in terms of number of trainees you hire each month and number of available tellers at each month. Hint: You can use the following notations T t = number of trainees hired at the beginning of month t for t = 1,…6 A t = number of tellers available at the beginning of month t for t = 1,…,6 Turn-in Format Please turn in the LP formulation, printout of the Excel worksheet, the answer report and the sensitivity report from Excel Solver. You also need to summarize your workforce plan and interpret the sensitivity analysis results in your own words....
View Full Document
- Fall '09
- Operations Research, 6 months, $600, $300, 10 percent, 80 hours