| Purchase | Cost of goods sold | Ending inventory | |||||||
| Date | # of unit | cost per unit | Total Cost | # of unit | Cost per unit | Total Cost | # of unit | Cost per unit | Total cost |
| May 1 | 400 | 5.10 | 2040 | ||||||
| May 3 | 200 | 5.1 | 1020 | 200 | 5.1 | 1020 | |||
| May 4 | 1400 | 5.20 | 7280 |
200 1400 |
5.1 5.2 |
1020 7280 |
|||
| May 6 | 1000 | 5.2 | 5200 |
200 400 |
5.1 5.2 |
1020 2080 |
|||
| May 8 | 600 | 5.30 | 3180 |
200 400 600 |
5.1 5.2 5.3 |
1020 2080 3180 |
|||
| May 12 | 500 | 5.3 | 2650 |
200 400 100 |
5.1 5.2 5.3 |
1020 2080 530 |
|||
| Total | 8870 | ||||||||
Cost of goods sold under LIFO = $8870
assuming that a perpetual inventory system is used compute the cost of good sold for the...
(1 points) A record of transactions for the month of May was as follows: Purchases Sales May 1 (balance) 200 May 3 4 400 @ $5.10 1,400 @ $5.20 600 @ $5.30 1,000 500 1) Assuming that a periodic inventory system is used, compute the End dollars for the month of May using FIFO. stem is used, compute the Ending Inventory balance in
Sales May 1 Purchases (balance) 400 @ $5.10 1,400 @ $5.20 600 @ $5.30 May 3 200 1,000 500 1 A tary balance in sold for the Assuming that a periodic inventory system and p ut the cost of Goo month of May using the Average Cost method (Round to 2 decimal places
Perpetual LIFO. A record of transactions for the month of May was as follows: Purchases May 1 (balance) 400 @ $4.20 May 3 1,300 @ $4.10 6 800 @$4.30 12 700 @ $4.40 1,200 @ $4.50 500 @ $4.55 Sales 200 @ $7.00 1,000 @ 7.00 900 @ 7.50 400 @ 7.50 1,400 @ 8.00 18 Assuming that perpetual inventory records are kept in dollars, determine the ending inventory using LIFO.
Calculate the cost of goods available for sale, cost of goods
sold and ending inventory in both units and dollars using the
perpetual moving average method.
P8.4 (LO 3) Excel (Compute FIFO, LIFO, and Average-Cost) Hull Company's record of trans actions concerning part X for the month of April was as follows. Purchases Sales April 1 (balance on hand) 100 @ $5.00 April 5 400 @ 5.10 300 @ 5.30 200 @ 5.35 600 @ 5.60 200 @ 5.80 18...
METHOD PERPETUAL
P8.4 (LO 3) Excel (Compute FIFO, LIFO, and Average-Cost) Hull Company's record of trans- actions concerning part X for the month of April was as follows. Purchases Sales April 1 (balance on hand) 100 @ $5.00 April 5 300 4 400 @ 5.10 12 200 11 300 @ 5.30 27 800 18 200 @ 5.35 28 150 26 600 @ 5.60 30 200 @ 5.80 Instructions a. Compute the inventory at April 30 on each of the following...
lu Tepl D U 36 .P8-7 (Compute FIFO, LIFO, and Average-Cost) Ronaldo Company's record of transactions part VF5 for the month of September was as follows. Purchases Sales September 1 (balance on hand) 100 @ $5.00 September 5 300 400 @ 5.10 12 200 300 @ 5.30 27 800 200 @ 5.35 28 150 600 @ 5.60 200 @ 5.80 Instructions (a) Compute the inventory at September 30 on each of the following bases. Assume that perpetual inventory records are...
Determine Monsoon's ending
inventory in dollars using Perpetual
FIFO. Round to the nearest dollar.
Determine Monsoon's ending inventory in dollars
using Perpetual LIFO. Round to the nearest
dollar.
Monsoon Company has a beginning balance in inventory of 400 units at @ $4.20 per unit. A record of transactions for the month of May was as follows: Purchases Sales May Cost May # Price 200 $7.00 1,100 600 $4.10 $4.30 800 $7.00 900 $4.40 800 $7.50 500 $7.50 1,450 550 $4.50...
Moving-Average Inventory Question: Assuming that perpetual
inventory records are kept in units only, the ending inventory on
an average-cost basis, rounded to the nearest dollar, is
The number I came up with was 1,300 @ $3.4 = $4,420, which the
closest answer to that would be D. Is the key off or did I miss a
step?
Transactions for the month of June were: Purchases June 1 (balance) 800 a $3.20 2,200 @ 3.10 1,200 @ 3.30 1,800 @ 3.40...
Question 10 A record of transactions for the month of May was as follows: Purchases Sales May 1 (balance) 480 @ $5.40 May 3 240 @ $7.00 4 1,350 @ $5.30 6 1,000 @ 7.00 8 800 @ $5.50 12 900 @ 7.50 14 700 @ $5.60 18 500 @ 7.50 22 1,290 @ $5.70 25 1,300 @ 8.00 29 600 @ $5.75 Assuming that perpetual inventory records are kept in dollars, determine the ending inventory using LIFO. Ending inventory...
Montoure Company uses a perpetual Inventory system. It entered into the following calendar year purchases and sales transactions. Units Sold at Retail Units Acquired at Cost 600 units $45 per unit 400 units $42 per unit 200 units $27 per unit Date Activities Jan. 1 Beginning inventory Feb. 10 Purchase Mar. 13 Purchase Mar. 15 Sales Aug. 21 Purchase Sept. 5 Purchase Sept. 10 Sales Totals 800 units $75 per unit 100 units $50 per unit 500 units @ $46...