Place your order now for a similar assignment and have exceptional work written by our team of experts, At affordable rates
Excel Case: Cookies Cares Charitable Foundation
What You Need
Download and save the following file:
Chapter 1 Raw Data.xlsx
Analyze the corporate social responsibility of the Cookies Cares Charitable Foundation.
Why is this data important, and what questions or problems need to be addressed?
•It is important to analyze the Cookies Cares Charitable Foundation’s charitable giving efforts to ensure that Julia’s Cookies is fulfilling its corporate social responsibility promise to grow its charitable efforts from year to year.
•To analyze the financial gifts that the Cookies Cares Charitable Foundation has given over the years, consider the following questions: How much was given? To whom were the charitable gifts allocated? Where are the charities located?
What data is needed, and how should it be analyzed?
•The data needed is captured by the Accounts Payable department and extracted from the database that supports the Financial module of the ERP system. Accounts Payable manages the charitable giving process because charitable donations are business expenses that are subject to specific internal controls.
•To isolate the charitable giving expenses for the Cookies Cares Charitable Foundation, the data is filtered on the Cost Center field to only show cost center 12542. Cost centers identify the departments where expenses are allocated. The data includes charitable donation expenses from 1/1/2019 through 12/31/2022.
Now it’s your turn to evaluate, analyze, and communicate the results!
1.How many banks did Julia’s Cookies use for charitable giving?
2.How many transactions were processed through Wells Fargo? (Hint: Each line item is a transaction.)
3.Which bank processed the fewest total transactions?
4.What was the total dollar amount of charitable giving expenses in 2021?
5.Which bank processed the smallest total dollar amount of transactions in 2021? How much was it?
6.Which bank processed the highest total dollar amount of transactions overall? How much was it?
7.What three charities received the largest dollar amounts of donations?
8.Which state received the largest dollar amount of donations?
Take it to the next level!
9.In what month and year was the largest dollar amount of charitable giving donated?
10.Which charity received the largest donation during that month and year?