Given the data below answer the question. E F G H J Inventory Turnover Ratio Ending Inventory

Given the data below answer the question.

Transcribed Image Text:

E F G H J Inventory Turnover Ratio Ending Inventory (Dec. 31st) $50,000 Month Ending Inventory Cost of Goods Sold Inventory Turnover Ratio Formulas January February March April 0 May 1 June $55,000 $89,000 $89,000 $1,200,000 #N/A #N/A $80,000 $940,000 #N/A $52,000 $760,000 #N/A $79,000 $950,000 #N/A $85,000 $830,000 #N/A 2 July $160,000 $554,000 #N/A 3 August $215,000 $1,341,000 #N/A 14 September $63,000 $989,000 #N/A 15 October $106,000 $800,000 #N/A 16 November $169,000 $1,300,000 #N/A 17 December $42,000 $1,020,000 #N/A 18 19 Total COGS #N/A 20 21 Mean of the 12 monthly inventory averages #N/A 22 23 Annual invetory turnover ratio #N/A 24 25 Annual invetory turnover ratio (without the monthly ending inventory data) #N/A 26 27 Sheet1 + Workbook Statistics -18C Cloudy Q Search Give Feedbac ENC E F G H J Inventory Turnover Ratio Ending Inventory (Dec. 31st) $50,000 Month Ending Inventory Cost of Goods Sold Inventory Turnover Ratio Formulas January February March April 0 May 1 June $55,000 $89,000 $89,000 $1,200,000 #N/A #N/A $80,000 $940,000 #N/A $52,000 $760,000 #N/A $79,000 $950,000 #N/A $85,000 $830,000 #N/A 2 July $160,000 $554,000 #N/A 3 August $215,000 $1,341,000 #N/A 14 September $63,000 $989,000 #N/A 15 October $106,000 $800,000 #N/A 16 November $169,000 $1,300,000 #N/A 17 December $42,000 $1,020,000 #N/A 18 19 Total COGS #N/A 20 21 Mean of the 12 monthly inventory averages #N/A 22 23 Annual invetory turnover ratio #N/A 24 25 Annual invetory turnover ratio (without the monthly ending inventory data) #N/A 26 27 Sheet1 + Workbook Statistics -18C Cloudy Q Search Give Feedbac ENC