| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| WORK IN PROGRESS |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| 10/31/07 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| JOB |
CONTRACT |
COST TO |
MATERIAL |
MATERIAL |
% MAT |
LABOR |
LABOR |
% LABOR |
EST MAT TO |
EST LABOR |
EST COSTS |
PROJECTED |
|
TOTAL |
LEFT TO |
WIP % |
COSTS/BILLINGS |
| NAME |
AMOUNT |
DATE |
BUDGET |
ACTUAL |
USED |
BUDGET |
ACTUAL |
USED |
COMPLETE |
TO COMPLETE |
TO COMPLETE |
MARGIN |
% |
BILLED |
BILL |
COMPLETE |
IN EXCESS |
| SAMPLE |
500,000 |
150,000 |
100,000 |
50,000 |
50.00% |
200,000 |
100,000 |
50.00% |
85,000 |
55,000 |
140,000 |
210,000 |
42.0% |
350,000 |
150,000 |
51.7% |
$ (91,379) |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
0 |
|
|
#DIV/0! |
|
|
#DIV/0! |
|
|
0 |
0 |
#DIV/0! |
|
0 |
#DIV/0! |
#DIV/0! |
| |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TOTALS: |
500,000 |
150,000 |
100,000 |
50,000 |
50.00% |
200,000 |
100,000 |
50.00% |
85,000 |
55,000 |
140,000 |
210,000 |
42.0% |
350,000 |
150,000 |
51.7% |
#DIV/0! |
Business Forms
Privacy Policy.
Also See
Terms of Service.
|
|
|