The COST_ALLOCATION_PLAN Worksheet

 

§         Click on the Cost Allocation Plan button.

 

Cost Allocation PlanCost Allocation PlanThe user will be presented with the COST_ALLOCATION_PLAN worksheet as shown below:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

§         The Summary of the Estimated Project Budget table is created by clicking on the “Create Cost Allocation Plan Summary” or the “Create Cost Allocation Plan Section” buttons on the SHARED_USAGE_LOE worksheet.

 

§         This summary table contains each of the benefiting programs, their final percentage share in decimal format, and the columns to calculate the dollar amounts for their contribution.

 

§         Users must enter the “Budget Amount” and the appropriate match rates and the worksheet will calculate the Share Amount($), Federal Share($) FFP, and the State Share($) as shown below.

 

SUMMARY OF THE ESTIMATED PROJECT BUDGET

 

 

Enter Budget Amount:

 $  5,000,000.00

Federal/State Program

Program Share of Cost (%)

Share Amount ($)

Match Rate

Federal Share ($) FFP

State Share ($)

FS

0.71536

 $    3,576,800.00

0.5

 $               1,788,400.00

 $  1,788,400.00

TANF

0.28432

 $    1,421,600.00

0

 $                               -  

 $  1,421,600.00

STATE PROGRAM 3

0.00032

 $           1,600.00

0

 $                               -  

 $  1,600.00

TOTALS

1

 $    5,000,000.00

0

 $                               -  

 $  5,000,000.00

 

 

 

 

 

 

Users can transfer the summary information shown above directly into their required exhibit (table) in their Cost Allocation Plan.