(i) $3160
Explanation
FIFO | |||
Date | Purchases | sales | Balance |
01-May | Beginning inventory 20 units @$150 | 20 units @$150 | |
05-May | 12 units @$150 | 8 units @ $150 | |
08-May | 28 units @$160 | 8 units @ $150 28 units@$160 | |
20-May | 8 units @$150 + 4 units @$160 | 24 units @$160 | |
25-May | 12 units @$210 | 24 units @$160 12 units @$210 | |
30-May | 20 units @$160 | 4 units @$160 12 units @$210 |
(ii) $2480
Explanation
LIFO | |||
Date | Purchases | sales | Balance |
01-May | Beginning inventory 20 units @$150 | 20 units @$150 | |
05-May | 12 units @$150 | 8 units @ $150 | |
08-May | 28 units @$160 | 8 units @ $150 28 units@$160 | |
20-May | 12 units @$160 | 8 units @ $150 16 units @$160 | |
25-May | 12 units @$210 | 8 units @ $150 16 units @$160 12 units @$210 | |
30-May | 12 units @$210+8 units @$160 | 8 units @ $150 8 units @$160 |
Part B The following information relates to the inventory of badminton racquets in the records of...
Problem #1 ABC Company uses a perpetual inventory system and the information for Product LG58x is shown below. Complete a perpetual inventory sheet for this product using the First-in, First-out (FIFO) Method. March 3rd March 5th March 10th March 18th March 20th March 28th March 31st Inventory 24 units @ $4.00 Purchased 30 units @ $4.10 Purchased 24 units @ $4.12 Sold 10 units @ $11.75 Sold 30 units @ $11.75 Purchased 12 units @ $4.15 Sold 20 units @...
The following data relates to the inventory and purchases of item 125 for Sanders Company during May: Inventory, May 1 520 units at $21.00 Purchases: May 10 380 units at $20.75 May 19 280 units at $20.35 May 25 320 units at $20.40 Inventory, May 31 460 units INSTRUCTIONS Determine the cost of the ending inventory on May 31 under each of the following methods: (a) average cost method; (b) first-in, first-out (FIFO) method; and (c) last-in, first-out (LIFO) method....
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 1,200 units at $33 May 10 600 units at $35 May 12 840 units May 20 540 units at $37 May 14 720 units May 31 360 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 3,700 units at $23 May 10 1,850 units at $25 May 12 2,590 units May 20 1,665 units at $27 May 14 2,220 units May 31 1,110 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after...
Question 1: Inventory Cost Flow [13 marks] Jupiter Ltd uses the periodic inventory method to record the cost of sales. The company had the following inventory information available for the month of May: May Units Unit cost 1 Explanation Beginning inventory Purchase 100 $4 10 500 $5 20 Purchase 100 $7 30 Purchase 300 $8 A physical count of inventory on 31 May revealed that there were 350 units on hand. Required: For the purpose of this question, please ignore...
Inventory information for Part 311 of Waterway Corp.discloses the following information for the month of June. June 1 Balance 301 units @ $16 June 10 Sold 197 units @ $37 11 Purchased 797 units @ $19 15 Sold 498 units @ $39 20 Purchased 503 units @ $20 27 Sold 297 units @ $42 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 (2)...
Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 1,200 units at $22 May 12 840 units May 10 May 20 600 units at $24 540 units at $26 May 14 May 31 720 units 360 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the...
To more efficiently manage its inventory, Treynor Corporation maintains its internal inventory records using first-in, first-out (FIFO) under a perpetual inventory system. The following information relates to its merchandise inventory during the year: Jan. 1 Inventory on hand-20,000 units; cost $12.20 each. Feb. 12 Purchased 70,000 units for $12.50 each. Apr. 30 Sold 50,000 units for $20.00 each. Jul. 22 Purchased 50,000 units for $12.80 each. Sep. 9 Sold 70,000 units for $20.00 each. Nov. 17 Purchased 40,000 units for...
Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Purchases Sales May 1 2,800 units at $21 May 10 1,400 units at $23 May 12 1,960 units May 20 1 ,260 units at $25 May 14 1,680 units May 31 840 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance...
To more efficiently manage its inventory, Treynor Corporation maintains its internal inventory records using first-in, first-out (FIFO) under a perpetual inventory system. The following information relates to its merchandise inventory during the year: Jan. 1 Inventory on hand—20,000 units; cost $13.10 each. Feb. 12 Purchased 70,000 units for $13.40 each. Apr. 30 Sold 50,000 units for $20.90 each. Jul. 22 Purchased 50,000 units for $13.70 each. Sep. 9 Sold 70,000 units for $20.90 each. Nov. 17 Purchased 40,000 units for...