• No results found

Instructions for Attachment #1: Keystone STARS Excel Budget Workbook

N/A
N/A
Protected

Academic year: 2021

Share "Instructions for Attachment #1: Keystone STARS Excel Budget Workbook"

Copied!
6
0
0

Loading.... (view fulltext now)

Full text

(1)

Tab 1- Instructions for Attachment #1: Keystone STARS Excel Budget Workbook

Please read below

Tab 2- Keystone STARS Budget Request for Center, Group, and Family

This tab should be used to complete your yearly budget.

Please only fill out cells that are white, all of the other cells are locked. All categories and sub-categories will total across and down automatically.

Tab 3- Keystone STARS Final Expense Report and Revision Determination Sheet

This form is to be used for tracking purposes and to determine if a budget revision is required.

All totals from Tab 2 will automatically populate the "Approved budget from Tab 2" column. If any line item deviates +/-10% at the end of the year then a budget revision is required.

Tab 4- Keystone STARS Budget Revision Template for Center, Group, and Family

Tab 5- Staff Benefits: Staff Bonuses and Salary Template

This tab must be filled out before proceeding to Tab 6.

Please only fill out cells that are white, all of the other cells are locked. For column B, D, and E please select an option from the drop down menu.

If you click on one of these cells an arrow will appear in the right hand side of the selected cell.

Tab 6- Education and Retention Award (ERA) Template

This tab can only be filled out after completing Tab 6.

Please only fill out cells that are white, all of the other cells are locked. Columns A, B, C, and D will automatically populate from Tab 5.

Instructions for Attachment #1: Keystone STARS Excel Budget Workbook

If on Tab 5 an employee was marked "No" or "Blank" under ERA Eligible, then their record on Tab 6 will be marked "NA" for Columns B, C and D

This form will indicate if a budget revision is required. The form must be filled out for the entire year before the determination will be accurate.

Please fill out all of the identifying information at the top of this sheet as it will populate on the subsequent tabs.

Please only fill out cells that are white (including "Date Prepared" and "Prepared By"), all of the other cells are locked. Sign and date.

Please only fill out cells that are white (including "Date Prepared" and "Prepared By"), all of the other cells are locked. Sign and date.

(2)

Name of Provider: Date Prepared:

MPI# on Certificate of Compliance: Prepared By:

Designation Expiration: Phone:

County: Email:

BUDGET CATEGORIES Infants/Toddlers Preschool School Age Mixed/Multiple

Age Groups Total Grant Budget

CR Furnishings

$ -

Learning Materials

$ -

Minor Renovations

$ -

GM Equipment

$ -

DHS Cert, Business Practices,

Technology.

$ -

Equipment & Supplies/Materials

$ - $ - $ - $ - $ -

Non-Credit Bearing

$ -

Credit Bearing

$ -

Other

$ -

Total Professional Development

$ - $ - $ - $ - $ -

Accreditation Costs $ -

Staff Benefits $ -

Other Expenses $ -

TOTALS $ - $ - $ - $ - $ -

Keystone STARS Budget Request for Center, Group, and Family

Professional Development Equipment & Supplies/Materials

(3)

Name of Provider:

MPI# on Certificate of Compliance: Designation Expiration:

County:

BUDGET CATEGORIES Approved Budget

from Tab 2 Expenditures - Infants/Toddlers Expenditures - Preschool Expenditures - School Age Expenditures - Mixed/Multiple Age Groups Unspent Funds Percentage Expended

