Utilities_At_J-12.xlsx
XLSX spreadsheet 15 KB Posted
- Solicitation number
- DOL13RA20003
About this file
RFP Attachment J-12 Utilities and Fuel
View the file
Other files
Show all 19
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
usage-utility
| Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Expense | ||
| Constellation (DTE G) | $5,416.02 | $6,419.01 | $10,935.51 | $18,082.07 | $17,164.45 | $11,817.68 | $8,983.31 | $2,844.52 | $2,007.82 | $1,520.90 | $1,924.86 | $1,701.97 | $88,818.12 | 2011 - 2012 |
| Noble (DTE E) | $12,859.16 | $10,976.39 | $11,811.24 | $12,132.00 | $11,589.78 | $11,834.69 | $12,041.45 | $11,834.11 | $19,355.71 | $16,062.55 | $38,046.70 | $13,201.96 | $181,745.74 | 2011 - 2012 |
| DTE E | $4,705.45 | $4,972.53 | $5,226.80 | $5,985.25 | $5,532.66 | $5,458.55 | $5,611.30 | $4,795.31 | $6,518.16 | $5,440.14 | $5,877.51 | $10,003.65 | $70,127.31 | 2011 - 2012 |
| DTE G | $2,968.14 | $3,165.15 | $4,464.71 | $5,880.54 | $6,580.47 | $3,723.46 | $5,478.07 | $2,976.61 | $3,255.35 | $2,872.55 | $3,122.90 | $3,116.95 | $47,604.90 | 2011 - 2012 |
| Water | $9,715.36 | $9,923.70 | $10,492.52 | $9,576.33 | $11,694.32 | $10,577.48 | $10,050.26 | $9,654.24 | $10,357.54 | $10,118.67 | $11,222.37 | $6,312.63 | $119,695.42 | 2011 - 2012 |
| Usage | |||||||||||||
| DTE 10/2009 - 9/2010 | 186033 | 155785 | 176143 | 156829 | 171140 | 185351 | 170305 | 150862 | 270596 | 345139 | 353686 | 280160 | 2602029 |
| 10/2010 - 9/2011 | 157215 | 167566 | 190199 | 173665 | 181603 | 155945 | 153693 | 279345 | 372896 | 393680 | 272963 | 260616 | 2759386 |
| Gas 10/2009 - 9/2010 | 16734 | 21972 | 37730 | 42820 | 38845 | 32526 | 18398 | 8671 | 10072 | 8916 | 9895 | 9630 | 256209 |
| 10/2010 - 10211 | 12732 | 24677 | 37877 | 44588 | 24030 | 35738 | 23100 | 13159 | 10222 | 7554 | 10545 | 8702 | 252924 |
| Water 10/2009 - 9/2010 | 739516 | 0 | 880984 | 1309127 | 1079337 | 0 | 821853 | 628740 | 466315 | 1127241 | 980535 | 1017212 | 9050860 |
| 10/2010 - 9/2011 | 624998 | 910176 | 620507 | 785923 | 108319 | 895206 | 695357 | 614856 | 521356 | 522852 | 634304 | 416636 | 7350490 |
Detroit Job Corps Center Utility and Fuel Usage - Attachment J-12
Inventory
| Inventory | Avg | Medical | Total | ||
| Report | Admin | Clothing | and Dental | Food | By Type Avg |
| FROM REPORTS | |||||
| Stock Status Report Ending Balance | $36,752.76 | $27,388.94 | $10,387.45 | $19,381.26 | $93,910.41 |
| Receipts | $8,382.91 | $5,952.67 | $1,789.15 | $29,810.34 | $45,935.06 |
| Issues and Transfers | ($11,275.67) | ($8,311.01) | ($4,601.22) | ($30,767.21) | ($54,955.12) |
| Adjustments and Returns | $3,306.96 | $2,298.68 | $2,883.32 | $4,132.60 | $12,621.56 |
| Stock Status Report Ending Balance | $35,981.53 | $27,010.33 | $10,089.52 | $19,196.40 | $92,277.79 |
| Beginning inventory This is ideally where we want to end our contract year at |
| Clothing $10,460 | |||||
| Food $11,209 | |||||
| Medical $5,761 | |||||
| Office/Janitor $19,628 | |||||
| Total beginning is $47,058 | |||||
| Current inventory | |||||
| Inventory | Admin | Medical | Total | ||
| Report as of 9/30/12 | (Office Supplies and Janitorial) | Clothing | and Dental | Food | By Type |
| FROM REPORTS | |||||
| August Stock Status Report Ending Balance | $26,976.97 | $26,152.37 | $8,026.96 | $0.00 | $61,156.30 |
| Receipts | $2,899.37 | $1,865.40 | $200.24 | $0.00 | $4,965.01 |
| Issues and Transfers | ($5,451.77) | ($2,200.22) | ($106.22) | $0.00 | ($7,758.21) |
| Adjustments and Returns | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
| September Stock Status Report Ending Balance | $24,424.57 | $25,847.33 | $8,120.98 | $0.00 | $58,392.88 |
| Difference | $0.00 | ($29.78) | $0.00 | $0.00 | ($29.78) |
File details come from the government source that posted it. Updated .