Memo!! by xzibit

VIEWS: 128 PAGES: 14

									Apportioment Simulation Worksheet Memo
Updated Apportionment Simulation Worksheet (ver. 4)
The simulation worksheet has been modified to allow users to include an estimate of an existing or potential general deficit factor.
This version of the simulation worksheet has been updated to assist in estimating district aportionments for fiscal year 2007-08 New First-Year Centers: The worksheet provides for input of the number of centers within a district. The effect on apportionment is to increase current year revenue in item III by the base amount and the associated COLA for the new center. The nember of such centers must be input at data imput item #8.

OUR GOAL IS TO MAINTAIN UPDATED VERSIONS OF THIS WORKSHEET TO ALLOW DISTRICTS TO SIMULATE THE IMPACT OF FTES FLUCTUATIONS IN THE 2007-08 FISCAL YEAR. The fiscal data located in tabs #1 through #5 will be updated from time to time with an email notice of the update sent to all district CBO's. IMPORTANT!!: The worksheets included in this workbook are TOTALLY UNPROTECTED. Therefore, If you chance any of the formulas in the worksheet, you willingly accept any potentially incorrect or improved results. When all else fails, download the file again.

The results obtained through the use of the worksheet are not official and do not represent any claim for apportionment adjustments.

Please provide your comments and suggestions for improving this worksheet to Ed Monroe via email at:
emonroe@cccco.edu

APPORTIONMENT SIMULATION WORKSHEET
Introduction: This simulation worksheet (version 4.0) revises and updates all previous versions with apportionment methodologies implimented subsequent to the 2006-07 P2 simulation worksheet. This post-P2 version of the worksheet is provided for the use of district administrative staff and their auditors. Worksheet output is not official and may differ from those provided in upcoming apportionment. This simulation worksheet does not attempt to calculate a system-wide general apportionment deficit coefficient or a growth-revenue deficit factor. Our intent is to provide an updated simulation worksheet reflecting recent adjustments to the apportionment model. An assumed general deficit factor can now be included in district calculations.

This worksheet includes data for a hypothetical system district. All entries associated with the example must be removed or replaced with actual data for your particular district. Please review all the yellow shaded areas below and enter your district specific data or insure the area is blank. Please ensure you are using the most version of this worksheet. The simulation workbook can be downloaded at the following address. PLEASE SAVE ANY NEW DOWNLOADS TO YOUR LOCAL DRIVE BEFORE OPENING:

http://www.cccco.edu/SystemOffice/Divisions/FinanceFacilities/FiscalServices/AllocationsSection/ApportionmentSimulators/tabid/1102/
PART A
1 Base FTES:

APPORTIONMENT INPUTS - UPDATE WITH DISTRICT SPECIFIC DATA: Enter Data Enter the base FTES for credit, noncredit, and Career Development College Prep (CDCP) noncredit FTES. The base FTES each year is the funded FTES from the previous year's recalculation. 9,373.36 credit FTES 180.47 noncredit FTES 118.18 CDCP FTES

Actual/Estimated FTES:

Enter the estimated actual credit, noncredit, and CDCP noncredit FTES for the current year. CDCP noncredit FTES is a subset of noncredit FTES.

10,143.44 credit FTES 237.41 noncredit FTES 112.85 CDCP FTES

3 Property Taxes:

Enter total estimated property tax for the district as reported by each of the district's respective county auditors (see Tab #2):

52,327,570

