{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","General Information","Rate Calculation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,0,2,5],[0,0,0,8],[2,6,2,10],[11,0,11,5],[11,6,11,10],[5,0,5,5],[5,6,5,10],[8,0,8,5],[8,6,8,10],[9,0,9,10]]}
["Billing Rate Development Instructions"]
[]
["Purpose:"]
["To determine billing rate calculations for Recharge (21) accounts as well as General Operation (22) accounts.  "]
[]
["Preparation:"]
["Complete all required cells shaded yellow",null,null,null,null,"Required Cells"]
[]
["Submission:"]
["Complete the General Information tab as well as the Rate Calculation tab and email to your department's Campus Services Representative.  "]
[]
["Additional Documentation:"]
["Additional items to include at the time of submission:"]
[]
["Recharge (21) account submissions:"]
["1.)  Business Plan (if updates occurred)"]
["2.)  21 Fund Budget Request Form (if billing rates updated or  a new recharge account is being requested)"]
["3.)  3 Year Projection (only in cases where a new recharge account is being requested)"]
[]
["General Operations (22) account submissions:"]
["1.)  Business Plan (if updates occurred)"]
["2.)  22 Fund Budget Request Form (if billing rates updated or a new general operations account is being requested)"]
["3.)  3 Year Projection (only in cases where a new general operations account is being requested)"]
["4.)  Competition Analysis "]
["5.)  Unrelated Business Income Tax (UBIT) Questionnaire - contact BFS_Tax_Accounting@Mail.ColoState.edu to complete"]
[]
[]
["***For questions regarding the completion or submission of this information contact bfs_campus-services@mail.colostate.edu"]

{"sheet":"General Information","index":1,"n_rows":26,"n_cols":5,"rows_kept":26,"cut":false,"hidden":false,"merged":[[16,0,16,5],[19,0,19,5],[0,0,0,6],[2,0,2,5],[6,0,6,5],[12,0,12,5],[13,0,13,6],[14,0,14,6]]}
["General Information"]
[]
["Department Information:"]
["Department Name:"]
["Department Number:"]
[]
["Account Information Information:"]
["Account Status:"]
[]
["Account Number:"]
["Account Name:"]
[]
["Goods or Services Provided:"]
["Please provide a short description of the goods and/or services provided.  Are similar goods/services available elsewhere at Colorado State University?"]
[]
[]
["Deficits:"]
["Please designate a CSU account to cover prolonged deficits:"]
[]
["Contact Information:"]
["Fiscal Officer Name:"]
["Fiscal Officer Phone Number:"]
[]
["Rate Description"]
["Enter the names of the products and/or services offered"]
[null,null,"Item/Service #","Item/Service Name","Unit of Sale (hourly, rate per sample, etc.)"]

