Answer Happy

the state. 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.99/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 3. Plan S 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, d costs 150 S D H 1 Coming cell Phone Services 2 Anna's Allowed 3 Expectation Free Pald Costeach Total Cont PLAN: $ Night and weekend Minute 100 Unlimited OS 5 Anytime Min SOS 300 2005 0.29 $50.00 1 Text Message 30 370 5 10 5 17.00 Hoaming Me 150 SS Accot Fee: 520.00 10 PUAN 1 TOTAL COST: S 17250 mm 11 PLAN 13 and Weekend Minute 13 Anytime Minutes Test Messages Roaming 18 Fee PAN TOTAL COST per month PLANS Night and wand Minutes Anyt Minute Text Me Ramin PLAN TOTAL COST perman 89°F Mostly sunny 5:26 PM