more-arw search

Q&A Forum

Dashboards - What to include

Rich Winters's Profile

I'm looking for some ideas on Dashboards for my Exec team. Obviously, sales and cash, but what else? How long do you go back for trend showing? Any sites recommended that might show examples?

Answers

Topic Expert
Wayne Spivak
Title: President & CFO
Company: SBAConsulting.com
LinkedIn Profile
(President & CFO, SBAConsulting.com) |

I created a Dashboard with Sales, Open Orders, Potential Orders, Budget and then how close we were to meeting those goals (12 month).

Other KPI's included (vs Budget) Cash, Inventory, EBITDA and a snapshot of A/P, A/R, Open PO's, Breakdown of Spend (Selling, G&A, other divisions and then a group of sales comparisons

Topic Expert
Len Green
Title: Performance Improvement Consultant and E..
Company: Haygarth Consulting LLC
LinkedIn Profile
(Performance Improvement Consultant and ERP Strategist, Haygarth Consulting LLC) |

Rich

As a consulting firm, the following may be helpful:
1. Consultant utilization
2. Consultant realization
3. Project WIP, Billings, Deferred Revenue
4. Project forecasts-to highlight projects where estimate to completion may be worse than budgeted
5. Your firm has a number of markets and service offerings, so I would think that revenues + margins by customer, market and by service type would help show where and how you are making most of your money.
6. Project pipeline-what opportunities are you pursuing that have not yet turned into contracts
7. The trending periods may be both quarterly and longer term, e.g. if your projects are multi year projects you may want longer periods.

Some of these dashboards may be shown at different levels of detail, e.g. CEO view may differ from the view of your area managers, but the source data is all the same.

Hope this helps
Len

Rich Winters
Title: CFO
Company: Manhard Consulting
(CFO, Manhard Consulting) |

Thank you, these pretty much cover the thoughts I had, but there were a few new items to consider.

Rich

Jon Ferguson
Title: CFO
Company: M. Brsahem, Inc.
(CFO, M. Brsahem, Inc.) |

I include the following on our company dashboard:
1) Sales - Current fiscal year-to-date vs. Last fiscal year-to-date
2) # of Order - Current fiscal year-to-date vs. Last fiscal year-to-date
3) Operating Expenses - Current fiscal year-to-date vs. Last fiscal year-to-date
4) Profit - Current fiscal year-to-date vs. Last fiscal year-to-date
5) Net Cash Flow - Current vs. Prior year
6) Employees - Today vs. same day last year
7) Gross Margin rate - Last month, month-before last and YTD and Prior YTD
8) Days Sales Outstanding - Last month, month-before last and YTD and Prior YTD
9) Days Inventory On Hand - Last month, month-before last and YTD and Prior YTD
10) Receivables Turnover - Last month, month-before last and YTD and Prior YTD
11) Inventory Turnover - Last month, month-before last and YTD and Prior YTD
12) Working Capital - Last month, month-before last and YTD and Prior YTD
13) Asset Turnover - Last month, month-before last and YTD and Prior YTD
14) Return on Assets - Last month, month-before last and YTD and Prior YTD
15) Return on Equity - Last month, month-before last and YTD and Prior YTD
16) Debt to Equity - Last month, month-before last and YTD and Prior YTD
17) EBITDA - Last month, month-before last and YTD and Prior YTD

Rich Winters
Title: CFO
Company: Manhard Consulting
(CFO, Manhard Consulting) |

Jon,

Thanks lots of good stuff here. I must ask, do you manually prepare this data, or is it generated automatically by your accounting system?

Rosalio Ulloa
Title: President/CEO
Company: ProAmerica Advisors, Inc.-www.ProAmerica..
(President/CEO, ProAmerica Advisors, Inc.-www.ProAmericaAdvisors.c) |

Rich,
Most importantly, if your client has financing in place that require monitoring of financial covenants/ratios, then at minimum your dashboard should include the lender's financial covenant/ratios requirements vs. actual results. Last thing you would want is the lender to call the Note due, because of non-compliance with the financial covenants.

Rich Winters
Title: CFO
Company: Manhard Consulting
(CFO, Manhard Consulting) |

Rosalio, Thank you. Fortunately not an issue for me, but you make a very good point.

4285 views
Topics
Products and Companies

Get Free Membership

By signing up, you will receive emails from Proformative regarding Proformative programs, events, community news and activity. You can withdraw your consent at any time. Contact Us.

Business Exchange

Browse the Business Exchange to find information, resources and peer reviews to help you select the right solution for your business.

Learn more

Contribute to Community

If you’re interested in learning more about contributing to your Proformative community, we have many ways for you to get involved. Please email content@proformative.com to learn more about becoming a speaker or contributing to the blogs/Q&A Forum.