Business Analytics Updates

Description:
- The tool was designed to help estimate a college’s potential future resources based on decisions that are made within the college and made available to Deans, Financial Planners, and Business Center Managers that oversee and manage the budget model process for the colleges.
- Each year after the final budget model is released the what-if tool will be populated with the final numbers and saved to the shared Budget & Resource Planning box folder.
Purpose:
- Allows for assumptions to be entered for 5 years. Unit leaders were looking for a future focus on budget accountability (Bus Ops Final Rpt Pg 16).
- Develop a forecasting tool (operational excellence document). Identify and design consistent tasks, forms, processes, and systems (operational excellence document).
- This tool can be used by all colleges.
Deliverables:
- What-If Tool (excel) – with FINAL FY20 Budget Model data
- What-If Tool FAQ (word) – list of frequently asked question in regard to the what-if tool.
- What-If Tool Guidance (word) – tab by tab description/walk through of the main points of the what-if tool
Teams/stakeholders involved:
- Tool was created by the Budget and Resource Planning team
- Revisions have been made via suggestions from the users.
Timeline:
- Sent to Deans, BCM’s, and Financial Planners October 2019.
- What-If tool uploaded to BRP Box folder in November 2019.
- What-if tool FAQ & Guidance uploaded to BRP Box folder in January 2020.