Background: You are testing the accuracy and valuation management assertion of the allowance for bad debt account for your client, Oakley Turf, using its A/R subsidiary ledger in cells A18:A67 Instructions: (1) Use the SUMif function in cells B15:817 to compute the sum for each balance status as efficiently as possible using Excel formulas; (2) Foot the A/R subsidiary ledger provided to the client's recorded A/R balance from the trial balance to make sure the information they provided you was complete. Also foot the A/R total in B18 and agree the amount to the client's recorded A/R balance (ensure it says "Yes" in cell D18); (3) Caiculate your expectation for the Allowance for Bad Debt account in cell C21 and compare it to the client's recorded amount by calculating a difference between recorded and expected amounts in cell C22, and describe in cell B25 what (if any) steps you will take next as the auditor. All work on this assignment must be your team's own. Direct questions to vour professor, not classmates. \begin{tabular}{|c|c|c|c|} \hline A & B & C & D \\ \hline 17 & Delinquent & & Aging Categories Foot? (Yes/No) \\ \hline 18 & TOTAL Gross A/R & & No \\ \hline 19 & & & \\ \hline 20 & Client's recorded Allowance for Bad Debt & $150,000,00 & \\ \hline 21. & Auditor expectation of Allowance for Bad Debt & & \\ \hline 22 & Difference & & \\ \hline 23 & & & \\ \hline 24 & Based on the resuits of your testing herein, what should you do? & Mark "Yes" or "No" & \\ \hline 25 & As k the client to provide an explanation for the difference & YES & \\ \hline 26 & Notify your audit senior of the difference & YES & \\ \hline 27 & Assumingtheauditorsandelientdisagree,fornowrecordthedifferenceontheSummaryofAdjustmentsPassed(SOAPI? & & \\ \hline 28 & & & \\ \hline 30 & Account Receivable Subsidiary Ledger- Oakiey Turf & & \\ \hline 31 & WHA Customer & AR Balance & Age (days) \\ \hline 32 & & 29,938.51 & 9 \\ \hline 33 & HDSupplv & 34,990.87 & 64 \\ \hline 34 & Joes5uppliv & 77.480 .45 & 56 \\ \hline 35: & SpeedySuppiy & 30,602.54 & 19 \\ \hline 36 & BigTex & 21,99443 & 5 \\ \hline 37 & & A1111,319,70 & 119 \\ \hline 38 & Love's & & 17 \\ \hline 39 & TractorSupply & IfII 58,43275 & 25 \\ \hline 40 & Turnerco & 52,57758 & 84 \\ \hline \end{tabular}