Spreadsheet: 251ea124-ae04-48a9-a03a-624be6774d7f
Sheet: Cost Analysis XLS Instructions

 | CELLS THAT HAVE THIS COLOR SHADING ARE AVAILABLE TO YOU TO INPUT YOUR NECESSARY DATA. THE DATA WITHIN THESE CELLS ARE PROGRAMMED TO CALCULATE VARIOUS FIGURES THAT WILL CALCULATE YOUR RATES
 | Overview of Sample Service Center Cost Analysis XLS
 | -Template Tabs used for input are numbered from 1 to 10.  Please complete the analysis in numerical order (#1-8) on the template. Tabs 9 and 10 are the computed Summary results.
 | -Tabs # 1-8 contain cells highlighted in the GREEN color can be modified to input new values without disrupting the formulas linking the various sheets.
 | -Please contact our office if you need to add rows or columns
 | -This is a sample cost analysis; keep in mind your recharge center may have different information that needs to be presented another way
 | #1_Volume by User tab ([NAME])
 | -Record your anticipated volume for each service
 | -Identify top users (both internal and external) by name and [NAME]/other volume can be lumped together on one row
 | #2_Rates tab  ([NAME])
 | - Rates are calculated by the system
 | - In the event that you want to input rates different than the system calculated, please input into each corresponding service
 | -The XLS sheet will bring the calculated cost for each service into column B
 | -If you added services, be sure to copy down the formulas so each rate is displayed
 | -Use column C to input your proposed rates to see the variance between the cost to provide the service and proposed rates
 | -FY rates will need to correspond with the cost to provide the service
 | -Important--the XLS sheet does not calculate external user rates--you will need to customize this sheet to show your methodology, including F&A rate charged to external users
 | #3_FTE per Service (Orange Tab)
 | - For each service, please input the following
 |  | (1) Name of Activity
 |  | (2) Amount of time it takes to complete this activities in total, by minutes
 |  | (3) Repeat for every type of activity
 | #4_Revenue [NAME] ([NAME])
 | - Additional Revenue sources may be included that may not be associated with an actual rate
 | -This tab multiplies the rates from Rates tab column C times the anticipated demand for each service from the Volume tab row 23 to arrive at the expected FY2012 revenue
 | -Important--the XLS sheet does not calculate revenue from external users.  It also does not show the revenue resulting from charging a premium for F&A to external users,
 | where you will need to customize this sheet to accommodate revenue from external users and corresponding F&A revenue to be remitted to the School.
 | #5_Equipment tab ([NAME])
 | -The fields highlighted in the BLUE color must be completed in order to include annual depreciation expense as a cost to your service center.
 | -Consult with the Office of Financual Analysis ([PHONE]) if you have questions about this topic
 | #6_Project Specific and #7_Non-Project Specific Costs (Red Tabs)
 | - Non Project Specific Costs Tab:  [NAME] or one time basis type costs such as Travel, Membership Fees, Special Material Charges/ Fees, large one time part repairs or replacement costs, other.
 | - Project Specific Costs Tab:  Captures Project Specific Costs (Fixed Costs) such as Equip Service Contracts, [NAME], Instrument Usage Fees, [NAME], other.
 | #8_Salaries [NAME] ([NAME])
 | - Please input the the following for each employee
 |  | (1) Full Name
 |  | (2) Employee Type, may use drop down made available to you
 |  | (3) Total annual salary from all sources
 |  | (4) Fringe Benefit Rate per Employee
 |  | (5) Percentage of effort by each individual related to the recharge center
 | System Calculated Tabs ([NAME]) - displays analyses results only and has no user imput data cells.
 | #9_Fixed & Var Cost Allocation
 | #10_Statement of Activities
 | Office of Financial Analysis is here to assist you with your FY2012 Cost Analysis.  Please contact any of the following individuals for assistance, questions, or concerns:
 | Andres A Chan |  |  |  |  |  |  | Other Resources:
 | email: | [EMAIL] |  |  |  |  |  | OFA Website
 |  |  |  |  |  |  |  | http://www.ofa.usc.edu
 | [NAME] |  |  |  |  |  |  | Department [NAME]
 | email: | [EMAIL] |  |  |  |  |  | [EMAIL]
 |  |  |  |  |  |  |  | Department Phone Number
 | [NAME] |  |  |  |  |  |  | [PHONE]
 | email: | [EMAIL]
 |  |  |  |  |  |  |  | Department Phone Number
 | Pam Townsend |  |  |  |  |  |  | [PHONE]
 | email: | [EMAIL]