Qty | rate | Amt | ||
Purchase | 1200 | 115 | 138000 | |
Purchase | 890 | 97 | 86330 | |
Purchase | 450 | 63 | 28350 | |
Purchase | 200 | 74 | 14800 | |
2740 | 267480 | |||
ending inventory | 992 | |||
Unit sold = | 1748 | |||
Ending LIFO inventory value | 158176 | |||
=1200*115+208*97 | ||||
Cost of goods sold | 109304 | |||
267480-158176 | ||||
COGS as % of sales | 25.24% | |||
109304/433121 | ||||
QUESTION 6 Compute the ending LIFO inventory and cost of goods sold assuming: $433,121 in sales...
Q.4. Use the format in Exhibit 9-1 to compute the ending LIFO inventory and cost of goods sold assuming: $550,000 in sales Beginning inventory 1125 units @ $175 Purchases of 890 units @ $150 450 units @ $165 200 units @ $140 Ending inventory 892 units What is the dollar value of the ending inventory. In your answer, format the number using commas as needed. Do not include a dollar sign. Round to nearest whole dollar (no decimal and no...
inventory calcuations d. Compute the cost of ending inventory using the LIFO method Units Sold Cost 50 100 400 55 Date Activities Beginning 1-Mar inventory 5-Mar Purchase 9-Mar Sales 16-Mar Purchase 25-Mar Purchase 29-Mar Sales 420 120 2001 60 62 160 LIFO Cost of Goods Sold Cost per units unit Cost of goods sold Ending Inven # ending Cost per inventory unit Date Units sold Sales 25-Mar 16-Mar 5-Mar 1-Mar Totals
FIFO & LIFO Inventory Study the FIFO and LIFO explanations in Chapter 8. 1) Compute ending FIFO inventory and cost of goods sold. Assume $90,000 sales; beginning inventory 500 units @$50; purchases of 400 units @$50; 100 units @$65; 400 units @$80. 2) Compute the cost of goods sold percentage of sales. 3) Compute ending LIFO inventory and cost of goods sold, using same assumptions. 4) Compute the cost of goods sold percentage of sales. 5) Comment on the difference...
During the year, TRC Corporation has the following inventory transactions. For the entire year, the company sells 400 units of inventory for $50 each. Required: 1. Using FIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 2. Using LIFO, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. 3. Using weighted-average cost, calculate ending inventory, cost of goods sold, sales revenue, and gross profit. (Round "Average Cost per unit" to 4 decimal places and all other answers to...
Computing Cost of Goods Sold and Ending Inventory Under FIFO, LIFO, and Average Cost Assume that Gode Company reports the following initial balance and subsequent purchase of inventory: Beginning inventory, 2017 1,000 units @ $100 each $100,000 Inventory purchased in 2017 2.000 units $150 each 300,000 Cost of goods available for sale in 2017 3.000 units $400,000 Assume that 1,600 units are sold during 2017. Compute the cost of goods sold for 2017 and the balance reported as ending inventory...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Units Unit Cost $5 1,830 Inventory, December 31, prior year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current year 6,130 4,130 2,810 2 Required: Compute ending...
E7-6 (Algo) Calculating Ending Inventory and Cost of Goods Sold Under FIFO, LIFO, and Average Cost LO7-2 Hamilton Company uses a periodic inventory system. At the end of the annual accounting period, December 31 of the current year, the accounting records provided the following information for product 1: Unit Units Cost Inventory, December 31, prior 1,980 $8 year For the current year: Purchase, March 21 Purchase, August 1 Inventory, December 31, current 6,090 4,150 7 2,840 year Required: Compute ending...
Assuming that the periodic inventory method is used, compute the cost of goods sold and ending inventory under (1) LIFO and (2) FIFO. Please Show Work June 1 Balance 299 units @ $11 10-Jun Sold 197 units @ $27 11 Purchased 798 units @ $14 15-Jun Sold 503 units @ $29 20 Purchased 502 units @ $15 27-Jun Sold 305 units @ $31 LIFO PURCHASES COST OF GOODS SOLD ENDING INVENTORY Date Units Cost Per Unit Total Cost Units Cost Per...
Calculating Cost of Goods Available for Sale, Ending Inventory, Sales, Cost of Goods Sold, and Gross Profit under Periodic FIFO, LIFO, and Weighted Average Cost FIFO (PERIODIC) Unit Selling Price July 1 July 13 July 25 July 31 Beginning Inventory Purchase Sold Ending Inventory Units Unit Cost 40 $10 200 (100) 140 $14 Units Cost per Unit Total Beginning Inventory Purchases July 13 Goods Available for Sale Cost of Goods Sold Units from Beginning Inventory Units from July 13 Purchase...
1. Calculate cost of ending inventory and cost of goods sold using periodic FIFO, LIFO, and Weighted Average Cost methods X FILE 5.a. HOME % Calibri INSERT PAGE LAYOUT Inventory costing methods - Excel FORMULAS DATA REVIEW ? x VIEW - 6 Sign In Paste B IU - -A- Alignment Number Conditional Format as Cell Formatting Table Styles Styles Cells Editing Clipboard D66 1 Better Bottles, Inc., uses a periodic inventory system and has the following information available: of Units...