{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Summary INTERNAL USE","Instructions and Summary","a. Personnel","b. Travel","c. Equipment","d. Supplies","e. Contractual-Subawards","f. Construction","g. Other","h. Indirect","List"],"not_rendered":{"charts":0,"images":22,"macros":1,"external_links":0,"defined_names":30,"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":"Summary INTERNAL USE","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":true,"merged":[[34,0,35,6],[20,4,20,6],[21,0,21,6],[22,4,22,6],[25,0,25,6],[26,4,26,6],[27,0,27,6],[28,4,28,6],[29,4,29,6],[30,0,30,4],[31,4,31,6],[32,0,32,2],[19,4,19,6],[1,0,1,6],[6,0,6,6],[7,0,7,6],[9,0,9,6],[10,4,10,6],[11,4,11,6],[14,4,14,6],[15,4,15,6],[16,4,16,6],[17,4,17,6],[18,4,18,6]]}
[]
["Instructions and Summary"]
[]
["Award Number:",null,null,null,null,"Date of Submission:"]
["Award Recipient:",null,null,null,null,"Form submitted by: "]
[]
["Please read the instructions on each worksheet tab before starting. If you have any questions, please ask your DOC contact.                                                                                                    Do not modify this template or any cells or formulas.  "]
["1. Fill out the blank white cells in workbook tabs a. through i. with costs only for the current phase  (e.g., initial proposal or final proposal) being submitted. Also complete tab j.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.   \n3. Enter the project costs identified for each Category line item within each worksheet tab to auto-populate the summary tab.  \n4. All costs incurred by the eligible entity's sub-recipients and contractors, should be entered only in section e. Contractual/Subaward. All other sections are for the costs of the eligible entity only.\n5. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200.  Only include costs that can be directly attributed to the project.  Do not include costs that will be incurred for any other Federal financial assistance award. \n      • Allowable refers to costs that may be charged to a grant in accordance with the cost principles prescribed in 2 CFR 200.400.\n      • Allocable refers to costs that can be directly charged to the grant award based on the benefit provided.\n      • Reasonable refers to actions a prudent business person would employ.\n6. Add rows as needed throughout tabs a. through i. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab or tab j.\n7. Expenses relating to the administration of the grant: An Eligible Entity may not use more than two percent of the grant amounts received under the BEAD Program for expenses relating (directly or indirectly) to administration of the grant under Section 60102(d)(2)(B) of the Infrastructure Act. Identify if any expenses relating to the administration of the grant are included  as part of the category cost and enter dollar amount. Expenses related to the administration of the grant are not in addition to the total cost category.\n8. The totals of ALL cost categories are rounded to the nearest dollar.\n"]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent tabs, only blank white cells require data entry"]
["Category","Cost","Includes expenses relating to the administration of the grant?","Total ($) Expenses relating to the administration of the grant","Comments (as needed)"]
["a. Total Personnel",{"$f":"'a. Personnel'!I21","v":0},{"$f":"'Instructions and Summary'!C14","v":0},{"$f":"'Instructions and Summary'!D14","v":0}]
["Salary",{"$f":"'a. Personnel'!F21","v":0}]
["Fringe",{"$f":"'a. Personnel'!G21","v":0}]
["b. Travel",{"$f":"'b. Travel'!J18","v":0},{"$f":"'Instructions and Summary'!C17","v":0},{"$f":"'Instructions and Summary'!D17","v":0}]
["c. Equipment",{"$f":"'c. Equipment'!D18","v":0},{"$f":"'Instructions and Summary'!C18","v":0},{"$f":"'Instructions and Summary'!D18","v":0}]
["d. Supplies",{"$f":"'d. Supplies'!D18","v":0},{"$f":"'Instructions and Summary'!C19","v":0},{"$f":"'Instructions and Summary'!D19","v":0}]
["e. Contractual/Subawards",{"$f":"'e. Contractual-Subawards'!E45","v":0},{"$f":"'Instructions and Summary'!C20","v":0},{"$f":"'Instructions and Summary'!D20","v":0}]
["f. Construction",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}}]
["g. Other Direct Costs",{"$f":"'g. Other'!B17","v":0},{"$f":"'Instructions and Summary'!C22","v":0},{"$f":"'Instructions and Summary'!D22","v":0}]
["Total Direct Costs",{"$f":"SUM(B12:B20)-(B13+B14)","v":{"$error":"#REF!"}},null,{"$f":"SUM(D12:D20)","v":{"$error":"#REF!"}}]
[]
["h. Total Indirect Charges",{"$f":"'h. Indirect'!D21","v":0},{"$f":"'Instructions and Summary'!C25","v":0},{"$f":"'Instructions and Summary'!D25","v":0}]
["Federal Funds",{"$f":"'h. Indirect'!E21","v":0}]
["Non-Federal Funds",{"$f":"'h. Indirect'!F21","v":0}]
[]
["Total Federal Costs",{"$f":"B21+B23","v":{"$error":"#REF!"}},null,{"$f":"D21+D23","v":{"$error":"#REF!"}}]
[]
["i. Cost Sharing/Matching $",{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}},{"$f":"'Instructions and Summary'!#REF!","v":{"$error":"#REF!"}}]
["i. Cost Sharing/Matching %",{"$f":"B29/B32","v":{"$error":"#REF!"}}]
[]
["Total Project Costs",{"$f":"B27+B29","v":{"$error":"#REF!"}},"Total expenses relating to the administration of the grant ($)",{"$f":"D27+D29","v":{"$error":"#REF!"}}]
["Total expenses relating to the administration of the grant (%)",null,null,{"$f":"D32/B27","v":{"$error":"#REF!"}}]
[]
["Additional Explanation (as needed):"]

