The Average Price of the items purchased in each department during the queried period is  calculated as follows:

Dollar amount of sales

/  Divided by number of items

= Average Price