Question

In: Accounting

The following data regarding purchases and sales of a commodity were taken from the related perpetual...

The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account:

June 1 Balance 25 units at $60
6 Sale 20 units
8 Purchase 20 units at $61
16 Sale 10 units
20 Purchase 20 units at $62
23 Sale 25 units
30 Purchase 15 units at $63

Calculate the cost of the ending inventory at June 30, using (a) the first-in, first-out (FIFO) method and (b) the last-in, first-out (LIFO) method. Identify the quantity, unit price, and total cost of each lot in the inventory.

(a) First-In, First-Out (FIFO):

units at $ $
units at $
Total $

(b) Last-In, First-Out (LIFO):

units at $ $
units at $
units at $
Total $

Solutions

Expert Solution

Determine the cost of the inventory balance at June 30


(a) the first-in, first-out method


June 1 Balance 25 Units at $60
6 Sale 20 Units (COGS 20 x $60 = $1200)
Bal. inventory 5 units at $60
8 Purchase 20 units at $61
16 Sale 10 Units (COGS 5 units x $60 + 5 units x $61 = $605)
Bal. inventory 15 units at $61
20 Purchase 20 Units at $62
23 Sale 25 Units (COGS 15 units x $61 + 10 units at $62 = $1535)
Bal. inventory 10 units at $62
30 Purchase 15 Units at $63
Bal. inventory 10 units at $62 + 15 units x $63 = $1007 at June 31

(b) the last-in, first-out method

June 1 Balance 25 Units at $60
6 Sale 20 Units (COGS 20 x $60 = $1200)
Bal. inventory 5 units at $60
8 Purchase 20 units at $61
16 Sale 10 Units (COGS 10 units x $61 = $610)
Bal. inventory 5 units at $60 + 10 units at $61
20 Purchase 20 Units at $62
23 Sale 25 Units (COGS 20 units x $62 + 5 units at $61 = $1545)
Bal. inventory 5 units at $60
30 Purchase 15 Units at $63
Bal. inventory 5 units at $60 + 5 units at $61 + 15 units at $63 = $1550 at June 30


Related Solutions

The following data regarding purchases and sales of a commodity were taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: (30 points) June 1 Balance 25 units at $60         6 Sale 20 units at $70         8 Purchase 20 units at $61        16 Sale 10 units at $70        20 Purchase 20 units at $62        23 Sale 25 units at $70        30 Purchase 15 units at $63 ​ Record the inventory, purchases, cost of goods sold and sales...
The following data regarding purchases and sales of a commodity were taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: (30 points) June 1 Balance 25 units at $60 6 Sale 20 units at $70 8 Purchase 20 units at $61 16 Sale 10 units at $70 20 Purchase 20 units at $62 23 Sale 25 units at $70 30 Purchase 15 units at $63 ​ Record the inventory, purchases, cost of goods sold and sales in a perpetual inventory record similar...
The following data regarding purchases and sales of a commodity were taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: (30 points) June 1 Balance 25 units at $60 6 Sale 20 units at $70 8 Purchase 20 units at $61 16 Sale 10 units at $70 20 Purchase 20 units at $62 23 Sale 25 units at $70 30 Purchase 15 units at $63 ​ Record the inventory, purchases, cost of goods sold and sales in a perpetual inventory record similar...
The following data regarding purchases and sales of a commodity were taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: June 1 Balance 25 units at $60 6 Sale 20 units 8 Purchase 20 units at $61 16 Sale 10 units 20 Purchase 20 units at $62 23 Sale 25 units 30 Purchase 15 units at $63 Calculate the cost of the ending inventory at June 30, using (a) the first-in, first-out (FIFO) method and (b) the last-in, first-out (LIFO) method. Identify...
The following data regarding purchases and sales of a commodity were taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account: June 1 Balance 25 units at $60 6 Sale 20 units 8 Purchase 20 units at $61 16 Sale 10 units 20 Purchase 20 units at $62 23 Sale 25 units 30 Purchase 15 units at $63 Calculate the cost of the ending inventory at June 30, using (a) the first-in, first-out (FIFO) method and (b) the last-in, first-out (LIFO) method. Identify...
The following data regarding purchases and sales of a commoditywere taken from the related perpetual...
The following data regarding purchases and sales of a commodity were taken from the related perpetual inventory account:June 1Balance25 units at $606Sale20 units8Purchase20 units at $6116Sale10 units20Purchase20 units at $6223Sale25 units30Purchase15 units at $63Calculate the cost of the ending inventory at June 30, using (a) the first-in, first-out (FIFO) method and (b) the last-in, first-out (LIFO) method. Identify the quantity, unit price, and total cost of each lot in the inventory.(a) First-In, First-Out (FIFO):Date: JuneQuantityUnit PriceTotal costunits at$$units at$BLANKTotal$(b) Last-In,...
Beginning inventory, purchases, and sales data on Commodity A, as taken from Rich Company’s perpetual inventory...
Beginning inventory, purchases, and sales data on Commodity A, as taken from Rich Company’s perpetual inventory account, were as follows: July 1 Beginning inventory                              5 units @4 =$20                                                                               15 units $5 =$75         6 SALE                                                          16 UNITS         10 PURCHASE                                             15 UNITS @$6         20 SALE                                                        11 UNITS         30 PURCHASE                                             10 UNITS @$7         31 SALE                                                         7 UNITS Determine the cost of the ending inventory at JULY 31, by: (a) the first- in-first- out method, and (b) the last-in- first- out method.
5. The data regarding purchases and sales of a commodity is given in the table below:...
5. The data regarding purchases and sales of a commodity is given in the table below: Date Description Units Unit Cost May/01 Inventory 25 $40 May/06 Sale 20 $50 May/08 Purchase 20 $41 May/16 Sale 10 $55 May/20 Purchase 20 $42 May/23 Sale 25 $55 May/30 Purchase 15 43 Instructions: Determine the cost of the inventory balance at May/31, using the FIFO and LIFO Perpetual. Determine the cost of the inventory balance at May/31 using the Average Cost periodic method....
Sales-Related and Purchase-Related Transactions Using Perpetual Inventory System The following were selected from among the transactions...
Sales-Related and Purchase-Related Transactions Using Perpetual Inventory System The following were selected from among the transactions completed by Babcock Company during November of the current year: Nov. 3. Purchased merchandise on account from Moonlight Co., list price $82,000, trade discount 25%, terms FOB destination, 2/10, n/30. 4. Sold merchandise for cash, $40,180. The cost of the goods sold was $22,910. 5. Purchased merchandise on account from Papoose Creek Co., $50,750, terms FOB shipping point, 2/10, n/30, with prepaid freight of...
Sales-Related and Purchase-Related Transactions Using Perpetual Inventory System The following were selected from among the transactions...
Sales-Related and Purchase-Related Transactions Using Perpetual Inventory System The following were selected from among the transactions completed by Babcock Company during November of the current year: Nov. 3. Purchased merchandise on account from Moonlight Co., list price $91,000, trade discount 20%, terms FOB destination, 2/10, n/30. 4. Sold merchandise for cash, $36,270. The cost of the goods sold was $23,850. 5. Purchased merchandise on account from Papoose Creek Co., $50,600, terms FOB shipping point, 2/10, n/30, with prepaid freight of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT