{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Rate Application","Description_Notes","Information","Rate Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[21,0,21,3],[24,0,24,1],[25,0,25,1],[0,0,0,4],[1,0,1,4],[3,0,3,4],[10,0,10,4],[20,0,20,4]]}
["Service Center Rate Development Worksheet"]
["University of Idaho"]
[]
["General Information:"]
[]
[]
[]
[]
[]
[]
["Sheets and purposes:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Service Center Team contact information:"]
["Please direct all email correspondence to:"]
["UI Service Center Team","osp-cost@uidaho.edu"]
["Team members and contact information:"]
["Shannon Shumard- Service Center Team Member",null,"sshumard@uidaho.edu","885-4013"]
["Bryon Cavolo - Service Center Team Member",null,"bcavolo@uidaho.edu","885-6605"]

{"sheet":"Rate Application","index":1,"n_rows":36,"n_cols":12,"rows_kept":36,"cut":false,"hidden":false,"merged":[[8,7,8,9],[35,2,35,6],[35,8,35,11],[31,6,31,7],[31,8,31,9],[31,10,31,11],[33,1,33,10],[34,1,34,2],[34,3,34,6],[34,8,34,11],[24,1,24,10],[25,1,25,11],[27,3,27,4],[13,1,13,9],[13,10,13,11],[14,1,14,9],[14,10,14,11],[15,1,15,9],[15,10,15,11],[19,1,19,4],[27,1,27,2],[16,1,16,11],[20,1,20,11],[21,1,21,11],[17,1,17,11],[10,1,10,3],[11,1,11,3],[10,4,10,6],[10,7,10,9],[10,10,10,11],[11,4,11,6],[11,7,11,9],[11,10,11,11],[1,7,1,8],[5,1,5,3],[1,1,1,2],[9,1,9,3],[3,1,3,3],[4,1,4,3],[6,1,6,3],[8,1,8,3],[3,4,3,11],[4,4,4,11],[6,4,6,11],[5,4,5,11],[9,4,9,6],[9,7,9,9],[9,10,9,11],[8,4,8,6]]}
[null,"Service Center Rate Application",null,null,null,null,null,null,null,null,null,"FY2024"]
[null,"For rates effective:",null,null,null,null,null,"Application Type:",null,null," New","Renewal"]
[]
[null,"College/Division"]
[null,"Department"]
[null,"Service Center Name"]
[null,"Service Center Location"]
[]
[null,"Contact Information:",null,null,"Name",null,null,"Email",null,null,"Phone #"]
[null,"Worksheet preparer"]
[null,"College Fiscal Contact"]
[null,"Service Center Manager"]
[]
[null,"What % of total revenue is charged to internal UI Departments (including your own)?"]
[null,"What % of the above internal revenue is charged to Sponsored Projects (\"22\" funds)?"]
[null,"What % of total revenue is charged to external (non-UI) customers? *"]
[null,"Description of the product(s) or service(s) provided:"]
[]
[]
[null,"Do competitors exist outside of the UI?",null,null,null,null,"Yes","No"]
[null,"If yes, briefly describe how the service center rates compare to market rates:"]
[]
[]
[null,"Are services provided to certain users at discounted rates or free of charge?",null,null,null,null,null,null,null,null,"Yes "," No"]
[null,"If different fees are charged, please elaborate (who do you charge more or less):"]
[]
[]
[null,"Guarantee index:"]
[null,"(to be used if annual expenses create a budget deficit > 15% of the Service Center's total annual revenue)"]
[]
[null,"New service center only:"]
[null,"Source of start-up (seed) money:",null,null,null,null,null,null,"Amount:"]
[]
[null,"Dean or Department Head Approval:"]
[null,"Name (please print):",null,null,null,null,null,"Title:"]
[null,"Signature:",null,null,null,null,null,"Date:"]

{"sheet":"Description_Notes","index":2,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":false,"merged":[[8,0,23,4],[27,0,41,4]]}
["Department Notes and Comments"]
[]
[]
[]
[]
[]
[]
["Notes about your service center"," "," "]
[" "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Comments or suggestions to help us provide better service for you:"]

{"sheet":"Information","index":3,"n_rows":28,"n_cols":10,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,6,4,9],[24,2,24,4],[25,2,25,4],[2,4,2,5],[7,5,7,9],[6,5,6,9],[26,2,26,4],[27,2,27,4],[14,2,14,4],[23,2,23,4],[4,1,4,3],[13,2,13,4],[11,2,11,4],[12,2,12,4],[9,2,9,4],[10,2,10,4]]}
["Index Information",null,null,null,null,null,null,null,null,{"$f":"'Rate Application'!L1","v":"FY2024"}]
[]
[null,"Service Center Name *",null,null,{"$f":"IF('Rate Application'!E6=0,\"Please fill in cell E6 on rate application page\",'Rate Application'!E6)","v":"Please fill in cell E6 on rate application page"},null,"Please provide your rate calculation spreadsheet to Cost Accounting for review of rates in lieu of the standard rate calculation workbook."]
[null,"Index/Fund # **"]
[null,"Operating Index Carry Forward ***",null,null,null,{"$f":"J16","v":0}]
["FUND BALANCE AND SUBSIDY INDEX INFORMATION:"]
[]
["Operating index(s):",null,null,null,null,{"$f":"\"FY\"&RIGHT('Rate Application'!L1,2)-1","v":"FY23"}]
[null,"Index/Fund Number","Index Name",null,null,"Carry Forward","Revenue","Expenditures","Transfers","Ending Balance"]
[null,null,null,null,null,0,0,0,0,{"$f":"F10+G10-H10-I10","v":0}]
[null,null,null,null,null,0,0,0,0,{"$f":"F11+G11-H11-I11","v":0}]
[null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0]
[null,null,null,null,null,0,0,0,0,0]
[null,"TOTAL OPERATING INDEX",null,null,null,{"$f":"SUM(F10:F15)","v":0},{"$f":"SUM(G10:G15)","v":0},{"$f":"SUM(H10:H15)","v":0},{"$f":"SUM(I10:I15)","v":0},{"$f":"SUM(J10:J15)","v":0}]
["Equipment replacement reserves ††"]
[null,null,null," ",null,0,null,null,0,{"$f":"F18+G18-H18-I18","v":0}]
[null,"FUND TOTAL",null,null,null,{"$f":"F18+F16","v":0},{"$f":"G18+G16","v":0},{"$f":"H18+H16","v":0},{"$f":"I18+I16","v":0},{"$f":"J18+J16","v":0}]
[]
[]
["SUBSIDY INDEX INFORMATION:"]
[null,"Index/Fund Number","Index Name"]
[]
[null," ",null," "]
[null," ",null," "]
[null," ",null," "]
[null," ",null," "]

{"sheet":"Rate Sheet","index":4,"n_rows":185,"n_cols":5,"rows_kept":185,"cut":false,"hidden":false,"merged":[[4,0,4,4],[1,0,1,4],[2,0,2,4],[3,0,3,4]]}
[]
["Service Center Billing Rates"]
[{"$f":"'Rate Application'!L1","v":"FY2024"}]
[{"$f":"'Rate Application'!E6","v":0}]
[{"$f":"Information!F4","v":0}]
[]
["Service ","Description","Unit"," Internal Rate","External Rate"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Approver's Signatures",null,null,"Date"]
[]
[]
[]
["Heather Clark, Assistant Director of Sponsored Accounting"]
[]
[]
[]
["Amanda Bauer, University Controller"]