{"sheet":"Instructions and Summary","index":1,"n_rows":33,"n_cols":9,"rows_kept":33,"cut":false,"hidden":false,"merged":[[0,0,0,15],[29,3,29,4],[29,6,29,7],[30,3,30,4],[30,6,30,7],[3,0,3,10],[9,0,9,10],[16,8,16,10],[13,8,13,10],[17,8,17,10],[5,0,6,10],[8,0,8,10],[11,0,11,10],[32,0,33,10],[12,8,12,10],[22,8,22,10],[24,8,24,10],[28,0,28,8],[19,8,19,10],[23,0,23,10],[21,8,21,10],[30,8,30,10],[29,8,29,10],[27,8,27,10],[18,8,18,10]]}
["OMB Control No. 0660-0054 Expiration Date: 2/28/2027"]
[]
[]
["State Digital Equity Capacity Grant Program\nConsolidated Budget Form"]
[]
["This form will serve as a tool to capture budget information required for the State Digital Equity Capacity Grant Program application.\n\nPer Section II.C.2. of the NOFO, any State or Territory applying for Capacity Grant funds must submit the Consolidated Budget Form as part of their application. \nApplications from States must be received no later 11:59 p.m. ET on May 28, 2024, 60 days after the issuance the NOFO. Applications from U.S. Territories must be received no later 11:59 p.m. ET on July 31, 2024.  \n\nIf you have any further questions, or require technical assistance, please reach out to your assigned Federal Program Officer."]
[]
[]
["Read the instructions on each worksheet tab before starting. Do not modify this template or any cells or formulas.  "]
["1. First fill out the blank white cells in workbook tabs a. through i. with costs only for the current phase being submitted. Enter the project costs identified for each Category line item within each worksheet tab to auto-populate column B of this summary tab.\n2. Blue colored cells contain instructions, headers, or summary calculations and should not be modified. Only blank white cells should be populated.    \n3. All costs incurred by the grantee's sub-recipients and contractors, should be entered only in section e. Contractual/Subaward. All other sections are for the costs of the grantee only.\n4. Ensure all entered costs are allowable, allocable, and reasonable in accordance with the administrative requirements prescribed in 2 CFR 200.  Only include costs that can be directly attributed to the project.  Do not include costs that will be incurred for any other Federal financial assistance award. \n      • Allowable refers to costs that may be charged to a grant in accordance with the cost principles prescribed in 2 CFR 200.403.\n      • Allocable refers to costs that can be directly charged to the grant award based on the benefit provided.  See 2 CFR 200.405.\n      • Reasonable refers to actions a prudent business person would employ and are necessary to the execution of the award.  See 2 CFR 200.404.\n5. Add rows as needed throughout tabs a. through i. If rows are added, formulas/calculations may need to be adjusted by the preparer. Do not add rows to the Instructions and Summary tab.\n6. The budget should account for the State or Territory’s: a) administrative costs, capped at 3% of the grant amount; b) program evaluation costs, capped at 5% of the grant amount; and c) Digital Equity Plan updates and maintenance, capped at 20% of the grant amount; and d) affordable broadband program costs, capped at 10% (see Section II.C.3. of the NOFO regarding these funding restrictions).\n7. Expenses relating to the administration of the grant: A grantee may not use more than three percent (3%) of the grant amount received for expenses relating to administration of the grant (see 47 U.S.C. § 1723(d)(3)(D)(v)). The 3% limitation on administrative costs includes the combined total of indirect costs and direct administrative costs charged to an award. To identify if any expenses relating to the administration of the grant are included, please fill out columns C through E for each cost category in this summary page. Expenses related to the administration of the grant, both direct and indirect, should not be added to or subtracted from the total cost category in column B. The applicant must clearly describe in the budget narrative how it applied or calculated the 3% limitation on administrative costs.\n8. Expenses relating to subgrant evaluation: A grantee may not use more than 5 percent of the grant amounts received for expenses relating (directly or indirectly) to evaluate the efficacy of the efforts funded by subgrants (see 47 U.S.C. § 1723(d)(3)(D)(iv)). To identify if any expenses relating the evaluation of subgrant are included, please fill out columns F through H for each cost category in this summary page. Expenses related to the evaluation of subgrants, both direct and indirect, should not be added to or subtracted from the total cost category in column B. \n9. If indirect costs are included in the proposed budget, the applicant must provide a copy of the approved negotiated indirect cost rate agreement if this rate was negotiated with a cognizant federal agency or otherwise document those indirect costs consistent with 2 C.F.R. 200.414.\n10. The totals of ALL cost categories are rounded to the nearest dollar."]
[]
["SUMMARY OF BUDGET CATEGORY COSTS PROPOSED\nThe values in this summary table are from entries made in subsequent tabs; only blank white cells require data entry"]
["Category","Cost","Includes expenses relating to the administration of the grant? (Y/N)"," Expenses ($) relating to the administration of the grant \n(DIRECT COSTS)"," Expenses ($) relating to the administration of the grant \n(INDIRECT COSTS)","Includes expenses relating to subgrant evaluation? (Y/N)"," Expenses ($) relating to subgrant evaluation\n(DIRECT COSTS)"," Expenses ($) relating to subgrant evaluation\n(INDIRECT COSTS)","Comments (as needed)"]
["a. Total Personnel",{"$f":"'a. Personnel'!I21","v":0}]
["         Salary",{"$f":"'a. Personnel'!F21","v":0},null,0,0,null,0,0]
["         Fringe",{"$f":"'a. Personnel'!G21","v":0},null,0,0,null,0,0]
["b. Travel",{"$f":"'b. Travel'!J18","v":0},null,0,0,null,0,0]
["c. Equipment",{"$f":"'c. Equipment'!D18","v":0},null,0,0,null,0,0]
["d. Supplies",{"$f":"'d. Supplies'!D18","v":0},null,0,0,null,0,0]
["e. Contractual/Subawards",{"$f":"'e. Contractual-Subawards'!E45","v":0},null,0,0,null,0,0]
["f. Construction",{"$f":"'f. Construction'!B22","v":0},null,0,0,null,0,0]
["g. Other Direct Costs",{"$f":"'g. Other'!B17","v":0},null,0,0,null,0,0]
["Total Direct Costs",{"$f":"SUM(B14:B22)-(B15+B16)","v":0},null,{"$f":"SUM(D15:D22)","v":0},null,null,{"$f":"SUM(G15:G22)","v":0}]
[]
["h. Total Indirect Charges",{"$f":"'h. Indirect'!D21","v":0},null,null,{"$f":"SUM(E15:E22)","v":0},null,null,{"$f":"SUM(H15:H22)","v":0}]
["         Federal Funds",{"$f":"'h. Indirect'!E21","v":0}]
["         Non-Federal Funds",{"$f":"'h. Indirect'!F21","v":0}]
["Total Federal Costs",{"$f":"B23+B25","v":0},null,{"$f":"D23","v":0},{"$f":"E25","v":0},null,{"$f":"G23","v":0},{"$f":"H25","v":0}]
[]
["TOTAL PROJECT COSTS",{"$f":"B28","v":0},"Total expenses relating to the administration of the grant ($)",{"$f":"SUM(D28:E28)","v":0},null,"Total expenses relating to subgrant evaluation ($)",{"$f":"SUM(G28:H28)","v":0}]
[null,null,"Percent of expenses relating to the administration of the grant ($)",{"$f":"IFERROR(D30/B30,0)","v":0},null,"Percent of expenses relating to subgrant evaluation ($)",{"$f":"IFERROR(G30/B30,0)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"a. Personnel","index":2,"n_rows":23,"n_cols":10,"rows_kept":23,"cut":false,"hidden":false,"merged":[[22,0,23,9],[1,0,1,9],[2,0,3,9],[20,0,20,4]]}
[]
["a. Personnel"]
["INSTRUCTIONS\n1. List project costs solely for employees of the grantee.  All personnel costs for subrecipients and contractors must be included under e. Contractual- Subawards. \n2. All personnel should be identified by position title and not employee name. Enter the level of effort (e.g., hours for hourly employees, number of months for monthly, etc.), select the unit from the drop down menu, enter the unit cost, fringe benefits and the total direct personnel compensation will automatically calculate. \n3. Personnel cannot exceed 100% of their time on all active projects (including other Federal awards or work unrelated to the State Digital Equity Capacity Grant Program).\n4. If loaded labor rates are utilized, a description of the costs the loaded rate is comprised of must be included in the Additional Explanation section below. NIST/DOC must review all components of the loaded labor rate for reasonableness and unallowable costs (e.g., fee or profit). \n5. Fringe benefits are allowances and services provided to employees as compensation in addition to regular salaries and wages. The rates and how they are applied should not be averaged to get one fringe cost percentage. Complex calculations should be described/provided in the Additional Explanation section below. \n6. The fringe benefit rates should be applied to all positions, regardless of whether those funds will be supported by Federal Share or Recipient Cost Share."]
[]
[]
["Position Title","Key Personnel","Level of Effort","Unit","Unit Cost","Subtotal Salary","Fringe Benefits","Fringe Rate","Total ","Justification of Need"]
["Example: Grant Manager","Yes",4,"Annual",80000,{"$f":"C7*E7","v":320000},112000,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":0.35},{"$f":"SUM(F7:G7)","v":432000},"The Grant Manager will be responsible for completing Digital Equity Capacity grant reports; archiving grant-related documents and documentation; preparing for, and supporting, any activities related to grant monitoring, audit or compliance requests; compiling, reconciling, and managing the submission of subgrantee reports and documents. \n\nThe fringe benefit rate of the Grant Manager is expected to be 35% of the salary charges. Fringe benefits for this position include health and dental care, life insurance, long-term disability, retirement, workers compensation, and agency personnel charges.\n\nThese costs are expected to be used for the administration of the grant."]
["Example: Digital Navigators","No",200,"Hour",150,{"$f":"C8*E8","v":30000},0,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":0},{"$f":"SUM(F8:G8)","v":30000},"The Digital Navigators will be responsible for providing group assistance to Covered Populations regarding internet connectivity services information that can enhance their livelihood. The Digital Navigator is expected to be dedicated on a part-time basis totaling 200 hours (approximately 20 hours a week for 10 weeks) throughout the Subgrantee Selection Process.\n\nThe hourly rate is inclusive of fringe benefits."]
["Example: Legal Services","No",300,"Hour",300,90000,0,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":0},90000,"The legal services will be conducted by in-house legal staff at the State Broadband Office. The costs include drafting, execution, and filing fees of legal agreements and Memorandum of Understandings (MOUs) between organizations involved in the grant, including subgrantees. Legal hours also include time to conduct legal reviews for all contracts. \n\nThe hourly rate is inclusive of fringe benefits.\n\nThese costs are expected to be used for the administration of the grant."]
[null,null,null,null,null,{"$f":"C10*E10","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F10:G10)","v":0}]
[null,null,null,null,null,{"$f":"C11*E11","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F11:G11)","v":0}]
[null,null,null,null,null,{"$f":"C12*E12","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F12:G12)","v":0}]
[null,null,null,null,null,0,null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},0]
[null,null,null,null,null,0,null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},0]
[null,null,null,null,null,0,null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},0]
[null,null,null,null,null,{"$f":"C16*E16","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F16:G16)","v":0}]
[null,null,null,null,null,{"$f":"C17*E17","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F17:G17)","v":0}]
[null,null,null,null,null,{"$f":"C18*E18","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F18:G18)","v":0}]
[null,null,null,null,null,{"$f":"C19*E19","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F19:G19)","v":0}]
[null,null,null,null,null,{"$f":"C20*E20","v":0},null,{"$f":"Table8[[#This Row],[Fringe Benefits]]/Table8[[#This Row],[Subtotal Salary]]","v":{"$error":"#DIV/0!"}},{"$f":"SUM(F20:G20)","v":0}]
["TOTAL PERSONNEL",null,null,null,null,{"$f":"SUM(F10:F20)","v":0},{"$f":"SUM(G10:G20)","v":0},null,{"$f":"SUM(I10:I20)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"b. Travel","index":3,"n_rows":20,"n_cols":11,"rows_kept":20,"cut":false,"hidden":false,"merged":[[19,0,20,10],[2,0,2,10],[17,0,17,7],[1,0,1,10]]}
[]
["b. Travel"]
["INSTRUCTIONS\n1.  Examples of Purpose of Travel are subrecipient site visits, DOC meetings, project mgmt. meetings, etc. Examples of Basis for Estimating Costs are past trips, travel quotes, GSA rates, etc.\n2.  All listed travel must be necessary for performance of the project. \n3. Only travel that is directly associated with this award should be included as a direct travel cost to the award.\n4. Federal travel regulations are contained within the applicable cost principles for all entity types.\n5. Travel costs should remain consistent with travel costs incurred by an organization during normal business operations as a result of the organizations written travel policy. In absence of a written travel policy, organizations must follow the regulations prescribed by the General Services Administration (GSA). \n6. Columns B-I are per trip.\n7. The number of days is inclusive of day of departure and day of return.\n8. Funds requested in the travel category should be only for project staff. Travel for consultants/contractors should be shown in the “Contract” cost category along with consultant/contractor fees. Because these costs are associated with contract-related work, they must be under the “Contract” cost category.                                                                                                                                                                                                                                                                                                                                                                                                                                                                               "]
[]
["Purpose of Travel / Justification of Need","No. of Days","No. of Travelers","Lodging per Traveler / per night","Flight per Traveler","Vehicle per Traveler","Per Diem Per Traveler","Mileage","Miscellaneous","Cost per Trip","Basis for Estimating Costs"]
["Example: Digital Literacy Training\n\nFunds are requested for X Office staff to travel to Y city for the Digital Literacy Training series kick-off.\n\nRequesting mileage estimated at 250 miles at $.585 per mile.",4,2,180,500,100,80,59,60,{"$f":"(((B6-1)*D6)*C6)+(C6*E6)+(C6*F6)+((C6*G6)*B6)+H6+I6","v":3039},"Current GSA rates"]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,{"$f":"(((B15-1)*D15)*C15)+(C15*E15)+(C15*F15)+((C15*G15)*B15)+H15+I15","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"(((B16-1)*D16)*C16)+(C16*E16)+(C16*F16)+((C16*G16)*B16)+H16+I16","v":0}]
[null,null,null,null,null,null,null,null,null,0]
["TOTAL TRAVEL",null,null,null,null,null,null,null,null,{"$f":"SUM(J7:J17)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"c. Equipment","index":4,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,0,2,5],[19,0,20,5],[17,0,17,2],[1,0,1,5]]}
[]
["c. Equipment"]
["INSTRUCTIONS\n1. Equipment means a single item of tangible, personal property (including information technology systems) having a useful life of more than one year and a per-unit acquisition cost which equals or exceeds the lesser of the capitalization level established by the non-Federal entity for financial statement purposes, or $5,000. Please refer to the applicable Federal regulations in 2 CFR 200.1 and 2 CFR 200.313 for specific equipment definitions and treatment. \n2. Do not include supply items under equipment.  Please refer to 2 CFR 200.1 and d. Supplies on what constitutes a supply item.\n3. List all equipment below, providing a basis of cost (e.g. contractor quotes, catalog prices, prior invoices, etc.). Briefly justify items as they apply to the project. \n4. Any equipment that is leased must be listed under tab g. Other and not under c. Equipment.  "]
[]
["Equipment Item","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Example:  Lexmark Laser All-In-One Printer",1,13699,{"$f":"B6*C6","v":13699},"Online Cost Comparison","The high-capacity printer is needed to support the State Broadband Office. Cost comparisons across eligible vendors of renting for a period of five years or purchasing demonstrated that purchasing is more cost effective. The proposed cost was the best value among eligible vendors and included a warranty covering maintenance costs for a period of five years.\n\nThese costs are expected to be used for the administration of the grant."]
[null,null,null,{"$f":"B7*C7","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B15*C15","v":0}]
[null,null,null,{"$f":"B16*C16","v":0}]
[null,null,null,0]
["TOTAL EQUIPMENT",null,null,{"$f":"SUM(D7:D17)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"d. Supplies","index":5,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,1],[2,0,2,5],[19,0,20,5],[1,0,1,5],[17,0,17,2]]}
[]
["d. Supplies"]
["INSTRUCTIONS\n1. Supplies are generally defined as an item with an acquisition cost of $5,000 or less and a useful life expectancy of less than one year.  Supplies are generally consumed during the project performance. Please refer to the applicable Federal regulations in 2 CFR 200.1 and 2 CFR 200.314 for specific supplies definitions and treatment. A computing device is a supply if the acquisition cost is less than the lesser of the capitalization level established by the non-Federal entity for financial statement purposes or $5,000, regardless of the length of its useful life.\n2. List all proposed supplies below, providing a basis of costs (e.g. contractor quotes, catalog prices, prior invoices, etc.). \n3. Briefly justify the need for the Supplies as they directly apply to the project. Note that Supply items must be direct costs to the project at this budget category, and not duplicative of supply costs included in the indirect pool that is the basis of the indirect rate applied for this project. Supply costs must be allocable specifically to the project."]
[]
["General Category of Supplies","Qty","Unit Cost         ","Total Cost             ","Basis of Cost","Justification of need"]
["Example: Two (2) 15\" laptop computers ",2,1000,{"$f":"B6*C6","v":2000},"Catalog price (based on online search)","The laptop computers are needed for the Device Distribution program to carry out State's efforts \n\nThese costs are expected to be used for the participants of the grant."]
["Example: General office supplies",36,150,{"$f":"B7*C7","v":5400},"Catalog price (based on online search). Items expected to include pens, paper, staples, sticky notes, etc. for approximately five (5) people. Unit cost is monthly.","General office supplies are needed to carry out the work of the Digital Capacity Grant Program (i.e., reporting requirements) during the period leading up to the submission of the Final Proposal and throughout the period of performance. \n\nThese costs are expected to be used for the administration of the grant."]
[null,null,null,{"$f":"B8*C8","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,{"$f":"B11*C11","v":0}]
[null,null,null,0]
[null,null,null,{"$f":"B13*C13","v":0}]
[null,null,null,{"$f":"B14*C14","v":0}]
[null,null,null,{"$f":"B15*C15","v":0}]
[null,null,null,{"$f":"B16*C16","v":0}]
[null,null,null,0]
["TOTAL SUPPLIES",null,null,{"$f":"SUM(D8:D17)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"e. Contractual-Subawards","index":6,"n_rows":47,"n_cols":15,"rows_kept":47,"cut":false,"hidden":false,"merged":[[5,5,5,9],[2,0,2,9],[1,0,1,9],[25,7,25,9],[46,0,47,4],[25,0,25,3],[42,0,42,3],[44,0,44,3],[5,0,6,0],[5,2,6,2],[5,3,6,3],[5,4,6,4],[5,1,6,1],[27,0,27,4],[4,0,4,4]]}
[]
["e. Contractual/Subawards"]
["INSTRUCTIONS\n1. The eligible entity must provide all costs related to subrecipients and contractors in the applicable boxes below. For each cost related to subrecipients and contractors, indicate the Project ID from the list of Specific Projects that the cost is associated with. Refer to 2 C.F.R. 200.331 for subrecipient and contractor determinations.\n2. Subrecipients (sub-awardees): A subrecipient is a legal entity to which a subaward is made, who has performance measured against whether the objectives of the Federal program are met, is responsible for programmatic decision making, must adhere to applicable Federal program compliance requirements, and uses the Federal funds to carry out a program of the organization. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status.\n3. Contractors: A contractor is a legal entity contracted to provide goods and services within normal business operations, provides similar goods or services to many different purchasers, operates in a competitive environment, provides goods or services that are ancillary to the operation of the Federal program, and is not subject to compliance requirements of the Federal program. All characteristics may not be present and judgment must be used to determine subrecipient vs. contractor status. List all contractors supplying commercial supplies or services used to support the project. \n4. In determining whether an agreement between a pass-through entity and another non-Federal entity casts the latter as a subrecipient or a contractor, the substance of the relationship is more important than the form of the agreement. Please refer to 2 CFR 200.331 Subrecipient and contractor determinations for more information on making a determination on subrecipient vs contractor.\n5. Justification of Need: Proper budget justifications should explain how the costs associated with each line item relate to the implementation of the project as outlined in the proposal being submitted. Justifications should be concise and be written in such a way that someone not specifically familiar with the project can conceptually understand the rational, purpose and calculation of the anticipated costs identified. Explain why items are essential in relation to the aims of the project as well as meeting the goals of the project. Do not merely restate the proposed expenditure. The specific items in the subrecipient budget(s) should not be explained here.\n6. Construction contracts/subawards: In the basis of cost and breakdown, provide information such as engineering estimates, fees, permits, prior construction, etc., and briefly justify its need as it applies to the project.\n7. Subrecipient Cost Share/Matching: Please provide any cost share/matching that is being provided by a subrecipient. Contractors may not provide cost share.  Any partial donation of goods or services by a contractor is considered a discount and is not allowable."]
[]
["SUBRECIPIENTS"]
["Project ID","Subrecipient\nName / Organization","Justification of Need","Basis of Cost and Breakdown","Subrecipient Costs","Subrecipient Cost Share / Matching"]
[null,null,null,null,null,"Is Cost Share / Matching being provided?","Value ($)","Type (Cash or In Kind) ","Source","If Federal source, which Program?"]
["Example: [State]-Capacity Grant Project-01","To be determined","The State Broadband Office certifies that it has a plan to meet the unserved and underserved location blank commitments, which is outlined in the DE Plan. It can do so for less than its total Digital Equity Capacity allocation and will thus have Digital Equity funds leftover to use for blank purposes. A sub-recipient(s) to be determined will carry out eligible non-deployment uses of internet access, as identified in the Digital Equity Capacity Grant NOFO, SectionX--specifically to provide devices to 1,000 participants. The subrecipient(s) will carry out these activities following the Subgrantee Selection process, which are outlined in the NOFO.","Based on the DE Plan, and as outlined in the NOFO, the cost of conducting the program is based on the cost of internet-capable devices (inclusive of software and accessories, according to an online search) and associated programmatic implementation costs (e.g., communications and marketing, distributions, etc.).",2000000,"No"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SUBTOTAL SUBRECIPIENTS",null,null,null,{"$f":"SUM(E9:E21)","v":0},null,{"$f":"SUM(G9:G21)","v":0}]
[]
["CONTRACTORS"]
["Project ID","Contractor\nName / Organization","Justification of Need","Basis of Cost and Breakdown","Contractor Costs",null,null,null,null,null,null,null,null,null,"ANCHOR"]
["Example: [State]-Capacity Grant Project-02","ABC Corporation","ABC Corporation will implement the Challenge Process outlined in the Initial Proposal. All final products will be owned by the State Broadband Office, not the consulting firm. The services are expected to be provided within three (3 months) of award in order for the State Broadband Office to begin the Subgrantee Selection Process. ","ABC Corporation was selected following a competitive review process in line with the State Broadband Office procurement policy. The contract amount is and will be inclusive of staff, travel, supplies, and all other costs necessary to meet the goals of the contract. The basis of the cost is estimated by the contractor at approximately 1,250 hours at $400/hour.",500000]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["SUBTOTAL CONTRACTORS",null,null,null,{"$f":"SUM(E31:E39)","v":0}]
[]
["TOTAL CONTRACTUAL/SUBAWARDS",null,null,null,{"$f":"E26+E43","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"f. Construction","index":7,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,3],[2,0,2,3],[23,0,24,3]]}
[]
["f. Construction"]
["INSTRUCTIONS\n1. Construction for the purpose of budgeting, is defined as the construction of new buildings, completion of shell space in existing buildings, renovation or rehabilitation of existing buildings, and construction or development of real property infrastructure improvements (e.g., site preparation, utilities, streets, curbs, sidewalks, parking lots, other streetscaping improvements, etc.). \n2. Any construction work that is performed by a contractor or subrecipient should be entered under e. Contractual-Subawards.\n3. List all proposed non-deployment construction being proposed to be undertaken directly by the eligible entity below, providing a basis of cost such as engineering estimates, prior construction, etc., and briefly justify its need as it applies to the project."]
[]
["General Description","Cost             ","Basis of Cost","Justification of need"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL CONSTRUCTION",{"$f":"SUM(B6:B18)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"g. Other","index":8,"n_rows":19,"n_cols":4,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,3],[18,0,19,3],[2,0,2,3]]}
[]
["g. Other Direct Costs"]
["INSTRUCTIONS\n1. Other direct costs are direct cost items required for the project which do not fit clearly into other categories.  These direct costs must not be included in the indirect costs (for which the indirect rate is being applied for this project).  Examples are: tuition, printing costs, etc. which can be directly charged to the project and are not duplicated in indirect costs (overhead costs).\n2. Basis of cost are items such as contractor quotes, prior purchases of similar or like items, published price list, etc.\n3. Contingency is that part of a budget estimate of future costs (typically of large IT projects or other items as approved by the Federal awarding agency) which is associated with possible events or conditions arising from causes the precise outcome of which is indeterminable at the time of estimate, and that experience shows will likely result, in aggregate, in additional costs for the approved activity or project. Amounts for major project scope changes, unforeseen risks, or extraordinary events may not be included. Amounts must be estimated using broadly-accepted cost estimating methodologies and accepted by the Federal awarding agency. Contingency costs are reserved until a demonstrated need is approved by the Grants Officer. Please refer to 2 CFR 200.433 for more information."]
[]
["General Description"," Cost             ","Basis of Cost","Justification of need"]
["Example: Project Management Training for State Broadband Office Staff",7200,"Catalog price (based on online search)","Project Management Training conducted by XYZ Corporation is requested to pay for three staff working full-time on the Digital Equity Capacity Grant Program (i.e., Grant Manager, State Broadband Office Director, and Procurement Specialist). The training will cover project management areas necessary for the successful implementation and oversight of the Digital Equity Capacity Grant Program. \n\nThese costs are expected to be used for the administration of the grant."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["TOTAL OTHER DIRECT COSTS",{"$f":"SUM(B7:B13)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"h. Indirect","index":9,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,0,0,3],[1,0,1,6],[2,0,2,6],[22,0,23,6],[20,0,20,2]]}
[]
["h. Indirect Costs"]
["INSTRUCTIONS\n1. Indirect (facilities & administrative (F&A)) costs means those costs incurred for a common or joint purpose benefitting more than one cost objective, and not readily assignable to the cost objectives specifically benefitted, without effort disproportionate to the results achieved. See 2 C.F.R. 200.1\n2. Indirect costs may be charged to the award if, the applicant has a Federally approved indirect cost rate or the applicant has never received a negotiated indirect cost rate and elects to charge a de minimis rate of 10 percent of modified total direct costs (MTDC), which can be used indefinitely. MTDC means all direct salaries and wages, applicable fringe benefits, materials and supplies, services, travel, and up to the first $25,000 of each subaward (regardless of the period of performance of the subawards under the award). MTDC excludes equipment, capital expenditures, charges for patient care, rental costs, tuition remission, scholarships and fellowships, participant support costs and the portion of each subaward in excess of $25,000. See 2 C.F.R. 200.1.\n3. Indirect costs that are related to the administration of the Eligible Entity's grant count toward the statutory three percent cap. By their nature, indirect costs are those recipient costs that are not directly associated with the recipient’s execution of its grant-funded project, but that are necessary to the operation of the organization and the performance of its programs. A grantee should describe the types of indirect costs that it will charge to the grant. A grantee can never double-charge a cost as both a direct and an indirect administrative cost. The budget provided by the Eligible Entity must explain how they will account for direct and indirect personnel costs charged to the grant with the statutory three percent cap. It is the Eligible Entity’s responsibility to determine whether their indirect costs include such expenses subject to the cap, and account for them appropriately.  The Eligible Entity must document such accounting, and make it available to NTIA and NIST if requested.\n4. Fill out the table below to indicate how your indirect costs are calculated. \n5. The rates and how they are applied should not be averaged to get one indirect cost percentage. Complex calculations or rates that do not do not correspond to the below categories should be described/provided in the Additional Explanation section below. If questions exist, consult with your DOC contact before filling out this section. \n6. The indirect rate should be applied to the total request for funding, including both the Federal Share and Recipient’s Voluntary Committed Cost Share (if any).                                                                                                                                                                                                                                                                                                                                                                   \n7. NOTE: A Recipient may not claim \"unrecovered indirect costs\" as a Cost Share contribution (see 2 CFR 200.306(c)). Regardless of how the Eligible Entity calculates its indirect costs, it may not exceed the statutory three percent cap on administrative costs for both direct and indirect costs combined."]
[]
["Rate Period","Indirect Cost Base ($)","Indirect Cost Rate (%)","Total Indirect Costs ($)","Amount ($) of Indirect Costs covered by Federal Funds","Amount ($) of Indirect Costs covered by Non-Federal Funds","Explanation of Indirect Cost Base "]
["Example: Period of Performance",1123090,0.1,{"$f":"B6*C6","v":112309},112309,0,"The Eligible Entity does not have a Federally approved indirect costs rate and elects to charge a de minimis rate of 10 percent of modified total direct costs (MTDC).\n\nIndirect Cost Base of the MTDC is based on the following Tabs: Personnel ($552,000); Travel ($12,190); Supplies ($8,900); Contractual-Subawards (2 Subawards totaling $50,000 and $500,000 contracts)"]
["Example: 05/01/2024 - 12/31/2026",600000,0.56000000000000005,{"$f":"B7*C7","v":336000.00000000006},300000,36000,"Cost base is based on negotiated rate agreement and includes Labor, Fringe, Travel, and Other."]
[null,null,null,{"$f":"B8*C8","v":0}]
[null,null,null,{"$f":"B9*C9","v":0}]
[null,null,null,{"$f":"B10*C10","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["TOTAL INDIRECT COSTS",null,null,{"$f":"SUM(D8:D16)","v":0},{"$f":"SUM(E8:E16)","v":0},{"$f":"SUM(F8:F16)","v":0}]
[]
["Additional Explanation (as needed):"]

{"sheet":"List","index":10,"n_rows":8,"n_cols":22,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Hour",null,"Cash",null,"Domestic",null,"Yes",null,"Personnel",null,"Yes",null,"Deduction",null,"Federal",null,"Yes",null,"Yes","Cash","Federal","American Rescue Plan Act (ARPA)"]
["Month",null,"In Kind",null,"International",null,"No",null,"Travel",null,"No",null,"Addition",null,"Non-Federal",null,"No",null,"No","In Kind","State","CARES Act"]
["Annual",null,null,null,null,null,null,null,"Equipment",null,null,null,"Cost Sharing or Matching",null,null,null,null,null,"TBD","Combination of both Cash & In Kind (explanation is provided under Additional Explanation)","Local","Consolidated Appropriations Act (CAA)"]
[null,null,null,null,null,null,null,null,"Supplies",null,null,null,"Other (explanation is provided under Additional Explanation)",null,null,null,null,null,null,"TBD","Other","ReConnect Loan and Grant Program"]
[null,null,null,null,null,null,null,null,"Contractual",null,null,null,null,null,null,null,null,null,null,null,"TBD","Families First Coronavirus Response Act (FFCRA)"]
[null,null,null,null,null,null,null,null,"Construction",null,null,null,null,null,null,null,null,null,null,null,null,"TBD"]
[null,null,null,null,null,null,null,null,"Subaward"]
[null,null,null,null,null,null,null,null,"Other"]