Hey, can you help me with this question. Thanks

AutoSave AA 2 OF... OFF Week4_Perpiny_Moving Aver_Student Template7 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (body) v 11 v P A a Wraa Text General v Insert v 5 X [G AYO AY Delete Paste B 1 Uv VA = = - - Merge & Centre Y Conditional Format Cell Formatting as Table Styles Sensitivity Format Sort & Filter v Analyse Data Find & Select y D29 . fx A B C D D E F G H 1 J L M N 0 0 R S T 1 2 Week 4 PERPETUAL INVENTORY SYSTEM & MOVING AVERAGE COST METHOD 3 4 5 Required; 6 Using the information provided determine the cost of ending inventory and the cost of sales 7 NB: Calculate moving average unit costs to 4 decimal places. 8 Data Section 9 Date 9 Particulars Units Unit Cost 10 May-01 O/Inventory 80 $7.00 11 3 Purchased 90 $8.00 12 10 Purchased 110 $9.00 13 12 Sold 90 units 14 17 Sold 80 units 15 25 Sold 30 units 16 17 Solution; 18 Purchased Sold Balance 19 Tota Total Total 20 Quantity Cost Quantity Cost Quantity Cost 21 May-01 Balb/d 22 23 24 Unit Cost 25 26 27 28 29 30 31 32 33 Sheet1 + + 125% %