{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Title Page","Instructions","Data Input","Narrative Responses","Template"],"not_rendered":{"charts":3,"defined_names":31,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Title Page","index":0,"n_rows":2,"n_cols":1,"rows_kept":2}
["Local Control Funding Formula (LCFF) Budget Overview for Parents Template"]
["Developed by the California Department of Education, September 2020"]

{"sheet":"Instructions","index":1,"n_rows":34,"n_cols":1,"rows_kept":34}
["LCFF Budget Overview for Parents Data Entry Instructions"]
["These instructions are for the completion of the Local Control Funding Formula (LCFF) Budget Overview for Parents. "]
["Notice that there are 5 five tabs along the bottom of the workbook titled: ‘Title Page’, ‘Instructions’, ‘Data Input’, ‘Narrative Responses’, and ‘Template’. The local educational agency (LEA) will enter its data in the ‘Data Input’ tab and then respond to the available prompts in the ‘Narrative Responses’ tab; please note that certain prompts in the 'Narrative Responses' tab are conditional. This information will automatically populate the ‘Template’ pages of the Budget Overview for Parents with the information. The tabs ‘Title Page’, ‘Instructions’, ‘Data Input’, and ‘Narrative Responses’ are “inward facing” and are intended for use by LEA personnel. The information contained in the ‘Template’ tab will be “outward facing”, or the information that will be available to the LEA’s parents and stakeholders. To start, ensure that you are on the ‘Data Input’ worksheet by clicking on the ‘Data Input’ in the lower left hand side."]
["*NOTE: The \"High Needs Students\" referred to below are Unduplicated Students for LCFF funding purposes."]
["Data Input Tab Instructions"]
["LEA Information (rows 1-3)"]
["The LEA must enter the LEA name, county district school (CDS) code, and LEA contact information (name, phone number and email address) in the corresponding blue boxes."]
["For the 2020–21 Budget Overview for Parents, the dates for the Current School Year (2020–21) and the Prior School Year (2019–2020) have been prepopulated. "]
["Projected General Fund Revenue for the 2020–21 School Year"]
["All amounts should be entered in the gray boxes adjacent to the corresponding amount title. The amounts for the 2020–21 school year must reflect budget information available at the time of the first interim report."]
["•\tTotal LCFF funds (row 9): This amount is the total amount of LCFF funding (including supplemental & concentration grants) the LEA estimates it will receive pursuant to California Education Code (EC) sections 2574 (for county offices of education) and 42238.02 (for school districts and charter schools), as of the date of the first interim report for 2020. This amount is the amount indicated in the Standardized Account Code Structure (SACS) First Interim Fund Form 01, Column D, row A.1 (LCFF Sources)."]
["•\tLCFF supplemental & concentration grants (row 10): This amount is the total amount of LCFF supplemental and concentration grants the LEA estimates it will receive on the basis of the number and concentration of low income, foster youth, and English learner students as determined pursuant to California Code of Regulations, Title 5 (5 CCR) Section 15496(a)(5), pursuant to EC sections 2574 and 42238.02, as applicable for the 2020–21 school year."]
["•\tAll other state funds (row 12): This amount is the total amount of other state funds (do not include including LCFF funds) the LEA estimates it will receive."]
["•\tAll local funds (row 13): This amount is the total amount of local funds and entitlements the LEA estimates it will receive."]
["•\tTotal federal funds (row 14): This amount is the total amount of federal funds (including all Every Student Succeeds Act Title funds and Coronavirus Aid, Relief, and Economic Security [CARES] funds) the LEA estimates it will receive."]
["•\tFederal Coronavirus Aid, Relief, and Economic Security (CARES) funds (row 16): Of the amount of federal funds reported on line 14, provide the amount attributable to federal funds allocated to the LEA under the federal CARES Act (Public Law 116-136). CARES Act funds include the Elementary and Secondary School Emergency Relief (ESSER) Funds and Learning Loss Mitigation (LLM) Funds; LLM Funds include both Coronavirus Relief (CR) Funds and Governor's Emergency Education Relief (GEER) Funds."]
["The total of the General Fund Revenue should equal the amount indicated in the SACS First Interim Fund Form 01, Column D, row A.5 (Total Revenues)."]
["Total Budgeted Expenditures for the 2020–21 School Year"]
["The amounts for the 2020–21 school year must reflect budget information available at the time of the first interim report."]
["•\tTotal Budgeted General Fund Expenditures (row 19): This amount is the LEA’s total budgeted General Fund expenditures for the 2020–21 school year as indicated on SACS First Interim Fund Form 01, Column D, Row B.9 (Total Expenditures). The General Fund is the main operating fund of the LEA and accounts for all activities not accounted for in another fund. All activities are reported in the General Fund unless there is a compelling reason to account for an activity in another fund. For further information please refer to the California School Accounting Manual (http://www.cde.ca.gov/fg/ac/sa/). (Note: For some charter schools that follow governmental fund accounting, this amount is the total budgeted expenditures in the Charter Schools Special Revenue Fund. For charter schools that follow the not-for-profit accounting model, this amount is total budgeted expenses, such as those budgeted in the Charter Schools Enterprise Fund.)"]
["•\tTotal Budgeted Expenditures in the Learning Continuity and Attendance Plan (Learning Continuity Plan) (row 20): This is the total amount of budgeted expenditures associated with the actions included in the Learning Continuity Plan."]
["•\tTotal Budgeted Expenditures for High Needs Students in the Learning Continuity Plan (row 21): This is the total amount of the budgeted expenditures, from all fund sources, associated with the actions included in the Learning Continuity Plan that are identified as contributing to the increased or improved services for high needs students pursuant to EC Section 42238.07."]
["Expenditures for High Needs Students in the 2019–2020 School Year"]
["•\tTotal Budgeted Expenditures for High Needs Students in the Local Control and Accountability Plan (LCAP) (row 24): This amount is the total of the budgeted expenditures, from all fund sources, in the planned actions and services included in the 2019–2020 LCAP that are identified as contributing to the increased or improved services for high needs students pursuant to EC Section 42238.07 for the current school year."]
["•\tActual Expenditures for High Needs Students in the LCAP (row 25): This is the total of the estimated actual expenditures, from all fund sources, in the actions and services included in the 2019–2020 LCAP that are identified as contributing to the increased or improved services for high needs students pursuant to EC Section 42238.07."]
["Narrative Responses Tab Instructions"]
["The LEA's response for each prompt is limited to 75 words. Double click on the applicable cell to respond to the required prompt(s). Please note that certain prompts are conditional, based on the data provided in the ‘Data Input’ tab. "]
["•\tBrief description for General Fund Expenditures (row 3): Briefly describe any of the General Fund Budget Expenditures for the 2020–21 school year that are not included in the Learning Continuity Plan."]
["•\tBrief description for High Needs Students (row 4): If the amount on line 21 ('Data Input' tab) is less than the amount on line 10 ('Data Input' tab), a prompt will appear and the LEA must provide a brief description of the additional actions it is taking to meet its requirement to increase or improve services for high needs students. "]
["Note: If no prompt appears, the LEA is not required to supply a description."]
["Note: It may be necessary to adjust the row height to display the entire prompt."]
["•\tBrief description for actual expenditures for high needs students (row 5): If the amount in line 24 ('Data Input' tab) is greater than the amount in line 25 ('Data Input' tab), a prompt will appear and the LEA must provide a brief description of how the difference impacted the actions and services and overall increased or improved services for high needs students in the 2019–2020 fiscal year pursuant to EC Section 42238.07. "]
["Note: If no prompt appears, the LEA is not required to supply a description."]
["Note: It may be necessary to adjust the row height to display the entire prompt."]

