REVENUE

JAN FEB MAR

Sales $ 240,000 $ 280,000 $ 235,000
Services $ 15,000 $ 12,500 $ 10,800
TOTAL REVENUE $ 255,000 $ 292,500 $ 245,800
TARGET REVENUE $ 245,000 $ 290,000 $ 225,000
Difference +4.1% +0.9% +9.2%

COGS AND OTHER EXPENSES

JAN FEB MAR
COGS $ 102,000 $ 135,000 $ 114,500
OTHER EXPENSES $ 4,611 $ 4,004 $ 4,624

INTEREST & TAX

JAN FEB MAR
INTEREST $ 19,979 $ 14,081 $ 14,702
TAX $ 9,989 $ 7,041 $ 7,351

OPERATING EXPENSES
JAN FEB MAR
Sales $ 30,435 $ 27,382 $ 29,250
Marketing $ 8,500 $ 9,000 $ 10,000
IT $ 15,000 $ 15,000 $ 9,500
General & Admin $ 8,810 $ 14,654 $ 13,242
TOTAL OPERATING EXPENSES $ 62,745 $ 66,036 $ 61,992
TARGET OPERATING EXPENSES $ 60,000 $ 65,000 $ 60,000
Difference +4.6% +1.6% +3.3%

GROSS PROFIT
JAN FEB MAR
Gross profit $ 153,000 $ 157,500 $ 131,300
TARGET GROSS PROFIT $ 147,000 $ 155,000 $ 122,000
Difference +4.1% +1.6% +7.6%

EBIT
JAN FEB MAR
EBIT $ 85,644 $ 87,460 $ 64,684
TARGET EBIT $ 85,000 $ 87,000 $ 58,500
Difference +0.8% +0.5% +10.6%
EBIT% 33.6% 29.9% 26.3%
TARGET EBIT% 34.7% 30.0% 26.0%
Difference -3.2% -0.3% +1.2%
NET PROFIT
JAN FEB MAR
Net profit $ 55,676 $ 66,338 $ 42,630
TARGET NET PROFIT $ 61,000 $ 63,000 $ 45,000
Difference -8.7% +5.3% -5.3%

Employee Net Promoter Score (eNPS)

Promoters Passives
(Respond 4-5) (Respond 3)
JAN 10 2
FEB 11 2
MAR 12 1
APR 12 1
MAY 11 0
JUN 10 1
JUL 9 2
AUG 11 3
SEP 10 3
OCT 11 3
NOV 11 3
DEC 11 3
YTD 129 24

Employee Net Promoter Score (eNPS)

Promoters Passives
(Respond 4-5) (Respond 3)
JAN 55% 10%
FEB 58% 12%
MAR 60% 14%
APR 55% 12%
MAY 54% 11%
JUN 52% 15%
JUL 51% 20%
AUG 54% 18%
SEP 56% 22%
OCT 54% 18%
NOV 52% 17%
DEC 49% 20%
 YTD 54% 16%

Employee Performance Metrics

EMPLOYEE PHOTO DEPARTMENT

Liam Smith Sales

Noah Johnson Marketing

Oliver Williams IT

Emilia Brown Administration

James Jones Sales

Mateo Garcia Sales

Theodore Miller Sales

Lucas Davis Sales

Vera Rodriguez Sales

 William Martinez IT

Benjamin Hernandez IT

Sarah Lopez Administration

Sebastian Gonzales Administration

Jack Wilson Marketing

Jessica Anderson Marketing

Michael Thomas Sales

Alexandra Taylor Sales

Leo Moore Sales

 6 "-MAX row for top performer"

TOP PERFORMER

Mateo Garcia Emp_6 Sales

Employee Cost VS Sales

EMPLOYEE COST
SALES
EMOLOYEE COST VS SALES (%)

INVENTORY

STOCK VALUE
ITEMS AVAILABLE ON STOCK
GROUP 1
GROUP 2
GROUP 3
GROUP 1
GROUP 2
GROUP 3
 APR MAY JUN JUL AUG SEP
$ 302,000 $ 215,000 $ 240,000 $ 300,000 $ 218,000 $ 298,000
$ 8,500 $ 14,500 $ 21,500 $ 22,400 $ 12,600 $ 17,400
$ 310,500 $ 229,500 $ 261,500 $ 322,400 $ 230,600 $ 315,400
$ 245,000 $ 220,000 $ 240,000 $ 250,000 $ 220,000 $ 250,000
+26.7% +4.3% +9.0% +29.0% +4.8% +26.2%

