Internet-based ProjectI.Choosing a Cellular Telephone Plan Collect information from your f...

Internet-based Project

I.Choosing a Cellular Telephone Plan Collect information from your family, friends, or consumer agencies such as Consumer Reports. Then decide on a cellular telephone provider, choosing the company that you feel offers the best service. Once you have selected a service provider, research the various types of individual plans offered by the company by visiting the provider’s website.

1. Suppose you expect to use 400 anytime minutes without a texting or data plan. What would be the monthly cost of each plan you are considering?

2. Suppose you expect to use 600 anytime minutes with unlimited texting, but no data plan. What would be the monthly cost of each plan you are considering?

3. Suppose you expect to use 500 anytime minutes with unlimited texting and an unlimited data plan. What would be the monthly cost of each plan you are considering?

4. Suppose you expect to use 500 anytime minutes with unlimited texting and 20 MB of data. What would be the monthly cost of each plan you are considering?

5. Build a model that describes the monthly cost C as a function of the number of anytime minutes used m assuming unlimited texting and 20 MB of data each month for each plan you are considering.

6. Graph each function from Problem.

7. Based on your particular usage, which plan is best for you?

8. Now, develop an Excel spreadsheet to analyze the various plans you are considering. Suppose you want a plan that offers 700 anytime minutes with additional minutes costing $0.40 per minute that costs $39.99 per month. In addition, you want unlimited texting, which costs an additional $20 per month, and a data plan that offers up to 25 MB of data each month, with each additional MB costing $0.20. Because cellular telephone plans’ cost structure is based on piecewise-defined functions, we need “if-then” statements within Excel to analyze the cost of the plan. Use the Excel spreadsheet below as a guide in developing your worksheet. Enter into your spreadsheet a variety of possible minutes and data used to help arrive at a decision regarding which plan is best for you.

9. Write a paragraph supporting the choice in plans that best meets your needs.

10. How are “if/then” loops similar to a piecewise-defined function?