Spreadsheet: 35958d1233693279-best-initial-format-for-good-pivot-tables-demo
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (16) | (13) | (14) | (15)
 | BUDGET | INCUR'D | BUDGET | INCUR'D |  |  |  |  |  |  |  |  | DIRECT
 | LABOR | LABOR | LABOR | LABOR | BUDGET | INCUR'D | OUT/STD | BUDGET | INCUR'D | OUT/STD | TOTAL | TOTAL | COST | OWN | MAN | BUILD | SUP | SUB | COST | VAR | VAR
 | HOURS | HOURS | COST | COST | MATL | MATL | MATL | SUB'S | SUB'S | SUB'S | BUDGET | ACTUAL | EAC | ADJ | ADJ | ADJ | ADJ | ADJ | EAC | $ | %
A0210 | 501-01-001 | ROOF, REPAIR |  |  |  |  |  | PCT COMPLETE:100.00
BASE | 0 | 57 | 0 | 1946 | 0 | 276 | 0 | 78969 | 145089 | 154304 | 78969 | 301616
EXT | 0 | 50 | 0 | 2090 | 0 | 393 | 0 | 7486 | 12 | 0 | 7486 | 2495
GROWTH | 120 | 0 | 4870 | 0 | 386 | 0 | 0 | 14096 | 0 | 14165 | 19353 | 14165
ADDIT'NL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 120 | 107 | 4870 | 4037 | 386 | 669 | 0 | 100552 | 145101 | 168469 | 105809 | 318278 | 318278 | -134261 | 0 | 0 | 0 | -134261 | 184017 | -78208 | -0.74
A0210 | 514-00-001 | WINDOW; CLEAN & REPLACE |  |  |  |  |  | PCT COMPLETE:100.00
BASE | 0 | 2 | 0 | 58 | 232521 | 221347 | 0 | 137508 | 200903 | 12210 | 370029 | 434520
EXT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROWTH | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36127 | 0 | 36303 | 36127 | 36303
ADDIT'NL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 0 | 2 | 0 | 58 | 232521 | 221347 | 0 | 173636 | 200903 | 48514 | 406157 | 470823 | 470823 | 0 | 14421 | 0 | 0 | 14421 | 485244 | -79087 | -0.19
A0210 | 520-00-002 | DRIVEWAY, REPAIR |  |  |  |  |  | PCT COMPLETE:100.00
BASE | 0 | 2844 | 0 | 107238 | 0 | 17967 | 0 | 408038 | 13926 | 397551 | 408038 | 536683
EXT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROWTH | 2873 | 0 | 113611 | 0 | 20609 | 0 | 0 | -406483 | 0 | -408456 | -272263 | -408456
ADDIT'NL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 2873 | 2844 | 113611 | 107238 | 20609 | 17967 | 0 | 1554 | 13926 | -10904 | 135775 | 128227 | 128227 | 3423 | 0 | 0 | 0 | 3423 | 131650 | 4125 | 0.03
A0210 | SUB-SKEW TASK(S) ITEM TOTAL ***********
BASE | 8584 | 11844 | 339450 | 440543 | 284620 | 326401 | 0 | 7745476 | 5950640 | 1989576 | 8369546 | 8707162
EXT | 0 | 50 | 0 | 2090 | 0 | 393 | 0 | 7486 | 138222 | -139951 | 7486 | 754
GROWTH | 8283 | 4462 | 327673 | 188425 | 140637 | 42838 | 0 | 1386994 | 750094 | 500567 | 1855305 | 1481925
ADDIT'NL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 16867 | 16357 | 667124 | 631059 | 425257 | 369634 | 0 | 9139956 | 6838956 | 2350191 | 10232338 | 10189842 | 10189842 | -950150 | 70771 | -12287 | 0 | -891666 | 9298176 | 934162 | 0.09
A0244 | 430-80-990 | HVAC UPGRADE |  |  |  |  |  | PCT COMPLETE:100.00
BASE | 16427 | 17310 | 649598 | 728111 | 2322125 | 2292345 | 0 | 18133160 | 16346911 | 4055345 | 21104884 | 23422714
EXT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROWTH | 680 | 14 | 28152 | 558 | 28443 | 8978 | 3635 | 1143892 | 1082915 | 110078 | 1200488 | 1206167
ADDIT'NL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 17107 | 17325 | 677751 | 728670 | 2350568 | 2301324 | 3635 | 19277052 | 17429826 | 4165423 | 22305372 | 24628881 | 24628881 | 981765 | -265550 | -5497 | 0 | 710718 | 25339599 | -3034227 | -0.14
A0244 | SUB-SKEW TASK(S) ITEM TOTAL ***********
BASE | 16427 | 17310 | 649598 | 728111 | 2322125 | 2292345 | 0 | 18133160 | 16346911 | 4055345 | 21104884 | 23422714
EXT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
GROWTH | 680 | 14 | 28152 | 558 | 28443 | 8978 | 3635 | 1143892 | 1082915 | 110078 | 1200488 | 1206167
ADDIT'NL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL | 17107 | 17325 | 677751 | 728670 | 2350568 | 2301324 | 3635 | 19277052 | 17429826 | 4165423 | 22305372 | 24628881 | 24628881 | 981765 | -265550 | -5497 | 0 | 710718 | 25339599 | -3034227 | -0.14
 | PROJECT TOTAL | ***********
BASE | 53055 | 55024 | 2098036 | 2453945 | 3098956 | 3087632 | 7137 | 34408083 | 28710415 | 8302140 | 39605076 | 42561271
EXT | 0 | 50 | 0 | 2090 | 0 | 393 | 0 | 7486 | 138222 | -139951 | 7486 | 754
GROWTH | 19161 | 4718 | 758747 | 199548 | 228635 | 58815 | 8284 | 2611094 | 1839188 | 663275 | 3598476 | 2769111
ADDIT'NL | 0 | 22 | 0 | 875 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 875
TOTAL | 72216 | 59816 | 2856783 | 2656459 | 3327592 | 3146841 | 15421 | 37026663 | 30687825 | 8825464 | 43211039 | 45332013 | 45644686 | -479400 | -406998 | 77513 | 0 | -808885 | 44835801 | -1624762 | -0.04
 | SUMMARY
 |  | BUDGET INFORMATION |  |  | EAC INFORMATION |  |  | [NAME]
 |  |  |  |  | SUBCLIN |  | TOTAL
 |  |  |  |  | DIRECT |  | DIRECT
 |  | SUBSKEW | PRO-RATED | TOTAL | COST | PRO-RATED | COST | [NAME] | [NAME]
 |  | BUDGET | BUDGET | BUDGET | EAC | EAC | EAC | $ | %
 | [NAME] | 0 | 0 | 0 | 1072 | 0 | 1072 | -1072 | 0
 | A0210 | 10232338 | 3276016 | 13508354 | 9298176 | 3067174 | 12365350 | 1143004 | 0.08
 | A0244 | 22305372 | 5407924 | 27713296 | 25339599 | 5063174 | 30402773 | -2689477 | -0.1
 | A0310 | 886745 | 0 | 886745 | 887970 | 0 | 887970 | -1225 | 0
 | A0330 | 1102641 | 0 | 1102641 | 1178633 | 0 | 1178633 | -75992 | -0.07
 | PROJECT TOTAL | 34527096 | 8683940 | 43211036 | 36705450 | 8130348 | 44835798 | -1624762 | -0.04
 | Note: | SubCLIN figures include pro-rates.
 | PRO-RATES
 | [NAME] | 0
 | A0210 | 0.37725
 | A0244 | 0.62275
 | A0310 | 0
 | A0330 | 0