Answered step by step
Verified Expert Solution
Question
1 Approved Answer
If the Buderim branch made 6.4 cents in interest for every $1 a customer was outstanding on a credit card, and 8.2 cents in interest
If the Buderim branch made 6.4 cents in interest for every $1 a customer was outstanding on a credit card, and 8.2 cents in interest for every $1 that a customer was overdrawn on a current account within their overdraft limit, and 45 cents for every $1 they went over their overdraft limit, how much interest would they make amongst the customers whose information is provided?
If the Buderim branch made 6.4 cents in interest for every $1 a customer was outstanding on a credit card, and 8.2 cents in interest for every $1 that a customer was overdrawn on a current account within their overdraft limit, and 45 cents for every $1 they went over their overdraft limit, how much interest would they make amongst the customers whose information is provided? Primo Bank Ltd: Account Database (Extract taken from Buderim branch data) $0 ID Account type 289-XXX-XXX-117 Premium saver - joint 289-XXX-XXX-117 Gold current - joint 289-XXX-XXX-116 Standard current 189-XXX-XXX-199 Platinum credit card 189-XXX-XXX-211 Gold current 189-XXX-XXX-211 Standard credit card 338-XXX-XXX-116 Standard current - joint 338-XXX-XXX-116 Saver - joint 338-XXX-XXX-074 Standard credit card 338-XXX-XXX-019 Standard current 421-XXX-XXX-288 Student current Name Paid out J Thakrar / S Thakrar J Thakrar / S Thakrar $3,238.12 N McBrydie $144.00 A Brock $299.82 E Rush $5,629.12 E Rush $2,877.12 H Radford / V Young $1,988.13 H Radford/V Young $0.00 L Palfreyman $189.45 M Gordon $1,890.74 S Bright $654.15 Paid in Balance $450.00 $20,237.18 $3,217.28 $1,278.20 $180 $245.34 $259 ($400.00) $7,889.54 $28,982.11 $2,877.12 $0.00 $1,800.12 ($597.12) $100 $500 $75.28 ($5,600.78) $2,000.35 $1,500.76 $686.12 $189.34 Overdraft limit $0 $3,000 $200 n/a $3,500 n/a $100 $0 n/a $200 0 Primo Account Types Held and Average Balances Primo Bank Ltd: Number of account types held 811,998 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 210,000 167,112 0 112,658 28,003 42,997 Gold current Platinum Premium saver credit card Saver Standard credit card Standard current 27,098 Student current Account Type Gold current Premium saver Saver Standard current Student current Average Balance ($) 2,688 23,005 5,000 575 101 Customer Transactions (Extract taken 9th June 2018) ID* last logged in latest transaction recent transactions 289-XXX-XXX-117 04/06/18:1816 $450 credit 15/05/18 $450 credit 15/04/18 $450 credit 15/03/18 $450 credit 15/02/18 289-XXX-XXX-116 07/06/18:0905 $4.57 debit 1/6/18 $12.87 debit 4/6/18 $2.40 debit 3/6/18 $11.23 debit 1/6/18 189-XXX-XXX-199 03/01/18:2304 $190.00 credit 5/6/18 $45.00 debit 5/6/18 $32.99 debit 4/6/18 $5.00 debit 3/6/18 289-XXX-XXX-116 05/06/16:1139 $74.80 debit 4/6/18 $880.12 debit 5/6/18 $37.45 debit 3/6/18 $2877.12 credit 2/6/18 338-XXX-XXX-116 12/12/17:0725 $100.00 credit 6/6/18 $109.27 debit 5/6/18 $2.78 debit 5/6/18 $98.76 debit 4/6/18 338-XXX-XXX-074 28/05/18:0905 $245.00 debit 1/6/18 $85.00 debit 29/5/18 $1007.00 debit 29/5/18 $2000.00 credit 28/5/18 189-XXX-XXX-199 07/06/18:1234 $1,890.74 credit 6/6/18 $32.99 debit 6/6/18 $82.00 debit 5/6/18 $44.00 debit 4/6/18 421-XXX-XXX-288 03/06/15:2305 $150.00 credit 6/6/18 $11.99 debit 6/6/18 $1.87 debit 6/6/18 $7.88 debit 6/6/18 *If a customer has multiple accounts, only data from one account is currently displayed in this view. The account with the most recent transaction is displayed. Data Guidelines In line with the new guidelines surrounding data presentation and storage, below is a useful summary for you of the areas. Most team members believe that we are not in breach of any of the below. 1. 2. 3. Customer data can only be stored for up to six months Customer names should not be presented in extracted data tables It should be possible to link all transactions to the customer making them Customers' gender and ethnicity should not be stored without prior consent 4. If the Buderim branch made 6.4 cents in interest for every $1 a customer was outstanding on a credit card, and 8.2 cents in interest for every $1 that a customer was overdrawn on a current account within their overdraft limit, and 45 cents for every $1 they went over their overdraft limit, how much interest would they make amongst the customers whose information is provided? Primo Bank Ltd: Account Database (Extract taken from Buderim branch data) $0 ID Account type 289-XXX-XXX-117 Premium saver - joint 289-XXX-XXX-117 Gold current - joint 289-XXX-XXX-116 Standard current 189-XXX-XXX-199 Platinum credit card 189-XXX-XXX-211 Gold current 189-XXX-XXX-211 Standard credit card 338-XXX-XXX-116 Standard current - joint 338-XXX-XXX-116 Saver - joint 338-XXX-XXX-074 Standard credit card 338-XXX-XXX-019 Standard current 421-XXX-XXX-288 Student current Name Paid out J Thakrar / S Thakrar J Thakrar / S Thakrar $3,238.12 N McBrydie $144.00 A Brock $299.82 E Rush $5,629.12 E Rush $2,877.12 H Radford / V Young $1,988.13 H Radford/V Young $0.00 L Palfreyman $189.45 M Gordon $1,890.74 S Bright $654.15 Paid in Balance $450.00 $20,237.18 $3,217.28 $1,278.20 $180 $245.34 $259 ($400.00) $7,889.54 $28,982.11 $2,877.12 $0.00 $1,800.12 ($597.12) $100 $500 $75.28 ($5,600.78) $2,000.35 $1,500.76 $686.12 $189.34 Overdraft limit $0 $3,000 $200 n/a $3,500 n/a $100 $0 n/a $200 0 Primo Account Types Held and Average Balances Primo Bank Ltd: Number of account types held 811,998 900,000 800,000 700,000 600,000 500,000 400,000 300,000 200,000 100,000 210,000 167,112 0 112,658 28,003 42,997 Gold current Platinum Premium saver credit card Saver Standard credit card Standard current 27,098 Student current Account Type Gold current Premium saver Saver Standard current Student current Average Balance ($) 2,688 23,005 5,000 575 101 Customer Transactions (Extract taken 9th June 2018) ID* last logged in latest transaction recent transactions 289-XXX-XXX-117 04/06/18:1816 $450 credit 15/05/18 $450 credit 15/04/18 $450 credit 15/03/18 $450 credit 15/02/18 289-XXX-XXX-116 07/06/18:0905 $4.57 debit 1/6/18 $12.87 debit 4/6/18 $2.40 debit 3/6/18 $11.23 debit 1/6/18 189-XXX-XXX-199 03/01/18:2304 $190.00 credit 5/6/18 $45.00 debit 5/6/18 $32.99 debit 4/6/18 $5.00 debit 3/6/18 289-XXX-XXX-116 05/06/16:1139 $74.80 debit 4/6/18 $880.12 debit 5/6/18 $37.45 debit 3/6/18 $2877.12 credit 2/6/18 338-XXX-XXX-116 12/12/17:0725 $100.00 credit 6/6/18 $109.27 debit 5/6/18 $2.78 debit 5/6/18 $98.76 debit 4/6/18 338-XXX-XXX-074 28/05/18:0905 $245.00 debit 1/6/18 $85.00 debit 29/5/18 $1007.00 debit 29/5/18 $2000.00 credit 28/5/18 189-XXX-XXX-199 07/06/18:1234 $1,890.74 credit 6/6/18 $32.99 debit 6/6/18 $82.00 debit 5/6/18 $44.00 debit 4/6/18 421-XXX-XXX-288 03/06/15:2305 $150.00 credit 6/6/18 $11.99 debit 6/6/18 $1.87 debit 6/6/18 $7.88 debit 6/6/18 *If a customer has multiple accounts, only data from one account is currently displayed in this view. The account with the most recent transaction is displayed. Data Guidelines In line with the new guidelines surrounding data presentation and storage, below is a useful summary for you of the areas. Most team members believe that we are not in breach of any of the below. 1. 2. 3. Customer data can only be stored for up to six months Customer names should not be presented in extracted data tables It should be possible to link all transactions to the customer making them Customers' gender and ethnicity should not be stored without prior consent 4Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started