a0e931b1-1369-48bb-89b9-2bfb8b960ae6.xls
A B C D E
1 Income QTR 1 2011 & 2012 Averages
2
3 Dept A
4 Dept B
5 Dept C
6 Dept D
Page 1
a0e931b1-1369-48bb-89b9-2bfb8b960ae6.xls
A B C D E F G
1 Income Jan Feb March TOTAL
2
3 Dept A 14,000.00 13,000.00 17,000.00 44,000.00
4 Dept B 51,000.00 48,000.00 53,000.00 152,000.00
5 Dept C 48,000.00 26,000.00 49,000.00 123,000.00
6 Dept D 29,000.00 31,000.00 33,000.00 93,000.00
7 TOTAL 142,000.00 118,000.00 152,000.00 412,000.00
8
9 Expenses Jan Feb March TOTAL
10
11 Salary 38,000.00 38,000.00 38,000.00 114,000.00
12 Advertising 12,000.00 15,000.00 14,950.00 41,950.00
13 Utilities 9,000.00 10,000.00 11,000.00 30,000.00
14 Misc. 5,000.00 6,000.00 58,000.00 69,000.00
15 TOTAL 64,000.00 69,000.00 121,950.00 254,950.00
Page 2
a0e931b1-1369-48bb-89b9-2bfb8b960ae6.xls
H I J K
1 April May June TOTAL
2
3 14,000.00 16,000.00 15,500.00 45,500.00
4 52,000.00 55,000.00 53,500.00 160,500.00
5 48,000.00 47,950.00 48,750.00 144,700.00
6 29,000.00 28,000.00 26,000.00 83,000.00
7 143,000.00 146,950.00 143,750.00 433,700.00
8
9 April May June TOTAL
10
11 38,000.00 38,000.00 38,000.00 114,000.00
12 23,000.00 25,000.00 12,500.00 60,500.00
13 19,000.00 14,000.00 17,000.00 50,000.00
14 9,000.00 7,000.00 8,000.00 24,000.00
15 5,000.00 6,000.00 5,500.00 16,500.00
Page 3
a0e931b1-1369-48bb-89b9-2bfb8b960ae6.xls
A B C D E F G H
1 Income Jan Feb March TOTAL April
2
3 Dept A 12,000.00 12,500.00 17,000.00 41,500.00 25,000.00
4 Dept B 47,000.00 46,000.00 58,000.00 151,000.00 48,000.00
5 Dept C 51,000.00 24,000.00 45,000.00 120,000.00 29,000.00
6 Dept D 19,000.00 21,000.00 38,000.00 78,000.00 32,000.00
7 TOTAL 129,000.00 103,500.00 158,000.00 390,500.00 134,000.00
8
9 Expenses Jan Feb March TOTAL April
10
11 Salary 38,000.00 38,000.00 38,000.00 114,000.00 38,000.00
12 Advertising 12,000.00 15,000.00 14,950.00 41,950.00 15,000.00
13 Utilities 9,000.00 10,000.00 11,000.00 30,000.00 12,000.00
14 Misc. 5,000.00 6,000.00 58,000.00 69,000.00 6,000.00
15 TOTAL 64,000.00 69,000.00 121,950.00 254,950.00 71,000.00
Page 4
a0e931b1-1369-48bb-89b9-2bfb8b960ae6.xls
I J K L
1 May June TOTAL
2
3 17,000.00 25,500.00 67,500.00
4 18,500.00 52,000.00 118,500.00
5 27,000.00 28,000.00 84,000.00
6 33,000.00 34,000.00 99,000.00
7 95,500.00 139,500.00 369,000.00
8
9 May June TOTAL
10
11 38,000.00 38,000.00 114,000.00
12 17,000.00 19,000.00 51,000.00
13 11,000.00 10,500.00 33,500.00
14 7,000.00 6,500.00 19,500.00
15 73,000.00 74,000.00 218,000.00
Page 5