SOLVED

Monitoring funds usage

Occasional Contributor

I am a sales manager. I send funds to my salesman every weeks for them to purchase for me.

What I am trying to do is to monitor the weeks since when they have received funds that they havn’t completely used.

To give you a simple example, what I’d like to do is:

A - In week one, I send him 500$; This same week the salesman bought for 300$. There’s an outstanding of 200$ and total sales of 300$.

B - In week two, I send him 300$; This same week he bought for 100$. There’s an outstanding of 400$ and total sales of 400$.

C - In week three, I send him 300$; This same week he bought for 150$. There’s an outstanding of 550$ and total sales of 550$.

- What I want is a formula that would give me, for A, one week since the funds havn’t been entirely used;

- For B, two weeks since the total sales are 400$ and I gave him 500 in week one;

- For C, two weeks since the first 500$ have been filled, but now I am on the 300$ from the second week.

durendal_0-1660208498585.png

 

I hope you can understand what I am asking, don’t hesitate to ask question if you don’t understand. I’ve tried all sort of thing but I’m not able to solve this.

 

Thanks a lot

2 Replies
best response confirmed by Sergei Baklan (MVP)
Solution

@durendal Perhaps like in the attached file?

Riny_van_Eekelen_0-1660211186249.png

 

@Riny_van_Eekelen 

 

It is exactly what I was asking for. Thank you so much, really!

 

Wish you a good day