Word Count: 1240
2.0Mobile Phone Plan Analysis1
3.0Mobile Phone Plan Analysis for individual3
4.0Using charts for analysing data6
Nowadays, there are so many mobile phone service providers along with various mobile phone plans that customers are spoilt for choice and cannot find the best plan for themselves. In this case, for helping customers choosing a well-suited plan, a systemic method of analysing mobile phone plan is indispensable. This report will concentrate on using excel and charts for collecting and analysing data of mobile phone plans.
2.0 Mobile Phone Plan Analysis
Twelve varying mobile phone plans belonging to four different companies (Optical Mobile, Tess Mobile, Volt Mobile and Wetend Mobile) were selected for analysis. Each company provide three different level plans for satisfying different consumer groups. Each mobile plan corresponds to five basic items including: Included call credit, Flag fall cost, Call rates per minute, SMS rates and Extras. According to above information, four further data comprising Monthly phone cost, Monthly SMS cost, Total monthly cost and Actual monthly cost were calculated on the basis of estimated parameters; 200 average calls with an average length of 2 minutes and 150 average SMS per month. In addition, calculation of Max No. of calls per month, a crucial standard in following analysis, was based on average length of 2 minutes per call and 150 average SMS per month; Calculation of Max No. of SMS per month, which were used in part of individual analysis, was based on no phone call cost. Both of these two data are the result of maximum value before the actual monthly cost touches the plan cap.
As the chart showed above, the relationship between plan cap and Max No. of calls per month are proportional on the whole. All low price plans, which are under $20, have an upper limit of 47 calls or lower. The medium priced plans that are between $20 and $50 permit much more sufficient No. of calls per month; The Max No. of calls is between 134 and 494. The top-level plans provide clients with most adequate amount. For instance, Tess Mobile $79 plan allows for over 1000 calls per month. Volt Mobile $79 plan and Optical $79 plan offer around 700 calls per month. Users even can obtain 486 calls chances from Wetend Mobile $59 plan. Despite the importance of Max No. of calls obviously, some other factors also should be considered for making the best choice for clients. The extras usually include restrictive free calls and data. All of plans provide free calls between users who belong to the same service provider. For example, an optical mobile user can have free calls to others optical mobile users. Therefore, if a client whose friends are almost using optical mobile, choosing the same provider as friends is a good way to reduce costs due to the free calls. Another important factor is the amount data, especially for users who really enjoy internet. Suitable amount of data is able to reduce costs as well.
3.0 Mobile Phone Plan Analysis for individual
The table and chart above are the personal plan analysis for Smith. She makes minimal calls and sends few SMS messages, so a low-priced plan is adequate for her. In addition, because most of her friends are Optical and Westend user, choosing the same provider as her friends is better for her. As a result, Optical Mobile $19 plan, Volt Mobile $19 plan and Westend Mobile $19 were selected. All the three plans are at low prices. However, Volt Mobile is not popular with her friends and No. of calls is only 24 in Westend Mobile plan. Therefore the Optical Mobile $19 plans is most recommended option for her. Mitchell
Mitchell is a business who makes a good deal of phone calls, and...