Question: Can you please help and explain how to do questions 1,2, 3 and 4? Class Grade Roster OverheadCost FinalCost Reject/Accept Manager Maryann Rick Sean Rick

Can you please help and explain how to do questions 1,2, 3 and 4?
Class Grade Roster OverheadCost FinalCost Reject/Accept Manager Maryann Rick Sean Rick Maryann Sean Rick Maryann Sean Rick Maryann Sean Rick Maryann Sean Division Design Design Manufacturing Design Manufacturing Manufacturing Manufacturing Design Manufacturing Design Design Design Manufacturing Design Manufacturing Funding BB&T RNCB RNCB Wells Fargo RNCB BB&T Wells Fargo BB&T RNCB BB&T BB&T BB&T Wells Fargo Wells Fargo RNCB Project Cost OverheadRate 173000 232000 132000 244000 228000 285000 283000 265000 128000 88000 158000 223000 228000 203000 243000 Number of Reject ProjectCost Overhead Rate 0 0.03 150000 0.05 175000 0.1 185000 0.2 200000 0.25 Min Final Grade Max FinalGrade Average FinalGrade Count of "Passed = Yes" 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 1221 7. Draw a chart that shows Funding totals relative to the Funding overall total 848 8. Create a pivot table that for each Funding source shows ProjectCost values for Division within Manager 1210 9. In K21, count the number of projects that were rejected RNCB Wells Fargo BB&T Manufacturing Design 756 561 223 1540 465 287 987 1739Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
