Actual vs. Plan

The Actual vs. Plan analysis should be loaded after you have used the Actual Data menu, under Plan menu, to enter data of the actual performance of the business during the plan years.

The Actual vs. Plan screens are the same as the Actual Data screens:

Profit and Loss

• Cash Flow
• Balance
• Plant and Equipment
• Profit Centers

Revenues/Sales

• Operating Expenses (Budget)

Financial Ratios - The program calculates the main financial ratios based on the data that was entered in the Actual data module. These ratios are displayed and compared to the plan ratios in the Actual vs. Plan module.

Drill Down in Actual Profit & Loss Report

The Profit & Loss report, which is included in the Actual vs. Plan analysis, can now show details for major items such as sales and operating expenses. This makes it easier to understand the variance between Plan and Actual.

The details for an item can be seen if there is a small plus sign [+] on its left. Clicking on the plus sign will expand the detailed lines.

Note: The detailed lines will be available only if detailed data was entered in the Actual Data screens and it matches the totals in the Profit and Loss report. For example, details of the sales line, by products, will be available only of data was entered in the Actual Sales Plan screen and the total of this data matches the Sales value entered in the Actual Profit and Loss screen.

Each screen presents for each of the plan items and for each selected period, the planned figures compared to the actual figures and the variance between them in amounts and percentages.

The period for the analysis is selected in the period dropdown list on the top of the screen.

If the first plan year is detailed in months or quarters the analysis will shows for each month or quarter the figures for this period and the accumulated figures since the beginning of the year. In the Balance screen these two values are actually the same but in all other screens it will be shown in different columns.

The Profit Centers screen and the Revenues/Sales screen include the Market list on the left enabling you to select from the list the market for which you want to view the analysis.

The Operating Expenses screen includes the Department / Expense Group list on the left enabling you to select from the list the department for which you want to view the analysis. The screen includes the three sections: Fixed Expenses, Variable Expenses and Salary & Staff selected with the buttons on the toolbar.

Toolbar Buttons

The toolbar includes the following buttons:

OK - Close screen (and save all changes if applicable)

Print Table - Create a report for the current table, showing it on the print preview screen

Export to MS Excel file - Exports the displayed table to MS Excel