This is a Retail Sales Balanced Scorecard Report, it is one of reports that Balanced Scorecard Designer can generate for Retail Sales scorecard. With this software you can also design your own KPIs, Balanced Scorecards and metrics.

Retail Sales

Report includes: 1 month(s) 49 day(s), from 05.04.2008 to 24.05.2008

Name

Start value

End value

Dynamic

Contains

Retail Sales

70,55 %

49,79 %

-20,76 %

Sales Controller	(71,2%, -1,26%)
Inventory Controller	(30,7%, -44,52%)
Customer Power	(46,8%, -27,7%)
Training and Development	(49,3%, -7,4%)

Graph for Retail Sales

Data for Retail Sales

Dates	Value
05.04.2008	70,55
12.04.2008	45,2
19.04.2008	61,96
26.04.2008	50,14
03.05.2008	43,58
10.05.2008	35,01
17.05.2008	50,99
24.05.2008	49,79

Sales Controller

Name

Start value

End value

Dynamic

Parent

Contains

Sales Controller

72,44 %

71,18 %

-1,26%

Retail Sales

Indicators

Retail Sales

Sales by Department or Product Category

Gross Margin

Sales Capacity *

Selling Hour Value *

* - Information for this metric is limited in sample report Description Assessment of the retail sales efficiency

Graph for Sales Controller

Data for Sales Controller

Dates	Value	Weight
05.04.2008	72,44	3
12.04.2008	66,52	3
19.04.2008	35,49	3
26.04.2008	35,4	3
03.05.2008	11,82	3
10.05.2008	38,37	3
17.05.2008	48,99	3
24.05.2008	71,18	3

Retail Sales

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Retail Sales	274,8	258	-16,8	Score	Maximize	Sales Controller

Description Retail Sales=Number of Shoppers x Closing Ratio (number who buy) x Average Amount Purchased
Target description Amount

Graph for Retail Sales

Data for Retail Sales

Dates	Weight	Min	Max	Value
05.04.2008	6	60	300	274,8
12.04.2008	6	60	300	273,6
19.04.2008	6	60	300	131,76
26.04.2008	6	60	300	114
03.05.2008	6	60	300	71,04
10.05.2008	6	60	300	131,28
17.05.2008	6	60	300	199,92
24.05.2008	6	60	300	258

Sales by Department or Product Category

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Sales by Department or Product Category	29,92	37,04	+ 7,12	%	Maximize	Sales Controller

Description Allows to compare product categories within a retail store
Target description Category's % of Total Store Sales=Category's Total Net Sales ? Store's Total Net Sales

Graph for Sales by Department or Product Category

Data for Sales by Department or Product Category

Dates	Weight	Min	Max	Value
05.04.2008	1	5	45	29,92
12.04.2008	1	5	45	24,44
19.04.2008	1	5	45	9,2
26.04.2008	1	5	45	30,84
03.05.2008	1	5	45	21,48
10.05.2008	1	5	45	6,32
17.05.2008	1	5	45	34,68
24.05.2008	1	5	45	37,04

Gross Margin

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Gross Margin	4366	5068	+ 702	Score	Maximize	Sales Controller

Description Gross Margin = Total Sales - Cost of Goods
Target description USD

Graph for Gross Margin

Data for Gross Margin

Dates	Weight	Min	Max	Value
05.04.2008	3	1000	10000	4366
12.04.2008	3	1000	10000	5257
19.04.2008	3	1000	10000	6148
26.04.2008	3	1000	10000	5149
03.05.2008	3	1000	10000	1144
10.05.2008	3	1000	10000	4123
17.05.2008	3	1000	10000	1513
24.05.2008	3	1000	10000	5068

Inventory Controller

Name

Start value

End value

Dynamic

Parent

Contains

Inventory Controller

75,24 %

30,72 %

-44,52%

Retail Sales

Indicators

Inventory Turns Rate

Days Inventory Outstanding (DIO)

Inventories-to-Sales Ratio (ISR)

