Page History

...

This dashboard can be filtered by Date Range. Users can drill through most widgets to view more details and/or breakdowns.

Widget Name	Description	Calculations	Sources for Calculations
MSPF Benchmark - Gross Margin generated per $1 Sales	A card number showing the overall Gross Margin generated per $1 of Sales

/

& Marketing

Cost

Expenses for the selected date range.	(Total Revenue - Total COGS) / Total Sales & Marketing Expenses	Xero P&L (SLI-Mapped): Revenue, COGS, Sales & Marketing Expenses
MSPF Benchmark - Blended Gross Margin %	A bar graph providing a benchmark for Gross Margin. Data is shown per month for the selected date range.

[Revenue (Product + Services) - COGS] / Revenue

(Total Revenue - Total COGS) / Total Revenue	Xero P&L (SLI-Mapped): Revenue, COGS
MSPF Benchmark - Service Gross Margin %	A bar graph providing a benchmark for Service Gross Margin. Data is shown per month for the selected date range.	(Service Revenue - Services COGS) / Service Revenue	Xero P&L (SLI-Mapped): Service Revenue, Service COGS
MSPF Benchmark - Product Gross Margin %	A bar graph providing a benchmark for Product Gross Margin. Data is shown per month for the selected date range.	(Product Revenue - Product COGS) / Product Revenue	Xero P&L (SLI-Mapped): Product Revenue, Product COGS
MSPF Benchmark SG&A %	A bar graph providing a benchmark for Selling, General and Administrative Expense (SG&A) as a % of Total

Costs

Expenses. Data is shown per month for the selected date range.

SG&A Expenses/

Total Costs

Total Expenses	Xero P&L (SLI-Mapped): SG&A Expenses, Total Expenses
MSPF Benchmark - Sales Cost %	A bar graph providing a benchmark for Sales

Costs

Expenses as a % of Total

Costs

Expenses. Data is shown per month for the selected date range.

Sales

Costs

Expenses / Total

Costs

Expenses	Xero P&L (SLI-Mapped): SG&A Expenses, Total Expenses
MSPF Benchmark G&A Cost%	A bar graph providing a benchmark for General and Admin Expenses as a % of Total

Costs

Expenses. Data is shown per month for the selected date range.

General and Admin Expenses / Total

Costs

Expenses	Xero P&L (SLI-Mapped): SG&A Expenses, Total Expenses
MSPF Benchmark - EBITDA %	A bar graph providing a benchmark for Earnings Before Interest, Taxes, Depreciation, and Amortization (EBITDA) as a % of Total Revenue. Data is shown per month for the selected date range.	EBITDA / Total Revenue

Page tree