Answer using Ms excel !

The Alto Shop company using the LCNRV (Lower of Cost or Net Reliazable Value) method has data as of December 31, 2020 as follows:

Type product Unit Unit Cost Reliazable Value

Computer:

Asus 5 $ 170 $ 156

Lenovo 6 $ 150 $ 152

Printer:

Canon 10 $ 125 $ 115

HP 14 $ 120 $ 135

Requested: 1. What is the value of the company's ending inventory? 2. If Lenovo computers are sold as many as 4 units at a price of $ 225 / unit and Canon printers 5 units at a price of $ 180. Calculate how much gross profit will be obtained by the company using this LCNRV method!