Hi all,
I have been given a piece of work to carry on which I am more than happy to do however, there is an element within that has me confused as it just doesn't look or feel right.
So the data is laid out like this and is manually updated through templates sent in.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Value of Batch
[/TD]
[TD]Remitted to Client
[/TD]
[TD]On Arrangement
[/TD]
[TD]Potential total Collection
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]£36,833[/TD]
[TD]£5,065[/TD]
[TD]£0.00[/TD]
[TD]£5,065[/TD]
[/TR]
</tbody>[/TABLE]
So the Value of Batch is the total amount for all the work.
Remitted to Client is out of the Value of Batch how much was returned.
On Arrangement is any additional costs.
Potential Total Collection Remitted to Client + On Arrangement.
There another table which is next to the one above with the same headings. That table is the out-sourced work whereas the above is internal.
Simple stuff.
There is another table below which is formula driven.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Total Warrant
[/TD]
[TD]% collection rate
[/TD]
[TD]% Potential Collection
[/TD]
[TD]Income if all work given to Internal
[/TD]
[TD]Potential if all work given to Internal
[/TD]
[TD]Income / loss to us
[/TD]
[TD]Potential Income / loss to us
[/TD]
[/TR]
[TR]
[TD]£71,400[/TD]
[TD]14%[/TD]
[TD]14%[/TD]
[TD]£9,818.40[/TD]
[TD]£9,818.40[/TD]
[TD]-£4,332.07[/TD]
[TD]-£4,332.07[/TD]
[/TR]
</tbody>[/TABLE]
So the Total Warrant is the Internal's Value of Batch + out-sourced Value of Batch.
% collection rate is Remitted to Client / Value of Batch.
% Potential Collection is Potential total collection / Value of Batch.
Income if all work given to Internal is Total Warrant * % collection rate.
I guess my question is, that bottom equation : Income if all work given to Internal is Total Warrant * % collection rate. doesn't look right.
Surely you can't use the 14% against the £71,400 seeing as the 14% was originally calculated for Internals work?
for that week. In reality, it would be very difficult to calculate their income had they got all of the warrants. Am I right?
I was thinking of using AVERAGE however, again, I am stuck in the same position. Is there a way to do this? As I'm racked my brain over it and getting burnt out.
Thanks!
I have been given a piece of work to carry on which I am more than happy to do however, there is an element within that has me confused as it just doesn't look or feel right.
So the data is laid out like this and is manually updated through templates sent in.
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]Value of Batch
[/TD]
[TD]Remitted to Client
[/TD]
[TD]On Arrangement
[/TD]
[TD]Potential total Collection
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]£36,833[/TD]
[TD]£5,065[/TD]
[TD]£0.00[/TD]
[TD]£5,065[/TD]
[/TR]
</tbody>[/TABLE]
So the Value of Batch is the total amount for all the work.
Remitted to Client is out of the Value of Batch how much was returned.
On Arrangement is any additional costs.
Potential Total Collection Remitted to Client + On Arrangement.
There another table which is next to the one above with the same headings. That table is the out-sourced work whereas the above is internal.
Simple stuff.
There is another table below which is formula driven.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Total Warrant
[/TD]
[TD]% collection rate
[/TD]
[TD]% Potential Collection
[/TD]
[TD]Income if all work given to Internal
[/TD]
[TD]Potential if all work given to Internal
[/TD]
[TD]Income / loss to us
[/TD]
[TD]Potential Income / loss to us
[/TD]
[/TR]
[TR]
[TD]£71,400[/TD]
[TD]14%[/TD]
[TD]14%[/TD]
[TD]£9,818.40[/TD]
[TD]£9,818.40[/TD]
[TD]-£4,332.07[/TD]
[TD]-£4,332.07[/TD]
[/TR]
</tbody>[/TABLE]
So the Total Warrant is the Internal's Value of Batch + out-sourced Value of Batch.
% collection rate is Remitted to Client / Value of Batch.
% Potential Collection is Potential total collection / Value of Batch.
Income if all work given to Internal is Total Warrant * % collection rate.
I guess my question is, that bottom equation : Income if all work given to Internal is Total Warrant * % collection rate. doesn't look right.
Surely you can't use the 14% against the £71,400 seeing as the 14% was originally calculated for Internals work?
for that week. In reality, it would be very difficult to calculate their income had they got all of the warrants. Am I right?
I was thinking of using AVERAGE however, again, I am stuck in the same position. Is there a way to do this? As I'm racked my brain over it and getting burnt out.
Thanks!
