@php $cwb_month = (isset($cmonth))?$rep_data[0]->MONTH_NBR:''; $cwb_year = (isset($cmonth))?$rep_data[0]->YEAR:''; @endphp

Georgia Title IV-E Child Welfare Education & Training Program

{{($agency_det->DESIGNATION!=1)?str_replace('Proposal','Cost workbook',$rep_data[0]->PROPOSAL_NM):'Cost Workbook'}} - {{($agency_det->DESIGNATION!=1)?$term:date('F', mktime(0, 0, 0, $cwb_month, 10))}}

@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 {{$eligibility}}%	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)}}
Budget Justifications						{{(isset($rep_data[0]->ADMIN_SALARY_JSTFCTN))?$rep_data[0]->ADMIN_SALARY_JSTFCTN:''}}

@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
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 {{$eligibility}}%	Reportable Costs	Federal Share 75%	Federal Reimbursement	University Reimbursement 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)}}
Administrative Faculty Costs Subtotals						{{(isset($rep_data[0]->FACULTY_SALARY_JSTFCTN))?$rep_data[0]->FACULTY_SALARY_JSTFCTN:''}}

@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 Administrative Staff Costs
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 {{$eligibility}}%	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)}}
Budget Justifications						{{(isset($rep_data[0]->ADMIN_FRINGE_JSTFCTN))?$rep_data[0]->ADMIN_FRINGE_JSTFCTN:''}}

@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 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 {{$eligibility}}%	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)}}
Budget Justifications						{{(isset($rep_data[0]->FCLTY_TCHR_FRINGE_JSTFCTN))?$rep_data[0]->FCLTY_TCHR_FRINGE_JSTFCTN:''}}

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 {{$eligibility}}%	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}}
Budget Justifications					{{(isset($vbudget[1][$v]->BUDGET_JSTFCTN))?$vbudget[1][$v]->BUDGET_JSTFCTN:''}}
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 {{$eligibility}}%	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}}
Budget Justifications					{{(isset($vbudget[2][$v1]->BUDGET_JSTFCTN))?$vbudget[2][$v1]->BUDGET_JSTFCTN:''}}
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 {{$eligibility}}%	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)}}
Budget Justifications					{{(isset($vbudget[3][0]->BUDGET_JSTFCTN))?$vbudget[3][0]->BUDGET_JSTFCTN:''}}

@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)}}
Budget Justifications					{{(isset($vbudget[4][0]->BUDGET_JSTFCTN))?$vbudget[4][0]->BUDGET_JSTFCTN:''}}

@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 {{$eligibility}}%	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}}
Budget Justifications					{{(isset($vbudget[5][0]->BUDGET_JSTFCTN))?$vbudget[5][0]->BUDGET_JSTFCTN:''}}
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)}}

@if($agency_det->DESIGNATION!=1)

@php $courses1 = (isset($courses))?count($courses):''; $courses1 = ($courses1)?$courses1:1; $chourst = 0; $chcl75=0; $chcl50=0; $chcl0=0; @endphp @for($v1=0;$v1<$courses1;$v1++) @endfor

PART 3

Courses

GSU CURRICULUM STATISTIC

Fall 2017

% of Claimable Credit Hours at 75%

# of Credit Hours Claimable at 75%

% of Claimable Credit Hours at 50%

# of Credit Hours Claimable at 50%

% of Credit Hours Not Claimable

# of Credit Hours Claimable at 0%

Course Number

Course Name

Name of Instructor

Credit Hours

75%

50%

Total

{{(isset($courses[$v1]->COURSE_NBR))?$courses[$v1]->COURSE_NBR:''}}

{{(isset($courses[$v1]->COURSE_TITLE))?$courses[$v1]->COURSE_TITLE:''}}

{{(isset($courses[$v1]->CREDIT_HR))?$courses[$v1]->CREDIT_HR:''}}

${{number_format($chourst,2)}}

${{number_format($chcl75,2)}}

${{number_format($chcl50,2)}}

${{number_format($chcl0,2)}}

