1) | ||||||||||
Date | Purchases | cost of merchandise sold | Inventory | |||||||
Quantity | unit cost | total cost | Quantity | unit cost | total cost | Quantity | unit cost | total cost | ||
Jun-01 | 500 units | $ 30.000 | $ 15,000 | |||||||
Jun-10 | 1500 units | $ 34.00 | $ 51,000 | 500 units | $ 30.000 | $ 15,000 | ||||
1500 units | $ 34.00 | $ 51,000 | ||||||||
Jun-28 | 500 units | $ 30.000 | $ 15,000 | |||||||
250 units | $ 34.00 | $ 8,500 | 1,250 units | $ 34.00 | $ 42,500 | |||||
Jun-30 | 250 units | $ 34.00 | $ 8,500 | 1,000 units | $ 34.00 | $ 34,000 | ||||
Jul-05 | 100 units | $ 34.00 | $ 3,400 | 900 units | $ 34.00 | $ 30,600 | ||||
Jul-10 | 3,600 units | $ 35.00 | $ 126,000 | 900 units | $ 34.00 | $ 30,600 | ||||
3,600 units | $ 35.00 | $ 126,000 | ||||||||
Jul-16 | 900 units | $ 34.00 | $ 30,600 | |||||||
900 units | $ 35.00 | $ 31,500 | 2,700 units | $ 35.00 | $ 94,500 | |||||
Jul-28 | 1,700 units | $ 35.00 | $ 59,500 | 1,000 units | $ 35.00 | $ 35,000 | ||||
Aug-05 | 3,000 units | $ 35.80 | $ 107,400 | 1,000 units | $ 35.00 | $ 35,000 | ||||
3,000 units | $ 35.80 | $ 107,400 | ||||||||
Aug-14 | 1,000 units | $ 35.00 | $ 35,000 | |||||||
1,000 units | $ 35.80 | $ 35,800 | 2,000 units | $ 35.80 | $ 71,600 | |||||
Aug-25 | 500 units | $ 36.00 | $ 18,000 | 2,000 units | $ 35.80 | $ 71,600 | ||||
500 units | $ 36.00 | $ 18,000 | ||||||||
Aug-30 | 1,750 units | $ 35.80 | $ 62,650 | 250 units | $ 35.80 | $ 8,950 | ||||
500 units | $ 36.00 | $ 18,000 | ||||||||
Aug-31 | Balances | $ 290,450 | $ 26,950 |
2) | |||
Account title and explanation | Debit | Credit | |
Accounts receivable | $ 483,800 | ||
Sales | $ 483,800 | ||
($37,500 +$ 13,000+$ 5,500 + $ 100,800+ | |||
$ 102,000 + $ 120,000 + $ 105,000) | |||
( to record total sales ) | |||
Cost of Merchandise sold | $ 290,450 | ||
Merchandise inventory | $ 290,450 | ||
( to record total cost of merchandise sold) | |||
3) | Gross profit = Total Sales - Total cost of merchandise sold | ||
Gross profit = $ 483,800 - $ 290,450 | |||
Gross profit = $ 193,350 | |||
4) | Ending inventory cost as of August 31,2014 | ||
Ending inventory =$ 8,950 +$ 18,000 | |||
Ending inventory = $ 26,950 | |||
5) | Hence, the price per unit rises from $ 30 for June 1 inventory | ||
to $ 36 for the purchase on August 25 . So, we would expect | |||
that under the last-in , First out method the inventory would | |||
be lower . | |||
Tuviens Series A $193,350 PR 7-1A FIFO perpetual inventory OBJ. 2, 3 The beginning inventory at...
problem 7-1A, I need answers 1-5! Beginning merchandise inventory Purchases (net) Merchandise available for sale 860,000 $ 960,000 oblems: Series A 5,750 PR 7-1A FIFO perpetual inventory OBJ. 2,3 The beginning inventory at Funky Party Supplies and data on purchases and sales for a three-month period ending March 31, 2016, are as follows: Per Date Jan. 1 10 28 30 Transaction Inventory Purchase Sale Sale Number of Units 2,500 7,500 3,750 1,250 Unit $60.00 68.00 120.00 120.00 $150,000 510,000 450,000...
perpetual inventory using FIFO Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales for Item 1901 are as follows: August 1 Inventory 37 units $24 31 units 13 Purchase 41 units $25 Sale 28 Sale 14 units Assuming a perpetual Inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on August 28 and (b) the inventory on August 31. a. Cost of merchandise sold on August 28 b. Inventory on August 31
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Number of Units Date Transaction Per Unit Total Apr. 3 Inventory $1,200 $30,000 8 Purchase 1,240 93,000 11 Sale 2,000 80,000 60,000 30 Sale May 8 Purchase 2,000 1,260 2,000 2,000 1,260 75,600 100,000 10 Sale 19 Sale 40.000 28 Purchase 100,800 June 5 Sale 2,250 90,000 16 Sale 2.250 56,250 21 Purchase...
FIFO Perpetual Inventory The beginning inventory of merchandise at Rhodes Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Number of Units Date Transaction Per Unit Total Apr. 3 Inventory 60 $375 $22,500 8 Purchase 120 450 54,000 11 Sale 80 1,250 100,000 30 Sale 50 1,250 62,500 May 8 Purchase 100 500 50,000 10 Sale 60 1,250 75,000 19 Sale 30 1,250 37,500 28 Purchase 100 550 55,000 June 5 Sale...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 36 $150 $5,400 8 Purchase 72 180 12,960 11 Sale 48 500 24,000 30 Sale 30 500 15,000 May 8 Purchase 60 200 12,000 10 Sale 36 500 18,000 19 Sale 18 500 9,000 28 Purchase 60 220 13,200 June 5 Sale...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 36 $300 $10,800 8 Purchase 72 360 25,920 11 Sale 48 1,000 48,000 30 Sale 30 1,000 30,000 May 8 Purchase 60 400 24,000 10 Sale 36 1,000 36,000 19 Sale 18 1,000 18,000 28 Purchase 60 440 26,400 June 5 Sale...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 36 $375 $13,500 8 Purchase 72 450 32,400 11 Sale 48 1,250 60,000 30 Sale 30 1,250 37,500 May 8 Purchase 60 500 30,000 10 Sale 36 1,250 45,000 19 Sale 18 1,250 22,500 28 Purchase 60 550 33,000 June 5 Sale...
FIFO Perpetual Inventory The beginning inventory of merchandise at Dunne Co. and data on purchases and sales for a three-month period ending June 30 are as follows: Date Transaction Number of Units Per Unit Total Apr. 3 Inventory 66 $225 $14,850 8 Purchase 132 270 35,640 11 Sale 88 750 66,000 30 Sale 55 750 41,250 May 8 Purchase 110 300 33,000 10 Sale 66 750 49,500 19 Sale 33 750 24,750 28 Purchase 110 330 36,300 June 5 Sale...
Perpetual Inventory Using FIFO Beginning inventory, purchases, and sales for Item HM46 are as follows: August 1 Inventory 56 units @ $21 9 Sale 41 units 13 Purchase 43 units @ $24 28 Sale 23 units Assuming a perpetual inventory system and using the first-in, first-out (FIFO) method, determine (a) the cost of merchandise sold on August 28 and (b) the inventory on August 31. a. Cost of merchandise sold on August 28 $ b. Inventory on August 31 $
FIFO perpetual inventory Instructions FIFO Chart of Accounts Journal Final Questions Instructions The beginning inventory at Midnight Supplies and data on purchases and sales for a three-month period ending March 31, are as follows: Date Transaction Per Unit $58.00 Total $150,800 Jan. Inventory 66.00 475,200 10 28 30 Purchase Sale Sale 8 8 Feb Sale 8 8 Number of Units 2,600 7.200 3,950 1,300 500 17,500 9,200 8,000 14,400 10,100 3,300 7,900 8 10 16 28 5 14 25 30...