Case 1:98-cv-00488-SGB
Document 372-4
Filed 08/18/2006
Page 1 of 1
Sacramento Municipal Utility District v. The United States Exhibit 1 to Supplemental Written Direct Testimony re Proposed Modification to Labor Costs in Table A
June 1, 1997 - December 31, 2003
A B C D E F G H I
HOURS CHARGED TO NON CLAIMED WORK ORDERS PER DATABASE Item Employee No. No. 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 7911 6730 9436 9850 2799 9647 2281 2149 4318 5613 3505 1802 4475 3663 1751 3359 No. of Hours 70 928 1,877 2,533 2,257 3,225 2,470 3,354 4,173 5,632 3,663 5,792 5,737 5,627 5,619 5,972
HOURS AND DOLLARS CHARGED TO CLAIMED WORKORDERS
Direct Labor
Indirect Labor from FMIS Period Only Dollars $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 37,438.26 92,514.98 65,717.24 85,191.26 82,452.25 82,311.62 3,302.66 3,939.11 6,585.12 11,961.96 53.26 15,069.51 11,177.46 51,014.85 8,737.33 11,094.77 568,561.64 No. of Hours 7,868 3,879 7,791 9,389 6,616 8,836 5,923 5,677 5,891 7,042 4,392 6,483 6,219 6,060 5,935 6,108
Total
PERCENT OF CLAIMED HOURS TO TOTAL HOURS D/(D+C) Dollars
No. of Hours 7,868 3,879 7,791 9,389 6,616 8,836 5,923 5,677 5,891 7,042 4,392 6,483 6,219 6,060 5,935 6,108 Total > 50%
Dollars $ 413,282.60 $ 181,279.87 $ 433,664.32 $ 481,655.63 $ 334,693.32 $ 455,117.28 $ 222,126.40 $ 214,347.43 $ 254,483.28 $ 395,903.76 $ 264,762.58 $ 270,480.02 $ 261,864.56 $ 286,999.11 $ 251,077.14 $ 255,124.41 $ 4,976,861.71
$ 450,720.86 $ 273,794.85 $ 499,381.56 $ 566,846.89 $ 417,145.57 $ 537,428.90 $ 225,429.06 $ 218,286.54 $ 261,068.40 $ 407,865.72 $ 264,815.84 $ 285,549.53 $ 273,042.02 $ 338,013.96 $ 259,814.47 $ 266,219.18 $ 5,545,423.35
99.12% 80.69% 80.58% 78.75% 74.56% 73.26% 70.57% 62.86% 58.54% 55.56% 54.53% 52.81% 52.01% 51.85% 51.37% 50.56%