SUMMARY	Credit Hours
75% credit hours	${{number_format($chcl75,2)}}
50% credit hours	${{number_format($chcl50,2)}}
0% credit hours	${{number_format($chcl0,2)}}
Total credit hours	${{number_format($tot_chr,2)}}

Curriculum Statistics	{{number_format($cstatis,2)}}

@endif @php $cstatis = ($agency_det->DESIGNATION==1)?'1':$cstatis; @endphp

	PART 4
	CR Training Costs

Stipend Program Training Costs Cost Report

Administrative Expenditures/Costs

Total Administrative Costs

Action

SALARY COSTS (all salaries paid for by universities for administration of program report here)

@php $train_salcost1 = (isset($train_salary[11]))?count($train_salary[11]):''; $train_salcost1 = ($train_salcost1)?$train_salcost1:1; $tpay_sal=0; $tpay_fring=0; @endphp @for($v1=0;$v1 <$train_salcost1;$v1++) @endfor

In the lines below, please enter the Administrative Staff Salary Costs for University Reimbursement.
{{(isset($train_salary[11][$v1]->FULL_NM))?$train_salary[11][$v1]->FULL_NM:''}}	{{$t_paysal}}	{{$t_payfring}}

SUBTOTAL for Reimbursement	${{number_format($tpay_sal,2)}}	${{number_format($tpay_fring,2)}}

@php $train_salcost2 = (isset($train_salary[12]))?count($train_salary[12]):''; $train_salcost2 = ($train_salcost2)?$train_salcost2:1; $tpay_sal1=0; $tpay_fring1=0; @endphp @for($v2=0;$v2 <$train_salcost2;$v2++) @endfor

In the lines below, please enter the Administrative Staff Salary Costs for University Reimbursement.
{{(isset($train_salary[12][$v2]->FULL_NM))?$train_salary[12][$v2]->FULL_NM:''}}	{{$t_paysal1}}	{{$t_payfring1}}

SUBTOTAL for Reimbursement	${{number_format($tpay_sal1,2)}}	${{number_format($tpay_fring1,2)}}

Total Salary Costs	${{number_format($t_tot_paysal,2)}}
Total Fringe Benefits Costs	${{number_format($t_tot_frng,2)}}

TRAVEL COSTS (expenditure related to travel of students in training/stipend program)

@php $train_none1 = (isset($train_none[13]))?count($train_none[13]):''; $train_none1 = ($train_none1)?$train_none1:1; $t_trvl_tot = 0; @endphp @for($v2=0;$v2 <$train_none1;$v2++) @endfor

{{(isset($train_none[13][$v2]->BUDGET_ITEM))?$train_none[13][$v2]->BUDGET_ITEM:''}}	{{(isset($train_none[13][$v2]->BUDGET_AMT))?$train_none[13][$v2]->BUDGET_AMT:''}}

Total Travel costs	${{number_format($t_trvl_tot,2)}}

OPERATING COSTS (expenditure related to operating of stipend program activities)

@php $train_none2 = (isset($train_none[14]))?count($train_none[14]):''; $train_none2 = ($train_none2)?$train_none2:1; $t_opt_cst = 0; @endphp @for($v2=0;$v2 <$train_none2;$v2++) @endfor

{{(isset($train_none[14][$v2]->BUDGET_ITEM))?$train_none[14][$v2]->BUDGET_ITEM:''}}	{{(isset($train_none[14][$v2]->BUDGET_AMT))?$train_none[14][$v2]->BUDGET_AMT:''}}

Total Operating Costs	${{number_format($t_opt_cst,2)}}

SUPPLIES (expenditure related to supplies for stipend program activities)

@php $train_none3 = (isset($train_none[15]))?count($train_none[15]):''; $train_none3 = ($train_none3)?$train_none3:1; $t_supp_tot = 0; @endphp @for($v2=0;$v2 <$train_none3;$v2++) @endfor

{{(isset($train_none[15][$v2]->BUDGET_ITEM))?$train_none[15][$v2]->BUDGET_ITEM:''}}	{{(isset($train_none[15][$v2]->BUDGET_AMT))?$train_none[15][$v2]->BUDGET_AMT:''}}

Total Supplies Costs	${{number_format($t_supp_tot,2)}}

