AutoSave OFF Chapter 8 Homework Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v > 2 AY 4 DX Delete Ideas Y Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter Find Select Farmatu Y T 1 j L L M N P Q X Calibri (Body) v 11 v AP a Wras Text General LG Paste B 1 A = = Merge & Center $ % DB4 A xv fx D E F F G H 81 82 12. Find the inventory value using the weighted average method, the FIFO method, and the LIFO Method. (5 pts) 83 84 Beginning Inventory: 23 Units @ $8 85 Purchases: 86 June: 16 units @9 87 August 10 units & 10 88 Ending Inventory 20 units 89 90 Inventory Value using Weighted Average: 91 Inventory Value using FIFO Method: 92 Inventory Value using LIFO Method: 93 94 95 95 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 Sheet1 + Ready + 30% AutoSave OFF Chapter 8 Homework Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Insert v > 2 AY 4 DX Delete Ideas Y Conditional Format Cell Formatting as Table Styles Sensitivity Sort & Filter Find Select Farmatu Y T 1 j L L M N P Q X Calibri (Body) v 11 v AP a Wras Text General LG Paste B 1 A = = Merge & Center $ % DB4 A xv fx D E F F G H 81 82 12. Find the inventory value using the weighted average method, the FIFO method, and the LIFO Method. (5 pts) 83 84 Beginning Inventory: 23 Units @ $8 85 Purchases: 86 June: 16 units @9 87 August 10 units & 10 88 Ending Inventory 20 units 89 90 Inventory Value using Weighted Average: 91 Inventory Value using FIFO Method: 92 Inventory Value using LIFO Method: 93 94 95 95 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 Sheet1 + Ready + 30%