Performance Report

[matyl]

Dear Forum Members,

Recently I was asked to create a company performance report. It's purpose is to provide an overview of how the company is performing in the past 12 months.

I'm not sure what to include in the report.
Could anyone suggest what information should I include in this report?

Thank you in advance.
Maty

 

[etaf]

That will be difficult to say, and would depend very much on the business itself and at what level of management or division the report is for.
Operational Reporting Or Financial reporting Or people or customers

Usually its not just a 12 month view,

Give us some more info about the company , any KPI its currently using , what is important to the company
Have a look at balanced score cards

They maybe a HR element , on people, diversity , environment , etc
Financial things , like Revenue , gross profit, net profit, stock on hand, assets
Share price, dividend

Operational things, maybe things like Fix first call, call centre volume, calls not answered ,
HR things like, churn rate, Employee satisfaction, morale, diversity , Woman in leadership positions - etc
Customer - churn rate, satisfaction
Environment, Carbon footprint, Waste, sustainability , etc
Web Operational metrics

Whenever i did this for companies, I looked at the business plan, the strategy for the next 5 years, and started at the board level and worked down.
Talked to the financial team, they should already be reporting, any annual reports supplied

Often there is a flavour of the week, and somethings may only last a quarter , short term stuff they seems important at the time, and you may spend a lot of time trying to get the data , for it to blow over , so be on the lookout for that

A review of the data available. how its captured and then how it may provide info

Also look at a balance - for example the metric may look at one area, BUT often to hit the target other areas are used
Classic case
Improve First Time fix rate on site for engineer, to do that , every possible part could be sent to site, increasing Stock & distribution costs
So cost of the call went up 10x fold - as the metric was FTF Only which was achieved but at a huge cost

 

[matyl]

Hello Etaf,

Thank you for replying.
The performance report is supposed to cover revenue and customer acquisition. I don't think the management is interested in other things because it's only a small company.
There are many ways to report performance with revenue and customer acquisition. What would you suggest?

Maty

 

[etaf]

do you have accountants ? which can provide the Revenue figures
And do you have data on customer acquisition ?

What data do you have , how frequently do you get it refreshed.
How do you define customer Acquisition ?
As mentioned Customer Churn would be a measure , but do you have the data ?
Cost to acquire customers , via marketing
Repeat business
web based, Shop based, Wholesalers, no idea where your customers are acquired from and how or at what cost

There are many ways to report performance with revenue and customer acquisition. What would you suggest?

I would suggest, you align with any current metrics that are used, Its so easy in meetings, reviewing the KPI for people to have 2 different results for the same metric and then spend most of the time arguing about the measure , rather than take action because of what the measure shows. Especially if peoples salary/bonus or job are dependant on the measures.

Full definition of how the measures are taken, what sources are used

So for financial you would need to align with the Financial accounts, who may already be providing Monthly/Quarterly or annual figures , maybe even a Flash process that reviews the accounts for a few days before finalising for any Audit or presentation.

Is it a UK company , is it limited , if so, then turnover, costs , tax, figures will already be produced for HMRC and company house.

Whats the purpose of the report you are going to provide , who sees it, what action will be taken as a result of it,

 

[matyl]

do you have accountants ? which can provide the Revenue figures
And do you have data on customer acquisition ?

What data do you have , how frequently do you get it refreshed.
How do you define customer Acquisition ?
As mentioned Customer Churn would be a measure , but do you have the data ?
Cost to acquire customers , via marketing
Repeat business
web based, Shop based, Wholesalers, no idea where your customers are acquired from and how or at what cost


I would suggest, you align with any current metrics that are used, Its so easy in meetings, reviewing the KPI for people to have 2 different results for the same metric and then spend most of the time arguing about the measure , rather than take action because of what the measure shows. Especially if peoples salary/bonus or job are dependant on the measures.

Full definition of how the measures are taken, what sources are used

So for financial you would need to align with the Financial accounts, who may already be providing Monthly/Quarterly or annual figures , maybe even a Flash process that reviews the accounts for a few days before finalising for any Audit or presentation.

Is it a UK company , is it limited , if so, then turnover, costs , tax, figures will already be produced for HMRC and company house.

Whats the purpose of the report you are going to provide , who sees it, what action will be taken as a result of it,

We don't have an accountant.
I have access to our database, so getting data is no problem.

I discovered there is a type of chart called Z chart, can I display a Z chart in the performance report?

 

[etaf]

yes, if you search the web, you will find quite a few tutorials on using Excel with NormDist , Z-chart, Bell curves etc
mrexcel has a bell curve example for Excel

Also lots of examples of dashboards, etc

https://www.youtube.com/c/MrExcelcom/videos

 

[matyl]

yes, if you search the web, you will find quite a few tutorials on using Excel with NormDist , Z-chart, Bell curves etc
mrexcel has a bell curve example for Excel

Also lots of examples of dashboards, etc

https://www.youtube.com/c/MrExcelcom/videos

No, no, you misunderstood me.
I was talking about Z chart, not Z score. The latter is a statistical concept, the former is a type of chart used for business reporting. I just learned about it today.

 

[etaf]

maybe a link to the chart , would help us understand a little more , what you are after

 

[matyl]

maybe a link to the chart , would help us understand a little more , what you are after

This is an explanation of how Z chart works: Z-charts

 

[etaf]

Yes , that graph can be easily produced

See the table from your link here

Book2
	A	B	C	D
1		This month	Total since March	Rolling 12 month total
2	Mar-20	5	5	46
3	Apr-20	2	7	45
4	May-20	5	12	47
5	Jun-20	12	22	46
6	Jul-20	3	25	48
7	Aug-20	5	30	47
8	Sep-20	7	37	49
9	Oct-20	2	39	50
10	Nov-20	4	43	51
11	Dec-20	2	45	50
12	Jan-21	7	52	58
13	Feb-21	3	55	55
Sheet3

And a screen shot including the graph