4 Enrollment Fees: Enter 98 percent of the total student fees reported by the district on its most recent Enrollment Fee Revenue report (see tab #3). The amount included at tab #3 is 98% or the originally reported amount. 5 Restoration/Growth Adjustment - Enter the following data from the attached Tab #1: Unrestored Decline remaining since the previous Recalculation (see Tab #1): 6 Estimated general deficit coefficient: 7 Number of first-year State-Approved Centers not reported in a previous year having >= 1,000 FTES: 8 Basic Allocation: Enter the number of colleges and centers in each of the Basic Allocation FTES ranges for colleges and centers from the attached Tab #5:

9,648,008

0.98463806 1 FTES/Center Status
State/CPEC Appr: FTES>=1,000 750<=FTES<1,000 500<=FTES<750 250<=FTES<500 100<=FTES<250

FTES/Status FTES<10,000 10,000<=FTES<20,000 FTES>=20,000 Rural

Single Coll. 0 1 0 0

Multi-College 0 0 0

Centers 0 0 0 0 0 0

9 Growth Rate :

Enter the district's growth rate from Tab #2 in the format shown here:

0.02410

10 "Program Based Funding" districts ONLY: Enter the appropriate credit base funding rate for your district as shown in Tab #4 (enter to 5 decimal places): District Credit Base Funding Rate:

2/11/20093:55 PM

CALIFORNIA COMMUNITY COLLEGES

PART B

APPORTIONMENT SIMULATION WORKSHEET (Worksheet Provided With Example District)

Workload Measures: Credit FTES Noncredit FTES Noncredit - CDCP Total FTES:

Base Funding Rate 4,367.000000 2,626.000000 3,092.000000

Marginal Funding Rate 4,564.8251 2,744.9578 3,232.0676

Base FTES 9,373.36 180.47 118.18 9,672.01

Restoration FTES 0.00 0.00 0.00 0.00

Growth FTES 770.08 56.94 -5.33

Stability FTES 0.00 0.00 0.00

Actual FTES 10,143.44 237.41 112.85 10,493.70

Funded FTES 10,143.44 237.41 112.85 10,493.70

I A B 1 2 3 C D

Base Revenues +/- Restore or Decline Basic Allocation Base Revenue Credit Base Revenue Noncredit Base Revenue Career Development College Prep NonCr - Current Year Decline Total Base Revenue less Decline

$4,236,800 $41,772,790 $40,933,463 $473,914 $365,413 $0 $46,009,590

A B C

V Other Revenue Adjustments Audit Adjustment CDCP Rate Adjustment Total Revenue Adjustments VI Stability Adjustment

$0 $0 $0 $0 $52,855,358 0.98463806 $52,043,397

II A B C

Inflation Adjustment Statewide Inflation Adjustment 4.53% Inflation Adjustment Entitlement $2,084,234 Current Year Base Revenue + Inflation Adjustment

VII Total Computational Revenue (sum of II, III, IV, V & VI) Deficit Coefficient Adjusted Revenue Entitlement VIII A B C D District Revenue Sources Property Taxes Student Enrollment Fees State General Apportionment Total Available General Revenue

$48,093,824

III Basic Allocation & Restoration Basic Allocation Adjustment Basic Allocation Adjustment COLA Restoration IV A B C D E F Growth Unadjusted Growth Rate Unadjusted Growth Cap Actual Growth Funded Credit Growth Revenue Funded Noncredit Growth Revenue Funded Noncredit CDCP Revenue Total Growth Revenue

$52,327,570 $9,648,008 -$9,932,181 $52,043,397

$1,059,200 $47,982 $0 $1,107,182 2.41% $1,043,123 $3,654,351 $3,515,281 $156,298 -$17,227 $3,654,351

IX Other Allowances and Total Apportionments State General Apportionment -$9,932,181 Full-time Faculty Adjustment Number of Faculty Not Hired Statewide Average Replacement Cost $60,289 C Net State General Apportionment -$9,932,181 A B

PART C
Basic Allocation Calculation College/Center Base Funding Rates: Single College District Funding Rates: Total FTES >=20,000 10,000<=x<20,000 x<10,000 $5,296,000 $4,236,800 $3,177,600 Single College District - College FTES >=20,000 10,000<=x<20,000 0 1 Revenue: >=20,000 $0 CPEC Approved Centers: 0 Multi-College District Funding Rates: Total FTES >=20,000 10,000<=x<20,000 x<10,000 $4,236,800 $3,707,200 $3,177,600 Multi-College District - College FTES >=20,000 10,000<=x<20,000 0 0 Total Colleges 1 Total College Revenue 4,236,800

Rural $529,600

x<10,000 0

Rural 0

x<10,000 0

10,000<=x<20,000 $4,236,800

x<10,000 $0

Rural $0

>=20,000 $0

10,000<=x<20,000 $0

x<10,000 $0

Funding Rate $1,059,200

CPEC Center Revenue $0

"Grandfathered" Centers: Funding Rates @ FTES Levels >1,000 >750 >500 $1,059,200 $794,400 $529,600 Number of Grandfathered Centers @ Total FTES >1,000 >750 0 0 Grandfathered Center Revenue: >1,000 >750 $0 $0 Total Centers: 0

>250 $264,800

250>FTES>100 $132,400

>500 0

>250 0

250>FTES>100 0

>500 $0

>250 $0

250>FTES>100 $0

Grandfathered Center Revenue $0

Total Center Revenue $0 Total Basic Allocation $4,236,800

2/11/20093:55 PM

Worksheet Calculations
Previous revenue decline not yet restored $ Potential CDCP Avail. Growth/ Restoration Rev Cr+NCr Offset credit 3,515,281 NCr 156,298 Cr + NCr 3,671,578 Potential Restore From CDCP Growth Within Total NCr 0 CDCP -17,227

Total
3,654,351 3,654,351

Restoration: CDCP Base = 0; Potential Restoration (D153) > Growth/Restoration Available (F156+G156) Restored if Reg. NCr >= 0 Restored if Reg. NCr < 0 FTES Restored (NCR>=0) FTES Restored (NCR<0) 0 0 0.00 0.00 0 0 0.00 0.00 0 0 0 0 0.00 0.00 0 0

Restoration: CDCP Base = 0; Growth/Restoration Available (F156+G156) >= Potential Restoration (D153) Restored if Reg. NCr >= 0 Restored if Reg. NCr < 0 FTES Restored (NCR>=0) FTES Restored (NCR<0) 0 0 0.00 0.00 0.00 Restoration: CDCP Base > 0; Growth/Restoration Available (I156) >= Potential Restoration (D153) Restored if Reg. NCr >= 0 Restored if Reg. NCr < 0 FTES Restored (NCR>=0) FTES Restored (NCR<0) 0 0 0.00 0.00 0 0 0.00 0.00 0 0 0 0 0.00 0.00 0 0 0 0 0.00 0.00 0 0 0 0 0.00 0.00 0 0

Restoration: CDCP Base > 0; Potential Restoration > Growth/Restoration Available Restored if Reg. NCr >= 0 Restored if Reg. NCr < 0 FTES Restored (NCR>=0) FTES Restored (NCR<0) 0 0 0.00 0.00 0 0 0.00 0.00 0 0 0 0.00 0.00 0 0

Growth (net of restoration): "Growth" revenue Growth FTES Growth NCr FTES net of cdcp 56.94 Stability FTES: 0.00 0.00 0.00 Check Stab. Sum $0 3,515,281 770.08 156,298 56.94 -17,227 -5.33 3,654,351 3,654,351 3,654,351

CDCP Funding Rate Adjustment (Applies only if CDCP Base =0)

0 0

Temp - Output

CHECKS

3,515,281

156,298 non-stability -57,567 -2,596

-17,227

3,654,351

Temp - Input

CHECKS

3,515,281

156,298

0

-17,227

3,654,351

2/11/20093:55 PM

Tab #1: 2007-08 Restoration Eligibility

District Allan Hancock Antelope Valley Barstow Butte Cabrillo Cerritos Chabot-Las Positas Chaffey Citrus Coast Compton Contra Costa Copper Mt. Desert El Camino Feather River Foothill-DeAnza Gavilan Glendale Grossmont-Cuyamaca Hartnell Imperial Kern Lake Tahoe Lassen Long Beach Los Angeles Los Rios Marin Mendocino-Lake Merced Mira Costa Monterey Peninsula Mt. San Antonio Mt. San Jacinto Napa Valley North Orange County Ohlone Palo Verde Palomar Pasadena Area Peralta Rancho Santiago

2007-08 Restoration Eligibility 782,423 0 64,085 4,578,417 13,018 2,882,879 0 0 0 0 23,463,973 24,432,430 866,925 0 72,055 428,913 857,135 0 5,697,267 0 2,127,571 0 2,263,182 547,545 2,991,263 0 0 0 4,409,531 0 92,954 0 1,888,823 0 0 344,635 0 0 0 0 0 0 0

D:\Docstoc\Working\pdf\06bd0a7f-0949-4b42-8c77-4cb817ea40d6.xls

Tab #1: 2007-08 Restoration Eligibility

District Redwoods Rio Hondo Riverside San Bernardino San Diego San Francisco San Joaquin Delta San Jose-Evergreen San Luis Obispo San Mateo Santa Barbara Santa Clarita Santa Monica Sequoias Shasta-Tehama-Trinity Sierra Siskiyou Solano Sonoma South Orange Southwestern State Center Ventura Victor Valley West Hills West Kern West Valley-Mission Yosemite Yuba

2007-08 Restoration Eligibility 4,720,496 0 10,757,682 1,490,152 0 0 0 0 0 1,544,855 0 0 0 0 2,356,873 0 1,384,121 1,695,221 1,082,511 0 159,941 426,483 4,958,797 1,974,405 0 86,656 8,477,216 2,584,323 0

Total

122,504,756

D:\Docstoc\Working\pdf\06bd0a7f-0949-4b42-8c77-4cb817ea40d6.xls

Tab #2: Property Tax (2007-08 P1); Growth Rates with Minimums Revised Growth Rates Constrained 07-08 PTax DistName Allan Hancock Joint CCD Antelope Valley CCD Barstow CCD Butte-Glenn CCD Cabrillo CCD Cerritos CCD Chabot-Las Positas CCD Chaffey CCD Citrus CCD Coast CCD Compton CCD Contra Costa CCD Copper Mountain CCD Desert CCD El Camino CCD Feather River Foothill-De Anza CCD Gavilan CCD Glendale CCD Grossmont-Cuyamaca CCD Hartnell CCD Imperial CCD Kern CCD Lake Tahoe CCD Lassen CCD Long Beach CCD Los Angeles CCD Los Rios CCD Marin CCD Mendocino-Lake CCD Merced CCD Mira Costa CCD Monterey Peninsula CCD Mt. San Antonio CCD Mt. San Jacinto CCD Napa Valley CCD North Orange County CCD Ohlone CCD Palo Verde CCD Palomar CCD Pasadena Area CCD Peralta CCD Rancho Santiago CCD Redwoods CCD Rio Hondo CCD Riverside CCD (for 07-08 P1) to the System's Growth Appropriation 1.43% 2.99% 4.36% 0.91% 0.87% 1.44% 1.26% 2.54% 2.86% 1.56% 2.32% 0.89% 7.43% 3.50% 2.40% 7.49% 2.28% 2.59% 0.83% 2.19% 1.54% 2.09% 1.66% 5.92% 6.80% 1.34% 1.60% 2.08% 2.30% 3.31% 9.44% 3.80% 1.58% 1.32% 5.12% 1.69% 0.86% 1.21% 5.52% 1.09% 0.97% 2.34% 0.69% 2.22% 1.66% 2.41% Total 2,075,264,994 187.909% DistName San Bernardino CCD San Diego CCD San Francisco CCD San Joaquin Delta CCD San Jose-Evergreen CCD San Luis Obispo County CCD San Mateo County CCD Santa Barbara CCD Santa Clarita CCD Santa Monica CCD Sequoias CCD Shasta-Tehama-Trinity CCD Sierra Joint CCD Siskiyou Joint CCD Solano County CCD Sonoma County Jr. CCD South Orange County CCD Southwestern CCD State Center CCD Ventura County CCD Victor Valley CCD West Hills CCD West Kern CCD West Valley-Mission CCD Yosemite CCD Yuba CCD 07-08 PTax (for 07-08 P1) Revised Growth Rates Constrained to the System's Growth Appropriation 2.26% 1.45% 2.92% 3.98% 1.89% 1.08% 1.41% 1.23% 8.21% 2.09% 1.96% 1.38% 2.37% 6.33% 1.14% 1.53% 3.18% 1.97% 2.07% 1.80% 4.81% 2.02% 4.38% 0.81% 1.41% 1.52%

11,602,492 6,452,425 2,131,760 10,802,082 19,289,971 7,256,976 23,273,231 18,242,065 3,854,869 85,987,693 3,872,269 79,309,729 1,378,608 21,724,952 22,987,577 4,826,034 65,038,670 14,023,190 8,103,943 31,648,252 14,837,417 5,981,865 40,320,114 3,521,397 1,537,682 10,020,190 139,189,162 58,945,043 37,619,550 6,846,026 8,670,642 73,118,828 22,563,647 16,279,230 22,684,888 21,117,395 56,707,103 13,135,334 1,041,574 54,468,506 17,774,200 25,488,637 42,620,911 8,252,724 4,954,264 29,521,546

16,493,174 72,472,159 39,891,066 28,196,724 66,078,151 28,821,921 65,755,551 19,975,576 13,520,336 10,639,894 11,217,749 11,995,678 62,906,431 3,188,337 11,484,902 40,469,443 152,985,333 19,744,909 29,544,574 49,863,095 10,908,863 2,656,423 8,461,876 63,143,429 35,954,922 19,869,815

Tab #3: Enrollment Fees (98%) from the 2007-08 P1 Enrollment Fees (98 Percent) $2,097,388 $2,286,985 $466,261 $1,920,169 $3,685,203 $3,471,111 $5,299,312 $4,802,000 $3,357,294 $9,800,000 $514,792 $8,993,566 $326,973 $2,246,514 $5,702,353 $351,011 $9,751,000 $807,312 $3,185,000 $6,099,425 $1,623,884 $1,241,518 $3,739,857 $611,370 $377,300 $3,483,630 $16,023,000 $12,369,556 $749,077 $543,765 $1,781,247 $3,330,188 $1,592,136 $6,660,324 $2,940,000 $1,323,000 $8,512,305 $2,298,439 $64,963 $5,999,297 $4,978,493 $3,704,929 $5,458,682 $834,490 $2,842,000 $7,994,349 $3,136,000 $9,924,831 $6,867,188 Enrollment Fees (98 Percent) $4,295,312 $3,503,500 $2,907,253 $5,084,273 $4,255,944 $4,900,000 $7,804,747 $1,811,123 $1,826,682 $4,100,559 $450,800 $3,363,801 $6,116,886 $8,414,109 $3,923,763 $4,898,527 $8,559,687 $1,882,772 $1,027,040 $439,910 $4,079,348 $4,214,000 $1,363,142 285,392,665

Distname ALLAN HANCOCK ANTELOPE VALLEY BARSTOW BUTTE CABRILLO CERRITOS CHABOT-LAS POSITAS CHAFFEY CITRUS COAST COMPTON CONTRA COSTA COPPER MOUNTAIN DESERT EL CAMINO FEATHER RIVER FOOTHILL-DEANZA GAVILAN GLENDALE GROSSMONT HARTNELL IMPERIAL KERN LAKE TAHOE LASSEN LONG BEACH LOS ANGELES LOS RIOS MARIN MENDOCINO-LAKE MERCED MIRACOSTA MONTEREY MT. SAN ANTONIO MT. SAN JACINTO NAPA NORTH ORANGE OHLONE PALO VERDE PALOMAR PASADENA PERALTA RANCHO SANTIAGO REDWOODS RIO HONDO RIVERSIDE SAN BERNARDINO SAN DIEGO SAN FRANCISCO

Distname SAN JOAQUIN DELTA SAN JOSE-EVERGREEN SAN LUIS OBISPO SAN MATEO SANTA BARBARA SANTA CLARITA SANTA MONICA SEQUOIAS SHASTA-TEHEMA-TRINITY SIERRA SISKIYOU SOLANO SONOMA SOUTH ORANGE SOUTHWESTERN STATE CENTER VENTURA VICTOR VALLEY WEST HILLS WEST KERN WEST VALLEY YOSEMITE YUBA TOTAL

$4,295,312 $3,503,500 $2,907,253 $5,084,273 $4,255,944 $4,900,000 $7,804,747 $1,811,123 $1,826,682 $4,100,559 $450,800 $3,363,801 $6,116,886 $8,414,109 $3,923,763 $4,898,527 $8,559,687 $1,882,772 $1,027,040 $439,910 $4,079,348 $4,214,000 $1,363,142

Tab #4: Base Funding Rates for "PBF" funded districts

Base Credit DistName Foothill-De Anza CCD Lake Tahoe CCD Lassen CCD Marin CCD Mira Costa San Francisco San Jose-Evergreen CCD Santa Monica CCD South Orange West Kern CCD Funding Rate

$4,396.1113500 $4,493.4453190 $4,414.4755310 $4,955.1405750 $4,379.2651760 $4,423.3837800 $4,385.4677850 $4,441.9630620 $4,515.8403510 $6,373.3972110

Educational Centers Approved for Apportionment College centers eligible for the Basic Allocation. This list includes both State approved educational centers and grandfathered or prevously approved centers

Please review the centers listed below associated with your district. Contact Ed Monroe at (916) 327-6226 or emonroe@cccco.edu if you have questions or updates to this list. Updated: 03/20/08 District Allan Hancock Joint CCD/ Cabrillo CCD/ Chaffey CCD/ Contra Costa CCD/ Kern CCD/ Long Beach CCD/ Los Rios CCD/ Marin CCD/ MiraCosta CCD/ Mt. San Jacinto CCD/ North Orange County CCD Palomar CCD Riverside CCD San Francisco CCD San Luis Obispo County CCD Santa Clarita CCD Santa Monica CCD Sequoias CCD Sierra CCD Solano County CCD Sonoma County JCD Southwestern CCD State Center CCD State Approved Centers Lompoc Valley Center Watsonville Center Fontana Learning Center Chino Center San Ramon Valley Center Delano Center Eastern Sierra Center Pacific Coast Campus Natomas Education Center Indian Valley Campus San Elijo Center Community Learning Center Menifee Valley Center School of Continuing Education Escondido Center Norco Valley Center Moreno Valley Center San Francisco Downtown CC Center North County Center Canyon Country Center Academy of Entertainment Technology Center for Agriculture Science and Technology Western Nevada County Center Vacaville Center Petaluma Center Otay Mesa Center Vocational Training Center Madera County Education Center Willow International Center Woodland Center Lake County Center

Yuba CCD

District Updated: 03/20/08 Antelope Valley CCD/ Foothill-DeAnza CCD/ Glendale CCD/ Hartnell CCD/ Kern CCD/ Los Rios CCD/ Mendocino-Lake CCD/ Merced CCDMerced CCD/ Monterey Peninsula CCD/ Napa Valley CCD/ Ohlone CCD Palo Verde CCD Pasadena Area Rancho Santiago CCD Redwoods CCD San Diego CCD

Grandparented or Previously Approved Centers Palmdale Center Middlefield Center Garfield Center King City Center Southern Kern Southwest Center El Dorado Center Willits Center Lake County Center Los Baños Center Ft. Ord Center Upper Valley Center Newark Center Needles Center Community Education Center Centennial Education Center Del Norte Center Mendocino Coast Center West City Campus Education Cultural Complex Mid-City Campus North City Campus Centre City Campus & Skills Center John Adams CC Center Alemany CC Center John O'Connell/Evans Trade Tech Center Mission CC Center Southeast CC Center Airport CC Center Chinatown/North Beach CC Center Tracy Center Schott Continuing Ed. Center Goleta Valley Center Criminal Justice Training Center, Windsor North District Center

San Francisco CCD

San Joaquin Delta CCD Santa Barbara CCD Sonoma County JCD West Hills CCD

Note: The SB 361 grandparented centers (now referred to as "State approved" centers) shown on this list are
derived from a list of centers identified as CPEC approved "grandfathered" centers in operation prior to April 1974. That list of approved grandparented centers was further modified based on the following considerations: 1) The center is owned or controlled thru a long-term lease by the district; 2) It has been in continuous operation since 1974; 3) It is a "comprehensive" center with an administrator and student services on site; 4) It served at least 100 FTES during 2006-07.


								
To top