forecasting

  1. J

    Forecast Tickets using Budget

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

    How to Caculate Accuracy

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

    FORECAST Based on Column Value.

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

    Calculating values based on variables

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

    Inventory - Days On Hand Help

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

    Forecasting Accuracy in Excel

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

    Consolidate forecasts and actual dates into one column with a helper column

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

    Combine Budget and Actual Months to create "Forecast"

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

    macro to choose between different formula's

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

    I have rows of records, each w/ a start and end date. How can I compile and summarize these in a separate table, month by month

    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()...
  11. G

    Pharmaceutical Forecasting trending seasonality model

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

    Changing Calendar -- Too complicated for me!

    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)...
  13. H

    Forecasting Average Monthly Growth Rates

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

    Projections/forecasting

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

    Help on calculating payroll taxes

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

    General Data Forecasting

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

    Seasonailty and Target Average Discounts

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

    Find out which month purchases are 1st forecast

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

    Conditional formatting based on the specific TYPE of formula in a cell (e.g. flat-lining versus summing)

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

    Calculate a trendline forecast

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

We've detected that you are using an adblocker.

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.
Go back
Back
Top