Question

In: Accounting

The inventory data for an item for November are: Nov. 1 Inventory 23 units at $24...

The inventory data for an item for November are:

Nov. 1

Inventory

23 units at $24

4

Sold

8 units

10

Purchased

34 units at $20

17

Sold

19 units

30

Purchased

21 units at $25

Using a perpetual system, what is the cost of the goods sold for November if the company uses LIFO?

Solutions

Expert Solution

Cost of Goods Sold
Qty Rate Amt
4-Nov 8 $              24 $    192
17-Nov 19 $              20 $    380
Total 27 $    572

Working

Inward Outward Balance
Date Particulars Qty Rate Amt Qty Rate Amt Qty Rate Amt
1-Nov Balance 23 $     24 $    552
4-Nov Sale 8 $    24 $ 192 15 $     24 $    360
10-Nov Purchase 34 $    20 $ 680 15 $     24 $    360
34 $     20 $    680
17-Nov Sale 19 $    20 $ 380 15 $     24 $    360
15 $     20 $    300
30-Nov Purchase 21 $    25 $ 525 15 $     24 $    360
15 $     20 $    300
21 $     25 $    525

Related Solutions

The inventory data for an item for November are: Nov. 1 Inventory 20 units at $19...
The inventory data for an item for November are: Nov. 1 Inventory 20 units at $19 4 Sold 10 units 10 Purchased 30 units at $20 17 Sold 20 units 30 Purchased 10 units at $22 Using a perpetual system, what is the cost of the goods sold for November if the company uses the weighted average cost method? a. $590 b. $610 c. $585 d. $575
Assume the following data for Kruger Sales for November 2013: Beginning inventory Nov. 15 units at...
Assume the following data for Kruger Sales for November 2013: Beginning inventory Nov. 15 units at $90 each Sale Nov. 33 units Nov. 6 purchase11 units at $95 each Sale Nov. 84 units Sale Nov. 93 units Requirement 1: calculate ending inventory and COGS for Kruger Sales assuming FIFO Requirement 2: calculate ending inventory and COGS for Kruger Sales assuming Weighted Average
The following units of an item were available for sale during the year: Beginning inventory 23...
The following units of an item were available for sale during the year: Beginning inventory 23 units at $40 Sale 20 units at $60 First purchase 20 units at $41 Sale 5 units at $60 Second purchase 26 units at $43 Sale 18 units at $62 The firm uses the perpetual inventory system, and there are 26 units of the item on hand at the end of the year. a. What is the total cost of the ending inventory according...
Beginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units...
Beginning inventory, purchases and sales data for T-shirts are as follows: April 3 Inventory 24 units @ $10 11 Purchase 26 units @ $12 14 Sale 36 units 21 Purchase 18 units @ $15 25 Sale 20 units Assuming the business maintains a periodic inventory system; calculate the cost of merchandise sold and ending inventory under the following assumptions: FIFO LIFO Average cost In your computations, round the average cost per unit to two decimal places and round your final...
Beginning inventory, purchases, and sales for Item Gidget are as follows: Sept. 1 Inventory 80 units...
Beginning inventory, purchases, and sales for Item Gidget are as follows: Sept. 1 Inventory 80 units at $175 10 Sale 65 units 18 Purchase 75 units at $180 27 Sale 70 units Assuming a perpetual inventory system and using the last-in, first-out (LIFO) method, determine (a) the cost of merchandise sold on September 27 and (b) the inventory on September 30. a. Cost of merchandise sold on September 27 $ b. Inventory on September 30 $
Beginning inventory, purchases, and sales for Item ER27 are as follows: July 1 Inventory 42 units...
Beginning inventory, purchases, and sales for Item ER27 are as follows: July 1 Inventory 42 units @ $22 9 Sale 34 units 13 Purchase 40 units @ $24 28 Sale 16 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on July 28 and (b) the inventory on July 31. a. Cost of merchandise sold on July 28 $ b. Inventory on July 31 Beginning inventory, purchases, and sales...
Bailer Company's record of transactions for the month of November was the following: Purchases: Nov 1....
Bailer Company's record of transactions for the month of November was the following: Purchases: Nov 1. 525 @ $7.00 5 1400 @ $7.20 8 750 @ $7.35 14 1,250 @ $7.42 21 825 @ $7.55 29 610 @ $7.80 Total units sold :  5,360 Sales Nov 6. 550 @ $10 9 1,320 @ $10 10 625 @ 12 22 1,100 @ 12 28 850 @ 13 #1 - Assume periodic inventory records are kept in units only. Compute the inventory on...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1 310 units @ $6.00 Purchase, January 9 870 units @ $6.50 Purchase, January 19 210 units @ $7.00 Inventory, January 31 310 units What value should be assigned to cost of goods sold using LIFO?
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1...
The Ivanhoe Shop shows the following data related to an item of inventory: Inventory, January 1 310 units @ $6.00 Purchase, January 9 870 units @ $6.50 Purchase, January 19 210 units @ $7.00 Inventory, January 31 310 units (a) What value should be assigned to the ending inventory using FIFO? Value assigned to the ending inventory $
Make a histogram of the following data {21, 22, 23, 24, 24, 24, 25, 25, 25,...
Make a histogram of the following data {21, 22, 23, 24, 24, 24, 25, 25, 25, 26, 27, 32, 34} The shape of the distribution is ___________________________________________________ Use your calculator to compute the mean of the data: __________________________________ Use your calculator to compute the standard deviation of the data ________________________ Give the five-number summary for this data: Item Value Draw the complete box-plot (including fences and outliers). Provide an accurate scale.                                                                                                              ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT