This is a Retail Sales Metric Dashboard (Diamond) Report, it is one of reports that Balanced Scorecard Designer can generate for Retail Sales KPI. With this software you can also design your own scorecards, KPIs and metrics.

Retail Sales

Report includes: 1 day(s), from 28.10.2008 to 28.10.2008

Name

Start value

End value

Dynamic

Contains

Retail Sales

51,78 %

0 %

Sales Controller	(17,2%, 0%)
Inventory Controller	(56,7%, 0%)
Customer Power	(63,5%, 0%)
Training and Development	(84,6%, 0%)

Graph for Retail Sales

Data for Retail Sales

Dates	Value
28.10.2008	51,78

Sales Controller

Name

Start value

End value

Dynamic

Parent

Contains

Sales Controller

17,23 %

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
28.10.2008	17,23	3

Retail Sales

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Retail Sales	110,88	110,88	0	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
28.10.2008	6	60	300	110,88

Sales by Department or Product Category

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Sales by Department or Product Category	11,04	11,04	0	%	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
28.10.2008	1	5	45	11,04

Inventory Controller

Name

Start value

End value

Dynamic

Parent

Contains

Inventory Controller

56,67 %

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
28.10.2008	56,67	3

Inventory Turns Rate

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Inventory Turns Rate	10,21	10,21	0	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
28.10.2008	7	2	12	10,21

Days Inventory Outstanding (DIO)

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Days Inventory Outstanding (DIO)	133,8	133,8	0	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
28.10.2008	1	30	180	133,8

Customer Power

Name

Start value

End value

Dynamic

Parent

Contains

Customer Power

63,49 %

Retail Sales

Indicators

Selling Opportunities

Net Cash Flow per Customer

Return on Customer *

* - Information for this metric is limited in sample report Description Evaluation of customer impact on the retail business

Graph for Customer Power

Data for Customer Power

Dates	Value	Weight
28.10.2008	63,49	2

Selling Opportunities

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Selling Opportunities	257,48	257,48	0	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
28.10.2008	2	30	500	257,48

Net Cash Flow per Customer

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Net Cash Flow per Customer	17,3	17,3	0	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
28.10.2008	1	0	100	17,3

Training and Development

Name

Start value

End value

Dynamic

Parent

Contains

Training and Development

84,58 %

Retail Sales

Indicators

Quota Attainment

Training Cost

Benefit Test *

* - Information for this metric is limited in sample report 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
28.10.2008	84,58	2

Quota Attainment

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Quota Attainment	72,01	72,01	0	%	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
28.10.2008	2	10	100	72,01

Training Cost

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Training Cost	5,495	5,495	0	%	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
28.10.2008	7	5	60	5,495

Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 20.11.2008 17:29:30