APR MAY JUN JUL AUG SEP

$ 158,000 $ 102,000 $ 120,000 $ 154,000 $ 104,500 $ 144,200
$ 2,837 $ 5,044 $ 7,154 $ 5,610 $ 3,354 $ 1,185

APR MAY JUN JUL AUG SEP

$ 21,902 $ 19,094 $ 19,029 $ 22,847 $ 20,246 $ 12,893
$ 10,951 $ 9,547 $ 9,514 $ 11,423 $ 10,123 $ 6,446

APR MAY JUN JUL AUG SEP

$ 30,349 $ 30,526 $ 29,644 $ 28,787 $ 29,011 $ 29,641
$ 12,000 $ 11,000 $ 8,000 $ 7,500 $ 9,500 $ 10,500
$ 26,004 $ 8,500 $ 8,500 $ 8,500 $ 15,550 $ 8,500
$ 7,500 $ 7,500 $ 7,500 $ 6,246 $ 8,975 $ 15,046
$ 75,853 $ 57,526 $ 53,644 $ 51,033 $ 63,036 $ 63,687
$ 65,000 $ 60,000 $ 60,000 $ 60,000 $ 65,000 $ 60,000
+16.7% -4.1% -10.6% -14.9% -3.0% +6.1%

APR MAY JUN JUL AUG SEP

$ 152,500 $ 127,500 $ 141,500 $ 168,400 $ 126,100 $ 171,200
$ 125,000 $ 125,000 $ 138,000 $ 140,000 $ 124,000 $ 150,000
+22.0% +2.0% +2.5% +20.3% +1.7% +14.1%

APR MAY JUN JUL AUG SEP

$ 73,810 $ 64,930 $ 80,702 $ 111,757 $ 59,710 $ 106,328
$ 57,000 $ 62,000 $ 75,000 $ 76,500 $ 57,000 $ 82,000
+29.5% +4.7% +7.6% +46.1% +4.8% +29.7%
23.8% 28.3% 30.9% 34.7% 25.9% 33.7%
23.3% 28.2% 31.3% 30.6% 25.9% 32.8%
+2.2% +0.4% -1.2% +13.3% -0.1% +2.8%
 APR MAY JUN JUL AUG SEP
$ 40,957 $ 36,289 $ 52,159 $ 77,487 $ 29,341 $ 86,989
$ 45,000 $ 40,000 $ 50,000 $ 70,000 $ 30,000 $ 80,000
-9.0% -9.3% +4.3% +10.7% -2.2% +8.7%

Detractors eNPS eNPS Trend Last

eNPS Score
(Respond 1-2) Last 3 Months Prev 3 Months 3 months
6 22 95 58 POSITIVE
6 26
7 25
7 25
8 16 HELPER DATA FOR DONUT CHART
8 11 60 185 115
8 5
5 32
6 21
5 32
5 32 INCREASE
5 32
76 +23

Detractors NPS NPS Trend Last

eNPS Score
(Respond 1-2) Last 3 Months Prev 3 Months 3 months
35% 20 65 82 NEGATIVE
30% 28
26% 34
33% 22
35% 19 HELPER DATA FOR DONUT CHART
33% 19 60 186 114
29% 22
28% 26
22% 34
28% 26
31% 21 DECREASE
31% 18
 DECREASE

30% +24

ROLE JAN FEB MAR APR

Sales Manager 5.0 4.8 4.8 4.2

Marketing Analyst 4.6 4.4 4.4 4.0

IT manager 3.6 4.0 4.2 4.6

Assistant 3.8 4.0 4.0 4.6

Sales Specialist 5.0 3.8 4.6 3.6

Sales Specialist 5.0 4.8 4.6 5.0

Sales Specialist 4.8 4.4 3.6 4.8

Account Executive 4.4 4.2 3.8 4.4

Sales Developer 3.8 4.0 4.6 3.8

Network Administrator 5.0 4.8 4.6 4.2

Programer 3.8 4.2 4.6 4.4

Office Administartor 5.0 4.8 4.2 4.2

Accounting Manager 4.4 4.8 4.0 5.0

Brand Manager 3.6 4.6 4.0 4.8

