Please provide answers in excel spreadsheet format along with the (show formal) format.

Please provide answers in excel spreadsheet format along with the (show formal) format.

EXTRA PRACTICE QUIZ WITH WORKED-OUT SOLUTIONS LU 18-2 Need more practice? Try this sxtra Practice Qulz (check 1. From the followi the cost ratio to the nearest tenth percent): ng. calculate the cost of ending inventory using the retail method (round es in the Interactive Chapter January 1-inventory at cost January 1--inventory at retail Net purchases at cost Net purchases at retail Net sales at retail $ 19,000 60,000 265,000 392,000 375,000 be found in Appendix Bat can end of textd 2. Given the following, calculate the estimated cost of ending inventory using t profit method: Gross profit on sales Beginning inventory, January 1, 2017 Net purchases Net sales at retail for January 30% $30.000 S 8,000 S16,000