I need some help having a macro or something that can take a data set (45 check points = X and % stock used = Y) and it’s bell curve, compress it to fit a smaller scale such as 1-15 checkpoints and maintain the bell curve shape.
I want to type in a stock amount and weeks and it spits out a new...
Hi all, I have a simple table like the below. I'm looking to forecast both sites at once if possible on one output. When I select the whole range and select 'Forecast Sheet', it only selects Site B e.g. the bottom row. I assume it is possible to forecast both Sites at once, or indeed any number...
I work in Finance and have a QoL-issue with excelling daily.
I use INDIRECT and SUMIFS constantly when comparing figures. Oftentimes it's about comparing latest estimates with previous forecasts or budgets in an earlier instances of the same file (although with a different name)...
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...
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...
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.
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...
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?.
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...
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...
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...
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...
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...
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...
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...
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...
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>...
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...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.