Georgia Title IV-E Child Welfare Education & Training Program

{{$agency_det->NAME}}

{{$rep_data[0]->PROPOSAL_NM}}

Academic : {{($rep_data[0]->academic_year->ACADEMIC_YR)?$rep_data[0]->academic_year->ACADEMIC_YR:''}}

Prepared by : {{($rep_data[0]->user->username)?$rep_data[0]->user->username:''}}

  Proposed Budget  
@php $per_budget = (isset($pbudget[1]))?count($pbudget[1]):''; $tbase_a1 = 0; $tdeticate1 = 0; $terate1=0; $trepcost1 =0; $tfshare1 = 0; $tfedrem1 = 0; @endphp @for($j=0;$j <$per_budget;$j++) @endfor
Test Title IV-E Social Work Stipend Program Budget
Administrative Staff Costs
Administrative Staff Name Base Salary % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:''}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:''}}%
Reportable Costs Federal Share

50%
Federal Reimbursement University Reimbursement Required?
{{(isset($pbudget[1][$j]->FIRST_NM))?$pbudget[1][$j]->FIRST_NM:''}} {{(isset($pbudget[1][$j]->LAST_NM))?$pbudget[1][$j]->LAST_NM:''}} ${{$base_a1}} {{$time_a1}}% ${{$deticated_a1}} N/A ${{$erate_a1}} ${{$erate_a1}} ${{$federal_a1}} {{(isset($pbudget[1][$j]->SALARY_REIMBURSEMENT) && $pbudget[1][$j]->SALARY_REIMBURSEMENT=='Y' )?$deticated_a1:''}} {{(isset($pbudget[1][$j]->SALARY_REIMBURSEMENT))?$pbudget[1][$j]->SALARY_REIMBURSEMENT:''}}
Administrative Faculty Costs Subtotals ${{number_format($tbase_a1,2)}}   ${{number_format($tdeticate1,2)}} ${{number_format($terate1,2)}} ${{number_format($trepcost1,2)}} ${{number_format($tfshare1,2)}} ${{number_format($tfedrem1,2)}}
Faculty & Teaching Costs
@php $per_budget1 = (isset($fbudget[1]))?count($fbudget[1]):''; $tbase_a2 = 0; $tdeticate2 = 0; $terate2=0; $trepcost2 =0; $tfshare2 = 0; $tfedrem2 = 0; $tmaterial2 = 0; @endphp @for($j1=0;$j1 <$per_budget1;$j1++) @endfor
Faculty & Teaching Costs Base Salary % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

75%
Federal Reimbur
sement
University Reimbur
sement Required?
{{(isset($fbudget[1][$j1]->FIRST_NM))?$fbudget[1][$j1]->FIRST_NM:''}} {{(isset($fbudget[1][$j1]->LAST_NM))?$fbudget[1][$j1]->LAST_NM:''}} ${{$base_a1}} {{$time_a1}}% ${{$deticated_a1}} ${{$material_a1}} ${{$erate_a1}} ${{$erate_a1}} ${{$federal_a1}} {{(isset($fbudget[1][$j1]->SALARY_REIMBURSEMENT) && $fbudget[1][$j1]->SALARY_REIMBURSEMENT=='Y' )?$deticated_a1:''}} {{(isset($fbudget[1][$j1]->SALARY_REIMBURSEMENT))?$fbudget[1][$j1]->SALARY_REIMBURSEMENT:''}}
Administrative Faculty Costs Subtotals ${{number_format($tbase_a2,2)}}   ${{number_format($tdeticate2,2)}} ${{number_format($tmaterial2,2)}} ${{number_format($terate2,2)}} ${{number_format($trepcost2,2)}} ${{number_format($tfshare2,2)}} ${{number_format($tfedrem2,2)}}
Fringe Benefits for Administrative Staff Costs
@php $fring_budget = (isset($pbudget[1]))?count($pbudget[1]):''; $tdeticate3 = 0; $terate3=0; $trepcost3 =0; $tfshare3 = 0; $tfedrem3 = 0; $tmaterial3 = 0; $fbcost_a3=0; @endphp @for($f=0;$f <$fring_budget;$f++) @endfor
Fringe Benefits for Adminis trative Staff Costs Fringe Benefit Rates Fringe Cost % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

