Assuming that the periodic inventory method is used, compute the cost of goods sold and ending inventory under (1) LIFO and (2) FIFO. Please Show Work
| June 1 |
Balance |
299 units @ $11 | 10-Jun |
Sold |
197 units @ $27 | ||||
| 11 |
Purchased |
798 units @ $14 | 15-Jun | Sold | 503 units @ $29 | ||||
| 20 | Purchased | 502 units @ $15 | 27-Jun | Sold | 305 units @ $31 | ||||
| LIFO | |||||||||
| PURCHASES | COST OF GOODS SOLD | ENDING INVENTORY | |||||||
| Date | Units | Cost Per Unit | Total Cost | Units | Cost Per Unit | Total Cost | Units | Cost Per Unit | Total Cost |
| 1-Jun | 299 | $ 11.00 | $ 3,289.00 | $ - | 299 | $ 11.00 | $ 3,289.00 | ||
| 11-Jun | 798 | $ 14.00 | $ 11,172.00 | $ 14.00 | $ - | $ 14.00 | $ - | ||
| 20-Jun | 502 | $ 15.00 | $ 7,530.00 | 502 | $ 15.00 | $ 7,530.00 | $ - | ||
| Total | 1599 | $ 21,991.00 | 502 | $ 7,530.00 | 299 | $ 3,289.00 | |||
Correct Answer:
|
FIFO |
|||||||||
|
FIFO |
Cost of Goods Available for sale |
Cost of goods sold |
Ending Inventory |
||||||
|
No. of units |
Cost per unit |
Cost of goods available for sale |
No. of units |
Cost per unit |
Cost of goods sold |
No. of units |
Cost per unit |
Ending Inventory |
|
|
1-Jun |
299 |
$ 11 |
$ 3,289 |
299 |
$ 11 |
$ 3,289 |
0 |
$ 11 |
$ - |
|
Purchase |
|||||||||
|
11-Jun |
798 |
$ 14 |
$ 11,172 |
706 |
$ 14 |
$ 9,884 |
92 |
$ 14 |
$ 1,288 |
|
20-Jun |
502 |
$ 15 |
$ 7,530 |
$ 15 |
$ - |
502 |
$ 15 |
$ 7,530 |
|
|
Total |
1599 |
$ 21,991 |
1005 |
$ 13,173 |
594 |
$ 8,818 |
|
LIFO |
|||||||||
|
Cost of Goods Available for sale |
Cost of goods sold |
Ending Inventory |
|||||||
|
No. of units |
Cost per unit |
Cost of goods available for sale |
No. of units |
Cost per unit |
Cost of goods sold |
No. of units |
Cost per unit |
Ending Inventory |
|
|
1-Jun |
299.00 |
11.00 |
$ 3,289.00 |
$ 11 |
$ - |
299 |
$ 11 |
$ 3,289 |
|
|
Purchase |
0.00 |
||||||||
|
11-Jun |
798.00 |
14.00 |
$ 11,172.00 |
503 |
$ 14 |
$ 7,042 |
295 |
$ 14 |
$ 4,130 |
|
20-Jun |
502.00 |
15.00 |
$ 7,530.00 |
502 |
$ 15 |
$ 7,530 |
0 |
$ 15 |
$ - |
|
Total |
1599 |
$ 21,991.00 |
1005 |
$ 14,572 |
594 |
$ 7,419 |
End of Answer.
Please give a thumbs-up, it will be highly appreciated.
Thanks
Assuming that the periodic inventory method is used, compute the cost of goods sold and ending...
Inventory information for Part 311 of Concord Corp. discloses the following information for the month of June. June 1 Balance June 10 Sold 11 Purchased 299 units @ $11 798 units @ $14 502 units @ $15 15 Sold 197 units @ $27 503 units @ $29 305 units @ $31 20 Purchased 27 Sold Assuming that the periodic inventory method is used, compute the cost of goods sold and ending inventory under (1) LIFO and (2) FIFO. (1) LIFO...
Question 19 Inventory information for Part 311 of Concord Corp. discloses the following information for the month of June. June 1 11 20 Balance Purchased Purchased 299 units @ $11 798 units @ $14 502 units @ $15 June 10 15 27 Sold Sold Sold 197 units @ $27 503 units @ $29 305 units @ $31 Assuming that the periodic inventory method is used, compute the cost of goods sold and ending inventory under (1) LIFO and (2) FIFO....
C Inventory Information For Part 31 X C E8-13 (Fifo And Lifo - Periodi A X C Inventory Information For Part 31 x + wileyplus.com/courses/22841/assignments/2747360 Inventory information for Part 311 of Concord Corp discloses the following information for the month of June. June 1 11 20 Balance 299 units @ $11 Purchased 798 units@$14 Purchased 502 units @ $15 June 10 15 27 Sold Sold Sold 197 units @ $27 503 units @ $29 305 units @ $31 Your Answer...
1) Presented below is information related to Skysong Company. Date Ending Inventory (End-of-Year Prices) Price Index December 31, 2017 $ 87,400 100 December 31, 2018 152,755 137 December 31, 2019 148,824 156 December 31, 2020 168,493 169 December 31, 2021 200,018 182 December 31, 2022 238,140 189 Compute the ending inventory for Skysong Company for 2017 through 2022 using the dollar-value LIFO method. Ending Inventory 2017 $enter a dollar amount 87,400 2018 $enter a dollar amount 2019 $enter a dollar...
need help with findinf perpetural
method for both LIFO and FIFO
CALCULATOR Exercise 8-10 (Part Level Submission) Inventory information for Part 311 of Flounder Corp. discloses the following information for the month of June. June 1 Balance 299 units @ $11 June 10 Sold 197 units@ $27 Purchased 798 units $14 11 15 Sold 503 units $29 20 Purchased 502 units@$15 27 Sold 305 units@ $31 (a) Your answer is correct. Assuming that the periodic inventory method is used, compute...
I also need the ending inventory
and costs of goods sold for periodic LIFO and periodic weighted
average - Thank you!
в D E F G H I J K L M N O P Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO and Weighted Average Cost methods. Make use of Excel capabilities by using as many formulas and functions as possible. Better Bottles, Inc. uses a periodic inventory system and has the following...
1. Complete the table to determine the cost
assigned to ending inventory and cost of goods sold using specific
identification.
2. Determine the cost assigned to ending inventory
and to cost of goods sold using weighted average.
3. Determine the cost assigned to ending inventory
and to cost of goods sold using FIFO.
4. Determine the cost assigned to ending inventory
and to cost of goods sold using LIFO.
Laker Company reported the following January purchases and sales data for...
calculate the cost of goods
available for sale, ending inventory, and cost of goods sold if
Aircarf uses (a) FIFO, (b) LIFO, or (c) weighted average
cost.
Aircard Corporation tracks the number of units purchased and sold throughout each accounting period but applies its inventory costing method at the end of each period as if it uses a periodic inventory system. The following are the transactions for the month of July Units Unit Cost July 1 July 5 July 13...
E6A-26 Comparing ending merchandise inventory, cost of goods sold, and gross profit using the periodic inventory system-FIFO, LIFO, and weighted-average methods Assume that Jump Coffee Shop completed the following periodic inventory trans actions for a line of merchandise inventory: g Objective 7 Appendix 6A 2. COGS $513 53A G03 Jun. 1 Beginning merchandise inventory 17 units @ $ 15 each 12 Purchase 5 units @$19 each 20 Sale TO 14 units @$37 each 24 Purchase 11 units @ $ 23...
E6A-26 Comparing ending merchandise inventory, cost of goods sold, and gross profit using the periodic inventory system-FIFO, Lino weighted average methods Assume that Jump Coffee Shop completed the following periodic inventory transac for a line of merchandise inventory: Jun. 1 Beginning merchandise inventory 17 units @ $ 15 each 12 Purchase 5 units @ $ 19 each 20 Sale 14 units @ $ 37 each 24 Purchase 11 units @ $ 23 each 513 29 Sale 13 units @ $...