{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Budget Performance Report"],"read":"whole","date_system":"1900"}

{"sheet":"Budget Performance Report","index":0,"n_rows":133,"n_cols":5,"rows_kept":133,"merged":[[0,0,0,4],[1,0,1,2],[2,0,2,2],[34,0,34,4],[35,0,35,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[40,0,40,4],[42,1,42,4],[43,1,44,4],[45,1,46,4],[47,1,48,4],[50,1,50,4],[51,1,52,4],[53,1,54,4],[55,1,56,4],[58,1,58,4],[59,1,60,4],[62,1,62,4],[63,1,64,4],[66,1,66,4],[67,1,68,4],[69,1,70,4],[72,1,72,4],[73,1,75,4],[77,1,77,4],[78,1,79,4],[81,1,81,4],[82,1,83,4],[84,1,85,4],[86,1,87,4],[89,1,89,4],[90,1,91,4],[93,1,93,4],[94,1,95,4],[98,0,98,4],[100,0,100,4],[101,1,101,2],[102,1,102,2]]}
["<Insert Project Name> Budget Performance Report"]
["PM: <Insert Project Manager>"]
["Project dates: <Insert Project Execution Dates>"]
[]
["Project Budget"]
["Budgeted Cost (Non-Capitalized)"]
[{"v":0,"d":"$0.00"}]
["Budgeted Cost (Capitalized)"]
[{"v":0,"d":"$0.00"}]
["Budget Cost (Total)"]
[{"v":0,"d":"$0.00"}]
[]
["Estimate (Non-Cap)",null,"Estimate (Cap)",null,"Total Estimate"]
["Hours Estimate (Total)",null,"Total T&E Estimated Cost (Capitalized)",null,"Total T&E: Estimated Cost (Total)"]
[{"v":0,"d":"0.00"},null,{"v":0,"d":"$0.00"},null,{"$f":"SUM(A19,C15)","v":{"v":0,"d":"$0.00"}}]
["Hours Estimate Cost (Total)"]
[{"v":0,"d":"$0.00"}]
["Total T&E Estimated Cost (Non-Cap) "]
[{"v":0,"d":"$0.00"}]
[]
["Actual (Non-Cap)",null,"Actual (Cap)",null,"Total Actual"]
["Actual Budgeted Salary Expense (Total)",null,"Total T&E Actual Cost (Capitalized)",null,"Total T&E Actual Cost (Total)"]
[{"v":0,"d":"$0.00"},null,{"v":0,"d":"$0.00"},null,{"$f":"SUM(A25,C23)","v":{"v":0,"d":"$0.00"}}]
["Total T&E Actual Cost (Non-Cap)"]
[{"v":0,"d":"$0.00"}]
[]
["TPC (Non-Cap)",null,"TPC (Cap)",null,"TPC"]
["Actual Hours",null,"TPC T&E (Capitalized)",null,"TPC T&E (Total)"]
[{"v":0,"d":"0.00"},null,{"v":0,"d":"$0.00"},null,{"$f":"SUM(A33,C29)","v":{"v":0,"d":"$0.00"}}]
["Hours Actual Cost (Total)"]
[{"v":0,"d":"$0.00"}]
["TPC T&E (Non-Cap)"]
[{"v":0,"d":"$0.00"}]
[]
["Definitions"]
["*TPC = Total Project Cost  (includes indirect)."]
["*T&E = Time & Expense."]
["*Non-Cap = Non-Capital Expense: Non-capital expenses are monies budgeted for repairs, supplies, payroll, and other operating expenses pertaining to the project."]
["*Cap = Capital Expense: Capital expenses are monies budgeted to acquire or improve long-term assets such as property, plant, or equipment."]
[]
["Instructions"]
[]
["Project Budget","These figures are provided by the approved project budget and should mirror what is in Banner."]
["Budgeted Cost (Non-Capitalized)","Dollar amount for all non-capital expenses in the project budget.   Non-capital expenses are monies budgeted for repairs, supplies, payroll, and other operating expenses pertaining to the project."]
["<$xxx,xxx>"]
["Budgeted Cost (Capitalized)","Dollar amount for all capital expenses in the project budget.   Capital expenses are monies budgeted to acquire or improve long-term assets such as property, plant, or equipment."]
["<$x,xxx,xxx>"]
["Budget Cost (Total)","Auto-calculated field.  This value will be the sum of the non-capital and capital expenses as identified in the project budget. "]
["<$xx,xxx,xxx>"]
[]
["Estimate (Non-Cap)","These figures represent estimates for effort hours and associated non-capital expenses for the project."]
["Hours Estimate (Total)","Project effort estimate (in hours).  This is a summation of all estimated task hours identified in the project execution plan (project schedule).  This field can be obtained in Innotas on the Project Info page.  "]
["<x,xxx>"]
["Hours Estimate Cost (Total)","Cost of estimated task hours.  This field can be found in Innotas on the Project Info screen.  Salary averages based on Team members' titles are multiplied by the task hours they are assigned, producing a time (hours) cost estimate.  Team members must log project hours for this to be accurate."]
["<$xx,xxx,xxx>"]
["Total T&E Estimated Cost (Non-Cap) ","This field can be found in Innotas on the Project Info screen.  This represents the total estimate (sum) of all non-capital expenses (salary, supplies, etc.).  In order for this to be accurate, the PM must input all non-capital project expenses and the project team must log their hours."]
["<$xx,xxx,xxx>"]
[]
["Estimate (Cap)","This figure represents the estimated capital expenditures for the project."]
["Total T&E Estimated Cost (Capitalized)","Data for this field can be found in Innotas on the Project Info screen.  In Innotas, this field is calculated based on all submitted (but not yet approved) capital expenses for a project.  The PM must input all capital expenditure estimates into Innotas for this data to be accurate."]
["<$xx,xxx,xxx>"]
[]
["Total Estimate","This figure represents the sum of the estimated capital and non-capital expenditures for the project."]
["Total T&E: Estimated Cost (Total)","Auto -calculated field representing the sum of capital and non-capital Time and Expense estimates."]
["<$xx,xxx,xxx>"]
[]
["Actual (Non-Cap)","These figures represents the actual salary and associated non-capital expenses for the project."]
["Actual Budgeted Salary Expense (Total)","Data for this field should be provided by Banner.  This dollar amount represents the actual salary expenditure for the project (non-capital expense)."]
["<$xx,xxx,xxx>"]
["Total T&E Actual Cost (Non-Cap)","Data for this field should be provided by Banner.  This dollar amount represents the actual sum of all non-capital expenditures on a project (salary, supplies, etc.).  A Banner detail account report will provide the correct data. "]
["<$xx,xxx,xxx>"]
[]
["Actual (Cap)","This figure represents the actual capital expenditures for the project."]
["Total T&E Actual Cost (Capitalized)","Data for this field should be provided by Banner.  This dollar amount represents the sum all actual capital expenditures on a project.  A Banner detail account report will provide the correct data.  If the PM is tracking expenses in Innotas, then the Project Financial Report in Innotas will also provide this information. "]
["<$xx,xxx,xxx>"]
[]
[]
["Total Actual","This figure represents the sum of the actual capital and non-capital expenditures for the project."]
["Total T&E Actual Cost (Total)","Auto-calculated field representing the sum of actual capital and non-capital Time and Expense costs."]
["<$xx,xxx,xxx>"]
[]
["TPC (Non-Cap)","These figures represent actual effort hours and associated non-capital (including indirect) expenses for the project."]
["Actual Hours","Data for this field is provided on the Innotas Project Info screen.  This represents the total time logged against the project by the project team."]
["<x,xxx>"]
["Hours Actual Cost (Total)","Data for this field is provided by the Project Financial Report in Innotas.  This is the actual (including indirect) cost of all time logged against the project based on the average salary of each team members' respective roles/title.  This amount is sometimes referred to as 'indirect'."]
["<$xx,xxx,xxx>"]
["TPC T&E (Non-Cap)","Data for this field is provided by the Project Financial Report in Innotas (if expenses and time have been logged).   This is the sum of the true cost of all time logged against the project based on the average salary of each team members' respective roles/title as well as any other non-capitalized expense. "]
["<$xx,xxx,xxx>"]
[]
["TPC (Cap)","This figure represents the actual capital expenditures for the project (same as Actual (Cap))."]
["TPC T&E (Capitalized)","Data for this field should be provided by Banner.  This dollar amount represents the actual sum of all capital expenditures on a project.  A Banner detail account report will provide the correct data.  If the PM is tracking expenses in Innotas, then the Project Financial Report in Innotas will also provide this information.   This should be the same as Actual (Cap)."]
["<$xx,xxx,xxx>"]
[]
["TPC","This figure represents the sum of the actual capital and non-capital (including indirect) expenditures for the project.  The result should be the 'true' cost of the project."]
["TPC T&E (Total)","Auto-calculated field representing the Total Project Cost.  This is a sum of the TPC T&E capital and non-capital expenses."]
["<$xx,xxx,xxx>"]
[]
[]
["***Example***"]
[]
["Luminis 4 Budget Performance Report"]
[null,"PM: Adam Levinson"]
[null,"Project dates: 10.6.08 - 6.8.09"]
[]
["Project Budget"]
["Budgeted Cost (Non-Capitalized)"]
[{"v":35000,"d":"$35,000.00"}]
["Budgeted Cost (Capitalized)"]
[{"v":55000,"d":"$55,000.00"}]
["Budget Cost (Total)"]
[{"v":90000,"d":"$90,000.00"}]
[]
["Estimate (Non-Cap)",null,"Estimate (Cap)",null,"Total Estimate"]
["Hours Estimate (Total)",null,"Total T&E Estimated Cost (Capitalized)",null,"Total T&E: Estimated Cost (Total)"]
[{"v":1652,"d":"1,652.00"},null,{"v":55000,"d":"$55,000.00"},null,{"$f":"SUM(A119,C115)","v":{"v":125580,"d":"$125,580.00"}}]
["Hours Estimate Cost (Total)"]
[{"v":70580,"d":"$70,580.00"}]
["Total T&E Estimated Cost (Non-Cap) "]
[{"v":70580,"d":"$70,580.00"}]
[]
["Actual (Non-Cap)",null,"Actual (Cap)",null,"Total Actual"]
["Actual Budgeted Salary Expense (Total)",null,"Total T&E Actual Cost (Capitalized)",null,"Total T&E Actual Cost (Total)"]
[{"v":20734.13,"d":"$20,734.13"},null,{"v":53738.74,"d":"$53,738.74"},null,{"$f":"SUM(A125,C123)","v":{"v":74472.87,"d":"$74,472.87"}}]
["Total T&E Actual Cost (Non-Cap)"]
[{"v":20734.13,"d":"$20,734.13"}]
[]
["TPC (Non-Cap)",null,"TPC (Cap)",null,"TPC"]
["Actual Hours",null,"TPC T&E (Capitalized)",null,"TPC T&E (Total)"]
[{"v":1570.25,"d":"1,570.25"},null,{"v":53738.74,"d":"$53,738.74"},null,{"$f":"SUM(A133,C129)","v":{"v":120099.85,"d":"$120,099.85"}}]
["Hours Actual Cost (Total)"]
[{"v":66361.11,"d":"$66,361.11"}]
["TPC T&E (Non-Cap)"]
[{"$f":"SUM(A131)","v":{"v":66361.11,"d":"$66,361.11"}}]