Using Microsoft Excel, create an estimate for Bid ITEM 44 (Paving) from the attached problem. The spreadsheet should not be a recap of a hand done takeoff, do not use a calculator, It should include all the equations and links necessary to make the calculations. IGNORE the bonding requirement and add-ons but include the markups. You are the staff estimator for Hard Top Paving Services. Your task is to create a bid for a new road project that your company is pursuing. The "Instructions to Bidders" indicates that you must bid the following items: Mobilization & Demobilization (.5 days for each) 1 2 3 Site Clearing (37 acres) Cut & Fill Operations (240,000 cy) Paving (28' x 1.25 miles) Lines & Signs (as required) 4 5 . Use the following information to build your bid: I Means Cost Data that present labor and equipment costs by crew. Use the cost "Including Subs O&P" instead of "Bare Cost" Activities - handout Bond Table: 0-500,000 - $3.85/$1000, 500,000-5,000,000 - $2.45/$1000; over 5,000,000 - $1.10/$1000 Mark-Up: 15% on labor, 8% on equipment, 2% on materials Add-Ons: 3% on Sub-Contracts Activities Mobilitation & Demobilization By crew Site Clearing 3111-10.100200 Cut & Chip medium, trees to 12" diameter (B7, 68.571 MH/Acre) Grub stumps and remove (B30, 24 MH/Acre) 3111-10.100250 Cut & Fill 3122-16.100200 3123-16.50-1350 Grade subgrade for base course, roadways (B11L,.005 MH/SY) Excavation, Bulk, Self-Propelled Scraper, 3000' Haul (B33D, .020 MH/BCY) Paving 3211-23.23-0050 3212-16.13-0160 Base Course, Roadways, \" crushed stone, 3" deep (B36C, .008 MH/SY) Plant Mix Asphalt Paving, Binder Course, 3" thick (B25,.018 MH/SY) Plant Mix Asphalt Paving, Wearing Course, 2" thick (B25B, 0.15 MH/SY) 3212-16.13-0380 Lines & Signs 3217-23.13-0010 Painted Pavement Markings (Sub-Contract to Pete's Pavement Painting, LS $2500) Traffic Signs (Sub-Contract to Stanley's Signs, LS $3250) 1014.53.20-0010 Materials Plant Mix Asphalt, Delivered Binder Course $10.60/SY Wearing Course $7.90/SY Crushed Stone, ". Delivered $3.38/SY Means Cost Data Information Crew B-25 Bare Costs 1 Labor Foreman (Outside) 7 Laborers 3 Equipment Operators (med) 1 Asphalt Paver, 130 HP 1 Tandem Roller, 10 Ton 1 Roller, Pneumatic, Wheeled, 12 Ton 88 Labor Hours, Daily Totals Daily 37.10 296.80 35.10 280.80 46.55 1117.20 1996.00 227.60 313.20 4231.60 Including Subs O&P HT Daily 57.10 456.80 54.00 432.00 70.25 1686.00 2195.00 250.36 344.52 5364.68 Crew B-25B Bare Costs 1 Labor Foreman (Outside) 7 Laborers 4 Equipment Operators (med) 1 Asphalt Paver, 130 HP 2 Tandem Rollers, 10 Ton 1 Roller, Pneumatic, Wheeled, 12 Ton 96 Labor Hours, Daily Totals Daily 37.10 296.80 35.10 280.80 46.55 1489.60 1996.00 455.20 313.20 4831.60 Including Subs O&P H Daily 57.10 456.80 54.00 432.00 70.25 | 2248.00 2195.00 500.72 344.52 6177.04 Crew B-36C Bare Costs HE 37.10 46.55 35.30 1 Labor Foreman (Outside) 3 Equipment Operators (med) 1 Truck Driver, Heavy 1 Grader, 30,000 lbs 1 Dozer, 300 HP 1 1 Roller, Vibratory, 25 Ton 1 Truck Tractor, 6x4, 450 HP 1 1 Water Tank Trailer, 5000 Gal 40 Labor Hours, Daily Totals Daily 296.80 1117.20 282.40 610.80 1718.00 640.20 635.00 141.00 5441.40 Including Subs O&P Hr Daily 57.10 456.80 70.25 1686.00 53.55 428.40 671.88 1889.80 704.22 698.50 155.10 6690.70