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


 Work In Process


Export to Excel File

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


Contract Costs
Original Estimated Costs($)Cost of Change Orders($)Revised Contract Costs($)Pending Change Order Costs($)Total Potential Costs($)
Total$ 176,200$ 160$ 176,360$ 10,600$ 186,960


Profitability
 Revised ContractPotential Contract
Profit($)Profit Percent(%)Profit($)Profit Percent(%)
Total$ 148,296 45.68 %$ 150,896 44.66 %


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


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$ -4,512,821$ -4,497,604


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


Earnings Based on Revised Contract Values
Revised Contract Value($)Revised Contract Costs($)Cost to Date($)Earned Value($)
Total$ 324,656$ 176,360$ 3,941,892$ 4,837,477


Earnings Based on Potential Contract Values
Potential Contract Value($)Total Potential Costs($)Cost to Date($)Earned Value($)
Total$ 337,856$ 186,960$ 3,941,892$ 4,835,460


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$ 4,837,477$ 43,100$ 37,900$ 9,790$ 4,390$ 95,180$ 4,742,29798.03 %


Budget Variance to Date
Potential Contract Value
($)
  Material  
($)
    Labor    
($)
Sub Contract
($)
Other Costs
($)
Total Direct Costs
($)
    Profit    
($)
Pecentage
(%)
Total$ -2,143,256,170$ -6,450$ 2,200$ -350$ 400$ -4,200$ -2,143,251,970-99.77 %