Developing your skills
Beacon don't just give you the tools, we can teach them how to use them yourselves to give your business a lasting advantage.
Excel© Masterclass
Rationale for attendance
With Microsoft Excel© is an exceptionally powerful data analysis tool, but many mangers use of only a small fraction of its potential.
This course will help the reasonably competent Excel© user to unlock the power of this application and produce really effective spreadsheet models and reports.
Outline programme
- Excel special functions
- Logical functions
- Database functions
- Time and date functions
- Excel tools
- Reporting tools
- What-if analysis tools
- Auditing tools
- Model optimisation tools
- Excel automation
- Writing and recording macros
- Introduction to Excel Visual Basic
Forecasting for Established Products
This course looks at a range of analytical techniques that will help participants forecast and analysis sales and use of existing products. This can help you manage profitable levels of stock, assess the impact of marketing or map your products life cycle.
Outline programme
- Statistical Concepts
- Variability
- Forecast errors
- Confidence Limits
- Analysing historical sales data
- Growth patterns
- Seasonality
- Smoothing techniques
- Identifying causal relationships
- Correlation and regression
- Residual analysis
- Modelling discreet events, e.g. patent expiry
Modelling Pharmaceutical Markets
The commercial environment for pharmaceutical companies is increasingly complex. Sometimes past behaviour is not a good guide to future performance. You need a number of models that will show us how products may perform under a number of scenarios. Idea of events such as product launches, competitor threats and market development.
The course covers various techniques that that are flexible and robust that can design and develop complex scenarios quickly and effectively.
Outline programme
- The modelling process
- Model design
- Model building
- Model testing and operation
- Different model types
- Deterministic models: linear programming
- Probabilistic models: Monte Carlo simulation
- Specific applications
- Modelling patient cohorts over time
- Patient acquisition and retention
- Modelling discreet events, e.g. patent expiry
Financial Management
The course looks at how financial statements are constructed and the key management ratios that can be used to assess company performance. We go on to cover various methods for valuing projects such as marketing programmes, products and their life cycle, and companies. It also looks at the relationship between risk and return.
Outline programme
- Financial statements
- Balance sheet
- Profit and loss statement
- Cash flow statement
- Key management ratios
- Valuation methods
- Discounted cash flow
- Internal rate of return
- Net present value
- Investing and risk
- Sources of risk
- Evaluating risk
- Managing risk across a portfolio
Strategic Planning
Rationale for attendance
This course shows how effective strategies can be developed through application of tried and tested methods. Participants will gain useful practical experience through selected case studies and simulations.
Course Outline
- Strategic analysis
- Analytical frameworks
- Competitive analysis
- Internal analysis
- Strategic Choice
- Elements of strategy
- Product, business unit and company strategy
- Alternative strategies
- Strategic Implementation
- Strategy and organisational structure
- Control and monitoring
- Change management
Our Clients
Beacon's client list includes some of the world's leading healthcare corporations.
- Novartis
- Novo-Nordisk
- Norgine
- Orphan Europe
- Pfizer
- Roche
- Sanofi-Aventis
- Schering-Plough
- Solvay
- Waymade
- Abbott
- AstraZeneca
- Bayer
- Celltech
- Cephalon
- Dabur Oncology
- Kyowa
- Lilly
- Merck AG
- MSD