Pillsbury Company\'s record of transactions concerning the month of September we
ID: 2466589 • Letter: P
Question
Pillsbury Company's record of transactions concerning the month of September were as follows: Compute the inventory at September 30 on each of the following bases. Assume that the company used the periodic method to report its inventory. Carry unit costs to the nearest cent. First-in, first-out (FIFO). Last-in, first-out (LIFO). Average cost. Repeat your calculations in (1), (2), and (3) above, under the assumption that the company used the perpetual method to report its inventory. Carry average unit costs to at least two decimal places.Explanation / Answer
FIFO
Receipts
Issues
Balance
Date
Description
Qty
Rate
Amount
Qty
Rate
Amount
Qty
Rate
Amount
1-Sep
Beg Inventory
300
12.00
3,600
300
12.00
3,600
3-Sep
Purchases
200
12.10
2,420
200
12.10
2,420
4-Sep
Sales
300
12.00
3,600
100
12.10
1,210
100
12.10
1,210
12-Sep
Purchases
300
12.25
3,675
300
12.25
3,675
16-Sep
Purchases
300
12.30
3,690
300
12.30
3,690
17-Sep
Sales
100
12.10
1,210
300
12.25
3,675
200
12.30
2,460
100
12.30
1,230
22-Sep
Purchases
500
12.30
6,150
-
-
500
12.30
6,150
26-Sep
Purchases
300
12.40
3,720
300
12.40
3,720
27-Sep
Sales
100
12.30
1,230
200
12.30
2,460
30-Sep
200
12.30
2,460
100
12.30
1,230
300
12.40
3,720
1,900
23,255
1,500
18,305
400
4,950
LIFO
Receipts
Issues
Balance
Date
Description
Qty
Rate
Amount
Qty
Rate
Amount
Qty
Rate
Amount
1-Sep
Beg Inventory
300
12.00
3,600
3-Sep
Purchases
200
12.10
2,420
4-Sep
Sales
200
12.10
2,420
200
12.00
2,400
100
12.00
1,200
12-Sep
Purchases
300
12.25
3,675
300
12.25
3,675
16-Sep
Purchases
300
12.30
3,690
300
12.30
3,690
17-Sep
Sales
300
12.30
3,690
-
300
12.25
3,675
100
12
1,200
22-Sep
Purchases
500
12.30
6,150
500
12.30
6,150
26-Sep
Purchases
300
12.40
3,720
300
12.40
3,720
27-Sep
Sales
300
12.40
3,720
30-Sep
200
12.30
2,460
300
12.30
3,690
100
12.00
1,200
1,900
23,255
1,500
18,365
400
4,890
Average Cost
Receipts
Issues
Balance
Date
Description
Qty
Rate
Amount
Qty
Rate
Amount
Qty
Rate
Amount
1-Sep
Beg Inventory
300
12.00
3,600
3-Sep
Purchases
200
12.10
2,420
500
12.04
6,020
4-Sep
Sales
400
12.04
4,816
100
12.04
1,204
12-Sep
Purchases
300
12.25
3,675
700
12.24
8,569
16-Sep
Purchases
300
12.30
3,690
17-Sep
Sales
600
12.24
7,345
100
12.24
1,224
22-Sep
Purchases
500
12.30
6,150
900
12.33
11,094
26-Sep
Purchases
300
12.40
3,720
27-Sep
Sales
300
12.33
3,698
600
12.33
7,396
30-Sep
200
12.33
2,465
400
12.33
4,931
1,900
23,255
1,500
18,324
400
12.33
4,931
FIFO
Receipts
Issues
Balance
Date
Description
Qty
Rate
Amount
Qty
Rate
Amount
Qty
Rate
Amount
1-Sep
Beg Inventory
300
12.00
3,600
300
12.00
3,600
3-Sep
Purchases
200
12.10
2,420
200
12.10
2,420
4-Sep
Sales
300
12.00
3,600
100
12.10
1,210
100
12.10
1,210
12-Sep
Purchases
300
12.25
3,675
300
12.25
3,675
16-Sep
Purchases
300
12.30
3,690
300
12.30
3,690
17-Sep
Sales
100
12.10
1,210
300
12.25
3,675
200
12.30
2,460
100
12.30
1,230
22-Sep
Purchases
500
12.30
6,150
-
-
500
12.30
6,150
26-Sep
Purchases
300
12.40
3,720
300
12.40
3,720
27-Sep
Sales
100
12.30
1,230
200
12.30
2,460
30-Sep
200
12.30
2,460
100
12.30
1,230
300
12.40
3,720
1,900
23,255
1,500
18,305
400
4,950