How to calculate the stock month inventory

**jolin** · 03-07-2020, 12:36 AM

Hi,

I need help to formulate formula to be able to calculate the months of coverage.
Base on the stock on hand and the Mar to May requirement, How many months of inventory can I cover now?

Capture.JPG

**bebo021999** · 03-07-2020, 12:45 AM

Try:

Please Login or Register  to view this content.

**jolin** · 03-07-2020, 02:48 AM

Thanks Bebo

Can it display with 1 decimal. Eg 1.3 or 0.4

How to calculate the stock month inventory

LinkBack

Thread Tools

Rate This Thread

Display

How to calculate the stock month inventory

Re: How to calculate the stock month inventory

Re: How to calculate the stock month inventory

Thread Information

Users Browsing this Thread

Similar Threads

calculate the inventory available each month without affected to the coming months

[SOLVED] lookup and calculate stock taken from inventory

[SOLVED] Inventory management how to deduct stock from sheet 1 and amend stock value on sheet two

I need a stock order sheet to be created from a stock inventory

Stock inventory, subtract purchased stock from current stock and continue with second row

How do you calculate 12 month forward return of a stock

Inventory Stock Balancing with Inventory Data

Bookmarks

Bookmarks

Posting Permissions