forecasting

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

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

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

Hello, I am a total newbie at forecasting and have a question about the forecasting function. I have three months worth of sales data for 8 SKUs. I need to predict the next six months of sales for these SKUs. Would the =FORECAST(x, known_y's, known_x's) function work for me here? Here's...

What I'm trying to achieve is to spread amounts across columns. In the columns C to M below, this represents future months income, i.e. what is actually received from customers in the month. However, the income received is prepaid, so it is for future months. Column B represents the number of...

Hi :) I am working on a project to forecast monthly change of inflation rate. I used SLR but the forecast doesnt seem to be correct. Could someone take a look please? :confused: I am also not sure how to diagnose time series (stationarity, trend, ARMA..) in Excel( is this even possible?) I...

Hi everyone, I have recently been asked to make changes to a sales forecast. I've never done a task like this before but I would like to make a 5 year sales projection based on historical data from 2010-2016. Every company deals with different items, and so, it becomes difficult to follow...

Hi, If I have a portfolio with, for example, a return of 5% and standard deviation of 7% how can I graph a growth of a thousand yearly over 40 years? Also, how can I graph the same chart but with an 80% confidence interval? I think I know how to do the first part: make a table with...

Good day any help I can attain will be awesome. Issue: Based on two cells I would like to know the probability that the next input will meet the desired result. Example Months Yield (The expected yield in 5months is 10%) 5 10% 1 3% (The current...

I'm looking to get a formula for end of day projection for order lines based on historical percentages for each of our hourly order pulls. Below is an example: 6am pull - 100 lines (historically 50% of daily volume) 7am pull - 50 lines (historically 25% of daily volume) 8am pull - ...

Hi guys!! I need to forecast in Excel using a Logarithmic function for the following data: <colgroup><col style="width: 73px"><col width="105"><col width="76"></colgroup><tbody> Year Year Number Profit 2012 0 24,992 2013 1 41,521 2014 2 61,105 2015 3 82,340 </tbody> I need to find...

I'm trying to trend out some numbers. I have two sets of numbers: The first we can call a "local" projection and the second we can call a "national" projection. For the national projection I know all 3 numbers: Low, Medium, High For the local projection I know only 1 number: Low I would...

I am wondering if its possible to write a macro that can find a relationship between columns in the worksheet found on the link below and make possible forecasts based on the relationship. https://www.dropbox.com/s/06hpjgcxuh61vkg/FIND%20A%20RELATIONSHIP.xlsx?dl=0 The worksheet has two...

I have table a which shows; - the number of phone calls made MTD - against the target number of calls for the month - the Percentage to monthly target at the end of last week A B C D...

Hi, I have PowerPivot model with order data. I would like to forecast the number of orders being paid out in the future. In a normal Excel spreadsheet this is easy for me to do with SUMPRODUCT on a table with distribution. For example 50 % of all order are paid out same day (day 0), 25 % day...

Hello, I'm running into a small problem here that I'm hoping someone can help out with. If I forecast a small number of units for a group of customers, then break it down based on historical customer sales, how do I sort out the rounding so that the break down will equal my group forecast...

hi. Say you have multiple excel sheets where forecasting is done daily. For example, sheet one headings: Depot, department, location, 01/09/10, 02/09,10, 03/09/10 and then second sheet is similar but: Depot, department, location, 02/09/10, 03/09/10, 04,09, 10 - as you can see each day...

I am trying to forecast revenue by end of year based on one number and the exponential growth rate for several clients. For example, I have the number 150 and the growth rate is .5%, 150(1+.005)^1 for the first month. For the second month I want it to be equal to month 1's results plus the...

My boss wants me to create a spreadsheet that shows inventory sold and what the percentage of each size sold. He also wants the inventory on hand for those same items and what percentage of size's we have. He needs this so he can decide what to buy on the next purchase order to keep the...

Hello, I have my forecast for each month in 2014 of my budget. I want to forecast how many tickets I will be able to produce with that budget amount. I have the historical data from 2013 to use. I want to forecast how many tickets I will have February 2014 - December 2014. Is there any way to...