Posts

Example of a Variable Labor Budget Model for Hospitality Companies

What is a Variable Labor Budget Model?

Variable Labor Budget Models are considered planning and forecasting tools and are used by budget managers and department heads to capture wages by position. Some of the main functionality in this type of input form is that it is uses drivers (typically from an assumptions template) like hourly rates, max/min hours and room occupancy to calculate the labor expenses. You find an example of this type of input form below.

Purpose of Variable Labor Budget Models

Hospitality companies use Variable Labor Budget Models to automate the capturing of detailed labor budgets by department and business unit. When used as part of good business practices in FP&A departments, a company can improve its budget accuracy, and it can reduce the chances that labor expenses are over- or under estimated.

Example of a Variable Labor Budget Model

Here is an example of a departmental input form for Variable Labor Wages.

Example of a Variable Labor Budget Model for Hospitality Companies

Example of a Variable Labor Budget Model for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Input form?

The typical users of this type of input form are: Budget managers, HR managers, department heads.

Other Reports Often Used in Conjunction with Variable Labor Budget Models

Progressive FP&A departments sometimes use several different Variable Labor Budget Models, along with Employee payroll budgets, human capital planning models, profit & loss budgets, historical financial statements, budget analysis dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Variable Labor Budget Assumptions Model for Hospitality Companies

What is a Variable Labor Budget Assumptions Model?

Variable Labor Models are considered planning and forecasting tools and are used by budget managers and HR leaders to automate employee budgets with drivers for wages and benefits. Some of the main functionality in this type of input form is that it is parameter driven and can be populated by business entity, department and position type. Examples of assumptions that can be entered are: Minimum hours, Wage rates, Timing of annual increase, Increment threshold, Productivity ratio, and Maximum hours. You find an example of this type of input form below.

Purpose of Variable Labor Assumption Models

Hospitality companies use Variable Labor Assumption Models to provide a dynamic way to capture drivers of labor costs and automate human capital modelling. When used as part of good business practices in FP&A departments, a company can improve its budget process and speed, and it can reduce the chances that budgets are inaccurate due to hardcoded wages and assumptions.

Example of a Variable Labor Assumption Model

Here is an example of a Variable Labor Assumption Input Form with various drivers.

Example of a Variable Labor Budget Assumptions Model for Hospitality Companies

Example of a Variable Labor Budget Assumptions Model for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Input form?

The typical users of this type of input form are: Budget managers, HR managers, department heads.

Other Reports Often Used in Conjunction with Variable Labor Assumption Models

Progressive FP&A departments sometimes use several different Variable Labor Assumption Models, along with Employee payroll budgets, human capital planning models, profit & loss budgets, historical financial statements, budget analysis dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Monthly Cash Flow Statement for hospitality companies

What is a Trended Monthly Cash Flow Statement?

Trended Cash Flow Statements are considered financial reporting tools and are used by CFOs and Controllers to monitor sources and uses of cash and net cash flow. Some of the main functionality in this type of report is that it is parameter driven and automatically displays months up to the current period across the columns. The rows of the report shows a typical layout of a financial statement. You find an example of this type of report below.

Purpose of Trended Cash Flow Reports

Hospitality companies use Trended Cash Flow Reports to analyze trends in sources and uses of cash. When used as part of good business practices in FP&A departments, a company can improve its liquidity and strategic investment options, and it can reduce the chances that unexpected cash flow trends leads to surprises.

Example of a Trended Cash Flow Report

Here is an example of a Trended Cash Flow Statement with exception highlighting.

Example of a Monthly Cash Flow Statement for hospitality companies

Example of a Monthly Cash Flow Statement for hospitality companies

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, executives, analysts, budget managers.

Other Reports Often Used in Conjunction with Trended Cash Flow Reports

Progressive FP&A departments sometimes use several different Trended Cash Flow Reports, along with profit & loss reports, balance sheets, KPI reports, dashboards, cash flow forecasts and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Monthly Operating Summary Report for a Hospitality Company

