Plan Options 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 Usage Summary Calls Weekday Daytime Minutes Evening & Weekend Minutes Total Minutes Used Plan Costs Option 1 - Pay-as-you-go Minute Charges Data Charges** Text Message Charges Media Message Charges 200 200 $10.00 $0.00 $0.00 $0.00 Data Used (gigabytes) Total Charges Taxes and Fees (cell F15) Total Bill $10.00 $1.80 $11.80 Messaging Text Messages Sent Media Messages Sent Total Messages Sent 0 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 1 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 $89.00 $0.00 $0.00 $0.00 Option 3 - Unlimited Rate $119.00 ** Note: There are 1024 kilobytes in a megabyte and 1024 megabytes in a gigabyte. Therefore there are 1048576 kilobytes in a gigabyte (1024x1024). Total Charges Taxes and Fees (cell F15) Total Bill $89.00 $16.02 $105.02 * Night and weekend minutes are free for Option 2 Option 3 - Unlimited 3 Monthly Cost $119.00 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. Please tell me which option is best/cheapest for you. Show your work in the solver TAKE SCREENSHOT. Total Charges Taxes and Fees (cell F15) Total Bill $119.00 $21.42 $140.42 Here are some constraints: 1. You use at least 200 mins during daytime every month. 2. You send at least 300 text messages & 150 Media Messages every month. 3. You use at least 4568 Megabytes for Data Plan Options 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 Usage Summary Calls Weekday Daytime Minutes Evening & Weekend Minutes Total Minutes Used Plan Costs Option 1 - Pay-as-you-go Minute Charges Data Charges** Text Message Charges Media Message Charges 200 200 $10.00 $0.00 $0.00 $0.00 Data Used (gigabytes) Total Charges Taxes and Fees (cell F15) Total Bill $10.00 $1.80 $11.80 Messaging Text Messages Sent Media Messages Sent Total Messages Sent 0 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 1 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 $89.00 $0.00 $0.00 $0.00 Option 3 - Unlimited Rate $119.00 ** Note: There are 1024 kilobytes in a megabyte and 1024 megabytes in a gigabyte. Therefore there are 1048576 kilobytes in a gigabyte (1024x1024). Total Charges Taxes and Fees (cell F15) Total Bill $89.00 $16.02 $105.02 * Night and weekend minutes are free for Option 2 Option 3 - Unlimited 3 Monthly Cost $119.00 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. Please tell me which option is best/cheapest for you. Show your work in the solver TAKE SCREENSHOT. Total Charges Taxes and Fees (cell F15) Total Bill $119.00 $21.42 $140.42 Here are some constraints: 1. You use at least 200 mins during daytime every month. 2. You send at least 300 text messages & 150 Media Messages every month. 3. You use at least 4568 Megabytes for Data