Use Excel show work plz and many thanks!
Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September 2019, produce an Account Analysis Statement similar in format to the one in the text in Chapter 7. (Note: Please calculate Collected Balances required) 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%. 1. Determine: (1) The Collected Balance, (2) the service charge for each item and the total service charge for the month, (3) the overall required collected balance and the required collected balance for each of the items above. 2. Provide the balance summary(according to the example in chapter 7): Ledger balance, float, collected balance, reserve requirement, available balance, available required, and the net available balance. 3. Provide the earning credit summary(according to the example in chapter 7): Available balance for earnings credit, earnings credit allowance, charge for services, net service credit. 4. Is it a surplus earnings credits or deficit balance that must be charged to the account for the month? Given the information below for the Patterson Manufacturing Company's bank accounts in the month of September 2019, produce an Account Analysis Statement similar in format to the one in the text in Chapter 7. (Note: Please calculate Collected Balances required) 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%. 1. Determine: (1) The Collected Balance, (2) the service charge for each item and the total service charge for the month, (3) the overall required collected balance and the required collected balance for each of the items above. 2. Provide the balance summary(according to the example in chapter 7): Ledger balance, float, collected balance, reserve requirement, available balance, available required, and the net available balance. 3. Provide the earning credit summary(according to the example in chapter 7): Available balance for earnings credit, earnings credit allowance, charge for services, net service credit. 4. Is it a surplus earnings credits or deficit balance that must be charged to the account for the month
