Problem 8-3A
combs
WRD27e_PR08-3A.xlsxPr. 8-3A
| Problem 8-3A | # Incorrect N-box and B-box entries COUNTIF(B15:G24,"~*") | |||
| Name: | 0 | |||
| Section: | # N-box Incorrects due to blanks COUNTIF(B15:AT24," ") | |||
| 31 | ||||
| Score: | 0% | # N-box +B-box corrects COUNTIF(B15:AT24," ") | ||
| 0 | ||||
| Key Code: | [Key code here] | Total SUM(AD13:AD15) | ||
| Instructions | 31 | |||
| Answers are entered in the cells with gray backgrounds. | Percentage =(AD16-AD13-AD14)/AD16 | |||
| Cells with non-gray backgrounds are protected and cannot be edited. | 0% | |||
| An asterisk (*) will appear to the right of an incorrect entry. | Notes: | |||
| If number-entry box is blank (this would be an incorrect answer for N-boxes), error check returns two spaces, " " | ||||
| If number-entry or blank-entry box is incorrect, returns "*" | ||||
| 1. | AMERICAN MEDICAL CO. | If number-entry or blank-entry box is correct, returns single space, " " | ||
| Bank Reconciliation | Use data verification to set data entry to whole number >= 0, and use drop-downs for lables and names, so that students can't enter a space in a box and have it counted as correct. | |||
| April 30 | Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color. | |||
| Cash balance according to bank statement | ||||
| Add: |
cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values. | |||
|
Mark Sears: Enter the total of additions. | Bank error in charging check as $420 instead of $240 | |||
| Bank service charges | ||||
| Deduct: |
Mark Sears: Enter all amounts as positive values, whether being added or subtracted. | Deposit of April 30, not recorded by bank | ||
| Adjusted balance | Error in recording check | |||
| Note and interest collected by bank | ||||
| Cash balance according to company's records | Outstanding checks | |||
| Add: | ||||
| Deduct: |
cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values. | |||
| Adjusted balance | ||||
| 2. | ||||
| April 30 |
cpence: Record increases to cash in this entry. | Accounts Payable - Targhee Supply Co. | ||
|
cpence: Enter the larger of the credits on this line. | Cash | |||
| Interest Revenue | ||||
| Miscellaneous Expense | ||||
| 30 |
Mark Sears: Enter the largest of the two debits first. | Notes Receivable | ||
| 3. | ||||
| Amount to be reported on April 30 balance sheet | ||||
Sol
| Problem 8-3A | |||
| Name: | Solution | ||
| Section: | |||
| Scoring: | ON | ||
| Instructions | |||
| Answers are entered in the cells with gray backgrounds. | |||
| Cells with non-gray backgrounds are protected and cannot be edited. | |||
| An asterisk (*) will appear to the right of an incorrect entry. | |||
| 1. | AMERICAN MEDICAL CO. | ||
| Bank Reconciliation | |||
| April 30 | |||
| Cash balance according to bank statement | $ 388,600 | ||
| Add: | Deposit of April 30, not recorded by bank | $ 42,500 cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values. |
|
| Bank error in charging check as $420 instead of $240 | 180 | 42,680 Mark Sears: Enter the total of additions. | Error in recording check |
| Bank error in charging check as $420 instead of $240 | |||
| Deduct: | Outstanding checks | 61,280 Mark Sears: Enter all amounts as positive values, whether being added or subtracted. | Bank service charges |
| Adjusted balance | $ 370,000 | Outstanding checks | |
| Deposit of April 30, not recorded by bank | |||
| Cash balance according to company's records | $ 334,985 | Note and interest collected by bank | |
| Add: | Note and interest collected by bank | 42,000 | |
| Deduct: | Error in recording check | $ 6,840 cpence: Enter the larger of the two amounts on this line. Enter the amounts as positive values. |
|
| Bank service charges | 145 | 6,985 | |
| Adjusted balance | $ 370,000 | ||
| 2. | |||
| April 30 | Cash cpence: Record increases to cash in this entry. | 42,000 | Accounts Payable - Targhee Supply Co. |
| Notes Receivable cpence: Enter the larger of the credits on this line. | 40,000 | Cash | |
| Interest Revenue | 2,000 | Interest Revenue | |
| Miscellaneous Expense | |||
| 30 | Accounts Payable - Targhee Supply Co. Mark Sears: Enter the largest of the two debits first. | 6,840 | Notes Receivable |
| Miscellaneous Expense | 145 | ||
| Cash | 6,985 | ||
| 3. | |||
| Amount to be reported on April 30 balance sheet | $ 370,000 | ||
