RedRocks Consulting, Management Information help

Anonymous
timer Asked: May 7th, 2016
account_balance_wallet $5

Question Description

Filtering RedRocks Consulting Contributions RedRocks Consulting is a large computer consulting firm in Denver, Colorado. Don McCubbrey, the CEO and founder of the firm, is well-known for his philanthropic efforts. He believes that many of his employees also contribute to nonprofit organizations and wants to reward them for their efforts while encouraging others to contribute to charities. He started a program in which RedRocks Consulting matches 50 percent of each donation an employee makes to the charity of his or her choice. The only guidelines are that the charity must be a nonprofit organization and the firm’s donation per employee may not exceed $500 a year. Don has started an Excel file, T3_RedRocks_Data.xls, to record the firm’s donations. Included in this file are the dates the request for a donation was submitted, the employee’s name and ID number, the name of the charity, the dollar amount contributed by the firm, and the date the contribution was sent. Don wants you to help him create several worksheets with the following criteria: 

1. One worksheet that sorts the list alphabetically by organization and then by employee’s last name. 

2. One worksheet that totals the contribution made per employee for the month of December. 

 3. One worksheet that sorts the list by donation value by lowest amount to highest amount. 

Tutor Answer

rafatisina
School: Duke University

I got this excel file from the google. Is that your file?  if yes I have already did the job for you. if not please send me your file I will do it in 15 minutes for you. :) I will write the explanation anyway so you can underestand the appraoch :)

Submitted Employee ID Last Name
12/12/2006
1XBA Doster
12/27/2006
J5M Johnson
12/14/2006
FA5A Peters
11/29/2006
688 Abbs
12/13/2006
R9M Simpson
12/27/2006
R45A Womak
12/6/2006
0NNA Clark
12/3/2006
C3P Warren
12/2/2006
0NNA Clark
12/16/2006
CT8A Donovan
12/16/2006
L3H Dunn
12/2/2006
56NA Foster
12/20/2006
57XA Lomstein
12/5/2006
08T Adams
12/9/2006
Y7CA Ascott
12/17/2006
1F9A Hughes
12/6/2006
R9M Simpson
12/10/2006
44JA Kelleher
12/5/2006
M5NA Bagby
12/3/2006
39N Butler
12/4/2006
56NA Foster
12/6/2006
08A Thimsen
12/3/2006
0NNA Clark
12/12/2006
FA5A Peters

First Name
Glenn
Les
Roger
Don
Jospeh
Anthony
Jolene
James
Jolene
Gary
Elaine
Scott
Thomas
David
Karen
Gary
Joseph
George
Sharon
Barry
Scott
Timothy
Jolene
Roger

Organization
Amnisty International
Foster Children's Fund
Foster Children's Fund
Habitat for Humanity
Habitat for Humanity
Habitat for Humanity
Leukemia Society
Lion's Club
Make a Wish Foundation
Make a Wish Foundation
Make a Wish Foundation
Meals on WHeels
Meals on WHeels
Red Cross
Red Cross
Red Cross
Red Cross
Romania Relief
Rotary Club
Rotary Club
Rotary Club
Rotary Club
Toastmasters
Toastmasters

Amount Donation Sent
$
200
12/21/2006
$
25
12/30/2006
$
80
12/19/2006
$
50
12/1/2006
$
150
12/23/2006
$
100
12/29/2006
$
60
12/19/2006
$
60
12/13/2006
...

flag Report DMCA
Review

Anonymous
Goes above and beyond expectations !

Similar Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors