track best seller in a shop
 

In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order the
same quantity I ordered last time. If they are declining I will order fewer
than I ordered last time.

Can Excel help here?

track best seller in a shop
 

Hi Maxx,
I have a couple of questions:
1) Did your inventory information store some where in the Excel?
2) How do you input your sale information? key in manually or a barcode
scanner?
3) Are you using a POS system (Point of sale)? if yes, then you should work
on the POS software.

"Maxx" wrote:

In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order the
same quantity I ordered last time. If they are declining I will order fewer
than I ordered last time.

Can Excel help here?

track best seller in a shop
 

In this case I have input the daily sales manually.

"Nelson" wrote in message
...
Hi Maxx,
I have a couple of questions:
1) Did your inventory information store some where in the Excel?
2) How do you input your sale information? key in manually or a barcode
scanner?
3) Are you using a POS system (Point of sale)? if yes, then you should
work
on the POS software.

"Maxx" wrote:

In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales
are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order
the
same quantity I ordered last time. If they are declining I will order
fewer
than I ordered last time.

Can Excel help here?

track best seller in a shop
 

Hi Maxx,
I think the simple way is to use a Pivottable to summarize and sort in
descending order.

If you are not familiar with Pivot table, please refer to below:
http://www.microsoft.com/dynamics/us...s_collins.mspx

Or if you like to learn from video, refer to below:
http://video.google.com/videosearch?...um=4&ct=title#

Hope the above help you.

"Maxx" wrote:

In this case I have input the daily sales manually.

"Nelson" wrote in message
...
Hi Maxx,
I have a couple of questions:
1) Did your inventory information store some where in the Excel?
2) How do you input your sale information? key in manually or a barcode
scanner?
3) Are you using a POS system (Point of sale)? if yes, then you should
work
on the POS software.

"Maxx" wrote:

In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales
are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order
the
same quantity I ordered last time. If they are declining I will order
fewer
than I ordered last time.

Can Excel help here?

track best seller in a shop
 

Okay thanks for your help I'll give it a go - I do find pivot tables
somewhat overwhelming, but ti would be good if I could finally master them.

"Nelson" wrote in message
...
Hi Maxx,
I think the simple way is to use a Pivottable to summarize and sort in
descending order.

If you are not familiar with Pivot table, please refer to below:
http://www.microsoft.com/dynamics/us...s_collins.mspx

Or if you like to learn from video, refer to below:
http://video.google.com/videosearch?...um=4&ct=title#

Hope the above help you.

"Maxx" wrote:

In this case I have input the daily sales manually.

"Nelson" wrote in message
...
Hi Maxx,
I have a couple of questions:
1) Did your inventory information store some where in the Excel?
2) How do you input your sale information? key in manually or a barcode
scanner?
3) Are you using a POS system (Point of sale)? if yes, then you should
work
on the POS software.

"Maxx" wrote:

In a bookshop, I'm monitoring the daily sales of a best selling title
The
bookshop is open 7 days a week. Some days are quieter than others (for
no
discernable reason).

I need to know how many copies a best selling title to reorder. If
sales
are
increasing I will need to replace all that I've sold and order a
larger
quantity than I ordered last time, if they are roughly static I'll
order
the
same quantity I ordered last time. If they are declining I will order
fewer
than I ordered last time.

Can Excel help here?

track best seller in a shop
 

On Jun 12, 9:56*pm, "Maxx" wrote:
In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order the
same quantity I ordered last time. If they are declining I will order fewer
than *I ordered last time.

Can Excel help here?

while pivot table/etc would work at finding your Top10 sellers, it
sounds like that is merely the first step and suggest plotting the
daily sales for those titles over a period time (say since the last
order was placed) for a graphical view of the data to see what trend
(s) emerge.

track best seller in a shop
 

Jeff,
Many thanks for your suggestion. I'll try it.
THank you.

"Jef Gorbach" wrote in message
...
On Jun 12, 9:56 pm, "Maxx" wrote:
In a bookshop, I'm monitoring the daily sales of a best selling title The
bookshop is open 7 days a week. Some days are quieter than others (for no
discernable reason).

I need to know how many copies a best selling title to reorder. If sales
are
increasing I will need to replace all that I've sold and order a larger
quantity than I ordered last time, if they are roughly static I'll order
the
same quantity I ordered last time. If they are declining I will order
fewer
than I ordered last time.

Can Excel help here?

while pivot table/etc would work at finding your Top10 sellers, it
sounds like that is merely the first step and suggest plotting the
daily sales for those titles over a period time (say since the last
order was placed) for a graphical view of the data to see what trend
(s) emerge.