{"sheet":"Data Input","index":2,"n_rows":26,"n_cols":2,"rows_kept":26}
["LCFF Budget Overview for Parents Data Input Sheet"]
["Local Educational Agency (LEA) name:","New Designs Charter"]
["CDS code:","19 64733 0102541"]
["LEA contact information:","Paul Okaiteye"]
["Current School Year:","2020-2021"]
["Prior School Year   ","2019-2020"]
["*NOTE: The \"High Needs Students\" referred to in the tables below are Unduplicated Students for LCFF funding purposes.","EmptyCell"]
[{"$f":"CONCATENATE(\"Projected General Fund Revenue for the \", IF(LCAP_Year=\"\", \"[Coming LCAP Year]\", LCAP_Year), \" School Year\")","v":"Projected General Fund Revenue for the 2020-2021 School Year"},"Amount"]
["Total LCFF funds",{"v":9778945,"d":"$9,778,945"}]
["LCFF supplemental & concentration grants",{"v":2421265,"d":"$2,421,265"}]
["All Other LCFF funds",{"$f":"SUM(LCAP_Year_LCFF_Funds-LCAP_Year_SC_Grants)","v":{"v":7357680,"d":"$7,357,680"}}]
["All other state funds",{"v":2274498,"d":"$2,274,498"}]
["All local funds",{"v":73410,"d":"$73,410"}]
["Total federal funds",{"v":1537608,"d":"$1,537,608"}]
["All Other Federal Funds",{"$f":"SUM(LCAP_Year_Federal_Funds-LCAP_YEAR_CARES_FUNDS)","v":{"v":652145,"d":"$652,145"}}]
["Federal CARES funds",{"v":885463,"d":"$885,463"}]
["Total Projected Revenue",{"$f":"SUM(LCAP_Year_LCFF_Funds,LCAP_Year_Other_Funds,LCAP_Year_Local_Funds,LCAP_Year_Federal_Funds)","v":{"v":13664461,"d":"$13,664,461"}}]
[{"$f":"CONCATENATE(\"Total Budgeted Expenditures for the \n\", IF(LCAP_Year=\"\", \"[Coming LCAP Year]\", LCAP_Year), \" School Year\")","v":"Total Budgeted Expenditures for the \n2020-2021 School Year"},"Amount"]
["Total Budgeted General Fund Expenditures",{"v":13125598,"d":"$13,125,598"}]
["Total Budgeted Expenditures in the Learning Continuity Plan",{"v":7235489,"d":"$7,235,489"}]
["Total Budgeted Expenditures for High Needs Students in the Learning Continuity Plan",{"v":2421265,"d":"$2,421,265"}]
["Expenditures not in the Learning Continuity Plan",{"$f":"B19-B20","v":{"v":5890109,"d":"$5,890,109"}}]
[{"$f":"CONCATENATE(\"Expenditures for High Needs Students in the \", IF(Current_LCAP_Year=\"\", \"[Current LCAP Year]\", Current_LCAP_Year), \" School Year\")","v":"Expenditures for High Needs Students in the 2019-2020 School Year"},"Amount"]
["Total Budgeted Expenditures for High Needs Students in the LCAP",{"v":3050804,"d":"$3,050,804"}]
["Actual Expenditures for High Needs Students in LCAP",{"v":3050804,"d":"$3,050,804"}]
["End of Sheet","End of Sheet"]

