A spreadsheet is attached that shows 2004-2005 total certified salaries and benefits paid from the Teacher Salary Fund and the Operating Fund, total certified athletic salaries and benefits paid from the Teacher Salary Fund and Operating Fund, and a column headed “Percentage Athletic." This percentage was calculated by dividing total certified athletic salaries and benefits by total certified salaries and benefits. This percentage can be used by school districts to allocate a portion of Property Insurance, Utilities, and Maintenance expenditures to athletics. This percentage allocation method is optional. A district may use its own method to allocate these expenditures as long as the method used is reasonable and well documented.
Step 1-Allocation of Property Insurance:
Total District Cost of Property Insurance x Allocation Percentage = Property Insurance to Charge to Athletics
AT THIS TIME DISTRICTS ARE NOT REQUIRED TO CHARGE THIS TO THE CAMPUS LEVEL.
Example Journal Entry:
DR 2000 26XX 000 115 00 65210 $ ?.?? (Property Insurance)
CR 2000 26XX 000 000 00 65210 $ ?.?? (Property Insurance)
Step 2-Allocation of Utilities:
Total District Cost of Utilities x Allocation Percentage =Utilities to Charge to Athletics
AT THIS TIME DISTRICTS ARE NOT REQUIRED TO CHARGE THIS TO THE CAMPUS LEVEL.
Example Journal Entry:
DR 2000 26XX 000 115 00 ...64110 $ ?.?? (Water & Sewer)
...........................................66210 $ ?.?? (Natural Gas)
...........................................66220 $ ?.?? (Electricity)
CR 2000 26XX 000 000 00 ....64110 $ ?.?? (Water & Sewer)
...........................................66210 $ ?.?? (Natural Gas)
...........................................66220 $ ?.?? (Electricity)
Step 3-Allocation of All Other Maintenance Expenditures:
Total District Charges to Operating Fund Function 26* Less Property Insurance and Utilities x Allocation Percentage =
Maintenance to Charge to Athletics
AT THIS TIME DISTRICTS ARE NOT REQUIRED TO CHARGE THIS TO THE CAMPUS LEVEL.
Example Journal Entry:
DR 2000 26XX 000 115 00 68400 $ ?.?? (Indirect Cost)
CR 2000 26XX 000 000 00 68400 $ ?.?? (Indirect Cost)
The account number 68400 for “Indirect Cost” is recommended. The other option would be to debit and credit each separate account in function 26*. Caution: This calculation should result in the TOTAL athletic portion of maintenance expenditures (other than property insurance and utilities). If other maintenance expenditures have been charged directly to athletics, subtract those amounts before entering this journal entry.
Step 4-Allocation of Student Transportation Expenditures:
For allocating 2005-2006 athletic bus transportation costs, the statewide transportation cost per mile for 2004-2005 is used. Expenditures charged to functions 2700-2799 were divided by annual transportation route miles per Cycle 6 of 2004-2005. The daily route miles reported by districts in Cycle 6 were multiplied by 178 days to determine annual miles. If a district failed to report any route miles in Cycle 6, that district's expenditures were not included in calculating the state's average cost per mile.
The average statewide transportation cost per mile for 2004-2005 was $3.25. For 2005-2006 a district may use $3.25 or the district's average cost per mile based on district records. If the state average is not used, the district must maintain detailed documentation supporting the amount used.
In order to record the allocation of student transportation costs to athletics, it is recommended that object code 68999 be used and defined as “Allocated Charges.” The journal entry would be:
DEBIT 2000 2700 000 115 00..........68999
CREDIT 2000 2700 000 000 00..........68999