Perpetual Inventory Using LIFO Beginning inventory, purchases, and sales data for prepaid cell phones for May are as follows: Inventory Sales Purchases May 10 May 1 May 12 20 14 31 2,000 units at $27 1,000 units at $29 900 units at $31 1,400 units 1,200 units 600 units a. Assuming that the perpetual inventory system is used, costing by the LIFO method, determine the cost of merchandise sold for each sale and the inventory balance after each sale, presenting the data in the form illustrated in Exhibit 4. Under LIFO, if units are in inventory at two different costs, enter the units with the HIGHER unit cost first in the Cost of Merchandise Sold Unit Cost column and LOWER unit cost first in the Inventory Unit Cost column

You have the following information for Ivanhoe Inc. for the month ended October 31, 2025. Ivanhoe uses a periodic system for inventory. Date Oct. 1 Oct. 9 Oct. 11 Oct. 17 Oct. 22 Oct. 25 Oct. 29 (a1) (a2) Description Beginning inventory 55 Purchase Sale Purchase Sale Purchase Sale Ending inventory Cost of goods sold Gross profit Units Unit Cost or Selling Price $26 $ tA 140 tA 100 1.LIFO. 2. FIFO. 3. Average-cost. (Round answers to O decimal places, e.g. 125.) 100 55 65 110 Calculate ending inventory, cost of goods sold, and gross profit under each of the following methods. LIFO tA $ 28 LA 45 29 50 31 50 FIFO tA tA tA AVERAGE-COST

company's inventory records show the following data for the month of July. Date July 1 July 5 July 10 July 20 July 25 July 1 Date Activities Beginning inventory Purchase Sale Purchase Sale July 5 Average cost July 5 July 10 July 20 200 units @ $50 If the company uses the weighted average method and the perpetual inventory system, what would be the cost of its ending inventory? Average cost July 20 July 25 Total July 25 Goods purchased Number of Cost per units unit 50 at $ 75.00 Units Acquired at Cost Units Sold at Retail 100 units @ $72 = $7,200 50 units @ $75 = $3,750 225 at $ 77.00 225 units @ $77 = $17,325 Number of units sold Cost of Goods Sold Cost per Cost of Goods Sold unit 75 at $ 50.00 = 200 at $ 50.00 $ 75 units @ $50 $ $ 3,750.00 10,000.00 10,000.00 Number of units 100 at Inventory Balance 100 at 50 at 150 at Cost per unit Inventory Balance 7,200.00 7,200.00 3,750.00 10,950.00 $ 175 at $ $ $ 75 at 150 at 225 at $ 375 at $ 50.00 = $ +73.00 = 77.00 = 75.40 75.00 = 55 72.00 = $…

Please help me make a perpetual FIFO, perpetual LIFO, Weighted Average, and Specific ID chart. Thank you