Question

In: Accounting

Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the...

Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system.

Date Transactions Units Unit Cost Total Cost
August 1 Beginning inventory 8 $ 155 $ 1,240
August 4 Sale ($200 each) 5
August 11 Purchase 10 145 1,450
August 13 Sale ($215 each) 8
August 20 Purchase 10 135 1,350
August 26 Sale ($225 each) 11
August 29 Purchase 10 125 1,250
$ 5,290

For the specific identification method, the August 4 sale consists of rackets from beginning inventory, the August 13 sale consists of rackets from the August 11 purchase, and the August 26 sale consists of one racket from beginning inventory and 10 rackets from the August 20 purchase.


1. Calculate ending inventory and cost of goods sold at August 31, using the specific identification method.

  

Solutions

Expert Solution

  • Requirement asked

Specific Identification

Cost of Goods available for sale

Cost of Goods Sold

Ending Inventory

Units

Cost/unit

COG for sale

Units sold

Cost/unit

COGS

Units

Cost/unit

Ending inventory

Beginning Inventory

8

$              155.00

$                        1,240.00

6

$             155.00

$                     930.00

2

$              155.00

$                310.00

Purchases:

11-Aug

10

$              145.00

$                        1,450.00

8

$             145.00

$                 1,160.00

2

$              145.00

$                290.00

20-Aug

10

$              135.00

$                        1,350.00

10

$             135.00

$                 1,350.00

0

$              135.00

$                         -  

29-Aug

10

$              125.00

$                        1,250.00

0

$             125.00

$                              -  

10

$              125.00

$            1,250.00

TOTAL

38

$                        5,290.00

24

$                 3,440.00

14

$            1,850.00

  • Cost of Goods Sold = $ 3440
  • Ending Inventory = $ 1850

Related Solutions

Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the...
Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 141 $ 1,128 August 4 Sale ($130 each) 5 August 11 Purchase 10 131 1,310 August 13 Sale ($145 each) 8 August 20 Purchase 10 121 1,210 August 26 Sale ($155 each) 11 August 29 Purchase 11 111 1,221 $...
Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the...
Pete’s Tennis Shop has the following transactions related to its top-selling Wilson tennis racket for the month of August. Pete’s Tennis Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost August 1 Beginning inventory 8 $ 145 $ 1,160 August 4 Sale ($150 each) 5 August 11 Purchase 10 135 1,350 August 13 Sale ($165 each) 8 August 20 Purchase 10 125 1,250 August 26 Sale ($175 each) 11 August 29 Purchase 12 115 1,380 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 245 $ 4,900 March 5 Sale ($390 each) 15 March 9 Purchase 10 265 2,650 March 17 Sale ($440 each) 8 March 22 Purchase 10 275 2,750 March 27 Sale ($465 each) 12 March 30 Purchase 8 295 2,360 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 190 $ 3,800 March 5 Sale ($280 each) 15 March 9 Purchase 10 210 2,100 March 17 Sale ($330 each) 8 March 22 Purchase 10 220 2,200 March 27 Sale ($355 each) 12 March 30 Purchase 8 240 1,920 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 175 $ 3,500 March 5 Sale ($250 each) 15 March 9 Purchase 10 195 1,950 March 17 Sale ($300 each) 8 March 22 Purchase 10 205 2,050 March 27 Sale ($325 each) 12 March 30 Purchase 8 225 1,800 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 195 $ 3,900 March 5 Sale ($290 each) 15 March 9 Purchase 10 215 2,150 March 17 Sale ($340 each) 8 March 22 Purchase 10 225 2,250 March 27 Sale ($365 each) 12 March 30 Purchase 7 245 1,715 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 225 $ 4,500 March 5 Sale ($350 each) 15 March 9 Purchase 10 245 2,450 March 17 Sale ($400 each) 8 March 22 Purchase 10 255 2,550 March 27 Sale ($425 each) 12 March 30 Purchase 7 275 1,925 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date Transactions Units Unit Cost Total Cost March 1 Beginning inventory 20 $ 170 $ 3,400 March 5 Sale ($240 each) 15 March 9 Purchase 10 190 1,900 March 17 Sale ($290 each) 8 March 22 Purchase 10 200 2,000 March 27 Sale ($315 each) 12 March 30 Purchase 9 220 1,980 $...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system.   Date Transactions Units Cost per Unit Total Cost   March 1 Beginning inventory 20    $250       $ 5,000        March 5 Sale ($400 each) 15      March 9 Purchase 10    270       2,700        March 17 Sale ($450 each) 8      March 22 Purchase 10    280       2,800        March 27 Sale ($475...
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March.
Greg’s Bicycle Shop has the following transactions related to its top-selling Mongoose mountain bike for the month of March. Greg's Bicycle Shop uses a periodic inventory system. Date   Transactions Units   Unit Cost   Total Cost March 1   Beginning inventory   20     $ 180       $ 3,600     March 5   Sale ($260 each)   15                       March 9   Purchase   10...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT