determine the annual budget for office utilities using the data from the past 12 mon 735225
Determine the annual budget for office utilities using the data from the past 12 months shown in Figure 9 7. Utility costs are expected to increase by 7% per year due to inflation. The company is planning on doubling its office space in July by expanding into some unoccupied space adjacent to its existing office space.
12/14/04 |
|
Page 1 |
||
|
EXPENSE REPORT |
|
||
From 12/1/03 to 11/30/04 |
|
|
||
Ck Num Date |
Payee |
Account |
Amount |
|
4990 |
01/07/04 |
Gas Company |
Office Utilities |
231.13 |
5004 |
01/21/04 |
Power Company |
Office Utilities |
100.35 |
5029 |
02/06/04 |
Gas Company |
Office Utilities |
291.01 |
5035 |
02/20/04 |
Power Company |
Office Utilities |
99.56 |
5036 |
03/05/04 |
Gas Company |
Office Utilities |
273.12 |
5047 |
03/19/04 |
Power Company |
Office Utilities |
105.22 |
5073 |
04/02/04 |
Gas Company |
Office Utilities |
206.65 |
5103 |
04/16/04 |
Power Company |
Office Utilities |
80.47 |
5133 |
05/08/04 |
Power Company |
Office Utilities |
86.42 |
5159 |
05/22/04 |
Gas Company |
Office Utilities |
159.23 |
5181 |
06/02/04 |
Power Company |
Office Utilities |
80.21 |
5182 |
06/16/04 |
Gas Company |
Office Utilities |
89.91 |
5204 |
07/07/04 |
Power Company |
Office Utilities |
106.06 |
5229 |
07/21/04 |
Gas Company |
Office Utilities |
71.51 |
5233 |
07/30/04 |
Gas Company |
Office Utilities |
44.73 |
5262 |
08/13/04 |
Power Company |
Office Utilities |
113.69 |
5272 |
09/02/04 |
Power Company |
Office Utilities |
98.81 |
5287 |
09/16/04 |
Gas Company |
Office Utilities |
48.72 |
5295 |
10/09/04 |
Gas Company |
Office Utilities |
54.52 |
5315 |
10/23/04 |
Power Company |
Office Utilities |
95.44 |
5323 |
10/29/04 |
Gas Company |
Office Utilities |
62.94 |
5344 |
11/12/04 |
Power Company |
Office Utilities |
77.10 |
5366 |
12/07/04 |
Gas Company |
Office Utilities |
109.23 |
5375 |
12/11/04 |
Power Company |
Office Utilities |
111.51 |
Total |
2,797.54 |