PROJECT COSTING DETAILED PROJECT ANALYSIS 3:36PM 07/18/96
Non Profit Agency REL 2.0 ALL PROJECTS PAGE 1
07/01/96 - 07/31/96
PROJECT DESCRIPTION REGULAR OVERTIME TOTAL LABOR MATERIAL REVENUE TRANSACTION
NUMBER HOURS HOURS HOURS AMOUNT AMOUNT AMOUNT DESCRIPTION
100 000 Grant-CDBG Housing
100 100 Administration EST 500.00 0.00 500.00 5000.00 1500.00 -6500.00 101 1000 3720 000
ACT 22.00 0.00 22.00 280.00 825.00 -3000.00
07/01/96 Mat 75.00 Johnson Office Suppl
101 2111 4610 000
07/08/96 Mat 250.00 Mat'ls for project
07/10/96 Lbr 12.00 0.00 12.00 180.00 Staff Review
Engr Design
07/17/96 Lbr 10.00 0.00 10.00 100.00 Secretary time
07/17/96 Rev -3000.00 1st DRAW CDBG-ADM1
-------- -------- --------- ------------ ------------ ------------
SUB PROJ 100 PERIOD SUB-TOTAL 22.00 0.00 22.00 280.00 325.00 -3000.00
100 110 Housing REHAB prog. EST 0.00 0.00 0.00 0.00 15000.00 -15000.00 101 1000 3720 000
ACT 0.00 0.00 0.00 0.00 10000.00 -11000.00
07/12/96 Mat 10000.00 ABC Landscape co.
1st draw
07/15/96 Rev -8500.00 CDBG Draw 1 on const
account.
07/17/96 Rev -2500.00 Test of Revenue
CDBG
-------- -------- --------- ------------ ------------ ------------
SUB PROJ 110 PERIOD SUB-TOTAL 0.00 0.00 0.00 0.00 10000.00 -11000.00
-------- -------- --------- ------------ ------------ ------------
PROJ. 100 PERIOD SUB-TOTAL 22.00 0.00 22.00 280.00 10325.00 -14000.00
-------- -------- --------- ------------ ------------ ------------
PROJ. ACTUAL COST TO DATE 22.00 0.00 22.00 280.00 10825.00
PROJ. ACTUAL REVENUE TO DATE -14000.00
PROJ. VARIANCE TO DATE 478.00 0.00 478.00 4720.00 5675.00 -7500.00
-------- -------- --------- ------------ ------------ ------------
PROFIT(LOSS) (100) 2895.00
200 000 New RDA Project 97-1
200 100 Administration EST 100.00 0.00 100.00 0.00 1500.00 0.00
ACT 0.00 0.00 0.00 0.00 0.00 0.00
200 210 CIP Construction EST 0.00 0.00 0.00 0.00 1230450.00 -1230450.00 101 1000 3151 000
ACT 10.00 0.00 10.00 150.00 250000.00 -250000.00
07/02/96 Lbr 10.00 0.00 10.00 150.00 Staff time
Design review
PROJECT COSTING DETAILED PROJECT ANALYSIS 3:36PM 07/18/96
CITY HALL RELEASE 2.0A ALL PROJECTS PAGE 2
07/01/96 - 07/31/96
PROJECT DESCRIPTION REGULAR OVERTIME TOTAL LABOR MATERIAL REVENUE TRANSACTION
NUMBER HOURS HOURS HOURS AMOUNT AMOUNT AMOUNT DESCRIPTION
07/10/96 Mat 250000.00 XYZ Const.,Draw 1
07/10/96 Rev -250000.00 RDA P-Taxes
-------- -------- --------- ------------ ------------ ------------
SUB PROJ 210 PERIOD SUB-TOTAL 10.00 0.00 10.00 150.00 250000.00 -250000.00
-------- -------- --------- ------------ ------------ ------------
PROJ. 200 PERIOD SUB-TOTAL 10.00 0.00 10.00 150.00 250000.00 -250000.00
-------- -------- --------- ------------ ------------ ------------
PROJ. ACTUAL COST TO DATE 10.00 0.00 10.00 150.00 250000.00
PROJ. ACTUAL REVENUE TO DATE -250000.00
PROJ. VARIANCE TO DATE 90.00 0.00 90.00 -150.00 981950.00 -980450.00
-------- -------- --------- ------------ ------------ ------------
PROFIT(LOSS) (200) (150.00)
PERIOD REPORT TOTAL 32.00 0.00 32.00 430.00 260325.00 -264000.00
PROJECT COSTING DETAILED PROJECT ANALYSIS 3:36PM 07/18/96
CITY HALL RELEASE 2.0A ALL PROJECTS PAGE 3
07/01/96 - 07/31/96
PROJECT DESCRIPTION REGULAR OVERTIME TOTAL LABOR MAT./CONTRCT REVENUE
NUMBER HOURS HOURS HOURS AMOUNT AMOUNT AMOUNT
REPORT GRAND TOTALS
===================
TOTAL ACTUAL COST 32.00 0.00 32.00 430.00 260,825.00
TOTAL ACTUAL REVENUE -264,000.00
TOTAL VARIANCE 568.00 0.00 568.00 4,570.00 987,625.00 -987,950.00
TOTAL PROFIT(LOSS) 2745.00