Account Analysis Case Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September 2017, produce an Account Analysis Statement similar in format to the one in the text in Chapter 7. (Note: Please calculate Collected Balances required, rather than Investable balances - Your formulas will then match to the ones in the text.) Number 3 3,589 395 5,829 3,102 Cost or Unit Price $25.00 $0.23 $0.20 $0.15 $0.45 8,150 355 1,088 8,099 $0.12 $1.00 $0.55 $0.25 Item - Services Performed Account Maintenance Debits - paper Debits - electronic Credits - electronic Addenda Records Processed Controlled Disbursements Items Paid Paid Item Reject Teller Cash Float Paid Item Images Wholesale Lockbox Monthly Maintenance Standard Items Deposit Tickets Data Capture Document Images Wire Transfers Domestic Wires - Out Domestic Wires - In International Wires - Out International Wires - In Info Services - Maintenance Info Services Data Transfers 2 9,875 20 125,847 984 $100 $0.50 $1.50 $0.005 $0.65 125 12 78 45 1 87,459 $15.00 $10.00 $25.00 $15.00 $150.00 $0.002 In addition for the month in question, the company had an Average Ledger Balance of $8,653,976, with Deposit Float of $928,237. You may assume an ECR of 2.5% and Reserve Requirement of 10%. Determine: The Collected Balance, the breakout of service charges for the month, the overall required balance and the required balance for each of the items above. Also compute the amount of either surplus earnings credits or deficit balance that must be charged to the account for the month in question. Account Analysis Case Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September 2017, produce an Account Analysis Statement similar in format to the one in the text in Chapter 7. (Note: Please calculate Collected Balances required, rather than Investable balances - Your formulas will then match to the ones in the text.) Number 3 3,589 395 5,829 3,102 Cost or Unit Price $25.00 $0.23 $0.20 $0.15 $0.45 8,150 355 1,088 8,099 $0.12 $1.00 $0.55 $0.25 Item - Services Performed Account Maintenance Debits - paper Debits - electronic Credits - electronic Addenda Records Processed Controlled Disbursements Items Paid Paid Item Reject Teller Cash Float Paid Item Images Wholesale Lockbox Monthly Maintenance Standard Items Deposit Tickets Data Capture Document Images Wire Transfers Domestic Wires - Out Domestic Wires - In International Wires - Out International Wires - In Info Services - Maintenance Info Services Data Transfers 2 9,875 20 125,847 984 $100 $0.50 $1.50 $0.005 $0.65 125 12 78 45 1 87,459 $15.00 $10.00 $25.00 $15.00 $150.00 $0.002 In addition for the month in question, the company had an Average Ledger Balance of $8,653,976, with Deposit Float of $928,237. You may assume an ECR of 2.5% and Reserve Requirement of 10%. Determine: The Collected Balance, the breakout of service charges for the month, the overall required balance and the required balance for each of the items above. Also compute the amount of either surplus earnings credits or deficit balance that must be charged to the account for the month in