{"sheet":"Narrative Responses","index":3,"n_rows":5,"n_cols":2,"rows_kept":5}
[" LCFF Budget Overview for Parents Narrative Responses Sheet"]
["Required Prompt(s)","Response(s)"]
["Briefly describe any of the General Fund Budget Expenditures for the school year not included in the Learning Continuity Plan.","Expenditures not included in the LCP are as follows; Benefits, District Oversight Fees, Depreciation, utilities, rent, auxiliary salaries not included in LCP, legal, Banking & Payroll Services, Audit Services, Other fees and settlements"]
[{"$f":"IF(LCAP_YEar_UP_Expenditures_LCAP>=LCAP_Year_SC_Grants,\"A prompt may display based on information provided in the Data Input tab.\",CONCATENATE(\"The amount budgeted to increase or improve services for high needs students in the \",TEXT(LCAP_Year,\"#,000\"),\" Learning Continuity Plan is less than the projected revenue of LCFF supplemental and concentration grants for \",TEXT(LCAP_Year,\"#,000\"),\". Provide a brief description of the additional actions the LEA is taking to meet its requirement to improve services for high needs students.\n\"))","v":"A prompt may display based on information provided in the Data Input tab."},"[Respond to the prompt here; if there is no prompt a response is not required.]"]
[{"$f":"IF(Current_Year_EA_UP_Expenditures>=Current_Year_Budg_UP_Expenditures,\"A prompt may display based on information provided in the Data Input tab.\",CONCATENATE(\"The total actual expenditures for actions and services to increase or improve services for high needs students in \",TEXT(Current_LCAP_Year,\"#,000\"),\" is less than the total budgeted expenditures for those planned actions and services. Briefly describe how this difference impacted the actions and services and the overall increased or improved services for high needs students in \",TEXT(Current_LCAP_Year,\"#,000\"),\".\"))","v":"A prompt may display based on information provided in the Data Input tab."},"[Respond to the prompt here; if there is no prompt a response is not required.]"]

