Using MS Excel complete the problems: Using the "Specific Identification" inventory method, calculate: (a) The Ending inventory, b) The Cost of Goods Sold. Based on the following: 1. Units Date Purchased Unit Cost Ending Inventory 1-Jun 15 1-Oct 25 1-Dec 35 $150.00 3 units $175.00 6 units $200.00 9 units