Thursday, 1 January 2015

R002 Assessment Task 7

Provide evidence of your file structure and the security measures you have taken to protect your
files from loss.

File Structure
Here is the file structure I have been using to store all the files from the previous tasks including screenshots uploaded to this blog and sent to the Office Manager.

Backups - to protect files from loss and corruption
To backup my work, I made a duplicate copy after every task (and if the task was particularly long, the exhibition resource for example, I backed it up multiple times throughout the task. With this duplicate copy I put it on a USB stick and I also uploaded it to the iCloud as a second measure.


R002 Assessment Task 6

A. The payments due to each sales manager need to be calculated. The sales managers each earn a
monthly salary of £2000. They also earn a bonus of £200 if their sales are more than the average
for the month and receive a mileage expenses payment of 40p for every mile driven.
The office manager has provided you with data on the sales and mileage of each sales manager
for this month. (Image below Task B)

B. Present the total sales for the four areas (North/Midlands/South East/South West), so that
they can be compared.


C. Fuel costs have risen, so the business has increased the mileage expenses payment to
sales managers to 47p for every mile. Use your solution to model the effect this will have on
the total amount to be paid to all sales managers this month.


D. The maximum amount the bonuses could be razed by is £80 (per person) to a total of £280 and costing the company a total of £46969.96


Link to the MAC Version of the spreadsheet
Link to the WINDOWS Version of the spreadsheet