Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

image text in transcribed

image text in transcribed 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 month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Culture Audit In Financial Services Reporting On Behaviour To Conduct Regulators

Authors: Dr Roger Miles

1st Edition

1789667755, 978-1789667752

More Books

Students also viewed these Accounting questions

Question

In most cases, medication is prescribed by physicians.

Answered: 1 week ago

Question

5. Describe how contexts affect listening

Answered: 1 week ago