Sorry I send back the sama question again because I still don't understand how the way work. I will give the answer that you give to me.

These 2 answer I don't understand because you give me the solution but you don't give me how the formula of excell work, like I mean the number comes from where and show me the formula in Excel, so that I can understand. Thanks

Melisa's record of transactions concerning part X for the month of September was as follows. Purchases Sales April 1 $5.00 April 5 300 4 5.10 12200 (balance on hand) 100 @ 400 @ 300 @ 200 @ 11 5.30 27 | 800 18 5.35 28 150 26 600 @ 5.60 30 200 @ 5.80 Required: a. Compute the inventory at April 30 on each of the following bases. Assume that perpetual inventory records are kept in units only. (Carry unit costs to the nearest cent.) 1. Specific identification; ending inventory is comprised of 100 units from beginning inventory and 250 units from the April 26 purchase. 2. First-in, first-out (FIFO). 3. Average-cost. b. If the perpetual inventory record is kept in dollars, and costs are computed at the time of each withdrawal, what amount would be shown as ending inventory in 1, 2, and 3 above? Explain the result! (Carry average unit costs to four decimal places, and total costs to two decimal places.) FIFO method: FIFO Method Date Purchase Unit Cost 01-Apr 100 04-Apr 400 @5.1 Sales Unit Cost 0 0 @5 Closing Unit Cost 100 @5 100 @5 400 @5.1 05-Apr 100 200 @5 @5.1 11-Apr 300 @5.3 200 @5.1 12-Apr 18-Apr 200 @5.35 200 200 300 300 300 200 300 200 600 @5.1 @5.1 @5.3 @5.3 @5.3 @5.35 @5.3 @5.35 @5.6 26-Apr 600 @5.6 27-Apr 300 200 300 150 @5.3 @5.35 @5.6 @5.6 28-Apr 30-Apr 300 150 150 200 @5.6 @5.6 @5.6 @5.8 200 @5.8 Average Cost method Average Cost Method Date Purchase Unit Cost 01-Apr 100 @5 04-Apr 400 @5.1 05-Apr 11-Apr 300 @5.3 12-Apr 18-Apr 200 @5.35 26-Apr 600 @5.6 27-Apr 28-Apr 30-Apr 200 @5.8 Sales Closing Unit Cost Unit Average Cost 100 @5 500 @5.05 300 @5.05 200 @5.05 500 @5.175 200 @5.175 300 @5.175 500 @5.2625 1100 @5.4313 800 @5.4313 300 @5.4313 150 @5.4313 150 @5.4313 350 @5.6156