Automated Metrics Program for various Companies

Metrics programs have become common, but usually require hours of running reports, cutting and pasting the results, then manually preparing charts and graphs.

With methods developed by HKC a number of clients have been able to redirected their managers time from Collecting and Organizing data for the reports to Developing Action Plans and Solving Problems.

These modules can be developed for any Operational Objective the client wishes to track, be it:

 Sales

 Financial

 Customer Focus

 Operational Performance

 

The workbook created for each of these Metrics contains a query into the enterprise system tables, which can be brought up to date with the click of a mouse. These queries can provide whatever data the client requests to help the staff with root cause analysis. A tracking chart tab is also included to reflect actual performance.

Invoice_No

Part_Key

 

Revision

Invoice_Date

FirstOfQuantity

Due_Date

Credit

Days

0109617

1667038

 

 

9/30

90000

7/25

13500

67

0109616

1666360

 

B

9/30

809300

8/19

97116

42

0109616

1666715

 

B

9/30

300000

8/19

33000

42

0109620

1665962

 

 

9/30

450000

8/19

63000

42

0109620

1665962

 

 

9/30

450000

8/26

63000

35

0109617

1656380

 

B

9/30

300000

8/28

33450

33

0109620

1667015

 

B

9/30

600000

9/9

66000

21

0109620

1667015

 

B

9/30

600000

9/16

66000

14

0109609

1695855

 

 

9/30

16600

9/18

8266.8

12

0109609

1695864

 

 

9/30

8800

9/18

8052

12

0109629

1651518

 

 

9/30

3780

9/19

4960.87

11

0109620

1667015

 

B

9/30

600000

9/23

66000

7

0109610

1693391

 

B

9/30

7615

9/24

2637.84

6

0109626

1458763

 

 

9/30

10584

9/26

10266.48

4

0109633

985479

 

 

9/30

8400

9/30

426.72

0

0109631

985514

 

 

9/30

17000

9/30

982.77

0

0109621

985252

 

 

9/30

6000

9/30

354.66

0

0109621

985429

 

 

9/30

36000

9/30

2531.16

0

0109622

985578

 

 

9/30

69000

9/30

9487.5

0

0109623

985295

 

 

9/30

18000

9/30

1022.4

0