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