Gross Margin Return on Inventory Investment (GMROII) *

* - Information for this metric is limited in sample report Description Assessment of inventory profitability of the retail business

Graph for Inventory Controller

Data for Inventory Controller

Dates	Value	Weight
05.04.2008	75,24	3
12.04.2008	36,33	3
19.04.2008	71,81	3
26.04.2008	59,18	3
03.05.2008	78,55	3
10.05.2008	37,51	3
17.05.2008	62,81	3
24.05.2008	30,72	3

Inventory Turns Rate

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Inventory Turns Rate	11,14	2,07	-9,07	Score	Maximize	Inventory Controller

Description Assessment of how fast a retail business turns its inventory
Target description Inventory Turns Rate=Current Year's Cost of Goods Sold or Cost of Revenues ? The average inventory value for the period

Graph for Inventory Turns Rate

Data for Inventory Turns Rate

Dates	Weight	Min	Max	Value
05.04.2008	7	2	12	11,14
12.04.2008	7	2	12	3,36
19.04.2008	7	2	12	8,63
26.04.2008	7	2	12	8,41
03.05.2008	7	2	12	10,25
10.05.2008	7	2	12	4,73
17.05.2008	7	2	12	9,82
24.05.2008	7	2	12	2,07

Days Inventory Outstanding (DIO)

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Days Inventory Outstanding (DIO)	100,95	54,6	-46,35	Score	Minimize	Inventory Controller

Description Measures how long it takes inventory to be replenished
Target description DIO = the number of days in a year ? inventory turns number

Graph for Days Inventory Outstanding (DIO)

Data for Days Inventory Outstanding (DIO)

Dates	Weight	Min	Max	Value
05.04.2008	1	30	180	100,95
12.04.2008	1	30	180	94,5
19.04.2008	1	30	180	67,2
26.04.2008	1	30	180	62,25
03.05.2008	1	30	180	79,2
10.05.2008	1	30	180	159
17.05.2008	1	30	180	120,75
24.05.2008	1	30	180	54,6

Inventories-to-Sales Ratio (ISR)

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Inventories-to-Sales Ratio (ISR)	1,507	1,178	-0,329	Score	Minimize	Inventory Controller

Description Measures the discrepancy of a retailer's inventory to its sales volume. A high ISR ratio means that a retailer sales are stalling.
Target description ISR = Average Inventories ? Average Sales

Graph for Inventories-to-Sales Ratio (ISR)

Data for Inventories-to-Sales Ratio (ISR)

Dates	Weight	Min	Max	Value
05.04.2008	2	1	2	1,507
12.04.2008	2	1	2	1,016
19.04.2008	2	1	2	1,188
26.04.2008	2	1	2	1,627
03.05.2008	2	1	2	1,119
10.05.2008	2	1	2	1,452
17.05.2008	2	1	2	1,57
24.05.2008	2	1	2	1,178

Customer Power

Name

Start value

End value

Dynamic

Parent

Contains

Customer Power

74,5 %

46,8 %

-27,7%

Retail Sales

Indicators

Selling Opportunities

Net Cash Flow per Customer

Return on Customer

Description Evaluation of customer impact on the retail business

Graph for Customer Power

Data for Customer Power

Dates	Value	Weight
05.04.2008	74,5	2
12.04.2008	46	2
19.04.2008	68,39	2
26.04.2008	82,29	2
03.05.2008	32,17	2
10.05.2008	27,25	2
17.05.2008	48,92	2
24.05.2008	46,8	2

Selling Opportunities

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Selling Opportunities	262,18	318,11	+ 55,93	Score	Maximize	Customer Power

Description The number of shoppers that come to the store
Target description People

Graph for Selling Opportunities

Data for Selling Opportunities

Dates	Weight	Min	Max	Value
05.04.2008	2	30	500	262,18
12.04.2008	2	30	500	178,05
19.04.2008	2	30	500	159,25
26.04.2008	2	30	500	493,42
03.05.2008	2	30	500	199,67
10.05.2008	2	30	500	34,23
17.05.2008	2	30	500	359,94
24.05.2008	2	30	500	318,11

