Access Millions of academic & study documents

It 210 hw 6 solution

Content type
User Generated
Showing Page:
1/75

Sign up to view the full document!

lock_open Sign Up
Showing Page:
2/75

Sign up to view the full document!

lock_open Sign Up
Showing Page:
3/75

Sign up to view the full document!

lock_open Sign Up
Showing Page:
4/75

Sign up to view the full document!

lock_open Sign Up
End of Preview - Want to read all 75 pages?
Access Now
Unformatted Attachment Preview
Prepare a personal budget for one month. Be sure to think through your sources of income and expenses. Be as detailed as you wish; but include cells that calculate the following: Income (which calculates the sum of all income sources), Expenses (which calculates the sum of all expenses), and Savings (which calculates the difference between the total income and expenses). After completing your budget, complete the tasks to create named ranges that reference the important cells outlined above. Plan Options Usage Summary Option 1 - Pay-as-you-go Minute Charges Data Charges per Megabyte Text Messages Included (no media) Text Message Charges Media Message Charges $0.05 $0.03 500 $0.05 $0.10 Option 2 - Rate Plan w/Overages Monthly Cost Minutes Included* Data Included (gigabytes) Messages (any type) Included Over-minute Charges Over-data Charges per megabyte Over-message Charges per message $89.00 700 1 1000 $0.10 $0.05 $0.10 Option 3 - Unlimited Rate $119.00 * Night and weekend minutes are free for Option 2 Calls Weekday Daytime Minutes Evening & Weekend Minutes Total Minutes Used 947.00 759 1706 Data Used (gigabytes) 0.79444 Messaging Text Messages Sent Media Messages Sent Total Messages Sent 698 179 877 Cellular Tax/Fee Rate # Kilobytes in a Gigabyte** # Megabytes in a Gigabyte** 18% 1048576 1024 ** Note: There are 1024 kilobytes in a megabyte and 1024 megabytes in a gigabyte. Therefore there are 1048576 kilobytes in a gigabyte (1024 x 1024). You are planning ...
Purchase document to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Studypool
4.7
Indeed
4.5
Sitejabber
4.4