Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please show the spreadsheet formulas you use. Lazarus Consulting is a large computer consulting company in New York. Pete Lazarus, the CEO and founder, is

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Please show the spreadsheet formulas you use.
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 each 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. Open the data file AYK4 Data.xlsx and determine the following: (You can refer to Tech Plugin 2 for information on how to use Excel.) What was the total donation amount per organization? (Without matching funds.) What were the average donations per organization? (Without matching funds.) Mary Submitted 127672071 12/10/2010 1275/2010 12.10.2011 12/6/2010 1227/2011 12/12010 12/2/2011 12/4/2011 11:20 2011 1272/2011 W312011 12/3/2011 1272/2011 12/12/2011 12/2012011 125 2011 12/12/2011 12/8/2011 12/6/2011 12/16/2011 12/3/2011 12/14/2017 12/17/2011 26 2011 2/16/2011 275/2011 2/10/2011 2762011 2/27/2011 2/13/2011 2/27/2011 214/2011 1/29/2011 2/2/2011 2/3/2011 2/3/2011 Employee 10 Last Name 21. Smith 234 Daniels 243 Bagley 334 Kelle 34 Cross 365 Lee 305 Smith 37 Wills 389 Fisher 42 Ash 454 Cross 450 Butler 499 Cross 543 Fisher 540 Daniels 558 LOS 654 Ash 657 Rogers 675 Ash 832 Haitz 867Daniels 945 Williams 97 Rogers 987 Haim 21 Smith 234 Daniels 245 Bagley 334 Kellee 345 Cross 365 Lee 386Smith 370 Wills 389 Fisher 4321 Ash 454 Cross 4561 Butler 499 Cross First Name Organization James DabCASSOCIO Jure Make a Wish Foundation Bob Cancer Society Pete Pouce Federation Roberta Leukemia Society Suteing Homeless Shelters James Habitat for Humanity Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter (Scott Meals on Wheels Julie Amnesty International Jim Meals on Wheels Carlin Diabetic Association Scott Animal Shelter Scott Diabetic Association Todd Cancer Society Jube Make a Wish Foundation James Vietnam Veterans Scott Homeless Shelters Gary Diabetic Association James Diabetic Association Julie Make a wish Foundation Bob Cancer Society Pete Police Federation Roberta Leukemia Society Sufeing Homeless Shelters James Habitat for Humanity Mary Habitat for Humanity Scott Cancer Society Jamie Habitat for Humanity Roberta Make a Wish Foundation Amy Cancer Society Roberta Animal Shelter Amount Donation Sent 550 72/1072011 $2251 12/29/2011 $25 127672011 $180 21472011 $60 12/19/2010 $25 1273072011 $150 12/23/2011 $100 12729/2011 $125 12/10/2011 $50 12/1/2011 $75 1274/2011 $250 12/01/2011 $20 1252010 $125 12/26/2011 $200 12/21/2011 $115 12112212011 $100 12/6/2011 $35 12/15/2011 $100 12/18/2011 $501 12/14/2011 $130 12/21/2011 $60 12/13/2011 S80 12/19/2011 $50 12/22/2011 $50 2/19/2011 $225 2/29/2011 $25 2/6/2011 $180 2/14/2011 S60 2/19/2011 $25 2/30/2011 $150 2123/2011 $100 2/29/2011 $25 2/10/2011 $50 2/1/2011 $75 2/4/2011 $250 2/10/2011 S20 275/2011 22/2011 222011 220/2011 225/2011 2220111 2/9/2011 2702011 216.2010 2320111 2/142011 2/17/2010 6762011 8/16. 2011 6/5/2011 6/10/2011 6/6/2011 627/2011 6132011 6/27/2011 6412011 5/29/2011 62/2011 6/3/2011 B3/2011 62/2011 6/6/2011 6/20/2011 6/5/2011 6/6/2011 6/9/2011 6/6/2011 5/16 2011 6/372011 6/14/2011 6/17/2011 9/9/2011 9/19/2011 9/8/2011 9/10/2011 549 lisher 5481Daniels 558 LOS 654 Ash 657 Rogers 675 Ash Hartz 867 Daniels 945 Williams 97 Rogers 987 Haim 25 Smith 234 Daniels 243 Bagley 334 Kellee 345 Cross 365 Lee 368 Smith 370 Wills 389 Fisher 432 Ash 454 Cross 456 Butler 499 Cross 543 Fisher 546 Daniels 558 Los 854 Ash 657 Rogers 675 Ash 832 Haitz 867 Daniels 945 Williams 977 Rogers 987| Haim 28 Smith 234 Daniels 243 Bagley 334 Kellee Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Cary James Julie Bob Pete Roberta Suleing James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary James Julie Bob Pete 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 $25 S200 $15 $100 $35 $100 $50 S130 $60 $80 $50 $50 $225 $26 $180 $60 $25 $150 $100 585 $501 $751 $250 $20 $65 $200 $55 $100 $35 $100 $50 S130 2/26/2011 2/21/2011 21/22/2011 2/6/2011 2/15/2011 2/18/2011 2/14/2011 2/21/2011 2/113/2011 2/19/2011 2/22/2011 6/19/2011 8/29/2011 6/6/2011 6/14/2011 6/19/2011 6730/2011 67232011 6/29/2011 6/10/2011 6/1/2011 6/4/2011 6/10/2011 05/2011 6/26/2011 6/21/2011 6/22/2011 6/8/2011 6/15/2011 6/18.2011 6/14/2011 6/21/2011 6/13/2011 6/19/2011 6722/2011 9/19/2011 9/29/2011 9/9/2011 971412201) $60 $80 $50 $80 S228 $28 $180 9/9/2011 9/27/2011 9/13/2011 9/27/2011 9/4/2011 8/29/2011 9/2/2011 9/3/2011 9/3/2011 9/2/2011 9/9/2011 9/20/2011 978/2011 9/9/2011 9/9/2011 9/9/2011 9/19/2011 9/3/2011 9/14/2011 9/17/2011 348 Cross 398 Lee 399 Smith 370 Wills 389 Fisher 4321Ash 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 Roberta Sufeina James Mary Scott Jamie Roberta Amy Roberta Scott Julie Jim Carlin Scott Scott Todd Julie James Scott Gary 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 590 $28 $180 $100 S98 $80 $78 $280 $20 S98 $200 S88 $100 $38 $100 $80 $130 S90 $80 $80 9/19/2011 9/30/2011 9/23/2011 9/29/2011 9/10/2011 9/1/2011 9/4/2011 9/10/2011 978/2011 9/29/2011 9/21/2011 9/22/2011 979/2011 9/18/2011 9/18/2011 9/14/2011 9/21/2011 9/13/2011 9/19/2011 9/22/2011 Amount TOTAL DONATIONS PER ORGANIZATION Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Total AVERAGE DONATION PER ORGANIZATION Amount Organization Amnesty International Total Animal Shelter Total Cancer Society Total Diabetic Association Total Habitat for Humanity Total Homeless Shelters Total Leukemia Society Total Make a Wish Foundation Total Meals on Wheels Total Police Federation Total Vietnam Veterans Total Grand Average

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

Bank Stability, Sovereign Debt And Derivatives

Authors: Author

1st Edition

113733214X, 9781137332141

More Books

Students also viewed these Accounting questions