50%
Federal Reimbu rsement University Reimbu rsement Required?
{{(isset($pbudget[1][$f]->FIRST_NM))?$pbudget[1][$f]->FIRST_NM:''}} {{(isset($pbudget[1][$f]->LAST_NM))?$pbudget[1][$f]->LAST_NM:''}} {{(isset($pbudget[1][$f]->BENEFIT_RATE))?$pbudget[1][$f]->BENEFIT_RATE:''}} ${{$fcost_a1}} {{(isset($pbudget[1][$f]->PGM_TIME_PCT))?$pbudget[1][$f]->PGM_TIME_PCT:''}}% {{$deticated_a1}} N/A {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{(isset($pbudget[1][$f]->BENEFIT_REIMBURSEMENT) && $pbudget[1][$f]->BENEFIT_REIMBURSEMENT=='Y' )?$deticated_a1:''}} {{(isset($pbudget[1][$f]->BENEFIT_REIMBURSEMENT))?$pbudget[1][$f]->BENEFIT_REIMBURSEMENT:''}}
Administrative Faculty Costs Subtotals {{number_format($fbcost_a3,2)}}   {{number_format($tdeticate3,2)}} {{number_format($terate3,2)}} {{number_format($trepcost3,2)}} {{number_format($tfshare3,2)}} {{number_format($tfedrem3,2)}}
Fringe Benefits for Faculty and Teaching Costs
@php $fringe_budget1 = (isset($fbudget[1]))?count($fbudget[1]):''; $tdeticate4 = 0; $terate4=0; $trepcost4 =0; $tfshare4 = 0; $tfedrem4 = 0; $tmaterial4 = 0; $fbcost_a4=0; @endphp @for($f1=0;$f1 <$fringe_budget1;$f1++) @endfor
Fringe Benefits for Faculty and Teaching Costs Fringe Benefit Rates Fringe Cost % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

75%
Federal Reimbu rsement University Reimbu rsement Required?
{{(isset($fbudget[1][$f1]->FIRST_NM))?$fbudget[1][$f1]->FIRST_NM:''}} {{(isset($fbudget[1][$f1]->LAST_NM))?$fbudget[1][$f1]->LAST_NM:''}} {{(isset($fbudget[1][$f1]->BENEFIT_RATE))?$fbudget[1][$f1]->BENEFIT_RATE:''}} ${{$fcost_a1}} {{(isset($fbudget[1][$f1]->PGM_TIME_PCT))?$fbudget[1][$f1]->PGM_TIME_PCT:''}}% {{$deticated_a1}} {{$dmaterial_a1}} {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{(isset($fbudget[1][$f1]->BENEFIT_REIMBURSEMENT) && $fbudget[1][$f1]->BENEFIT_REIMBURSEMENT=='Y' )?$deticated_a1:''}} {{(isset($fbudget[1][$f1]->BENEFIT_REIMBURSEMENT))?$fbudget[1][$f1]->BENEFIT_REIMBURSEMENT:''}}
Administrative Faculty Costs Subtotals {{number_format($fbcost_a4,2)}} {{number_format($tdeticate4,2)}} {{number_format($tmaterial4,2)}} {{number_format($terate4,2)}} {{number_format($trepcost4,2)}} {{number_format($tfshare4,2)}} {{number_format($tfedrem4,2)}}
Fringe Cost Dedicated Annual Budget to IVE Program % Title IVE Material curriculum statistic Eligibility Rate Reportable Costs Federal Share University Required Reimbursement
Personnel Cost Totals ${{number_format($pcotx,2)}} ${{number_format($deticate_f,2)}} ${{number_format($dmaterial_f,2)}} ${{number_format($derate_f,2)}} ${{number_format($drep_cost_f,2)}} ${{number_format($fed_share_f,2)}}
Direct Personnel Costs Requested ${{number_format($fed_reimb_f,2)}} ${{number_format($fed_reimb_f,2)}}
@php $pro_budget = (isset($vbudget[1]))?count($vbudget[1]):''; $tbase_a5 = 0; $tdeticate5 = 0; $terate5=0; $trepcost5 =0; $tfshare5 = 0; $tfedrem5 = 0; $tmaterial5 = 0; @endphp @for($v=0;$v <$pro_budget;$v++) @endfor
Training Operating Costs
Training Operating Costs Budget % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

