Part Time
150.00
5
Jul 12, 2024
Looking for an Excel expert or Google Drive expert to build a home grown inventory management system and network/cloud storage. We have a lot of inventory and sell blanks as well as make custom apparel via embroidery, heat transfer, sublimation, dtf, applique, patches, etc. We want to be able to take customer orders, print off estimates and print off work order sheets in order to help improve our work flow efficiency. Furthermore, we'd like to have a cost analysis/profit loss for each ticket. Example Profit Calculator: Embroidered polo shirt-left chest multi color design
Cost of blank shirt, design fee, Number of garments, Number of colors, Colors; Number of thread colors; Type of thread (Polyneon, Raynon, Glow in the Dark, Glitter, Two-toned, Metallic, Supertwist, Flame Retardant, Other) stitch count, (the first 3000 stitches is $20; 1-5 $4 per 1000 stitches, 6-10 $3.50 per 1000 stitches, 11-20 $3 per 1000 stitches; 21+ $.2.50 per 1000 stitches; Specialty Thread-the first 3000 stitches is $25; 1-5 $8 per 1000 stitches, 6-10 $7.50 per 1000 stitches, 11-20 $7 per 1000 stitches; 21+ $6.50 per 1000 stitches); Total Stitching Time (Total stitch count divided by 800spm = total minutes); Cost Per Hour Pay; Electricity (kph); Type of Needle, Number of Needles, Cost per Needle; Type of Backing; size of backing; cost of backing; Bobbin (white, black, color), # of bobbins needed for design, cost of bobbins
All of this=total minimum cost
Total minimum cost x 2 is what you should charge for garment
For Inventory management system we want to have picture of apparel, cost of apparel, different colors, suggested retail price, location of apparel, upc #, total number in inventory, date purchased, date received in, putaway date, Remove from inventory (sold blank, sold embellished, destroyed, gift, recall);