Sheridan Department Store uses a perpetual inventory system. Data for product E2-D2 include the following purchases.

I'm not using excel so if you could show how you got the right answer, id appreciate it!

Exerci Sheridan Department Store uses a perpetual inventory system. Data for product E2-D2 include the following purchases. Date May 7 Number of Units 60 35 Unit Price $12 15 July 28 On June 1, Sheridan sold 25 units, and on August 27, 40 more units. (a) Your answer is partially correct. Try again. Prepare the perpetual inventory schedule for the above transactions using FIFO. (Round answers to o decimal places, e.g. 1,250.) Product E2-D2 Date Purchases Cost of Goods Sold Balance May 7 720 0 720 June 1 300 420 $ July 28 525 945 X Aug. 27 0 425 520