hi all.
More of a math problem than an excel problem.
Hypothetical..
Company A is in sales.
Everyday they log sales, and pending sales
So lets say.. at the 5th of the month, they have sold $50,000 worth of product, and have another $10,000 'as good as sold'
i'm trying to work out how to predict how much they will end up selling in total..
so far i have this (not sure if its even correct??)
A1 - 50,000 - B1 - Sold
A2 - 10,000 - B2 - Pending sales
A3 - 5 - B3 - Days into month
A4 - 10,000 - B4 - Sold per day
A5 - 20 - B5 - Days left in month
A6 - =(A4*A3)+A1+A2
would this seem like the correct way to do this?
More of a math problem than an excel problem.
Hypothetical..
Company A is in sales.
Everyday they log sales, and pending sales
So lets say.. at the 5th of the month, they have sold $50,000 worth of product, and have another $10,000 'as good as sold'
i'm trying to work out how to predict how much they will end up selling in total..
so far i have this (not sure if its even correct??)
A1 - 50,000 - B1 - Sold
A2 - 10,000 - B2 - Pending sales
A3 - 5 - B3 - Days into month
A4 - 10,000 - B4 - Sold per day
A5 - 20 - B5 - Days left in month
A6 - =(A4*A3)+A1+A2
would this seem like the correct way to do this?