Please put in excel spreadsheet and please show formula and answers. Thank you.

EXTRA PRACTICE QUIZ WITH WORKED-OUT SOLUTIONS Need more practice? Try this Extra Practice Quiz (check 1. In 2015, Rancho Corporation bought semiconductor equipment for $90,000.U MACRS, what is the depreciation expense in year 3? eractive Chapter 2. What would depreciation be the first year for a wastewater treatment plant that cog Organizer). Worked-out Solutions an be found in Appendix B at nd of text. $900,000? The auestions below go together. From the following, (18-5 to 18-12) calculate the cost of ending inventory and cost of goods sold for the LIPO (18-13y (18-14), and weighted-average (18-15) methods (make sure to first find total cost to complete the table); ending inventory units: LU 18-1(2) Unit cost Total dollar cost Beginning inventory and purchases Units 18-5. Beginning inventory, January1 18-6. April 10 18-7. May 15 18-8. July 22 18-9. August 19 10 12 15 18 20 32 16 $2.00 2.50 3.00 3.25 4.00 4.20 4.40 4.80 18-10. September 30 18-11. November 10 18-12. December 15 18-13. LIFO: Cost of ending inventory Cost of goods sold