
Open
Posted
•
Ends in 7 hours
Paid on delivery
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
Project ID: 40463814
19 proposals
Open for bidding
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
19 freelancers are bidding on average ₹8,371 INR for this job

Hello, Greetings of the day! I have a vast experience of working in Advanced Excel and I have completed many projects based on Advanced Excel. I have read your requirements and I can complete your project within time frame with proper and efficient work. I am a full time Freelancer and available to start your project immediately. I have an experience of below skills • Changing Raw Data into Presentable Data which can be easily under stood. • Use of Advanced Excel Formula • Data, Power Query, Tables & Formatting • Conditional Formatting • Advanced Charting • Pivot Tables & Pivot Reporting • VBA & Macros • Data Analysis • Anova analysis in Excel • Statistic & Modeling using Excel • Forecasting & Trend Analysis & many more …. I am ready to work on a Sample file also if required. Please initiate the chat so that we can discuss more about project and start the project. Thanks & Regards Sneh
₹7,000 INR in 2 days
6.1
6.1

I am a Noida based Excel & VBA Automation Expert with an MBA and 10+ years of experience delivering smart solutions to global clients (eg. Decathlon, E&Y, Schindler). I’ve successfully completed 100+ projects (4.9★ rating), helping businesses save time, reduce errors, and boost efficiency. I can create excel based automated production management tool as per your requirements mentioned in the project description. I have already created a similar production management tool for a Mumbai based company. Lets chat and discuss the details further. Looking forward to working with you!
₹1,500 INR in 1 day
5.9
5.9

As an expert in Excel and specialized in VBA programming, I believe I am the ideal candidate for your project. With my extensive knowledge in data processing, strong aptitude for automation, and deep understanding of your requirements, I can create a comprehensive, user-friendly and fully-functional Production Management System for your Injection Moulding unit. I have a proven track record of delivering high-quality projects involving similar complex modules and features - from purchase & inward management to material consumption, finished goods dispatch, and advanced data analysis. My mastery over Excel's functions, formulas, formatting, timelines, pivot tables, charts & graphs will give you the power to effectively manage each step of your production process with ease. Having worked with top-notch clients like you has sharpened my skills in ensuring accuracy and quick turnaround time. While delivering value is my prime objective, keeping you satisfied upon receiving the final product is equally important to me. Therefore, I offer unlimited revisions to ensure we meet your specific needs. Trust me with this project and rest assured you'll get more than just a well-functioning system! You'll get a partner committed to your project's success.
₹7,000 INR in 1 day
5.2
5.2

I have done a similar project a week ago. I am sure you will give me more projects after this. I am interested to do this project too and ready to complete this within the timeline. Kindly check my profile to see all rating and reviews given by clients. Hoping to hear from you soon. Payment after completion.
₹7,000 INR in 1 day
5.0
5.0

Hi there, I will build a production-management Excel workbook tailored for injection moulding covering purchase/inward, machine/shift/operator entries, WIP, BOP parts and finished-goods with automated stock and lot tracking , I’ve delivered similar VBA-driven plant trackers and know Excel formulas, VBA and dashboarding needed for this scope. - Deliverable 1: Complete multi-sheet Excel system (Purchase/Inward, Daily Production, BOP, WIP, Quality, FG & Dispatch) with formulas, lot-wise stock and auto-update macros. - Deliverable 2: Interactive dashboard with KPIs, charts, machine-efficiency, rejection & downtime reports, and printable reports per date/machine/part. - Risk/QA: Backup checkpoint + staged deployment and post-deploy validation on sample data. Skills: ✅ Excel VBA ✅ Excel formulas & macros ✅ Inventory & lot tracking workflows ✅ Production reporting & dashboarding ✅ Stock management / WIP / BOP tracking Certificates: ✅ Microsoft® Certified: MCSA | MCSE | MCT ✅ cPanel® & WHM Certified CWSA-2 I’m available to start immediately. Do you want the workbook to use a single shared file on a network/SharePoint or split into user-specific files with a master consolidation? Best regards,
₹12,069 INR in 1 day
3.5
3.5

