Today I’m gonna tell you guys about how I dealt with these stock yardages. It’s a bit of a mess, but I managed to figure it out, so stick around!
First off, I got a whole bunch of data about the inventory, you know, how much of each fabric we had left. It was all over the place, different formats and stuff. So the first thing I did was to gather all of it in one place. I used a simple spreadsheet, nothing fancy, just to keep track of everything.
- Opened up a new spreadsheet.
- Started typing in all the data I had.
- Made sure each fabric had its own row.
- Added columns for the type of fabric, the quantity we had, and any notes about it.
Then, I needed to figure out how much of each fabric was actually usable. Some of it was damaged, some were just scraps, you know how it is. So, I went through the inventory and marked down what was good and what wasn’t.
After that, I sorted the fabrics by type. I figured it would be easier to work with if I grouped similar fabrics together. I mean, cottons with cottons, silks with silks, you get the idea. It’s like putting your socks and shirts in different drawers!
Then came the tricky part. I had to calculate the actual yardages. Let me tell you, it wasn’t easy. I had to account for the different widths of the fabrics, and sometimes the patterns made things even more complicated.
I also wanted to make sure I had enough of each fabric for upcoming projects. I made a list of the projects I had planned and checked if I had the necessary materials. For example, for a dress, how many yards did I need? Did I have enough?
Here’s how I did the calculations:
- Measured the usable length of each fabric.
- Took into account the width.
- Did some simple math to get the total square yardage.
- Wrote it all down in my spreadsheet.
Finally, I organized the physical inventory to match the spreadsheet. I put labels on everything, made sure similar fabrics were stored together, and created a system so I could easily find what I needed.
It was a lot of work, but now everything is in order. I can easily see how much of each fabric I have, and it’s much easier to plan for future projects. Plus, it just feels good to have everything organized, you know?
Alright, that’s my story about dealing with these messy stock yardages. Hope you found it helpful or at least a bit entertaining!
