Plan Options Usage Summa Plan Costs Option 1-Pay-as-you-go Minute Charges Data Charges per Megabyte Text Messages Included (no media) Text Message Charges Media Message Charges $0.05 $0.03 500 $0.05 $0.10 Calls Weekday Daytime Minutes Evening& Weekend Minutes Total Minutes Used tion 1 -P Minute Charges Data Charges" Text Message Charges Media Message Charges $85.30 $23.83 $9.90 $17.90 947 759 1706 Data Used (gigabytes) 0.79444 Total Charges Taxes and Fees (cell F15) Total Bill 136.93 $24.65 $161.58 Messaging Text Messages Sent Media Messages Sent Total Messages Sent Option 2-Rate Plan w/Overages Monthly Cost Minutes Included* Data Included (gigabytes) Messages (any type) Included Over-minute Charges Over-data Charges per megabyte Over-message Charges per message $89.00 700 698 179 877 13 1000 $0.10 $0.05 $0.10 Cellular Tax/Fee Rate # Kilobytes in a Gigabyte** # Megabytes in a Gigabyte** 18% 1048576 1024 Option 2 -Rate Plan w/Overages Monthly Cost Over-minute Charges Over-data Charges** Additional Message Charges 17 Option 3 -Unlimited Rate Note: There are1024 kilobytes in a megabyte and 1024 megabytes in a gigabyte Therefore there are 1048576 kilobytes in a 8igabyte (1024 x1024). Total Charges Taxes and Fees (cell F15) Total Bill 20 119.00 Night and weekend minutes are free for Option 2 23 Option 3 -Unlimited Monthly Cost 25 You are planning to switch your cell phone provider and there are three options available to you. You could choose a pay as-you-go plan, a traditional plan (which includes an allowance for minutes, data, and text and penalties for exceeding these allowances), and an unlimited plan. You want to evaluate which plan will be best for you. You have imported your calls, data usage, and text message usage from thelast month with your previous provider into separate worksheets in the workbook (Calls, Data, and Messages, respectively) so that you can how much each plan would cost you based on Total Charges Taxes and Fees(cell F15) Total Bill 29 30 our usage that month. Completethe tasks to compare vour bill for each plan option 34 36 Calculate the Monthly Cost for option 2. Reference the monthly cost for option 2 in the model inputs. Calculate the Over-minute Charges for option 2. This is the number of minutes used that exceed the minutes included in the plan times the over minute charges. Note: In this plan night and weekend minutes are free. Calculate the Over-data Charges for option 2. This is the amount of data used that exceed the data included in the plan times the Over-Data Charges per megabyte. Make sure that you adjust the over- data charges since the data used is reported in gigabytes. Calculate the Additional Message Charges for option 2. This is the number of total messages that exceed the messages included in the plan (notice this plan does not distinguish between text and media messages) times the Over-message Charges per message. Calculate the Total Charges for option 2. This is the sum of all of the different charges for this option. Calculate the Taxes and Fees for option 2. This is the total charges times the Cellular Tax/Fee Rate. Calculate the Total Bill for option 2. This is the sum of the total charges and the taxes and fees for this option. Calculate the Monthly Cost for option 3. Reference the monthly cost for option 3 in the model inputs. Calculate the Total Charges for option 3. This is the sum of all of the different charges for this option. Calculate the Taxes and Fees for option 3. This is the total charges times the Cellular Tax/Fee Rate. Calculate the Total Bill for option 3. This is the sum of the total charges and the taxes and fees for this option. Plan Options Usage Summa Plan Costs Option 1-Pay-as-you-go Minute Charges Data Charges per Megabyte Text Messages Included (no media) Text Message Charges Media Message Charges $0.05 $0.03 500 $0.05 $0.10 Calls Weekday Daytime Minutes Evening& Weekend Minutes Total Minutes Used tion 1 -P Minute Charges Data Charges" Text Message Charges Media Message Charges $85.30 $23.83 $9.90 $17.90 947 759 1706 Data Used (gigabytes) 0.79444 Total Charges Taxes and Fees (cell F15) Total Bill 136.93 $24.65 $161.58 Messaging Text Messages Sent Media Messages Sent Total Messages Sent Option 2-Rate Plan w/Overages Monthly Cost Minutes Included* Data Included (gigabytes) Messages (any type) Included Over-minute Charges Over-data Charges per megabyte Over-message Charges per message $89.00 700 698 179 877 13 1000 $0.10 $0.05 $0.10 Cellular Tax/Fee Rate # Kilobytes in a Gigabyte** # Megabytes in a Gigabyte** 18% 1048576 1024 Option 2 -Rate Plan w/Overages Monthly Cost Over-minute Charges Over-data Charges** Additional Message Charges 17 Option 3 -Unlimited Rate Note: There are1024 kilobytes in a megabyte and 1024 megabytes in a gigabyte Therefore there are 1048576 kilobytes in a 8igabyte (1024 x1024). Total Charges Taxes and Fees (cell F15) Total Bill 20 119.00 Night and weekend minutes are free for Option 2 23 Option 3 -Unlimited Monthly Cost 25 You are planning to switch your cell phone provider and there are three options available to you. You could choose a pay as-you-go plan, a traditional plan (which includes an allowance for minutes, data, and text and penalties for exceeding these allowances), and an unlimited plan. You want to evaluate which plan will be best for you. You have imported your calls, data usage, and text message usage from thelast month with your previous provider into separate worksheets in the workbook (Calls, Data, and Messages, respectively) so that you can how much each plan would cost you based on Total Charges Taxes and Fees(cell F15) Total Bill 29 30 our usage that month. Completethe tasks to compare vour bill for each plan option 34 36 Calculate the Monthly Cost for option 2. Reference the monthly cost for option 2 in the model inputs. Calculate the Over-minute Charges for option 2. This is the number of minutes used that exceed the minutes included in the plan times the over minute charges. Note: In this plan night and weekend minutes are free. Calculate the Over-data Charges for option 2. This is the amount of data used that exceed the data included in the plan times the Over-Data Charges per megabyte. Make sure that you adjust the over- data charges since the data used is reported in gigabytes. Calculate the Additional Message Charges for option 2. This is the number of total messages that exceed the messages included in the plan (notice this plan does not distinguish between text and media messages) times the Over-message Charges per message. Calculate the Total Charges for option 2. This is the sum of all of the different charges for this option. Calculate the Taxes and Fees for option 2. This is the total charges times the Cellular Tax/Fee Rate. Calculate the Total Bill for option 2. This is the sum of the total charges and the taxes and fees for this option. Calculate the Monthly Cost for option 3. Reference the monthly cost for option 3 in the model inputs. Calculate the Total Charges for option 3. This is the sum of all of the different charges for this option. Calculate the Taxes and Fees for option 3. This is the total charges times the Cellular Tax/Fee Rate. Calculate the Total Bill for option 3. This is the sum of the total charges and the taxes and fees for this option