Number Per of Unit Total Cost Units Cost 1,100 $10 $11,000 Beginning Merchandise Inventory on May 1 Purchases: May 7 May 18 May 26 Goods Available for Sale 1,040 1,200 1,360 4,700 $11 $11,440 $12 $14,400 $13 $17,680 $54,5201 On May 31, it was determined that 1,450 units remain on hand. Required: In the attached workpaper file, determine the total cost of goods sold and the total cost of the ending inventory using 1. First-In, First-out (FIFO) costing. 2. Last-In, First-out (LIFO) costing. 3. Weighted Average Costing Upload your completed workpaper here. Workpaper (PDF and Excel): Question 8 Workpaper First-In, First-Out Costing (FIFO) Ending Inventory Unit Units Cost Total Cost of Goods Sold Unit Units Cost Total Cost Cost Last-In, First-Out Costing (LIFO) Ending Inventory Unit Units Cost Total Cost of Goods Sold Unit Units Cost Total Cost Cost Weighted Average Casting Ending Inventory Unit Cost Total Cost of Goods Sold Unit Units Cost Cost Total Cost