Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Answer fully and on excel. Need the total per organization and average per organization. As well as the info in the first picture. Thank you!

Answer fully and on excel. Need the total per organization and average per organization. As well as the info in the first picture. Thank you!

image text in transcribed

image text in transcribedimage text in transcribed

MGT 114 Individual Assignment 1 Tracking Donations Lazarus Consulting is a large computer consulting company in New York. Pete Lazarus, the CEO and founder, is well known for his philanthropic efforts. Pete knows that most of his employees contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. Pete began a program that matches 50 percent of cach employee donation. The only stipulations are that the charity must be a nonprofit organization and the company will match only up to $2,000 per year per employee. Apply the Sort and Subtotal function in Excel to analyze the AYK4_Data.xlsx data file and determine the following: 1. What was the total donation amount per organization? 2. What was the average donation amount per organization? | First Name James Julie Bob Pete Roberta Sufeing James Mary Scott Jamie | Submitted | 12/6/11) 12/16/11 12/5/11 12/10/11 12/6/11) 12/27/11 12/13/11 12/27/11 12/4/11) 11/29/11 12/2/11 12/3/11 12/3/11 12/2/11 12/12/11 12/20/11 12/5/11 12/12/11 12/9/11 12/6/11 12/16/11) 12/3/11) 12/14/11 12/17/11 2/6/11) 2/16/11 2/5/11) 2/10/11 2/6/11) 2/27/11] 2/13/11) 2/27/11) 2/4/11 1/29/11 2/2/11 2/3/11 2/3/11 2/2/11) 2/2/11) 2/20/11 2/5/11) 2/2/11 2/9/11 2/6/11 2/16/11 2/3/11) 2/14/11 2/17/11 6/6/11) 6/16/11 6/5/11 6/10/11 6/6/11) 6/27/11 6/13/11 Employee ID 1 Last Name 211 Smith 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 366 Smith 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 499 Cross 543 Fisher 546 Daniels 558 Los 654 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987 Haim 21 Smith 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 366 Smith 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 4991 Cross 543 Fisher 546 Daniels 558 Los 654 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987 Haim 25 Smith 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 366 Smith Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Julie Bob Pete Roberta Sufeing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Julie Bob Pete Roberta Sufeing James Organization Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Amount | Donation Sent $80 12/19/11 $2001 12/29/11 $50 12/6/11 $220 12/14/11 $80 12/19/11 $401 12/30/11 $120 12/23/11 $100 12/29/11 $125 12/10/11 $801 12/1/11 $501 12/4/11 $200 12/10/11 $30 12/5/11 $1201 12/26/11 $200 12/21/11 $115 12/22/11 $100 12/6/11 $35 12/15/11 $100 12/18/11 $50 12/14/11 $130 12/21/11 $601 12/13/11 $80 12/19/11 $50 12/22/11 $50 2/19/11 $225 2/29/2011 $25 2/6/11 $180 2/14/11 $60 2/19/11 $251 2/30/2011 $150 2/23/11 $100 2/29/2011 $25 2/10/11 $50 2/1/11 $75 2/4/11 $250 2/10/11 $20 2/5/11 $251 2/26/11 $200 2/21/11 $15 2/22/11 $100 2/6/11 $351 2/15/11 $100 2/18/11 $501 2/14/11 $130 2/21/11 $60 2/13/11 $80 2/19/11 $50 2/22/11 $50 6/19/11 $225 6/29/11 $25 6/6/11 $180 6/14/11 6/19/11 $25 6/30/11 $150 6/23/11 11 $60 dation $100 $70 $501 $75 $250 $20 $651 $200 $60 $100 $351 $100 $50 6/27/11 6/4/11 5/29/11 6/2/11) 6/3/11 6/3/11 6/2/11 6/6/11 6/20/11 6/5/11 6/6/11) 6/9/11 6/6/11 6/16/11 6/3/11 6/14/11 6/17/11 9/9/11) 9/19/11 9/8/11 9/10/11 9/9/11) 9/27/11) 9/13/11) 9/27/11 9/4/11) 8/29/11 9/2/11) 9/3/11 9/3/11 9/2/11 9/9/11 9/20/11 9/8/11) 9/9/11 9/9/11) 9/9/11 9/19/11 9/3/11) 9/14/11 9/17/11 $130 $60 $80 $50 $80 $220 $28 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 499 Cross 543 Fisher 546 Daniels 558 Los 654 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987 Haim 28 Smith 234 Daniels 243 Bagley 334 Kellee 348| Cross 398 Lee 399 Smith 370 Wills 389 Fisher 432 Ash 484 Cross 489 Butler 499 Cross 843 Fisher 849 Daniels 888 Los 984 Ash 987 Rogers 978|Ash 832 Haitz 897 Daniels 948|Williams 977 Rogers 987 Haim Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Julie Bob Pete Roberta Sufeing James Mary Scott Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association Diabetic Association Make a Wish Foundation Cancer Society Police Federation Leukemia Society Homeless Shelters Habitat for Humanity Habitat for Humanity Cancer Society Habitat for Humanity Make a Wish Foundation Cancer Society Animal Shelter Meals on Wheels Amnesty International Meals on Wheels Diabetic Association Animal Shelter Diabetic Association Cancer Society Make a Wish Foundation Vietnam Veterans Homeless Shelters Diabetic Association $180 6/29/11 6/10/11 6/1/11 6/4/11 6/10/11 6/5/11 6/26/11 6/21/11 6/22/11 6/6/11 6/15/11 6/18/11 6/14/11 6/21/11 6/13/11 6/19/11 6/22/11 9/19/11 9/29/11 9/9/11 9/14/11 9/19/11 9/30/11 9/23/11 9/29/11 9/10/11 9/1/11 9/4/11 9/10/11 9/8/11 9/29/11 9/21/11 9/22/11 9/9/11 9/18/11 9/18/11 9/14/11 9/21/11 9/13/11) 9/19/11 9/22/11 Jamie $90 $300 $180 $100 $100 $80 $78 $280 $20 $1001 $200 $88 Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary $100 $40 $100 $80 $120 $901 $80 $100

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

Quality Audits For Improved Performance

Authors: Dennis R. Arter

3rd Edition

0873895703, 978-0873895705

More Books

Students also viewed these Accounting questions

Question

16-2 Describe the characteristics of special possessions.

Answered: 1 week ago