The following transactions occurred for the month of May. 25 points Cost per Sales Price Date Units Total Cost Unit per Unit 1-May Beginning Balance 60 12 $720 2-May Purchase 70 10 $700 3-May Purchase 85 11 $935 10-May Sale 15-May Purchase 17-May Sale 125 $30 30 18 $540 45 $30 30-May Sale 40 $30 Requirement: Calculate the Cost of Goods Availabe for Sale, Cost of Goods Sold, Ending inventory, and Gross Profit for the month using the FIFO method. If you find yourself getting stuck trying to complete this problem here is a link to a video of me solving a very similar problem. (Ignore any part that refers to My Open Math as these problems are now being done in these Excel spreadsheets.) Perpetual Inventory -FIFO- Demo/Example - YouTube Video End of the month totals: Cost of Goods Available for Sale Ending Inventory Total Sales Cost of Goods Sold Gross Profit 10000