Portfolio Planning and Projections (P3) Overview
P3 is a tool for primary investigators and research administrators to review the current status of their grants, gifts, projects, and programs, and plan for the future through fiscal projections.
P3 is still under initial development and has not been made available to users. SMPH employees can get a preview of the functionality at https://qa-cheetah.med.wisc.edu/. This is an environment for testing - it is not for doing actual work. You need to be logged into VPN or on the SMPH network to access the application. The data you see originates in Workday. Periodically we will need to clear the database, so things that you enter during testing will be cleared periodically.
Implemented Functionality
-
You can view a dashboard with bookmarked PIs, cost centers, and grants.
- You can search for grants, awards, PIs, and employees on grants.
- You can view award details, including name, description, PI, status, and dates.
- You can view award budget and grants under that award.
- You can view grant details, including name, worktag ID, legacy project ID, dates, PI, driver manager, sponsor, default cost center and fund, type, basis type, and F&A rate.
- You can view summary grant financials, including budget, expenses in last-closed month, total expenses through last-closed month, projected expenses, and projected balance.
- You can view categorized expenses with projections and projected balance.
- You can view costing allocations with projections.
- You can enter hypothetical expense adjustments.
- You can enter hypothetical costing allocations for "fictional" staff.
- You can view employee allocations on grants.
Recent Updates
- Simplified entry of allocation adjustments.
Future Work
- Launching P3 for SMPH employees.
- Viewing gift, project, and program information.