Troops - Workforce Movement: Decide how many troops to move from several camps to several other bases, to minimize movement time or total cost.HireFire - Workforce Composition: Decide how many employees to retrain, hire and fire to meet changing workforce composition requirements while minimizing costs or employee turnover. Sched3 - Employee Scheduling with Seniority and Preferences: Schedule park employees for weekly "shifts" to minimize payroll costs while meeting demand, taking into account employee seniority and preferences.Sched2 - Employee Scheduling with Preferences: Schedule park employees for weekly "shifts" to minimize payroll costs while meeting demand and maximizing employee preferences.Sched1 - Employee Scheduling: Schedule park employees for weekly "shifts" (five works days plus two consecutive days off) to minimize payroll costs while meeting varying demand for each day of the week.Offices - Office Assignment: Assign employees to available offices to maximize satisfaction of employee preferences.Crew - Crew Scheduling: Assign crews to different airline flight segments to minimize total cost while ensuring that a crew "rotation" begins and ends in the same city.Or, if you would prefer to view the examples in your browser, rather than in Excel, click the links below. You can then actually solve these small example models in Excel, using the standard Excel Solver, Analytic Solver Upgrade or Analytic Solver Optimization. Right-click Scheduling Examples.xls and select Save Target As.To download and save the workbook if you are using Excel 2003 or earlier: Right-click Scheduling Examples.xlsx and select Save Target As.Solving your real problem may require "scaling up" the model to include more variables and constraints - but rest assured that you can solve your full-size problem with the power of our Excel Solver upgrades, even if it requires hundreds of thousands of variables! To download and save the workbook if you are using Excel 2007 or later: You can use the worksheet that most closely models your situation as a starting point. Click the model names to display each worksheet model in your browser. This free workbook contains seven example models from personnel scheduling.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |