Question

In: Accounting

rmation applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions related to...

rmation applies to the questions displayed below.]

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 $ 235 $ 4,700
March 5 Sale ($370 each) 15
March 9 Purchase 10 255 2,550
March 17 Sale ($420 each) 8
March 22 Purchase 10 265 2,650
March 27 Sale ($445 each) 12
March 30 Purchase 9 285 2,565
$ 12,465

For the specific identification method, the March 5 sale consists of bikes from beginning inventory, the March 17 sale consists of bikes from the March 9 purchase, and the March 27 sale consists of four bikes from beginning inventory and eight bikes from the March 22 purchase.

rev: 02_28_2017_QC_CS-80932, 04_13_2020_QC_CS-208026

Problem 6-2A Part 1

Required:

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

.

Solutions

Expert Solution

Details Units Unit cost Total Cost
Opening Balance March 1. 20 $        235.00 $             4,700.00
Add: March 9 purchase 10 $        255.00 $             2,550.00
Add:March 22 Purchase 10 $        265.00 $             2,650.00
Add: March 30 purchase 9 $        285.00 $             2,565.00
A Total Goods Available for sale 49 $          12,465.00
Less : Sale
March 5 sales from opening inventory 15 $        235.00 $             3,525.00
March 17 sale from purchase of March 9 8 $        255.00 $             2,040.00
March 27 sale from opening inventory 4 $        235.00 $                940.00
March 27 sale from Mar 22 purchase 8 $        265.00 $             2,120.00
B Total Sales & Cost of Goods Sold 35 $            8,625.00
Ending Inventory=A-B 14 $             3,840.00
So Ending Inventory on March 31 = $            3,840.00
Cost of Goods Sold of March = $            8,625.00

Related Solutions

[The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions...
[The following information applies to the questions displayed below.] 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    $160       $ 3,200        March 5 Sale ($220 each) 15      March 9 Purchase 10    180       1,800        March 17 Sale ($270 each) 8      March 22 Purchase 10...
[The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the following transactions...
[The following information applies to the questions displayed below.] 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    $215       $ 4,300        March 5 Sale ($330 each) 15      March 9 Purchase 10    235       2,350        March 17 Sale ($380 each) 8      March 22 Purchase 10...
Required information [The following information applies to the questions displayed below.] Greg’s Bicycle Shop has the...
Required information [The following information applies to the questions displayed below.] 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 200 2,000 March 17 Sale ($310 each) 8 March 22 Purchase 10 210 2,100 March 27...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT