Dashboards & Reporting Management Systems

Inventory Management System for Drilling Operations

A complete materials and inventory workbook for a drilling services company. It links every well design to the chemicals and cement it consumes, tracks monthly usage per rig, calculates reorder quantities from lead times and reports cost of goods sold and revenue.

Industry

Oil & Gas

Deliverable

Inventory Management System.xlsx

Built with

Excel formulas, Lookup models, Charts