Question: What formula do I enter in cell B19 in order to calculate the ending inventory balance under the Weighted Average Method ? Please help AutoSave

What formula do I enter in cell B19 in order to calculate the ending inventory balance under the Weighted Average Method? Please help
AutoSave Off EA4-A1-Inventory-AlexandraBecker Search File Home Insert Draw Page Layout Formulas Data Review View Help Calibri 11 ~AI = ale Wrap Text Custom X Cut Copy Format Painter Paste B I U A E Merge & Center $ - % - F Clipboard Font Alignment Number B19 fic A B E F Document Recovery Units in Ending Inventory: 571 Excel has recovered the following files. Save the ones you wish to keep. 4 Methods to be used: Last-In, First-Out 6 First-In, First-Out 7 Weighted Average 8 Cost per EA4-A1-Inventory-Alexan... x Version created last time the... 4/17/2021 2:59 PM 9 Units 490 127 COA-ABC-Stitching-and-... x Version created last time the... 4/9/2021 8:25 AM 240 Unit Total $ 14 $ 6,860 $ 15 $ 1,905 $ 17 $ 4,080 $ 18 $ 1,530 $ 19 $ 9,595 $ 23,970 85 505 Opening-Balances-ABC-S... Version created last time the... 4/9/2021 8:25 AM 1447 10 Beginning Inventory 11 Purchase #1 12 Purchase #2 13 Purchase #3 14 Purchase #4 15 16 17 Last-In, First-Out Inventory Balance 18 First-In, First-Out Inventory Balance 19 Weighted Average Inventory Balance 20 21 https://d.docs.live.net/40... Version created last time the... XE $ $ 16,644 12,264 XH Final-Project-Workbook (... Version created from the last... 3/25/2021 9:19 AM
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
