Plan Options			Usage Summary			Plan Costs
Option 1 - Pay-as-you-go			Calls			Option 1 - Pay-as-you-go
Minute Charges	$0.05		Weekday Daytime Minutes	1073		Minute Charges	$85.30
Data Charges per Megabyte	$0.03		Evening & Weekend Minutes	633		Data Charges**	$17.87
Text Messages Included (no media)	500		Total Minutes Used	1706		Text Message Charges	$0.00
Text Message Charges	$0.05					Media Message Charges	$11.10
Media Message Charges	$0.10		Data Used (gigabytes)	0.59582
						Total Charges	$114.27
Option 2 - Rate Plan w/Overages			Messaging			Taxes and Fees (cell F15)	$20.57
Monthly Cost	$89.00		Text Messages Sent	441		Total Bill	$134.84
Minutes Included*	700		Media Messages Sent	111
Data Included (gigabytes)	1		Total Messages Sent	552		Option 2 - Rate Plan w/Overages
Messages (any type) Included	1000					Monthly Cost	$89.00
Over-minute Charges	$0.10		Cellular Tax/Fee Rate	18%		Over-minute Charges*	???
Over-data Charges per megabyte	$0.05		# Kilobytes in a Gigabyte**	1048576		Over-data Charges**	????
Over-message Charges per message	$0.10		# Megabytes in a Gigabyte**	1024		Additional Message Charges	?????
Option 3 - Unlimited			** Note: There are 1024 kilobytes in a megabyte and 1024 megabytes in a gigabyte. Therefore there are 1048576 kilobytes in a gigabyte (1024 x 1024).			Total Charges
Rate	$119.00					Taxes and Fees (cell F15)
						Total Bill
* Night and weekend minutes are free for Option 2
						Option 3 - Unlimited
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 the last 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 your usage that month. Complete the tasks to compare your bill for each plan option						Monthly Cost
						Total Charges	$0.00
						Taxes and Fees (cell F15)	$89.00
						Total Bill

This is set up in excel, and i need to type in a formula. So, just reference the name. Over Data charges are in gigabytes. Thank you!