...
Research Space Utilization Report displays the state of space utilization as available in the IFIS system and expenditures analysis for the selected department(s). The report contains three different views (presented as report tabs): Space, Building and Summary. The Space view provides a view of the space utilization and expenditures (Direct, F&A and Total) for every employee associated with the selected department(s). The Building view displays the Research Space Utilization Indicators as a Percentage of the Total Occupied Research Sq. Ft on each floor, as well as, summary data of space, it's functions, and research expenditures for every space associated with the given building and floor level for the selected department(s). The Summary view shows the space utilization and expenditures data for the selected department(s) per employee.
| Note |
|---|
Research expenditures are pulled from the previous FY and paired with space allocation from the current FY so there is a full year's worth of expenditures for calculation. |
Prompts
AIMS Faculty Prompts
...
| Warning |
|---|
| Report will not work correctly if you choose different departments for the Global Department prompts. If you are running the report for a specific faculty member(s), you will need to select their primary department in subsequent Global Department prompts. |
Space
| Insert excerpt |
|---|
| Primary Department - Space |
|---|
| Primary Department - Space |
|---|
| nopanel | true |
|---|
|
Currently Occupied Currently Occupied | Employee Name - Space |
|---|
| nopanel | true |
|---|
|
This block displays only Research designated square footage. The green section is based on room type of Research Labs, while the blue section is based on Research Room Function.
Data Last Refreshed | Research Square Feet - Space |
|---|
|
Data Last Refreshed | Research Square Feet - Space |
|---|
| nopanel | true |
|---|
|
Direct Research Expenditures
Direct Research Expenditures - Space | | Expenditures per Square Foot - Research Lab - Space | | Expenditures per Square Foot - Research Lab - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Research Square Feet Adjusted - Space |
|---|
| Research Square Feet Adjusted - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Expenditures per Research Square Foot Adjusted - Space |
|---|
| Expenditures per Research Square Foot Adjusted - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Direct Research Expenditures - Space |
|---|
| Direct Research Expenditures - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| F&A Expenditures - Space |
|---|
| F&A Expenditures - Space |
|---|
| nopanel | true |
|---|
|
Included As Research Sq Feet Adj? Y/N
Included As Research Sq Feet Adj? Y/N - Space | | Total Expenditures (Direct and F&A) - Space | | Total Expenditures (Direct and F&A) - Space |
|---|
| nopanel | true |
|---|
|
Building Table
This block displays all square footage assigned to the faculty member.
Net Square Feet Net Square Feet | Building - Space |
|---|
| nopanel | true |
|---|
|
Net Square Feet Adjusted by Function % Net Square Feet Adjusted by Function % | Room Location - Space |
|---|
| nopanel | true |
|---|
|
Primary Department Primary Department | Room Type - Space |
|---|
| nopanel | true |
|---|
|
Project ID Project ID | Net Square Feet - Space |
|---|
| nopanel | true |
|---|
|
Research Square Feet | Currently Occupied - Space |
|---|
|
Research Square Feet | Currently Occupied - Space |
|---|
| nopanel | true |
|---|
|
Research Square Feet Adjusted Research Square Feet Adjusted | Room Function - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Room Function % - Space |
|---|
| Room Function % - Space |
|---|
| nopanel | true |
|---|
|
Room | Net Square Feet Adjusted by Function % - Space |
|---|
|
Room | Net Square Feet Adjusted by Function % - Space |
|---|
| nopanel | true |
|---|
|
Room Location | Included As Research Sq Feet Adj? Y/N - Space |
|---|
|
Room Location | Included As Research Sq Feet Adj? Y/N - Space |
|---|
| nopanel | true |
|---|
|
Project Table
This block displays all projects from FAST where the employee is the PI.
Room Type Room Type | Project ID - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Total Expenditures (Direct and F&A) - Space |
|---|
| Total Expenditures (Direct and F&A) - Space |
|---|
| nopanel | true |
|---|
|
| Insert excerpt |
|---|
| Data Last Refreshed - Space |
|---|
| Data Last Refreshed - Space |
|---|
| nopanel | true |
|---|
|
Building
| Insert excerpt |
|---|
| Data Last Refreshed - Space |
|---|
| Data Last Refreshed - Space |
|---|
| nopanel | true |
|---|
|
...
| Insert excerpt |
|---|
| Total FYXX Research Square Feet Adjusted - Space |
|---|
| Total FYXX Research Square Feet Adjusted - Space |
|---|
| nopanel | true |
|---|
|
Research Space Utilization Indicators
Color coding is applied as displayed in the table above:
Dark Green: Expenditures Per Occupied Research Square Feet > $500
Green: Expenditures Per Occupied Research Square Feet between $200 and $500
Yellow: Expenditures Per Occupied Research Square Feet between $100 and $199
Pink: Expenditures Per Occupied Research Square Feet less than $100 and Employee Hire Date < 30 Months
Red: Expenditures Per Occupied Research Square Feet less than $100
Summary
| Insert excerpt |
|---|
| Data Last Refreshed - Space |
|---|
| Data Last Refreshed - Space |
|---|
| nopanel | true |
|---|
|
...