Reviewing budget summary

Overview

The Summary sheet provides an overview of the entire budget. Before making revisions, review the Summary tab to get a sense of where the budget currently stands. After completing revisions, return to the Summary sheet to see how the figures have changed. This sheet is also useful when submitting a budget plan file for leadership review.

This sheet includes data from two sources:

• Base Budget – Summary of inputs on Stat_Rev and Expense tabs based on KHASum (set in column U in the ACCT dimension table).
• New Initiatives – Incremental volumes, revenue, FTEs, and expenses for approved new initiatives. It does not include data from unapproved initiatives.

This tab includes the following sections:

The Financial Summary section displays totals from the other tabs, along with the contribution margin. The Analysis sections consist of Statistical Analysis and Hours Analysis, and features calculated metrics to help gauge the reasonableness of a submitted budget.