Given:
sales=165250
sales return=980
sales discount=1960
beginning inventory=16880
purchases=108380
purchase return=390
purchase discount=1630
transportation in=700
gross profit=58210
net income=17360

find the ending inventory

My Answer is attached. It is in MS Excel format.
Hope this help.