O 2 Weekly Peak User Lb 25 example essay topic
Using Excel, I was able to enter text, charts, graphs and also formulas. I found that I could input data very easily and the package helped me present my data in a very clear and organized way, more so than if I had used a different application such as Word. If I had used word, I would have had to calculate and enter in the information I needed every time. However, by using Excel I could enter formulas and therefore I did not have to change everything myself when I entered in a new piece of information, but rather they changed automatically. By adding these formulas all my calculations were worked out for me. I could also see what would happen if I added different values to my spreadsheet without having to change everything else i.e. a computer model.
If I had have used Word then I would have had to do all calculations by myself. Using Excel I was able to add charts to my work which helped me to present my information even more clearly and also more attractively. Collecting Information I got the information which I required to do my assignment from 'The Link' catalog. I obtained this from The Link mobile phone store in Newry. I also did some ringing around to other mobile phone stores to inquire to see if their prices were the same or cheaper. Evaluation After finishing my assignment and using Microsoft Excel to complete it, I can now come to a conclusion on what tariff would be best for the student and the sales representative.
From doing my calculations in Excel I found that the best option for the student would be 'Orange, peak user lb 25 and under'. For one week the overall cost of making his or her calls including the line rental worked out to be lb 19.50. This was much better than other tariffs which I had researched like 'O 2 weekly peak user lb 25 and under' which worked out to be lb 25. For the sales representative I worked out that the cheapest and best option for her would be 'Vodafone weekly Peak user lb 25 and over'. The overall cost per week for this tariff came to lb 91.00 including line rental.
This is how I worked it out: I worked out the total cost for each the daytime calls, the evening calls, the weekend calls the international calls and the text messages by using the following formula: Duration of calls (or texts) Cost per minute (or text) I then added the costs for the daytime, evening, weekend, international calls and text messages to find the total costs of all calls and text messages. This gave me lb 84.00. To get the overall cost for the sales representative I then added the cost of the line rental, which was lb 7.00 per week to the total cost of all the calls, which was lb 84. Therefore I found that the over-call cost of using 'Vodafone weekly Peak user lb 25 and over' for the sales representative was lb 91.00. I then compared this with 'O 2 weekly, Peak User lb 25 and over', using the same method, which worked out to be lb 106.50 per week.
Therefore I found that the best option for the sales representative was 'Vodafone Weekly Peak User lb 25 and over' as it was cheapest.