الميزانية

costchart

التاريخ: غير معروف
الفئة: الميزانية
النص متوفر: الإنكليزية
عدد الملفات: 1

الأصل الإنكليزي XLS تنزيل النص الإنكليزي

معاينة الجدول

الورقة «Sheet1»: 57 صفاً × 10 أعمدة

COST PROJECTIONS FOR PROPOSED SALARY STRUCTURE


Costing based on Salary Guidelines					Costing based on CPA percentages
(assumes some grade inflation)

			estimated	estimated
			cost at	cost at			estimated
	number of	percent of	salary	top of range		number of	average	total
	employees	employees	targets	progression		employees	salary	cost (000)


Council	24	0.00	576	576	Council			576
A	600	0.00	10,800	10,800	A			10,800
B	2,000	0.00	24,000	24,000	B			24,000

1	12,973.76	0.01	83,032	95,487	top 1%	12,973.76	6,125	79,464
2	38,921.28	0.03	193,050	222,007
3	77,842.56	0.06	298,915	343,753	next 9%	116,763.84	4,000	467,055
4	129,737.60	0.10	384,023	441,627
5	194,606.40	0.15	443,703	510,258	middle 30%	389,212.80	2,400	934,111
6	194,606.40	0.15	342,507	393,883
7	194,606.40	0.15	264,665	304,364	bottom 60%	778,425.60	1,100	856,268
8	129,737.60	0.10	140,117	161,134
9	129,737.60	0.10	114,169	131,294	Total estimated cost: US dollars:			2,372,274
10	129,737.60	0.10	93,411	107,423
11	64,868.80	0.05	38,921	44,759

	1,300,000	1	2,396,513	2,755,990







								576,000
								10,800,000
								24,000,000

			576,000	576,000				79,464,280
			10,800,000	10,800,000
			24,000,000	24,000,000				467,055,360

			83,032,064	95,486,873.60				934,110,720
			193,049,548.80	222,006,981.12
			298,915,430.40	343,752,744.96				778,425,600
			384,023,296	441,626,790.40
			443,702,592	510,257,980.80				2,294,431,960
			342,507,264	393,883,353.60
			264,664,704	304,364,409.60
			140,116,608	161,134,099.20
			114,169,088	131,294,451.20
			93,411,072	107,422,732.80
			38,921,280	44,759,472

			2,396,512,947.20	2,755,989,889.28

# Sheet1 COST PROJECTIONS FOR PROPOSED SALARY STRUCTURE Costing based on Salary Guidelines Costing based on CPA percentages (assumes some grade inflation) estimated estimated cost at cost at estimated number of percent of salary top of range number of average total employees employees targets progression employees salary cost (000) Council 24 0.0 576 576 Council 576 A 600 0.0005 10800 10800 A 10800 B 2000 0.0015 24000 24000 B 24000 1 12973.76 0.01 83032 95487 top 1% 12973.76 6125 79464 2 38921.28 0.0299 193050 222007 3 77842.56 0.0599 298915 343753 next 9% 116763.84 4000 467055 4 129737.6 0.0998 384023 441627 5 194606.4 0.1497 443703 510258 middle 30% 389212.8 2400 934111 6 194606.4 0.1497 342507 393883 7 194606.4 0.1497 264665 304364 bottom 60% 778425.6 1100 856268 8 129737.6 0.0998 140117 161134 9 129737.6 0.0998 114169 131294 Total estimated cost: US dollars: 2372274 10 129737.6 0.0998 93411 107423 11 64868.8 0.0499 38921 44759 1300000 1 2396513 2755990 576000 10800000 24000000 576000 576000 79464280 10800000 10800000 24000000 24000000 467055360 83032064 95486873.6 934110720 193049548.8 222006981.12 298915430.4 343752744.96 778425600 384023296 441626790.4 443702592 510257980.8 2294431960 342507264 393883353.6 264664704 304364409.6 140116608 161134099.2 114169088 131294451.2 93411072 107422732.8 38921280 44759472 2396512947.2 2755989889.28 # Sheet2 # Sheet3