Hi,
I have to preapre a budget for 2013/14 based on past year salesvolumes and according to the target sales value given. Data sheet is attached here and pls give me a possible solution to calculate volumes productwise according to te sales targets set.
SampleDataSheet.xls
maybe something like this?
You better add with productgroups so you can specify the forecast per productgroup.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
Thanking you for the response... But I need to anlyse the trend and set the volumes according to the sales target as I mentioned in the sheet . Sales target is in billions. I have the unit price list as well. Base on this data i need to get the forecast for next financial year. Pls see the sheet and give me a possible solution.
Please add the desired result in the sheet and tells us how you counted them.
Then i will take a look, to make the excel formula.
SampleDataSheet.xls
pls see the shhet here
Last edited by Cutter; 10-28-2012 at 01:54 PM. Reason: Removed whole post quote
1) Please don't send Private Message, just reply on the board.
2) I don't see the desired result in you sheet (see my post in #4).
hi..
Ok .. Results should be the volumes as past figures which finally has to match with the sales targets per months. As you can see right bottom lines in the sheet. These past volumes should be adjusted according to the trend and sales target for the next year. It may increase or decrease according to the trand and the sales target.
Simply, Sum (Volume * Unit Price) = Sales Target
thanx
Last edited by Udaya Samarathunga; 10-28-2012 at 06:15 AM.
Is this what you're up to?
If you don't use empty collumns you can drag the formula of the first collumn to the right.
Hi,
Actually this is sales value.. I need volumes for products each month. and the Total of the sales value of the products should same as the sales target as you can see botom line of the sheet.
cell value from v1282 on wards you can see sales targets in millions for ech month in next financial year. i have to adjust the volumes based on past vales (2011/12 values) as to come up finally to a setted sales target. in this sheet as you calculated total should arrived as the sales targets.
Thanx
then i ask you again, put the desired outcome and the data it is depending on, in the sheet.
I didn't scroll to v1282 because i don't expect to see data there.
put the data you need in the top of the file, so it is easy to see.
OK pls see new sheet. Here as exaple,
I want to get the forecated volume to April 2013/14 base on volumes of April 2011 and 2012.
Also Total of the Sales values of April 2013 should be equal or bit more than the given sales target.
This what I have to do through the formula.
Thanx
Last edited by Cutter; 10-28-2012 at 01:54 PM. Reason: Removed whole post quote
Pls see this sheet
** I notice you don't add the desired result in the sheet. **
How can we make a formula, if you don't give us the desired result?
How would you count this manualy?
I don have result for the next april 2013. Thats what i want to predict based on past figures as in the sheet 2011 and 2012. These data got from the sap system . These are the sales volumes done for tha past months. Based on these data and trend I have to predict next year volumes. thats why i need a formula which can consider past volumes and given target to calculate the volume for products to next year.
Thanx
How would you count this manualy?
Hi,
Not manually . I need to calculate the volume for April 20133/14 by using 2011/12 volume based on the sales target for particular month. Thats what i need . so i need to based on the trend of the past data I have. I have data from Apr2011 to September 2012. Based on these months volumes I have to predict the forecast.
So
Inputs are , 2011/12 monthly Productwise Volumes
2013/14 Monthly total Sales Targets for all products
By using these two data I have to arrive at new forecast volume for next Financial year Form April 2013 to March 2014.
Thanx
Last edited by Cutter; 10-28-2012 at 01:55 PM. Reason: Removed whole post quote
Hi,
Not manually I have to calculate Volumes for next financial year based on past volumes and the monthly total target given.
Ex:- I have data from 2011 April to 2012 September
Based on these monthly volumes need to predict 2013/14 monthly volumes based on the Total monthly targets given.
So Inputs are : 2011/12 Monthly product volumes
2013/14 Monthly Total Product Targets
This Target need to divide among the products according to the trend and finally need arrive at Total Target vlaue.
thanx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks