Simple BOM, inventory and sales spreadsheet

Đang Thực Hiện Đã đăng vào 4 tháng trước Thanh toán khi bàn giao
Đang Thực Hiện Thanh toán khi bàn giao

I am looking for someone to help me create a simple Bill of Materials (BOM) and inventory management system. I need to track electronic components in the spreadsheet but I do not need to track item locations. The spreadsheet should be able to notify me when the stock level reaches a certain quantity so that I can re-order stock as needed. Additionally, I do not require any forecasting functionality.

I want to be able to create assemblies in a BOM from inventory items, display assembly manufacturing costs and save each assembly. Modification/update of assembly function will be required as components are sometimes discontinued and new components have to be used.

I want to be able to store all necessary component information in the inventory database, such as Item code, item name, description, supplier, order code, quantity, unit cost, inventory value, re-order level, re-order qty, notes.

I want to be able to add "other costs" to each assembly in the BOM, for costs such a packaging, shipping, insurance, admin fees, business expenses, labour etc. I would need to be able to enter these costs separately and then designate what proportion is to be assigned to each assembly. Eg. there are annual costs that must be apportioned across all sales, usually be percentage of total cost apportioned to each assembly sale.

I want to be able to enter component stock purchases and have the inventory updated automatically for qty and unit cost (combining new costs with cost of stock on hand).

I want to keep track of sales to customers, including customer information, assemblies sold, sale price, shipping cost, transaction fees and assembly serial numbers, manufacturing date etc.

Each time an assembly sale is entered, I want the inventory quantities to be automatically updated.

Also, a notification whenever component re-order quantity is reached, including highlighting or changing the fill colour of the row.

What I DO NOT need is invoicing, purchase orders, complex sales analysis.

I do like the attached screenshot of a sample BOM page. Although, this particular template (the entire spreadsheet) is too complicated for me and too hard to edit.

I can provide exact details of information required to be recorded.

Excel VBA Excel Macros

ID dự án: #37253844

Về dự án

22 đề xuất Dự án từ xa 4 tháng trước đang mở

Được trao cho:

Giovanni704

Hi there! I am proficient in creating customized Bill of Materials (BOM) and inventory management systems in Excel. I can design a user-friendly spreadsheet tailored to your specific needs, including tracking electron Thêm

$30 AUD trong 1 ngày
(14 Đánh Giá)
6.0

22 freelancer chào giá trung bình$191 cho công việc này

schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are look Thêm

$180 AUD trong 3 ngày
(49 Nhận xét)
6.0
akritisood94

Hi there! My name is Akriti and I'm a professional Excel expert with extensive experience in the field. I understand that you're seeking someone to help you create a simple BOM and inventory management system for track Thêm

$200 AUD trong 1 ngày
(28 Nhận xét)
5.5
amokhtar70

Hi, I have gone through the Job details and am interested in taking it up. I’m Ahmed Hassanein. I’ve been working with MS Office since the 90’s as a user, developer, and trainer. I've been using formulas, VBA, and mac Thêm

$150 AUD trong 3 ngày
(22 Nhận xét)
5.0
writingapp

Hi. I have written many automation Excel projects. Ready to write your project. Will complete within some hours

$80 AUD trong 1 ngày
(41 Nhận xét)
4.9
daniyal3214

Hello, Excel expert here. I can perfectly assist you with this and can start on an immediate basis. I am an experienced Excel professional with years of experience in all the tools of Excel including Visual Basic, Auto Thêm

$70 AUD trong 1 ngày
(17 Nhận xét)
5.0
arunkumar9896

Hi Hope you are doing good, I can perfectly help you with that in quick turnaround. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools, creating dynamic dashboards and Exc Thêm

$100 AUD trong 1 ngày
(13 Nhận xét)
4.9
AccountantArman

" ADVANCE EXCEL VBA MACRO EXPERT ""Sir, EXCEL is my specialty and I can perform any complex task in EXCEL. I am an EXCEL VBA and CODING, AUTOMATION, TEMPLATE, REPORTS, FORM Thêm

$140 AUD trong 1 ngày
(15 Nhận xét)
4.5
GabrielBarreiro1

Hello, welcome to my proposal. I can develop the tool in MS Excel that you need, with an optimal combination between functionality and visualization. You can visit my profile to see samples of my recent work. I am a Thêm

$175 AUD trong 5 ngày
(13 Nhận xét)
4.1
BAVarun

Expert in excel with over 15+ years of experience and over 4.9 user rating on this platform. Completed over 90+ projects on FL. Expertise in - •Macros • Formulae • VBA • User forms • Pivot tables Willing to sha Thêm

$40 AUD trong 3 ngày
(2 Nhận xét)
3.2
freelancerabdu34

Greetings, I am an Advanced Level Excel Formula, VBA & Macros expert and an Accountant. I am very confident to start your project and complete it with all the efficiency you are looking for. I understand the requiremen Thêm

$114 AUD trong 1 ngày
(8 Nhận xét)
3.1
merinsinha

Excel VBA expert. I can do it. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating Thêm

$160 AUD trong 3 ngày
(12 Nhận xét)
3.3
zafarfarooq612

Greetings, I am excited to offer my expertise in creating a tailored Bill of Materials (BOM) and inventory management system to meet your specific needs. I will develop a user-friendly, customized spreadsheet that wil Thêm

$30 AUD trong 1 ngày
(1 Nhận xét)
2.6
AmazingEngr76386

Hi there! I understand from your project description that you are looking for someone to help you create a simple BOM and inventory management system. Specifically, you need to track electronic components in the sprea Thêm

$140 AUD trong 7 ngày
(1 Nhận xét)
2.7
saifulcmab

Hello, I can create a simple Bill of Materials (BOM) and inventory management system. I am certified in advanced Excel, data analytics, and Dashboards from Macquarie University, Australia. I have a lot of experience i Thêm

$45 AUD trong 1 ngày
(1 Nhận xét)
1.0
asadgcc

I understand your project well. I have considerable expertise in dynamic invoice generation and inventory management. I can show you a sample copy of the inventory management software in excel if needed.

$120 AUD trong 2 ngày
(0 Nhận xét)
0.0
AsimMunir77

Hello, I am interested in your project and i can complete it within required time. I have appropriate experience in Microsoft Office Products(Word, Excel, PowerPoint, Visio, Project as well as VBA etc) of more than 10 Thêm

$140 AUD trong 7 ngày
(0 Nhận xét)
0.0
techplusintl

Hi there, ★★★ Excel / VBA / Macros / Automation Expert ★★★ 10+ Years of Experience ★★★ I've read requirements and ready to create Bill of Materials (BOM) and inventory management system. I provide complete ranges of s Thêm

$250 AUD trong 2 ngày
(0 Nhận xét)
0.0