Digital Marketing 4.4 4.2 4.6 4.2

Sales Specialist 4.4 4.6

Sales Specialist

Sales Specialist
TOTAL EMPLOYEES 15 15 16 16

MAX

Sales Specialist 4.6 5.0

JAN FEB MAR APR

$ 52,200 $ 52,350 $ 56,000 $ 56,200
$ 240,000 $ 280,000 $ 235,000 $ 302,000
22% 19% 24% 19%

JAN FEB MAR APR

$ 650,000 $ 685,000 $ 696,000 $ 672,000
6,500 7,000 7,100 6,800
1,200 1,000 800 300
PURCHASED 1,000 1,200 600 800
1,200 1,000 1,100 400
800 1,400 1,100 700
SOLD 300 500 1,300 300
800 100 1,400 1,000
 OCT NOV DEC YTD HELPER DATA
$ 240,000 $ 251,500 $ 278,500 $ 3,098,000
$ 14,200 $ 13,500 $ 21,000 $ 183,900
$ 254,200 $ 265,000 $ 299,500 $ 3,281,900
$ 240,000 $ 240,000 $ 250,000 $ 2,915,000 PLUS MINUS
+5.9% +10.4% +19.8% +12.6% +12.6%

OCT NOV DEC YTD

$ 125,500 $ 126,000 $ 137,000 $ 1,522,700
$ 3,513 $ 5,322 $ 4,584 $ 51,842

OCT NOV DEC YTD

$ 16,512 $ 13,917 $ 20,168 $ 215,370
$ 8,256 $ 6,958 $ 10,084 $ 107,685

OCT NOV DEC YTD HELPER DATA

$ 27,289 $ 27,625 $ 28,493 $ 348,432
$ 11,000 $ 8,600 $ 9,200 $ 114,800
$ 8,500 $ 8,500 $ 8,500 $ 140,554
$ 13,210 $ 9,500 $ 9,500 $ 121,683
$ 59,999 $ 54,225 $ 55,693 $ 725,469
$ 55,000 $ 60,000 $ 50,000 $ 720,000 PLUS MINUS
+9.1% -9.6% +11.4% +0.8% +0.8%

OCT NOV DEC YTD HELPER DATA

$ 128,700 $ 139,000 $ 162,500 $ 1,759,200
$ 125,000 $ 132,000 $ 140,000 $ 1,623,000 PLUS MINUS
+3.0% +5.3% +16.1% +8.4% +8.4%

OCT NOV DEC YTD HELPER DATA

$ 65,188 $ 79,453 $ 102,223 $ 981,889
$ 63,000 $ 69,000 $ 77,000 $ 849,000 PLUS MINUS
+3.5% +15.1% +32.8% +15.7% +15.7%
25.6% 30.0% 34.1% 29.9%
26.3% 28.7% 30.8% 29.1% PLUS MINUS
-2.3% +4.3% +10.8% +2.7% +2.7%
 OCT NOV DEC YTD HELPER DATA
$ 40,419 $ 58,578 $ 71,971 $ 658,835
$ 45,000 $ 55,000 $ 70,000 $ 654,000 PLUS MINUS
-10.2% +6.5% +2.8% +0.7% +0.7%
MAY JUN JUL AUG SEP OCT

4.2 3.8 4.6 4.8 4.8 3.6

5.0 4.0 4.6 4.2 4.2 5.0

4.8 4.8 3.6 4.6 4.6 4.8

4.2 4.2 5.0 4.2 3.6 5.0

4.6 4.6 4.8

4.2 4.2 5.0 4.2 3.6 5.0

4.8 3.8 3.8 4.6 3.6 3.8

4.4 4.6 4.8 4.6 5.0 3.8

4.2 4.6 4.4 3.6 4.8 3.8

4.0 4.4 4.2 3.8 4.4 3.8

4.2 4.4 4.6 4.4 4.0 4.4

4.2 4.4 4.6 4.4 4.0 4.2

4.2 5.0 4.6 4.4 4.0 4.6

5.0 4.6 4.6 4.4 4.0 4.6

4.4 3.6 4.8 4.8 5.0 4.6

4.4 3.8 4.6 4.2 4.4 3.8

4.2 4.4 4.6 4.4 4.6

4.4 4.2
 16 17 17 16 17 17

MAY JUN JUL AUG SEP OCT

$ 56,800 $ 60,200 $ 60,350 $ 60,450 $ 62,200 $ 63,000
$ 215,000 $ 240,000 $ 300,000 $ 218,000 $ 298,000 $ 240,000
26% 25% 20% 28% 21% 26%

MAY JUN JUL AUG SEP OCT

$ 604,000 $ 585,000 $ 603,000 $ 578,000 $ 542,000 $ 485,000
6,300 6,100 6,300 6,000 5,700 5,000
500 1,100 1,000 800 400 1,200
1,200 1,000 800 900 400 1,100
900 700 700 500 800 500
1,000 400 1,800 600 900 300
1,400 1,100 700 1,100 500 800
1,400 1,100 300 800 900 900
HELPER DATA

TARGET RED GREEN

### N/A ###

HELPER DATA

TARGET RED GREEN

$ 725,469 $ 720,000 N/A

HELPER DATA

TARGET RED GREEN

### N/A ###

HELPER DATA

TARGET RED GREEN

$ 849,000 N/A $ 981,889

TARGET RED GREEN

29.1% N/A 29.9%
HELPER DATA

TARGET RED GREEN

$ 654,000 N/A $ 658,835
NOV DEC YTD

4.2 5.0 4.5

4.2 4.8 4.5

4.2 5.0 4.4

5.0 3.8 4.3

4.4

5.0 4.8 4.6

4.2 4.4 4.2

4.2 4.4 4.4

4.2 4.4 4.2

4.2 4.8 4.4

4.2 4.4 4.3

4.2 4.4 4.4

4.2 4.4 4.5

5.0 5.0 4.5

4.2 4.4 4.4

4.2 4.4 4.3

4.2 4.0 4.3

4.2 4.4 4.3

#DIV/0!

Current
#DIV/0!
employees
 17 17 17

NOV DEC YTD

$ 64,900 $ 65,100 $ 709,750
$ 251,500 $ 278,500 ###
26% 23% 23%

NOV DEC YTD

$ 578,000 $ 628,000 $ 628,000
5,800 6,100 6,100
800 600 9,700
1,100 1,000 11,100
600 1,400 9,800
1,100 1,000 11,100
600 1,100 9,700
500 1,300 10,500
CEO DASHBOARD I YTD (December 2024) COMPANY NAME

INCOME STATEMENT
REVENUE OPERATING EXPENSES EBIT%
REVENUE $3,281,900
$3,281,900 $725,469 29.9%
COGS $1,522,700

Target: $2,915,000 +12.6% Target: $720,000 +0.8% Target:29.1% +2.7%

GROSS PROFIT $1,759,200

OPERATING EXPENSES $725,469

OTHER EXPENSES $51,842

GROSS PROFIT EBIT NET PROFIT
INTEREST $215,370

TAX $107,685 $1,759,200 $981,889 $658,835

Target: $1,623,000 +8.4% Target: $849,000 +15.7% Target: $654,000 +0.7%
NET PROFIT $658,835

Employee Net Promoter Score (eNPS)

3-Months Trend Customer Satisfaction (NPS) 3-Months Trend
32

32

32

32

34

34
POSITIVE NEGATIVE
26

28
25

25

26

26
22

21

22

22

21
20

19

19

18
16

11

-100 +100 -100 +100

+23 +24

SALES vs EMPLOYEE COST

28%
ITEMS
AVAILABLE 6,100 STOCK
VALUE $628,000
$350,000 26% 26% 26%
25%
24% 23%
$300,000 22% $800,000 8,000
20% 21% $700,000 7,000
$250,000 19% 19% $600,000 6,000
$200,000 $500,000 5,000
$150,000 $400,000 4,000
$300,000 3,000
$100,000
$200,000 2,000
$50,000 $100,000 1,000
$- $- 0
Sales Employee Cost Items Available Stock value

NUMBER OF PURCHASED ITEMS NUMBER OF SOLD ITEMS

TOTAL EMPLOYEES TOP EMPLOYEE PERFORMER PER GROUPS PER GROUPS

17
11,10 11,10
Mateo Garcia 0 0
10,50
Sales 0
18

17
Sales Specialist
18

17
Sales Specialist
9,700 9,800 9,700

4.6
16

15

14
GROUP 1 GROUP 2 GROUP 3 GROUP 1 GROUP 2 GROUP 3
© TemplateLab.com