HALP! Brain Freeze!

[Olgaline]

If you have sold 12 items in 7 weeks, thats to say 1.71 items pr. week

how do you convert that to % sold pr. week ?

and then convert that into a excel friendly code

 

[Aoami]

you should start selling something else!

edit - im also fairly sure that your question doesnt make any sense

 

[Madmaxx]

If you have sold 12 items in 7 weeks, thats to say 1.71 items pr. week

how do you convert that to % sold pr. week ?

and then convert that into a excel friendly code

I dont know but, if you wanted to know the % amount of stock you've sold you would need the amount of Total stock you have to take away from right?

so if you had 120 items in stock and you sold 12 items in a week, that would be 10% of stock sold per week right ?

 

[Olgaline]

I dont know but, if you wanted to know the % amount of stock you've sold you would need the amount of Total stock you have to take away from right?

so if you had 120 items in stock and you sold 12 items in a week, that would be 10% of stock sold per week right ?

Aye, that part I've got down...

what I need is a % pr week over 7 weeks

 

[Madmaxx]

so in excel you coud have a In-stock amount...then a sold amount...then in the coloumn next to it have a % of stock sold or stock left ? is that to easy or wrong I dont know

EDIT =: ah nm then

 

[Olgaline]

My question i guess is:

how many % of 12 is 1.71


I think

no that all give 14.28 no matter number or itmem---gaah my brain hurts after a full day of crunching numbers

 

[Zarjazz]

Wrong, that's not the question. You're missing a value - how many items do I have in stock.

 

[Olgaline]

number of sold items / 7 weeks gives 1.71 pr. week.
now to turn that into % pr. week bah!

 

[Olgaline]

Wrong, that's not the question. You're missing a value - how many items do I have in stock.

not important in this case

 

[Raven]

It still doesn't make any sense.

Roughly 20% though I suppose.

12/7 = 1.72 ....... (12/100)*1.72 = 20% or there abouts.

 

[Olgaline]

the answer is 14.28 and they'll all say that..my bad
indded i need a primo & ultimo ...I'm getting ahead of my self here

but cheers

 

[Zenith.UK]

Assuming A1 is 12 and A2 is 7...
=(A1/A2)/A1
Highlight the cell and hit CTRL+SHIFT+5.

 

[Bigmac]

And I thought the topic was about brain freeze!

 

[old.Tohtori]

Me too. Me too my friend;


View: http://www.youtube.com/watch?v=cTte0H8OhvQ

 

[Olgaline]

if you want to make a diagram i excel that show how long it will take to sell item XX compared to item YY and where it the two "meet"
how do I do that ? I've spent half the day trying to figure this crap out ! me and excel dont agree to well :;/

 

[Madmaxx]

umm would have to set it to how much stock was sold..so a total on 100 items each, and 1 would go slow 1 would go fast, but both end up at 100 ?

so instead of cash it would be stock sold then time at bottom so it would see 1 going slow then peaking later or something ?

 

[Olgaline]

it has to be cash.

stok sold will be of no value to me.

stock a is worth xxx value
stock B is worth xyi value

thus the nuber of stock sold tells me not so very much in this case.
also due to tax, expenses and so fourth.

 

[Olgaline]

Basicly I need to know how long it would take to sell item B before I earn as much as I did with Item A in 3 weeks.

I know how much each has sold in 3 weeks, thus break down be deviding by 3 you have your pr. week value, so how many weeks/days before I sell for the same cash amount of B equal to A

 

[ileks]

So you have your values as a function of time - just stick in t=3 for item A and equate it to your function for B.

 

[Olgaline]

right, nvm figured it out!

it's at 72,5 work days.

 

[Olgaline]

So you have your values as a function of time - just stick in t=3 for item A and equate it to your function for B.

I'm too slow brained to get that. please elaborate

 

[ileks]

i.e. Earnings from A in 3 weeks = (Amount earnt from B in a week)*time

(time being in weeks)