# Forecasting Quantity in Sales

#### avi2ghatak

##### New Member
I have a product for which units sold in May is 12420, Jun is 1200, and Jul is 12400. How can i forecast that how many units will be sold for the next 12 months?.

### Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

#### Eric W

##### MrExcel MVP
Welcome to the MrExcel forum.

Forecasting is a bit of an art. You need to build a model of your sales. Are the sales seasonal? Do you need to worry about recession? What is your supply chain like? Can you expect to have as many units to sell as demand requires? Will advertising affect things?

With the extremely limited information you provided, about all you can do is say that sales for 3 months are 12420+1200+12400=26000. Average monthly sales is 26000/3=8,666. So estimated sales for the next 12 months is 8,666*12=104,000. But that's really suspect. Your June amount is a LOT lower than the others. Is that a typo, or is there a reason it's so low? If there's a reason, can you incorporate that reason into your model?

#### avi2ghatak

##### New Member
HI Eric,

Thanks a lot for the reply. Actually for June Month it was a typo error.

I want the sales individually for every month i.e.

 Sku Name May Jun Jul Aug Sep Oct Nov Dec Jan Feb May Jun Jul Aug Sep X 12420 12400 12580

<colgroup><col><col><col><col><col span="12"></colgroup><tbody>
</tbody>

#### Eric W

##### MrExcel MVP
With the information provided, all you can do is average the months you have and put that value in each of the remaining months.

1,102,826
Messages
5,489,081
Members
407,671
Latest member
annep833

### This Week's Hot Topics

• Timer in VBA - Stop, Start, Pause and Reset
[CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
• how to updates multiple rows in muliselect listbox
Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
• Delete Row from Table
I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
• Assigning to a variable
I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
• Way to verify information
Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
• Active Cell Address – Inactive Sheet
How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...