Sales Analysis

xirokx

New Member
Joined
Feb 19, 2005
Messages
1
Hi,

This forum was recommended by a friend.

I work in purchasing and my job entails purchasing stock from the far east. As the year has started I have been handed a sales spreadsheet which consists of sales values and quantities month on month for the last 2 years as well as year on year for the last 4 years.

I would like to know how to forecast stock quantities for the next year month on month using excel. Also bear in mind I will also need to hold buffer stock etc. Also I need excel to help me analyize and report any sales trends etc. We launch new products every june so I need to gain a better understanding of which lines are serving there cause and which lines are not also using excel.

Now although I use excel frequently I regret to say I am not too familar with all the functions despite studying guides and learning from tutorial software.

If you believe I can get much more information than stated above from excel then please feel free to suggest.

Please please help.

Thanks in advance
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,122,604
Messages
5,597,128
Members
414,126
Latest member
jellevansoelen

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top