Send the link below via email or IMCopy
Present to your audienceStart remote presentation
- Invited audience members will follow you as you navigate and present
- People invited to a presentation do not need a Prezi account
- This link expires 10 minutes after you close the presentation
- A maximum of 30 users can follow your presentation
- Learn more about this feature in our knowledge base article
Do you really want to delete this prezi?
Neither you, nor the coeditors you shared it with will be able to recover it again.
Make your likes visible on Facebook?
Connect your Facebook account to Prezi and let your likes appear on your timeline.
You can change this under Settings & Account at any time.
Transcript of Senior Design
Scheduling Output! Questions? Final Thoughts and Impact One or more tasks per project
One skill per task
Employees assigned proficiency for each skill: Graphical Front-End Project Background Project Assumptions The Big Picture John Harris and Michael Moore Historically known as an accounting firm
Building their Business Intelligence (BI) consulting practice
Has staffing issue and could benefit from better resource allocation Project Objectives: Assign the right personnel to the right job
Identify the necessary skills and personnel for training
Determine effectiveness of the model Determines resource availability
Takes skill sets into account
Satisfies the skill requirements for the schedule Develop linear programming model that: 0 = no skill, can’t complete task without training
1 = Low proficiency: 33% of level 3
2 = Medium proficiency: 67% of level 3
3 = High proficiency: 100% efficiency Skill efficiency per period ≥ 100%
Employees assigned task, training, or unbillable time
External contractors hired to fill voids
All outside resources are same (cost and skill) Complex Back-End Useable by Non-Technical People
Creates Complex Models
Light-weight and Easy to Deploy Runs an AMPL Model
Nuts and Bolts
Over 2 million nodes Objective Function: Minimizes the number of employee assignments.
X: Assignment of an employee to a task
Y: Assignment of a contractor
Z: Assignment of an employee after training Constraints: