SALES-TARGET-TOOL-TRY

	B	C	D	E	F	G	H	I	J	K	L	M	O	P
1			Number of Students Per Employee										Breakeven Total Students	10.58
2			1	2	3	4	5	6	7	8	9	10

3
4		Course Price	35,000	35,000	35,000	35,000	35,000	35,000	35,000	35,000	35,000	35,000
5		Total Revenue Earned	105,000	210,000	315,000	420,000	525,000	630,000	735,000	840,000	945,000	1,050,000
6
7	Sales Employees	Total Number of Employees	3	3	3	3	3	3	3	3	3	3
8		Employee Base Salary	7,000	7,000	7,000	7,000	7,000	7,000	7,000	7,000	7,000	7,000
9		Commmission Rate	2.00%	3.00%	4.00%	5.00%	6.00%	7.00%	8.00%	9.00%	10.00%	11.00%
10		Commissions (Per Employee)	700	2,100	4,200	7,000	10,500	14,700	19,600	25,200	31,500	38,500
11		Total Commissions (Employees)	2,100	6,300	12,600	21,000	31,500	44,100	58,800	75,600	94,500	115,500
12		Earning Per Sales Employee	7,700	9,100	11,200	14,000	17,500	21,700	26,600	32,200	38,500	45,500
13		Total Wage Costs	23,100	27,300	33,600	42,000	52,500	65,100	79,800	96,600	115,500	136,500
14
15	Sales Supervisors	Total Number of Supervisors	1	1	1	1	1	1	1	1	1	1
16		Supervisor Base Salary	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500	7,500
17		Supervisor Commmission Rate	0.25%	0.50%	0.75%	1.25%	2.50%	3.50%	4.50%	5.50%	6.50%	7.50%
18		Commissions (Per Supervisor)	263	1,050	2,363	5,250	13,125	22,050	33,075	46,200	61,425	78,750
19		Total Commissions (Supervisors)	263	1,050	2,363	5,250	13,125	22,050	33,075	46,200	61,425	78,750
20		Earning Per Supervisor	7,763	8,550	9,863	12,750	20,625	29,550	40,575	53,700	68,925	86,250
21		Total Supervisor Wage Costs	7,763	8,550	9,863	12,750	20,625	29,550	40,575	53,700	68,925	86,250
22
23	Marketing Employees	Total Number of Marketers	2	2	2	2	2	2	2	2	2	2
24		Marketers Base Salary	7,000	7,000	7,000	7,000	7,000	7,000	7,000	7,000	7,000	7,000
25		Marketer Commmission Rate	0.25%	0.50%	0.75%	1.25%	2.50%	3.50%	4.50%	5.50%	6.50%	7.50%
26		Commissions (Per Marketer)	131	525	1,181	2,625	6,563	11,025	16,538	23,100	30,713	39,375
27		Total Commissions (All Marketer)	263	1,050	2,363	5,250	13,125	22,050	33,075	46,200	61,425	78,750
28		Earning Per Marketer	7,131	7,525	8,181	9,625	13,563	18,025	23,538	30,100	37,713	46,375
29		Total Marketer Wage Costs	14,263	15,050	16,363	19,250	27,125	36,050	47,075	60,200	75,425	92,750
30													Costs Ratio
31	Costs	Rental and Property	33,250	33,250	33,250	33,250	33,250	33,250	33,250	33,250	33,250	33,250	7.43%
32		Dynamic Operations	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	10,000	2.23%
33		Software and Technology	10,232	10,232	10,232	10,232	10,232	10,232	10,232	10,232	10,232	10,232	2.29%
34		Marketing and Advertising	85,000	85,000	85,000	85,000	85,000	85,000	85,000	85,000	85,000	85,000	18.99%
35		Managarial Employees	129,300	129,300	129,300	129,300	129,300	129,300	129,300	129,300	129,300	129,300	28.89%
36		Teachers and Instructors	38,400	38,400	38,400	38,400	38,400	38,400	38,400	38,400	38,400	38,400	8.58%
37		Sales & Marketting Wages	45,125	50,900	59,825	74,000	100,250	130,700	167,450	210,500	259,850	315,500	31.59%
38		Total Costs	351,307	357,082	366,007	380,182	406,432	436,882	473,632	516,682	566,032	621,682	100.00%
39
40	Summary	Total Expenses	351,307	357,082	366,007	380,182	406,432	436,882	473,632	516,682	566,032	621,682
41		Total Revenue	105,000	210,000	315,000	420,000	525,000	630,000	735,000	840,000	945,000	1,050,000
42		Total Income	-246,307	-147,082	-51,007	39,818	118,568	193,118	261,368	323,318	378,968	428,318
43		Total Students Per Month	3	6	9	12	15	18	21	24	27	30
44
45	Investor Dividends	Musab Yass	-91,795	-54,815	-19,010	14,840	44,189	71,972	97,408	120,496	141,236	159,628
46		Nabil Mustafa	-38,275	-22,856	-7,926	6,188	18,425	30,010	40,615	50,242	58,890	66,559
47		Abir Menaa	-17,714	-10,578	-3,668	2,864	8,527	13,889	18,797	23,252	27,255	30,804
48		Abdul Aziz Fadel	0	0	0	0	0	0	0	0	0	0
49			#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100