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
Before
Chemical and cement usage was tracked per well in loose sheets, so reorder timing and cost of goods were guesswork.
After
Every well design is linked to the materials it uses, usage per rig is tracked monthly and reorder quantities follow lead times.
More like this
Related projects
Property Management Rent Ledger
Property Management
A rent and landlord statement system. Each property has its own ledger of rent, fees, VAT and landlord payments, statements are imported, and the dashboard totals…
View project
Counselor Service Hours Report
Healthcare (Behavioral Health)
A counselor selector report that shows, for any week, how many minutes of individual, group, treatment coordination and peer support each assigned client received, with alerts…
View project
Invoice Generator with Customer & Product Database
Wholesale Distribution
An invoicing system for a skincare wholesaler. Invoices are created from customer and product databases, saved, searched, reloaded and printed, and a best-selling report is updated…
View project