Capacity Analysis Model

When we find the person to work with me it will take some time for you to tell me what data to gather and then for me to get it. Though It will sort of be a training for me to remember how to do this. A statistically minded indivudal who thinks abstract will be great. We are a team that our internal business partners have a growing demand for our group which produces sophisticated, intelligent, and timely dynamically automated sales and client service materials and we need to design a data driven analytical approach to forecasting and measuring capacity needs required to support our internal business partners Financial Products. If you know ho wto use Minitab and are familar with six sigma even though this is not a ss project it would be helpful. The Alert Notification —Staffing Capacity model measures capacity. Excess and insufficient capacity should be calculated. Alert Notification —Staffing Capacity design is an analytical forecast model measuring resource efficiency, assumes a team’s capability of exceptionally high yields, and ensures ability to provide robust process variations. There is a business group that has 28 people broken up into three teams who all work together to create dynamically automated financial reports, presentations etc... The groups teams are Automation designers; Program Management and Production people Automation - 7 people consisting of two senior designers and 1 manager who is a sr designer and 4 very junior people. Training take 1.5 to 2 years. Project Management - 4 1 manager who is sr and works and 3 more average workers who need some hand-holding Testing - 3 people - all new Production - 13 people fairly senior and god at what they do. The group maintains production about 250k unique documents from about 12 different types of output. These document contain dynamic data from various outside data and content sources. These document are sales presentations, client presentations, client updates, financial product brochures - 6 page and 2 page. Need to create a capacity model which can be updated, alert when staff is unable to meet current deliverables or agreed upon deliverable for the year to come, by how much capacity, where is the deficit - what team, what skill level, etc. Note: Deliverables are fairly consistent we will be able to to use metrics gathered for like products to be created. There are only about 6 different types of output though the support 100's of different financial products and are supported in about 20 languages. Which mean different legal disclaimers for the same product that is going to different global regions. The business group is understaffed with Sr level people who can accurately, timely and consistently maintain current production and the quarterly enhancements to materials in production receive; create new materials for new Products coming onto the market and handle new projects. The senior staff trains junior staff and time is taken away from "work" The need to is to create a capacity model. I believe we need to break down the components of each groups activities throughout the various output types, give capacity value etc. This requires process flows, raw data etc. I want someone who knows data, what type of data should we start to capture or create and like to tell a story with graphics. Cause and Effect, Pareto and etc charts used in MInitab