Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you please help and explain questions 1,2,3, and 4? Class Grade Roster OverheadCost FinalCost Reject/Accept Manager Maryann Rick Sean Rick Maryann Sean Rick Maryann
Can you please help and explain 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started