ACCOUNTING SPREADSHEET EXCEL CHART

danivic78
Chapter6B.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCOUNTING SPREADSHEET EXCEL CHART

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 Goods 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.
Apr. 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
cpence: Place the earliest units first, above the units that were received later.
10
19
28
June 5
16
21
28
Sales
30 Balances
cpence: Enter the total of column H, the total cost of merchandise sold.
cpence: Place the earliest units first, above the units that were received later.
cpence: Place the latest units first, above the units that were received earlier.
cpence: Enter the ending inventory balance.
cpence: Place the earliest units first, above the units that were received later.
cpence: Place the earliest units first, above the units that were received later.		 Accounts Receivable
Merchandise Inventory
Cost of Merchandise Sold
2.
Total sales
Total cost of goods sold
Gross profit
3.
Ending inventory cost
Mark Sears: This should equal the ending inventory balance in part 1.
cpence: Place the earliest units first, above the units that were received later.

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 Goods Sold Inventory
Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost Quantity Unit Cost Total Cost
Apr. 3 25 $1,200 $ 30,000
8 75 $1,240 $ 93,000 25 $1,200 $ 30,000
cpence: Place the earliest units first, above the units that were received later.
75 $1,240 93,000
11 40 $1,240 $ 49,600 25 $1,200 $ 30,000
cpence: Place the earliest units first, above the units that were received later.
35 $1,240 43,400
30 30 $1,240 $ 37,200 25 $1,200 $ 30,000
cpence: Place the earliest units first, above the units that were received later.
5 $1,240 6,200
May 8 60 $1,260 $ 75,600 25 $1,200 $ 30,000
cpence: Place the earliest units first, above the units that were received later.
5 $1,240 6,200
60 $1,260 75,600
10 50 $1,260 $ 63,000 25 $1,200 $ 30,000
cpence: Place the earliest units first, above the units that were received later.
5 $1,240 6,200
10 $1,260 12,600
19 10 $1,260 $ 12,600
cpence: Place the latest units first, above the units that were received earlier.
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
cpence: Enter the total of column H, the total cost of merchandise sold.
cpence: Place the earliest units first, above the units that were received later.
cpence: Place the latest units first, above the units that were received earlier.		 $ 31,560
cpence: Enter the ending inventory balance.

cpence: Place the earliest units first, above the units that were received later.
cpence: Place the earliest units first, above the units that were received later.		 2. Sales
Total sales $ 525,250 Accounts Receivable
Total cost of goods sold 312,080 Merchandise Inventory
Gross profit $ 213,170 Cost of Merchandise Sold
3.
Ending inventory cost $31,560
Mark Sears: This should equal the ending inventory balance in part 1.

cpence: Place the earliest units first, above the units that were received later.