Answered step by step
Verified Expert Solution
Link Copied!

Question

00
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

image text in transcribed

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 1739

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions