MODELLING FINANCES
As the manager of a Mobiles R'us franchise
you are eligible for bonuses on a monthly and yearly (annual) basis.
To calculate your bonuses you must design a spreadsheet that uses an if
statement to help you calculate your bonuses.
Monthly Bonus
For sales above £20,000 per month your franchise gets £1000Annual Bonus
There is a standard bonus of £1000 paid to each franchise each year regardless of the sales figures (pays for the staff Christmas Party!)For sales above £300,000 per year a bonus of £10,000 is paid
For sales above £350,000 per year a bonus of £20,000 is paid
| THE GUIDE GRID | |
 Click here | Stuck? Launch SPB Helper! |
 |