Question

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

Answer 1

	Units	Unit cost	Amount
01-Jan	5	2	10
Apr-10	10	2.5	25
May-15	12	3	36
Jul-22	15	3.25	48.75
Aug-19	18	4	72
Sep-30	20	4.2	84
Nov-10	32	4.4	140.8
Dec-15	16	4.8	76.8
Cost of goods available for sale	128		493.35
Ending inventory	49
Sales	79
LIFO
Ending inventory	Units	Unit cost	Amount
01-Jan	5	2	10
Apr-10	10	2.5	25
May-15	12	3	36
Jul-22	15	3.25	48.75
Aug-19	7	4	28
Total	49		147.75
Cost of goods available for sale	128	493.35
Ending inventory	49	147.75
Cost of goods sold	79	345.6