I know there's a way but I'm drawing a blank on best approach and method. I have one rolling year of data so say July 2019 to June 2020. However, on the report I'm only showing year to date so January to June. What I'd like to be able to do is from July to December provide a projection based on...
Thanks for reading!!
I want to predict date or week number based on the current performance measured against target:
Col A : Week Number
Col B : Target (Number) target is 500 and each week target is to complete 20 (so 20, 40, 60, 80, and so on till 500)
Col C: Actual completed number...
Hi I'm trying to forecast my unit sales for the following year. I have last years data but I'm at a loss as to where i begin. My data is below along with what i expect the market changes to be.
new to the forum.
I have an issue with powerpivot/DAX that I have not been able to solve. I hope someone is up for the challenge...
The problem is calculating a YTD monthly Inventory closing position while ignoring cumulative negatives if there is no stock to satisfy the forecast...
I am a new user and novice without VBA knowledge. The hardest formula I can use is about Index/Match so please be nice :).
I am looking for a solution which does below;
1. A cell which looks up a value from a separate tab. I currently do this by index match. (ROW10 SUPPLY FCST key...
Hi, I'm having trouble with this problem
Construct a forecasting worksheet to calculate:
1. the number of new clients each month, and
2. the total client base (cumulative number of clients signed up) each month.
In your model, make projections for 60 months (Periods) for the two scenarios...
I have a file that is taking longer and longer to insert/delete/move cells/columns/rows now up to at least 10 minutes EVERY SINGLE TIME! I have tried absolutely EVERYTHING that I can find and am at my wits end.
I started from scratch to create a budget model that would provide forecasting...
I am running into circles with trying to figure out this issue. I am wanting to automate our current capacity planning tool for my team and want to generate some sort of forecasting ability with the forecast formula. I have heard that the newer versions of Excel contain the forecasting...
With recent economic and market conditions (eg. tariffs), raw material and commodity prices have fluctuated. Some, such as steel (purchased scrap), have fluctuated significantly.
If I want to use a formula for raw material pricing, does anyone suggested a specific "forecast" formula. I am...
I am working on a forecasting model and have run into some trouble when trying to extend the X-Axis of a 12-month Curve Distribution to a longer time frame. Given a distribution of 12 percentages (one for each month), how can I spread the 12 months or periods to say 18 months while...
First time posting so apologies if I'm not overly clear.
I've been set a task that is bending my brain a little bit -
The document has 3 tabs - Historical Calls, Forecast Calls, Accuracy
-Historical Calls - actual data
-Forecast Calls - historical data which is either like for like...
I have a year end sale figure of £80,000 and want to divide this between 12 months in way that starts from Jan to Dec, and the Jan Sale not to be less than £4,000 and each month the sale increase slightly with a few fluctuations in Sep, Feb and March when there is seasonality and the sales are...
First of all sorry if this has been answered somewhere else also I am a newbie so sorry if I'm wasting your time.
I'm currently analysing data for my School. I have two questions:
I do a lot of forecasting and am tired of having to repeatedly write a formula from scratch to test whether or not my forecasts fall within the prediction interval. To be clear what I mean, is that I may predict a value of 1,000 with an 80% chance it will be within 900 and 1100. I need to test...
I need help determining the best way to forecast for the following year end forecast value.
The 'Xs' represent the data I have available to me to leverage. Ideas??? Thanks!!!
Does anyone of you here have experience with the Analyse tool of DPSC ? Ho was it working with it?
Any tips on how to go about it as I am suppose to revive it and get it back in action at my office and I don't know where to start :P
I am working on an excel project for my business analysts diploma.
I have a worksheet detailing student enrollments and finaces for a number of different colleges, I have historical data for 2015 - 2017 and forecasted data for 2018 - 2020, this shows my forecast based on the...
Dear Forum Members,
I have a big data file with sales numbers of specific products per week for the year 2016. I also have the weekly total sales for the years 2014 and 2015. My question to you is if you can help me to find the most suitable way to forecast the sales for 2017. The data is from...