{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["DOE 101S","Instructions","Examples"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":1,"defined_names":36,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"DOE 101S","index":0,"n_rows":31,"n_cols":7,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,1,1,6],[27,1,30,4],[2,4,2,6],[3,4,3,6],[4,4,4,6],[5,1,5,6],[26,1,26,4]],"flags":["formulas_cached_only"]}
[]
[null,"FLORIDA DEPARTMENT OF EDUCATION\nBUDGET NARRATIVE FORM 101S"]
[null,null,null,"A)  Name of Eligible Recipient/Fiscal Agent:"]
[null,null,null,"B)  DOE Assigned Project Number:"]
[null,null,null,"C)  TAPS Number:          "]
[]
[null,"(1)","(2)","(3)","(4)","(5)","(6)"]
[null,"FUNCTION","OBJECT","Account Title and Narrative","FTE POSITION","AMOUNT","% Allocated to This Project"]
{"$rows_empty":18}
[null,"D)  TOTAL  ",null,null,null,0,0]
[null,"DOE ATTESTATION (Program and Grants Management)\nThe cost for each line item budget category has been evaluated and determined to be allowable, reasonable and necessary as required by Section 216.3475, Florida Statutes. Documentation is on file evidencing the methodology used and the conclusions reached."]
[]
[]
[{"$nulls":5},"April 2022","DOE 101S"]

{"sheet":"Instructions","index":1,"n_rows":13,"n_cols":1,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,0,11,8],[12,0,12,8],[6,0,6,13],[7,0,7,13],[8,0,8,13],[9,0,9,13],[10,0,10,13],[4,0,4,13],[5,0,5,13],[0,0,0,13],[1,0,1,13],[2,0,2,13],[3,0,3,13]],"flags":["formulas_cached_only"]}
["Budget Narrative Form Instructions"]
["A)  Enter Name of Eligible Recipient/Fiscal Agent"]
["B)  Enter DOE Assigned Project Number"]
["C)  Enter TAPS Number"]
["D)  Enter the Total Amount for column (5)"]
["(1)  Function Code – For School Districts Only – Enter the Function Code, as required in the Financial and Program Cost Accounting and Reporting for Florida Schools Manual, which best classifies the overall purpose or objective of the goods or services budgeted."]
["(2)  Object Code – Enter the Object Code which best classifies the goods or services budgeted.  School Districts - Use the three-digit Object Code as required in the Financial and Program Cost Accounting and Reporting for Florida Schools Manual;  Colleges and Universities - Use the first three digits of the Object Codes listed in the Florida Accounting Information Resource Manual;  Non-public entities – Use the Object Codes that are used in the respective entity’s/agency’s chart of accounts."]
["(3)   Account Title and Narrative - Provide the Account Title that applies to the Object Code listed in (2) and a detailed Narrative that includes a description of each good or service budgeted and its purpose or use.  For example:  \nSalaries – Describe the type(s) of position(s) requested and the major responsibilities/duties of each position(s). Use a separate line to describe each type of position.   \nOther Personal Services – Describe the type of service(s), its purpose or use, and an estimated number of hours for each type of position. OPS is defined as compensation paid to persons, including substitute teachers not under contract, who are employed to provide temporary services to the program.  \nProfessional/Technical Services – Describe the services rendered by personnel, other than agency personnel employees, who provide specialized skills and knowledge. \nContractual Services and/or Inter-agency agreements – Describe the services to be rendered and the type of entity or agency (name, if available).  \nTravel – Describe each type of travel to be supported with project funds, such as conference(s), local travel, in- or out-of-district, and out-of-state. Do not list\n individual names. List individual position(s) when travel funds are being requested to perform necessary activities.  \nMaterials and Supplies - Describe the type of item to be purchased and its purpose or use. \nCapital Outlay - Describe the type of item/equipment to be purchased and its purpose or use.\nIndirect Cost - Refer to the DOE Project Application and Amendment Procedures for Federal and State Programs (Green Book) for additional guidance\nregarding indirect cost.\n - School Districts Only - Provide the percentage rate from the district’s Approved Indirect Cost Plan.\n - Colleges and Universities Only– Provide the percentage rate (maximum of 5%) approved by the DOE.    "]
["(4)  FTE - (Only applicable for items classified as Salaries and Other Personal Services (Refer to (2) Object Code.) Enter the total number of positions (as FTEs*) that will be supported with these funds.  *Full-Time Equivalent (FTE based on the standard workweek for the type of position) is the number of positions to be funded. Determine FTE by dividing the standard number of weekly hours (e.g., 35 hours) for the type of position (e.g., teacher aide) into the actual work hours to be funded by the project."]
["(5)  Amount - Enter the total amount budgeted for each line item."]
["(6)  Percent Allocated – For each line item, enter the appropriate percentage that is allocated or applicable to this project (see pages 3-4 for examples)."]
["DOE 101S- Instructions - Page 1 of 1"]
["Februrary 2022"]

