| TANNER RESEARCH, INC. | ||||||||||||||||
| MONROVIA BUILDING CONSTRUCTIONS COSTS | ||||||||||||||||
| BUDGET vs. ACTUAL ANALYSIS | ||||||||||||||||
| Cost Estimate | Actual Costs | |||||||||||||||
| Item No. | Description of Work | as of 11/9/2005 | as of 1/17/2006 | Variance | Explanation | |||||||||||
| 001 | Drywall, Framing, & Wall Insulation | $ 51,910.00 | $ 62,979.00 | (11,069.00) | $7,500 for revised bid for 9 foot walls not 8 foot and hard-topping three labs areas, $2,000 change order for 3 additional interior door ways and 2 sofits (rooms ___ and ___) and $1,500 for lobby sofit. | |||||||||||
| 002 | HVAC | $ - | $ 42,990.00 | (42,990.00) | Included as a category in budget but had no estimate for costs | |||||||||||
| 003 | Electrical | $ 54,740.00 | $ 59,333.00 | (4,593.00) | $2,800 for adding outside parking lights and $1,700 server room HVAC's | |||||||||||
| 004 | Carpet/VCT/Laminate | $ 61,200.00 | $ 65,333.00 | (4,133.00) | Upgrading carpet backing | |||||||||||
| 004a | Major floor prep | $ 10,000.00 | $ 6,000.00 | 4,000.00 | Concrete work for electrical and date in floor less than estimate | |||||||||||
| 005 | New Exterior Window (Barry's office) | $ 12,000.00 | $ 18,500.00 | (6,500.00) | ||||||||||||
| 006 | Interior Paint | $ 15,000.00 | $ 30,550.00 | (15,550.00) | Painter did not break out interior and exterior costs | |||||||||||
| 006a | Exterior Paint | $ - | $ - | |||||||||||||
| 007 | Acoustical | $ 35,000.00 | $ 39,414.00 | (4,414.00) | $5,600 change order for 10,000 sq ft. of new tile installed. | |||||||||||
| 008 | Plumbing | $ 4,000.00 | $ 3,300.00 | 700.00 | ||||||||||||
| 009 | Fire Life Safety | $ - | $ 39,115.00 | (39,115.00) | $8,000 change order for new panel because the old one would not meet code and $8,000 change order for design and permitting process because FD contacting vendor | |||||||||||
| 010 | Fire Sprinklers | $ 12,000.00 | $ 11,500.00 | 500.00 | ||||||||||||
| 011 | Doors, Door Frames, door lock/lever | $ 26,700.00 | $ 51,900.00 | (25,200.00) | $17,000 change order to replace all doors (not just buy for new door ways), $4,000 change order for new front door and seal south door and $4,000 change order for _____ | |||||||||||
| 012 | Demo | $ 11,560.00 | $ 13,860.00 | (2,300.00) | $1,000 change order to demo concrete pad in west parking lot. | |||||||||||
| 012a | Misc/Laborers | $ 15,000.00 | $ 3,712.00 | 11,288.00 | ||||||||||||
| 013 | Skylights | $ - | $ 7,000.00 | (7,000.00) | Included as a category in budget but had no estimate for costs | |||||||||||
| 014 | Cabinets | $ 7,000.00 | $ 13,345.00 | (6,345.00) | Estimate did not include printer nooks | |||||||||||
| 015 | Movers | $ 10,000.00 | $ 15,583.00 | (5,583.00) | Optimistic estimate | |||||||||||
| Legal | $ 5,000.00 | $ 22,069.00 | (17,069.00) | Estate planning included | ||||||||||||
| Interior Designer | $ - | $ 1,500.00 | (1,500.00) | Did not expect to need this service | ||||||||||||
| Architect | $ - | $ 3,863.00 | (3,863.00) | Should have estimated an amount for budget | ||||||||||||
| CPA Firm (tax planning) | $ - | $ 4,965.00 | (4,965.00) | Should have estimated an amount for budget | ||||||||||||
| Network cabling | $ - | $ 14,519.00 | (14,519.00) | We did not know if we could use existing cabling from prior tenant | ||||||||||||
| Parking lot sealing and painting | $ - | $ 5,550.00 | (5,550.00) | Should have estimated an amount for budget | ||||||||||||
| Signage for building | $ - | $ 3,789.00 | (3,789.00) | Should have estimated an amount for budget | ||||||||||||
| Lighting retrofit | $ - | $ 15,733.00 | (15,733.00) | Expected this to be done by SCE but instead it was a rebate that coved about a fourth of the costs | ||||||||||||
| Security Alarm | $ - | $ 22,000.00 | (22,000.00) | Should have estimated an amount for budget | ||||||||||||
| Conference table and projectors | $ - | $ 12,000.00 | (12,000.00) | Should have estimated an amount for budget | ||||||||||||
| Tanner Research labor | $ 32,445.00 | (32,445.00) | Should have estimated an amount for budget | |||||||||||||
| Due diligence and structural engineering | $ - | $ 14,309.00 | (14,309.00) | |||||||||||||
| $ 331,110.00 | $ 637,156.00 | $ (306,046.00) | ||||||||||||||