|
SOUTHERN UTE INDIAN TRIBE
<br />Projects Grant Expense Report
<br />BOR5804 - ALP Operations Management
<br />As Of 2012 -12 -31
<br />Inception to
<br />YTD
<br />Current
<br />Fiscal Year
<br />Inception to
<br />Date Project
<br />Project
<br />Month
<br />to Date
<br />Date Project
<br />Remaining
<br />Quarter Quarter
<br />Account Description
<br />Budget
<br />Budget
<br />Actuals
<br />Actuals
<br />Actuals
<br />Budget
<br />Quarter t
<br />Quarter 2 3 4
<br />Revenues
<br />Total operating revenue
<br />1,365,393.00
<br />327,114.62
<br />45,164.36
<br />126,465.31
<br />1,164,743.69
<br />200,649.31
<br />126,465.31
<br />(126,465.31)
<br />Cost of Goods Sold
<br />Total operating cost of sales
<br />-
<br />-
<br />-
<br />-
<br />Payroll
<br />70010 Salaries and Wages
<br />724,366.61
<br />159,090.71
<br />23,640.72
<br />71,955.55
<br />631,401.48
<br />92,965.13
<br />71,955.55
<br />(1,048.37)
<br />70012 Bonus - Other Earnings
<br />10,508.97
<br />5,982.00
<br />5,130.95
<br />5,130.95
<br />9,657.92
<br />851.05
<br />5,130.95
<br />70110 Overtime
<br />1,854.18
<br />705.52
<br />60016
<br />672.91
<br />2,477.36
<br />(623.18)
<br />672.91
<br />70210 Fica
<br />50,907.66
<br />8,988.52
<br />2,164.81
<br />5,690.67
<br />47,847.66
<br />3,060.00
<br />5,690.67
<br />(76.08)
<br />70212 Worker's Compensation Expense
<br />1,957.69
<br />364.53
<br />79.54
<br />196.49
<br />1,789.65
<br />168.04
<br />196.49
<br />70216 Suta
<br />1,840.78
<br />374.89
<br />84.52
<br />222.11
<br />1,727.05
<br />113.73
<br />222.11
<br />(2,99)
<br />70310 Dental Insurance
<br />3,515.23
<br />851.34
<br />192.28
<br />560.70
<br />3,280.97
<br />234.26
<br />560.70
<br />11334
<br />70312 Health Insurance
<br />77,179.64
<br />25,258.77
<br />4,216.11
<br />12,698.10
<br />67,978.57
<br />9,201.07
<br />12,698.10
<br />4,759.84
<br />70314 Life Insurance
<br />2,586.32
<br />497.64
<br />129A0
<br />379.64
<br />2,407.70
<br />178.62
<br />379.64
<br />83.62
<br />70316 Long Term Disability
<br />3,062.19
<br />741.18
<br />158.44
<br />460.56
<br />2,842.19
<br />220.00
<br />460.56
<br />64.38
<br />70318 Vision Insurance
<br />1,027.12
<br />274.51
<br />54.66
<br />159.68
<br />912.29
<br />114.83
<br />159.68
<br />27.33
<br />70330 Pension and Retirement
<br />36,297.34
<br />8,262.23
<br />1,762.29
<br />4,665.53
<br />34,181.94
<br />2,115.40
<br />4,665.53
<br />(62.90)
<br />70332 Employer 401KMatch
<br />20,256.79
<br />4,124.83
<br />983.91
<br />2,561.04
<br />18,693.00
<br />1,563.79
<br />2,561.04
<br />(34.39)
<br />Salaries and Benefits
<br />935,360.52
<br />215,516.67
<br />39,197.89
<br />105,353.93
<br />825,197.78
<br />110,162.74
<br />105,353.93
<br />3,823.78
<br />Travel
<br />71010 Travel Expense
<br />6,645.82
<br />2,500.10
<br />-
<br />-
<br />4,145.72
<br />2,500.10
<br />-
<br />-
<br />71012 Mileage Reimbursement
<br />1,290.14
<br />-
<br />-
<br />-
<br />1,290.14
<br />-
<br />-
<br />71016 Business Meeting Expense
<br />7,581.64
<br />1,182.54
<br />42.65
<br />806.64
<br />6,455.24
<br />1,126.40
<br />806.64
<br />71018 Meals and Entertainment
<br />-
<br />-
<br />-
<br />-
<br />287.60
<br />(287.60)
<br />-
<br />71026 Airfare
<br />4,600.00
<br />1,613.90
<br />3,449.00
<br />1,151.00
<br />-
<br />Travel
<br />20,117.60
<br />5,296.54
<br />42.65
<br />806.64
<br />15,627.70
<br />4,489.90
<br />806.64
<br />Occupancy
<br />72016 Building- Contract Cleaning
<br />2,400.00
<br />2,400.00
<br />-
<br />475.00
<br />475.00
<br />1,925.00
<br />475.00
<br />300.00
<br />72112 Electricity
<br />15,000.00
<br />15,000.00
<br />-
<br />-
<br />-
<br />15,000.00
<br />-
<br />-
<br />72114 Water
<br />4,428.20
<br />931.64
<br />525.32
<br />1,033.26
<br />4,361.84
<br />66.36
<br />1,03326
<br />72116 Gas
<br />8,164.00
<br />6,010.51
<br />243.39
<br />435.62
<br />2,589.11
<br />5,574.89
<br />435.62
<br />72118 Sewer
<br />1,000.00
<br />1,000.00
<br />-
<br />-
<br />-
<br />1,000.00
<br />-
<br />72210 Cellular Phone Expense
<br />6,539.82
<br />1,627.23
<br />221.61
<br />664.83
<br />5,577.42
<br />962.40
<br />664.83
<br />72212 Telephone and Communications
<br />51,195.82
<br />17,766.55
<br />2,760.00
<br />2,760.00
<br />36,189.27
<br />15,006.55
<br />2,760.00
<br />-
<br />Occupancy
<br />88,727.84
<br />44,735.93
<br />3,750.32
<br />5,368.71
<br />49,192.64
<br />39,535.20
<br />5,368.71
<br />300.00
<br />Professional
<br />71112 Legal
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />71214 Outside Services
<br />108,028.11
<br />39,867.80
<br />9,146.42
<br />77,474.71
<br />30,553.40
<br />9,146.42
<br />4,171.52
<br />Professional
<br />108,028.11
<br />39,867.80
<br />9,146.42
<br />77,474.71
<br />30,553.40
<br />9,146.42
<br />4,171.52
<br />General and Administrative
<br />73112 Relocation Expense
<br />5,068.10
<br />-
<br />-
<br />5,068.10
<br />-
<br />-
<br />-
<br />73114 Position Advertising
<br />-
<br />-
<br />-
<br />-
<br />-
<br />-
<br />73212 Maintenance and Maint Supplies
<br />3,981.55
<br />3,815.97
<br />1,100.00
<br />1,265.58
<br />2,715.97
<br />1,100.00
<br />500.00
<br />73214 Office Supplies
<br />12,505.05
<br />4,002.55
<br />(65.59)
<br />604.37
<br />9,106.87
<br />3,398.18
<br />604.37
<br />-
<br />73216 Postage /Shipping /Handling
<br />636.46
<br />473.86
<br />-
<br />-
<br />162.60
<br />473.86
<br />-
<br />73220 Printing /Photocopying /Filming
<br />4,455.04
<br />1,312.45
<br />247.20
<br />473.00
<br />3,615.59
<br />839.45
<br />473.00
<br />136.09
<br />73314 Software License & Maint Fees
<br />4,445.99
<br />2,977.66
<br />-
<br />299.00
<br />1,744.99
<br />2,701.00
<br />299.00
<br />-
<br />73316 Internet Expense
<br />-
<br />-
<br />-
<br />22.34
<br />(22.34)
<br />73410 Training, Education, Seminare
<br />23,481.95
<br />4,355.00
<br />35.00
<br />19,161.95
<br />4,320.00
<br />35.00
<br />75005 Capital Assets $1000 to $4999
<br />15,162.12
<br />-
<br />-
<br />16,818.29
<br />(1,656.17)
<br />-
<br />75010 Small Equipment
<br />5,417.62
<br />1,000.00
<br />4,417.62
<br />1,000.00
<br />75012 Small Furniture
<br />707.99
<br />-
<br />707.99
<br />-
<br />75014 Small Tools
<br />19.97
<br />19.97
<br />75018 Safety and Other Supplies
<br />-
<br />-
<br />-
<br />-
<br />75028 Taxes /Licenses /Fees
<br />641.47
<br />344.30
<br />297.17
<br />344.30
<br />75040 Special Projects
<br />37,519.00
<br />-
<br />-
<br />-
<br />43,117.80
<br />(5,598.80)
<br />-
<br />75042 Operating Materials and Fees
<br />38,280.00
<br />1,606.89
<br />2,634.32
<br />36,665.41
<br />1,614.59
<br />2,634.32
<br />75046 Program /Department Supplies
<br />325.30
<br />-
<br />-
<br />895.80
<br />(570.50)
<br />-
<br />75210 Gas and Oil
<br />12,255.50
<br />2,057.52
<br />325.00
<br />583,92
<br />8,861.51
<br />3,393.99
<br />583.92
<br />75212 Repairs and Maintenance
<br />2,865.00
<br />1,252.15
<br />60.00
<br />60.00
<br />1,672.85
<br />1,192.15
<br />60.00
<br />75214 Vehicle Lease Expense
<br />106.22
<br />106.22
<br />106.22
<br />-
<br />-
<br />General and Administrative
<br />167,874.33
<br />21,697.68
<br />2,173.50
<br />51789.61
<br />153,622.43
<br />14,251.90
<br />5,789.61
<br />636.09
<br />Other Expenses
<br />Other Administration Expense
<br />Capital Expenditures/Fixed Assets
<br />17596 Contra Asset for PS Processing
<br />1,656.17
<br />-
<br />1,656.17
<br />79020 Office Furniture and Equipment
<br />9,936.00
<br />9,936.00
<br />-
<br />79024 Transportation Equipment
<br />30,562.00
<br />30,562.00
<br />79028 Computer Equipment
<br />3,130.43
<br />3,130.43
<br />Fixed Assets
<br />45,284.60
<br />-
<br />-
<br />-
<br />43,628.43
<br />1,65617
<br />Total Expenditures
<br />1,365,393.00
<br />327,114.62
<br />45,164.36
<br />126,465.31
<br />1,164,743.69
<br />200,64931
<br />126,465.31
<br />8,931.39
<br />
|