Tyler Company has the following information related to purchases and sales of one of its inventory items.   Sept.   1   Beginning inventory 20 units @ $5   10   Purchase 30 units @ $8   20   Sales   40 units @ $15 25   Purchase 25 units at $10   Assume the company uses a perpetual inventory system. Required: Calculate ending inventory and cost of goods sold using the FIFO, LIFO, and average cost methods.

Hess Company's inventory records show the following data for the month of September:       Units   Unit Cost   Inventory, September 1   100     $3.00     Purchases: September 8   450     3.50       September 18   300     3.70     A physical inventory on September 30 shows 150 units on hand.Calculate the value of ending inventory and cost of goods sold if the company uses FIFO inventory costing and a periodic inventory system. Ending inventory   $enter a value of ending inventory in dollars    Cost of goods sold   $enter a cost of goods sold in dollars

REQUIRED: Determine the cost assigned to ending inventory and to cost of goods sold using LIFO. Each yellow cell must include a formula using cell references, EVEN IF THE FORMULA RESULT IS ZERO. Date Jan. 1 Beginning inventory Jan. 11: Sales Jan. 15 Purchase Jan. 17: Sales Jan, 21:Purchase Jan. 23: Sales Totals Units purchased Cost of Goods Sold - Perpetual LIFO: 560 840 890: Ending Inventory-Perpetual LIFO: 2,290 Calculate cost of goods sold for the January 11 sale of 450 units. Calculate cost of goods sold for the January 17 sale of 670 units. Cost per unit $14 17 19 Units Sold 450 Total Cost of Goods Sold for January - 1,920 units Units in Ending Inventory Total Cost Units Sold Selling Price Total Sales of Purchase per unit Total Ending Inventory for January - 370 units $7,840 14,280 16,910 $39,030 units @ units units@ 450 670 800 1,920 Cost per unit $14 $14 Cost per unit $40: $40 $40 per unit= units @ units $18,000 26,800 32,000 $76,800 Cost of Goods Sold $6,300 Inventory Balance

Salmone Company reported the following purchases and sales of its only product. Salmone uses a perpetual inventory system. Determine the cost assigned to ending inventory using LIFO.   Date Activities Units Acquired at Cost Units Sold at Retail May 1 Beginning Inventory 200 units @ $15   5 Purchase 245 units @ $17   10 Sales   165 units @ $25 15 Purchase 125 units @ $18   24 Sales   115 units @ $26