Construction Project OverheadRate Overhead Cost FinalCost RejectAccept Manager Maryann Maryann Division Design Design Manufacturing Design Manufacturing Manufacturing I Manufacturing Design Manufacturing Design Design Design Manufacturing Design Manufacturing Funding BEST RNCB RNCS Wells Fargo RNCB IBB&T Wells Fargo BEST TRNCB BOAT IBBAT BBAT Wells Fargo Wells Fargo RNCB ProjectCost 173.000 232.000 132.000 244.000 228,000 285.000 283.000 265.000 120.000 88,000 158.000 223,000 228.000 99,000 240,000 Maryann Rick Scan Maryann Total Final Cost Min Final Cost Max Final Cost Average Final Cost ProjectCost Overhead Rate Raject ol 150000 175000 185000 200000 1. In Column Euse a lookup function to determine the OverheadRate using Project Cost 2. In Column F. calculate the Overhead Cost by multiplying ProjectCost by OverheadRate 3. In Column G. calculate FinalCost by adding Overhead Cost to Project Cost 3. Calculate Total Min, Max, and Average Final Cost (619-622) 4. Draw a chart that depicts Final Cost by Manager's (Charts should be added to new worksheets) 5. Draw a chart that shows Final Cost relative to the Total Final Cost 6. In Column Huse a logical function to determine "Reject Fina cost is more than $325,000 otherwise "Accep 7. In J20 and J21 use a count function to determine the number of projects that were Accepted and Rejected