Perpetual FIFO Inventory Schedule
Inventory Schedule |
|||||||||
FIFO (First in first out) Method |
|||||||||
Goods Purchased |
Cost of goods sold |
Inventory Balance |
|||||||
# of Units |
Cost per unit |
Total Cost ($) |
# of Units |
Cost per unit |
Cost of goods sold ($) |
# of Units |
Cost per unit |
Inventory Balance ($) |
|
Mar 1 |
90 |
50.80 |
4,572 |
||||||
Mar 5 |
220 |
55.80 |
12,276 |
90 |
50.80 |
4,572 |
|||
220 |
55.80 |
12,276 |
|||||||
Mar 9 |
90 |
50.80 |
4,572 |
60 |
55.80 |
3,348 |
|||
160 |
55.80 |
8,928 |
|||||||
Mar 18 |
80 |
60.80 |
4,864 |
60 |
55.80 |
3,348 |
|||
80 |
60.80 |
4,864 |
|||||||
Mar 25 |
140 |
62.80 |
8,792 |
60 |
55.80 |
3,348 |
|||
80 |
60.80 |
4,864 |
|||||||
140 |
62.80 |
8,792 |
|||||||
Mar 29 |
60 |
55.80 |
3,348 |
20 |
60.80 |
1,216 |
|||
60 |
60.80 |
3,648 |
140 |
62.80 |
8,792 |
||||
TOTAL |
20,496 |
160 |
10,008 |
||||||
connect.mheduca Wamerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March Units Sold at Retail war Units Acquired at Cost 190 units @ $52.80 per unit 270 units 557.30 per unit Date Activities Mar. 1 Beginning inventory 5 Purchase Mar. 9 Sales Mar. 18 Purchase Mar. 25 Purchase Mar. 29 Sales Totals 350 units $87.80 per unit 130 units $62.80 per unit 240 units $64.80 per unit 830 units 220 units $97.80 per...
The Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March 2019. For specific identification: The March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; The March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase. Date Activities Units Acquired at Cost Units Sold at Retail 100 units a $50.00 per unit 400...
The Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March 2019. For specific identification: • The March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; • The March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase. Date Activities Units Acquired at Cost Units Sold at Retail Mar.1 100 units @ $50.00...
The Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March 2019. For specific identification: The March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; The March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase. Date Activities Units Acquired at Cost Units Sold at Retail Beginning inventory Purchase..... 100 units a $50.00...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 230 units @ $53.60 per unit Mar. 5 Purchase 290 units @ $58.60 per unit Mar. 9 Sales 390 units @ $88.60 per unit Mar. 18 Purchase 150 units @ $63.60 per unit Mar. 25 Purchase 280 units @ $65.60 per unit Mar. 29 Sales 260 units @...
The Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March 2019. For specific identification: • The March 9 sale consisted of 80 units from beginning inventory and 340 units from the March 5 purchase; The March 29 sale consisted of 40 units from the March 18 purchase and 120 units from the March 25 purchase. Date Activities Units Acqulied at Cost Units Sold at Retail 100 units a $50.00 per unit...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 60 units @ $50.20 per unit Mar. 5 Purchase 205 units @ $55.20 per unit Mar. 9 Sales 220 units @ $85.20 per unit Mar. 18 Purchase 65 units @ $60.20 per unit Mar. 25 Purchase 110 units @ $62.20 per unit Mar. 29 Sales 90 units @...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 250 units @ $54.00 per unit Mar. 5 Purchase 300 units @ $59.00 per unit Mar. 9 Sales 410 units @ $89.00 per unit Mar. 18 Purchase 160 units @ $64.00 per unit Mar. 25 Purchase 300 units @ $66.00 per unit Mar. 29 Sales 280 units @...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 200 units @ $53.00 per unit Mar. 5 Purchase 275 units @ $58.00 per unit Mar. 9 Sales 360 units @ $88.00 per unit Mar. 18 Purchase 135 units @ $63.00 per unit Mar. 25 Purchase 250 units @ $65.00 per unit Mar. 29 Sales 230 units @...
Warnerwoods Company uses a perpetual inventory system. It entered into the following purchases and sales transactions for March. Date Activities Units Acquired at Cost Units Sold at Retail Mar. 1 Beginning inventory 220 units @ $53.40 per unit Mar. 5 Purchase 285 units @ $58.40 per unit Mar. 9 Sales 380 units @ $88.40 per unit Mar. 18 Purchase 145 units @ $63.40 per unit Mar. 25 Purchase 270 units @ $65.40 per unit Mar. 29 Sales 250 units @...