What is a Monthly Operating Summary Report?

Operating Summary Reports are considered business- and departmental analysis tools and are used by financial managers and executives to analyze key metrics, revenues and profitability. Some of the main functionality in this type of report is that it combines KPIs with financial summaries. The top of the report shows charts with Total Occupied Rooms and Revenue for monthly and year-to-date (YTD) figures. The top section with figures shows KPIs with actual, budget, last year and variances. The next two sections show revenue and profitability (not visible in the screenshot below) by department. The bottom of each section shows the company-level total revenue and profit. You find an example of this type of report below.

Purpose of Monthly Operational Summary Reports

Hospitality companies use Operational Summary Reports to provide managers with a combined departmental and summary view of the company’s top metrics. When used as part of good business practices in Executive- and FP&A departments, a company can improve its operational tactics and profitability, and it can reduce the chances that leaders don’t have a convenient way to see the relationship between department and company revenue and profitability.

Example of an Operational Summary Report

Here is an example of an Operational Summary Report with monthly and YTD charts and KPIs.

Example of a Monthly Operating Summary Report for a Hospitality Company

Example of a Monthly Operating Summary Report for a Hospitality Company

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, analysts, budget managers, department managers.

Other Reports Often Used in Conjunction with Operational Summary Reports

Progressive Executive- and FP&A departments sometimes use several different Operational Summary Reports, along with company financial statements, department P&L’s, forecast models, budgets, KPI scorecards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Department Dashboard for a Hospitality Company

What is a Department Dashboard for a Hospitality Company?

Departmental Dashboards are often considered revenue and expense analysis tools and are used by Finance and Department Managers to review major general ledger (GL) performance metrics and budget variances. Some of the main functionality in this type of report is that it can be filtered by department and it contains both a graphical section as well as figures (not visible in the screenshot below). The report shows three charts and include: 1) Top revenue categories ranked, 2) Top expense categories ranked, and 3) Monthly actual and budget revenue trend. You find an example of this type of report below.

Purpose of Departmental Dashboards

Hospitality companies use Departmental Dashboards to give managers an easily readable and quick snapshot of the key revenue and expense indicators. When used as part of good business practices by FP&A and by Department Managers, a company can improve its cost – and profit center tactics, and it can reduce the chances that over- or under performance in any particular department go undetected.

Example of a Departmental Dashboard

Here is an example of a Departmental Dashboard with revenue and expense analysis.

Example of a Department Dashboard for a Hospitality Company

Example of a Department Dashboard for a Hospitality Company

You can find hundreds of additional examples here

Who Uses This Type of Report?

The typical users of this type of report are: CFOs, analysts, budget managers, department managers.

Other Reports Often Used in Conjunction with Departmental Dashboards

Progressive FP&A and Department Managers departments sometimes use several different Departmental Dashboards, along with detailed F&B reports, financial statements, trail balance reports, forecast models, budgets, KPI scorecards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Food & Beverage Revenue Dashboard for Hospitality Companies

What is a Food & Beverage Revenue Dashboard?

Food and Beverage (F&B) Dashboards are considered revenue analysis tools and are used by Finance and restaurant managers to drill into revenues by looking at trends and comparing restaurants and F&B categories. Some of the main functionality in this type of dashboard is that it provides users with graphical analysis from eight different perspectives: 1) Breakfast revenue compared across restaurants, 2) Lunch revenue compared across restaurants, 3) Dinner revenue compared across restaurants, 4) Beverage revenue compared across restaurants, 5) Monthly revenue trend for breakfast revenue, 6) Monthly revenue trend for lunch revenue, 7) Monthly trend for dinner revenue, and 8) Monthly trend for beverage revenue. You find an example of this type of dashboard below.

Purpose of Food & Beverage Revenue Dashboards

