Docstoc

This-is-a-test

Document Sample
This-is-a-test Powered By Docstoc
					Timberline Construction D:\TSDATA\SAMPLE DATA\CONSTRUCTION SAMPLE DATA

Forecast Worksheet

11/28/2009 1:45 AM Page 1 of 2

JOB:

03-001 NW Food Warehouse 3428 SW 185th Avenue Beaverton, OR 97006

Project Manager: Misc Title 1: Misc Title 2: Misc Title 3: Misc Title 4:

Michael Perkins John Erickson Chris Anderson Peter Shell Smith Lange Associates

Schedule Start Completion Estimated 02/01/2001 10/30/2001 Revised Actual 01/13/2001

Cost Code

Description

Original Estimate

Approved Changes

Costs On COs Not Submitted

Revised Estimate

Committed

Non-Committed Costs

JTD Cost

Remaining Estimate

Cost to Complete

Cost at Completion

Current Over/Under

Previous Over/Under

Over/Under Change Notes

1 1-040 1-045 1-065 1-510 1-580 1-710

GENERAL CONDITIONS Coordination Insurance Permits - General Temporary Utilities Project Identification Final Cleaning DIVISION 1 TOTALS SITEWORK Concrete Removal Dewatering Excavate & Backfill Asphalt Paving Cement Paving Landscaping DIVISION 2 TOTALS CONCRETE Structural Formwork Permanent Forms Reinforcing Steel Welded Wire Fabric Concrete Accessories Structural Concrete Concrete Finishing Tilt-Up Precast DIVISION 3 TOTALS METALS Steel Joists Steel Decking Castings DIVISION 5 TOTALS WOOD & PLASTICS Fasteners Wood Framing Structural Panels Custom Casework DIVISION 6 TOTALS THERMAL & MOISTURE PROTECTION Vapor Retarders Building Insulation Built-Up Bituminous Roof Sheet Metal Roofing Roof Accessories Skylights DIVISION 7 TOTALS DOORS & WINDOWS Wood Doors Security Doors Rollup Doors Aluminum Windows DIVISION 8 TOTALS FINISHES Drywall Acoustical Ceilings Resilient Tile Floor Painting - Exterior

57,134.58 5,050.00 20,239.00 14,888.43 167.20 41,098.15 138,577.36

-

-

57,134.58 5,050.00 20,239.00 14,888.43 167.20 41,098.15 138,577.36

2,235.50 60.75 -

14,367.34 4,895.00 20,239.00 3,755.80 112.00 43,369.14

14,367.34 4,895.00 20,239.00 4,355.80 172.75 44,029.89

42,767.24 155.00 10,532.63 (5.55) 41,098.15 94,547.47

-

14,367.34 4,895.00 20,239.00 4,355.80 172.75 44,029.89

42,767.24 155.00 10,532.63 (5.55) 41,098.15 94,547.47

-

42,767.24 155.00 10,532.63 (5.55) 41,098.15 94,547.47

2 2-075 2-140 2-220 2-510 2-520 2-900

99,475.83 140,939.07 99,003.02 6,980.60 3,250.00 349,648.52

720.00 3,710.00 4,430.00

-

720.00 99,475.83 144,649.07 99,003.02 6,980.60 3,250.00 354,078.52

60,343.47 60,313.35 72,076.53 4,826.56 8,850.00

44,795.21 93,928.77 27,001.16 2,608.51 168,333.65

100,638.68 154,167.12 99,297.16 7,715.07 4,500.00 366,318.03

720.00 (1,162.85) (9,518.05) (294.14) (734.47) (1,250.00) (12,239.51)

-

100,638.68 154,167.12 99,297.16 7,715.07 4,500.00 366,318.03

720.00 (1,162.85) (9,518.05) (294.14) (734.47) (1,250.00) (12,239.51)

-

720.00 (1,162.85) (9,518.05) (294.14) (734.47) (1,250.00) (12,239.51)

3 3-110 3-130 3-210 3-220 3-250 3-310 3-345 3-470

20,986.12 3,010.85 22,820.19 23,799.00 1,452.92 136,890.67 45,122.43 64,473.60 318,555.78

480.00 611.50 5,832.00 360.00 7,283.50

-

21,466.12 3,010.85 23,431.69 23,799.00 1,452.92 142,722.67 45,482.43 64,473.60 325,839.28

2,259.60 682.88 13,151.51 7,456.05 127,568.00 625.00 32,694.69

13,294.66 1,744.84 6,112.47 10,653.42 403.99 14,459.98 33,283.44 20,834.83 100,787.63

15,554.26 2,427.72 19,132.46 18,109.47 403.99 140,627.98 33,908.44 24,461.17 254,625.49

5,911.86 583.13 4,299.23 5,689.53 1,048.93 2,094.69 11,573.99 40,012.43 71,213.79

-

15,554.26 2,427.72 19,132.46 18,109.47 403.99 140,627.98 33,908.44 24,461.17 254,625.49

5,911.86 583.13 4,299.23 5,689.53 1,048.93 2,094.69 11,573.99 40,012.43 71,213.79

-

5,911.86 583.13 4,299.23 5,689.53 1,048.93 2,094.69 11,573.99 40,012.43 71,213.79

5 5-210 5-310 5-540

132,701.96 76,104.50 2,960.47 211,766.93

-

-

132,701.96 76,104.50 2,960.47 211,766.93

86,497.50 54,400.00 1,651.00

28,444.00 28,444.00

28,444.00 28,444.00

104,257.96 76,104.50 2,960.47 183,322.93

-

28,444.00 28,444.00

104,257.96 76,104.50 2,960.47 183,322.93

-

104,257.96 76,104.50 2,960.47 183,322.93

6 6-050 6-110 6-120 6-410

569.51 52,338.15 95,116.56 148,024.22

820.50 820.50

-

569.51 53,158.65 95,116.56 148,844.72

578.10 9,569.26 27,200.00 -

8,832.50 1,621.84 10,454.34

8,832.50 1,621.84 10,454.34

569.51 44,326.15 93,494.72 138,390.38

-

8,832.50 1,621.84 10,454.34

569.51 44,326.15 93,494.72 138,390.38

-

569.51 44,326.15 93,494.72 138,390.38

7 7-190 7-210 7-510 7-610 7-720 7-800

15,063.11 1,063.11 108,152.37 124,278.59

552.50 552.50

-

15,063.11 1,063.11 108,152.37 552.50 124,831.09

53.00 1,125.00 23,500.00 552.50 -

-

-

15,063.11 1,063.11 108,152.37 552.50 124,831.09

-

-

15,063.11 1,063.11 108,152.37 552.50 124,831.09

-

15,063.11 1,063.11 108,152.37 552.50 124,831.09

8 8-210 8-320 8-360 8-520

1,120.00 9,480.17 4,633.51 15,233.68

450.00 2,660.00 1,431.00 4,541.00

-

1,120.00 450.00 12,140.17 6,064.51 19,774.68

1,120.00 450.00 11,500.00 5,031.00

-

-

1,120.00 450.00 12,140.17 6,064.51 19,774.68

-

-

1,120.00 450.00 12,140.17 6,064.51 19,774.68

-

1,120.00 450.00 12,140.17 6,064.51 19,774.68

9 9-250 9-510 9-660 9-910

3,977.15 3,855.65 134,507.51 4,500.00

2,275.00 -

6,252.15 3,855.65 134,507.51 4,500.00

1,810.50 2,950.00 134,400.00 4,320.00

-

-

6,252.15 3,855.65 134,507.51 4,500.00

-

6,252.15 3,855.65 134,507.51 4,500.00

-

6,252.15 3,855.65 134,507.51 4,500.00

587a5c1e-eb58-4ff8-9d05-e2829e4b9704.xls

Timberline Construction D:\TSDATA\SAMPLE DATA\CONSTRUCTION SAMPLE DATA

Forecast Worksheet

11/28/2009 1:45 AM Page 2 of 2

JOB:

03-001 NW Food Warehouse 3428 SW 185th Avenue Beaverton, OR 97006

Project Manager: Misc Title 1: Misc Title 2: Misc Title 3: Misc Title 4:

Michael Perkins John Erickson Chris Anderson Peter Shell Smith Lange Associates

