What is the total value of the VCCs created in Bank Report

Reference no: EM132249265

Assignment -

Background: Kingston LLC utilizes a bank software to issue virtual credit cards (VCCs) to our experience and travel marketplace vendors on behalf of Wishlist gift recipients to pay for that experience or travel booking. Monthly, we must reconcile the VCCs issued, used, and values remaining to understand our cost of goods sold as well as our remaining cash exposure on cards that still have a value, and/or if any cards have been over-charged. We do this by comparing two data sets, one from the bank and one from our database. Your exercise will be to do this analysis.

Instructions: Compare the two data sets and answer the below questions. It's important to show us how you arrived at your answers by providing proof of concept through equations/formulas.

Questions:

1. What is the unique identifier that is synonymous between the data sets? (Hint: this identifier would be the baseline for all further analyses between the datasets).

2. Do the data sets have the same number of VCCs issued? If yes, how many? If no, which data set has more VCCs and by how many?

3. What is the total value of the VCCs created in the Bank Report?

4. What is the total value of the VCCs created in the Database Report?

5. What is the highest value VCC created per the Bank Report?

6. For the VCCs created that match between the reports, what is the total variance of all VCC values between the two reports?

7. How many VCCs created that match between the reports have a NULL value in the Database Report?

8. How many VCCs created that match between the reports have a $0 value in the Database Report but a greater than $0 value in the Bank Report?

9. How many VCCs created that match between the reports have been over-charged?

10. How many VCCs created that match between the reports will need to be researched by our booking team?

Attachment:- Assignment File.rar

Reference no: EM132249265

Questions Cloud

Demonstrate a connection to your current work environment : If you are not currently working, share how this could be applied to an employment opportunity in your field of study.

Describe how you would start this incident off correctly : Describe how you would start this incident off correctly by properly protecting and securing the evidence on the laptop.

Capture how it impacts both internal staff and processes : Capture how it impacts both internal staff and processes, and external people and organizations that interact with it.

Research the web and identify a case study : Draw specific lessons and recommendations from your analysis of the case as part of the conclusion, and have a strong concluding paragraph.

What is the total value of the VCCs created in Bank Report : What is the total value of the VCCs created in the Bank Report? What is the total value of the VCCs created in the Database Report

Illustrate various security areas : Demonstrate a connection to your current work environment. If you are not employed, demonstrate a connection to your desired work environment.

How do you overcome an incident in your information company : How do you overcome an incident in your Information technology company? Do a presentation and provide a full report to your executive board.

Demonstrate a connection to your current work environment : At UC, it is a priority that students are provided with strong educational programs and courses that allow them to be servant-leaders in their disciplines.

Describe the main objectives of the anba drp : Describe the main objectives of the ANBA DRP. Explain the key ways that ANBA's DRP can help mitigate risk in the organization.

User Account

All Pages