Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Plan Options Option 1 - Pay-as-you-go Monthly Charges $40.00 Option 1- Pay-as-you-go Month Data Charges per Gigabyte $15.00 Monthly Charges Gigabytes Included 12 Taxes and
Plan Options Option 1 - Pay-as-you-go Monthly Charges $40.00 Option 1- Pay-as-you-go Month Data Charges per Gigabyte $15.00 Monthly Charges Gigabytes Included 12 Taxes and Fees Gigabytes Used (Rounded) Option 2- Unlimited Plan Data Charges Monthly Cost $70.00 Total Cost Taxes and Fees Option 2 - Unlimited Plan Rate 18% Month Monthly Charges Taxes Total Cost Which is best? Jan Feb Cost Comparison Mar Apr May Jun Total $0.00 Jan Feb Mar Apr May Jun Total $70.00 $70.00 $70.00 $70.00 $70.00 $70.00 $12.60 $12.60 $12.60 $12.60 $12.60 $12.60 $82.60 $82.60 $82.60 $82.60 $82.60 $82.60 $495.60 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. 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
Step 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