I want to make a inventory management excel sheet for T-shirt manufacturing. Need a products page , raw materials with different sizes column, a bill of materials sheet and an order sheet. I want the entries to be calculated based on sales and purchase. I have a mock excel spreadsheet for reference. Either that mock excel sheet can be adjusted to the liking or can be used as a base to create a new one. In T-shirt manufacturing one t-shirts design will be printed on various sizes i.e. xs, s,m,l,xl,xxl,xxxl. So the way i want is for example. In raw materials column if i enter gents white tshirt. The in number of tshirt should be entered in the size column and the total should be calculated at the end. The size column is important as this will avoid multiple entries of same design. A damage column is also required as when preparing few t-shirts gets damaged. In the bill of materials sheet i want a damage column and once an entry is made it should be calculated and it should be subtracted. The damage column should also have size chart. For example. If i entry 5 damage pcs in the L size Column of the damaged column or damaged spreadsheet. It should get adjusted in the bill of materials. The excel sheet i have doesn’t have size columns. You can use it as a reference and /or change it accordingly to my liking. Most of the formulas are already entered in the excel sheet that i have. If you can change that no problem but if changing is too complicated and making a new one is easier for you , we will go with that.
Please respond. Thank you.
32 фрилансеров(-а) готовы выполнить эту работу в среднем за ₹6472
I am an expert in filling in a spreadsheet with data. I know data entry in Excel file, I will work honestly & with maximum perfection which is my strong point. I have done diploma in data entry & typing.
I do very good typing and I have experience of it for 5 years.I have govt verified certificate for this field and i have many more online customers
I am data entry operator and I am expert in Excel , I also have Excel VB capabilities . I will complete your work on Time and in your budget. ....Thankyou....
I can complete your work in given time. Give me a chance to work so that my work can talk to you. Typing speed 80-89 words per minute with 95% accuracy.
We have best experience in data entry. Fast Typing jobs. Pdf convert. Copy paste We have work experience in working for big companies and for government.