Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please use formulas for the answers. You are planning to switch your cell phone provider. You have imported your data usage from the last six
please use formulas for the answers.
You are planning to switch your cell phone provider. You have imported your data usage from the last six months with your previous provider and entered this information on the "Data" worksheet so that you can analyze which plan is best for you based on your prior data usage. The Cellular worksheet presents two options for a cell phone plan with the new company. You could choose a pay-as-you-go plan or an unlimited plan. You want to evaluate which plan will be best for you. Both plans provide unlimited calling and texting. The unlimited plan also offers unlimited data usage. The pay-asyou-go plan includes 12 gigabytes of data. Any data you use beyond the 12 gigabytes will cost $15 per gigabyte. Complete the tasks to compare what your bill would be for both plan options based on the past data usage. \begin{tabular}{|c|c|c|} \hline A & C & D \\ \hline Month & Day & Megabytes Used \\ \hline Jan & 1 & 839 \\ \hline Jan & 2 & 232 \\ \hline Jan & 3 & 821 \\ \hline Jan & 4 & 580 \\ \hline Jan & 5 & 835 \\ \hline Jan & 6 & 753 \\ \hline Jan & 7 & 102 \\ \hline Jan & 8 & 566 \\ \hline Jan & 9 & 109 \\ \hline Jan & 10 & 733 \\ \hline Jan & 11 & 343 \\ \hline Jan & 12 & 553 \\ \hline Jan & 13 & 826 \\ \hline Jan & 14 & 451 \\ \hline Jan & 15 & 258 \\ \hline Jan & 16 & 498 \\ \hline Jan & 17 & 443 \\ \hline Jan & 18 & 245 \\ \hline Jan & 19 & 335 \\ \hline Jan & 20 & 807 \\ \hline Jan & 21 & 300 \\ \hline Jan & 22 & 781 \\ \hline Jan & 23 & 100 \\ \hline Jan & 24 & 720 \\ \hline Jan & 25 & 191 \\ \hline Jan & 26 & 399 \\ \hline Jan & 27 & 569 \\ \hline Jan & 28 & 694 \\ \hline Jan & 29 & 90 \\ \hline Jan & 30 & 617 \\ \hline Jan & 31 & 165 \\ \hline \end{tabular} E F G H K L M N 0 \begin{tabular}{|l|c|c|c|c|c|} \hline & \multicolumn{7}{|c|}{ Usage Summary } & Apr & May & Jun \\ \hline Month & Jan & Feb & Mar & Apr & \\ \hline Megabytes Used & & & & 0 & 0 \\ \hline Gigabytes Used & 0 & 0 & 0 & 0 & 0 \\ \hline Gigabytes Used (Rounded) & 0 & 0 & 0 & 0 & 0 \\ \hline \end{tabular} * Note: 1 gigabyte is equal to 1024 megabytes (2.4) Complete the Gigabytes Used (Rounded) row (F7:K7) of the Cost Comparison table on the Cellular worksheet for Option 1. The phone carrier rounds the data used up to the nearest gigabyte for billing purposes. a. Enter the rounded number of gigabytes used for January in cell (F7) by referencing its calculated value in the appropriate cell on the Data sheet. b. Reuse your formula to complete the Gigabytes Used (Rounded) for Option 1 for the remaining months. (2.1) Complete the Megabytes Used row (G4:L4) of the Usage Summary table on the Data worksheet. a. Build the formula to calculate total Megabytes Used for January (G4), by referencing the month name in G3 and the appropriate columns in the data table (B3:D183). b. Reuse your formula to calculate the Megabytes Used for the other months. c. Notice that the "Gigabytes Used" (G5:L5) row is already completed in the worksheet. "Gigabytes Used" is calculated as the "Megabytes Used" divided by 1024 (the number of megabytes in a gigabyte). d. The Gigabytes Used (Rounded) (G6:L6) row is also completed in the worksheet. Since the mobile carrier rounds the Gigabytes Used up to the next whole gigabyte, the ROUNDUP function is used to adjust the Gigabytes Used up to the next integer. (2.7) Complete the Which is best? row ( F17:L17) of the Cost Comparison table on the Cellular worksheet. a. Notice that the costs associated with Option 2 are already calculated in the worksheet. b. Write a formula to display "Option 1" if the total cost of Option 1 is less than the total cost of Option 2 for that month. c. If the total cost of Option 2 is less than the total cost of Option 1, display "Option 2". d. Otherwise, display "No Difference". e. Reuse your formula to determine which option is best for each month and in cell L17 to determine which option is best overall. 6 (2.5) Complete the Data Charges row ([F8:K8) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Calculate the data charges for option 1 in January in cell (F8). b. The phone carrier charges $15 for each gigabyte used (rounded up to the next whole gigabyte) that exceeds the data amount included with the plan. c. Be sure to reference the Gigabytes Used (Rounded) in January as well as Data Charges per Gigabyte and Gigabytes Included from the Plan Options section of the worksheet. d. Display a zero if the data does not exceed the gigabytes included with the plan. e. Reuse your formula to complete the data charges for Option 1 for each month. (2.6) Complete the Total Cost row (F9:K9) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Calculate the total cost for option 1 in January in cell (F9). b. The total cost is the sum of the monthly charges, taxes and fees, and the data charges for January. c. Reuse your formula to complete the total cost for Option 1 for each month. (2.2) Complete the Monthly Charges row ( F5:K5) ) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Enter the monthly charges for January (F5) by referenceing the monthly charges for option 1 (C4) in the Plan Options table. b. Reuse your formula to complete the monthly charges for Option 1 for each month. (2.3) Complete the Taxes and Fees row ( (F6:K6) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Calculate the tax for January in cell (F6). b. The taxes and fees are calculated as the monthly charges in cell F5) (not including any data charges) times the taxes and fees rate (cell C12 ) on the Plan Options table. c. Reuse your formula to complete the taxes and fees for Option 1 for each month. You are planning to switch your cell phone provider. You have imported your data usage from the last six months with your previous provider and entered this information on the "Data" worksheet so that you can analyze which plan is best for you based on your prior data usage. The Cellular worksheet presents two options for a cell phone plan with the new company. You could choose a pay-as-you-go plan or an unlimited plan. You want to evaluate which plan will be best for you. Both plans provide unlimited calling and texting. The unlimited plan also offers unlimited data usage. The pay-asyou-go plan includes 12 gigabytes of data. Any data you use beyond the 12 gigabytes will cost $15 per gigabyte. Complete the tasks to compare what your bill would be for both plan options based on the past data usage. \begin{tabular}{|c|c|c|} \hline A & C & D \\ \hline Month & Day & Megabytes Used \\ \hline Jan & 1 & 839 \\ \hline Jan & 2 & 232 \\ \hline Jan & 3 & 821 \\ \hline Jan & 4 & 580 \\ \hline Jan & 5 & 835 \\ \hline Jan & 6 & 753 \\ \hline Jan & 7 & 102 \\ \hline Jan & 8 & 566 \\ \hline Jan & 9 & 109 \\ \hline Jan & 10 & 733 \\ \hline Jan & 11 & 343 \\ \hline Jan & 12 & 553 \\ \hline Jan & 13 & 826 \\ \hline Jan & 14 & 451 \\ \hline Jan & 15 & 258 \\ \hline Jan & 16 & 498 \\ \hline Jan & 17 & 443 \\ \hline Jan & 18 & 245 \\ \hline Jan & 19 & 335 \\ \hline Jan & 20 & 807 \\ \hline Jan & 21 & 300 \\ \hline Jan & 22 & 781 \\ \hline Jan & 23 & 100 \\ \hline Jan & 24 & 720 \\ \hline Jan & 25 & 191 \\ \hline Jan & 26 & 399 \\ \hline Jan & 27 & 569 \\ \hline Jan & 28 & 694 \\ \hline Jan & 29 & 90 \\ \hline Jan & 30 & 617 \\ \hline Jan & 31 & 165 \\ \hline \end{tabular} E F G H K L M N 0 \begin{tabular}{|l|c|c|c|c|c|} \hline & \multicolumn{7}{|c|}{ Usage Summary } & Apr & May & Jun \\ \hline Month & Jan & Feb & Mar & Apr & \\ \hline Megabytes Used & & & & 0 & 0 \\ \hline Gigabytes Used & 0 & 0 & 0 & 0 & 0 \\ \hline Gigabytes Used (Rounded) & 0 & 0 & 0 & 0 & 0 \\ \hline \end{tabular} * Note: 1 gigabyte is equal to 1024 megabytes (2.4) Complete the Gigabytes Used (Rounded) row (F7:K7) of the Cost Comparison table on the Cellular worksheet for Option 1. The phone carrier rounds the data used up to the nearest gigabyte for billing purposes. a. Enter the rounded number of gigabytes used for January in cell (F7) by referencing its calculated value in the appropriate cell on the Data sheet. b. Reuse your formula to complete the Gigabytes Used (Rounded) for Option 1 for the remaining months. (2.1) Complete the Megabytes Used row (G4:L4) of the Usage Summary table on the Data worksheet. a. Build the formula to calculate total Megabytes Used for January (G4), by referencing the month name in G3 and the appropriate columns in the data table (B3:D183). b. Reuse your formula to calculate the Megabytes Used for the other months. c. Notice that the "Gigabytes Used" (G5:L5) row is already completed in the worksheet. "Gigabytes Used" is calculated as the "Megabytes Used" divided by 1024 (the number of megabytes in a gigabyte). d. The Gigabytes Used (Rounded) (G6:L6) row is also completed in the worksheet. Since the mobile carrier rounds the Gigabytes Used up to the next whole gigabyte, the ROUNDUP function is used to adjust the Gigabytes Used up to the next integer. (2.7) Complete the Which is best? row ( F17:L17) of the Cost Comparison table on the Cellular worksheet. a. Notice that the costs associated with Option 2 are already calculated in the worksheet. b. Write a formula to display "Option 1" if the total cost of Option 1 is less than the total cost of Option 2 for that month. c. If the total cost of Option 2 is less than the total cost of Option 1, display "Option 2". d. Otherwise, display "No Difference". e. Reuse your formula to determine which option is best for each month and in cell L17 to determine which option is best overall. 6 (2.5) Complete the Data Charges row ([F8:K8) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Calculate the data charges for option 1 in January in cell (F8). b. The phone carrier charges $15 for each gigabyte used (rounded up to the next whole gigabyte) that exceeds the data amount included with the plan. c. Be sure to reference the Gigabytes Used (Rounded) in January as well as Data Charges per Gigabyte and Gigabytes Included from the Plan Options section of the worksheet. d. Display a zero if the data does not exceed the gigabytes included with the plan. e. Reuse your formula to complete the data charges for Option 1 for each month. (2.6) Complete the Total Cost row (F9:K9) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Calculate the total cost for option 1 in January in cell (F9). b. The total cost is the sum of the monthly charges, taxes and fees, and the data charges for January. c. Reuse your formula to complete the total cost for Option 1 for each month. (2.2) Complete the Monthly Charges row ( F5:K5) ) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Enter the monthly charges for January (F5) by referenceing the monthly charges for option 1 (C4) in the Plan Options table. b. Reuse your formula to complete the monthly charges for Option 1 for each month. (2.3) Complete the Taxes and Fees row ( (F6:K6) of the Cost Comparison table on the Cellular worksheet for Option 1. a. Calculate the tax for January in cell (F6). b. The taxes and fees are calculated as the monthly charges in cell F5) (not including any data charges) times the taxes and fees rate (cell C12 ) on the Plan Options table. c. Reuse your formula to complete the taxes and fees for Option 1 for each monthStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started