kpi excel software

Company

First Year 2010

release 1.55 a

[email protected] a

Implementation

> Project Notes

Registries

> Perspectives

> Categories

> Key Performance Indicators

Data

> Actual

> Target

Reports

> Dashboard

> Graphical performance display

Strategy

> Strategic plan

> Business Process

> Area Managers

> Settings and scores KPISoftware

> Cleaning Fields

> Handbook

> Trend performance indicators

Company

04/10/2023 2 X KPI 1.55

Handbook [email protected]

1. System Requirement

Microsoft Excel 2002-2003-2007

To use the model you must set the macro security level on the level "low" through the following procedure:

Tools --> Macro --> Security --> Security Level --> Low

The model automatically adapts to screen size.

The model manages a maximum of 5 years of measures.

2. X KPI Purpose and Basic Contents

performance verification both with respect to periods prior to that target set.

Map of indicators is build basing on the following plan:

Perspectives

Categories

Business Process

KPIs

Area Managers

(for example: financial, market, internal process, ….)

(for example: in the market perspective is possible to detail category like: sales, customer acquisition, …)

perspectives and categories) (optional)

This icon (from anywhere) back to the menu

3. First year and frequency

The model provides for the management of five years of activity fractionated in a monthly periodicity.

Indicators with different frequency by month (eg quarterly) can be handled in two ways:

1. Recognition of competence within the month (leaving empty fields of two months not purchased)

2. Repeating the value found in the quarter for two months (in order to always have a value indicator)

4. Project Notes

This worksheet enables the writing of notes that can be detected during the construction project.

It constitutes a "notepad" on which to note the progress of the project and the steps to be taken.

X KPI born with the objective of enabling a structured management performance indicators through a streamlined collection and organization of information and a

Perspectives constitute the highest level of classification of indicators (required)

Categories represent subclassifications perspective (required)

