
In Progress
Posted
Paid on delivery
I need an automated Excel-based stock register tailored for a garment manufacturing company. The register should manage raw materials, finished goods, and job work processes. It must include a summary with automated calculations and dynamically update changes across sheets when selecting products with different sizes. It should also track materials sent for stitching (including packing materials), record items received back after stitching, and manage sales of finished goods. The solution should be user-friendly and efficient for inventory management.
Project ID: 40764040
9 proposals
Remote project
Active 6 hours ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Garment Manufacturing Stock Register — Raw Materials, Job Work, and Finished Goods Here is exactly how I will build this for your garment manufacturing workflow: Material Inward Ledger: logs raw material and packing material receipts by date, supplier, and quantity, with auto-calculated stock on hand so nothing is counted twice. Job Work Dispatch and Return Tracker: records what you send for stitching, to which contractor, and what comes back finished — automatically flagging shortfalls so missing pieces never slip through unnoticed. Finished Goods and Sales Register: deducts from finished stock each time a sale is logged, giving you a live balance of what is ready to ship versus already sold. Dashboard Summary: one tab showing current raw material stock, pending job work, and finished goods balance at a glance. One decision worth flagging: I will use named Excel Tables rather than plain ranges. This means your dispatch and return sheets stay linked automatically even when new rows are added — no broken formulas when your data grows. Anticipated issue: garment businesses often have packing materials that get partially consumed across multiple batches. I will build a packing material consumption tracker separate from main raw materials so that shortfall does not get buried. Delivery: fully working .xlsx file in 4 days at 4900 INR.
₹4,500 INR in 4 days
7.1
7.1
9 freelancers are bidding on average ₹6,128 INR for this job

Hello, I have carefully reviewed the details before placing a bid on your project. I am confident that I can complete the task and provide you with an effective solution. With over 14 years of experience in reporting and data analysis, I have designed and delivered multiple dashboards and implemented VBA automation to reduce human intervention which enhances data accuracy. My dashboards and reports are equipped with dynamic features like checkboxes, radio buttons, drop-down lists, and various graphical data representations, including bar charts, pie charts, heat maps, and Gantt charts. Please feel free to check my portfolio for more information. I look forward to discussing the details further in chat. Thank you for your time. Best regards, Jitender Kumar Reporting & Data Analytics EXCEL | VBA | POWER BI | SQL | OCR | Google Sheets
₹5,250 INR in 7 days
5.7
5.7

Hello, How are you today? After carefully reviewing your requirements, I’m confident in my ability to meet them with the utmost accuracy in the shortest time possible. I have worked on similar projects as an expert. Chat me up; let's discuss your project in detail and get started right away. Thank you.
₹3,500 INR in 1 day
5.5
5.5

One strength that sets me apart from other freelancers is my ability to architect robust systems that not only automate tasks but also ensure data integrity. Your stock register not only tracks raw materials and finished goods but also manages job work processes. Thus, data accuracy is vital, as you want to avoid any inconsistencies or errors in your inventory management. Given my core specialization which includes extensive experience with POWER QUERY and managing massive amounts of data daily, I am confident in successfully creating a solution that manages stitching materials (including packing materials), tracks items received back after stitching and handles sales of finished goods seamlessly. In hiring me for this project, you're investing in more than just an automated stock register - you're gaining an expert partner dedicated to ensuring your inventory runs smoothly and efficiently. Together let's reclaim countless hours wasted on manual updating and improve your decision-making process through my proficient data-modeling and visualization skills! Let's alleviate all those stock control concerns with one-click clarity!
₹7,000 INR in 3 days
3.9
3.9

KANPUR NAGAR, India
Member since Aug 30, 2025
₹600-1500 INR
₹3500-7000 INR
₹750-1250 INR / hour
₹100-400 INR / hour
₹750-1250 INR / hour
₹12500-37500 INR
$10-30 USD
₹1500-12500 INR
₹75000-150000 INR
₹750-1250 INR / hour
₹750-1250 INR / hour
₹100-400 INR / hour
₹1500-12500 INR
₹12500-37500 INR
$10-30 USD
$10-30 USD
₹750-1250 INR / hour
₹12500-37500 INR
$15-25 USD / hour
$15-25 USD / hour