forecasting

I am trying to determine how accurate a forecast is. For example, a customer requested 18 items. However, they only pick-up or take 6 items. The forecast of their needs is only 33.3% accurate. 18 forecasted 6 actual 33.3% accuracy Calculating a formula that can handle the reverse scenario...

Hi All, I have a large number of products that I would like to use the forecast formula to predict sales for based on Save %. Preferably, I would like the function to evaluate sales and save based on the product # in the first column (like a FORECASTIF formula), since there are hundreds of...

Using Excel 2007, I am trying to create a revenue forecast for the year based on several sets of criteria. Would like to have the spreadsheet calculate monthly payment values based on: 1. Payment options (1 payment, 2 payments, etc. through 6 payments) with established table of probability...

Having trouble with aligning a production schedule to produce the same number of days on hand [DOH] across three packaging types. A total of 480.3 units can be produced for the three packaging types. All three packaging types have different inventory levels and daily rate of sales [DROS]. how...

Hi All, Need to know how to calculate forecasting accuracy in excel and which is the best way to measure forecast accuracy. Quick response will be highly appreciated. Sample Data : <colgroup><col><col><col><col></colgroup><tbody> Actual P1 Calls Forecasted P1 Calls...

I am looking to see how to convert raw data as shown in the 1st table and manipulating the data to display as shown in the 2nd table. Specifically, I want the dates to be in a single column with a second column marking if the date is an actual or forecast. Any help would be greatly...

Hello, I have financial data that is arranged as follows: Account Code, Actual, Jan, Feb, Mar, ....Nov, Dec, YTD, Full Year Account Code, Budget, Jan, Feb, Mar, ....Nov, Dec, YTD, Full Year There are several hundred rows for each account code. I realize this is not the best table...

I have two formula's available for a cell. Its actual value, and a previously forecasted value. The actual value is found using an index formula and the forecasted value is a forecast function. i want to create a macro and link it to a button such that i can change which formula used in the cell...

Above I have a list of projects, each on a new row, each with a start and end date. I need to take this information and organize it into a month by month forecast, the outline of which should look something like this: Is this possible or reasonable to do? I've looked into vlookup(), match()...

Hi Everyone, I am working on a pharmaceutical inline forecasting project and need some readily available trending tool which can trend on monthly level considering different trends (best fit should be selected automatically) and historical seasonality. I have created one and want to share with...

Hi there, I have a complicated excel problem, which I want to solve with formulas if possible. Basically, it's a forecasting tool that changes based on different launch dates. For example: Launch Date is April 2013, and the quantity in that month is a percentage of the total market (say 50)...

Hi there, I have a simple forecasting query that I'm struggling to solve. Hoping you can help! I wish to forecast a target monthly growth rate, based on 12 months worth of data, for example: Date|Visits Dec-11|1000 Jan-12|1200 Feb-12|900 Mar-12|800 Apr-12|900 May-12|1000 Jun-12|720 Jul-12|450...

Hi all, New to mr excel and still relatively new to excel but loving it ... I'm looking to be able to get a projection or forecast value from a previous weeks data so that each week going forward always has a projection value based on previous weeks results ... Hope this makes sense? I've...

Hi I need help on writing this formula, never posted here but I am hoping someone can help. I have a model with changing payroll data and have made a tab of forecasted cumulative payroll. I want to forecast the different payroll taxes a business will incur in 2013. For example FUTA tax is only...

Hello All, I have started trying to do 10 -12 year forecasting model for my business. I tried using some various equations but none of them have given me what I am looking for. Starting in 2013 through 2018 I will be opening 30 new stores. 5 one year and six the next. so 2013 - 5, 2014 -6, 2015...

Hi all Im not sure if this is a basic math question but I'm scratching my head over it. Basically, I have been given some data relating to the seasonality of sales discounts to mess around with. I have managed to calculate the average discount for the year based on those trends without any...

Hi, I’m trying to work out which month a forecast is first made. Probably need to explain a bit more. I have a list of purchases along the left, 12 months along the top and then the various cost in the middle followed with a total at the end. I’m trying to work out which is first month the...

It seems to be commonly known that the Get.Cell function can be used to format (shade) cells conditionally based on whether they contain a formula or just a value (explained here: http://j-walk.com/ss/excel/usertips/tip045.htm). Can anybody figure out how to take this one step further and...

Hello, This is my first post. I found an article on Microsoft Office Online from MrExcel about calculating a forecast for Sales based on historical data. I tried this LINEST formula by selecting two cells side by side and entering the =linest(c2:c35) etc. This formula does not seem to work for...

This is a unique problem I have never encountered and I wanted to see if I could get some thoughts. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I am working on 5-year monthly projections in a clinical trial environment. Each trial will have different...