With a proficient academic background in actuarial science coupled with practical and intern experience, I have developed remarkably adept skills in Excel that promote efficiency, accuracy, and intelligent data usage. I have immense experience crafting comprehensive formula systems, pivots, automations et. al in Excel. My dexterity is further enhanced through my familiarity with VBA/macros. From your project description, I fully comprehend the extensive modules and features you require. My work methodology aligns seamlessly with this; I will develop separate sheets for each module/feature to promote easy navigation and use. Dashboards will be thoughtfully designed with charts and KPIs. All reports will auto-generate and be easily accessible via search bar. Ultimately, I amend each project to specifically suit client requirements. Alongside delivering the entire requested scope of this project, I'll also implement extra features to better enhance productivity and ensure client satisfaction.
₹7,000 INR in 7 days
3.7
3.7

Hi, I do have some questions, but here's what I can do for you: - Build a fully automated Excel system with interconnected modules so entering a production entry or inward shipment instantly updates stock, consumption, and dashboards with zero manual recalculation - Design VBA macros that handle the heavy lifting — auto stock updates, search and filter across sheets, and one-click report generation — so your team spends time on decisions, not data entry - Create a KPI dashboard with live charts for machine efficiency, rejection rates, and material balance that updates in real time as data flows in - Structure each module on its own sheet with clear navigation so adding new machines, parts, or suppliers later doesn't break anything - Include validation and error handling so incorrect entries get flagged before they ripple through the system Send me a message, let's discuss.
₹7,000 INR in 7 days
3.4
3.4

Hello! I can build this Excel-based Production Management System for your injection moulding unit with separate modules for inward, production, material consumption, WIP, quality, finished goods, and a clear dashboard with formulas, automation, and VBA where needed. The workbook will be user-friendly, easy to update, and designed with search/filter options, auto stock updates, KPI reports, and machine-wise analysis as per your requirement.
₹7,500 INR in 7 days
2.7
2.7

Hi! I'm Sudhir Jain — MIT graduate, Data Analyst & BI specialist with hands-on Excel and VBA expertise. I can build your complete Injection Moulding Production Management System with all 10 modules including automated formulas, macros, and KPI dashboards. Delivery in 7 days. 100% on-time track record!
₹7,000 INR in 7 days
2.0
2.0

Hi, Have you considered how you’d like the dashboards and reports to be structured? I can create an Excel-based Production Management System tailored for your injection moulding unit with all required modules. My approach includes automating data management and analysis through VBA and macros to make the process streamlined and user-friendly. From managing purchases to production tracking and generating insightful reports, I can ensure each module is designed for optimal efficiency. Additionally, I have extensive experience in Excel and VBA, which will help in creating a robust system that meets your needs. For the timeline and cost, I’d need to understand your specific requirements better. Feel free to reach out if you’d like to discuss further! Best Regards, Salman Malik
₹2,000 INR in 4 days
1.7
1.7

Hi, I am Syed Taha Hussain, and I would love to build this injection moulding Production Management System for you. Automated spreadsheet modeling and technical data structure are my primary skills. I am a data analyst with extensive experience designing custom workbooks that simplify complex tracking into high performance tools. I am an expert in creating dynamic multi sheet systems, specialising in complex formulas and automated dashboards that link diverse operational modules. I have a strong background in developing intricate tracking systems including 12 sheet inventory and fee models, ensuring that daily production, raw material inwarding, and WIP entries automatically update stock balances and KPIs without manual recalculation. I have successfully executed several technical projects requiring absolute precision and professional data visualisation . You can message me in the chat so we can discuss your specific machine counts and parts list to finalise the timeline immediately.
₹6,500 INR in 5 days
1.3
1.3

My extensive experience in software development, including using Excel to create complex systems and incorporating VBA/macros where necessary, will be a huge asset for your project. I have a deep appreciation for automation, data processing and the creation of user-friendly solutions; skills that will be invaluable for the modules and features you desire. My approach to development emphasizes thorough understanding of client needs, attention to detail and efficient problem solving. My goal is to not only meet but exceed client expectations. Finally, consider my profile as an example of the versatility and depth of skills I bring to the table. Having worked across multiple domains and technologies, I have cultivated a comprehensive mindset that enables me to adapt quickly to new projects. Trust me with your project, as my commitment is not just about delivering a system but providing a solution that has a positive impact on your operations. Let's discuss further details and make this project a success together!
₹1,500 INR in 7 days
0.0
0.0

