Determine the annual budget for office utilities the data from the past 12 months shown in Figure 9-7. Utility costs are expected to increase by 8% per year due to inflation. None of the company’s goals are expected to affect the utility costs. 

Figure 9-7

 

From 12/1/17 to 11/30/18 Ck Num 4990 5004 5029 5035 5035 5047 5073 5103 5133 5159 5181 5182 5204 5229 5233 5262 5272 5287 5295 5315 5323 5344 5366 5375 Date 01/07/18 01/21/18 02/06/18 02/20/18 03/05/18 03/19/18 04/02/18 04/16/18 05/08/18 05/22/18 06/02/18 06/16/18 07/07/18 07/21/18 07/30/18 08/13/18 09/02/18 09/16/18 10/09/18 10/23/18 10/29/18 11/12/18 12/07/18 EXPENCE REPORT Payee Gas Company Power Company Gas Company Power Company Gas Company Power Company Gas Company Power Company Power Company Gas Company Power Company Gas Company Power Company Gas Company Gas Company Power Company Power Company Gas Company Gas Company Power Company Gas Company Power Company Gas Company 12/11/18 Power Company Account Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Office Utilities Amount 231.13 100.35 291.01 99.56 273.12 105.22 206.65 80.47 86.42 159.23 80.21 89.91 106.06 71.51 44.73 113.69 98.81 48.72 54.52 95.44 62.94 77.10 109.23 111.51