B C D E F G H K 4 (LO3) Compute FIFO, LIFO, and Average-Cost 2 I Company's record of transactions concerning part X for the month of April was as follows. 4 Purchases - Units and Unit Costs April Sales - Total Units 1 Balance 100 at $ 5.00 April 5 300 4 400 at 5.10 12 11 200 300 at 5.30 27 18 800 200 at 5.35 28 26 150 600 at 5.60 10 30 200 at 5.80 11 12 tructions 13 Compute the inventory at April 30 on each of the following bases. Assume that perpetual 14 inventory records are kept in units only. Carry unit costs to the nearest cent. 15 1. First-in, first-out (FIFO) 16 2 . Last-in, first-out (LIFO) 17 3. Average-cost 18 If the perpetual inventory record is kept in dollars, and costs are computed at the time of each 19 withdrawal, what amount would be shown as ending inventory in (1), (2), and (3) above? (Carry 20 average unit costs to four decimal places.) 21 22 TE: Enter a formula, a cell reference, or a value (if you are unable to reference a cell), into 23 - yellow shaded input cells