{"sheet":"Examples","index":2,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[27,6,28,6],[28,0,28,3],[29,0,29,6],[30,0,30,6],[24,0,24,6],[25,6,26,6],[16,0,16,8],[17,0,17,8],[18,0,18,6],[22,6,23,6],[23,0,23,3],[19,0,19,13],[20,6,21,6],[12,6,13,6],[14,6,15,6],[11,0,11,6],[0,0,0,6],[1,0,1,13],[2,6,3,6],[4,6,10,6],[10,0,10,3],[15,0,15,3]],"flags":["formulas_cached_only"]}
["(6)  PERCENT ALLOCATED If the cost entered in (5) for each service/commodity listed in (3) is not the total cost of this service/commodity, enter the appropriate percentage in (6) that is applicable to this project. If the cost entered in (5) for each service/commodity listed in (3) is the total cost for this service/commodity and is applicable to this project, enter 100% in (6)."]
["Example A"]
["(1)","(2)","(3)","(4)","(5)","(6)","EXPLANATION"]
["FUNCTION","OBJECT","ACCOUNT TITLE & NARRATIVE","FTE POSITION","AMOUNT","% ALLOCATED to this PROJECT"]
[6200,110,"Salaries - Provides for supervision of all project activities; specific areas for supervision/ coordination are listed by position below.\nSupervisor/Grant Administration/National Instructional Materials Accessibility Standards\nCoordinator/Professional Development and Training",2,120000,1,"The total cost for the two positions listed in (5), a Supervisor and a Coordinator (2.0 FTE), are charged to this project.  Therefore, the percent of the cost for Salaries and Benefits allocated to this project is 100%."]
[6200,210,"Retirement (9.85%)",null,11820,1]
[6200,220,"FICA (6.20%)",null,7440,1]
[6200,223,"Medicare (1.45%)",null,1740,1]
[6200,"231 / 232","Health / Life (11.90%)",null,14280,1]
[6200,240,"Worker's Comp. (1.26%)",null,1512,1]
["TOTAL",null,null,null,156792]
["Example B"]
["(1)","(2)","(3)","(4)","(5)","(6)","EXPLANATION"]
["FUNCTION","OBJECT","ACCOUNT TITLE & NARRATIVE","FTE POSITION","AMOUNT","% ALLOCATED to this PROJECT"]
[7900,430,"Utilities - Electricity, water and sewage charges for the facility where this project is housed.",null,10000,0.5,"The total cost for utilities for the facility where this project is housed is $20,000 annually.  However, this project only occupies 50% of the facility.  Therefore, the percent of the cost for Utilities allocated to this project is 50%."]
["TOTAL",null,null,null,10000]
[]
[]
["(6)  PERCENT ALLOCATED (continued)"]
["Example C"]
["(1)","(2)","(3)","(4)","(5)","(6)","EXPLANATION"]
["FUNCTION","OBJECT","ACCOUNT TITLE & NARRATIVE","FTE POSITION","AMOUNT","% ALLOCATED to this PROJECT"]
[6300,331,"In County Travel - Travel cost for staff to and from agency headquarters to designated program sites for the purpose of performing activities related to the administration and supervision of project.",null,1980,1,"The mileage estimated for travel for district staff to and from the county office to the program sites was estimated to be 4,500 miles annually @ $0.44/mile.  Therefore, the percent of the cost for In County Travel allocated to this project is 100%."]
["TOTAL",null,null,null,1980]
["Example D"]
["(1)","(2)","(3)","(4)","(5)","(6)","EXPLANATION"]
["FUNCTION","OBJECT","ACCOUNT TITLE & NARRATIVE","FTE POSITION","AMOUNT","% ALLOCATED to this PROJECT"]
["NA for Private Entities",350,"Purchased Services - Contract with ABC Company for the repair/ maintenance of the office equipment; one laser printer and copier.",null,1250,0.25,"The total cost for the maintenance contract for this equipment is $5,000.  It has been determined that this project only uses this equipment 25% of the time.  Therefore, the percent of the cost for Purchased Services allocated to this project is 25%."]
["TOTAL",null,null,null,1250]