Question

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 $230 $4,600
March 5 Sale ($360 each) 15
March 9 Purchase 10 250 2,500
March 17 Sale ($410 each) 8
March 22 Purchase 10 260 2,600
March 27 Sale ($435 each) 12
March 30 Purchase 8 280 2,240

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.

Required:
a. Calculate ending inventory and cost of goods sold at March 31, 2015, using 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.
b. Using FIFO, calculate ending inventory and cost of goods sold at March 31, 2015.
c. Using LIFO, calculate ending inventory and cost of goods sold at March 31, 2015.
d. Using weighted-average cost, calculate ending inventory and cost of goods sold at March 31, 2015.(Round your intermediate and final answers to 2 decimal places.)
e. Calculate sales revenue and gross profit under each of the four methods.

Answer 1

Answer:

Greg's Bicycle Shop

Ending Inventory:

a. Specific Identification:

Beginning inventory 1 * $230 = $230

March 9 purchase  2 *  $250 =  500

March 22 purchase 2 * $260 = 520

March 30   Purchase 8 * $280 =2,240

Total value of inventory 13 units = $3,490

Cost of goods sold = Cost of goods available for sale Minus Ending Inventory

= $11,940 - $3,490

= $8,450

b. FIFO:

March 22   Purchase     5   260     1,300

March 30   Purchase     8   280    2,240

Ending Inventory          13           $3,540

Cost of goods sold = Goods available for sale Minus Ending Inventory

= $11,940 - $3,540

= $8,400

c. LIFO:

Ending Inventory:

March 1  Inventory     13    $230         $2,990

Cost of goods sold = Goods available for sale Minus Ending Inventory

= $11,940 - $2,990

= $8,950

d) Weighted -Average Cost:

Ending Inventory = $248.75 * 13 = $3,233.75

Cost of Goods Sold = $248.75 * 35 = $8,706.25

                                      Specific          FIFO         LIFO         Weighted

                                Identification                                           Average

Sales                           $13,900       $13,900      $13,900       $13,900.00

Cost of goods sold        8,450           8,400         8,950         $8,706.25

Gross profit                 $5,450         $5,500      $4,950          $5,193.75

Explanation:

Dat and Calculations:

Shop uses periodic inventory system

Date           Transactions               Units      Unit Cost    Total Cost   Total

March 1      Beginning inventory     20          $230         $4,600       Sales

March 5     Sale ($360 each)                   15   $360                          $5,400

March 9     Purchase                       10            250           2,500

March 17    Sale ($410 each)                   8     $410                           $3,280

March 22   Purchase                      10            260           2,600

March 27   Sale ($435 each)                12     $435                         $5,220

March 30   Purchase                      8             280           2,240

Total Goods available for sale     48   35                     $11,940   $13,900

Ending Inventory = 13 (48 - 35)

Weighted average cost = Cost of goods available for sale/Units of Goods available for sale

= $11,940/48 = $248.75

Specific Identification:

March 5 sale 15 consists of bikes from 15 beginning inventory Bal 5 - 4 = 1

March 17 sale 8 consists of bikes from the March 9 purchase  Bal  = 2

March 27 sale 12 consists of four bikes from beginning inventory and eight bikes from the March 22 purchase Bal  = 2

Ending Inventory:

Specific Identification:

Beginning inventory 1 * $230 = $230

March 9 purchase  2 *  $250 =  500

March 22 purchase 2 * $260 = 520

March 30   Purchase 8 * $280 =2,240

Total value of inventory 13 units = $3,490

FIFO:

March 22   Purchase     5   260     1,300

March 30   Purchase     8   280    2,240

Ending Inventory          13           $3,540

LIFO:

March 1      Beginning inventory     13    $230         $2,990

Weighted-Average Costs:

Ending Inventory = $248.75 * 13 = $3,233.75

Cost of Goods Sold = $248.75 * 35 = $8,706.25