Schedule Start Completion Estimated 02/01/2001 10/30/2001 Revised Actual 01/13/2001

Cost Code 9-920

Description Painting - Interior DIVISION 9 TOTALS SPECIALTIES Toilet Part. Metal Exterior Signs Lockers Fire Ext. Portable Mail Chutes Wire Mesh Partitions Storage Shelving Toilet & Bath Access. DIVISION 10 TOTALS EQUIPMENT Dock Levelers Food Storage Equip DIVISION 11 TOTALS FURNISHINGS Window Treatment DIVISION 12 TOTALS MECHANICAL Fire Protection Plumbing HVAC Refrigeration DIVISION 15 TOTALS ELECTRICAL Electrical Sub DIVISION 16 TOTALS JOB 03-001 TOTALS

Original Estimate 750.00 147,590.31

Approved Changes 215.00 2,490.00

Costs On COs Not Submitted -

Revised Estimate 965.00 150,080.31

Committed 600.00

Non-Committed Costs -

JTD Cost -

Remaining Estimate 965.00 150,080.31

Cost to Complete -

Cost at Completion -

Current Over/Under 965.00 150,080.31

Previous Over/Under -

Over/Under Change Notes 965.00 150,080.31

10 10-160 10-430 10-500 10-522 10-551 10-605 10-670 10-800

2,766.19 30,193.63 509.55 1,506.14 1,205.92 580.42 21,227.65 990.02 58,979.52

860.00 860.00

-

2,766.19 30,193.63 509.55 1,506.14 1,205.92 580.42 22,087.65 990.02 59,839.52

2,400.00 30,000.00 433.40 687.50 840.00

-

-

2,766.19 30,193.63 509.55 1,506.14 1,205.92 580.42 22,087.65 990.02 59,839.52

-

-

2,766.19 30,193.63 509.55 1,506.14 1,205.92 580.42 22,087.65 990.02 59,839.52

-

2,766.19 30,193.63 509.55 1,506.14 1,205.92 580.42 22,087.65 990.02 59,839.52

11 11-161 11-405

270,795.47 270,795.47

55,150.00 55,150.00

-

325,945.47 325,945.47

260,703.00

500.00 500.00

500.00 500.00

325,445.47 325,445.47

-

500.00 500.00

325,445.47 325,445.47

-

325,445.47 325,445.47

12 12-500

-

-

-

-

-

-

-

-

-

-

-

-

-

15 15-300 15-400 15-500 15-650

54,673.97 88,085.84 177,204.42 76,422.07 396,386.30

750.00 800.00 1,550.00

-

55,423.97 88,085.84 178,004.42 76,422.07 397,936.30

55,350.00 85,515.44 177,865.00 76,360.00

-

22,001.50 22,001.50

55,423.97 66,084.34 178,004.42 76,422.07 375,934.80

-

22,001.50 22,001.50

55,423.97 66,084.34 178,004.42 76,422.07 375,934.80

-

55,423.97 66,084.34 178,004.42 76,422.07 375,934.80

16 16-100

82,436.20 82,436.20 2,262,272.88

1,250.00 1,250.00 78,927.50

-

83,686.20 83,686.20 2,341,200.38

82,250.00

351,888.76

8,250.00 8,250.00 734,623.25

75,436.20 75,436.20 1,606,577.13

-

8,250.00 8,250.00 734,623.25

75,436.20 75,436.20 1,606,577.13

-

75,436.20 75,436.20 1,606,577.13

CONTRACT SUMMARY Original Pending Changes Approved Changes Revised COST SUMMARY JTD Cost Cost To Complete Projected Cost Projected Profit

Contract 2,489,500.00 151,195.00 2,640,695.00

Estimate 2,262,272.88 78,927.50 2,341,200.38

Profit 227,227.12 72,267.50 299,494.62

Notes

734,623.25 734,623.25 1,906,071.75 As of March 05, 2008

587a5c1e-eb58-4ff8-9d05-e2829e4b9704.xls


				
DOCUMENT INFO
Shared By:
Tags: This-, is-a-
Stats:
views:142
posted:11/28/2009
language:English
pages:2
Description: This-is-a-test