In: Accounting
Week 4 |
||||||||||||||||||||
Date |
Transaction description |
|||||||||||||||||||
22 |
Sold 90 Specialist Tennis Raquets to Jump Around for $408 each, Invoice No. 385. |
|||||||||||||||||||
25 |
The Locker Room paid the full amount owing on their account. |
|||||||||||||||||||
25 |
Paid sales staff wages of $2,037 for the week up to and including yesterday, Check No. 878. |
|||||||||||||||||||
25 |
Ordered 16 Specialist Tennis Raquets from Extreme Sports Inc for $280 each. Agreed terms with Extreme Sports Inc are 2/10, n/30. |
|||||||||||||||||||
27 |
Delivered 40 Quidditch Snitches to Balls 'n All for $752 each, Invoice No. 386. These items were ordered on the 19th. |
|||||||||||||||||||
27 |
Made cash sale of 60 pairs of Football Boots for $336 each. |
|||||||||||||||||||
28 |
Paid the full amount owing to Hike, Check No. 879. Payment fell outside discount period. |
|||||||||||||||||||
28 |
Returned 8 faulty sets of Sting Ray Golf Clubs, originally purchased for $376 each, to Sport Borders. Received a Credit Note for $3,008.
|
(Q=610-110-3.AcctsRec3_week4)
INVENTORY CARDS
Sets Of Sting Ray Golf Clubs
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
39 |
288 |
11232 |
|||||||
15 |
376 |
5640 |
|||||||||
Jun |
13 |
25 |
288 |
7200 |
14 |
288 |
4032 |
||||
15 |
376 |
5640 |
|||||||||
Jun |
15 |
13 |
376 |
4888 |
14 |
288 |
4032 |
||||
28 |
376 |
10528 |
|||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
(Q=630.Inventory3_week4)
Pairs Of Football Boots
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
75 |
192 |
14400 |
|||||||
Jun |
11 |
18 |
192 |
3456 |
57 |
192 |
10944 |
||||
Jun |
20 |
-8 |
192 |
-1536 |
65 |
192 |
12480 |
||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
(Q=630.Inventory4_week4)
Quidditch Snitches
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
33 |
360 |
11880 |
|||||||
19 |
416 |
7904 |
|||||||||
Jun |
17 |
3 |
360 |
1080 |
30 |
360 |
10800 |
||||
19 |
416 |
7904 |
|||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
(Q=630.Inventory5_week4)
Specialist Tennis Raquets
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
66 |
232 |
15312 |
|||||||
Jun |
9 |
14 |
232 |
3248 |
80 |
232 |
18560 |
||||
Jun |
17 |
11 |
280 |
3080 |
80 |
232 |
18560 |
||||
11 |
280 |
3080 |
|||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
The assumptions used in the question are we have used FIFO method as nothing is mentioned
Sets Of Sting Ray Golf Clubs
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
39 |
288 |
11232 |
|||||||
15 |
376 |
5640 |
|||||||||
Jun |
13 |
25 |
288 |
7200 |
14 |
288 |
4032 |
||||
15 |
376 |
5640 |
|||||||||
Jun |
15 |
13 |
376 |
4888 |
14 |
288 |
4032 |
||||
28 |
376 |
10528 |
|||||||||
Jun |
28 |
8 |
376 |
3008 |
14 |
288 |
4032 |
||||
20 |
376 |
7520 |
|||||||||
Jun |
29 |
14 |
288 |
4032 |
|||||||
17 |
376 |
4392 |
3 |
376 |
1128 |
(Q=630.Inventory3_week4)
Pairs Of Football Boots
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
75 |
192 |
14400 |
|||||||
Jun |
11 |
18 |
192 |
3456 |
57 |
192 |
10944 |
||||
Jun |
20 |
-8 |
192 |
-1536 |
65 |
192 |
12480 |
||||
Jun |
30 |
18 |
240 |
4320 |
65 |
192 |
12480 |
||||
18 |
240 |
4320 |
|||||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
(Q=630.Inventory4_week4)
Quidditch Snitches
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
33 |
360 |
11880 |
|||||||
19 |
416 |
7904 |
|||||||||
Jun |
17 |
3 |
360 |
1080 |
30 |
360 |
10800 |
||||
19 |
416 |
7904 |
|||||||||
Jun |
27 |
30 |
360 |
10,800 |
|||||||
10 |
416 |
4160 |
9 |
416 |
3744 |
||||||
Jun |
|||||||||||
Jun |
|||||||||||
Jun |
|||||||||||
(Q=630.Inventory5_week4)
Specialist Tennis Raquets
Date |
Purchases |
Cost of Goods Sold |
Balance |
||||||||
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
Units |
Unit Cost |
Total Cost |
|||
May |
31 |
66 |
232 |
15312 |
|||||||
Jun |
9 |
14 |
232 |
3248 |
80 |
232 |
18560 |
||||
Jun |
17 |
11 |
280 |
3080 |
80 |
232 |
18560 |
||||
11 |
280 |
3080 |
|||||||||
Jun |
22 |
80 |
232 |
18560 |
|||||||
10 |
280 |
2800 |
1 |
280 |
280 |
||||||
Jun |
29 |
16 |
280 |
4480 |
17 |
280 |
4760 |
||||
Jun |
|||||||||||