In: Accounting
Problem 6-2A Calculate ending inventory, cost of goods sold, sales revenue, and gross profit for four inventory methods (LO6-3, 6-4, 6-5)
[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 | $ | 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 each) | 12 | |||||||||||||
| March | 30 | Purchase | 9 | 300 | 2,700 | |||||||||||
| $ | 13,200 | |||||||||||||||
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: 04_13_2020_QC_CS-208026
2. Using FIFO, calculate ending inventory and
cost of goods sold at March 31.
  
| 
 Ending Inventory  | 
|
| 
 Cost of good sold  | 
3. Using LIFO, calculate ending inventory and
cost of goods sold at March 31.
  
| 
 Ending Inventory  | 
|
| 
 Cost of good sold  | 
4. Using weighted-average cost, calculate ending inventory and cost of goods sold at March 31. (Round your intermediate and final answers to 2 decimal places.)
| 
 Ending Inventory  | 
|
| 
 Cost of good sold  | 
5. Calculate sales revenue and gross profit under each of the four methods. (Round weighted-average cost amounts to 2 decimal places.)
| 
 Specific Identification  | 
 FIFO  | 
 LIFO  | 
 Weighted- Average cost  | 
|
| 
 Sales Revenue  | 
 $  | 
 $  | 
 $  | 
 $  | 
| 
 Gross profit  | 
 $  | 
 $  | 
 $  | 
 $  |