Sales & Purchase Inventory Data Model
A relational data model in Excel with customers, suppliers, products and countries. Sales and purchase orders are entered through forms, stock levels update automatically and customs duty is applied by country.
- Industry
- Trading
- Deliverable
- Inventory Data Model.xlsm
- Built with
- Excel VBA, UserForms, Data modelling
More like this
Related projects
Staff Leave & Attendance Manager
Human Resources
Tracks staff attendance and seventeen leave types with yearly allowances. Monthly attendance grids, period and yearly reports and PDF and CSV exports are all generated by…
View project
Inventory Management System for Drilling Operations
Oil & Gas
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…
View project
Account Reporting Tracker
Food & Beverage Brokerage
A shared tracker for account managers. Each update entered on the form is sent to the internal database, a master log file and a separate file…
View project