{"sheet":"Template","index":4,"n_rows":18,"n_cols":1,"rows_kept":18}
["LCFF Budget Overview for Parents Template "]
[{"$f":"CONCATENATE(\"Local Educational Agency (LEA) Name: \",IF(LEA_Name=\"\",\"[LEA Name]\",LEA_Name))","v":"Local Educational Agency (LEA) Name: New Designs Charter"}]
[{"$f":"CONCATENATE(\"CDS Code: \", IF(CDS_Code=\"\", \"[CDS Code]\", CDS_Code))","v":"CDS Code: 19 64733 0102541"}]
[{"$f":"CONCATENATE(\"School Year: \", IF(LCAP_Year=\"\", \"[School Year]\", LCAP_Year))","v":"School Year: 2020-2021"}]
[{"$f":"CONCATENATE(\"LEA contact information: \", IF(LEA_Contact=\"\", \"[LEA Contact Information]\", LEA_Contact), \"\")","v":"LEA contact information: Paul Okaiteye"}]
["School districts receive funding from different sources: state funds under the Local Control Funding Formula (LCFF), other state funds, local funds, and federal funds. LCFF funds include a base level of funding for all LEAs and extra funding - called \"supplemental and concentration\" grants - to LEAs based on the enrollment of high needs students (foster youth, English learners, and low-income students)."]
[{"$f":"CONCATENATE(\"Budget Overview for the \", IF(LCAP_Year=\"\", \"[School Year]\", LCAP_Year), \" School Year\" )","v":"Budget Overview for the 2020-2021 School Year"}]
[{"$f":"CONCATENATE(\"This chart shows the total general purpose revenue \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" expects to receive in the coming year from all sources.\")","v":"This chart shows the total general purpose revenue New Designs Charter expects to receive in the coming year from all sources."}]
[{"$f":"CONCATENATE(\"The total revenue projected for \",IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")),\" is $\", TEXT(LCAP_Year_Total_Revenue, \"#,0.00\"), \", of which $\", TEXT(LCAP_Year_LCFF_Funds, \"#,0.00\"), \" is Local Control Funding Formula (LCFF) funds, $\", TEXT(LCAP_Year_Other_Funds, \"#,0.00\"), \" is other state funds, $\", TEXT(LCAP_Year_Local_Funds, \"#,0.00\"), \" is local funds, and $\", TEXT(LCAP_Year_Federal_Funds, \"#,0.00\"), \" is federal funds. Of the $\", TEXT(LCAP_Year_Federal_Funds, \"#,0.00\"), \" in federal funds, $\", TEXT(LCAP_YEAR_CARES_FUNDS, \"#,0.00\"), \" are federal CARES Act funds. Of the $\",TEXT(LCAP_Year_LCFF_Funds, \"#,0.00\"),\" in LCFF Funds, $\",TEXT(LCAP_Year_SC_Grants, \"#,0.00\"),\" is generated based on the enrollment of high needs students (foster youth, English learner, and low-income students).\n\")","v":"The total revenue projected for New Designs Charter is $13,664,461.00, of which $9,778,945.00 is Local Control Funding Formula (LCFF) funds, $2,274,498.00 is other state funds, $73,410.00 is local funds, and $1,537,608.00 is federal funds. Of the $1,537,608.00 in federal funds, $885,463.00 are federal CARES Act funds. Of the $9,778,945.00 in LCFF Funds, $2,421,265.00 is generated based on the enrollment of high needs students (foster youth, English learner, and low-income students).\n"}]
["For the 2020-21 school year school districts must work with parents, educators, students, and the community to develop a Learning Continuity and Attendance Plan (Learning Continuity Plan). The Learning Continuity Plan replaces the Local Control and Accountability Plan (LCAP) for the 2020–21 school year and provides school districts with the opportunity to desribe how they are planning to provide a high-quality education, social-emotional supports, and nutrition to their students during the COVID-19 pandemic."]
[]
[{"$f":"CONCATENATE(\"This chart provides a quick summary of how much \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" plans to spend for planned actions and services in the Learning Continuity Plan for \", IF(LCAP_Year=\"\", \"[LCAP Year]\", TEXT(LCAP_Year, \"#,000\")), \"and how much of the total is tied to increasing or improving services for high needs students.\")","v":"This chart provides a quick summary of how much New Designs Charter plans to spend for planned actions and services in the Learning Continuity Plan for 2020-2021and how much of the total is tied to increasing or improving services for high needs students."}]
[{"$f":"CONCATENATE(\"\n\",IF(LEA_Name=\"\",\"[LEA Name]\",TEXT(LEA_Name,\"#,000\")),\" plans to spend $\",TEXT(LCAP_Year_GF_Expenditures,\"#,0.00\"),\" for the \",IF(LCAP_Year=\"\",\"[LCAP Year]\",TEXT(LCAP_Year,\"#,000\")),\" school year. Of that amount, $\",TEXT(LCAP_Year_LCAP_Expenditures,\"#,0.00\"),\" is tied to actions/services in the Learning Continuity Plan and $\",TEXT(LCAP_Year_Expenditures_Not_LCAP,\"#,0.00\"),\" is not included in the Learning Continuity Plan. The budgeted expenditures that are not included in the Learning Continuity Plan will be used for the following: \n\n\",LCAP_Year_Descr_Not_In_LCAP,\"\")","v":"\nNew Designs Charter plans to spend $13,125,598.00 for the 2020-2021 school year. Of that amount, $7,235,489.00 is tied to actions/services in the Learning Continuity Plan and $5,890,109.00 is not included in the Learning Continuity Plan. The budgeted expenditures that are not included in the Learning Continuity Plan will be used for the following: \n\nExpenditures not included in the LCP are as follows; Benefits, District Oversight Fees, Depreciation, utilities, rent, auxiliary salaries not included in LCP, legal, Banking & Payroll Services, Audit Services, Other fees and settlements"}]
[{"$f":"CONCATENATE(\"Increased or Improved Services for High Needs Students in in the Learning Continuity Plan for the \", IF(LCAP_Year=\"\", \"[LCAP Year]\", LCAP_Year), \" School Year\")","v":"Increased or Improved Services for High Needs Students in in the Learning Continuity Plan for the 2020-2021 School Year"}]
[{"$f":"CONCATENATE(\"\nIn \", IF(LCAP_Year=\"\", \"[LCAP Year]\", TEXT(LCAP_Year, \"#,000\")), \", \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" is projecting it will receive $\",TEXT(LCAP_Year_SC_Grants, \"#,0.00\"), \" based on the enrollment of foster youth, English learner, and low-income students. \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" must describe how it intends to increase or improve services for high needs students in the Learning Continuity Plan. \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" plans to spend $\", TEXT(LCAP_YEar_UP_Expenditures_LCAP, \"#,0.00\"), \" towards meeting this requirement, as described in the Learning Continuity Plan.\",IF('Narrative Responses'!A4=\"\", \"\", IF('Data Input'!B21<'Data Input'!B10, CONCATENATE(\" The additional improved services described in the plan include the following: \n\n\", UP_Improve_Description, \"\"), \"\")))","v":"\nIn 2020-2021, New Designs Charter is projecting it will receive $2,421,265.00 based on the enrollment of foster youth, English learner, and low-income students. New Designs Charter must describe how it intends to increase or improve services for high needs students in the Learning Continuity Plan. New Designs Charter plans to spend $2,421,265.00 towards meeting this requirement, as described in the Learning Continuity Plan."}]
[{"$f":"CONCATENATE(\"Update on Increased or Improved Services for High Needs Students in \", IF(Current_LCAP_Year=\"\", \"[LCAP Year]\", Current_LCAP_Year))","v":"Update on Increased or Improved Services for High Needs Students in 2019-2020"}]
[{"$f":"CONCATENATE(\"This chart compares what \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" budgeted in the 2019-20 LCAP for actions and services that contributed to increasing or improving services for high needs students with what \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \" actually spent on actions and services that contributed to increasing or improving services for high needs students in the 2019-20 school year.\")","v":"This chart compares what New Designs Charter budgeted in the 2019-20 LCAP for actions and services that contributed to increasing or improving services for high needs students with what New Designs Charter actually spent on actions and services that contributed to increasing or improving services for high needs students in the 2019-20 school year."}]
[{"$f":"CONCATENATE(\"\nIn \", IF(Current_LCAP_Year=\"\", \"[the current LCAP Year]\", Current_LCAP_Year), \", \", IF(LEA_Name=\"\", \"[LEA Name]\", LEA_Name),\"'s LCAP budgeted $\", TEXT(Current_Year_Budg_UP_Expenditures, \"#,0.00\"), \" for planned actions to increase or improve services for high needs students. \", IF(LEA_Name=\"\", \"[LEA Name]\", LEA_Name), \" actually spent $\", TEXT(Current_Year_EA_UP_Expenditures, \"#,0.00\"), \" for actions to increase or improve services for high needs students in \", IF(Current_LCAP_Year=\"\", \"[the current LCAP Year]\", Current_LCAP_Year), \".\", IF(Current_Year_EA_UP_Expenditures<Current_Year_Budg_UP_Expenditures, CONCATENATE(\" The difference between the budgeted and actual expenditures of $\", TEXT(SUM(Current_Year_Budg_UP_Expenditures-Current_Year_EA_UP_Expenditures), \"#,0.00\"), \" had the following impact on \", IF(LEA_Name=\"\", \"[LEA Name]\", TEXT(LEA_Name, \"#,000\")), \"'s ability to increase or improve services for high needs students:\n \n\", UP_Difference_Descr, \"\"), \"\"))","v":"\nIn 2019-2020, New Designs Charter's LCAP budgeted $3,050,804.00 for planned actions to increase or improve services for high needs students. New Designs Charter actually spent $3,050,804.00 for actions to increase or improve services for high needs students in 2019-2020."}]