Related sites: MCA.NET | JPAC ONLINE | MARKETSHARE
More related sites: FORUM | LIVE SUPPORT | TUTORIAL | ARTICLES | FAQ


 CWIP - Construction Work In Process

MAKING PRODUCTIVITY VISIBLE TO EVERYONE ™

Export to Excel File

Contract Values
Original Contract Value($)Approved Change Orders($)Revised Contract Value(here)Pending Change Orders($)Potential Contract Value($)
Total$ 201,021$ 123,656$ 324,698$ 13,200$ 337,898


Contract Costs
Original Estimated Costs($)Cost of Change Orders($)Revised Contract Costs($)Pending Change Order Costs($)Total Potential Costs($)
Total$ 176,100$ 160$ 176,260$ 10,600$ 186,860


Profitability
 Revised ContractPotential Contract
Profit($)Profit Percent(%)Profit($)Profit Percent(%)
Total$ 148,417 45.71 %$ 151,017 44.70 %


Billings
Actual Billed to Date($)Under Billed($)Over Billed($)
Total$ 4,612,525$ 774,778-


Cash Position
Cash Received to Date($)Costs Paid to Date($)Cash (Short) Over($)
Total$ 4,156,800$ 3,941,892$ 214,908


Backlog
Without Pending Change Orders($)With Pending Change Orders($)
Total$ -5,062,626$ -5,047,409


Retention Receivable
Total Potential Retainer($)Amount Retained to Date($)
Total$ 16,955$ 456,568


Earnings Based on Revised Contract Values
Revised Contract Value($)Revised Contract Costs($)Cost to Date($)Earned Value($)
Total$ 324,698$ 176,260$ 3,941,892$ 5,387,303


Earnings Based on Potential Contract Values
Potential Contract Value($)Total Potential Costs($)Cost to Date($)Earned Value($)
Total$ 337,898$ 186,860$ 3,941,892$ 5,385,286


Budget Values to Date
Potential Contract Value
($)		  Material  
($)		    Labor    
($)		Sub Contract
($)		Other Costs
($)		Total Direct Costs
($)		    Profit    
($)		Pecentage
(%)
Total$ 2,148,093,647$ 49,550$ 35,700$ 10,140$ 3,990$ 99,380$ 2,147,994,267100.00 %


Actual Values to Date
Potential Contract Value
($)		  Material  
($)		    Labor    
($)		Sub Contract
($)		Other Costs
($)		Total Direct Costs
($)		    Profit    
($)		Pecentage
(%)
Total$ 5,387,303$ 43,100$ 37,900$ 9,790$ 4,390$ 95,180$ 5,292,12398.23 %


Budget Variance to Date
Potential Contract Value
($)		  Material  
($)		    Labor    
($)		Sub Contract
($)		Other Costs
($)		Total Direct Costs
($)		    Profit    
($)		Pecentage
(%)
Total$ -2,142,706,344$ -6,450$ 2,200$ -350$ 400$ -4,200$ -2,142,702,144-99.75 %