Develop Review View Formulas Data Home Draw Page Layout Insert Wrap Calibri (Body) A A 11 A Paste BIU EE Merge 29 A B C D E F G Exercise C Miami Discount Company inventory records show: Total Unit Units Cost Cost Beginning inventory 3,000 $38.00 $114,000 Purchases: February 14 March 18 July 21 September 27 2 November 5 3 Sales: 4 April 15 s August 20 900 39.00 35,100 96,000 72,540 2400 1,800 40.00 40.30 1,800 40.60 73,080 24,600 600 41.00 2,800 2,000 1,500 6 October 3 A C Di E H K L MI October 3 1500 The December 31 inventory was 4,200 uns Miami Dscount Compuny uses perpetual inventory procedure. Present a schedule showing the measurement of the ending inventory uning FIFO perpetual inventory procedure Purchased Sold Balance Date Units Unit Cost Total Cost Units Sold Total Cost Units Unit Cout Units Unit Cost 3 eghwing inventory 38.00 114/000 00 rve filed in some for you so you can see 3000 4 14-Feb 900 114,000 00 3900 3000 38.00 35,100.00 35.300.00 900 39.00 t in onder (oldest to newest) on right, so 2%18-Mar 27 40 00 2400 96,000 00 3000 114,000 00 38.00 35,100.00 Nobe Unit Cost above instructions when en s00 39.00 $ 28 2400 6,000.00 40.00 29 15-Apr 2800 38.00 $ 38.00 106400.00 200 7,600.00 30 31 32 21- 33 34 35 FIFO so sell oldest tems fist fsel 200 3 7600.00 36 20-Aug 200 38.00 39.00 35.100.00 900 37 38 39 27-5ep 40 41 42 3-Oct 43 44 27-Nov- Find Ending invetory ng hefiometho 45 of the lait inveory total co e 46 471 Ending Imeemery 4s Eerche D Sheet1 + 17 Ready AD TS 14