Author: Lucas Pedretti

Predictive Analytics with Excel

How Do You Do Predictive Analytics in Excel Without Rocket Science? The Easiest Sales Forecasting Template.

 
You know the problem entirely. You are using Excel for your sales forecast. Your spreadsheet reports your next quarter revenue, and you need a reliable result.

Accurately forecasting sales is critical for your job. You are an experienced sales manager and have a strong affinity to sales analytics. Only with precise sales forecasts can you negotiate healthier sales goals with your team and management.

With reliable sales predictions, you can improve your sales process and prioritize accounts.

How do you forecast sales today?

(more…)

Vertriebscontrolling-Kunstliche-Intelligenz

Artificial Intelligence Example to Rock Sales Controlling in B2B

Machine learning (ML) and artificial intelligence (AI) hold the key to a tremendous improvement in sales controlling efficiency. A software is intelligent if it can solve problems independently and efficiently.

 

The degree of intelligence depends on the level of autonomy, the extent of complexity of the problem, and the efficiency of the problem-solving process. In artificial intelligence terms, researchers speak of “strong” versus “weak” AI – “general” and “narrow” AI, respectively.
(more…)

Sales & Operations Planning

The Five SALSA Principles of Effective Sales and Operations Planning

Sales and Operations Planning (S&OP) is probably the most important planning process of any company. It will determine the difference between success and failure in the years to come.

Usually, the S&OP includes a list of open sales deals, an updated sales forecast, production plan, inventory plan, customer lead time (backlog) plan, new product development plan, strategic initiative plan and the resulting financial plan.

 

(more…)

Future of industrial distribution

The future of B2B industrial distribution in Germany.

 
Make the first steps to becoming a leader in the German market.

Germany and the US are two advanced, yet different industrial markets, with special sales and investment cycles. They have, however, plenty of parallels as developed economies.

Both are under the top largest in the world; built on years of intensive research, development, and industrial innovation. Similarly, the US and the German market is decentralized and varied, with interests and preferences differing from region to region.

(more…)

Preispolitikanalyse und Kundenabwanderung

The relationship between customer churn and pricing analytics

 
Customer Churn Trigger Analysis: Why You cannot separate it of pricing.

Think for a moment of the last time you visited your favourite restaurant and had your favourite dish. In my case, it was an Argentinean filet together with a glass Rioja. How much did you pay? How much more will you spend in the future before stopping going altogether to that restaurant?

If you a regular patron of gastronomic premises, be a restaurant or a pub, you understand my point. You know that there is a certain price level where you would stop going to the place. Bear in mind that visiting a restaurant was commonplace before this current pandemic started and will return once it ends.
(more…)