ACC2021

profileBURROEPELUSA
06-2b_12e_4.xls
Home>Business & Finance homework help>Accounting homework help>ACC2021

Pr. 6-2B

Problem 6-2B # Incorrect N-box and B-box entries COUNTIF(B15:G24,"~*")
Name: 0
Section: # N-box Incorrects due to blanks COUNTIF(B15:AT24," ")
29
Score: 0% # N-box +B-box corrects COUNTIF(B15:AT24," ")
0
Key Code: [Key code here] Total SUM(AD13:AD15)
Instructions 29
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. In part 1, only final inventory cost - Column K - will be graded. Notes:
1. Date Purchases Cost of Merchandise Sold Inventory If number-entry or blank-entry box is incorrect, returns "*"
Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost If number-entry or blank-entry box is correct, returns single space, " "
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.
Aor. 3 25 $1,200 $ 30,000 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.
8
11
30
May 8
10
19
28
June 5
16
21
28
Sales
30 Balances Accounts Receivable
Merchandise Inventory
Cost of Merchandise Sold
2.
Total sales
Total cost of goods sold
Gross profit
3.
Ending inventory cost
This should equal the ending inventory balance in part 1.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the latest units first, above the units that were received earlier.
Enter the total of column H, the total cost of merchandise sold.
Enter the ending inventory balance.

Sol

Problem 6-2B
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. In part 1, only final inventory cost - Column K - will be graded.
1. Date Purchases Cost of Merchandise Sold Inventory
Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Aor. 3 25 $1,200 $ 30,000
8 75 $1,240 $ 93,000 25 $1,200 $ 30,000
75 $1,240 93,000
11 40 $1,240 $ 49,600 25 $1,200 $ 30,000
35 $1,240 43,400
30 30 $1,240 $ 37,200 25 $1,200 $ 30,000
5 $1,240 6,200
May 8 60 $1,260 $ 75,600 25 $1,200 $ 30,000
5 $1,240 6,200
60 $1,260 75,600
10 50 $1,260 $ 63,000 25 $1,200 $ 30,000
5 $1,240 6,200
10 $1,260 12,600
19 10 $1,260 $ 12,600
5 $1,240 6,200
5 $1,200 6,000 20 $1,200 $ 24,000
28 80 $1,260 $ 100,800 20 $1,200 $ 24,000
80 $1,260 100,800
June 5 40 $1,260 $ 50,400 20 $1,200 $ 24,000
40 $1,260 50,400
16 25 $1,260 $ 31,500 20 $1,200 $ 24,000
15 $1,260 18,900
21 35 $1,264 $ 44,240 20 $1,200 $ 24,000
15 $1,260 18,900
35 $1,264 44,240
28 35 $1,264 $ 44,240 20 $1,200 $ 24,000
9 $1,260 11,340 6 $1,260 7,560
30 Balances $ 312,080 $ 31,560
2. Sales
Total sales 0 $ 525,250 0 Accounts Receivable
Total cost of goods sold 0 312,080 0 Merchandise Inventory
Gross profit $ 213,170 Cost of Merchandise Sold
3. 0
Ending inventory cost $31,560
Place the earliest units first, above the units that were received later.
Enter the total of column H, the total cost of merchandise sold.
Enter the ending inventory balance.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the earliest units first, above the units that were received later.
Place the latest units first, above the units that were received earlier.
This should equal the ending inventory balance in part 1.