Excel Expert/network-cloud storage creator

Please login or register as jobseeker to apply for this job.

TYPE OF WORK

Part Time

SALARY

150.00

HOURS PER WEEK

5

DATE POSTED

Jul 12, 2024

JOB OVERVIEW

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);

VIEW OTHER JOB POSTS FROM:
SHARE THIS POST
facebook linkedin