Posted: August 2nd, 2022

module 13-budget part 2

PLEASE ANSWER THE QUESTIONS IN THE EXCEL SPREADSHEET

2

>Instructions Get data from Budget

3 6 4

0.txt

Insert a

Pivot

Table on a new sheet labeled “Pivot”

1 For the entire year, rent is what % of Total

Expense

s? 2

In January,

Electricity

was what % of total expenses for that month? 3

The December

Gifts

expense was what % of total Gifts expense? 4

What % of total rent was spent in March? 5 What was the total income ($) for the year? 6

What was the bonus amount ($) for July? 7 March OT was what % of total income for the year? 8 Salary

was what % of total income for April? 9 September commission was what % of total commission? 10 What was the OT amount for October? 11 What was the total income for July? 12 How much was earned in bonus for the year? 13 What % of total bonus was earned in October? 14 What were the total expenses in May? 15 What was the total income in May? 16 In what month was the highest savings? 17 What was the highest amount saved in a single month? 18 In April what % of total expenses was for food? 19 In April food was what % of the total spent on food for the year? 20 Food

is what % of the expenses for the year? 21 Create a Pivot Chart – Column style Filter so only (2) Expenses are showing on your chart 22 Copy & Paste as Picture your Chart to a PowerPoint Document 23 Add (2) notes to your PowerPoint; one note explaining each Expense

BP-MODULE 13

Expense

10

7 Bonus

4 Bonus 315

1 Bonus 288

12

11 Cable, Internet, TV 152

10 Cable, Internet, TV 152

9 Cable, Internet, TV 152

8 Cable, Internet, TV 152

7 Cable, Internet, TV 152

6 Cable, Internet, TV 152

5 Cable, Internet, TV 152

4 Cable, Internet, TV 152

3 Cable, Internet, TV

2 Cable, Internet, TV

1 Cable, Internet, TV 152

12

11 Car payment, fuel, maintenance

10 Car payment, fuel, maintenance

9 Car payment, fuel, maintenance

8 Car payment, fuel, maintenance

7 Car payment, fuel, maintenance

6 Car payment, fuel, maintenance

5 Car payment, fuel, maintenance

4 Car payment, fuel, maintenance

3 Car payment, fuel, maintenance

2 Car payment, fuel, maintenance

1 Car payment, fuel, maintenance

7 Car payment, fuel, maintenance

0

12

11 Cell Phone 60

10/1/17 10 Cell Phone 60
9/1/17 9 Cell Phone 60
8/1/17 8 Cell Phone 60
7/1/17 7 Cell Phone 60
6/1/17 6 Cell Phone 60
5/1/17 5 Cell Phone 60
4/1/17 4 Cell Phone 60
3/1/17 3 Cell Phone 60
2/1/17 2 Cell Phone 60
1/1/17 1 Cell Phone 60

12

11 Commission 133

10 Commission 133

9 Commission

3

8 Commission 133

7 Commission 133

6/16/17 6 Commission 133

5 Commission 133

4 Commission 133

3 Commission 133

2 Commission 133

1 Commission 133

12 Electricity

11 Electricity

10/23/17 10 Electricity 44
9/22/17 9 Electricity 54
8/22/17 8 Electricity

7 Electricity

6 Electricity 54

5 Electricity 53

4 Electricity

3 Electricity 90

2 Electricity

1 Electricity

3

4 Entertainment

6 Entertainment

1/5/17 1 Food 75

2 Food 75

3 Food 75

6 Food 75

8 Food 75

9 Food 60

12 Food

12 Food

11 Food

10/1/17 10 Food 319
9/1/17 9 Food

8/1/17 8 Food

7/1/17 7 Food

6/1/17 6 Food 284

5 Food

5/1/17 5 Food

4/1/17 4 Food

3/1/17 3 Food

2/1/17 2 Food

1/1/17 1 Food

3/27/17 3 Gifts 30
4/18/17 4 Gifts 50

5 Gifts 30

7/24/17 7 Gifts 50

12 Gifts 20

12 Gifts 500

12 Gifts

12

11 Heathcare Premium 218

10 Heathcare Premium 218

9 Heathcare Premium 218

8 Heathcare Premium 218

7/5/17 7 Heathcare Premium 218
6/5/17 6 Heathcare Premium 218

5 Heathcare Premium 218

4 Heathcare Premium 218

3 Heathcare Premium 218

2/6/17 2 Heathcare Premium 218
1/5/17 1 Heathcare Premium 218

12

100

11 Insurance 100