Hi, I can help with an Excel-based production management system that fully tracks purchase inward, machine-wise production, WIP, quality, material consumption, and dispatch with live dashboards. I’ll start by mapping your required sheets/modules and key data fields, then build formulas for auto stock updates plus VBA/macros only where automation is needed. To reduce risk, I’ll deliver an early read-only prototype for review (sample entries, dashboards, and reports) and iterate quickly. Which columns/IDs do you use for lot/batch and machine/shift/operator? Also, do you want the dashboard to show cycle time, downtime, and rejection KPIs daily or per shift? Reply with your preferred timeline and I’ll propose a clear build plan.
₹8,478 INR in 3 days
0.0
0.0

Hello, I can develop a complete Excel-based Production Management System tailored for your Injection Moulding manufacturing unit with automation, dashboards, formulas, and VBA/macros where required. The system will include all requested modules such as Purchase & Inward Management, Daily Production Records, Machine Analysis, Material Consumption, BOP Tracking, WIP Management, Quality Control, Finished Goods & Dispatch, and automated Reports & Dashboards. Key features: ✔ User-friendly Excel interface ✔ Automated stock updates & calculations ✔ Machine-wise, shift-wise, operator-wise production tracking ✔ Downtime, rejection, and efficiency analysis ✔ Raw material & scrap consumption tracking ✔ Dashboard with KPIs, charts, and summaries ✔ Search/filter functionality for fast data access ✔ Separate modules/sheets for clean workflow ✔ VBA/macros for automation and reduced manual work I specialize in Excel automation, production MIS systems, dashboards, and process optimization. The final workbook will be structured, fast, easy to audit, and ready for daily operational use. Estimated Timeline: 10–15 days (depending on final scope) Cost: Can be discussed based on detailed requirements and automation level. Looking forward to working with you. Thank you 9727721648
₹10,000 INR in 15 days
0.0
0.0

As a multifaceted and seasoned developer with over a decade of professional experience, I am confident in my ability to deliver a fully-functional and high-performing Excel-based Production Management System tailored to your specific needs. Proficient in key areas such as formulas, automation, dashboard design, and VBA/macros, I will ensure all modules you've requested — Purchase & Inward Management, Daily Production Record, Machine & Production Analysis, Material Consumption, BOP Part Tracking,WIP Tracking, Quality Module and Finished Goods & Dispatch— are robustly integrated and optimized for user efficiency. Don't hesitate to entrust this project to me; let's build a system that not only meets your expectations but also one that contributes significantly to the efficiency and productivity of your manufacturing unit!
₹12,000 INR in 7 days
0.0
0.0

Ten modules with live stock cascading from Purchase through WIP to Finished Goods means the architecture choice matters before a single cell is built. If Purchase inward doesn't auto-feed Material Consumption and WIP correctly, every downstream report breaks. I've built manufacturing trackers in Excel/VBA before: shift-wise production logs with efficiency calcs, rejection tracking, and auto-updating dashboards. The pattern that works is named ranges plus a central data sheet per module, with all reporting pulling from a single aggregation layer so the dashboard stays clean regardless of who does the entry. For 10 modules at this scope (lot/batch tracking, cycle time analysis, BOP balance, WIP stage-wise, dispatch), I'd structure it across two milestones: M1: Purchase/Inward, Daily Production, Material Consumption, BOP Tracking, WIP. INR 11,000. 4 days. M2: Machine Analysis, Quality, Finished Goods/Dispatch, Dashboard + KPIs, full testing. INR 11,000. 3 days. Total: INR 22,000, 7 days. The posted budget was INR 12,500. I can't build all 10 modules at that rate without cutting corners on the VBA automation or the dashboard layer. INR 22,000 reflects the actual scope, and I'm happy to phase delivery if the budget needs to flex. One question before I start: how many machines and shifts are in scope? That shapes the daily production entry form significantly.
₹22,000 INR in 7 days
0.0
0.0

Manesar, India
Payment method verified
Member since Dec 4, 2025
₹1500-12500 INR
₹1500-12500 INR
₹1500-12500 INR
₹600-1500 INR
₹1500-12500 INR
$2-8 USD / hour
$10-30 USD
$17 CAD
₹400-750 INR / hour
₹600-601 INR
$30-250 AUD
$30-250 USD
£10-15 GBP / hour
$30-250 USD
₹1500-12500 INR
$250-750 AUD
₹750-1250 INR / hour
$30-250 USD
₹750-1250 INR / hour
₹750-1250 INR / hour
$17 CAD
₹600-1500 INR
$250-750 USD
$60-100 USD / hour
₹750-1250 INR / hour