Hospitality companies use Food & Beverage Revenue Dashboards to easily find trends and high/low performing F&B categories. When used as part of good business practices in FP&A and Operations departments, a company can improve its revenues by optimizing menu offerings and location strategies, and it can reduce the chances that poor performing F&B categories are not fixed with quick and informed decisions.

Example of a Food & Beverage Revenue Dashboard

Here is an example of a Food & Beverage Revenue Dashboard with restaurant comparisons and monthly trends.

Example of a Food & Beverage Revenue Dashboard for Hospitality Companies

Example of a Food & Beverage Revenue Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, CFOs, Analysts, Restaurant Managers.

Other Reports Often Used in Conjunction with Food & Beverage Revenue Dashboards

Progressive FP&A and Operations departments sometimes use several different Food & Beverage Dashboards, along with detailed F&B reports, financial statements, corporate dashboards, forecast models, budgets, KPI scorecards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Restaurant Performance Dashboard for Hospitality Companies

What is a Restaurant Performance Dashboard?

Restaurant Dashboards are considered performance analysis tools and are used by Finance and restaurant managers to look at essential metrics and trends. Some of the main functionality in this type of dashboard is that it provides analysis from six different perspectives, including: 1) Monthly trend in restaurant covers, 2) Revenue comparison across restaurants, 3) Top expenses, ranked, 4) Trend in food & beverage (F&B) revenues, 5) Beverage revenue ranked by category, and 6) Food revenue for breakfast, lunch and dinner. You find an example of this type of dashboard below.

Purpose of Restaurant Performance Dashboards

Hospitality companies use Restaurant Performance Dashboards to provide a high level snapshot of statistical and revenue trends and comparisons. When used as part of good business practices in FP&A  departments, a company can improve its operational tactics, and it can reduce the chances that low performing areas go under the radar with resulting lack of action.

Example of a Restaurant Performance Dashboard

Here is an example of a Restaurant Dashboard with trends and comparative metrics.

Example of a Restaurant Performance Dashboard for Hospitality Companies

Example of a Restaurant Performance Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Executives, CFOs, Analysts, Restaurant Managers.

Other Reports Often Used in Conjunction with Restaurant Performance Dashboard

Progressive FP&A and Executive departments sometimes use several different Restaurant Performance Dashboards, along with detailed financial statements, corporate dashboards, forecast models, budgets, KPI scorecards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Hotel KPI Dashboard for Hospitality Companies

What is a Hotel KPI Dashboard?

Hotel KPI Dashboards are considered monitoring and analysis tools and are used by hotel managers and executives to get a graphical representation of essential performance metrics. Some of the main functionality in this type of dashboard is that it is parameter driven and it gives the user four different KPI views, including: 1) Monthly trend in room nights, 2) Top revenue categories ranked by amount, 3) Top expense categories ranked by amount, and 4) Monthly trend in revenues. You find an example of this type of dashboard below.

Purpose of Hotel KPI Dashboards

Hospitality companies use Hotel KPI Dashboards to give leaders a quick and easy way to see the big picture for financial metrics and occupancy. When used as part of good business practices in FP&A and Executive departments, a company can improve its strategic decisions, and it can reduce the chances that managers get lost in details and miss major trends in hotel performance.

Example of a Hotel KPI Dashboard

Here is an example of a Hotel KPI Dashboard with trends in room nights and revenue and expense comparisons.

Example of a Hotel KPI Dashboard for Hospitality Companies

Example of a Hotel KPI Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: CEOs, COOs, CFOs, Hotel Managers, Analysts.

Other Reports Often Used in Conjunction with Hotel KPI Dashboards

Progressive FP&A and Executive departments sometimes use several different Hotel KPI Dashboards, along with detailed financial statements, corporate dashboards, forecast models and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Casino Game Comparison Dashboard for Hospitality Companies

What is a Casino Game Comparison Dashboard?

