Ch06-Excel Drawing Tools Page Layout Formulas Data ReviewView FormatTell me what you want to do Sign in Share Equation . 2 Symbol PivotTable Recommended Table Pictures Online PivotChart 3D Line Column Win Slicer Timeline Hyperlink Text Header Box Footer My Add-ins Recommended Charts- PivotTables Pictures Shape 4 16 Food 19 20 a. What was the average food inventory for Answer: b. What was the average beverage inventory for Gene's operation? 24c. How many times did Gene turn his food inventory in the accounting period? 25 Answer: 26 27 d. How many times did Gene turn his beverage inventory in the accounting period? 28 e. What would likely be the cause of the difference between Gene's food and beverage 30 inventory turnovers? 1 Answer 32 35 36 37 Q1 Q3 Q5 100% 1:48 PM 4 n/2019 . Ch06 - Excel Insert Page LayoutFormulasData Review View Tell me what you want to do. Sign in Share s Cut E Copy AutoSum . A Fill Merge & Center. $. % , 4% Conditional Format as Cell Formatting TableStyles Paste Insert Delete Format Sort &Find & Filter Select 1 u. | EE.. 2.. Format Painter Font Alignment Cells Editing F15 1 Chapter 6, Question 3 3 Product 4 Food 5 Bevera 6 Product Usage 7 Cost of Food Used 8 Cost of Beverage Used innin Endin $11,300 $5,750 $8,700 $6,250 122,000 28,000 10 11 AVERAGE INVENTORY 12 Food 13Bevera 14 15 INVENTORY TURNOVER 16 Food 17 Bevera 18 19 a. What was the average food inventory for Gene's operation? 20 Answer: 21 22 b. What was the average beverage inventory for Gene's operation? Q1 Q3 Q5 - + 100% 1:28 PM d.al. 5/7/2019