10/1/17 10 Insurance 100
9/1/17 9 Insurance 100
8/1/17 8 Insurance 100
7/1/17 7 Insurance 100
6/1/17 6 Insurance 100
5/1/17 5 Insurance 100
4/1/17 4 Insurance 100
3/1/17 3 Insurance 100
2/1/17 2 Insurance 100
1/1/17 1 Insurance 100
10/17/17 10

9 Overtime

9/7/17 9 Overtime

9/1/17 9 Overtime

2

8 Overtime

8/22/17 8 Overtime

8 Overtime

8 Overtime

6 Overtime

5 Overtime

6

3 Overtime 500

2 Overtime

1 Overtime

2

12

11 Rent 1020

10 Rent 1020

9/22/17 9 Rent 1020

8 Rent 1020

7/24/17 7 Rent 1020
6/23/17 6 Rent 1020

5 Rent 1020

4/24/17 4 Rent 1020

3 Rent 1020

2/24/17 2 Rent 1020

1 Rent 1020

12 Salary

0

11 Salary 2720

10 Salary 2720

9/1/17 9 Salary 2720

8 Salary 2720

7 Salary 2720

6 Salary 2720

5 Salary 2720

4 Salary 2720

3 Salary 2720

2/3/17 2 Salary 2720
1/3/17 1 Salary 2720

7

8 Savings

9/22/17 9 Savings 100

9 Savings

9/22/17 9 Savings 450

12 Savings

12 Savings

11 Savings

7/24/17 7

1000

12 Vacation & Travel

12 Vacation & Travel

12

11 Water & Sewer 55

10/23/17 10 Water & Sewer 48
9/22/17 9 Water & Sewer 62
8/22/17 8 Water & Sewer 53
7/24/17 7 Water & Sewer 60
6/21/17 6 Water & Sewer 58
5/23/17 5 Water & Sewer 49
4/24/17 4 Water & Sewer

3/27/17 3 Water & Sewer 72
2/22/17 2 Water & Sewer

1 Water & Sewer

Posted Date Month Description Income
10/17/17 Bonus 315
7/18/17 288
4/18/17
1/18/17
1

2/3/17 Cable, Internet, TV 152
1

1/3/17
10/23/17
9/22/17
8/22/17
7/25/17
6/16/17
5/9/17
4/17/17
3/10/17 146
2/14/17 1

44
1/17/17
12/18/17 Car payment, fuel, maintenance 351
11/12/17 398
10/1/17 396
9/1/17 333
8/1/17 3

30
7/1/17 382
6/1/17 395
5/1/17 341
4/1/17 369
3/1/17 399
2/1/17 319
1/1/17 345
7/5/17 50
12/16/17 Cell Phone 60
11/10/17
12/12/17 Commission 133
11/6/17
10/11/17
9/11/17 53
8/8/17
7/19/17
5/10/17
4/14/17
3/16/17
2/10/17
1/13/17
12/5/17 103
1

1/5/17 54
64
7/24/17 62
6/21/17
5/23/17
4/24/17 90
3/27/17
2/22/17 107
1/24/17 169
3/9/17 Entertainment 500
4/25/17 100
6/5/17 2

75
2/24/17
3/17/17
6/23/17
8/17/17
9/18/17
12/7/17 80
12/15/17 314
11/9/17 284
294
305
278
5/18/17 137
290
275
318
312
322
5/4/17
12/1/17
12/14/17
1

2/6/17 200
12/13/17 Heathcare Premium 218
11/7/17
10/5/17
9/5/17
8/7/17
5/5/17
4/5/17
3/6/17
12/17/17 Insurance
11/11/17
Overtime 5

48
9/7/17 531
411
58
8/28/17 405
592
8/15/17 431
8/2/17 568
6/30/17 450
5/26/17 55
3/29/17
2/28/17 480
1/30/17 49
12/2/17 Rent 1020
11/2/17
10/24/17
8/24/17
5/24/17
3/24/17
1/26/17
12/19/17 2

72
11/8/17
10/3/17
8/3/17
7/3/17
6/2/17
5/3/17
4/3/17
3/3/17
7/20/17 Savings 490
8/29/17 1000
9/12/17 1600
12/11/17 550
12/9/17 250
11/1/17 340
Vacation & Travel
12/8/17 1550
12/10/17 1400
12/4/17 Water & Sewer 111
11/4/17
57
66
1/27/17 63
39875 42390

Pivot

Expert paper writers are just a few clicks away

Place an order in 3 easy steps. Takes less than 5 mins.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
$0.00