Biostar Pharmaceuticals, Inc. (BSPM)

[GorillaGorilla]

Ah, I'd forgotten... Am I workshy or what
I'm getting $13.37 per day which sounds slightly higher than yours. I would round that down to $13. Would even be tempted to use $10 or 11 as no one minds if your low... but whine if you are high

I wont't check your method against mine until after posting. This way I won't follow you and make, potentially, the same mistake. Sometimes it's good to reinvent the wheel

I broke it up so [A1] calculates the number of days that the shops open for all the year and the shops open from April [A2] and divided by 2 - to approx the delay for opening the shops - this assumes a constant opening rate - probably not true. Then we divide the revenue for the shops [A4] by the sum of the days [A3].

Next bit is Total number of store open days for a full year [A6]... which, finally, give the estimate of revenue for revenue from pharmacies in 2010 [A7]. I've put the forumlaes in so it's easy for anyone to put in spreadsheet and tweek.

.................................... A.........Formula
[1] Days for shops open all yr......356,400....=9*30*1320
[2] Days for shops open part........197,280....=6*30*J24/2
[3] Total Days open Sum ............553,680....= Sum(A2:A3)
[4] Rev from all Shops............7,400,000...............
[5] Dollars Per day...................13.37....= A4/A3
[6] Total Days next year..........1,825,000....=5000*365
[7] Revenue 2010..................24,391,345...=A5*A6

rich