Controlling in Sales and Marketing

Who is the workshop intended for?

The training program “Controlling in Sales and Marketing” is aimed at owners, managers and risk specialists, strategic planning, controlling, internal auditing, monitoring compliance and other organizational units dealing with business environment analysis, strategic guidelines and business operations and a holistic approach to risk management.

Training objectives

The participants of the training will consider basic risk management concepts arising from the business environment, identify the prerequisites for effective strategic risk management, identify significant risks and independently create a risk map.

Workshop content

• Business environment risks
• the concept and methodology of business risk management
• the correlation of business environment and business risk
• monitoring the risks of the business environment
• Example of overcoming the business environment risk (practical exercise)
• Current economic trends and business environment risks
• economic trends
• identifying risks specific for business operations
• methods of overcoming risks arising from the business environment
• Determining the methods of overcoming risks coming from business events (Practical Exercise)
• Risk categorization depending on the organization’s business operations
• identification and risk analysis
• the risks caused by exogenous (external) or endogenous (internal) circumstances
• readiness for events that are not directly related to business
• Risk map (practical exercise)
• Strategic, management and other risks
• concept, definition and examples of strategic and managerial risk
• establishing and evaluating
• the methodology of mastering strategic and managerial risks
• strategic, managerial and other risk management, strategic, management and other risks
• Recognizing risk from the business case (practical exercise)
• The most commonly used formulas for risk management
• frequency of use of Excel® formulas and procedures for risk management
• examples of 5 most commonly used formulas and procedures
• added value
• Examples of using the Excel® formula (practical exercise)
• Using Excel® to improve risk management performance
  • pivot tables
  • process automation
  • the most common procedures for data mining on VBA (Visual Basic Application) and risk management
• An example of Pivot Tables for quick data analysis (practical exercise)
• Risk management methods and Excel®
• risk value – Value at Risk (VaR)
• simulation
• stress tests
• Example stress test in Excel® (practical exercise)
• Monte Carlo simulations
• What is the Monte Carlo simulation?
• When to use the Monte Carlo simulation?
• making and analyzing the Monte Carlo simulation model
• An example of Monte Carlo simulation in Excel® (practical exercise).

DURATION: ONE DAY TRAINING PROGRAM 

Finance and Controlling

Controlling in Sales and Marketing