asked on

Inventory Balance Calculation

Inventory Balance Calculation

I am running into a situation where we're trying to re-organize our inventory supply to satisfy our inventory demand. The demand changes frequently, so we need a quick way to re-align supply accordingly. At present, this is a tedious task when you consider we manufacture about 10K active parts. Please see the attached sheet for more detail and examples. This one should be a challenge.

thanks!
edm iv-mrp-part.xlsx

ASKER CERTIFIED SOLUTION

ComputerAidNZ

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wellous

Hi Emil,

Check this articles , they explain in details how to use Excel to calculate the Inventory.
http://www.computorcompanion.com/LPMArticle.asp?ID=161
http://www.inventoryops.com/safety_stock.htm

Also here you can find some Excel templates of Intevntories to get the ideas ..
Download them free :)
http://exceltemplates.net/inventory/inventory-system-comparison/
Good luck

wellous

Emil,

There is also a tool called : EOQ Inventory Calculator for Excel tool
to calculate the inventory you just input required numbers of holding cost, units sold, ordering cost, and this EOQ Inventory Calculator for Excel tool will automatically calculate all inventory metrics and create charts.
Here is the link to download a trail or buy the full version.
http://www.top-software-reviews.com/2009/eoq-inventory-calculator-for-excel-08-31.html

Here are some other free templates for Orders and inventory calc:
http://dotxls.com/free-excel-templates/free-excel-templates---orders-and-inventory

Brgds
Wellous