Excel-Based Production Management Development

Hello,

I need an Excel-based Production Management System for an Injection Moulding manufacturing unit.

The project should be fully developed in Microsoft Excel with formulas, automation, dashboard, and VBA/macros if required.

Required modules/features:

1. Purchase & Inward Management

* Purchase inward entry
* Supplier-wise inward tracking
* Raw material inward
* BOP part inward
* Invoice/challan tracking
* Lot/batch tracking
* Auto stock update

2. Daily Production Record

* Machine-wise production entry
* Shift-wise production
* Operator-wise production
* Part-wise production quantity

3. Machine & Production Analysis

* Cycle time tracking
* Production loss tracking
* Machine stop/breakdown loss
* Rejection loss tracking
* Machine efficiency report

4. Material Consumption

* Raw material consumption
* Scrap tracking
* Material balance report

5. BOP Part Tracking

* BOP inward, issue, and balance tracking

6. WIP Tracking

* WIP inward/outward
* Stage-wise stock tracking

7. Quality Module

* OK quantity
* Not OK/rejection quantity
* Rework tracking

8. Finished Goods & Dispatch

* Finished goods stock
* Dispatch entry
* Balance stock after dispatch

9. Reports & Dashboard

* Auto-generated reports
* Production dashboard
* Stock summary
* Rejection & downtime reports
* Material consumption reports

10. Other Requirements

* User-friendly Excel format
* Automated formulas/macros
* Search & filter option
* Separate sheets/modules
* Dashboard with charts & KPIs

Please share:

* Timeline
* Cost
* Similar Excel project/demo if available

Thank you.
9050030489