Answered step by step
Verified Expert Solution
Link Copied!

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

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

Step: 3

blur-text-image

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

More Books

Students also viewed these Accounting questions

Question

Question What is a Roth 401(k) feature?

Answered: 1 week ago

Question

Question Can employees make contributions to a profit sharing plan?

Answered: 1 week ago