Anderson 123
New Member
- Joined
- Jan 24, 2018
- Messages
- 3
I have a year end sale figure of £80,000 and want to divide this between 12 months in way that starts from Jan to Dec, and the Jan Sale not to be less than £4,000 and each month the sale increase slightly with a few fluctuations in Sep, Feb and March when there is seasonality and the sales are slow.
The total of all 12 months should add up to £80,000. is there an formula that forecasts the sales amounts in each month for me?
The total of all 12 months should add up to £80,000. is there an formula that forecasts the sales amounts in each month for me?