jagomart
digital resources
picture1_Budget Spreadsheet 41371 | Aflp Rfa 20 10014 Attachment8


 177x       Filetype XLSX       File size 0.05 MB       Source: www.cdph.ca.gov


File: Budget Spreadsheet 41371 | Aflp Rfa 20 10014 Attachment8
sheet 1 budget overview aflp rfa 2010014 proposed budget overview the aflp guide to proposed budget development budget is intended to provide basic instructions for completing the aflp rfa proposed ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
Sheet 1: Budget Overview
AFLP RFA # 20-10014 Proposed Budget Overview
The AFLP Guide to Proposed Budget Development budget is intended to provide basic instructions for completing the AFLP RFA Proposed Budget Template for FY 20-21, 21-22, and 22-23. Agencies selected for award will develop a revised budget in conjunction with their assigned MCAH/AFLP Program Consultant and Contract Manager.

The Proposed "Total Costs" (Cell D61) reflect the total amount proposed for possible funding under Title V. Any optional funds, whether unmatched agency funds (Cell D63) or matched agency funds (Cell D64) or Title XIX requested funds (Cell D65), may be reported below the proposed budget and must fit within the funding range outlined in Part I, Table 1, for the proposed program size.

Cells that may be completed by the agency are described in the Budget Development Guide. Additionally, cells are color coded to identify those that may be filled or are auto-populated. Cells shown in tan highlights are fields for manual data entry while those shown in green highlights will auto-populate.

Annual Cost and Total Costs will auto-populate as items on the budget are updated; however, it is the responsibility of the Applicant to validate the totals. All fields are required to have a budgeted amount, unless indicated they are optional.

Sheet 2: Budget Development Guide
Item Location / Cell(s) Instructions
Agency Name Cell A4 Enter the agency name on each budget sheet.
Personnel Cell A5 Follow the guidance in Part III, H of the RFA regarding required staffing pattern, qualities and minimum requirements. Insert each staff's annual salary and FTE%.
AFLP Position Rows 6 through 23 Complete one row per staff on the proposed budget following required staffing pattern in Part III, H of the RFA. Case Manager positions must be a minimum of halftime FTE. Ten case manager rows are embedded in the template in the event of ten halftime positions. Only populate the rows needed for each budgeted staff; it is okay to leave blank rows that are not needed. Two rows, 22 and 23, are available for non-listed positions. In Cell A22, enter the title or brief description of the first non-listed position. Report a second non-listed position in Cell A23. Refer to Part IX, C, 1 of the RFA for additional details. Do not list any in-kind staff in this section.
Other Position (optional) - please describe Cell A22 and A23 Two rows are available for non-listed positions and may be left blank. To report a non-listed position, in Cell A22, enter the title or brief description. Report a second non-listed position in Cell A23. Refer to Part IX, C, 1 of the RFA for additional details.
Annual Salary Cells B6 through B23 List the annual salary amount for each position based on full time employment (FTE). Use the CalHR Civil Service classifications and pay scales as a guide on salary limitations. CDPH/MCAH reserves the right to seek additional information and limit salary reimbursement to levels that are comparable to those of Civil Service employees. Refer to Part IX, C, 1b of the RFA for additional details.
Fulltime Equivalent (FTE) Cells C6 through C23 Indicate the FTE or annual percentage of time for each position (i.e. full time = 100%, 1/2 time = 50%, 3/4 time = 75%, 1/4 time = 25%. Refer to Part IX, C, 1a of the RFA for additional details.
Annual Cost Cell D6 through D23 The annual cost is calculated based on the annual salary multiplied by the FTE. The Annual Cost field auto-populates; however, it is the responsibility of the Applicant to validate the total.
Total Salaries Cell D24 The total salary is the sum of the annual cost of all positions. The total salary field auto-populate; however, it is the responsibility of the Applicant to validate the total.
Fringe Benefits Rate as a Percentage of Total Salaries Cell C25 Insert your agency's fringe benefit rate as a percentage. Refer to Part IX, C, 1c of the RFA for additional details.
Fringe Benefits Expense Cell D26 Fringe Benefits Expense is calculated based on the total salary multiplied by the fringe benefit rate. The field will auto-populate; however, it is the responsibility of the Applicant to validate the total.
Total Salaries and Fringe Benefits Cell D27 Total Salaries and Fringe benefit is the sum of the total salary plus the fringe benefits expense. This field will auto-populate; however, it is the responsibility of the Applicant to validate the total.
Operating Expenses Cell A29 Refer to Part IX, C, 2 of the RFA for additional details.
Travel - MCAH-Sponsored Trainings and Events Cell D30 Includes travel for CDPH/MCAH-sponsored trainings and events, excluding participants which is reported in Other Costs/Other Charges/Participant Travel/Transportation. Refer to Part III, C, 2 and IX, C, 2a and Table 14 of the RFA for required trainings and events. Indicate the total cost for travel and per diem. Include costs for expenses such as airfare, car rental, mileage reimbursement, parking, toll bridge fees, taxicab fares, overnight lodging and meal expenses, etc. Travel costs should be per guidelines set forth at CalHR - Travel Reimbursements. Note: All participant travel is budgeted under the Other Costs Part.

https://www.calhr.ca.gov/employees/Pages/travel-reimbursements.aspx
Travel - Other Cell D31 Includes all travel other than travel to MCAH-Sponsored Trainings and Events and participant travel. Examples include travel for purposes such as case management, outreach, local collaboratives, or local trainings. Indicate the total cost for travel and per diem. Include costs for expenses such as airfare, car rental, mileage reimbursement, parking, toll bridge fees, taxicab fares, overnight lodging and meal expenses, etc. Travel costs should be per guidelines set forth at CalHR - Travel Reimbursements. Note: All participant travel is budgeted under the Other Costs Part.

https://www.calhr.ca.gov/employees/Pages/travel-reimbursements.aspx
Training Cell D32 Includes registration and speaker fees for local AFLP staff training. Refer to Part III. C, 2 and IX, C, 2 of the RFA for additional details.
Rent/Lease Cost Per Square Foot (Not to Exceed $3) Cell C33 Rent/Lease Expense is optional. Enter the cost per square foot, not to exceed $3 per square foot, of renting or leasing office space (e.g. rent, utilities, janitorial, security, property taxes and insurance).
Rent/Lease Expense (Optional) Cell C34 The maximum allowable rent/lease amount is auto-populated based on the total FTE x 200 per square foot x the cost per foot x 12 months in Cell C33. Under state standards, it is permissible to reimburse up to a maximum of 200 square feet of office space per FTE at the MCAH rate of $3.00. Refer to Part IX, C, 2e of the RFA for additional details.
Rent/Lease Expense (Optional) Cell D34 Rent/Lease Expense is optional. Enter the cost of renting/leasing office space as described in Cell C33. Cell C34 auto-populates the rent/lease expense. To report the full allowable amount, which is actual cost per square foot (not to exceed $3) x FTE x 200 x 12 months, enter the amount in Cell C34 in this cell. If rent is covered by other means, you can enter a lower amount or leave blank.
General Expense Cell D35 Includes materials such as files for youth charts, duplication of program materials for staff and program participants, and ordering and shipping for additional resource/material necessary for educational purposes. Refer to Part IX, C, 2d of the RFA for additional details.
Audit Fees (Optional) Cell D36 Includes the cost of the mandatory financial audit by an independent auditor at the end of each fiscal year can be included in the budget, up to the proportionate amount of the Agreement, in accordance with 2 CFR Part 200 Part 400.425. This field is optional. Refer to Part IX, C, 2f of the RFA for additional details.
Communications / Software Cell D37 Includes costs associated with use of the internet, electronic mail (Outlook), scanning equipment, telephones and computers with current versions of Adobe Professional 11 and the Microsoft Office 2010 Professional Suite (Word, Excel, Access and PowerPoint). Refer to Part IX, C, 2g of the RFA for additional details.
Equipment (Optional) Cell D38 Minor equipment is defined as a tangible or intangible item with a base unit (and needed peripherals to operate the unit) cost less than $4,999 and a life expectancy of one (1) year or more that is purchased or reimbursed with Agreement funds. This field is optional. Refer to Part IX, C, 2h of the RFA for additional details.
Total Operating Expenses Cell D39 This field will auto-populate; however, it is the responsibility of the Applicant to validate the total.
Capital Expenditures (Optional) Cell A41 Refer to Part IX, C, 3 of the RFA for guidance regarding Capital Expenses.
Capital Expenditure description Cell A42 This field is for items greater than $5,000. This field is optional and likely to be left blank. If completed, enter a brief description of the item recommended for purchase and list the cost in Cell D42. Refer to Part IX, C, 3 of the RFA for additional details.
Capital Expense (Optional) Cell D42 If A42 is complete, enter the Capital Expense. Refer to Part IX, C, 3 of the RFA for additional details.
Total Capital Expenditures Cell D43 This field is for items greater than $5,000. This field is optional and likely to be left blank. If Cell A42 is completed, list the capital expense cost in Cell D42. Refer to Part IX, C, 3 of the RFA for additional details.
Other Costs Cell A45 Refer to Part IX, C, 4 of the RFA for additional details.
Subcontract (Optional) Cell D46 If proposing a sub-contract, include the total amount here. Otherwise, this field is optional. Refer to Part IX, C, 4a of the RFA for additional details.
Other Charges - Educational Materials (Not Matchable) Cell D47 Includes the cost of creating and duplicating program tools or resources for participants. Refer to Part IX, C, 4b of the RFA for additional details.
Other Charges - Outreach Materials Cell D48 Includes the cost of creating and duplicating outreach material. Refer to Part IX, C, 4b of the RFA for additional details.
Other Charges - Concrete Supports Cell D49 Refer to Part VIII, B, Use of Funds of the RFA for details. Incentives - gift cards must not be used for Alcohol or Tobacco products and an agreement with the vendor must be made indicating that any unredeemed value will be returned to the funded agency within an agreed upon and reasonable timeframe.
Other Charges - Participant Travel / Transportation Cell D50 Includes travel or transportation costs related directly to transporting program participants for AFLP program activities or other activities. Examples include providing participants with bus tokens/passes, and rides to non-AFLP appointments. Refer to Part IX, C, 4b of the RFA for additional details.
Total Other Costs Cell D51 This field will auto-populate; however, it is the responsibility of the Applicant to validate the total.
Total Direct Costs Cell D53 This field will auto-populate; however, it is the responsibility of the Applicant to validate the total.
Indirect Costs Cell A55 Applicants should follow the guidance in Part IX, C, 5 of the RFA regarding allowable indirect cost rates allowed for their agency. Based on the guidance outlined in the RFA, complete the appropriate option on the template, with the allowable percentage. Based on their CDPH Indirect Cost Rate, Counties and Local Health Jurisdictions will choose their ICR basis and enter their rate either Cell I57 for percent of total allowable direct cost, or Cell I58 for percent of total personnel cost. Community Based Organizations will complete Cell I59. The "Total Indirect Cost will auto-populate.

https://www.cdph.ca.gov/Programs/CFH/DMCAH/Pages/Indirect-Cost-Rate.aspx
Indirect Costs - Counties and Local Health Jurisdictions Cell C57 For Counties and Local Health Jurisdictions with ICRs based on total allowable direct cost, enter the indirect cost rate. Cell D57 will auto-populate the total annual cost. Leave blank cells C58, C59, D58, D59. Refer to Part IX, C, 5 of the RFA for additional details.
Indirect Costs - Counties and Local Health Jurisdictions Cell D57 Cell D57 will auto-populate the total annual cost based on Cell C57; however, it is the responsibility of the Applicant to validate the total.
Indirect Costs - Counties and Local Health Jurisdictions Cell C58 For Counties and Local Health Jurisdictions with ICRs based on total personnel cost, enter the indirect cost rate. Cell D58 will auto-populate the total annual cost. Leave blank cells C57, C59, D57, D59. Refer to Part IX, C, 5 of the RFA for additional details.
Indirect Costs - Counties and Local Health Jurisdictions Cell D58 Cell D58 will auto-populate the total annual cost based on Cell C58; however, it is the responsibility of the Applicant to validate the total.
Indirect Costs - Community Based Organizations Cell C59 Community Based Organizations will enter their indirect cost rate not to exceed 15% of total personnel cost. Leave blank cells C57, C58, D57, D58. Refer to Part IX, C, 5 of the RFA for additional details.
Indirect Costs - Community Based Organizations Cell D59 Cell D59 will auto-populate the total annual cost based on Cell C59; however, it is the responsibility of the Applicant to validate the total.
Total Indirect Costs Based on Methodology 1, 2 or 3 Cell D60 Cell D60 will auto-populate; however, it is the responsibility of the Applicant to validate the total.
Total Costs Cell D61 Cell D61 will auto-populate; however, it is the responsibility of the Applicant to validate the total.
In Kind or Unmatched Agency Funds (Optional) Cell D63 Applicants providing local Agency Funds for their program (not for Title XIX purposes) should indicate it here. This field is optional.
Matched Agency Funds (Optional) Cell D64 Applicants selecting to draw down Title XIX must indicate the amount of non-federal agency funds they will contribute. For all other applicants, this field is optional. Refer to Part I, F, 2 of the RFA for more details.
Title XIX Requested (Optional) Cell D65 Applicants interested in drawing down Title XIX must indicate the amount they would like to request and must populate the field "Agency Funds - Matched" to indicate the amount of non-federal funds available for matching.

Title XIX FFP allows eligible entities to draw down federal reimbursement for activities related to assisting Medi-Cal eligible individuals with enrolling in Medi-Cal and assisting individuals on Medi-Cal with accessing services.

Agencies that select to utilize Title XIX FFP must follow requirement of the Social Security Act (SSA) Section 1903(a)(2)(A) and Title 42 Code of Federal Regulations (CFR) Sections 432.2 and 432.50 provide for variable federal reimbursement rates for the administrative functions of the Medicaid (Title XIX) program.

Sheet 3: FY 20-21
Adolescent Family Life Program


Budget (Year 1)


07/01/20 through 06/30/21


Enter Agency Name


Personnel


AFLP Position Annual Salary FTE % Annual Cost
Project Director $-
$0
Coordinator (Optional) $-
$0
Supervisor $-
$0
Data Entry (Optional) $-
$0
Youth Advisor (Optional) $-
$0
Case Manager $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Case Manager (Optional) $-
$0
Other Position (Optional) - Please Describe $-
$0
Other Position (Optional) - Please Describe $-
$0
Total Salaries blank blank $0
Fringe Benefits Rate as a Percentage of Total Salaries blank
blank
Fringe Benefits Expense blank blank $0
Total Salaries and Fringe Benefits blank blank $0
blank blank blank blank
Operating Expenses blank blank blank
Travel - MCAH-Sponsored Trainings and Events blank blank $0
Travel - Other blank blank $0
Training blank blank $0
Rent/Lease Cost Per Square Foot (Not to Exceed $3) blank
blank
Rent/Lease Expense (Optional) blank $0
General Expense blank blank $0
Audit Fees (Optional) blank blank $0
Communications/Software blank blank $0
Equipment (Optional) blank blank $0
Total Operating Expenses blank
$0
blank blank blank blank
Capital Expenditures (Optional) blank blank blank
Capital Expense (Optional) - Please Describe blank blank $0
Total Capital Expenditures blank
$0
blank blank blank blank
Other Costs blank blank blank
Subcontract (Optional) blank blank $0
Other Charges - Educational Materials (Not Matchable) blank blank $0
Other Charges - Outreach Materials blank blank $0
Other Charges - Concrete Supports blank blank $0
Other Charges - Participant Travel/Transportation blank blank $0
Total Other Costs blank blank $0
blank blank blank blank
Total Direct Costs blank blank $0
blank blank blank blank
Indirect Costs blank blank blank
Select the appropriate Indirect Cost Rate (ICR) methodology blank ICR% Annual Cost
1. County & LHJ: Percent of Total Allowable Direct Cost, Enter ICR blank
$0
2. County & LHJ: Percent of Total Personnel Cost, Enter ICR blank
$0
3. CBO: Not to Exceed 15% of Total Personnel Cost, Enter ICR blank
$0
Total Indirect Cost Based on Methodology 1, 2 or 3 blank blank $0
TOTAL COSTS blank blank $0
blank blank blank blank
In Kind or Unmatched Agency Funds (Optional) blank blank $0
Matched Agency Funds (Optional) blank blank $0
Title XIX Requested (Optional) blank blank $0

The words contained in this file might help you see if this file matches what you are looking for:

...Sheet budget overview aflp rfa proposed the guide to development is intended provide basic instructions for completing template fy and agencies selected award will develop a revised in conjunction with their assigned mcahaflp program consultant contract managerthe quot total costs cell d reflect amount possible funding under title v any optional funds whether unmatched agency or matched xix requested may be reported below must fit within range outlined part i table size cells that completed by are described additionally color coded identify those filled autopopulated shown tan highlights fields manual data entry while green autopopulate annual cost as items on updated however it responsibility of applicant validate totals all required have budgeted unless indicated they item location s name enter each personnel follow guidance iii h regarding staffing pattern qualities minimum requirements insert staff salary fte position rows through complete one row per following case manager positio...

no reviews yet
Please Login to review.