ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Forecasting Sales using the Forecast Function (https://www.excelbanter.com/excel-worksheet-functions/49266-forecasting-sales-using-forecast-function.html)

Sharon T

Forecasting Sales using the Forecast Function
 
I am using data in units and dollars by month from this year in an effort to
do a quick and dirty sales forecast for next year. I used the units as the
independent variable and the dollars as the dependent variable. The units
for one product that I was trying to do this with were all less than 75 per
month and the dollars were no more than $10,000 per month. In fact, $10,000
is probably the average. The forecasted number came up to 4590.01. I am
doing something wrong because the number makes no sense. Can anyone help?


All times are GMT +1. The time now is 09:58 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com