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

Travel Agency Scorecard

Report includes: 1 month(s) 49 day(s), from 23.12.2008 to 10.02.2009

Name

Start value

End value

Dynamic

Contains

Travel Agency Scorecard

49,18 %

43,64 %

-5,54 %

Financial Perspective	(28,6%, -15,09%)
Customer Services and Satisfaction Perspective	(51,5%, -10,25%)
Internal Operations Perspective	(48,3%, -9,65%)
Business Planning and Growth Perspective	(49,7%, 19,95%)

Graph for Travel Agency Scorecard

Data for Travel Agency Scorecard

Dates	Value
23.12.2008	49,18
30.12.2008	33,94
06.01.2009	53,07
13.01.2009	51,93
20.01.2009	47,35
27.01.2009	39,54
03.02.2009	58,69
10.02.2009	43,64

Financial Perspective

Name

Start value

End value

Dynamic

Parent

Contains

Financial Perspective

43,69 %

28,6 %

-15,09%

Travel Agency Scorecard

Indicators

Operating profit

% increase in planned sales

Actual Sales step-up ratio

% increase in travel and entertainment cost *

* - Information for this metric is limited in sample report Description The KPIs under this category are to judge and improve the financial standing of the organization.

Graph for Financial Perspective

Data for Financial Perspective

Dates	Value	Weight
23.12.2008	43,69	3
30.12.2008	41,89	3
06.01.2009	65,98	3
13.01.2009	51,21	3
20.01.2009	54,16	3
27.01.2009	44,18	3
03.02.2009	67,77	3
10.02.2009	28,6	3

Operating profit

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Operating profit	44,065	31,195	-12,87	$ million	Maximize	Financial Perspective

Description This is the most important financial metric, indicating the financial health of the organization.

Graph for Operating profit

Data for Operating profit

Dates	Weight	Min	Max	Value
23.12.2008	3	1	100	44,065
30.12.2008	3	1	100	18,127
06.01.2009	3	1	100	91,585
13.01.2009	3	1	100	51,787
20.01.2009	3	1	100	28,423
27.01.2009	3	1	100	3,574
03.02.2009	3	1	100	81,388
10.02.2009	3	1	100	31,195

% increase in planned sales

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	% increase in planned sales	17,425	15,075	-2,35	%	Maximize	Financial Perspective

Description It refers to the % increase in the planned sales over the past 6 months. This KPI shows the efficiency of the travel consultants.

Graph for % increase in planned sales

Data for % increase in planned sales

Dates	Weight	Min	Max	Value
23.12.2008	2	5	30	17,425
30.12.2008	2	5	30	29,95
06.01.2009	2	5	30	29,725
13.01.2009	2	5	30	17,25
20.01.2009	2	5	30	18,225
27.01.2009	2	5	30	23,2
03.02.2009	2	5	30	22,525
10.02.2009	2	5	30	15,075

Actual Sales step-up ratio

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Actual Sales step-up ratio	0,4768	0,4054	-0,0714	#	Maximize	Financial Perspective

Description This is a direct reflection of the progress being made, in expanding the operations in 'financial terms'.

Graph for Actual Sales step-up ratio

Data for Actual Sales step-up ratio

Dates	Weight	Min	Max	Value
23.12.2008	3	0,4	1	0,4768
30.12.2008	3	0,4	1	0,4864
06.01.2009	3	0,4	1	0,4666
13.01.2009	3	0,4	1	0,532
20.01.2009	3	0,4	1	0,8098
27.01.2009	3	0,4	1	0,6844
03.02.2009	3	0,4	1	0,7114
10.02.2009	3	0,4	1	0,4054

Customer Services and Satisfaction Perspective

Name

Start value

End value

Dynamic

Parent

Contains

Customer Services and Satisfaction Perspective

61,74 %

51,49 %

-10,25%

Travel Agency Scorecard

Indicators

Number of Ancillary facilities

Favourable review Index

Look/Book index

% increase in customer base *

* - Information for this metric is limited in sample report Description This group of indicators is to know how well the efforts of the management and employees are becoming visible, in the form of satisfaction realized by clients.

Graph for Customer Services and Satisfaction Perspective

Data for Customer Services and Satisfaction Perspective

Dates	Value	Weight
23.12.2008	61,74	3
30.12.2008	20,75	3
06.01.2009	58,57	3
13.01.2009	52,99	3
20.01.2009	48,48	3
27.01.2009	23,1	3
03.02.2009	48,94	3
10.02.2009	51,49	3

Number of Ancillary facilities

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Number of Ancillary facilities	6,62	5,515	-1,105	#	Maximize	Customer Services and Satisfaction Perspective

Description This KIP's value is equal to the additional facilities provided to customers like mobile alerts, previews (video, hotel looks and reviews) and attractive deals on packages.

Graph for Number of Ancillary facilities

Data for Number of Ancillary facilities

Dates	Weight	Min	Max	Value
23.12.2008	3	3	8	6,62
30.12.2008	3	3	8	3,45
06.01.2009	3	3	8	6,555
13.01.2009	3	3	8	7,41
20.01.2009	3	3	8	6,855
27.01.2009	3	3	8	3,65
03.02.2009	3	3	8	5,485
10.02.2009	3	3	8	5,515

Favourable review Index

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Favourable review Index	0,662	0,6972	+ 0,0352	#	Maximize	Customer Services and Satisfaction Perspective

Description The value of this parameter can be had by knowing the percentage of travellers that rated the experience as 'satisfying'.

Graph for Favourable review Index

Data for Favourable review Index

Dates	Weight	Min	Max	Value
23.12.2008	2	0,6	1	0,662
30.12.2008	2	0,6	1	0,8596
06.01.2009	2	0,6	1	0,664
13.01.2009	2	0,6	1	0,8032
20.01.2009	2	0,6	1	0,748
27.01.2009	2	0,6	1	0,7448
03.02.2009	2	0,6	1	0,6992
10.02.2009	2	0,6	1	0,6972

Look/Book index

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Look/Book index	0,9258	0,706	-0,22	#	Maximize	Customer Services and Satisfaction Perspective

Description This parameter is to know the fraction of 'lookers' who wilfully convert to 'bookers'.

Graph for Look/Book index

Data for Look/Book index

Dates	Weight	Min	Max	Value
23.12.2008	3	0,3	1	0,9258
30.12.2008	3	0,3	1	0,3651
06.01.2009	3	0,3	1	0,8684
13.01.2009	3	0,3	1	0,5415
20.01.2009	3	0,3	1	0,7011
27.01.2009	3	0,3	1	0,3952
03.02.2009	3	0,3	1	0,5695
10.02.2009	3	0,3	1	0,706

Internal Operations Perspective

Name

Start value

End value

Dynamic

Parent

Contains

Internal Operations Perspective

57,97 %

48,32 %

-9,65%

Travel Agency Scorecard

Indicators

Number of Booking Channels

Abroad to Local Bookings Ratio

Packaged to Independent Bookings Ratio

Green Index *

* - Information for this metric is limited in sample report Description This class of KPIs is to measure the internal environment of the organization.

Graph for Internal Operations Perspective

Data for Internal Operations Perspective

Dates	Value	Weight
23.12.2008	57,97	2
30.12.2008	41,19	2
06.01.2009	39,08	2
13.01.2009	50,06	2
20.01.2009	46,97	2
27.01.2009	37,36	2
03.02.2009	50,97	2
10.02.2009	48,32	2

Number of Booking Channels

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Number of Booking Channels	2,462	1,624	-0,838	#	Maximize	Internal Operations Perspective

Description It refers to number of booking channels through which people books their trips in the travel agency. It includes retail, online, direct, etc.

Graph for Number of Booking Channels

Data for Number of Booking Channels

Dates	Weight	Min	Max	Value
23.12.2008	2	1	3	2,462
30.12.2008	2	1	3	1,712
06.01.2009	2	1	3	1,17
13.01.2009	2	1	3	1,628
20.01.2009	2	1	3	1,806
27.01.2009	2	1	3	1,094
03.02.2009	2	1	3	2,75
10.02.2009	2	1	3	1,624

Abroad to Local Bookings Ratio

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Abroad to Local Bookings Ratio	0,7298	0,7333	+ 0,0035	#	Maximize	Internal Operations Perspective

Description It indicates the fraction of abroad bookings experienced in the travel agency as compared to the local bookings. (ratio of 40% to 60%)

Graph for Abroad to Local Bookings Ratio

Data for Abroad to Local Bookings Ratio

