Week 4 Project

I need help with a English question. All explanations and answers will be used to help me learn.

Don't use plagiarized sources. Get Your Custom Essay on
Week 4 Project
Just from $13/Page
Order Essay

First, in 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 3 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. Part 2 The Chart: Open another spreadsheet. Create a column chart to visually represent their monthly expenses. Add a descriptive title to the chart. Part 3: Copy everything from sheet 1 and paste it into a new worksheet. Change values for Sally’s March income to $200 more. The totals should change if you used the formulas correctly. Rename each of the 3 spreadsheets with descriptive names.

superadmin

Recent Posts

Consider the following information, and answer the question below. China and England are internation

Consider the following information, and answer the question below. China and England are international trade…

4 years ago

The CPA is involved in many aspects of accounting and business. Let’s discuss some other tasks, othe

The CPA is involved in many aspects of accounting and business. Let's discuss some other…

4 years ago

For your initial post, share your earliest memory of a laser. Compare and contrast your first percep

For your initial post, share your earliest memory of a laser. Compare and contrast your…

4 years ago

2. The Ajax Co. just decided to save $1,500 a month for the next five years as a safety net for rece

2. The Ajax Co. just decided to save $1,500 a month for the next five…

4 years ago

How to make an insertion sort to sort an array of c strings using the following algorithm: * beg, *

How to make an insertion sort to sort an array of c strings using the…

4 years ago

Assume the following Keynesian income-expenditure two-sector model:

Assume the following Keynesian income-expenditure two-sector model:                                                AD = Cp + Ip                                                Cp = Co…

4 years ago