Friday, May 17, 2013

Week 2 Day 1


Today I finished my Groupon spreadsheet and I’m beginning to make pie charts for all of the different products on the spreadsheet I made. So I just use Excel’s graph function to make them but, unfortunately, I have to manually enter in the key. I also started a second project where I’m checking off whether or not certain products where shipped or not based on an invoice. An invoice for those who don’t know is essentially a sheet of paper that lists the sales of a particular item; it could also mean that they want a certain number of products as well. I have a pile about a foot high of these invoices to check and I check them using a program called RPMS, Resources and Patient Management System, and it’s a database that has the information on every product in certain warehouses that are owned by the companies we represent. So I look through the database and look up the products code number and If it was shipped I put an S and if it wasn’t I press the spacebar, or if part of the inventory was sold I press P and then enter the amount sold. This is crucial because by having records of what products are shipped our company can get a commission on the sales. 

No comments:

Post a Comment