Business Process represent a level of classification in according to internal business process ( that lie in a plane parallel to the

Area Managers represent managers entrusted with the monitoring of the indicators and compliance targets (optional)

The field "first year" in the model menu defines the year from which the measures are managed and the values entered.

Company

04/10/2023 3 X KPI 1.55

5. Cleaning Fields

The action "clean fields" allow the template to clean the tables below reports to highlight in "drop-down lists" only the update and active values.

The procedure can be launched at user's discretion.

6. Perspectives

The creation and modification of pespectives is through typing in the "white" fields.

The modification of a previously entered description requires a new combination of related fields.

7. Categories

The creation and modification of categories is through typing the description in the column "description category" and associating

the category to the perspective through the drop-down menu in the column headed "description perspective".


8. Area Managers



9. Business Process



10. KPIs

The creation of the indicators is done through compiling and selecting different options and informations.

a. Kpi Description

Write the name of the indicator in the "white" field.

b. Category Description

Choose the category to which belongs the indicator through the drop-down menu in the "Category Description"

The choice of the indicator category includes the directly association to the perspective

c. Business Process Description (optional)

Choose the process to which belongs the indicator through the drop-down menu in the "Business Process Description"

d. Number Format

Click through the drop-down menu, one of the possible formats

e. Band Type

Click through the drop-down menu, the indicator band type

The band type expresses the better indicator trend: for some KPIs an increasing is a good thing (for example Sales or Revenue have a positive band type, "+"),

for other KPIs, such as Costs or Complaints, an increasing is a bad thing (these indicators have a negative band type, "-").

f. Frequency

Click through the drop-down menu, the indicator frequency

The choice has no impact on the model because the values are manually inserted into the chosen period

g. Time Frame

Click through the drop-down menu, the indicator time frame

Year to Date (if the data entered is a sequence, eg sales from 01.01 to 30.04)

At present (if the data entered is an present number, eg due to banks)

h. GrAtPresent

Scegliere se, in presenza di un indicatore progressivo, si vogliono vedere i valori anche mensili.

Esempio: l'ordinato viene inserito come progressivo da inizio anno e il modello calcola i valori mensili puntuali

i. Area Manager (optional)

Click through the drop-down menu, the responsable of the performance indicator

through this icon you can open the detailed description and the setting of the indicator (only if you are placed on the indicator code)

Company

04/10/2023 4 X KPI 1.55

11. Detail and setting indicator

In addition to information provided by the worksheet of creation indicators can further detail the characteristics of the indicator across the fields:

a. Indicators description

Detailed Description and Objective of the indicator

b. Calculation Formula

Calculation procedure that is followed for determining the value of the indicator

c. Data Source

Identify the source of the indicator value, where the data comes from (can be a file, ERP, statistics…)

d. Target Description

Calculation procedure that is followed for determining the goals of the indicator

e. Other information

Any other information related indicator

12. Actual Data

In the matrix indicators - periods are added the indicator values observed at that time.




13. Target Data

In the matrix indicators - periods are inserted target/goals values identified by the indicator at the time




14. Strategic Plan

For each year of management you can set a business plan through:

a. Strategic Plan

Description of the overall corporate strategic plan

b. Objectives

Description of specific objectives related to strategic management

c. Indicators

Association of specific indicators of achievement to each objective

d. Initiatives

Description of specific initiatives to be implemented to achieve each targets

The choice of the period of analysis will determine the achivement of objectives established in the strategic plan

15. Dashboard

The dashboard is a business tool that allows you to configure and build periodic reports of the indicators

The dashboard is updated automatically when opening

The construction and analysis of the details is through the set of buttons at the top right

Dashboard Print

Configuration of the scale of analysis and the periods

Graphic detail of the selected indicator

Detailed description and setting of the selected indicator

Company

04/10/2023 5 X KPI 1.55

16. Graphic indicator

The graph indicator enables:

a. the navigability of the indicators

b. the choice of reporting period

c. analysis of the last 12 months

d. comparing the previous year and the target

e. short guideline for development performance

f. a graphical summary

Navigability and the recording period allowed by the indicator buttons

Choise from a menu of indicators created

Scroll buttons indicators

Choise of the period of evaluation

Other icons:

Print Chart

Detailed description and setting of the selected indicator

Transition to the chart at present (if the indicator has time frame "year to date")

17. Settings and Scores Indicator

This worksheet combines the detailed information of the indicator with the values found in selected periods

The worksheet functions are the same as for graphic indicator

Company: Company

Process of implementing: Update Sales Manager target measures

To fix a date for internal audit

To complete Strategic Plan for the years 2011

04/10/2023

Company: Company

Year: 2010

Period: 2010.03

Strategic Plan:

Goal 1:

Improvement in net financial position by reviewing the trade policies of extensions granted to customers and suppliers obtained by suppliers

KPIs Area Manager 2010.03 Target Change % Change Goal Ach. Initiatives

01-Net financial position Corporate Administrators -2,659.67 -2,734.95 75.28 -2.75% p

02-Gross Margin % Corporate Administrators 35.86 33.45 2.41 7.20% p

03-ROI Corporate Administrators 10.14 -8.13 18.28 -224.76% p

Goal 2:


The company has set as its goal for 2009 to maintain commercial volumes achieved in 2008, maintaining % margin the previous year. The area where the company intends to act are to improve the net debt through trade policy review, a reduction of complaints and defective products and particular attention, given the likely increase in the levels of customer insolvency, at financial risk.

Review the investment policy

04/10/2023

Company: Company

Year: 2010

Period: 2010.03

Strategic Plan:


Goal 3:


Goal 4:


04/10/2023

Company: Company

Year: 2010

Period: 2010.03

Strategic Plan:


Goal 5:


04/10/2023

Company: Company

Year: 2011

Period: 2011.03

Strategic Plan:

Goal 1:


Goal 2:


Review the investment policy

04/10/2023

Company: Company

Year: 2011

Period: 2011.03

Strategic Plan:

Goal 3:


Goal 4:


04/10/2023

Company: Company

Year: 2011

Period: 2011.03

Strategic Plan:

Goal 5:


04/10/2023

Company: Company

Year: 2012

Period: 2012.06

Strategic Plan:

Goal 1:


Goal 2:


04/10/2023

Company: Company

Year: 2012

Period: 2012.06

Strategic Plan:

Goal 3:


Goal 4:


04/10/2023

Company: Company

Year: 2012

Period: 2012.06

Strategic Plan:

Goal 5:


04/10/2023

Company: Company

Year: 2013

Period: 2013.11

Strategic Plan:

Goal 1:


Goal 2:


04/10/2023

Company: Company

Year: 2013

Period: 2013.11

Strategic Plan:

Goal 3:


Goal 4:


Goal 5:

04/10/2023

Company: Company

Year: 2013

Period: 2013.11

Strategic Plan:


04/10/2023

Company: Company

Year: 2014

Period: 2014.04

Strategic Plan:

Goal 1:


Goal 2:


04/10/2023

Company: Company

Year: 2014

Period: 2014.04

Strategic Plan:

Goal 3:


Goal 4:


Goal 5:

04/10/2023

Company: Company

Year: 2014

Period: 2014.04

Strategic Plan:


Company

04/10/2023 X KPI 1.55

PERSPECTIVES

CodPersp Perspective DescriptionP001 FINANCIAL 1P002 MARKET 2P003 BUSINESS PROCESS 3P004 HR / INNOVATION 4P005 RISK 5P006 6P007 7P008 8P009 9P010 10

Company

04/10/2023 X KPI 1.55

BUSINESS PROCESS

CodProc Business Process DescriptionPR01 Financial

PR02 Customer

PR03 Industrial Production

PR04 Supply Vendor

PR05 Human Resource

PR06

PR07

PR08

PR09

PR10

PR11

PR12

Azienda XYZ

04/10/2023

AREA MANAGERS

CodMan Area Manager DescriptionRE01 Corporate Administrators

RE02 Sales Manager

RE03 Production Manager

RE04 Purchasing Manager

RE05 Human Resources

RE06

RE07

RE08

RE09

RE10

RE11

RE12

Company

04/10/2023 X KPI 1.55

CATEGORIES

CodCat Category Description CodPersp Perspective DescriptionD001 Commercial risk P001 FINANCIAL

D002 Profitability P001 FINANCIAL

D003 Operating Cycle P001 FINANCIAL

D004 Costs P001 FINANCIAL

D005 Financial Risk P005 RISK

D006 Sales P002 MARKET

D007 Ordered P002 MARKET

D008 Customer Loyalty P002 MARKET

D009 Customer Service P003 BUSINESS PROCESS

D010 Quality P003 BUSINESS PROCESS

D011 Production cycle P003 BUSINESS PROCESS

D012 Human Resource P004 HR / INNOVATION

D013 Learning and Growth P004 HR / INNOVATION

D014

D015

D016

D017

D018

D019

D020

D021

D022

D023

D024

D025

D026

D027

D028

D029

D030

D031

D032

D033

D034

D035

D036

D037

D038

D039

D040

Company

04/10/2023 X KPI 1.55

KEY PERFORMANCE INDICATORS

CodKpi KPI Description CodCat Category Description CodPersp Perspective Description CodProc Business Process Description Number Format Band Type Frequency Time Frame GrAtPresent Area Manager01 Net financial position D005 Financial risk P005 RISK PR01 Financial Amount + Month At present NO Corporate Administrators

02 Gross Margin % D002 Profitability P001 FINANCIAL PR01 Financial Percentage + Month At present NO Corporate Administrators

03 ROI D002 Profitability P001 FINANCIAL PR01 Financial Percentage + Month At present NO Corporate Administrators

04 Total Asset Turnover D002 Profitability P001 FINANCIAL PR01 Financial Numero + Month At present NO Corporate Administrators

05 ROS D002 Profitability P001 FINANCIAL PR01 Financial Percentage + Month At present NO Corporate Administrators

06 EBITDA D002 Profitability P001 FINANCIAL PR01 Financial Amount + Month At present NO Corporate Administrators

07 Accounts Receivable Turnover in Days D003 Operating Cycle P001 FINANCIAL PR02 Customer Decimal - Month At present NO Sales Manager

08 Payables Turnover in Days D003 Operating Cycle P001 FINANCIAL PR04 Supply Vendor Decimal + Month At present NO Purchasing Manager

09 Rolling average raw material storage D003 Operating Cycle P001 FINANCIAL PR01 Financial Decimal - Month At present NO Purchasing Manager

10 Inventory Turnover in Days D003 Operating Cycle P001 FINANCIAL PR01 Financial Decimal - Month At present NO Production Manager

11 Investments/Sales D005 Financial risk P005 RISK PR01 Financial Percentage + Month At present NO Corporate Administrators

12 % Purchases D004 Costs P001 FINANCIAL PR01 Financial Percentage - Month At present NO Purchasing Manager

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

Company

04/10/2023 X KPI 1.55

KEY PERFORMANCE INDICATORS

CodKpi KPI Description CodCat Category Description CodPersp Perspective Description CodProc Business Process Description Number Format Band Type Frequency Time Frame GrAtPresent Area Manager83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

INPUT ACTUAL

CodKpi KPI Description Number Format Frequency Time Frame Band Type 2010.01 2010.02 2010.03 2010.04 2010.05 2010.06 2010.07 2010.08 2010.09 2010.10 2010.11 2010.12 2011.01 2011.02 2011.0301 Net financial position Amount Month At present + -2,243.61 -1,931.15 -2,659.67 -2,366.20 -2,451.27 -2,766.54 -2,901.32 -2,839.91 -2,989.67 -2,244.67 -1,817.57 -2,924.42 -2,588.37 -2,675.57 -2,643.22

02 Gross Margin % Percentage Month At present + 37.46 36.49 35.86 35.63 35.99 36.13 35.75 35.77 35.71 35.70 35.47 35.27 39.34 38.34 36.77

03 ROI Percentage Month At present + -8.38 12.30 10.14 18.12 23.83 26.92 27.77 20.49 21.53 22.53 23.64 16.07 -12.74 -5.47 2.59

04 Total Asset Turnover Numero Month At present + 2.98 3.30 3.12 3.46 3.59 3.51 3.61 3.33 3.30 3.53 3.66 3.26 1.67 2.15 2.44

05 ROS Percentage Month At present + -2.81 3.72 3.25 5.23 6.64 7.66 7.70 6.14 6.53 6.38 6.47 4.93 -7.63 -2.54 1.06

06 EBITDA Amount Month At present + 21.79 191.19 269.98 500.19 768.36 1,038.90 1,259.26 1,134.21 1,340.69 1,473.54 1,633.75 1,477.68 -27.00 30.48 171.42

07 Accounts Receivable Turnover in Days Decimal Month At present - 133.79 123.29 129.03 120.89 121.12 119.51 116.50 118.99 117.23 114.75 112.75 118.50 109.10 112.20 112.20

08 Payables Turnover in Days Decimal Month At present + 97.89 87.07 85.00 86.88 91.17 88.28 88.30 85.76 82.86 85.62 87.24 86.74 154.83 112.54 102.57

09 Rolling average raw material storage Decimal Month At present - 54.54 54.17 58.72 53.43 46.75 51.10 49.14 52.16 51.43 51.26 52.37 50.41 114.13 86.46 86.47

10 Inventory Turnover in Days Decimal Month At present - 12.74 13.10 12.50 12.25 11.58 11.55 11.43 11.94 11.90 11.88 11.87 12.13 14.82 13.89 14.48

11 Investments/Sales Percentage Month At present + 0.09 0.56 0.75 1.25 1.48 2.27 2.15 2.43 2.13 1.73 1.76 1.66 6.46 2.84 2.84

12 % Purchases Percentage Month At present - 59.96 65.21 68.93 65.43 61.63 63.69 62.42 61.68 61.07 60.73 60.69 60.05 55.31 62.07 62.04

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

INPUT TARGET

CodKpi KPI Description Number Format Frequency Time Frame

01 Net financial position Amount Month At present

02 Gross Margin % Percentage Month At present

03 ROI Percentage Month At present

04 Total Asset Turnover Numero Month At present

05 ROS Percentage Month At present

06 EBITDA Amount Month At present

07 Accounts Receivable Turnover in Days Decimal Month At present

08 Payables Turnover in Days Decimal Month At present

09 Rolling average raw material storage Decimal Month At present

10 Inventory Turnover in Days Decimal Month At present

11 Investments/Sales Percentage Month At present

12 % Purchases Percentage Month At present

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

78

79

80

81

82

83

84

85

86

87

88

89

90

91

92

93

94

95

96

97

98

99

100

Band Type 2010.01 2010.02 2010.03 2010.04 2010.05 2010.06

+ -2,310.09 -2,662.51 -2,734.95 -2,543.44 -2,943.54 -3,042.70

+ 34.81 37.35 33.45 31.25 33.43 33.31

+ -11.02 -0.94 -8.13 -11.46 4.21 6.80

+ 3.14 3.14 3.14 3.14 3.14 3.14

+ -3.51 -0.30 -2.59 -3.65 1.34 2.16

+ 7.55 95.58 52.70 8.43 360.61 512.85

- 118.00 118.00 118.00 118.00 118.00 118.00

+ 96.70 96.70 96.70 96.70 96.70 96.70

- 62.23 62.23 62.23 62.23 62.23 62.23

- 9.98 9.98 9.98 9.98 9.98 9.98

+ 2.75 2.75 2.75 2.75 2.75 2.75

- 56.19 56.19 56.19 56.19 56.19 56.19

2010.07 2010.08 2010.09 2010.10 2010.11 2010.12

-3,052.80 -2,471.82 -2,422.32 -2,341.74 -2,394.69 -2,122.82

33.46 34.22 34.57 35.06 35.92 35.74

9.23 11.49 13.76 16.26 18.83 16.37

3.14 3.14 3.14 3.14 3.14 3.14

2.94 3.66 4.38 5.18 6.00 5.21

693.28 810.33 1,016.12 1,270.50 1,539.87 1,478.93

118.00 118.00 118.00 118.00 118.00 118.00

96.70 96.70 96.70 96.70 96.70 96.70

62.23 62.23 62.23 62.23 62.23 62.23

9.98 9.98 9.98 9.98 9.98 9.98

2.75 2.75 2.75 2.75 2.75 2.75

56.19 56.19 56.19 56.19 56.19 56.19

2011.01 2011.02 2011.03 2011.04 2011.05 2011.06

-2,641.35 -2,903.27 -2,659.10 -2,334.05 -2,678.33 -2,935.42

10.80 28.80 34.12 35.38 36.01 35.46

21.02 21.02 21.02 21.02 21.02 21.02

2.85 2.85 2.85 2.85 2.85 2.85

7.37 7.37 7.37 7.37 7.37 7.37

-240.80 4.96 172.01 457.04 751.57 898.37

124.21 124.21 124.21 124.21 124.21 124.21

90.41 90.41 90.41 90.41 90.41 90.41

58.02 58.02 58.02 58.02 58.02 58.02

9.22 9.22 9.22 9.22 9.22 9.22

0.00 1.10 2.41 4.50 3.91 3.60

54.47 51.33 58.72 57.63 57.08 57.67

2011.07 2011.08 2011.09 2011.10 2011.11 2011.12

-3,573.55 -2,927.23 -2,863.72 -2,848.17 -2,899.58 -2,332.59

36.03 36.39 36.41 35.83 36.59 37.95

21.02 21.02 21.02 21.02 21.02 21.02

2.85 2.85 2.85 2.85 2.85 2.85

7.37 7.37 7.37 7.37 7.37 7.37

1,176.98 1,187.61 1,353.17 1,363.46 1,636.97 2,048.41

124.21 124.21 124.21 124.21 124.21 124.21

90.41 90.41 90.41 90.41 90.41 90.41

58.02 58.02 58.02 58.02 58.02 58.02

9.22 9.22 9.22 9.22 9.22 9.22

8.24 7.89 6.95 6.22 5.65 5.29

57.13 56.74 56.73 57.30 56.54 55.20

2012.01 2012.02 2012.03 2012.04 2012.05 2012.06

47.00 47.00 47.00 47.00 47.00 47.00

500.00 500.00 500.00 500.00 500.00 500.00

450.00 450.00 450.00 450.00 450.00 450.00

2012.07 2012.08 2012.09 2012.10 2012.11 2012.12

47.00 47.00 47.00 47.00 47.00

500.00 500.00 500.00 500.00 500.00

450.00 450.00 450.00 450.00 450.00

2013.01 2013.02 2013.03 2013.04 2013.05 2013.06

2013.07 2013.08 2013.09 2013.10 2013.11 2013.12

2014.01 2014.02 2014.03 2014.04 2014.05 2014.06

2014.07 2014.08 2014.09 2014.10 2014.11 2014.12

Company

04/10/2023 X KPI 1.55

2010.09 2011.09 2011.09

Perspective KPI Previous Actual Charge % Charge Band Ind Target Charge TG %Charge TG Band TG

FINANCIAL 03-ROI 21.53 4.72 -16.80 -78.06% 6 21.02 -16.29 -77.53% 605-ROS 6.53 1.92 -4.61 -70.62% 6 7.37 -5.45 -73.96% 602-Gross Margin % 35.71 37.84 2.14 5.98% 5 36.41 1.44 3.94% 509-Rolling average raw material storage 51.43 80.45 29.03 56.44% 6 58.02 22.43 38.67% 604-Total Asset Turnover 3.30 2.46 -0.84 -25.33% 6 2.85 -0.39 -13.68% 607-Accounts Receivable Turnover in Days 117.23 114.00 -3.23 -2.76% 5 124.21 -10.21 -8.22% 508-Payables Turnover in Days 82.86 102.81 19.95 24.08% 5 90.41 12.40 13.72% 510-Inventory Turnover in Days 11.90 15.83 3.93 33.03% 6 9.22 6.61 71.65% 612-% Purchases 61.07 57.02 -4.05 -6.63% 5 56.73 0.29 0.51% 6

FINANCIAL Total 391.55 417.07 25.51 5 406.23 10.83 5RISK 11-Investments/Sales 2.13 2.75 0.62 29.11% 5 6.95 -4.19 -60.35% 6

01-Net financial position -2,989.67 -2,866.57 123.10 -4.12% 5 -2,863.72 -2.85 0.10% 6RISK Total -2,987.54 -2,863.81 123.72 5 -2,856.77 -7.04 6

Company

04/10/2023 X KPI 1.55

Company XYZ

04/10/2023 X KPI 1.43

2009.07 2009.08 2009.09 2009.10 2009.11 2009.12 2010.01 2010.02 2010.03 2010.04 2010.05 2010.06

Perspective KPI Band Period 1 Period 2 Period 3 Period 4 Period 5 Period 6 Period 7 Period 8 Period 9 Period 10 Period 11 Period 12

FINANCIAL 03-ROI + -8.38 12.30 10.14 18.12 23.83 26.92

05-ROS + -2.81 3.72 3.25 5.23 6.64 7.66

06-EBITDA + 21.79 191.19 269.98 500.19 768.36 1,038.90

02-Gross Margin % + 37.46 36.49 35.86 35.63 35.99 36.13

09-Rolling average raw material storage - 54.54 54.17 58.72 53.43 46.75 51.10

04-Total Asset Turnover + 2.98 3.30 3.12 3.46 3.59 3.51

07-Accounts Receivable Turnover in Days - 133.79 123.29 129.03 120.89 121.12 119.51

08-Payables Turnover in Days + 97.89 87.07 85.00 86.88 91.17 88.28

10-Inventory Turnover in Days - 12.74 13.10 12.50 12.25 11.58 11.55

12-% Purchases - 59.96 65.21 68.93 65.43 61.63 63.69

FINANCIAL Total 409.97 589.85 676.52 901.54 1,170.66 1,447.25

RISK 11-Investments/Sales + 0.09 0.56 0.75 1.25 1.48 2.27

01-Net financial position + -2,243.61 -1,931.15 -2,659.67 -2,366.20 -2,451.27 -2,766.54

RISK Total -2,243.52 -1,930.59 -2,658.93 -2,364.95 -2,449.79 -2,764.26

Company XYZ

04/10/2023 X KPI 1.43

Azienda XYZ

04/10/2023 X KPI 1.43

05-ROS Perspective FINANCIAL Band Type + umber Format Percentage

Category Profitability Frequency Month Area Manager Corporate Administrators

Last period of evaluation 2011.09 Process Financial Time Frame At present

Period 2010.10 2010.11 2010.12 2011.01 2011.02 2011.03 2011.04 2011.05 2011.06 2011.07 2011.08 2011.09

Actual 6.38 6.47 4.93 -7.63 -2.54 1.06 3.82 2.70 3.64 3.67 2.08 1.92

Target 5.18 6.00 5.21 7.37 7.37 7.37 7.37 7.37 7.37 7.37 7.37 7.37

Change 1.20 0.47 -0.29 -14.99 -9.91 -6.30 -3.54 -4.66 -3.72 -3.70 -5.28 -5.45

% Change 18.82% 7.24% -5.85% 196.56% 389.77% -593.70% -92.73% -172.57% -102.30% -100.85% -253.51% -284.07%

Indicator Band p p q q q q q q q q q q

Same period previous year -2.81 3.72 3.25 5.23 6.64 7.66 7.70 6.14 6.53

Change -4.81 -6.26 -2.19 -1.41 -3.94 -4.02 -4.03 -4.06 -4.61

% Change 171.09% -168.28% -67.34% -26.95% -59.32% -52.47% -52.37% -66.09% -70.62%

Indicator Band q q q q q q q q q

VS TARGET

q

VS PREVIOUS ACTUAL

q

2010.10 2010.11 2010.12 2011.01 2011.02 2011.03 2011.04 2011.05 2011.06 2011.07 2011.08 2011.09

-10.00

-8.00

-6.00

-4.00

-2.00

0.00

2.00

4.00

6.00

8.00

10.00

Azienda XYZ

04/10/2023

29-Value of production per day Perspective Band Type 0 umber Format 0

Category 0 Frequency 0 Area ManagerLast period of evaluation 2010.06 Process Time Frame 0

Period 2009.07 2009.08 2009.09 2009.10 2009.11 2009.12 2010.01 2010.02 2010.03 2010.04 2010.05 2010.06

Actual 0.00 0.00 0.00 0.00 0.00 0.00

Target 0.00 0.00 0.00 0.00 0.00 0.00

Change

% Change

Indicator Band

Same period previous year

Change

% Change

Indicator Band

VS TARGET

VS PREVIOUS ACTUAL

2009.07 2009.08 2009.09 2009.10 2009.11 2009.12 2010.01 2010.02 2010.03 2010.04 2010.05 2010.060

0.1

0.2

0.3

0.4

0.5

0.6

0.7

0.8

0.9

1

Azienda XYZ

04/10/2023 X KPI 1.43

08-Payables Turnover in Days Perspective FINANCIAL Band Type + GrAtPresent NOCategory Operating Cycle Frequency Month Format Decimal

Last period of evaluation 2010.12 Process Supply Vendor Time Frame At present Area Manager Purchasing Manager

Kpi Description #REF!

Calculation Formula #REF!

Data Source #REF!

Target Description #REF!

Other Information #REF!

Period 2010.01 2010.02 2010.03 2010.04 2010.05 2010.06 2010.07 2010.08 2010.09 2010.10 2010.11 2010.12

Actual 97.89 87.07 85.00 86.88 91.17 88.28 88.30 85.76 82.86 85.62 87.24 86.74

Target 96.70 96.70 96.70 96.70 96.70 96.70 96.70 96.70 96.70 96.70 96.70 96.70

Change 1.19 -9.63 -11.70 -9.82 -5.53 -8.42 -8.40 -10.94 -13.84 -11.08 -9.46 -9.96

% Change 1.22% -11.06% -13.76% -11.30% -6.07% -9.54% -9.52% -12.75% -16.70% -12.94% -10.84% -11.48%

Indicator Band p q q q q q q q q q q q


Change

% Change

Indicator Band

Azienda XYZ

04/10/2023 X KPI 1.43

08-Payables Turnover in Days Perspective FINANCIAL Band Type + GrAtPresent NOCategory Operating Cycle Frequency Month Format Decimal

Last period of evaluation 2010.12 Process Supply Vendor Time Frame At present Area Manager Purchasing Manager

Kpi Description #REF!

Calculation Formula #REF!

Data Source #REF!

Target Description #REF!

Other Information #REF!

Period 2010.01 2010.02 2010.03 2010.04 2010.05 2010.06 2010.07 2010.08 2010.09 2010.10 2010.11 2010.12

Actual

Target

Change

% Change

Indicator Band


Change

% Change

Indicator Band

Azienda XYZ

04/10/2023

09-Rolling average raw material storage Perspective FINANCIAL Band Type - GrAtPresent NOCategory Operating Cycle Frequency Month umber Format Decimal

Last period of evaluation 2011.08 Process Financial Time Frame At present Area Manager Purchasing Manager

Period 2010.09 2010.10 2010.11 2010.12 2011.01 2011.02 2011.03 2011.04 2011.05 2011.06 2011.07 2011.08

Actual 51.43 51.26 52.37 50.41 114.13 86.46 86.47 80.37 78.13 79.25 80.92 94.71

Target 62.23 62.23 62.23 62.23 58.02 58.02 58.02 58.02 58.02 58.02 58.02 58.02

Change -10.80 -10.97 -9.86 -11.82 56.11 28.44 28.45 22.36 20.11 21.23 22.90 36.70

% Change -21.01% -21.40% -18.82% -23.46% 49.16% 32.89% 32.90% 27.82% 25.74% 26.79% 28.30% 38.74%

Indicator Band p p p p q q q q q q q q

Same period previous year 54.54 54.17 58.72 53.43 46.75 51.10 49.14 52.16

Change 59.59 32.28 27.75 26.94 31.38 28.16 31.78 42.56

% Change 109.26% 59.59% 47.26% 50.42% 67.11% 55.10% 64.67% 81.59%

Indicator Band q q q q q q q q

VS TARGET

q

VS PREVIOUS ACTUAL

q

2010.09 2010.10 2010.11 2010.12 2011.01 2011.02 2011.03 2011.04 2011.05 2011.06 2011.07 2011.080.00

20.00

40.00

60.00

80.00

100.00

120.00

Azienda XYZ

04/10/2023

09-Rolling average raw material storage Perspective FINANCIAL Band Type - GrAtPresent NOCategory Operating Cycle Frequency Month umber Format Decimal

Last period of evaluation 2011.08 Process Financial Time Frame At present Area Manager Purchasing Manager

Period 2010.09 2010.10 2010.11 2010.12 2011.01 2011.02 2011.03 2011.04 2011.05 2011.06 2011.07 2011.08

Actual

Target

Change

% Change

Indicator Band


Change

% Change

Indicator Band

VS TARGET

VS PREVIOUS ACTUAL

2010.09 2010.10 2010.11 2010.12 2011.01 2011.02 2011.03 2011.04 2011.05 2011.06 2011.07 2011.080

2

4

6

8

10

12

Data for Month

KPI SETTING

Code Kpi 01 Perspective RISK Number Format Amount

Category Financial risk Band Type +

Name Net financial position Area Manager Corporate Administrators Frequency Month

Process Financial Time Frame At present

Kpi Description Financial Debt

Calculation Formula financial liabilities minus cash and cash equivalents

Data Source

Target Description

Other Information

Company

04/10/2023 X KPI 1.43

KPI SETTING

Code Kpi 02 Perspective FINANCIAL Number Format Percentage

Category Profitability Band Type +

Name Gross Margin % Area Manager Corporate Administrators Frequency Month


Kpi Description

Calculation Formula Gross Profit / Net Sales

Data Source

Target Description Budget

Other Information

Indicates the relationship between net sales revenue and the cost of goods sold. This ratio should be compared with industry data as it may indicate insufficient volume and excessive purchasing or labor costs.

Azienda XYZ

04/10/2023

KPI SETTING



Name ROI Area Manager Corporate Administrators Frequency Month


Kpi Description Measures the income earned on the invested capital

Calculation Formula

Data Source


Other Information

Net Income / (Long-term Liabilities + Equity)

Company

04/10/2023 X KPI 1.55

KPI SETTING

Code Kpi 04 Perspective FINANCIAL Number Format Numero


Name Total Asset Turnover Area Manager Corporate Administrators Frequency Month


Kpi Description

Calculation Formula Net Sales / Average Total Assets

Data Source


Other Information

Measures the activity of the assets and the ability of the business to generate sales through the use of the assets.

KPI SETTING



Name ROS Area Manager Corporate Administrators Frequency Month


Kpi Description

Calculation Formula fiscal year's pre-tax income divided by total sales

Data Source

Target Description

Other Information

A measure of a company's profitability, equal to a fiscal year's pre-tax income divided by total sales

KPI SETTING

Code Kpi 06 Perspective FINANCIAL Number Format Amount


Name EBITDA Area Manager Corporate Administrators Frequency Month


Kpi Description A measure of a company's operating cash flow based on data from the company's income statement

Calculation Formula Earnings before the deduction of interest expenses, taxes, depreciation, and amortization.

Data Source

Target Description

Other Information

KPI SETTING

Code Kpi 07 Perspective FINANCIAL Number Format Decimal

Category Operating Cycle Band Type -

Name Accounts Receivable Turnover in Days Area Manager Sales Manager Frequency Month

Process Customer Time Frame At present

Kpi Description

Calculation Formula

Data Source Erp


Other Information

Indicates the liquidity of the company's receivables in days.

Average Gross Receivables / (Annual Net Sales / 365)

KPI SETTING


Category Operating Cycle Band Type +

Name Payables Turnover in Days Area Manager Purchasing Manager Frequency Month

Process Supply Vendor Time Frame At present

Kpi Description

Calculation Formula

Data Source ERP


Other Information

Indicates the liquidity of the firm's payables in days.

Average Accounts Payable / (Purchases / 365)

KPI SETTING



Name Rolling average raw material storage Area Manager Purchasing Manager Frequency Month


Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING



Name Inventory Turnover in Days Area Manager Production Manager Frequency Month


Kpi Description

Calculation Formula Average Inventory / (Cost of Goods Sold / 365)

Data Source

Target Description

Other Information

Indicates the liquidity of the inventory in days.

KPI SETTING

Code Kpi 11 Perspective RISK Number Format Percentage

Category Financial risk Band Type +

Name Investments/Sales Area Manager Corporate Administrators Frequency Month


Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING


Category Costs Band Type -

Name % Purchases Area Manager Purchasing Manager Frequency Month


Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING

Code Kpi 13 Perspective Number Format

Category Band Type

Name Area Manager Frequency

Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

Azienda XYZ

04/10/2023 X KPI 1.43

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description Longevity; duration of service or employment. Often used to indicate how long an employee has worked at a company or an individual has belonged to an organization

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

Azienda XYZ

04/10/2023

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

KPI SETTING


Category Band Type


Process Time Frame

Kpi Description

Calculation Formula

Data Source

Target Description

Other Information

kpi excel software

Documents