Manager is using perpetual weighted average costing method to calculate cost of each sold item.
See: What inventory system is adopted by Manager?
What do you mean by wanting “total value of what is left to sell”? Inventory on hand asset account shows this.