{"sheet":"Rate Calculation","index":2,"n_rows":78,"n_cols":23,"rows_kept":78,"cut":false,"hidden":false,"merged":[[0,0,0,6]]}
["Billing Rate Development Worksheet"]
[]
["•Complete all required cells shaded yellow "]
["•Update descriptions of service/product offered"]
["•Input additional rows and/or columns if needed"]
[]
[null,null,null,"Enter Service/Product 1 Description and Amounts",null,null,null,null,null,"Enter Service/Product 2 Description and Amounts",null,null,null,null,null,"Enter Service/Product 3 Description and Amounts"]
[]
["Description",null,"Employee Annual Labor and Applicable Fringe Amount","Yearly Amount for Service/Product","Labor Allocation %","Annual Total","Monthly Total",null,"Employee Annual Labor and Applicable Fringe Amount","Yearly Amount for Service/Product","Labor Allocation %","Annual Total","Monthly Total",null,"Employee Annual Labor and Applicable Fringe Amount","Yearly Amount for Service/Product","Labor Allocation %","Annual Total","Monthly Total",null,"Annual Overall Account \nTotals","Monthly Overall Account \nTotals"]
[]
["Salary:"]
["(Position 1)",null,null,{"$f":"ROUND(C12*E12,2)","v":0},null,{"$f":"D12","v":0},{"$f":"F12/12","v":0},null,null,{"$f":"ROUND(I12*K12,2)","v":0},null,{"$f":"J12","v":0},{"$f":"L12/12","v":0},null,null,{"$f":"ROUND(O12*Q12,2)","v":0},null,{"$f":"P12","v":0},{"$f":"R12/12","v":0},null,{"$f":"+F12+L12+R12","v":0},{"$f":"+G12+M12+S12","v":0}]
["(Position 2)",null,null,{"$f":"ROUND(C13*E13,2)","v":0},null,{"$f":"D13","v":0},{"$f":"F13/12","v":0},null,null,{"$f":"ROUND(I13*K13,2)","v":0},null,{"$f":"J13","v":0},{"$f":"L13/12","v":0},null,null,{"$f":"ROUND(O13*Q13,2)","v":0},null,{"$f":"P13","v":0},{"$f":"R13/12","v":0},null,0,0]
["(Position 3)",null,null,0,null,0,0,null,null,0,null,0,{"$f":"L14/12","v":0},null,null,0,null,0,{"$f":"R14/12","v":0},null,0,0]
["(Position 4)",null,null,0,null,0,0,null,null,0,null,0,{"$f":"L15/12","v":0},null,null,0,null,0,{"$f":"R15/12","v":0},null,0,0]
["Salary Subtotal",null,null,null,null,{"$f":"SUM(F12:F15)","v":0},{"$f":"SUM(G12:G15)","v":0},null,null,null,null,{"$f":"SUM(L12:L15)","v":0},{"$f":"SUM(M12:M15)","v":0},null,null,null,null,{"$f":"SUM(R12:R15)","v":0},{"$f":"SUM(S12:S15)","v":0},null,{"$f":"SUM(U12:U15)","v":0},{"$f":"SUM(V12:V15)","v":0}]
[]
["Supplies:"]
["(Supply 1)",null,null,null,null,{"$f":"D19","v":0},{"$f":"F19/12","v":0},null,null,null,null,{"$f":"J19","v":0},{"$f":"L19/12","v":0},null,null,null,null,{"$f":"P19","v":0},{"$f":"R19/12","v":0},null,{"$f":"+F19+L19+R19","v":0},0]
["(Supply 2)",null,null,null,null,{"$f":"D20","v":0},{"$f":"F20/12","v":0},null,null,null,null,{"$f":"J20","v":0},{"$f":"L20/12","v":0},null,null,null,null,{"$f":"P20","v":0},{"$f":"R20/12","v":0},null,0,0]
["(Supply 3)",null,null,null,null,0,0,null,null,null,null,0,{"$f":"L21/12","v":0},null,null,null,null,0,{"$f":"R21/12","v":0},null,0,0]
["(Supply 4)",null,null,null,null,0,0,null,null,null,null,0,{"$f":"L22/12","v":0},null,null,null,null,0,{"$f":"R22/12","v":0},null,0,0]
["Supplies Subtotal",null,null,null,null,{"$f":"SUM(F19:F22)","v":0},{"$f":"SUM(G19:G22)","v":0},null,null,null,null,{"$f":"SUM(L19:L22)","v":0},{"$f":"SUM(M19:M22)","v":0},null,null,null,null,{"$f":"SUM(R19:R22)","v":0},{"$f":"SUM(S19:S22)","v":0},null,{"$f":"SUM(U19:U22)","v":0},{"$f":"SUM(V19:V22)","v":0}]
[]
["Services:"]
["(Service 1)",null,null,null,null,{"$f":"D26","v":0},{"$f":"F26/12","v":0},null,null,null,null,{"$f":"J26","v":0},{"$f":"L26/12","v":0},null,null,null,null,{"$f":"P26","v":0},{"$f":"R26/12","v":0},null,{"$f":"+F26+L26+R26","v":0},0]
["(Service 2)",null,null,null,null,{"$f":"D27","v":0},{"$f":"F27/12","v":0},null,null,null,null,{"$f":"J27","v":0},{"$f":"L27/12","v":0},null,null,null,null,{"$f":"P27","v":0},{"$f":"R27/12","v":0},null,0,0]
["(Service 3)",null,null,null,null,0,0,null,null,null,null,0,{"$f":"L28/12","v":0},null,null,null,null,0,{"$f":"R28/12","v":0},null,0,0]
["(Service 4)",null,null,null,null,{"$f":"D29","v":0},0,null,null,null,null,{"$f":"J29","v":0},{"$f":"L29/12","v":0},null,null,null,null,{"$f":"P29","v":0},{"$f":"R29/12","v":0},null,0,0]
["Services Subtotal",null,null,null,null,{"$f":"SUM(F26:F29)","v":0},{"$f":"SUM(G26:G29)","v":0},null,null,null,null,{"$f":"SUM(L26:L29)","v":0},{"$f":"SUM(M26:M29)","v":0},null,null,null,null,{"$f":"SUM(R26:R29)","v":0},{"$f":"SUM(S26:S29)","v":0},null,{"$f":"SUM(U26:U29)","v":0},{"$f":"SUM(V26:V29)","v":0}]
[]
["Depreciation/Recharge:"]
["(Item 1)",null,null,null,null,{"$f":"D33","v":0},{"$f":"F33/12","v":0},null,null,null,null,{"$f":"J33","v":0},{"$f":"L33/12","v":0},null,null,null,null,{"$f":"P33","v":0},{"$f":"R33/12","v":0},null,{"$f":"+F33+L33+R33","v":0},0]
["(Item 2)",null,null,null,null,{"$f":"D34","v":0},{"$f":"F34/12","v":0},null,null,null,null,{"$f":"J34","v":0},{"$f":"L34/12","v":0},null,null,null,null,{"$f":"P34","v":0},{"$f":"R34/12","v":0},null,0,0]
["(Item 3)",null,null,null,null,{"$f":"D35","v":0},0,null,null,null,null,{"$f":"J35","v":0},{"$f":"L35/12","v":0},null,null,null,null,{"$f":"P35","v":0},{"$f":"R35/12","v":0},null,0,0]
["(Item 4)",null,null,null,null,{"$f":"D36","v":0},0,null,null,null,null,{"$f":"J36","v":0},{"$f":"L36/12","v":0},null,null,null,null,{"$f":"P36","v":0},{"$f":"R36/12","v":0},null,0,0]
["Depreciation/Recharge Subtotal",null,null,null,null,{"$f":"SUM(F33:F36)","v":0},{"$f":"SUM(G33:G36)","v":0},null,null,null,null,{"$f":"SUM(L33:L36)","v":0},{"$f":"SUM(M33:M36)","v":0},null,null,null,null,{"$f":"SUM(R33:R36)","v":0},{"$f":"SUM(S33:S36)","v":0},null,{"$f":"SUM(U33:U36)","v":0},{"$f":"SUM(V33:V36)","v":0}]
[]
["Total Cost ",null,null,null,null,{"$f":"F16+F23+F30+F37","v":0},{"$f":"G16+G23+G30+G37","v":0},null,null,null,null,{"$f":"L16+L23+L30+L37","v":0},{"$f":"M16+M23+M30+M37","v":0},null,null,null,null,{"$f":"R16+R23+R30+R37","v":0},{"$f":"S16+S23+S30+S37","v":0},null,{"$f":"+F39+L39+R39","v":0},0]
["Subsidy (for 21 accounts only)",null,null,null,null,{"$f":"+D40","v":0},{"$f":"+D40/12","v":0},null,null,null,null,{"$f":"+J40","v":0},{"$f":"+J40/12","v":0},null,null,null,null,{"$f":"+P40","v":0},{"$f":"+P40/12","v":0},null,0,0]
["Total Cost for Service/Product after Subsidy but Prior to External G&A Fee.  See Below External Section for G&A Fee.",null,null,null,null,{"$f":"F39-F40","v":0},{"$f":"G39-G40","v":0},null,null,null,null,{"$f":"L39-L40","v":0},{"$f":"M39-M40","v":0},null,null,null,null,{"$f":"R39-R40","v":0},{"$f":"S39-S40","v":0},null,0,{"$f":"+G41+M41+S41","v":0}]
[]
["Total Internal Revenue for Service/Product after Subsidy",null,null,null,null,{"$f":"IF(D56=0,\"0.00\",F61*D56)","v":"0.00"},{"$f":"IF(D56=0,\"0.00\",F43/12)","v":"0.00"},null,null,null,null,{"$f":"IF(J56=0,\"0.00\",L61*J56)","v":"0.00"},{"$f":"IF(J56=0,\"0.00\",L43/12)","v":"0.00"},null,null,null,null,{"$f":"IF(P56=0,\"0.00\",R61*P56)","v":"0.00"},{"$f":"IF(P56=0,\"0.00\",R43/12)","v":"0.00"},null,{"$f":"F43+L43+R43","v":0},{"$f":"U43/12","v":0}]
["Yearly Internal Surplus/(Deficit)",null,null,null,null,{"$f":"IF(D56=0,\"0.00\",+F43-F41)","v":"0.00"},{"$f":"IF(D56=0,\"0.00\",F44/12)","v":"0.00"},null,null,null,null,{"$f":"IF(J56=0,\"0.00\",+L43-L41)","v":"0.00"},{"$f":"IF(J56=0,\"0.00\",L44/12)","v":"0.00"},null,null,null,null,{"$f":"IF(P56=0,\"0.00\",+R43-R41)","v":"0.00"},{"$f":"IF(P56=0,\"0.00\",R44/12)","v":"0.00"},null,{"$f":"IF(D43=0,\"0.00\",+U43-U41)","v":"0.00"},{"$f":"U44/12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B58+U44","v":0},{"$f":"U45/12","v":0},"Projected Internal Account Fund Balance (as of June 30, 2022)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B59+U44","v":0},{"$f":"U46/12","v":0},"Projected Internal Account Cash Balance (as of June 30, 2022)"]
[]
["Total External Revenue for Service/Project",null,null,null,null,{"$f":"IF(D65=0,\"0.00\",D65*F73)","v":"0.00"},{"$f":"IF(D65=0,\"0.00\",F48/12)","v":"0.00"},null,null,null,null,{"$f":"IF(J65=0,\"0.00\",J65*L73)","v":"0.00"},{"$f":"IF(J65=0,\"0.00\",L48/12)","v":"0.00"},null,null,null,null,{"$f":"IF(P65=0,\"0.00\",P65*R73)","v":"0.00"},{"$f":"IF(P65=0,\"0.00\",R48/12)","v":"0.00"},null,{"$f":"F48+L48+R48","v":0},{"$f":"U48/12","v":0}]
["External G&A Fee",null,null,null,null,{"$f":"IF(D65=0,\"0.00\",F39*0.225)","v":"0.00"},{"$f":"IF(D65=0,\"0.00\",F49/12)","v":"0.00"},null,null,null,null,{"$f":"IF(J65=0,\"0.00\",L39*0.225)","v":"0.00"},{"$f":"IF(J65=0,\"0.00\",L49/12)","v":"0.00"},null,null,null,null,{"$f":"IF(P65=0,\"0.00\",R39*0.225)","v":"0.00"},{"$f":"IF(P65=0,\"0.00\",R49/12)","v":"0.00"},null,{"$f":"F49+L49+R49","v":0},{"$f":"U49/12","v":0}]
["Yearly External Surplus/(Deficit)",null,null,null,null,{"$f":"IF(D65=0,\"0.00\",+F48-F39-F49)","v":"0.00"},{"$f":"IF(D65=0,\"0.00\",F50/12)","v":"0.00"},null,null,null,null,{"$f":"IF(J65=0,\"0.00\",+L48-L39-L49)","v":"0.00"},{"$f":"IF(J65=0,\"0.00\",L50/12)","v":"0.00"},null,null,null,null,{"$f":"IF(P65=0,\"0.00\",+R48-R39-R49)","v":"0.00"},{"$f":"IF(P65=0,\"0.00\",R50/12)","v":"0.00"},null,{"$f":"F50+L50+R50","v":0},{"$f":"U50/12","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B68+U50","v":0},{"$f":"U51/12","v":0},"Projected External Account Fund Balance (as of June 30, 2022)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B69+U50","v":0},{"$f":"U52/12","v":0},"Projected External Account Cash Balance (as of June 30, 2022)"]
[]
[]
["Internal Activity Calculations"]
["Enter Total Hours Available/Year"]
["If Applicable, Enter Number of Samples/Services  Per Hour"]
["Projected Internal Account Beginning Fund Balance on 7/1/2021"]
["Projected Internal Beginning Cash Balance on 7/1/2021"]
[]
["Internal Hourly or Per Service Rate",null,null,null,null,{"$f":"IF(D56=0,\"N/A\",F41/D56)","v":"N/A"},null,null,null,null,null,{"$f":"IF(J56=0,\"N/A\",L41/J56)","v":"N/A"},null,null,null,null,null,{"$f":"IF(P56=0,\"N/A\",R41/P56)","v":"N/A"}]
["Internal Rate Per Sample",null,null,null,null,{"$f":"IF(D57=0,\"N/A\",F61/D57)","v":"N/A"},null,null,null,null,null,{"$f":"IF(J57=0,\"N/A\",L61/J57)","v":"N/A"},null,null,null,null,null,{"$f":"IF(P57=0,\"N/A\",R61/P57)","v":"N/A"}]
[]
["External Activity Calculations"]
["Enter Total Hours Available/Year"]
["If Applicable, Enter Number of Samples/Services Per Hour"]
["Additional Upcharge/Profit %"]
["Projected External Account Beginning Fund Balance on 7/1/2021"]
["Projected External Beginning Cash Balance on 7/1/2021"]
[]
["External Minimum Rate/Hour (Prior to Upcharge/Profit)",null,null,null,null,{"$f":"IF(D65=0,\"N/A\",ROUND(F39/D65,2)*1.225)","v":"N/A"},null,null,null,null,null,{"$f":"IF(J65=0,\"N/A\",ROUND(L39/J65,2)*1.225)","v":"N/A"},null,null,null,null,null,{"$f":"IF(P65=0,\"N/A\",ROUND(R39/P65,2)*1.225)","v":"N/A"}]
["External Additional Upcharge/Profit Per Hour",null,null,null,null,{"$f":"IF(D65=0,\"N/A\",+F71*D67)","v":"N/A"},null,null,null,null,null,{"$f":"IF(J65=0,\"N/A\",+L71*J67)","v":"N/A"},null,null,null,null,null,{"$f":"IF(P65=0,\"N/A\",+R71*P67)","v":"N/A"}]
["Revised External Hourly or Per Service Rate ",null,null,null,null,{"$f":"IF(D65=0,\"N/A\",ROUND(F71+F72,2))","v":"N/A"},null,null,null,null,null,{"$f":"IF(J65=0,\"N/A\",ROUND(L71+L72,2))","v":"N/A"},null,null,null,null,null,{"$f":"IF(P65=0,\"N/A\",ROUND(R71+R72,2))","v":"N/A"}]
["External Rate Per Sample",null,null,null,null,{"$f":"IF(D66=0,\"N/A\",F73/D66)","v":"N/A"},null,null,null,null,null,{"$f":"IF(J65=0,\"N/A\",L73/J66)","v":"N/A"},null,null,null,null,null,{"$f":"IF(P65=0,\"N/A\",R73/P66)","v":"N/A"}]
[]
[]
["***Each Rate Must Stand On Its Own"]
["***All Customers Must Be Charged The Same Rate"]