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

Monday, 29 December 2014

R002 Assignment Task 5

A. The office manager has asked you to research items that can be given away to visitors to the stand
at the NEC exhibition.Use the internet to find at least three different items that would be suitable. You do not need to obtain a personalised quote - this will be done by the business when the choice has been made. Present your findings to the office manager, showing the search criteria you used.

The search criteria I used for (what I was looking for) were products that would be used/seen everyday - which have advertisement of Gnarly Hardware on them. They also needed to be bright and eye catching in different colours (if possible). I found four objects that I thought would be good and matched my criteria:

1. Lanyard(s) - colourful and can be used all the time with keys, USB sticks and key cards
 2. Key ring(s) - easy to advertise on and is seen all the time if on keys
 3. Sticky Note Pad(s) - could hold logo/watermark with Gnarly Hardware advertising
 4. USB stick - could have promotional media on the stick and also the logo on the USB itself
B. Record the copyright details of the images of the items you found so that the office manager
can request permission to use these images in the promotional material. 

All of the above images (apart from the sticky note pad) are free for the public to use as shown in the image below and are all from Wikimedia commons which states:

The sticky note pad is free for the public but some rights are reserved:

 Here are the URLs for the images of potential promotional use:
Lanyard - Lanyard.jpg
Keyring - Keyring.png
Sticky Note pad - Sticky Note pad.jpg
USB - SanDisk_Cruzer_Micro.png

C. The Gnarly Hardware stand at the exhibition will have a large computer screen. Create a resource to be used on the screen to promote the business at the exhibition.

The resource to be used:

Sunday, 28 December 2014

R002 Assignment Task 4

A. Some suppliers have informed you of the following changes:
• Bellas are no longer able to supply standard quality t-shirts in YS.
• Yings can now supply premium quality shirts, XXL polos at a unit cost of £2.75. They can
deliver in three days but orders must be for 50 or more items.
Update the relevant data file.

B. All stock in size XXL is running low. The factory manager wants a list, showing full details of
all the suppliers who can supply this size.
Produce a report showing this information. 


C. A customer has placed an urgent order for polos and t-shirts in size YS. The factory manager
wants to know if there are any suppliers who can deliver the goods tomorrow or the next day.

The factory manager will need to know the name of the supplier, the type of shirt or hat they
can supply, the quality, the cost per unit, the minimum order and the delivery time. It will be
useful to have the list sorted on cost, with the cheapest first.

Produce a report of suppliers who meet these requirements. 





R002 Assignment Task 3

The office manager would like you to send a personal letter to each sales manager and has
provided the wording of the letter for you to use.

For this task I used a tool in Pages '09 and Numbers called 'Mail Merge' which allows me to take data from a spreadsheet to a text document and merge certain fields (like the name at the top of the document or a date).

Link to the letters on Google Drive

R002 Assignment - Task 2

The office manager has asked you to design and create a new logo for use on all documentation.
The new name, Tailored Tops, must form part of the logo.
Create the new logo.


This is the finished logo:



R002 Assessment: Task 1


A. Read and respond to the email sent to you by the manager 


B. Create a filing structure to store the files used in this assessment

C. Set up your email system to enable you to efficiently:
  • Send emails regularly to each of the people listed below.
For this I used the Contacts tool to add the selected emails to the Gnarly Hardware group in my Gmail. This makes it easier to contact members of the group either with group emails or personal emails as the contacts are all there as a group.
Add them to my Gmail contacts so I could find and use their emails regularly (either one by one or all three at once) without having to type all the emails out manually.



  • Store incoming business messages, which will mainly come from the factory, other departments and customers 


  • For this I used the Contacts tool (to add the selected emails) and also the Label tool to allocate contacts to specific groups. This makes finding email conversations easier and keeps all the same type of email in the same place

    I created a folder/label in my Gmail where I moved all the conversations/messages from Admin, Factory, Finance and the Office Manager


    • Use a standard ending on all your emails
    For this I used the signature tool in the Gmail settings. This lets the receiver know my contact details and Gnarly Hardware's details to contact for queries or problems instead of them looking through a manual that comes with their product or a website  
    This is my 'Standard Ending'/signature on my emails.
    • Make sure that if anyone sends you an email when you are absent from work, they will receive an email to say that someone will deal with their query within 72 hours.
    For this I used the Out of Office tool in the Gmail settings:

    Here are the settings for my Out of Office Email which gets sent to everyone who emails me from the 28th of December onwards (until I stop it).

    Here is the finished email response when someone sends me an email. It states that the customers query will be dealt with within 72 hours as it is part of the Gnarly Hardware policy.

    D. Explain the email tools and etiquette that help you to communicate with others in a business
    context. 

    The tools that help me communicate with others in business are mainly the tools Gmail provides which include:
    • The Contacts tool (to save peoples details to use in the future or for reference)
    • The Group/Label tool (to send emails to lots of people at once quickly and store groups of people together)
    • The Signature tool (allows the user to easily add selected text/images to the end of emails they send to let other people know who they are and how to communicate with them etc...)
    • The Out of Office email tool (sends emails on your behalf to people who send you emails to say that you are out of your office for a certain period of time and how to contact you by other means or where to query instead) 
    It is important for all of the above that you are polite and courteous, making sure all the words are in the right context and spelt correctly showing professionalism.