Help solve these charts. Show work, Thanks!

ACCOUNTING 3313 Third Opportunity for Excellence - Review Exercise Klett Company's records show the following for the month of September: Units Unit Cost Total Cod Units en Hand Balance on September 100 $50 $5,000 100 Purchased on September 10 so SS 52.750 150 Sold on September 14 100 50 Purchased on September 16 60 60 53.600 110 Sold on September 20 7 5 In the spreadsheet provided to answer this exercise, there are three worksheets - the first for FIFO in a perpetual system, the second for LIFO in a perpetual system and the third for average cost in a perpetual system. Required: Compute Klett's 1) total cost of goods sold and 2) ending inventory balance in a perpetual system using the cost flow method specified in each respective worksheet of the spreadsheet provided to answer this exercise. Note the following: Study the other spreadsheet posted along with both these instructions and the spreadsheet for this exercise. The other spreadsheet contains the solution to the Chapter 8 exercise on FIFO, LIFO and average cost in a perpetual system. Study the worksheets in that spreadsheet to gain insight on how to provide your answer to this exercise in the spreadsheet provided. o Do not use Excel functions to compute your answers. Simply type in your answers, showing all work, following the style of form and content of the other spreadsheet provided containing the solution to the Chapter 8 exercise o Round cost per unit calculations to four decimal places and total cost calculations to two decimal places