Spelling Company had the following transactions in connection with their inventory account during the month of August: Instructions 1. Calculate the total number of ending inventory units. (This number will be used for all methods and assumptions) a. Assuming that the compary keeps perpetual records in units only, compute the inventory August 31, using (1) UFO, (2) FIFO and (3) average cost (the periodic method) b. Assuming that perpetual records are kept in dollars, compute the inventory at August 31 using (1) LFFO, (2) FIFO and (3) average cost (the perpetual method) c. Calculate the cost of goods sold Spelling Company should record for the month of August assumning the periodic inventory method for (1) LIFO; (2) FIFO and (3) average cost. d. Calculate the cost of goods sold Spelling Company should record for the month of August assuming the perpetual inventory method for (1) UFFO, (2) FiFO and (3) average cost 3. Calculate the Gross Profit for HFO and FFFO under the periodic method You are to create worksheets within this document that calculate the requested information provide for above I must see your work in order to give full credit This is your opportunity to flex your Excel muscile and utiize this poweiful software to help