please solve with formulas

AutoSave Week Excel Practice Problems ile Han Vine Insert Formus Page Layout Review Waplo General X IS- - Bree- Castro 11AA Buna A- Paste Menje Center - $ % 3 Conditional Formats Cel Formatting Table Styles Slyse Cels Number Opbd Tent U2 K M G D Help Leroy at Southern Regional Hospital cakulite his inventory value for each month in 2017 Also calculate yearly wages for his food costs, inventory turnovers, and inventory value Inventory valve 4.0 3.5 16 12 3 LY Sreby 5 March April MAY 9 Nune 10 ruly 11 A 12 September 13 October 14 November 16 December Food contentory 524. $21.005.00 56125.00 $200 $2,15700 524164.00 SOS. 712.00 $94.000 $21.777.00 322.214.00 35.00 40 4: 4.0 X 11 AW SI According to the standard rooster inventory turope According to the standard in your book o'storming van appropriate umber of times per month Watch when inventory does not turn over frequently Help Leroy at Southern Regional Hospital calculate his inventory value for each month in 2017. Also 1 calculate yearly averages for his food costs, inventory turnovers, and inventory value. 2 3 4 January 5 February 6 March 7 April 8 May 9 June 10 July 11 August 12 September 13 October 14 November 15 December Inventory Food cost inventory turnovers value $24,830.00 4.0 $21,005.00 3.5 $26,475.00 4.6 $25,893.00 4.2 $23,157.00 3.9 $24,364.00 4.0 $25,734,00 4.1 $24,369.00 4.0 $23,777.00 3.9 $22,284.001 3.6 $25,384.00 4.2 $26,585.00 4.6 17 Average 18 Adinathartandani hatari santa RARE According to the standards given in your book, is Leroy's inventory turning over an appropriate number of times per month? What issues can arise when inventory does not turn over frequently enough? 19