BuzzerBeater Forums

BB Global (English) > Kvarc's Staff Salary Calculator

Kvarc's Staff Salary Calculator

Set priority
Show messages by
From: BB-Marin

This Post:
00
106860.8 in reply to 106860.7
Date: 8/29/2009 8:37:53 AM
TrenseRI
III.2
Overall Posts Rated:
36003600
Second Team:
ChiLeaders
damn it Kivan, you're scaring people away!

I was looking forward to seeing which changes did Moutihno include but he removed his file from rapidshare. Thanks Kivan! We all know you were joking but your sarcasm just isn't helping sometimes...

Anyway, I'd politely like to ask Moutihno if he can post his changed calculator.

This Post:
00
106860.9 in reply to 106860.8
Date: 8/29/2009 8:42:39 AM
JMDCeltics
II.3
Overall Posts Rated:
32793279
Yes please, post the calculator again.

From: 7ton

This Post:
00
106860.10 in reply to 106860.9
Date: 9/10/2009 2:09:54 AM
Overall Posts Rated:
4545
I think the calculations could be improved. I have done similar things for myself and I can tell you what I did.

There are 3 costs associated with staff:

1. signing bonus
2. total wage he has received during the holding period
3. severance fee

What we want is to minimize the average weekly cost(awc) of our staff ([1+2+3]/no. of holding weeks). I determined the awc of my existing staff (including the signing bonus, which I think this calculator is missing) and the ones available in the staff market. Actually the awc changes every week. Initially it is usually very high due to the signing bonus. Then it comes down as the signing bonus is spread across the holding period and then reach a minimum(can be determined when 1,2,3 are available). It rises again because the staff is getting better pay. After reaching this minimum I compared this minimum awc with the awc of the staff available in the market. I would only replace my staff if I can find one with lower awc (in other words I am able to bid x amount to a particular staff since awc is related to 1, while 2 and 3 are constant for this particular staff I am bidding.) If no I wait and let the awc of my staff increases (it has already reached a minimum) until it reach the point where the awc of the available staff in the market is at least equal or lower than mine.

From: jacobomd

To: 7ton
This Post:
00
106860.11 in reply to 106860.10
Date: 9/10/2009 2:06:39 PM
JMDCeltics
II.3
Overall Posts Rated:
32793279
Great! That´s exactly what we all need, to know the moment in wich a staff member has reached a salary so high that is more profitable to change him into more economic other one. I usually take a look to transfer list, but i don´t know the exactly moment to do it or what saving supposes.
Best regards

From: 7ton

This Post:
00
106860.12 in reply to 106860.11
Date: 9/17/2009 3:27:00 AM
Overall Posts Rated:
4545
If you understand what I said you may try my spreadsheet program. I think you need to activate solver: tools -> macro -> visual basic editor -> tools -> reference -> and then you add solver

From: 7ton

To: 7ton
This Post:
00
106860.13 in reply to 106860.12
Date: 9/17/2009 3:28:53 AM
Overall Posts Rated:
4545
Sorry... how can I upload a file?

From: jacobomd

To: 7ton
This Post:
00
106860.15 in reply to 106860.13
Date: 9/17/2009 7:33:58 AM
JMDCeltics
II.3
Overall Posts Rated:
32793279
Maybe rapidshare, megaupload,gigasize....there are several pages to upload and share your files.

Message deleted
From: 7ton

This Post:
00
106860.17 in reply to 106860.15
Date: 9/17/2009 11:29:15 AM
Overall Posts Rated:
4545
From: jacobomd

To: 7ton
This Post:
00
106860.18 in reply to 106860.17
Date: 9/17/2009 12:28:09 PM
JMDCeltics
II.3
Overall Posts Rated:
32793279
Thank you friend. I hope to use it wisely.
Thanks again.