Capstone Papers-Analyze HVAC expense for the current fiscal year
Analyze HVAC expense for the current fiscal year as well as the year prior, and make a budget projection for the upcoming year. Review the budget data in the attached spreadsheet to make your projection. In addition to the spreadsheet, there is an HVAC preventative maintenance contract at a cost of $10,000 annually.
Write an email explaining and supporting the budget number you are recommending in 500 words or less. Include your analysis in an Excel document attached to your email illustrating how you arrived at your projection. The fiscal year is 7/1-6/30. FY19 will start on 7/1/2018 with your projected HVAC figure.