Account Analysis Case Given the information below for the Patterson Manufacturing Companys bank accounts in the month of April 2021, produce an Account Analysis Statement similar in format to the one in the text in Chapter 6. (Note: Please calculate Collected Balances required, rather than Investable balances Your formulas will then match to the ones in the text.)

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.

\begin{tabular}{|l|c|c|} \hline Item - Services Performed & Number & Cost or Unit Price \\ \hline Account Maintenance & 3 & $25.00 \\ \hline Debits - paper & 3,589 & $0.23 \\ \hline Debits - electronic & 395 & $0.20 \\ \hline Credits - electronic & 5,829 & $0.15 \\ \hline Addenda Records Processed & 3,102 & $0.45 \\ \hline Controlled Disbursements & & \\ \hline Items Paid & 8,150 & $0.12 \\ \hline Paid Item Reject & 355 & $1.00 \\ \hline Teller Cash Float & 1,088 & $0.55 \\ \hline Paid Item Images & 8,099 & $0.25 \\ \hline Wholesale Lockbox & & $100 \\ \hline Monthly Maintenance & 2 & $0.50 \\ \hline Standard Items & 20 & $1.50 \\ \hline Deposit Tickets & 125,847 & $0.005 \\ \hline Data Capture & 984 & $0.65 \\ \hline Document Images & 125 & $15.00 \\ \hline Wire Transfers & 12 & $10.00 \\ \hline Domestic Wires - Out & 78 & $25.00 \\ \hline Domestic Wires - In & 45 & $15.00 \\ \hline International Wires - Out & & $0.002 \\ \hline International Wires - In & Infor & \\ \hline Info Services - Maintenance - Data Transfers & & \\ \hline \end{tabular}