Forecasting Quantity in Sales

avi2ghatak

New Member
Joined
Aug 16, 2019
Messages
2
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?.
 

Some videos you may like

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
Joined
Aug 18, 2015
Messages
9,922
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
Joined
Aug 16, 2019
Messages
2
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 NameMayJunJulAugSepOct NovDecJanFebMayJunJulAugSep
X124201240012580


<colgroup><col><col><col><col><col span="12"></colgroup><tbody>
</tbody>
Could you please help me in getting that..
 

Eric W

MrExcel MVP
Joined
Aug 18, 2015
Messages
9,922
With the information provided, all you can do is average the months you have and put that value in each of the remaining months.
 

Watch MrExcel Video

Forum statistics

Threads
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...
Top