75%
Federal Reimbursement
{{(isset($vbudget[1][$v]->BUDGET_ITEM))?$vbudget[1][$v]->BUDGET_ITEM:''}} {{(isset($vbudget[1][$v]->BUDGET_AMT))?$vbudget[1][$v]->BUDGET_AMT:''}} {{(isset($vbudget[1][$v]->PGM_TIME_PCT))?$vbudget[1][$v]->PGM_TIME_PCT:''}} {{$deticated_a1}} N/A {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{$deticated_a1}}
Training Operating Costs Subtotals ${{number_format($tbase_a5,2)}}   ${{number_format($tdeticate5,2)}} ${{number_format($terate5,2)}} ${{number_format($trepcost5,2)}} ${{number_format($tfshare5,2)}} ${{number_format($tfedrem5,2)}}
@php $pro_budget1 = (isset($vbudget[2]))?count($vbudget[2]):''; $tbase_a6 = 0; $tdeticate6 = 0; $terate6=0; $trepcost6 =0; $tfshare6 = 0; $tfedrem6 = 0; $tmaterial6 = 0; @endphp @for($v1=0;$v1 <$pro_budget1;$v1++) @endfor
Training Travel Costs
Training Travel Costs Budget % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

75%
Federal Reimbursement
{{(isset($vbudget[2][$v1]->BUDGET_ITEM))?$vbudget[2][$v1]->BUDGET_ITEM:''}} {{(isset($vbudget[2][$v1]->BUDGET_AMT))?$vbudget[2][$v1]->BUDGET_AMT:''}} {{(isset($vbudget[2][$v1]->PGM_TIME_PCT))?$vbudget[2][$v1]->PGM_TIME_PCT:''}} {{$deticated_a1}} N/A {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{$deticated_a1}}
Training Travel Costs Subtotals ${{number_format($tbase_a6,2)}} ${{number_format($tdeticate6,2)}} ${{number_format($terate6,2)}} ${{number_format($trepcost6,2)}} ${{number_format($tfshare6,2)}} ${{number_format($tfedrem6,2)}}
@php $pro_budget2 = (isset($vbudget[3]))?count($vbudget[3]):''; $tbase_a7 = 0; $tdeticate7 = 0; $terate7=0; $trepcost7 =0; $tfshare7 = 0; $tfedrem7 = 0; $tmaterial7 = 0; @endphp @for($v2=0;$v2 <$pro_budget2;$v2++) @endfor
Student Stipend Costs
Student Stipend Costs Budget % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

75%
Federal Reimbursement
{{(isset($vbudget[3][$v2]->BUDGET_ITEM))?$vbudget[3][$v2]->BUDGET_ITEM:''}} {{(isset($vbudget[3][$v2]->BUDGET_AMT))?$vbudget[3][$v2]->BUDGET_AMT:''}} {{(isset($vbudget[3][$v2]->PGM_TIME_PCT))?$vbudget[3][$v2]->PGM_TIME_PCT:''}} {{$deticated_a1}} N/A {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{$deticated_a1}}
Student Stipend Costs Subtotals ${{number_format($tbase_a7,2)}} ${{number_format($tdeticate7,2)}} ${{number_format($terate7,2)}} ${{number_format($trepcost7,2)}} ${{number_format($tfshare7,2)}} ${{number_format($tfedrem7,2)}}
@php $pro_budget3 = (isset($vbudget[4]))?count($vbudget[4]):''; $tbase_a8 = 0; $tdeticate8 = 0; $terate8=0; $trepcost8 =0; $tfshare8 = 0; $tfedrem8 = 0; $tmaterial8 = 0; @endphp @for($v3=0;$v3 <$pro_budget3;$v3++) @endfor
Administrative Operating Costs
Administrative Operating Costs Budget % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

