Anna is thinking of changing her cell phone service, and she is comparing three plans: 1. Plan 1 has a $20/month access

[answerhappygod]

Anna Is Thinking Of Changing Her Cell Phone Service And She Is Comparing Three Plans 1 Plan 1 Has A 20 Month Access 1 (67.01 KiB) Viewed 61 times

Anna is thinking of changing her cell phone service, and she is comparing three plans: 1. Plan 1 has a $20/month access fee, unlimited nights and weekends, 300 anytime minutes plus $0.29/minute for minutes over 300, text messages cost $0.10 each, and roaming costs $0.39/minute whenever she leaves the state. 2. Plan 2 has a $40/month access fee, unlimited nights and weekends, 750 anytime minutes plus $0.29/minute for minutes over 750, text messages cost $0.05 each, and roaming costs $0.39/minute whenever she leaves the state. 3. Plan 3 has a $60/month access fee, unlimited nights and weekends, 1500 anytime minutes plus $0.19/minute for minutes over 1500, text messages are included in the anytime minutes (1 minute per message), and roam- ing is free. Her primary concern is costs during the summer when she is away from college, out of the cell phone company's state, and spending a lot of time communicating with her friends. Looking at her bills from last summer, and trying to predict what will likely happen this summer, she anticipates the following monthly cell phone usage during the summer months; • 400 minutes nights and weekends • 500 anytime minutes • 370 text messages 150 roaming minutes Develop an Excel worksheet like the one shown in Figure 73 to determine which plan is the best for Anna. costs E G 1. Comparing cell Phone Services 2 Anna's Allowed 3 Expectation Free Pald Costeach Total Cost 4 PLAN 5 Night and Weekend Minute 400 Unlimited OS s 6 Anytime Minutes 500 300 200 $029 S SRO 2 Text Messages 170 0 305 0.10 $ 17.00 Roaming Minutes 150 o 1505055850 9 Acc Food $ 20.00 10 PLAN 1 TOTAL COSTI 5 17250 per month T1 PLAN 32 Night and Weekend Minutes 13 Anytime Minutes 10 Text Messa 29 Roaming Minutes 16 Ace Feed TU PLAN 2 TOTAL COST per month PLAN Night and weekend Minute 20 Anytime Minutes 21 Text Messages Roaming Minutes Acest 24 PLAN TOTAL COSTI Der month