forecast

Hello Excel masters :) I need your help in order to develop a final file (CustomerForecast) from 3 different files with some restrictions. The final file should have the below format. The columns "FactType" and "Unit" should have always the same values. <tbody> Depot/StoreFormat Product...

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

Hey Guys, I have a set of data with data and projects, in the format below: [Row 4, starting column F] Jan Feb Mar etc. [Column B, starting row 6] Project A, Project B I'm trying to sum all the forecast for for a project, based on the previous month's forecast - so i can compare with what's...

I have a set number of dates that I need to forecast. Some of the months I have dont always have a Forecast but I want to be able to at least post a 0 still in that date. What I need is to be able to use a list of parts IE 301080.01 301081.01 301082.01 301083.01 Etc ( this parts will be...

HI All, Thank you for your help in advance.Im really struggle to translate one formula to the code. Below formula is calculating weeks of stock cover based on deliveries and demand. Unforgettably it have plenty of "if" slowing down the report. Im looking to translate this to VBA code. Is anyone...

I'm trying to simplify some really long formulas in my model by creating some custom functions. I've cleaned up a lot but there's this forecast with offset and match that's throwing me off. here's the formula =FORECAST(AE1264,OFFSET('Data Table Dynamic'!$AC$4,MATCH(AE1264,'Data Table...

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?.

Hi Everyone! I was looking for some help on creating a completion date forecast. Here are some details of my inquiry Total Callable Records: 60,000 Total Agents: 34 WorkHours/day: 8 hrs (weekends are not included) Start Date: 8/5/2019 I want to determine the date of completion with an...

Good Morning, I have a report that comes out of our system weekly. It shows all past business actual revenues e.g anything before today and all future(today to the end of time!) forecasted revenues. We are trying to look at or pull the data so that it does the below. *** Put a date in a cell...

Hi All, I am looking for help regarding forecasting future material requirement from finished goods forecast. I have this set up currently in excel with a few index and sumproduct formulas. However the material code within the finished goods can change depending on promotion etc, at various...

Hi there I am trying to create a macro/code that will overwrite data each day when a new file arrives I have a spreadsheet that has a daily forecast for the next month where each day has 48 half hours/rows and 28 columns (including the column for the date/period i.e. dd/mm/yyyy hh:mm). This...

Hi Everyone, I'm trying to do some predictive forecasting with parameters but I'm coming across an issue when using parameters into the future. What i'm trying to do is forecast the amount of people on a waiting list in the future but this can be altered by using parameters which will remove...

If I have two Quantities and two Unit Prices, is the a formula that will forecast another qty? Qty 100 = $25.00 Qty 500 = 10.50 Is there a formula that would forecast Qty 300 or any other quantity I enter that is between 100 and 500 (Using a straight line)? Thanks

I've managed to successfully create a Forecast line chart. It has produced a table including forecast values, which is great. However, I'd really like to know what % increase it's working on? How would I go about adding this column to the Forecast table?

Hello, First off, appreciate any help as I a have been banging my head on this for some time. I want to see if there is any guidance on how to do a mean reversion forecast in excel. The data points are very simple and are linked below for your reference...

I know it sounds weird...but I have some complicated code that has MANY conditions for when I double click a cell in a range. I want a code that will run the code associated with the double-clicking of the cells automatically without actually double clicking. to sum up (I think): I have an...

Hi All, I control a monthly sales forecast - sales people enter their forecast for the month but then can amend this at 2 dates in the month (approx 10th and the 20th), it is then fixed. I need to track the changes they make; example. Cell B1 they enter £100,000 for June On the 10th they may...

Hi, I'm trying to sum every 3rd column up to the current week in order to have a current year to date sum up to our current fiscal week (or any fiscal week chosen). Below is the current setup, any ideas with sumproduct, offset, mod probably make sense but I can't wrap my head around what the...

I have data that is material description July Aug Sept. The forecast is below each month. I will like the format to be Mat Des Jan Forecast Mat Des Feb Forecast Essentially, I will like to transpose the months and Forecast. I hve 80 unique material numbers. What is the quickest way of...

I have over 800 lines of data. I am trying to create a forecast for each material based on the plant. I have consumption for two years. I want the forecast to be automatic so when someone enters the plant and material, the forecast is auto populated. Currently the issue I am having is how to...