Q15E_1

Question

Question: Super Mart, a regional convenience store chain, maintains milk inventory by the gallon.

The first month’s milk purchases and sales at its Freeport, Florida, location follow:

Nov. 2 Purchased 11 gallons @ \(2.15 each

6 Purchased 2 gallons @ \)2.80 each

8 Sold 6 gallons of milk to a customer

13 Purchased 3 gallons @ $2.85 each

14 Sold 4 gallons of milk to a customer

Requirements

1. Determine the amount that would be reported in ending merchandise inventoryon November 15 using the FIFO inventory costing method.

 

Step-by-Step Solution

Verified
Answer

The ending inventory on Nov.15 amounts to $16.3.

1Step-by-Step-Solution Step1: Perpetual Inventory FIFO Method

The Perpetual Inventory method is a system of maintaining inventory records continuously after every purchase and sale. FIFO is a method of allocating cost based on issuing assumption of first in first out. 

So perpetual inventory under the FIFO method maintains the continuous record of inventory based on the first in first out assumption.

2Step 2: Calculation of ending inventory

Date

Purchase/opening

Sales

Balance

 

Units

Cost per unit

Amount

Units

Cost per unit

Amount

Units

Cost per unit

Amount

 

 

 

 

 

 

 

 

 

 

Nov 2

11

$2.15

$23.65

 

 

 

11

$2.15

$23.65

       6

2

$2.80

$5.6

 

 

 

11

2

$2.15

$2.80

$29.25

       8

 

 

 

6

$2.15

$12.9

5

2

$2.15

$2.80

$16.55

     13

3

$2.85

$8.55

 

 

 

5

2

3

$2.15

$2.80

$2.85

$24.9

     14

 

 

 

4

$2.15

$8.6

1

2

3

$2.15

$2.80

$2.85

$16.3