“Project Cost Analysis and Visualization”

1. In Column E, determine OverheadRate using ProjectCost
2. In Column F, calculate Overhead Cost by multiplying ProjectCost times Overhead Rate
3. In Column G, calculate FinalCost by adding OverheadCost to ProjectCost
3. Calculate Min, Max, and Average FinalCost
4. In Column H, determine “Reject” if FinalCost is more than 325000 otherwise “Accept”
5. Draw a chart that depicts totals for Funding
6. Draw a chart that shows Funding totals brokendown by Division
7. Draw a chart that shows Funding totals relative to the Funding overall total
8. Create a pivot table that for each Funding source shows ProjectCost values for Division within Manager
9. In K21, count the number of projects that were rejected