Mark is looking to change his cell phone plan. He is considering switching to one of four plans
nanoy200xh1d
workbook1.xlsxSheet1
| Comparing Cell Plans | ||||||
| Mark's | Allowed Free | Paid (Not | Cost each | Total | ||
| Plan 1 | Expectation | (Included in Plan) | (Included in Plan) | (for extra) | Cost | |
| Night & Weekend Minutes: | 1000 | 750 | 250 | $0.10 | $25.00 | |
| Anytime Minutes: | 600 | 400 | 200 | $0.10 | $20.00 | |
| Text Messages: | 1250 | 750 | 500 | $0.10 | $50.00 | |
| Data (in MB): | 3000 | 1000 | 2000 | $0.20 | $400.00 | |
| Roaming (Call): | 150 | 0 | 150 | $0.05 | $7.50 | |
| Roaming (Data): | 250 | 0 | 250 | $0.10 | $25.00 | |
| Plan Cost: | $25.00 | $25.00 | ||||
| Total Cost for Plan 1 : | $552.50 | per month | ||||
| Mark's | Allowed Free | Paid (Not | Cost each | Total | ||
| Plan 2 | Expectation | (Included in Plan) | (Included in Plan) | (for extra) | Cost | |
| Night & Weekend Minutes: | ||||||
| Anytime Minutes: | ||||||
| Text Messages: | ||||||
| Data (in MB): | ||||||
| Roaming (Call): | ||||||
| Roaming (Data): | ||||||
| Plan Cost: | ||||||
| Total Cost for Plan 2 : | per month | |||||
| Mark's | Allowed Free | Paid (Not | Cost each | Total | ||
| Plan 3 | Expectation | (Included in Plan) | (Included in Plan) | (for extra) | Cost | |
| Night & Weekend Minutes: | ||||||
| Anytime Minutes: | ||||||
| Text Messages: | ||||||
| Data (in MB): | ||||||
| Roaming (Call): | ||||||
| Roaming (Data): | ||||||
| Plan Cost: | ||||||
| Total Cost for Plan 3 : | per month | |||||
| Mark's | Allowed Free | Paid (Not | Cost each | Total | ||
| Plan 4 | Expectation | (Included in Plan) | (Included in Plan) | (for extra) | Cost | |
| Night & Weekend Minutes: | ||||||
| Anytime Minutes: | ||||||
| Text Messages: | ||||||
| Data (in MB): | ||||||
| Roaming (Call): | ||||||
| Roaming (Data): | ||||||
| Plan Cost: | ||||||
| Total Cost for Plan 4 : | per month | |||||
| It looks like Plan X is the best one for Mark's cell usage. |