Game Comparison Dashboards are considered operational analysis tools and are used by casino managers and financial analysts to benchmark game metrics. Some of the main functionality in this type of dashboard is that it provides six different perspectives, including: 1) Revenue per game, 2) Monthly revenue trend, 3) Wagers per hour per game, 4) Monthly wagers trend, 5) Average bet per game, and 6) Monthly trend in average bets. You find an example of this type of dashboard below.

Purpose of Casino Game Comparison Dashboards

Hospitality companies use Casino Game Comparison Dashboards to enable performance benchmarking across the company’s game offerings. When used as part of good business practices in casino operations departments, a company can improve its game services analysis and revenue optimization, and it can reduce the chances that any individual game offering under- or over-performs without receiving proper analysis.

Example of a Casino Game Comparison Dashboard

Here is an example of a Game Comparison Dashboard with monthly trend analysis and benchmarking of revenues, average wagers and average bets.

Example of a Casino Game Comparison Dashboard for Hospitality Companies

Example of a Casino Game Comparison Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: Casino managers and Analysts.

Other Reports Often Used in Conjunction with Casino Game Comparison Dashboards

Progressive casino operations departments sometimes use several different Casino Game Comparison Dashboards, along with detailed gaming revenue reports, revenue budgets and forecasts, annual budgets, profit & loss reports, KPI dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples

Example of a Casino Comparison Dashboard for Hospitality Companies

What is a Casino Comparison Dashboard?

Casino Comparison Dashboards are considered performance analysis tools and are used by executives and financial analysts to benchmark casino metrics. Some of the main functionality in this type of dashboard is that it provides six different perspectives, including: 1) Revenue per casino, 2) Monthly revenue trend, 3) Wagers per hour per casino, 4) Monthly wagers trend, 5) Average bet per casino, and 6) Monthly trend in average bets. You find an example of this type of dashboard below.

Purpose of Casino Comparison Dashboards

Hospitality companies use Casino Comparison Dashboards to enable performance benchmarking across the company’s casinos. When used as part of good business practices in FP&A and Executive departments, a company can improve its growth strategies and revenues, and it can reduce the chances that any individual casino under- or overperforms without receiving proper analysis.

Example of a Casino Comparison Dashboard

Here is an example of a Casino Comparison Dashboard with monthly trend analysis and benchmarking of revenues, average wagers and average bets.

Example of a Casino Comparison Dashboard for Hospitality Companies

Example of a Casino Comparison Dashboard for Hospitality Companies

You can find hundreds of additional examples here

Who Uses This Type of Dashboard?

The typical users of this type of dashboard are: CEOs, COOs, CFOs, casino managers.

Other Reports Often Used in Conjunction with Casino Comparison Dashboards

Progressive FP&A and Executive departments sometimes use several different Casino Comparison Dashboards, along with detailed revenue reports, revenue budgets and forecasts, annual budgets, profit & loss reports, KPI dashboards and other management and control tools.

Where Does the Data for Analysis Originate From?

The Actual (historical transactions) data typically comes from enterprise resource planning (ERP) systems like: Microsoft Dynamics 365 (D365) Finance, Microsoft Dynamics 365 Business Central (D365 BC), Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP, Microsoft Dynamics SL, Sage Intacct, Sage 100, Sage 300, Sage 500, Sage X3, SAP Business One, SAP ByDesign, Acumatica, Netsuite and others.

In analyses where budgets or forecasts are used, the planning data most often originates from in-house Excel spreadsheet models or from professional corporate performance management (CPM/EPM) solutions.

What Tools are Typically used for Reporting, Planning and Dashboards?

Examples of business software used with the data and ERPs mentioned above are:

  • Native ERP report writers and query tools
  • Spreadsheets (for example Microsoft Excel)
  • Corporate Performance Management (CPM) tools (for example Solver)
  • Dashboards (for example Microsoft Power BI and Tableau)

Corporate Performance Management (CPM) Cloud Solutions and More Examples