Problem $7-2($Algo$)$

The following table contains data about the inventory for five items at Jones Corporation. Complete the missing Items in the table. $($Round your Inventory turnover values to $3$ decimal places.$)$

Pictureclick here for the Excel Data File

$\backslash$table$[[$Item #$,\backslash$table$[[$Beginning Unit$],[$Inventory$]],\backslash$table$[[$Ending Unit$],[$Inventory$]],\backslash$table$[[$Average Unit$],[$Inventory$]],\backslash$table$[[$Annual Unit$],[$Sales$]],\backslash$table$[[$Inventory$],[$Turnover$]]],[1,300,000,270,000,,550,000,],[2,55,000,75,000,,95,000,],[3,100,000,112,000,,340,000,],[4,350,000,320,000,,500,000,],[5,65,000,75,000,,240,000,],[$Total$,,,,,]]$

Average inventory turnover