Another day, another spreadsheet. Today was another day of being shown how to input information into the merchandisers excel documents under jersey, denim and accessories. Of course they all have totally different ways of doing the same thing just to make it that much easier for me.. joke.
Today was mainly about learning how to do the daily sales. I met another MAA called Stephanie who has been with the company for 3 months so far, as Nicola has now left so Steph is the person I go to if I need help.
Daily sales is pretty self explanatory - if you don't include all the numbers. It involves working out basically what all the stores took the previous day, but only in the jersey, denim and accessory departments. Using sheets that have been filled out but the company director already with figures, it's a case of inputting these figures into the correct places on the spreadsheet and a percentage is worked out for you (thank god). But there is some maths involved, something you have to do some timing and working out the percentage to time it by yourself, which is where I tend to get confused.
After this, I was then shown how to produce labels. These are used by the buyers in all the meets, as they hang off the garments they talk about it. It contains all that particular garments details such as what its sold the previous week, or what week it's coming in etc etc. Stephen then asked me to check the cost price of some jersey that had come in, and making sure what we had down on paper matched with the online documents. This involved using a programme called Mercatus which contains A LOT of info for the merch teams but I've only used it for reports and this so far. This was quite a fun task, and only involved ticking off ones that matched and marking down which ones where wrong and flagging it with steph.
One of my last tasks of the day was checking the input reports. This is a way of tracking when each shipment of stock is coming in, and again to see if what we had printed matched. I think I'll only need to do this when Jenna, the senior merch for denim, asks me to look up something so that won't be a daily routinely task.
These posts will probably lack a lot of imagery as i'm not allowed to take photos in the office, and doubt you want to see pictures of huge excel sheets with a load of numbers on.
People I've met count: 6
No. of things learnt: 7
Brain ache scale: 7/10 - this isn't good.
See ya after day three!
No comments:
Post a Comment