please help me out in analysis

please help me out in analysis
Posted: Fri May 22, 2009 10:55:54 PM

Hi,
I got one question from my manager as he wants to see if I can do the job for him in the future, The worst part is that I didnot understand what he was trying to ask as I didnt want to say no as its a matter of my future. The thing is we have some suppliers from whom we buy some products. The prices have gone down by 5%. So he asked me to add up the total of stock on hand and stock on order(units). He also ask me to put put the average sales(units) for the last three months in another coloumn.Then we ask me to add up the total of stock on hand & on order as well as average sales. Now he wants me to do analysis of what will be good for us. And here comes the trick part I dont know what does good mean. Please help me out as its a matter of my future.
eg:
Product , SOH+SOO, Average sales, Price in May , Price in August
A , 4 , 30 , 4 , 3.90
B , 2 , 12 , 6 , 5.80
C , 5 , 8 , 8 , 7.60

Please I will be really thankful. If you dont know can you advise any messageboard where I can post it and get answers.
Thanks

RE:please help me out in analysis
Posted: Thu Oct 1, 2009 10:32:45 AM

Use Excel program and run columns by time frames ex top to bottom jan, feb , etc.. column 2 stock on hand, 3 stock on order, 4 price/value at that time frame, 4 total valuation of stock, 5 sales/month, in each box type in =(b1+c1)*d1 gives total value on hand & ordered, on hand - sales = net inventory value tada! a reasonable report and you can tailor it to your more specifics, adjust text fonts etc.. so it looks good, and you're now in charge of inventory management. Hope that helped, I used to assess work productions for all kinds of criteria for a major auto chain store and my own towing/lt transport work. Caution if your too detailed bosses can be jealous of talents and don;t like to be shown how to do their job better. Tact!  Maybe ask exactly what they want to see then be creative with excel it does lots of calculations and if you understand math or business concepts you can adjust it to your needs.