Good afternoon everyone,
I have been given this exercise to complete and the instructions seem very vague so not sure how to solve the issue they are asking. Also the way they are doing some of the calculations are straightforward but really weird and do not make sense to me. Looking at the sheet for a couple of minutes you will quickly see what I am talking about. This one makes sense but some of the others do not. For example in the Expenses sheet, Percent Available column is calculated by doing Available Budget / Budget*100. They are also hard coded.. yea I know right.. Any help would be greatly appreciated. Here are the instructions with the workbook:
In June of 2017 Public Utilities brought forward several changes that positively affect the future of Public Utilities. While one change brings savings, it will be several years until the full savings are felt. In the meantime, other changes immediately affect our revenues.
We were just informed this morning that a major water distribution main has been compromised and needs immediate replacement. The estimate replacement cost is $15 million and it is critical that the construction is complete in the next two years.
With the attached revenues and expenses, and our 5-year CIP, what is the recommended plan of action? Please provide a memo outlining your recommendations and financial charts and graphs.
Since we cannot attach docs here, this is the link to the gmail shareable excel doc, which you can paste into a normal excel workbook to use the full functionality of excel.
https://docs.google.com/spreadsheets/d/1dZLd4c0ADf47yXIbgPkVQvfUJyU92DD-ojRo4PSmNrA/edit?usp=sharing
I have been given this exercise to complete and the instructions seem very vague so not sure how to solve the issue they are asking. Also the way they are doing some of the calculations are straightforward but really weird and do not make sense to me. Looking at the sheet for a couple of minutes you will quickly see what I am talking about. This one makes sense but some of the others do not. For example in the Expenses sheet, Percent Available column is calculated by doing Available Budget / Budget*100. They are also hard coded.. yea I know right.. Any help would be greatly appreciated. Here are the instructions with the workbook:
In June of 2017 Public Utilities brought forward several changes that positively affect the future of Public Utilities. While one change brings savings, it will be several years until the full savings are felt. In the meantime, other changes immediately affect our revenues.
We were just informed this morning that a major water distribution main has been compromised and needs immediate replacement. The estimate replacement cost is $15 million and it is critical that the construction is complete in the next two years.
With the attached revenues and expenses, and our 5-year CIP, what is the recommended plan of action? Please provide a memo outlining your recommendations and financial charts and graphs.
Since we cannot attach docs here, this is the link to the gmail shareable excel doc, which you can paste into a normal excel workbook to use the full functionality of excel.
https://docs.google.com/spreadsheets/d/1dZLd4c0ADf47yXIbgPkVQvfUJyU92DD-ojRo4PSmNrA/edit?usp=sharing
