inventory valuation

  1. H

    FIFO/LIFO inventory valuation

    I am working on a project for an Excel/VBA course that requires us to take purchase/sell data and determine the value of the remaining inventory at the end of the month by 4 methods: averaging, specific ID, LIFO and FIFO. We are completely stuck on FIFO/LIFO and honestly don't even really know...
  2. B

    Averaging Liquid Inventory Price on a 1st in 1st out basis

    I am trying to build a spreadsheet that would average the inventory that we currently have stored. As our inventory is constantly changing, I need to know at any given time the cost of what is in inventory based on a percentage (liquid). Ideally I would like to enter a percentage of what we have...
  3. Q

    Weighted Average Cost for Inventory & Cost of Materials Used

    I am trying to value inventory and cost of materials used using the weighted average costing method. This is how it works in theory: When using the weighted average method, divide the cost of raw materials available by the number of units available, which yields the weighted-average cost per...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top