2. From the following information: Units Date Purchased Unit Cost Total Cost 1-Jan 40 $4.00 $160.00 $160.00 1-Apr 60 $7.00 $420.00 $420.00 1-Jun 50 $8.00 $400.00 $400.00 1-Nov 55 $9.00 $495.00 $495.00 * Ending Inventory is 61 units. Using the following methods; 1. Weighted Average 2. FIFO 3. LIFO Calculate: (a) the Cost of Ending inventory (b) the Cost of Goods Sold 3. Given the following information, calculate the estimar Profit Method. Using MS Excel complete the problems: 1. Calculate the Final Selling Price (to the nearest cent and Markup percent to the nearest hundredth percent): Original Selling Price - $5,000.00 1st. Markdown -20% 2nd. Markdown - 10% 1st. Markup -12% Final Markdown -5% illu no more than $120.00