Best Math Formula website. Search anything about Math Formula in this website.
how to find weighted average ending inventory. Units in ending inventory Total units available for sale Total units sold during the period. 170 x 13733 2334610 in COGS.
How To Find A Weighted Average Cost Ending Inventory Value Microsoft Office Wonderhowto from ms-office.wonderhowto.com
The value of ending inventory is the number of units remaining multiplied by the average cost at the time of the last sale in this case 826. To calculate the ending inventory the new purchases are added to the ending inventory minus the cost of goods sold. 3400 units 400 units 500 units 1400 units 200 units 3400 units 2500 units.
The numbers may be slightly off due to rounding off.
To find the cost of goods available for sale youll need the total amount of beginning inventory and recent purchases. 3 Weighted. Some more sophisticated options allow for FIFO or LIFO. Beginning inventory Purchases - Cost of goods sold Ending inventory.
