=;d#X1Arial1Arial1Arial1Arial1Arial1Arial1Arial1Arial1
Arial1Arial1
Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)5*0_("$"* #,##0_);\("$"* #,##0\);_("$"* ""_);_(@_),)'_(* #,##0_);\(* #,##0\);_(* ""_);_(@_)=,8_("$"* #,##0.00_);\("$"* #,##0.00\);_("$"* ""??_);_(@_)4+/_(* #,##0.00_);\(* #,##0.00\);_(* ""??_);_(@_)
"$"#,##0.)_(* #,##0_);_(* \(#,##0\);_(* ""_);_(@_)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* ""_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* ""??_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* ""??_);_(@_) & " ' ( # "0@ ' ( ` ( "8@ "8@ "8@
*8@ '!t &8@@ &8@ &8@ @ '"4` @ @ '"<` ' $` ' $` ' $` @ ' $a@ @ ' $a@ `@ (` (f@@ 8@ "0@ (@@ # # 0 0 8 8` 0` 0` 8 8@ 0@ 8f@ 0f@ 8 8@ 8 H '" '" " ' ' @ "8@ "0@ ' $` @ ' a@ @ a@ ' a@ ' a`@ ' ` "@ ' ` @ ' `` "0 "`@ ( ( ' $` @ ' a@ @ "8`@ ' @@ @ @ ' `@ ' a@ ' @ a@ `@ ` ` @@ @ @ " "`@ ' ` ' a@ @ "f@ ' af@ @ "`@ '"`` "@ '"` @ *8@ "8@ @ "0 (@@ 8@ 0@ @@ @ @ @@ @ #p #P ' a@ "@ #JUV for 2006 Budget and Interim ## ;BudgetFY2006 InterimFY2006 ActualsFY2005PeriodA"ActualsColCodeBE_JUsedFYCA #2CBsI ##""dJUsedColCodeCA #2CBsI IPBB""NOMSGFormAbbrJUV&SheetPageHeader1:s0SchoolNamePrintschoolnameprint"
vbcrlf
Ao
Ao
LeanameleAnAme&
Countyname
CoUnTyNaMe&
PeriodDesc
PeRiOdDeScaJUsedDescCA #"2CBsI #!# ""&UsedFY2CBt"FundNameFuNdNaMe CountyCoUnTyLEALeA SchoolScHoOl(
HiddenRows,k+
HiddenColumns,CLOSEMSG:"CLOSEMSGTYPE: Page13 Page24o Page3So%
StartingCell(64,11)"
BudgetDescBudget.InterimDescInterim Projected(ActualsDescActualsDesc& ActualsPriorFYC(HideRow[I,,HIDEROWS,1]
dMbP?_*+%&L{LEAName} SHEET DEFINED
{CountyName}&C{PeriodDesc}
{ActualsFY}{ActualsFY2} {ActualsDesc}
COUNTY SCHOOL SERVICE FUND
JUVENILE COURT AND COUNTY COMMUNITY SCHOOLS ACCOUNT&R{County} {LEA}
Form {FormAbbr}&LCalifornia Dept of Education
SACS Financial Reporting Software  {Version}
File: juv (08/06/2007)&CPage &P of &N&RPrinted: &D &T
&?'?(?)?"UdXX??HHH@}& F}mF}$F}IF}$F}F}+F} UF}
F}F}F}
/F}gF}UF}*!F}& F}F}F}U?F}QF}F}F}F}& F@@s@ @
!"#$%&'()*+,./0123456789:;<=>?@A@B@CDEF@GHI@J@KLMNOPQRSTUVWXYZ[\] ^_`abcdef @g @hi jls@u v w x @y @z @{ @ @} @~ @ @ @ @@$@
@
8 @**&'''''()IIIIIIIIII*
+TotalJJJJJJJJJJ%Programmer Notes:KFBDescription (Funds 01, 09, and 62; resources 2400, 2410, and 2420)G99: wObject Codes
xProgramsJJFunds
JObjectsJ FunctionsJGoalsJ Resources
JJJextractJA. 4REVENUES"4444yzIIIIIIIIK5x[R,,USSUMM,OB,FN,GO,,RS,FU,C,C ]'$x[R,,USSUMM,OB,FN,GO,,RS,FU,2005,BE]IwFor all cells except where indicated differently, extract funds 01, 03, 06, 09, and 62; resources 2400, 2410, and 2420*1)/9&Revenue Limit Transfers  Current Year99:~ @
,B1("Fundcode in ('01','03','06','09','62')"
L@D
3*"ResourceCode in ('2400', '2410', '2420')"
k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ]ur[R,.11,USSUMM,8091,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]extract*2).9%Revenue Limit Transfers  Prior Years99: @,
L@D k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ]ur[R,.11,USSUMM,8099,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]extract * 3) 9Other Local Revenue 99:+ $"8631, 8650, 8660, 8662, 8699, 8710
,R@
D
L;"Objectcode in ('8631','8650','8660','8662','8699','8710')" k[R,.$
B ,USSUMM,D
,D ,D ,,D,D,C,C ][R,.11,USSUMM,"Objectcode in ('8631','8650','8660','8662','8699','8710')",,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE] extract
*
4)
9
Contributions
99:
89808999
,RK

L$Objectcode between '8980' and '8999'
k[R,.$
B ,USSUMM,D
,D
,D
,,D,D,C,C ][R,.11,USSUMM,Objectcode between '8980' and '8999',,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]
extract*}5)*?!TOTAL, REVENUES (Sum lines A1A4)99: #
p=ணB
%
L
calcB. ypEXPENDITURES (in accordance with EC Section 42238.18(b)) (Goals 0000, 3500 & 3600, except where noted otherwise)&44444RL
*
1)F
?=Direct Instructional Costs (Goals 3500 & 3600, Function 1000)$
99:QdOMLLMMMMM
*a)9Teachers' Salaries
9:~ Q0@
ip=#A
fN
L0@D ~L@@&M"Goalcode in ('3500','3600')"NNNk[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,1100,1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]N5,extract with goals 3500 &3600, Function 1000
*b)$9Other Certificated Salaries
9: @,
L@D ~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,1900,1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*c)&9Instructional Aides' Salaries
9:~ h@
.HzFA
Lh@D ~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,2100,1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*d)"9Other Classified Salaries
9: @.
L@D ~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,2900,1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*e)9Employee Benefits
9: 30003999
.{GA

L$Objectcode between '3000' and '3999'~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,Objectcode between '3000' and '3999',1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*f)9Books and Supplies
9: 40004499~
.b@

L$Objectcode between '4000' and '4499'~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,Objectcode between '4000' and '4499',1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*g)29)Services and Other Operating Expenditures
9: 50005999
.33333@

L$Objectcode between '5000' and '5999'~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,Objectcode between '5000' and '5999',1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*h);92Capital Outlay (Equipment & Equipment Replacement)
9: 64006500~
.

L$Objectcode between '6400' and '6500'~L@@&M"Goalcode in ('3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ][R,.11,USSUMM,Objectcode between '6400' and '6500',1000,"Goalcode in ('3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]5,extract with goals 3500 &3600, Function 1000
*i)>95Total, Direct Instructional Costs (Sum lines B1aB1h)9: #
.̾1A
%
;LLM
calc*2)9Direct Support Costs$99:QSMMLMMMMMM
*>95(Functions 20002999, 30003600, 3900, and 80008999)$99:QjNNLNNNNNN
*a)9Teachers' Salaries
9: Q0@U
NN
L0@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"NNNk[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,1100,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]N[Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
*b),9#Certificated Pupil Support Salaries
9: @.
L@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,1200,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE][Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
*c)?96Certificated Supervisors' and Administrators' Salaries
9:~ P@
.Q]A
LP@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,1300,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE][Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
*d)$9Other Certificated Salaries
9: @.S@
L@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,1900,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE][Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
*e)$9Classified Support Salaries
9: 0@.
L0@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,2200,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE][Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
*f)=94Classified Supervisors' and Administrators' Salaries
9: @.J@
L@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,2300,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE][Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
*g)%9Clerical and Office Salaries
9:~ @
.3333@
L@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')M$"Goalcode in ('0000','3500','3600')"k[R,.$
B ,USSUMM,D
,D,D,,D,D,C,C ].+[R,.11,USSUMM,2400,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE][Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
* h)" 9Other Classified Salaries
9:~ @
.ףp=j@
L@D N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999') M$"Goalcode in ('0000','3500','3600')" k[R,.$
B ,USSUMM,D
,D ,D ,,D,D,C,C ].+[R,.11,USSUMM,2900,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE] [ Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
!*!i)!9Employee Benefits
!9:! 30003999!
.q=
ד@
!!
L$Objectcode between '3000' and '3999'!N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')!M$"Goalcode in ('0000','3500','3600')"!!k[R,.$!
B ,USSUMM,D!
,D!,D!,,D,D,C,C ]NK[R,.11,USSUMM,Objectcode between '3000' and '3999',(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]![!Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
"*"j)"9Books and Supplies
"9:" 42004499"
.G@
""
L$Objectcode between '4200' and '4499'"N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')"M$"Goalcode in ('0000','3500','3600')"""k[R,.$"
B ,USSUMM,D"
,D",D",,D,D,C,C ]NK[R,.11,USSUMM,Objectcode between '4200' and '4499',(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]"["Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
#*#k)2#9)Services and Other Operating Expenditures
#9:# 50005999#
.̅vA
##
L$Objectcode between '5000' and '5999'#N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')#M$"Goalcode in ('0000','3500','3600')"##k[R,.$#
B ,USSUMM,D#
,D#,D#,,D,D,C,C ]NK[R,.11,USSUMM,Objectcode between '5000' and '5999',(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]#[#Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
$*$l)$9Capital Outlay
$9:$ 61006500~$
.
$$
L$Objectcode between '6100' and '6500'$N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')$M$"Goalcode in ('0000','3500','3600')"$$k[R,.$$
B ,USSUMM,D$
,D$,D$,,D,D,C,C ]NK[R,.11,USSUMM,Objectcode between '6100' and '6500',(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]$[$Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
%*%m)+%E"Transfers of Direct Support Costs
%9:% ʼ@,
%%
Lʼ@D% %N(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999')%M$"Goalcode in ('0000','3500','3600')"%%k[R,.$%
B ,USSUMM,D%
,D%,D%,,D,D,C,C ].+[R,.11,USSUMM,7370,(FunctionCode between '2000' and '2999' OR FunctionCode between '3000' and '3600' OR FunctionCode = '3900' OR FunctionCode between '8000' and '8999'),"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]%[%Rextract with goals 3500 &3600, Functions 20002999, 30003600, 3900, and 80008999
&*&n)8&9/Total, Direct Support Costs (Sum lines B2aB2m)&9: #&
.p=J0A
%%
$&L
&calc'*'3)%'9Debt Service (Function 9100)'99:' " 74387439~'
/@
''
L$Objectcode between '7438' and '7439'~'L@'M$"Goalcode in ('0000','3500','3600')"''k[R,.$'
B ,USSUMM,D'
,D',D',,D,D,C,C ][R,.11,USSUMM,Objectcode between '7438' and '7439',9100,"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]'5',extract with goals 3500 &3600, Function 9100(*(4)(9$Deferred Maintenance (Function 9300)(99:( "@/@
((
L@D( ~(L*@(M$"Goalcode in ('0000','3500','3600')"((k[R,.$(
B ,USSUMM,D(
,D(,D(,,D,D,C,C ][R,.11,USSUMM,7615,9300,"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE](5(,extract with goals 3500 &3600, Function 9300)*)5)6)9SUBTOTAL (Lines B1i plus B2n plus B3 plus B4))99:! )
,hAAD
D&
D'
D(
)L
)calc***6)J*9AIndirect Costs and All Other Costs (not to exceed 10% of Line B5)$*99:"SMMLMMMMMM
+* +a)@+;7Transfers of Indirect Costs for General Administration "+9:"TNNLNNNNNN,* ,;(Function 7210)
,9:~, "@,
UG:A
,NN,
L@D, ~,L*@,M$"Goalcode in ('0000','3500','3600')",NNN,k[R,.$,
B ,USSUMM,D,
,D,,D,,,D,D,C,C ][R,.11,USSUMM,7310,7210,"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE],N5,,extract with goals 3500 &3600, Function 7210
* b)G;>All Other Costs (Resources 24002420, goals 0000, 3500 & 3600,"9:"SMMLMMMMMM.* 3.;*objects 10007999, minus lines B5 and B6a).9:" '.
h{ǹAD.D)
D,
.NN.
L$ObjectCode between '1000' and '7999'.N.M$"Goalcode in ('0000','3500','3600')"
.NN~.N
A.k[R,.$.B ,USSUMM,D.
,D.,D.,,D,D,C,C ][R,.19,USSUMM,ObjectCode between '1000' and '7999',,"Goalcode in ('0000','3500','3600')",,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE].Nb.Yextract Resources 24002420, goals 3500 & 3600, objects 10007999, minus lines B4 and B5a
/* /c)F/;=Total, Indirect Costs and All Other Costs (Sum lines B6aB6b)/9:! #/
,q=
?
%*.
/L
/calc
0* 0d)00;'Less: Maximum Allowed (10% of Line B5)
09:R0 <D1
"Excessive costs; revise and#
B 0
0nA
D)
0L
0calc
1* 1e)G1;>Unallowable Costs (Lines B6c minus B6d) (Must not be positive)
19:H1 {2D1
reimport G/L data#
B!1
01LAD/
D0
1L
1calc2*27)02;'TOTAL, EXPENDITURES (Lines B5 plus B6c)299:! !2

AD)
D/
2LX2]B[W,.$2
B ,USEL,CD2,C,C ]+([W,.11,USEL,JUV.TOTAL.ALLOW.EXP,2005,BE]2.TOTAL.ALLOW.EXP2$calc and save as JUV.TOTAL.ALLOW.EXP33C. D3C;NET INCREASE (DECREASE) IN FUND BALANCE (Lines A5 minus B7)3DDDDu %3
vp=`$BD
D2
F3L
3calc46D.4AFUND BALANCE, RESERVES&4BBBB[,L5*51)59Beginning Balance$599:QUMMLMMMMMM
6*6a)"69As of July 1  Unaudited
69:6 Q@UO"A
6NN6
L@D6 6NNNNN6k[R,.$6
B ,USSUMM,D6
,D6,D6,,D,D,C,C ]ur[R,.11,USSUMM,9791,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]6N6extract
7*7b)79Audit Adjustments
79:7 @.9@
77
L @D7 77k[R,.$7
B ,USSUMM,D7
,D7,D7,,D,D,C,C ]ur[R,.11,USSUMM,9793,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]77extract
8*8c)389*As of July 1  Audited (Sum lines D1aD1b)89: #8
.O"A
%57
'8L
8calc
9*9d)99Other Restatements
99:9 !@.:@
99
L!@D9 99k[R,.$9
B ,USSUMM,D9
,D9,D9,,D,D,C,C ]ur[R,.11,USSUMM,9795,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]99extract
:*:e)7:9.Adjusted Beginning Balance (Sum lines D1cD1d):9: #:
.O"A
%89
:L
:calc;*;2)3;9*Ending Balance, June 30 (Lines C plus D1e);99: $;
ap=cϡB$3
$:
B;LX;]B[W,.$;
B ,USEL,CD;,C,C ]# [W,.11,USEL,JUV.END.BAL,2005,BE];.END.BAL%;calc and save as JUV.END.BAL
<**<9!Components of Ending Fund Balance$<99:QSMMLMMMMMM
=*=a))=9 Reserve for Prepaid Expenditures
=9:~= Q@=
hNN=
L@D= =NNNNN=k[R,.$=
B ,USSUMM,D=
,D=,D=,,D,D,C,C ]ur[R,.11,USSUMM,9713,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]=N=extract
>*>b)#>9Legally Restricted Balance
>9:> @,<@
>>
L@D> >>k[R,.$>
B ,USSUMM,D>
,D>,D>,,D,D,C,C ]ur[R,.11,USSUMM,9740,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]>>extract
?*?c).?9%Designated for Economic Uncertainties
?9:? @a=@
??
L@D? ??k[R,.$?
B ,USSUMM,D?
,D?,D?,,D,D,C,C ]ur[R,.11,USSUMM,9770,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]?X?]B[W,.$?
B ,USEL,CD?,C,C ][W,.11,USEL,JUV.DEU,2005,BE]
?.DEU$?extract and save as JUV.DEU@*@1)@9xCBsAG@Beginning Balance (Preloaded PY unaudited actual ending balance)Beginning BalanceBC@Beginning Balance (Preloaded PY unaudited actual ending balance)
@:Q ~@
b@@@L`@JCA%[I,.$@
B ,celllock,1]No cell lockB[I,.11,celllock,1]e@OCA,[R,.11,STEL,JUV.DEU,C#,BA,,A]
No extractB"[R,.11,STEL,JUV.DEU,2004,BA,,A]@@]CAF[W,.$@
B ,USEL,CD@,C,C ]J[RW,.$@
B ,USEL,CD@,C,C ]B'$[W,.11,USEL,JUV.DEU.BEG.BAL,2005,BE]@.DEU.BEG.BAL7@.input (or extract) and save as JUV.DEU.BEG.BALA*A0A?'a) Audit Adjustments/Other RestatementsA:QUL_AICBsA #$* not hidden for Unaudited ActualsB# not hidden for Unaudited Actuals
AA]B*B4B?+ (Must not exceed Line D1b plus Line D1d)B?B {$B
$7
$9
$B
$J
$7
$9
B%Unbalanced; revise entry#
BB
OL_BICBsA #$* not hidden for Unaudited ActualsB# not hidden for Unaudited Actuals
B}B]gCBsAG[RW,.$B
B ,USEL,CDB,C,C ]
B,)[RW,.11,USEL,JUV.DEU.BEG.BAL.ADJ,2005,BE]B.DEU.BEG.BAL.ADJ.B%input and save as JUV.DEU.BEG.BAL.ADJC*C2)2C9)Less: Current Uses (Must not be negative)C:XC PB$C
$Negative amount; revise input#
B~C
@@CLYC]C[RW,.$C
B ,USEL,CDC,C,C ]%"[RW,.11,USEL,JUV.DEU.USES,2005,BE]C .DEU.USES'Cinput and save as JUV.DEU.USESD*D3);D92Plus: Current Contributions (Must not be negative)D:XD PB$D
$Negative amount; revise input#
B Negative amount; revise input~D
bpDLYD]C[RW,.$D
B ,USEL,CDD,C,C ](%[RW,.11,USEL,JUV.DEU.CONTRIB,2005,BE]D.DEU.CONTRIB*D!input and save as JUV.DEU.CONTRIBE*E}4)IE?@Subtotal (Lines D2c1 minus D2c2 plus D2c3) (Must equal Line D2c)E:WE #ADE
D?
%Unbalanced; see Uses/Contribs.#
B!Unbalanced; see Uses/Contribs..E
,$@
$D
B$C
EL
EcalcF*F~d)WFNDesignated for the Unrealized Gains of Investments and Cash in County Treasury
FF @,>@
FF
L@DF FMMMMFk[R,.$F
B ,USSUMM,DF
,DF,DF,,D,D,C,C ]ur[R,.11,USSUMM,9775,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]FMFextractG*G}e)G?Capital Outlay Reserve
G?:G @a?@
GG
L@DG GGk[R,.$G
B ,USSUMM,DG
,DG,DG,,D,D,C,C ]ur[R,.11,USSUMM,9780,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]GXG]B[W,.$G
B ,USEL,CDG,C,C ].+[W,.11,USEL,JUV.CAP.OUTLAY.RESERVE,2005,BE]G.CAP.OUTLAY.RESERVE3G*extract and save as JUV.CAP.OUTLAY.RESERVEH*H1)H9xCBsAG@Beginning Balance (Preloaded PY unaudited actual ending balance)Beginning BalanceBC@Beginning Balance (Preloaded PY unaudited actual ending balance)
H:Q ~H
bp@HL`HJCA%[I,.$H
B ,celllock,1]No cell lockB[I,.11,celllock,1]tH^CA;#[R,.11,STEL,JUV.CAP.OUTLAY.RESERVE,C#,BA,,A]
No extractB1.[R,.11,STEL,JUV.CAP.OUTLAY.RESERVE,2004,BA,,A]HH]CAF[W,.$H
B ,USEL,CDH,C,C ]J[RW,.$H
B ,USEL,CDH,C,C ]B'$[W,.11,USEL,JUV.CAP.BEG.BAL,2005,BE]H.CAP.BEG.BAL7H.input (or extract) and save as JUV.CAP.BEG.BALI*I0I?'a) Audit Adjustments/Other RestatementsI?QUL_IICBsA #$* not hidden for Unaudited ActualsB# not hidden for Unaudited Actuals
II]J*J4J?+ (Must not exceed Line D1b plus Line D1d)J?J {$J
$7
$9
$B
$J
$7
$9
B%Unbalanced; revise entry#
BJ
OL_JICBsA #$* not hidden for Unaudited ActualsB# not hidden for Unaudited Actuals
J}J]gCBsAG[RW,.$J
B ,USEL,CDJ,C,C ]
B,)[RW,.11,USEL,JUV.CAP.BEG.BAL.ADJ,2005,BE]J.CAP.BEG.BAL.ADJ.J%input and save as JUV.CAP.BEG.BAL.ADJK*K2)2K@)Less: Current Uses (Must not be negative)K:TK P>DK
$Negative amount; revise input#
B~K
@KLYK]C[RW,.$K
B ,USEL,CDK,C,C ]%"[RW,.11,USEL,JUV.CAP.USES,2005,BE]K .CAP.USES'Kinput and save as JUV.CAP.USESL*L3);L@2Plus: Current Contributions (Must not be negative)L:TL P>DL
$Negative amount; revise input#
B~L
bALLp=cϡB $;
L
LYL]C[RW,.$L
B ,USEL,CDL,C,C ](%[RW,.11,USEL,JUV.CAP.CONTRIB,2005,BE]L.CAP.CONTRIB*L!input and save as JUV.CAP.CONTRIBM*M4)JM9ASubtotal (Lines D2e1 minus D2e2 plus D2e3) (Must equal Line D2e) M:_M PI$M
$G
%Unbalanced; see Uses/Contribs.#
B!Unbalanced; see Uses/Contribs..M
UXA$H
$L
B$K
MO7M]@!D=
D>
D?
DF
DG
M
L
Mcalc
N*Nf),N@#Undesignated/Unappropriated Amount
N9:^N PH$N$O
$Unbalanced; check import TRCs#
B Unbalanced; check import TRCs
N
SMANMp=H`ϡB+$;
D=
D>
D?
DF
DG
N
LMMMMMMO*EO@<(Must equal Line D2 minus Lines D2a, D2b, D2c, D2d, and D2e)
O9:~O Q@O
Vq=p_ϡB
ONNO
L@DO ONNNNNOk[R,.$O
B ,USSUMM,DO
,DO,DO,,D,D,C,C ]ur[R,.11,USSUMM,9790,,,,"ResourceCode in ('2400', '2410', '2420')","Fundcode in ('01','03','06','09','62')",2005,BE]ONOextractPE. AP815% CALCULATION (in accordance with E.C. 42238.18(b)(4))&P5WLQQ1)&QTotal, Expenditures (Line B7)Q Q
t
AD2
QL
QlinkRremove page breakRkRl2)6Rm15% of Total Expenditures (Line E1 times 15%)Rmmmr )R
V@DQ
333333?RL
RcalcSnF. 3So*AMOUNT IN EXCESS OF ALLOWABLE 15% TRANSFER&SppppqsLT*T1)RT?IDesignated for Economic Uncertainties  Current Contributions (Line D2c3)T??: T
,p $D
TL
TlinkU*U2)CU9:Capital Outlay Reserve  Current Contributions (Line D2e3)U99: U
.A $L
UL
UlinkV*V3)+V9"Total, Transfers (Sum lines F1F2)V99: #V
.
A
%TU
VL
VcalcW*W4)*W9!15% Allowable Transfers (Line E2)W99: W
.@ $R
WL
WlinkX*X5)0X9'Amount in Excess of Allowable TransfersX99?LX X6DY
Excessive transfers; #
BExcessive transfers; X
YMMLMMMMMM
Y*LY@C(Lines F3 minus F4, or 0 if negative amount) (Must not be positive)Y99?SY \=DY
#reduce current contributions#
Breduce current contributionsCY
Z@ADV
DW
DV
DW
BYNNLNNNNNNXY]B[W,.$Y
B ,USEL,CDY,C,C ].+[W,.11,USEL,JUV.AMOUNT.EXCESS.XFRS,2005,BE]Y.AMOUNT.EXCESS.XFRS0Y'calc and save as JUV.AMOUNT.EXCESS.XFRSZ6G. 7ZA.AMOUNT IN EXCESS OF ALLOWABLE 15% FUND BALANCE&ZBBBB[,L[*[1)*[9!Ending Balance, June 30 (Line D2)[99: [
,p=cϡB $;
[L
[link\*\2)1\;(Less: Capital Outlay Reserve (Line D2e) \99: \
,?@DG
\L
\link]*]3..]% 3) Plus: Unallowable Costs (B4e)] ]
,1LA $1
]L^*^3)8^9/Adjusted Net Ending Balance (Lines G1 minus G2)^99: )^
.p=cϡB$[
$\
^L
^calc_*_4)R_9I15% Allowable Net Ending Balance (Line E2) or $25,000 (whichever is more)_99: ?_
@)$R
a
$R
aB_L
_calc`*`5)5`9,Amount in Excess of Allowable Ending Balance$`99:QdOMLMMMMMM
a*.a;%(Lines G3 minus G4, or 0 if negative)$a99:QefNLNNNNNN
b12Kb<B(If positive, the amount is subject to reduction in apportionment)b==>c 7b
gp=ʡB!Db
$b
B
bfN!b
Mp=ʡBD^
D_
bNNNNNNXb]B[W,.$b
B ,USEL,CDb,C,C ]1.[W,.11,USEL,JUV.AMOUNT.EXCESS.END.BAL,2005,BE]b.AMOUNT.EXCESS.END.BAL3b*calc and save as JUV.AMOUNT.EXCESS.END.BAL*cKKKKKKKKKKKKod?fI certify that juvenile court, county group home and institutions, and county community schools funds (d??????Oe?Fhave been expended in accordance with Education Code Section 42238.18.(e??????f g h7
Signature:h7777h Date:h
hboth cells lockedi j7Contact Person:j7777^j
Telephone:j
^[j]E[RW,.$jB ,USEL,C .CONTACT,C,C ]# [RW,.9,USEL,JUV.CONTACT,2005,BE]Yj]C[RW,.$j
B ,USEL,C.PHONE,C,C ]"[RW,.11,USEL,JUV.PHONE,2005,BE]?j6input both cells and save as JUV.CONTACT and JUV.PHONEl8Email:l8888^Yl]C[RW,.$lB ,USEL,C.EMAIL,C,C ]![RW,.9,USEL,JUV.EMAIL,2005,BE]$linput and save as JUV.EMAILs_&LC
CC
C&CC
CC C
C6
Juvenile Court and County Community Schools Account&RCC00A0 C C
Form JUV&Lschoolnameprint
leAnAme
CoUnTyNaMe&CPeRiOdDeSc
200506 ActualsDesc
FuNdNaMe
Juvenile Court and County Community Schools Account&R
CoUnTy LeA ScHoOl
Form JUVs DWarning...
There are unbalanced/incomplete data in this form. Please enter and/or
correct data to balance the following items:
Warning  Line D2c3 is negative; revise input
Warning  Line D2c4 does not equal Line D2c; enter/revise DEU Current Uses/
Contributions
Warning  Line D2e4 does not equal Line D2e; enter/revise Capital Outlay
Reserve Current Uses/Contributions
Warning  Line F5 is positive; reduce current contributions
Warning  Line D2f does not equal EFB minus CEFB; check TRC for invalid codes
Warning  Contact name and/or telephone number have not been entered
s
<>>Q
;Dv
Dw
Dx
Dy
Dz
D{
D
D~
D
D
Warning  Line D2c3 is negative; revise inputWarning  Line D2c4 does not equal Line D2c; enter/revise DEU Current Uses/
ContributionsWarning  Line D2e4 does not equal Line D2e; enter/revise Capital Outlay
Reserve Current Uses/ContributionsWarning  Line F5 is positive; reduce current contributionsWarning  Line D2f does not equal EFB minus CEFB; check TRC for invalid codesWarning  Contact name and/or telephone number have not been entered?)D
UnbalancedB
UnbalancedX
B[W,.$B ,USEL,CD,C,C ]&#[W,.13,USEL,JUV.UNBALANCED,2005,BE].UNBALANCEDe`ODDC
BDDC
BWarning  Line D2c3 is negative; revise input
Warning  Line D2c4 does not equal Line D2c; enter/revise DEU Current Uses/
Contributions
Warning  Line D2e4 does not equal Line D2e; enter/revise Capital Outlay
Reserve Current Uses/Contributions
Warning  Line F5 is positive; reduce current contributions
Warning  Line D2f does not equal EFB minus CEFB; check TRC for invalid codes
Warning  Contact name and/or telephone number have not been entered
3 `*combine Fatal and Warning (if either/both)
``oD OKXD
Warning...CI There are unbalanced/incomplete data in this form. Please enter and/orC/ correct data to balance the following items:CCDC
Warning...CX There are unbalanced/incomplete data in this form. Please enter and/or correct data: CCDC"BWarning...
There are unbalanced/incomplete data in this form. Please enter and/or
correct data to balance the following items:
Warning  Line D2c3 is negative; revise input
Warning  Line D2c4 does not equal Line D2c; enter/revise DEU Current Uses/
Contributions
Warning  Line D2e4 does not equal Line D2e; enter/revise Capital Outlay
Reserve Current Uses/Contributions
Warning  Line F5 is positive; reduce current contributions
Warning  Line D2f does not equal EFB minus CEFB; check TRC for invalid codes
Warning  Contact name and/or telephone number have not been entered
]<< used
]`Dv
Dw
Dx
Dy
Dz
D{
D
D}
FDv
Dv
C
BDw
Dw
C
BDx
Dx
C
BDy
Dy
C
BDz
Dz
C
BD{
D{
C
BD
D
C
BD}
D}
C
BBa^Warning  Line D2c3 is negative; revise input
Warning  Line D2c4 does not equal Line D2c; enter/revise DEU Current Uses/
Contributions
Warning  Line D2e4 does not equal Line D2e; enter/revise Capital Outlay
Reserve Current Uses/Contributions
Warning  Line F5 is positive; reduce current contributions
Warning msg`D~
D
D
~D~
D~
C
BD
D
C
BD
D
C
BBWarning  Line D2f does not equal EFB minus CEFB; check TRC for invalid codes
Warning  Contact name and/or telephone number have not been entered
Warning msg>@
Ud& `
!!""##$$%%&&''))**++,,..//00112233445566778899::;;<<==>>??@@CCDDEEGGhhHHKKLLMMRRSSTTNNOOPPUUVVWWXXYYZZ[[\\jjll``aabbdd ^^__ee FFQQ((AABBIIJJ