Money Matters
Task:
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 £1000
Annual 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 | |
 | Stuck? Launch SPB Helper! |
 | |
 | Student login Teacher login |