| Perpetual inventory system and moving-average cost formula: | |||||||||
| Date | Purchase | Sale ( at cost ) | Balance | ||||||
| Units | Unit cost | Total cost | Units | Unit cost | Total cost | Units | Unit cost | Total cost | |
| May 1 | 2000 | 3.10 | 6200 | ||||||
| May 5 | 3000 | 3.30 | 9900 | 5000 | 3.22 | 16100 | |||
| May 10 | 5000 | 3.40 | 17000 | 10000 | 3.31 | 33100 | |||
| May 15 | 5000 | 3.31 | 16550 | 5000 | 3.31 | 16550 | |||
| May 20 | 3000 | 3.31 | 9930 | 2000 | 3.31 | 6620 | |||
| May 22 | 3500 | 3.60 | 12600 | 5500 | 3.49 | 19220 | |||
| May 24 | 2500 | 3.60 | 9000 | 8000 | 3.53 | 28220 | |||
| May 25 | 5000 | 3.53 | 17650 | 3000 | 3.52 | 10570 | |||
| Ending inventory | 10570 |
The following inventory transactions took place for Oriole Corporation for the month of May: Date Event...
The following inventory transactions took place for NPR Corporation for the month of May: Date Event Quantity Cost/Selling Price May 1 Beginning Inventory 1,000 $3.55 May 5 Purchase 6,000 3.10 May 10 Purchase 2,000 3.75 May 15 Sale 3,000 6.00 May 20 Sale 2,000 6.00 May 22 Purchase 5,000 3.45 May 24 Purchase 2,000 3.75 May 25 Sale 7,000 6.00 Required 1. Calculate the ending inventory balance for NPR Corporation, assuming the company uses a periodic inventory system and the...
The following inventory transactions took place for Crane Corporation for the month of May:Calculate the ending inventory balance for Crane Corporation, assuming the company uses a perpetual inventory system and the first-in, first-out (FIFO) cost formula.
A company reports the following beginning inventory and two
purchases for the month of January. On January 26, the company
sells 360 units. Ending inventory at January 31 totals 130
units.
Units
Unit Cost
Beginning inventory on January 1
320
$
3.10
Purchase on January 9
70
3.30
Purchase on January 25
100
3.40
Required:
Assume the perpetual inventory system is used. Determine the costs
assigned to ending inventory when costs are assigned based on the
weighted average method. (Round...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 400 17 Purchase 200 $5.50 25 Sale 150 Purchase 100 5.75 May 5 Purchase 250 5.50 18 Sale 300 22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: 1. Compute the inventories at the end of each...
Garrett Company has the
following transactions during the months of April and May:
Date Transaction Units Cost/Unit April 1 Balance 500 17 Purchase
200 $5.30 25 Sale 150 28 Purchase 100 5.70 May 5 Purchase 250 5.30
18 Sale 300 22 Sale 50 The cost of the inventory on April 1 is $5,
$4, and $2 per unit, respectively, under the FIFO, average, and
LIFO cost flow assumptions.
Required: 1. Compute the inventories at the end of each month
and...
Inventory Date Activity Units Unit Cost Balance 1-Mar Beginning Balance 250 $14 $3,500 3-Mar Sale (200) - - 0 10-Mar Purchase 200 15 ...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Cost/Unit April 1 Balance 17 Purchase 25 Sale Units 500 200 $5.40 28 May 5 18 22 5.70 5.40 Purchase Purchase Sale Sale 300 The cost of the inventory on April 1 Is 55, 54, and 52 per unit, respectively, under the FIFO, average and fine m ELLE he cost of the inventory on April 1 is $5, $4, and $2 per...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 500 17 Purchase 200 $5.10 25 Sale 150 28 Purchase 100 $5.90 May 5 Purchase 250 $5.10 18 Sale 300 22 Sale 50 The cost of the inventory on April 1 is $5, $4, and $2 per unit, respectively, under the FIFO, average, and LIFO cost flow assumptions. Required: Compute the costs of goods sold for each...
2 You have the following information for Oriole Company for the month ended October 31, 2022. Oriole uses a periodic method for inventory. Calculate the weighted-average cost. (Round answer to 3 decimal places, e.g. 5.125.) Weighted-average cost per unit _______ 4 Coronado Industries took a physical inventory on December 31 and determined that goods costing $180,500 were on hand. Not included in the physical count were $27,000 of goods purchased from Sunland Company, FOB, shipping point, and $20,000 of goods sold to Bramble...
Oriole Company is a retailer operating in Calgary, Alberta.
Oriole uses the perpetual inventory method. Assume that there are
no credit transactions; all amounts are settled in cash. You are
provided with the following information for Oriole for the month of
January 2022.
Dec.31 Ending Inventory - 175 units - $20 each
Jan 2. Purchase - 105 units - $28 each
Jan 6. Sale 193 units - $44 each
Jan 9. Purchase 58 units - $25 each
Jan 10. Sale...