Instructions

Creating a Budget

In this assignment you will create a spreadsheet and a chart to help a hypothetical couple work out their budget. You will submit a Microsoft Excel spreadsheet following the directions below to the appropriate submission folder by the due date. You will name this file W4P_LastName.xlsx.

Please Note:Information to help you with this project is available in the Week 4 online lectures, your textbook, as well as Microsoft Excel Help (F1). Your professor is also a great resource. If you work ahead, you can post questions about this assignment in the Questions for the Professor area in Course Resources and still submit your assignment on time.

Scenario

Tom and Sally were trying to get a handle on their budget. They heard that MS Excel could help them with that.  Tom is going to school and has cut back on his hours. Sally has finished her associate’s degree and is working full time. They want to look at the last three months of their income and expenses to see where they can make changes.

Part I – The Spreadsheet

First, in an Excel Spreadsheet, create a budget to show Tom and Sally’s income, expenses, and money leftover each month (Net). Create formulas in your spreadsheet for your calculations using the following data:

  • Tom brought home $1,000 a month for January, February, and March.
  • Sally brought home $1,900, $2,000, and $1,975 respectively for those three months.
  • They paid $1,000 for rent and utilities each month.
  • They paid $88 for insurance each month.
  • They paid $60 for cell phones and $60 for Internet/TV each month.
  • They spent $600, $750 (due to a big birthday bash), and $500 on food respectively.
  • Their car payment and gas came to $225, $250, and $300 respectively.
  • Entertainment and gifts were $75, $100, and $45 respectively.
  • They paid a little extra on their credit card $150, $125, and $100 respectively.
  • They allocated $200 each month for personal grooming and health care.
  • They put $100 each month into savings.
  • Miscellaneous Expenses came to $200, $100, and $400 respectively.

A sample budget layout is included below as an example of one way to lay out a budget.

Example Budget Layout

Part II – The Chart

Once you have worked out the budget spreadsheet, use the tabs at the bottom of the page to open another sheet. Here you will create a chart similar to the example below using the tools you learned about in the lectures and the textbook. On the new sheet:

  1. Create a column chart to visually represent their monthly expenses. If you have a challenge getting the chart on this sheet, research how to move your chart using your reading or Help (F1). You might also try right clicking on the chart.
  2. Add a descriptive title to the chart.

Example Line Chart

Part III – Changing Values

  1. Copy everything from Sheet 1 (the budget calculations) and paste it into a new worksheet.
  2. Change values for Sally’s March income to $200 more. Let’s say that they didn’t use as much heat in March and their utilities were $75 less (you could use a formula to figure out $75 less but you don’t have to). See how the totals change automatically if you used formulas correctly. If the values did not change, check your formulas and try them again. Seek help if you can’t figure this out.
  3. Rename each of your three spreadsheets with descriptive names.

By the assigned due date, submit this budget to the appropriate submission folder. In the message box, share how the process of creating this went for you, including any challenges, successes, or insights.

Attachments

 

Order Solution Now

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

In the dynamic world we currently live in, it’s becoming increasingly difficult for students to balance academics, co-curricular activities and entertainment among others. Students are required to submit countless assignments in a short time frame. These assignments should not be taken lightly as they form a major part of the grade when it comes to the end of the semester. Understanding the value of education and how these grades are important to students, Infinite Essays has made it its mission in life to offer customized essays to students at an affordable cost.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

There are plenty of reasons why you should order a paper with Infinite Essays. We have reliable writers who are also very competent. They have over the years managed to work under tight schedules and deadlines. Whenever you order an essay with Infinite Essays, you are guaranteed a fast turnaround of your project and this is done on time. Other than writing custom papers, our writers provide value added services that include academic assistance in the areas that they have specialized in. We ensure that the work that we offer is free of plagiarism. Infinite Essays does not condone plagiarism in whatsoever manner. Our writers are very experienced and can handle of sorts of formats such as Turabian, Chicago, Harvard as well as APA and MLA. Infinite Essays covers a wide range of topics. At the moment, we specialize with over 68 topics. We understand the importance of maintaining confidentiality when dealing with our clients. It’s for this reason that we will never reveal the identity of our clients to whoever may be interested. Finally, we offer the most competitive rates in the industry.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Whenever you want to make an order with us, you will use our automated online ordering system. If you are having some difficulties of any sort, feel free to contact our live support and they will be more than happy to assist you. Ensure that you fill all the relevant information regarding your order. This is the area where you have to include the deadline of your assignment, the formatting style to be used and even the kind of academic paper you desire. The more information you give to our writers, the better.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Brief explanations of how our services work 1. Provide us with the necessary instructions. Go to the Order Now page and click the order now button. This is the part where you have to attach all the relevant attachments. At the same time, remember to add the instructions sheet here. Once you are sure that you have submitted all relevant information, please submit the final draft to us. 2. The second step will involve paying for the services. This is where an invoice will be sent to you. However, the easiest process is clicking the payment link and following all the prompts that come along. At the moment, all payments are made through PayPal only. 3. Working on your paper. Once you have made the payment, we will assign the order to a writer who will follow the instructions. Remember that our writers will spend countless hour laboring to ensure that the work they provide is meticulously researched. 4. Download your paper. When the writer is finished with the assignment, they will submit it to our writers who will then go through the paper to ensure that the paper has followed all instructions and there are no grammatical errors. We will then forward a copy of the assignment to your email. 5. Tell your friends. We always happy to receive a referral. Whenever a friend tells us that you recommended our services to them, we will give you a 40 percent discount for your next order. Whenever you have provided us with the necessary details, we will forward them to qualified writers who will handle the assignment for you. Remember that the writers will begin working on the assignment immediately. This is the sole reason we encourage our clients to provide their exact specifications during the first time.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Tackling an order may be challenging but we always offer the best. Before the assignment can be passed to you by our writers, it will be passed through a team of qualified editors and proofreaders to ensure that the paper is accurate and of the required quality. Once the editors are satisfied with the assignment, they will forward the assignment to your account and a copy to your email.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Discounts We offer the best prices in the industry. We currently have a 20 percent discount for all of our customers. If you feel the budget is putting a strain on you, contact our live support and they might consider you case. We treat each case differently. Remember that our main goal is to continue with education transformation. At the moment, we only accept payments in form of PayPal.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline

Why Choose Us While there are many companies in the writing service industry claiming to offer platinum services, none can match the services offered by Infinite Essays. Some of our writers have been with us since 2010. The testimonials that have been written by some of our happy customers is an indication of the good services that we offer.

Click HERE to order a unique plagiarism free paper done by 

professional writers and delivered before your deadline