Analysis of the plan

The creation of a business plan is followed by its analysis. Plans can be compared with realisation. We also have an inflow and outflow planning tool.

We will present the analysis of the plan in the example below.

CASE SUMMARY The responsible person has created a business plan for Tecta's in-house café for 2020. The plan contains values for sales, purchases, financial indicators and wage costs. The plan is to be analysed and compared with realisation. It also wants to see a plan of inflows and outflows. It does this as follows: Choosing a plan for analysis Analysing the plan Planning of inflows and outflows

1. Choosing a plan for analysis

To analyse a plan, we need to have a planning document already created.

The person responsible wants to analyse the plan for Tecta's in-house café.

In the navigation bar, select Analytics - Planning - NA00 - Planning from the menu.

Clicking on the button 'three dots', on the command line, opens the window of the created planning documents.

The responsible person selects the desired plan and opens it by double-clicking it or by clicking the Confirm button.

The planning document opens on the Background tab. The person responsible for the analysis opens the Analysis tab.

It goes on to analyse the plan.

2. Analysing the plan

On the Analysis tab, select the type of plan you want to analyse and all the other details of the analysis.

In our case, it wants to analyse the sales plan, so it selects the Sales plan from the drop-down list.

There are also plan options:

• Purchasing
• Finance
• Payroll

Selects the comparison by value and by position as the plan is made.

HINT An analysis is presented comparing the value of the planned with the value of the realised, and an index is provided.

The responsible person wants to see the sales totals, so he selects the Total radio button.

HINT The user can choose between ritual displays of the plan analysis. Read more in Analysis.

The analysis is created by clicking on the Calculate button.

The analysis shows planned sales compared to actual sales. Realised sales are the sum of all issue documents from the BAR warehouse during the selected period.

For each period, we also see an index of achievement of the target value (as shown in the figure below).

In the last columns, we also see a comparison between the total planned value and the realised value.

Click on the (Export to excel) button in the toolbar to save the analysis to an Excel file.

The responsible person also wants to analyse the procurement, finance and payroll plans.

Select the desired plan from the drop-down menu and repeat the steps to analyse the sales plan.

This completes the analysis of the plan and can feed into the planning of inflows and outflows.

3. Inflow and outflow planning

Inflow and Outflow Planning is designed to provide an overview of expected cash flow on a planning basis, either by entity or in aggregate.

Tab Plan of the Annex/Separation. is found on the planning document.

The person in charge wants to check the cash flow on a planning basis for the local Tecta bar. He/she selects the planning document and clicks to open the Plan app.Plan app.

The cash flow plan is created by clicking on the Order button.

A cash flow plan is created based on the business planning of Tecta's in-house café. The responsible person can plan monthly inflows, outflows and balances.

He wants to export the data to password-protected Excel. In the toolbar, he selects the (Export to Excel with lock) button and saves the Excel file.

WARNING To export to Excel with locking, we need to set a password for Export Settings on the Basic Data tab of the planning document.

This concludes the analysis of the plan.