Problem $9-2($Algo$)$ Lower of cost or net realizable value; by product, category, and total inventory $[$LO$9-1]$

Ace Hardware Store sells two product categories, tools and paint products. Information pertaining to its year$-$end inventory is as follows:

$\backslash$table$[[$Inventory$,$ by Product Category,Quantity,$\backslash$table$[[$Per Unit$],[$Cost$]],\backslash$table$[[$Net Realizable$],[$Value$]]],[$Tools:$,,,$$$5\mathrm{.}10$Problem $9-2($Algo$)$ Lower of cost or net realizable value; by product, category, and total inventory $[$LO$9-1]$

Ace Hardware Store sells two product categories, tools and paint products. Information pertaining to its year$-$end inventory is as follows:

$\backslash$table$[[$Inventory$,$ by Product Category,Quantity,$\backslash$table$[[$Per Unit$],[$Cost$]],\backslash$table$[[$Net Realizable$],[$Value$]]],[$Tools:$,,,$$$5\mathrm{.}10$