Dates	Weight	Min	Max	Value
23.12.2008	3	0,3	1	0,7298
30.12.2008	3	0,3	1	0,3266
06.01.2009	3	0,3	1	0,7872
13.01.2009	3	0,3	1	0,8166
20.01.2009	3	0,3	1	0,4365
27.01.2009	3	0,3	1	0,6549
03.02.2009	3	0,3	1	0,5303
10.02.2009	3	0,3	1	0,7333

Packaged to Independent Bookings Ratio

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Packaged to Independent Bookings Ratio	0,7809	0,4659	-0,315	#	Maximize	Internal Operations Perspective

Description It refers to the fraction of bookings made as Packaged as compared to Independent ones. (Ratio of 45% to 55%)

Graph for Packaged to Independent Bookings Ratio

Data for Packaged to Independent Bookings Ratio

Dates	Weight	Min	Max	Value
23.12.2008	3	0,3	1	0,7809
30.12.2008	3	0,3	1	0,9139
06.01.2009	3	0,3	1	0,4442
13.01.2009	3	0,3	1	0,6738
20.01.2009	3	0,3	1	0,8558
27.01.2009	3	0,3	1	0,6605
03.02.2009	3	0,3	1	0,4064
10.02.2009	3	0,3	1	0,4659

Business Planning and Growth Perspective

Name

Start value

End value

Dynamic

Parent

Contains

Business Planning and Growth Perspective

29,8 %

49,75 %

+ 19,95%

Travel Agency Scorecard

Indicators

Ticket delivery standards

Disaster recovery planning effectiveness

% increase in number of tour packages sold

Number of staff retention initiatives taken *

* - Information for this metric is limited in sample report Description This groups of indicators shows the planning and growth initiatives maintained and taken by the travel agency.

Graph for Business Planning and Growth Perspective

Data for Business Planning and Growth Perspective

Dates	Value	Weight
23.12.2008	29,8	2
30.12.2008	34,56	2
06.01.2009	39,44	2
13.01.2009	53,27	2
20.01.2009	35,81	2
27.01.2009	59,43	2
03.02.2009	67,43	2
10.02.2009	49,75	2

Ticket delivery standards

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Ticket delivery standards	5,626	5,905	+ 0,279	Score	Maximize	Business Planning and Growth Perspective

Description It refers to the level of delivery standards maintained by the company for providing fast, efficient and reliable service to the customers with a view to improve business reputation (on a scale of 1 to 10).

Graph for Ticket delivery standards

Data for Ticket delivery standards

Dates	Weight	Min	Max	Value
23.12.2008	3	1	10	5,626
30.12.2008	3	1	10	2,332
06.01.2009	3	1	10	3,7
13.01.2009	3	1	10	9,874
20.01.2009	3	1	10	4,933
27.01.2009	3	1	10	9,811
03.02.2009	3	1	10	3,988
10.02.2009	3	1	10	5,905

Disaster recovery planning effectiveness

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	Disaster recovery planning effectiveness	3,808	4,564	+ 0,756	Score	Maximize	Business Planning and Growth Perspective

Description It shows the effectiveness and accuracy of disaster recovery planning done by the travel agency to provide safe and reliable travelling experience to the customers (on a scale of 1 to 10).

Graph for Disaster recovery planning effectiveness

Data for Disaster recovery planning effectiveness

Dates	Weight	Min	Max	Value
23.12.2008	2	1	10	3,808
30.12.2008	2	1	10	3,124
06.01.2009	2	1	10	3,979
13.01.2009	2	1	10	7,498
20.01.2009	2	1	10	1,765
27.01.2009	2	1	10	5,05
03.02.2009	2	1	10	7,678
10.02.2009	2	1	10	4,564

% increase in number of tour packages sold

	Name	Start value	End value	Dynamic	Measure units	Optimization method	Parent
	% increase in number of tour packages sold	11,93	14,38	+ 2,45	%	Maximize	Business Planning and Growth Perspective

Description It indicates the % rise in the number of tour packages been booked by the travel agency (over the last 2 months).

Graph for % increase in number of tour packages sold

Data for % increase in number of tour packages sold

Dates	Weight	Min	Max	Value
23.12.2008	3	5	40	11,93
30.12.2008	3	5	40	34,26
06.01.2009	3	5	40	18,09
13.01.2009	3	5	40	7,345
20.01.2009	3	5	40	9,13
27.01.2009	3	5	40	17,32
03.02.2009	3	5	40	36,535
10.02.2009	3	5	40	14,38

Created by: AKS-Labs
Report created with Balanced Scorecard Designer at 15.01.2009 21:03:39