50%
Federal Reimbursement
{{(isset($vbudget[4][$v3]->BUDGET_ITEM))?$vbudget[4][$v3]->BUDGET_ITEM:''}} {{(isset($vbudget[4][$v3]->BUDGET_AMT))?$vbudget[4][$v3]->BUDGET_AMT:''}} {{(isset($vbudget[4][$v3]->PGM_TIME_PCT))?$vbudget[4][$v3]->PGM_TIME_PCT:''}} {{$deticated_a1}} N/A {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{$deticated_a1}}
Administrative Operating Costs Subtotals: ${{number_format($tbase_a8,2)}}   ${{number_format($tdeticate8,2)}} ${{number_format($terate8,2)}} ${{number_format($trepcost8,2)}} ${{number_format($tfshare8,2)}} ${{number_format($tfedrem8,2)}}
@php $pro_budget4 = (isset($vbudget[5]))?count($vbudget[5]):''; $tbase_a9 = 0; $tdeticate9 = 0; $terate9=0; $trepcost9 =0; $tfshare9 = 0; $tfedrem9 = 0; $tmaterial9 = 0; @endphp @for($v4=0;$v4 <$pro_budget4;$v4++) @endfor
Administrative Travel Costs
Administrative Travel Costs Budget % of Time Dedicated Annual Budget to IV-E Program %Title IV-E Material curriculum statistic

{{(isset($rep_data[0]->MATERIAL_PCT))?$rep_data[0]->MATERIAL_PCT:'70'}}%
Eligibility Rate

{{(isset($rep_data[0]->ELIGIBILITY_RATE))?$rep_data[0]->ELIGIBILITY_RATE:'47'}}%
Reportable Costs Federal Share

50%
Federal Reimbursement
{{(isset($vbudget[5][$v4]->BUDGET_ITEM))?$vbudget[5][$v4]->BUDGET_ITEM:''}} {{(isset($vbudget[5][$v4]->BUDGET_AMT))?$vbudget[5][$v4]->BUDGET_AMT:''}} {{(isset($vbudget[5][$v4]->PGM_TIME_PCT))?$vbudget[5][$v4]->PGM_TIME_PCT:''}} {{$deticated_a1}} N/A {{$erate_a1}} {{$erate_a1}} {{$federal_a1}} {{$deticated_a1}}
Administrative Travel Costs Subtotals: ${{number_format($tbase_a9,2)}}   ${{number_format($tdeticate9,2)}} ${{number_format($terate9,2)}} ${{number_format($trepcost9,2)}} ${{number_format($tfshare9,2)}} ${{number_format($tfedrem9,2)}}
Budget Dedicated Annual Budget to IV-E Program % Title IV-E Material curriculum statistic Eligibility Rate Reportable Costs Federal Share University Required Reimbursement
Total Direct Costs: ${{number_format($abudx,2)}} ${{number_format($abudxx,2)}} ${{number_format($amaterialx,2)}} ${{number_format($aeratex,2)}} ${{number_format($asharex,2)}}
Modified Direct Costs: ${{number_format($mdircosts,2)}}
Indirect Rate: {{(isset($rep_data[0]->INDIRECT_RATE))?$rep_data[0]->INDIRECT_RATE:'58'}} ${{number_format($ind_rate_cst,2)}} ${{number_format($ind_erate,2)}} ${{number_format($ind_erate,2)}} ${{number_format($ind_fshare,2)}} ${{number_format($afedreim,2)}}
Indirect Cost Reimbursement to University: {{(isset($rep_data[0]->INDIRECT_COST))?$rep_data[0]->INDIRECT_COST:'1'}} ${{number_format($ind_cst_reium,2)}}
Total Title IV-E Budget
FEDERAL DOLLARS REQUIRED Total Federal Reimbursement ${{number_format($tfshare,2)}}
Stipend Support: ${{number_format($tfedrem7,2)}}
Travel: ${{number_format($travel_csts,2)}} Reimbursment Requested ${{number_format($btotal,2)}}
Operating expense: ${{number_format($operating_csts,2)}}
Direct personnel cost: ${{number_format($fed_reimb_f,2)}}
Indirect Cost Reimbursement to University: ${{number_format($ind_cst_reium,2)}} Difference for Admin ${{number_format($admin_diff,2)}}
Total ${{number_format($btotal,2)}}