Home > Excel Business Solutions > Operations and Management > Supply Chain and Inventory > Inventory Management Share

Inventory Management

Excel inventory management for supply chain and inventory

Excel Inventory Management

Rate this solution:
(3.2/5 from 8 votes)
Inventory Management screenshot
Excel based inventory management templates include: Economic order quantity, EOQ with back orders, EOQ with quantity discounts, EOQ for production lot sizes, and Reorder points and safety stocks (ROP).

The purpose of the EOQ model is simple, to find that particular quantity to order which minimizes the total variable costs of inventory.

Back orders are common in inventories held for resale to customers. The EOQ model can be modified to handle back orders by including one more cost, the cost per unit back ordered.

Use the modified EOQ model for production lot sizes to ensure that the EOQ is larger than maximum investment to account for sales made during the production run.

When demand is uncertain, inventory investment from the EOQ model should be supplemented with safety stock. The Reorder points and safety stocks (ROP) template can be used to compute safety stocks and reorder points.

Try It  Get It

(Pricing is available on the next page)
(Updated on 2018-02-01)

Related Excel Solutions for Inventory Management

Inventory SchedulingSupply Chain and Inventory  Inventory TrackingSupply Chain and Inventory  Inventory AccountingSupply Chain and Inventory  Economic Order Quantity (EOQ) TemplateSupply Chain and Inventory

Share your thoughts and opinion with other users: Create Review

Browse Main Excel Solution Categories

Business Finance Financial Markets Operations Management Excel Productivity

Additional Excel business solutions are categorized as and the . Further solutions proposed for specific user requirements can be either found in the Excel Help Forum.