The assignment must be uploaded into the Moodle before the deadline. Use Excel, Word or PDF. Another formats will not be accepted. Each transaction is worth 0,5 point and also 1 point for proper value of ending inventory and cost of sales. Please check the formatting before submitting the work. Required: Calculate ENDING INVENTORY and COST OF SALES using LIFO and weighted average method. Show all calculations. Material X supplementary ledger information Transaction Type of transaction 1. / 01.03.2020 opening balance 2./05.03.2020 purchase 3. / 10.03.2020 sale 4./ 22.03.2020 purchase Number of units 100 units 40 units 80 units 10 units Purchase price / unit $2,50/unit $3,00/unit $4,50/unit