I need help answering/filling out the sheet according to problems 10 & 11 
(Name) (Dato) Problem & 10 Committed Costs Buy Out --Problem # 11 Revised Adjust. Based Total Est. Over (Under) Estimatel on Costs Cost at Original Budget Incurred Completion Budget Original Cost Estimate Code Description Budget 1100 Supervision 1700 Temp. Utilities 1900 Cleanup 3300 Footings & Found. - labor 3400 Footings & Found. - conc. 3450 Concrete Pump 3500 SlablFloor - labor 3600 SlabFloor Concrete 3900 Rebar 4100 Masonry 5100 Structural Steel 5300 Joist and Desk 5900 Erection 6110 Rough Carpentry 6120 Lumber 7200 Insulation 7500 Roofing 7700 Roof Specialties 8110 Metal Doors & Frames 8400 Storm Fronts Revised djust. Basec Total Est. Over(Under) Estimatel on Costs Cost at Original Budget Incurred Completion Budget Original Committed Cost Estimate Costs Code Description Budget Buy Out 8700 Hardware 9100 Drywall 9200 Ceramic Tile 9300 Acoustical Treatment 9400 Carpet and Vinyl 9800 Paint 10400 Signage 10800 Toilet & Bath Access. 12300 Cabinetry & Countertops 21100 Fire Sprinklers 22100 Plumbing 23100 HVAC 26100 Electrical 31100 Grading & Excavation 32100 Asphalt 32200 Site Concrete - labor 32300 Site Concrete - concrete 32500 Landscaping 33100 Sanitary Sewer 33200 Water Line 99997 Profit & Overhead Total Increase (Decrease) in Original Budget as Compared to Revised Budget Increase (Decrease) in Revised Budget as Compared to Total Estimated Costs at Completion 10. Your company has been hired to act as a construction manager for the construction of a bookstore for a fixed fee of $32,000. When the design was 90% complete, you prepared a budget for the project, which is shown in Figure 4-13. During the buyout, the subcontracts shown in Figure 4-14 were signed and the purchase orders shown in Figure 4-15 were issued. No additional costs are ex- pected for the contracts in Figure 4-14 and the purchase orders in Figure 4-15. A purchase order has been issued for concrete for $115 per cubic yard. This price is 4% below the costs used in the budget. Code 01100 Budget 36,000 6,700 4,600 Code 04100 05900 07200 Contract Amount 42,136 8.200 01700 01900 1,802 03300 03400 03450 03500 03600 03900 04100 3,400 3,500 1,700 2,100 6,800 1,100 44,000 11,000 15,500 8,600 07500 08400 09100 09200 09300 09400 8.875 9,100 6,898 1,999 6.995 5,354 Description Masonry Erection Insulation Roofing Store Fronts Drywall Ceramic Tile Acoustical Treatment Carpet and Vinyl Paint Cabinetry and Countertops Fire Sprinklers Plumbing HVAC Electrical Grading and Excavation Asphalt Sanitary Sewer Water Line 09800 12300 05100 05300 Description Supervision Temporary Utilities Cleanup Footing and Foundation - Labor Footing and Foundation - Concrete Concrete Pump Slab/Floor-Labor Slab/Floor-Concrete Rebar Masonry Structural Steel Joist and Deck Erection Rough Carpentry Lumber Insulation Roofing Roof Specialties Metal Doors and Frames Store Fronts Hardware Drywall Ceramic Tile Acoustical Treatment Carpet and Vinyl Paint 21100 05900 22100 06110 500 8,000 9,865 7,000 22,115 23,850 17,825 6,150 17,569 1.359 1,125 06120 23100 26100 31100 32100 33100 33200 07200 07500 07700 08110 08400 FIGURE 4-14 Subcontracts for Problem 10 08700 09100 09200 09300 Description Structural Steel PO Amount 10.250 09400 Code 05100 05300 06120 09800 10400 15,500 875 900 1,700 9,000 1,000 2,900 9,500 1,900 6,700 2,100 7,200 5,500 8,200 500 1.000 10,000 6,700 24.000 23,000 19.000 6,300 17,000 1,000 1,000 1,000 1,000 1,000 10800 07700 08110 08700 Joist and Deck Lumber Roof Specialties Metal Doors and Frames Hardware Signage Toilet & Bath Accessories 945 2.725 12300 1.864 21100 22100 486 10400 10800 965 23100 FIGURE 4-15 Purchase Orders for Problem 10 Signage Toilet & Bath Accessories Cabinetry and Countertops Fire Sprinklers Plumbing HVAC Electrical Grading and Excavation Asphalt Site Concrete-Labor Site Concrete-Concrete Landscaping Sanitary Sewer Water Line Profit and Overhead TOTAL 26100 31100 32100 32200 32300 32500 33100 33200 11. The project in Problem 10 is expected to take 9 months to complete. The costs for the project at the end of the second month are shown in Figure 4-16. You have a meeting with project's owner to discuss the financial status of the project. Using the committed cost work- sheet from Problem 10, update the estimated cost at completion and determine if the project is over or under budget. The supervision and temporary utility costs should be prorated over the life of the project. The pouring of the footings, foundations, and floor slab are complete. 32,000 346,600 FIGURE 4-13 Budget for Problem 10 You have a meeting with the project's owner to discuss (Name) (Dato) Problem & 10 Committed Costs Buy Out --Problem # 11 Revised Adjust. Based Total Est. Over (Under) Estimatel on Costs Cost at Original Budget Incurred Completion Budget Original Cost Estimate Code Description Budget 1100 Supervision 1700 Temp. Utilities 1900 Cleanup 3300 Footings & Found. - labor 3400 Footings & Found. - conc. 3450 Concrete Pump 3500 SlablFloor - labor 3600 SlabFloor Concrete 3900 Rebar 4100 Masonry 5100 Structural Steel 5300 Joist and Desk 5900 Erection 6110 Rough Carpentry 6120 Lumber 7200 Insulation 7500 Roofing 7700 Roof Specialties 8110 Metal Doors & Frames 8400 Storm Fronts Revised djust. Basec Total Est. Over(Under) Estimatel on Costs Cost at Original Budget Incurred Completion Budget Original Committed Cost Estimate Costs Code Description Budget Buy Out 8700 Hardware 9100 Drywall 9200 Ceramic Tile 9300 Acoustical Treatment 9400 Carpet and Vinyl 9800 Paint 10400 Signage 10800 Toilet & Bath Access. 12300 Cabinetry & Countertops 21100 Fire Sprinklers 22100 Plumbing 23100 HVAC 26100 Electrical 31100 Grading & Excavation 32100 Asphalt 32200 Site Concrete - labor 32300 Site Concrete - concrete 32500 Landscaping 33100 Sanitary Sewer 33200 Water Line 99997 Profit & Overhead Total Increase (Decrease) in Original Budget as Compared to Revised Budget Increase (Decrease) in Revised Budget as Compared to Total Estimated Costs at Completion 10. Your company has been hired to act as a construction manager for the construction of a bookstore for a fixed fee of $32,000. When the design was 90% complete, you prepared a budget for the project, which is shown in Figure 4-13. During the buyout, the subcontracts shown in Figure 4-14 were signed and the purchase orders shown in Figure 4-15 were issued. No additional costs are ex- pected for the contracts in Figure 4-14 and the purchase orders in Figure 4-15. A purchase order has been issued for concrete for $115 per cubic yard. This price is 4% below the costs used in the budget. Code 01100 Budget 36,000 6,700 4,600 Code 04100 05900 07200 Contract Amount 42,136 8.200 01700 01900 1,802 03300 03400 03450 03500 03600 03900 04100 3,400 3,500 1,700 2,100 6,800 1,100 44,000 11,000 15,500 8,600 07500 08400 09100 09200 09300 09400 8.875 9,100 6,898 1,999 6.995 5,354 Description Masonry Erection Insulation Roofing Store Fronts Drywall Ceramic Tile Acoustical Treatment Carpet and Vinyl Paint Cabinetry and Countertops Fire Sprinklers Plumbing HVAC Electrical Grading and Excavation Asphalt Sanitary Sewer Water Line 09800 12300 05100 05300 Description Supervision Temporary Utilities Cleanup Footing and Foundation - Labor Footing and Foundation - Concrete Concrete Pump Slab/Floor-Labor Slab/Floor-Concrete Rebar Masonry Structural Steel Joist and Deck Erection Rough Carpentry Lumber Insulation Roofing Roof Specialties Metal Doors and Frames Store Fronts Hardware Drywall Ceramic Tile Acoustical Treatment Carpet and Vinyl Paint 21100 05900 22100 06110 500 8,000 9,865 7,000 22,115 23,850 17,825 6,150 17,569 1.359 1,125 06120 23100 26100 31100 32100 33100 33200 07200 07500 07700 08110 08400 FIGURE 4-14 Subcontracts for Problem 10 08700 09100 09200 09300 Description Structural Steel PO Amount 10.250 09400 Code 05100 05300 06120 09800 10400 15,500 875 900 1,700 9,000 1,000 2,900 9,500 1,900 6,700 2,100 7,200 5,500 8,200 500 1.000 10,000 6,700 24.000 23,000 19.000 6,300 17,000 1,000 1,000 1,000 1,000 1,000 10800 07700 08110 08700 Joist and Deck Lumber Roof Specialties Metal Doors and Frames Hardware Signage Toilet & Bath Accessories 945 2.725 12300 1.864 21100 22100 486 10400 10800 965 23100 FIGURE 4-15 Purchase Orders for Problem 10 Signage Toilet & Bath Accessories Cabinetry and Countertops Fire Sprinklers Plumbing HVAC Electrical Grading and Excavation Asphalt Site Concrete-Labor Site Concrete-Concrete Landscaping Sanitary Sewer Water Line Profit and Overhead TOTAL 26100 31100 32100 32200 32300 32500 33100 33200 11. The project in Problem 10 is expected to take 9 months to complete. The costs for the project at the end of the second month are shown in Figure 4-16. You have a meeting with project's owner to discuss the financial status of the project. Using the committed cost work- sheet from Problem 10, update the estimated cost at completion and determine if the project is over or under budget. The supervision and temporary utility costs should be prorated over the life of the project. The pouring of the footings, foundations, and floor slab are complete. 32,000 346,600 FIGURE 4-13 Budget for Problem 10 You have a meeting with the project's owner to discuss
