# forecasting

1. ### Forecasting date based on current performance & targets

Hi All, 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...
2. ### Forecasting the next number in a list?

Is there a formula that I can put next to the final date that will "forecast" the number? My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it.
3. ### Forecasting

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. <colgroup><col><col span="12"></colgroup><tbody> Monthly Data Jan Feb Mar Apr May Jun...
4. ### Forecasting Quantity in Sales

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?.
5. ### Forecasting Opening and Closing Inventory

Hello all, 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...
6. ### Dynamic update of the database when you change the linked cell?

Hi, all 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...
7. ### Forecasting help

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...
8. ### Excrutiatingly slow insert/delete times using table and defined names

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...
9. ### Forecasting and Capacity Analysis for Future Dates, Projects, and Resource Names

Hi guys, 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...
10. ### Forecasting Raw Material Pricing

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...
11. ### Forecasting Curve Distribution

Hello, 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...
12. ### Forecasting Accuracy Model

Hi all, 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...
13. ### Cumulative sales Forecast Formula

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...
14. ### Forecasting & Predicting Data

Dear All, 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: <colgroup><col span="22"></colgroup><tbody> Art <tbody>...
15. ### Simple conditional output failure aka Prediction Interval Testing - should be an easy VBA fix

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...
16. ### Best Way to Forecast with this Data

Hi - 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!!! <tbody> Months: 1 2 3 4 5 6 7 8 9 10 11 12 Total 2018 x x x x *FORECAST* 2017 x x x x x x x x x x...
17. ### DPSC Analyse

Hi ! 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
18. ### Forecasting - changing data for creating different forecasts

Hi Everyone, 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...
19. ### Forecasting

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...
20. ### Payables Cash Requieents

Cash requirement for an Accounts Payables environment. Link provided for sample data set with desired date results highlighted. https://1drv.ms/x/s!Auu67iC5u960_VhNg5EF3ywaGrCe To provide an accurate detailed daily cash required forecast for payables, invoices and credits must be calculated to...