Final Revision Required? (When completed, if at least one of the columns indicates "Budget Revision

Required", then a revision MUST be submitted)

Equipment & Supplies/Materials $ - $ - 0%

Professional Development $ - $ - 0%

Accreditation Costs $ - $ - 0%

Staff Benefits $ - $ - 0%

Other Expenses $ - $ - 0%

TOTALS $ - $ - $ - $ - $ - $ - 0%

Authorized Signature: Date:

Date of Payment Total Received -$ -$ $ - $ - $ -

Payment Schedule (For Regional Key Use Only) Amount

-$

-$

Keystone STARS Final Expense Report and Revision Determination Sheet

Total Grant Expenditures Date Prepared: Prepared By: Phone: Email

I attest that all grant purchases were made in accordance with the STARS Merit Award General Requirements contained in the STARS Merit and Education & Award Request (FA-03). If I did not follow the General Requirements, I understand that I must return the grant funds. I also agree to keep receipts for purchases made through this grant for a period of seven years after

the date this Grant Agreement is executed.

I understand that it is my responsibility to maintain receipts and records for financial auditing purposes. $ - $ - $ -

(4)

Name of Provider: Date Prepared:

MPI# on Certificate of Compliance: Prepared By:

Designation Expiration: Phone:

County: Email:

BUDGET CATEGORIES Infants/Toddlers Preschool School Age Mixed/Multiple Age Groups

Revised Grant

Budget Revision Justification

CR Furnishings $ -

Learning Materials $ -

Minor Renovations $ -

GM Equipment $ -

DHS Cert, Business Practices,

Technology. $ -

Total Equipment & Supplies/Materials $ - $ - $ - $ - $ -

Non-Credit Bearing $ -

Credit Bearing $ -

Other $ -

Total Professional Development $ - $ - $ - $ - $ -

Accreditation Costs $ -

Staff Benefits $ -

Other Expenses $ -

TOTALS $ - $ - $ - $ - $ -

Authorized Signature: Date:

Equipment & Supplies/Materials

I attest that all grant purchases were made in accordance with the STARS Merit Award General Requirements contained in the STARS Merit and Education & Award Request (FA-03). If I did not follow the General Requirements, I understand that I must return the grant funds. I also agree to keep receipts for purchases made through this grant for a

period of seven years after the date this Grant Agreement is executed.

I understand that it is my responsibility to maintain receipts and records for financial auditing purposes.

Professional Development

(5)

Name of Provider:

Employee Name Position Title

(Select from dropdown) Date of Hire

Care Level (Select from dropdown) ERA Eligible (Select from dropdown)

Current Annual Salary Bonus Requested Additional Salary Requested Award Amount Requested Employee 1 Employee 2 Employee 3 Employee 4 Employee 5 Employee 6 Employee 7 Employee 8 Employee 9 Employee 10 Employee 11 Employee 12 Employee 13 Employee 14 Employee 15 Employee 16 Employee 17 Employee 18 Employee 19 Employee 20 Employee 21 Employee 22 Employee 23 Employee 24 Employee 25 Employee 26 Employee 27 Employee 28 Employee 29 Employee 30 Employee 31 Employee 32 Employee 33 Employee 34 Employee 35 Employee 36 Employee 37 Employee 38 Employee 39 Employee 40 Employee 41 Employee 42 Employee 43 Employee 44 Employee 45 Employee 46 Employee 47 Employee 48 Employee 49 Employee 50

MPI# on Certificate of Compliance:

Staff Benefits: Staff Bonuses and Salary Template

(6)

Name of Provider:

Employee Name Position Title Date of Hire Care Level

Earnings (Child Care Annual Salary & Bonuses)

# Hours Worked Per Week Career Lattice Level Current Level of Education & Major

Attained (as it appears on

diploma)

Does this staff work with school

aged children? Yes/No and, if yes, list number of hour

per week

Does this staff work in a classroom that receives funding through Head Start, Pre-K Counts or Early Intervention? (please

specify) Award Amount Requested Employee 1 NA NA NA Employee 2 NA NA NA Employee 3 NA NA NA Employee 4 NA NA NA Employee 5 NA NA NA Employee 6 NA NA NA Employee 7 NA NA NA Employee 8 NA NA NA Employee 9 NA NA NA Employee 10 NA NA NA Employee 11 NA NA NA Employee 12 NA NA NA Employee 13 NA NA NA Employee 14 NA NA NA Employee 15 NA NA NA Employee 16 NA NA NA Employee 17 NA NA NA Employee 18 NA NA NA Employee 19 NA NA NA Employee 20 NA NA NA Employee 21 NA NA NA Employee 22 NA NA NA Employee 23 NA NA NA Employee 24 NA NA NA Employee 25 NA NA NA Employee 26 NA NA NA Employee 27 NA NA NA Employee 28 NA NA NA Employee 29 NA NA NA Employee 30 NA NA NA Employee 31 NA NA NA Employee 32 NA NA NA Employee 33 NA NA NA Employee 34 NA NA NA Employee 35 NA NA NA Employee 36 NA NA NA Employee 37 NA NA NA Employee 38 NA NA NA Employee 39 NA NA NA Employee 40 NA NA NA Employee 41 NA NA NA Employee 42 NA NA NA Employee 43 NA NA NA Employee 44 NA NA NA Employee 45 NA NA NA Employee 46 NA NA NA Employee 47 NA NA NA Employee 48 NA NA NA Employee 49 NA NA NA Employee 50 NA NA NA -$ Total Amount Requested

Education and Retention Award (ERA) Template

You must complete the form on the "Staff Bonuses and Salary" tab before completeing this form tab MPI# on Certificate of Compliance:

References

Related documents

On May 1, 2015, Duquesne Keystone, LLC (Duquesne Keystone), Duquesne Conemaugh, LLC (Duquesne Conemaugh, and together with Duquesne Keystone, Sellers), Chief Keystone Power,

Monthly Budget Planner for Excel Download a free Monthly Budget Planner that helps in planning your personal or harsh household monthly expenses.. Wally is always plan for

The Rising STARS Tuition Assistance Program pays 95% of tuition costs for eligible college coursework taken by early learning professionals working at Keystone STARS facilities, with

Any staff person who is employed at a Keystone STARS designated early learning program, and has been working at an early learning program operated by that legal entity for

Fixed office space can get in the way of letting your people work where and when they need to, reducing their agility and flexibility.. At Regus we understand that there is value

LHV (c) I understand that in accepting Rising STARS Tuition Assistance Program funds, I am agreeing to maintain my employment at my current legal entity or another Keystone

For a microsoft excel is a budget template from a name, but it has very simple spreadsheet excel microsoft templates teach salespeople how much money covers mileage in making

Feb 10 2015 Download a straightforward Project Budget template for Excel and create a detailed project budget to help himself track expenses.. A coarse project budget template is