Answered step by step
Verified Expert Solution
Link Copied!

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

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 to Expert-Tailored 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

Inventory Best Practices

Authors: Steven M. Bragg

2nd Edition

1118000749, 9781118000748

More Books

Students also viewed these Accounting questions

Question

2 What are the key barriers to implementing HRM?

Answered: 1 week ago

Question

1 What are three of the formative traditions in HRM?

Answered: 1 week ago