Please Provide Answers Below On Excel Spreadsheet

(Learning Objective 2: Compare ending inventory and cost of goods sold by four methods) Use the data for Donovan, Inc., in Exercise 6-29B to answer the following.

▶ Requirements

• 1. Compute cost of goods sold and ending inventory using each of the following methods:
  • a. Specific unit cost, with five $170 units and four $180 units still on hand at the end
  • b. Average cost
  • c. FIFO
  • d. LIFO
• 2. Which method produces the highest cost of goods sold? Which method produces the lowest cost of goods sold? What causes the difference in cost of goods sold?
•  
•  

• Aug  1	Beginning inventory	5 units @ $170	=	$  850
  Aug 15	Purchase	7 units @  170	=	1,190
  Aug 26	Purchase	13 units @  180	=	2,340