STUDENT STIPENDS (expenditure of stipends of student)

@php $train_none4 = (isset($train_none[16]))?count($train_none[16]):''; $train_none4 = ($train_none4)?$train_none4:1; $t_std_stip = 0; @endphp @for($v2=0;$v2 <$train_none4;$v2++) @endfor

{{(isset($train_none[16][$v2]->BUDGET_ITEM))?$train_none[16][$v2]->BUDGET_ITEM:''}}	{{(isset($train_none[16][$v2]->BUDGET_AMT))?$train_none[16][$v2]->BUDGET_AMT:''}}

Total Stipend Cost	${{number_format($t_std_stip,2)}}

TOTAL DIRECT TO BE REIMBURSED TOcenterNIVERSITY (TO BE PAID TO UNIVERSITY)	${{number_format($dir_reium_tot,2)}}
TOTAL DIRECT STIPEND COSTS (TOTAL COST INCLUDING CPE'S)	${{number_format($dir_step_cst,2)}}

	PART 5
	CR Admin Costs

Stipend Program Administrative Costs Cost Report

Administrative Expenditures/Costs

Total Administrative Costs

Action

SALARY COSTS (all salaries paid for by universities for administration of program report here)

@php $admin_salcost1 = (isset($admin_salary[17]))?count($admin_salary[17]):''; $admin_salcost1 = ($admin_salcost1)?$admin_salcost1:1; $apay_sal=0; $apay_fring=0; @endphp @for($v1=0;$v1 <$admin_salcost1;$v1++) @endfor

In the lines below, please enter the Administrative Salary Costs for University Reimbursement.
{{(isset($admin_salary[17][$v1]->FULL_NM))?$admin_salary[17][$v1]->FULL_NM:''}}	{{$a_paysal}}	{{$a_payfring}}

SUBTOTAL for Reimbursement	${{number_format($apay_sal,2)}}	${{number_format($apay_fring,2)}}

@php $admin_salcost2 = (isset($admin_salary[18]))?count($admin_salary[18]):''; $admin_salcost2 = ($admin_salcost2)?$admin_salcost2:1; $apay_sal1=0; $apay_fring1=0; @endphp @for($v2=0;$v2 <$admin_salcost2;$v2++) @endfor

In the lines below please enter the Administrative Staff Salary Costs identified as Certified Public Expenditure.
{{(isset($admin_salary[18][$v2]->FULL_NM))?$admin_salary[18][$v2]->FULL_NM:''}}	{{$a_paysal1}}	{{$a_payfring1}}

SUBTOTAL for Reimbursement	${{number_format($apay_sal1,2)}}	${{number_format($apay_fring1,2)}}

Total Personnel Costs	${{number_format($t_tot_paysal1,2)}}
Total Fringe Benefits Costs	${{number_format($t_tot_frng1,2)}}

TRAVEL COSTS (travel costs of university staff to administrative program)

@php $admin_none1 = (isset($admin_none[19]))?count($admin_none[19]):''; $admin_none1 = ($admin_none1)?$admin_none1:1; $a_tot_trvl = 0; @endphp @for($v2=0;$v2 <$admin_none1;$v2++) @endfor

{{(isset($admin_none[19][$v2]->BUDGET_ITEM))?$admin_none[19][$v2]->BUDGET_ITEM:''}}	{{(isset($admin_none[19][$v2]->BUDGET_AMT))?$admin_none[19][$v2]->BUDGET_AMT:''}}

Total Travel Costs	${{number_format($a_tot_trvl,2)}}

OPERATING COSTS (costs to operate the administrative portion of program)

@php $admin_none2 = (isset($admin_none[20]))?count($admin_none[20]):''; $admin_none2 = ($admin_none2)?$admin_none2:1; $a_opr_cst = 0; @endphp @for($v2=0;$v2 <$admin_none2;$v2++) @endfor

{{(isset($admin_none[20][$v2]->BUDGET_ITEM))?$admin_none[20][$v2]->BUDGET_ITEM:''}}	{{(isset($admin_none[20][$v2]->BUDGET_AMT))?$admin_none[20][$v2]->BUDGET_AMT:''}}

Total Operating Costs	${{number_format($a_opr_cst,2)}}

SUPPLIES (costs for supplies to operate the administrative portion of program)

@php $admin_none3 = (isset($admin_none[21]))?count($admin_none[21]):''; $admin_none3 = ($admin_none3)?$admin_none3:1; $tot_sup_cst = 0; @endphp @for($v2=0;$v2<$admin_none3;$v2++) @endfor

{{(isset($admin_none[21][$v2]->BUDGET_ITEM))?$admin_none[21][$v2]->BUDGET_ITEM:''}}	{{(isset($admin_none[21][$v2]->BUDGET_AMT))?$admin_none[21][$v2]->BUDGET_AMT:''}}

Total Supplies	${{number_format($tot_sup_cst,2)}}

TOTAL DIRECT TO BE REIMBURSED TO UNIVERSITY (THIS LINE TO BE PAID TO UNIVERSITY)	${{number_format($atotal_payy,2)}}
TOTAL DIRECT ADMINISTRATION COSTS (TOTAL EXPENDITURES FOR MONTH INCLUDING CPE'S)	${{number_format($atotal_fring,2)}}

	PART 6
	Cost Report Summary

Stipend Program

Report Month:	{{($agency_det->DESIGNATION!=1)?'Fall':date('F', mktime(0, 0, 0, $cwb_month, 10))}} - {{($agency_det->DESIGNATION!=1)?'2019':$cwb_year}}		Curriculum Statistic	Eligiblity Rate	Total Title IV-E Reportable (CB-496)	FFP	FFP	Total Title IV-E Reimbur sement
			{{($agency_det->DESIGNATION==1)?'NA':number_format($cstatis,2)}}	{{$summary_elig}}%		75%	50%
Total Stipend Program Costs		TOTALS
Total Administration Costs		${{number_format($atotal_fring,2)}}		{{number_format($eligib_rt,2)}}	{{number_format($eligib_rt,2)}}		{{number_format($ffp50,2)}}	{{number_format($ffp50,2)}}
Total Stipend Training Costs		${{number_format($dir_step_cst,2)}}	{{number_format($cur_cum_st,2)}}	{{number_format($eligib_rt1,2)}}	{{number_format($eligib_rt1,2)}}	{{number_format($ffp75,2)}}		{{number_format($ffp75,2)}}
TOTAL DIRECT COSTS		${{number_format($tdircst,2)}}
TOTAL MODIFIED DIRECT COST		${{number_format($mod_dir_tt,2)}}
INDIRECT COST RATE		{{$ind_rate}}%
TOTAL INDIRECT COSTS TO BE CLAIMED		${{number_format($indir_cst_rt,2)}}		{{number_format($toclaim,2)}}	{{number_format($toclaim,2)}}		{{number_format($toffp50,2)}}	{{number_format($toffp50,2)}}
TOTAL IV-E REPORTABLE DIRECT COSTS		{{number_format($tteligib,2)}}
TOTAL IV-E REPORTABLE INDIRECT COSTS		{{number_format($toclaim,2)}}
TOTAL IV-E FEDERAL REIMBURSEMENT		{{number_format($total_reiumbrr,2)}}
TOTAL DIRECT FOR REIMBURSEMENT to University		{{number_format($reium_to_univ,2)}}
Indirect Cost Reimbursement to University	{{$icstreuim}}%	{{number_format($indir_cst_reium,2)}}
TOTAL REIMBURSEMENT TO BE PAID TO UNIVERSITY		{{number_format($reuim_to_paid,2)}}
Contribution to Consortium Budget		{{number_format($contrib_budget,2)}}

	PART 7
	Cost Report Summary #2
Stipend Program Cost Report Summary

Report Month:	{{($agency_det->DESIGNATION!=1)?'Fall':date('F', mktime(0, 0, 0, $cwb_month, 10))}} - {{($agency_det->DESIGNATION!=1)?'2019':$cwb_year}}		Curri culum Statistic	Eligiblity Rate	Total Title IV-E Reportable (CB-496)	Federal Share	CPE - State Share	Federal Share	CPE - State Share	Total Title IV-E Reimbu rsement
			{{($agency_det->DESIGNATION==1)?'NA':number_format($cstatis,2)}}	{{$summary_elig}}%		75%	25%	50%	50%
Total Stipend Program Costs		TOTALS
Salaries/Fringe		${{number_format($sal_frng,2)}}		${{number_format($sum2eligrate_sal,2)}}	${{number_format($sum2eligrate_sal,2)}}			${{number_format($sum2salfedshr,2)}}	${{number_format($sum2fedstate,2)}}	${{number_format($sum2fedstate,2)}}
Travel		${{number_format($a_tot_trvl,2)}}		${{number_format($sum2eligrate_trvl,2)}}	${{number_format($sum2eligrate_trvl,2)}}			${{number_format($sum2trvlfedshr,2)}}	${{number_format($sum2fedstatetrvl,2)}}	${{number_format($sum2fedstatetrvl,2)}}
Operating		${{number_format($a_opr_cst,2)}}		${{number_format($sum2eligrate_opr,2)}}	${{number_format($sum2eligrate_opr,2)}}			${{number_format($sum2oprfedshr,2)}}	${{number_format($sum2fedstateopr,2)}}	${{number_format($sum2fedstateopr,2)}}
Supplies		${{number_format($tot_sup_cst,2)}}		${{number_format($sum2eligrate_sup,2)}}	${{number_format($sum2eligrate_sup,2)}}			${{number_format($sum2supfedshr,2)}}	${{number_format($sum2fedstatesup,2)}}	${{number_format($sum2fedstatesup,2)}}
Subtotal Administration Costs		${{number_format($tot_a_payfrng,2)}}		${{number_format($sum2eligrate_tsal,2)}}	${{number_format($sum2eligrate_tsal,2)}}			${{number_format($sum2tsalfedshr,2)}}	${{number_format($sum2fedstatetsal,2)}}	${{number_format($sum2fedstatetsal,2)}}
Salaries/Fringe		${{number_format($tsal_frng,2)}}	${{number_format($sum2curstattrvl,2)}}	${{number_format($sum2eligrate_trvl1,2)}}	${{number_format($sum2eligrate_trvl1,2)}}	${{number_format($sum2trvlfedshr1,2)}}	${{number_format($sum2fedstatettrvl1,2)}}			${{number_format($sum2trvlfedshr1,2)}}
Travel		${{number_format($t_trvl_tot,2)}}	${{number_format($sum2curstattrv2,2)}}	${{number_format($sum2eligrate_trvl2,2)}}	${{number_format($sum2eligrate_trvl2,2)}}	${{number_format($sum2trvlfedshr2,2)}}	${{number_format($sum2fedstatettrvl2,2)}}			${{number_format($sum2trvlfedshr2,2)}}
Operating		${{number_format($t_opt_cst,2)}}	${{number_format($sum2curstattrv3,2)}}	${{number_format($sum2eligrate_trvl3,2)}}	${{number_format($sum2eligrate_trvl3,2)}}	${{number_format($sum2trvlfedshr3,2)}}	${{number_format($sum2fedstatettrvl3,2)}}			${{number_format($sum2trvlfedshr3,2)}}
Supplies		${{number_format($t_supp_tot,2)}}	${{number_format($sum2curstattrv4,2)}}	${{number_format($sum2eligrate_trvl4,2)}}	${{number_format($sum2eligrate_trvl4,2)}}	${{number_format($sum2trvlfedshr4,2)}}	${{number_format($sum2fedstatettrvl4,2)}}			${{number_format($sum2trvlfedshr4,2)}}
Stipends		${{number_format($t_std_stip,2)}}	${{number_format($sum2curstattrv5,2)}}	${{number_format($sum2eligrate_trvl5,2)}}	${{number_format($sum2eligrate_trvl5,2)}}	${{number_format($sum2trvlfedshr5,2)}}	${{number_format($sum2fedstatettrvl5,2)}}			${{number_format($sum2trvlfedshr5,2)}}
Total Training Costs		${{number_format($ttot_a_payfrng,2)}}	${{number_format($sum2curstattrv6,2)}}	${{number_format($sum2eligrate_trvl6,2)}}	${{number_format($sum2eligrate_trvl6,2)}}	${{number_format($sum2trvlfedshr6,2)}}	${{number_format($sum2fedstatettrvl6,2)}}			${{number_format($sum2trvlfedshr6,2)}}
TOTAL DIRECT COSTS		${{number_format($tot_tsal_asal,2)}}
TOTAL MODIFIED DIRECT COST		${{number_format($sum2moddircst,2)}}
INDIRECT COST RATE		{{$ind_rate}}%
TOTAL INDIRECT COSTS TO BE CLAIMED		${{number_format($sum2indircstclm,2)}}		${{number_format($sum2eligrate_trvl7,2)}}	${{number_format($sum2eligrate_trvl7,2)}}			${{number_format($sum2trvlfedshr7,2)}}	${{number_format($sum2fedstatettrvl7,2)}}	${{number_format($sum2fedstatettrvl7,2)}}
Total Administration Costs		${{number_format($sum2_tot_admcst,2)}}		${{number_format($sum2eligrate_trvl8,2)}}	${{number_format($sum2eligrate_trvl8,2)}}			${{number_format($sum2trvlfedshr8,2)}}	${{number_format($sum2fedstatettrvl8,2)}}	${{number_format($sum2fedstatettrvl8,2)}}
TOTAL IV-E REPORTABLE Administration + Training					${{number_format($trep_trn,2)}}
TOTAL IV-E REPORTABLE INDIRECT COSTS					${{number_format($sum2eligrate_trvl7,2)}}
TOTAL IV-E FEDERAL REIMBURSEMENT					$ {{number_format($total_sum2_fedreium,2)}}
TOTAL DIRECT FOR REIMBURSEMENT to University					${{number_format($totdirreuim,2)}}
Indirect Cost Reimbursement to University				{{$icstreuim}}%	${{number_format($indircstreiumsum2,2)}}
TOTAL REIMBURSEMENT TO BE PAID TO UNIVERSITY					${{number_format($total_reium_touniv,2)}}
Contribution to Consortium Budget					${{number_format($consortium_dubget,2)}}

	PART 8
	Invoice

GSU
Title IV-E Stipend Program
REQUEST FOR REIMBURSEMENT

{{($agency_det->DESIGNATION!=1)?$acdmy_terms:date('F', mktime(0, 0, 0, $cwb_month, 10))}}

NAME AND ADDRESS OF University

University Name:	{{$agency_det->NAME}}
Address:	{{$agency_det->MAIL_ADDR_LN_1}} {{$agency_det->MAIL_CITY}}, {{$agency_det->MAIL_STATE}}, {{$agency_det->MAIL_ZIPCODE}}.

Mail to:

Invoice Number {{($agency_det->DESIGNATION!='1')?$invv_num:$cwb_year.$cbmm}}

Invoice Date : {{($invoice_date!='')?date('d/m/Y',strtotime($invoice_date)):''}}

CFMS/PO Number (Required)

Contact Person (Required)

Telephone Number (Required)

SUMMARY OF REIMBURSEMENT
Total IV-E Reimbursement	${{number_format($total_reiumbrr,2)}}
University Request	${{number_format($reuim_to_paid,2)}}
State of GA Consortium / Admin at GSU	${{number_format($contrib_budget,2)}}
Payment Amount	${{($contrib_budget<0)?number_format($total_reiumbrr,2):number_format($reuim_to_paid,2)}}

Title IV-E Reporting	Total Reportable	Total Reimbursement
75% FFP (CB-496)	${{number_format($eligib_rt1,2)}}	${{number_format($ffp75,2)}}
50% FFP (CB-459)	${{number_format($toclaim,2)}}	${{number_format($toffp50,2)}}

I certify that this Request for Reimbursement is in accordance with the terms and conditions of the agreement.
Signature and Title of Authorized Representative	Date

{{$agency_det->NAME}}

{{($agency_det->DESIGNATION!=1)?str_replace('Proposal','Cost workbook',$rep_data[0]->PROPOSAL_NM):'Cost Workbook'}} - {{($agency_det->DESIGNATION!=1)?$term:date('F', mktime(0, 0, 0, $cwb_month, 10))}}