Ans. | Cost of goods sold | $3,031 | ||||||||
Ending inventory | $514 | |||||||||
Gross profit | $5,969 | |||||||||
*Calculations for Cost of goods sold and Ending inventory: | ||||||||||
Weighted Average | ||||||||||
Purchase | Cost of goods sold | Balance | ||||||||
Date | Quantity | Rate | Total cost | Quantity | Rate | Total cost | Quantity | Rate | Total cost | |
01-May | 75 | $10.00 | $750 | 75 | $10.00000 | $750 | ||||
02-May | 60 | $11.00 | $660 | 135 | $10.44444 | $1,410 | ||||
03-May | 80 | $16.00 | $1,280 | 215 | $12.51163 | $2,690 | ||||
10-May | 125 | $12.51163 | $1,564 | 90 | $12.51163 | $1,126 | ||||
15-May | 45 | $19.00 | $855 | 135 | $14.67442 | 1981 | ||||
17-May | 60 | $14.67442 | $880 | 75 | $14.67442 | $1,101 | ||||
30-May | 40 | $14.67442 | $587 | 35 | $14.67442 | $514 | ||||
Total | Cost of goods sold | $3,031 | Ending inventory | $514 | ||||||
*Weighted average rate is calculated by using the formula of (Total available balance / Total units available). | ||||||||||
*Calculations for Gross Profit: | ||||||||||
Amount | ||||||||||
Sales | $9,000 | |||||||||
(-) Cost of goods sold | -$3,031 | |||||||||
Gross Profit | $5,969 | |||||||||
*Calculation of sales: | ||||||||||
Date | Units | Rate | Cost | |||||||
10-May | 125 | $40.00 | $5,000 | |||||||
17-May | 60 | $40.00 | $2,400 | |||||||
30-May | 40 | $40.00 | $1,600 | |||||||
Total sales | $9,000 | |||||||||
The following transactions occurred for the month of May. Date 1-May Beginning Balance 2-May Purchase 3-May...
The following transactions occurred for the month of May. Date 1-May Beginning Balance 2-May Purchase 3-May Purchase 10-May Sale 15-May Purchase 17-May Sale 30-May Sale Units Cost Total Sales Price 75 10 $750 60 11 $660 80 16 $1,280 125 $40 45 19 $855 60 $40 $40 $40 40 Calculate the cost of Goods Sold, Ending inventory, and Gross Profit for the month under FIFO. End of the month totals Cost of Goods Sold $ [ Ending Inventory $[ Gross...
The following transactions occurred for the month of May. Date Units Cost Total Sales Price 1-May Beginning Balance 70 15 $1,050 2-May Purchase 75 11 $825 3-May Purchase 85 12 $1,020 10-May Sale 150 $35 15-May Purchase 40 18 $720 17-May Sale 50 $35 30-May Sale 40 $35 Create a perpetual inventory record then calculate the Cost of Goods Sold, Ending inventory, and Gross Profit for the month under FIFO Purchases Cost of Goods Sold Inventory on Hand Dates Quantity...
The following transactions occurred for the month: 90,000 units were sold for $20 each. Units Cost Total Beginning Balance 15,000 Purchase 1 20,000 $10 Purchase 2 27,000 $12 Purchase 3 38,000 $16 Weighted Average Unit Cost: Calculate the Cost of Goods Sold, Ending inventory, and Gross Profit for the month under FIFO, LIFO, and Weighted Average. FIFO: Sales $ Less: Cost of Goods Sold $ Gross Profit $ Ending Inventory $
The following are the transactions for the month of July. Unit Selling Price 46 July 1 July 13 July 25 July 31 11 Units Unit Cost $10 230 (100) 176 Beginning Inventory Purchase Sold Ending Inventory $14 Calculate cost of goods available for sale and ending inventory, then sales, cost of goods sold, and gross profit, under LIFO. Assume a periodic inventory system is used. (Round "Cost per Unit" to 2 decimal places and your final answers to nearest whole...
Number of Units Unit Cost Date Transaction Jan. 1 Beginning inventory Apr. 7 Purchase Jul.16 Purchase Oct. 6 Purchase Total Cost $ 2,484 6,432 10,404 5,928 $25,248 SOG For the entire year, the company sells 440 units of inventory for $64 each. 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit Cost of Goods Available for Sale LIFO Ending Inventory Cost of Goods Sold Cost per Cost per unit # of units Cost of...
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...
Alternative Inventory Methods Garrett Company has the following transactions during the months of April and May: Date Transaction Units Cost/Unit April 1 Balance 17 Purchase $5.10 25 Sale 500 200 150 100 250 300 28 Purchase 5.90 5.10 May 5 Purchase 18 Sale 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 costs of goods sold for...
Jun. 1 Beginning merchandise inventory 12 Purchase 20 Sale 24 Purchase 29 Sale 17 units @ 5 units @ 14 units @ 11 units @ 13 units @ $ $ $ $ $ 15 each 19 each 37 each 23 each 37 each 1. Compute ending merchandise inventory, cost of goods sold, and gross profit using the FIFO inventory costing method. 2. Compute ending merchandise inventory, cost of goods sold, and gross profit using the LIFO inventory costing method. 3....
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...
The following are the inventory purchase and sales transactions of Packers Corp: Description Units Cost/Unit $40 $42 Price/Unit Date Balance Purchase Jan. 1 Jan. 5 Jan. 8 Jan. 15 Purchase Jan. 25 Sale 30 20 $80 Sale 35 $40 50 $80 40 Use the information above to answer the below questions. Round to the nearest dollar. Question 10 (0.001 points) Saved Please feel free to utilize the templates provided below. Q 15. The total ending inventory of Jan 31 that would...