1. Populate the Service Detail tab in the rate calculation template with the data on the Summary tab of the EDDIE Rate Calculation Financial Report.
   1. Service Activity Fund code and title
   2. Chart of Account
   3. College code
   4. Department code
   5. Base Fiscal Year
2. Complete the Service Activity Fund Details & Description section.
   1. Enter information about the Service Activity Fund, answer the questions, and provide a brief description of operations and services provided.
3. Attach the Mobius View Financial Statement.
   1. Run the Mobius View Financial Statement for period 14 of the base fiscal year.
   2. Include a screenshot in the Mobius View Financial Statement section.
   3. Visit the job aid Using Mobius View.

1. Populate the full supporting Usage Base Detail data on the Base Detail tab.
   1. NOTE: This detail is not available in Banner and therefore not on the Rate Calculation Financial Report. It must be obtained from the Service Manager.
   2. Compile the usage-based data into totals by line of service.
2. Populate the Base tab - Usage Base Summary and Lines of Service sections.
   1. Complete the Detail information for all Lines of Service columns: Activity/Program Code, Lines of Service/Product Descriptions, and Units of Measure.
   2. Enter the total usage base for each line of service in the Total Usage Base in Base Year column. (These amounts must be supported by the data on the Base Detail tab.)
3. If applicable, adjust for any errors or non-billable units in the Adjustments, Corrections, and Projections field.
   1. These may include maintenance, downtime, failed tests, etc.
   2. Any base projected changes must be supported by proper documentation.

1. Populate the Revenue Detail tab.
   1. Copy the revenue data from the “Revenue Detail” tab of the EDDIE Rate Calculation Financial Report and paste it into the corresponding “Revenue Detail” tab of the Rate Calculation Template.
2. Populate the Revenue tab.
   1. Copy the data from the Revenue tab of the EDDIE Rate Calculation Financial Report and paste it into the corresponding Revenue tab of the Rate Calculation Template workbook.
      1. Include columns: Revenue Account Code, Revenue Account Title, and Total Banner Revenue in Base.
      2. Do not include the header or totals rows.
      3. Add rows as needed by right-clicking the row number and selecting Insert.
3. Record any revenue posted to 307921 in the cell next to Revenue Posted to 307921.
   1. This amount is used in the Fund Balance tab as a Fund Balance Adjustment.

1. Populate Exp Detail tab.
   1. Copy the expenditures data from the Exp Detail tab of the EDDIE Rate Calculation Financial Report and paste it into the corresponding Exp Detail tab of the Rate Calculation Template.
2. Populate the Exp Detail tab.
   1. Copy the data from the Exp tab of the EDDIE Rate Calculation Financial Report into the corresponding sections of the Exp tab of the Rate Calculation Template.
   2. Include columns: Account Code, Expenditure Description, and Total Expenditures.
      1. Do not include the header or totals rows.
      2. Add rows as needed by right-clicking the row number and selecting Insert.
3. Populate the 3E Expenditures section with the 1xxxxx level account codes data.
4. Populate the Personnel Expenditures section with the 21xxxx level account codes data.
5. Populate the Transfers section with the 415xxx level account codes data.

1. Populate the Salaries Detail tab.
   1. Copy the Salaries and Wages data from the “Salaries Detail” tab of the EDDIE Rate Calculation Financial Report and paste it into the corresponding Salaries Detail tab on the Rate Calculation Template.
2. Populate the Salaries tab - 3E Salaries section.
   1. Copy the data from the Salaries tab of the EDDIE Rate Calculation Financial Report and paste it into the 3E Salaries section of the Salaries tab on the Rate Calculation Template.
      1. Include columns: Personnel Name, Title, UIN, Base Year 3E Salaries Total.
      2. Do not include the header or totals rows.
      3. Add rows as needed by right-clicking the row number and selecting Insert.

NOTE: The depreciation tabs of the EDDIE Rate Calculation Financial Report return all equipment for the Org code in Banner (Equip by Org, 3E Equip, Non-3E Equip).

1. Populate the Equip Detail tab - 3E Equipment section.
   1. Copy the data from the 3E Equip tab of the EDDIE Rate Calculation Financial Report and paste it into the Equip Detail tab - 3E Equipment section of the Rate Calculation Template.
   2. Include only 3E equipment related to the service activity, which can be identified using the Fund Src Fin Fund Code, matching the service activity fund code.
      1. Verify with the service activity fund manager that the equipment is not used by another service activity.
      2. Add rows as needed by right-clicking the row number and selecting Insert.
2. Populate the Equip Detail tab - Non-3E Equipment - Internal Rates section.
   1. Copy the data from the Non-3E Equip tab of the EDDIE Rate Calculation Financial Report and paste it into the Equip Detail tab - Non-3E Equipment – Internal Rates section of the Rate Calculation Template.
   2. Include only non-3E equipment related to the service activity, which can be identified using the Fund Attribute Value (FAV) matching the service activity fund code.
   3. NOTE: A list of any non-3E equipment that is used in the service activity without a FAV should be compiled and sent to UAFR Property Accounting to update the FAV fields.
      1. If the FAV field is blank, verify with the service activity fund manager what equipment is used in the service activity.
      2. Verify with the service activity fund manager that the equipment is not used by another service activity.
      3. Add rows as needed by right-clicking the row number and selecting Insert.
3. Verify Allowability of non-3E equipment for internal rates in the Equip Detail tab - Non-3E Equipment – Internal Rates section.
   1. Verify that the Equipment Fund Type code is allowable for internal rates. Refer to the Equipment Fund Type Allowability table at the bottom of the Equip Detail tab.
   2. Verify that each piece of equipment has a “3100” or “3110” Entity code listed in the Entities Attribute Value field.
   3. NOTE: Any equipment that is not entity coded or was purchased using an unallowable fund type cannot be included in internal rates and must be removed from the Non-3E Equipment – Internal Rates section of the Equip Detail tab.
   4. Unallowable equipment for internal rates may be included in the Non-3E Equipment – External Rates Only section if it meets the requirements in the Equipment Fund Type Allowability table for external rates.
4. Populate the Equip tab with the equipment listed in the Equip Detail tab.
   1. Populate the sections 3E Equipment, Non-3E Equipment, Projected Equipment, and EXTERNAL – Equipment Depreciation Summary for External Rates Only by copying the data from the respective sections on the Equip Detail tab.
   2. Include columns: Ptag Number, Equipment Description, and Base Year Depreciation Expense.
      1. Add rows as needed by right-clicking the row number and selecting Insert.
   3. Include any exclusions in the Depreciation Exclusions column with negative values.

NOTE: Banner records a positive fund balance as a deficit, and a negative fund balance as a surplus. All columns labeled as “Fund Balance” or “Over/Under Recovery” must be consistent with this convention

1. Populate the Fund Balance tab.
   1. Copy the Fund Balance data from the Fund Balance tab of the EDDIE Rate Calculation Financial Report and paste it into the Fund Balance for Base Year section of the Fund Balance tab on the Rate Calculation template.
      1. Do not include the header or totals rows.
      2. Add rows as needed by right-clicking the row number and selecting Insert.
2. Copy the Fund Balance total to the End of Year Fund Balance.