17-Calculate the Monthly Cost for option 2. Reference the monthly cost for option 2 in the model inputs.
18	4	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.
19	3	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.
20	3	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.
21	1	Calculate the Total Charges for option 2. This is the sum of all of the different charges for this option.
22	1	Calculate the Taxes and Fees for option 2. This is the total charges times the Cellular Tax/Fee Rate.
23	2	Calculate the Total Bill for option 2. This is the sum of the total charges and the taxes and fees for this option.
24	2	Calculate the Monthly Cost for option 3. Reference the monthly cost for option 3 in the model inputs.
25	2	Calculate the Total Charges for option 3. This is the sum of all of the different charges for this option.
26	2	Calculate the Taxes and Fees for option 3. This is the total charges times the Cellular Tax/Fee Rate.
27	2	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 0.05 0.03 500 0.05 0.10 Calls Weekday Daytime Minutes Evening &Weekend Minutes Total Minutes Used Minute Charges Data Charges Text Message Charges Media Message Charges $85.30 $23.83 $9.90 $17.90 947 759 1706 6 Data Used (gigabytes) 0.79444 Total Charges Taxes and Fees (cell F15) Total Bill $136.93 $24.65 $161.58 10 2 -Rate Plan w/Over $89.00 700 698 179 877 Monthly Cost Minutes Included Data Included (eigabytes) Messages (any type) Included Over-minute Charges Over-data Charges per megabyte Over-message Charges per message 12 13 Text Messages Sent Media Messages Sent Total Messages Sent 1000 0.10 0.05 Cellular Tax/Fee Rate # Kilobytes in a Gigabyte.. # Megabytes in a Gigabyte.. Option 2-Rate Plan w/Overages Monthly Cost Over-minute Charges Over-data Charges Additional Message Charges 15 18% 1048576 1024 17 Total Charges Taxes and Fees (cell F15) Total Bill 3 -Unlimited Note: There are 1024 kilobytes in a megabyte and 1024 megabytes in agigabyte. Therefore thereare 1048576 kilobytes ina gigabyte (1024 x 1024) 20 Rate $119.00 Night and weekend minutes are free for Option 2 Option 3-Unlimited Monthly Cost 25 27 29 You are planning to switch your cell phone provider and there are three options availableto you. You could choose a 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, datausage, 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 that month. Complete the tasks to com r bill for each plan option 31 32 35 36