Housing Financial Workshop (August 2004)

Presenters:

Peter Hoenig	- UCB
Tracy Bennett	- UCD
Dan Les	- UCLA
Greg Wineger	- UCOP

Workshop Documents

• Agenda (pdf)

• Attendance List (pdf)

• Campus Decision Making (pdf)
• Organizational and Financial Structures (pdf)
  Contextual information on operating budgets, plant, and organizational structure for three campuses
• Rate Setting Strategies and Approvals (pdf)
  The residential rate decision making process at three campuses
• Campus Fees (pdf)
  How overhead differs at three campuses
• Budget Cycles and Formats
  Budgeting basics -- overview narrative and very detailed budget cycles and formats for one campus: worksheet structure, monthly schedules by service salary, etc.
  • UCLA - Budget Cycles and Formats (pdf)
  Overview, timeline, flowchart & detailed tools for one campus.
  • UCD - Budget Process Overview (pdf)
  • UCD - Budget Process & Timeline (pdf)
  • UCD - UCHS Financial Workshop (xls)
  • UCD - Income Distribution (pdf)

• Campus Decision Making Tools - Part 2
• Operating Reports/Statements
  Low level / detailed variance analysis and data analysis for specific operations from two campuses.
  • UCD - Housing Operating Budget (pdf)
  • UCLA - Operating Report (pdf)
• Additional detailed tools:
  • Mid Year by facility by object code (pdf)
  • Mid Year by account (pdf)
  • Mid Year by manager (pdf)
  • Monthly Occupancy by facility (pdf)
• Variance Reporting for Senior Management (high level)
• Major Maintenance
  • Overview & Flowchart (pdf)
  • UCOP high level summary (xls)
  • High level campus narrative & guidelines (pdf)
  • Campus detailed tools:
    • Monthly Account (pdf)
    • Allocation Report (pdf)
    • Monthly Lien Report (pdf)
• Project Funding and Tracking
  Campus narrative and detailed tracking reports
  UCLA - Project Funding and Tracking (pdf)
• UCOP Policies and General Information (pdf)

• Financial Performance Ratios (pdf)

• Project Planning
• Pro forma projections / feasibility analysis for new project
  • High level campus model (xls)
  • Detailed, multi function campus model by unit by rent by phase, etc. (xls)
  • UCOP multi project growth model and rate projection (xls)
• New Project Budget (xls)
• New Project Variance Report (xls)
• 10 year Business / Finance / Debt Capacity Model (xls)
  (different names on different campuses) - as submitted annually to UCOP. Allows for inclusion of multiple projects, coupled with ongoing revenues and expenses. Includes drawdown schedules.
  
• External Finance Permanent Financing Analysis (ppt)

• Budget Office Project Feasibility Analysis (ppt)
  Read in conjunction with Strategic Planning sidebar items: Business Policy -55, Housing Regent Item development, and PPG development