Jeff Whiteheart Practice questions - Excel File Home Insert Draw Page Layout Formulas Data Review View Help Tell me what you want to do Out Copy Calibri 11 ' ' = Wrap Text General Paste BIU = = = Merge & Center - $% Format Painter Clipboard Font Alignment Number 2 P11 Ava Inc. had the following transactions on its inventory during 2021. Ava uses perpetual inventory system. Ava started the year with 300 units of inventory at a cost of $19. 2 3 4 Date 5 March 6 April 7 June 8 August 9 September 10 November 11 12 Required: Liam Roy LR AutoSum Conditional Format as Cell Formatting Table Styles Insert Delete Format Clear Styles Cells Sort & Find & Filter Select Editing E F G H J K L M N P Q R Unit Purchases 500 Price per unit $20 Unit Sales Selling Price 650 $21 800 $30 200 $32 700 $22 550 $33 13 a. Calculate the total cost of goods sold for the year 2021 using perpetual moving average. 14 b. Calculate ending inventory using perpetual moving average. 15 16 17 18 19 20 21 22 23 24 25 76 27 Q1 25 mins Q2 25 mins Q3 15 mins Q4 15 mins Q5 15 mins Q26 25 mins (+) Ready Accessibility: Investigate # ENG CMS Share 3:06 PM 2022-04-18 100%