Net Cash Flow per Customer

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Net Cash Flow per Customer	55,4	21,3	-34,1	Score	Maximize	Customer Power

Description Net Cash Flow per Customer = Revenue generated by a customer - The expenses incurred in acquiring and supporting that customer
Target description USD

Graph for Net Cash Flow per Customer

Data for Net Cash Flow per Customer

Dates	Weight	Min	Max	Value
05.04.2008	1	0	100	55,4
12.04.2008	1	0	100	22,5
19.04.2008	1	0	100	74,5
26.04.2008	1	0	100	25,1
03.05.2008	1	0	100	89,2
10.05.2008	1	0	100	85,9
17.05.2008	1	0	100	70,2
24.05.2008	1	0	100	21,3

Return on Customer

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Return on Customer	68,3	39,725	-28,57	%	Maximize	Customer Power

Description Return on Customer = A retail business's current-period profit from its customers + Any changes in customer equity (the sum of the lifetime values of all current and future customers served by the company) ? The total customer equity at the beginning of the period

Graph for Return on Customer

Data for Return on Customer

Dates	Weight	Min	Max	Value
05.04.2008	7	5	80	68,3
12.04.2008	7	5	80	45,125
19.04.2008	7	5	80	64,4
26.04.2008	7	5	80	69,35
03.05.2008	7	5	80	22,175
10.05.2008	7	5	80	24,8
17.05.2008	7	5	80	34,85
24.05.2008	7	5	80	39,725

Training and Development

Name

Start value

End value

Dynamic

Parent

Contains

Training and Development

56,71 %

49,31 %

-7,4%

Indicators

Description Management of training expenses. Evaluation of the efficiency of training provided.

Graph for Training and Development

Data for Training and Development

Dates	Value	Weight
05.04.2008	56,71	2
12.04.2008	25,72	2
19.04.2008	80,46	2
26.04.2008	26,54	2
03.05.2008	50,17	2
10.05.2008	34	2
17.05.2008	38,32	2
24.05.2008	49,31	2

Quota Attainment

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Quota Attainment	13,69	14,32	+ 0,63	%	Maximize	Training and Development

Description Evaluation in percentage of the degree to which the sales quota has been attained

Graph for Quota Attainment

Data for Quota Attainment

Dates	Weight	Min	Max	Value
05.04.2008	2	10	100	13,69
12.04.2008	2	10	100	78,04
19.04.2008	2	10	100	59,23
26.04.2008	2	10	100	40,78
03.05.2008	2	10	100	50,14
10.05.2008	2	10	100	64,81
17.05.2008	2	10	100	83,8
24.05.2008	2	10	100	14,32

Training Cost

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Training Cost	19,3	27	+ 7,7	%	Minimize	Training and Development

Description Money spent on personnel education and training as a percentage of HR budget

Graph for Training Cost

Data for Training Cost

Dates	Weight	Min	Max	Value
05.04.2008	7	5	60	19,3
12.04.2008	7	5	60	53,125
19.04.2008	7	5	60	9,895
26.04.2008	7	5	60	48,395
03.05.2008	7	5	60	29,255
10.05.2008	7	5	60	44,71
17.05.2008	7	5	60	48,12
24.05.2008	7	5	60	27

Benefit Test

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Benefit Test	23,405	33,575	+ 10,17	%	Maximize	Training and Development

Description Assessment of sales achievements after the training
Target description Assessment is based on quota attainment improvement

Graph for Benefit Test

Data for Benefit Test

Dates	Weight	Min	Max	Value
05.04.2008	1	5	50	23,405
12.04.2008	1	5	50	13,325
19.04.2008	1	5	50	30,875
26.04.2008	1	5	50	27,185
03.05.2008	1	5	50	14,54
10.05.2008	1	5	50	15,62
17.05.2008	1	5	50	35,6
24.05.2008	1	5	50	33,575

Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 28.04.2008 23:58:16