I have been having trouble doing this question I am currently using MS Excel and my student number is 245633.

Part 5 (Chapter 7 content) 12 Marks Pizzaworks Ltd, uses a perpetual inventory system and had the following activity for a single Inventory (premade pizza crusts) Item Units Units Total cos June 1 opening inventory 240 $350 5840 June 5 purchase asterom 400 $1200 June 10 purchase 250 5.20 $1.300 June 11 sale 400 June 15 purchase 260 5.75 51,495 June 19 sale 175 This company use the perpetual inventory sytet Required Using the FIFO method calculate the 1) cost of goods sold in number of unsad and 2) ending inventory din number of units and SRL Work is to be completed on the corresponding shoot in the Excel workbook, using the format provided TAKICH student number not used in this part Please provide descriptions and calculations. Revise format as needed to suit your style /formation of calculations 1) Total Cost of Goods Sold Date of sale / Quantities Sold Amounts/Calculations 1 2 3 4 15 16 17 18 19 20 21 2) Total Ending Inventory Quantities Amounts/Calculations +