Posted: August 2nd, 2022

MODULE 13-BUDGET PRACTICE

PLEASE ANSWER THE QUESTIONS IN THE EXCEL SPREADSHEET

2

>Instructions

Get data from

Budget Practice Transactions

3 6 4

0.txt

Insert a new column in B with the month (

1

12

) for each transaction Insert a Pivot Table on a new sheet labeled “Pivot” 1

For the entire year, rent is what % of Total Expenses? 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 total expenses for the entire year? 21 Create a Pivot Chart – Column style 22 Filter so only (2) Expenses are showing on your chart 23 Copy & Paste as Picture your Chart to a PowerPoint Document 24 Add (2) notes to your PowerPoint; one note explaining each Expense

Budget Practice Transactions

1/1/19

1/1/19 Food

1/1/19

Salary

4

Food

1/5/19

Electricity

2

Cell Phone 120

2/1/19 Insurance 200
2/1/19 Food

2/1/19 Car payment, fuel, maintenance

Salary

Heathcare Premium 437

Commission 293

Cable, Internet, TV

Water & Sewer

2/22/19 Electricity

Food 150

2/24/19 Rent

Overtime

Cell Phone 120

3/1/19 Insurance 200
3/1/19 Food

3/1/19 Car payment, fuel, maintenance

Salary 5984

Heathcare Premium 437

0

Cable, Internet, TV

Commission 293

Food 150

Rent 2040

Gifts

3/27/19 Water & Sewer

3/27/19 Electricity

Overtime

Cell Phone 120

4/1/19 Insurance 200
4/1/19 Food

4/1/19 Car payment, fuel, maintenance

Salary 5984

Heathcare Premium 437

Commission 293

Cable, Internet, TV

Gifts 100

4/18/19 Bonus

Water & Sewer

4/24/19 Electricity

4/24/19 Rent 2040

Entertainment 200

Cell Phone 120

5/1/19 Insurance 200
5/1/19 Food

5/1/19 Car payment, fuel, maintenance

Salary 5984

Gifts 60

Heathcare Premium 437

Cable, Internet, TV 303

Commission 293

Food

Water & Sewer 98

5/23/19 Electricity

Rent 2040

Overtime

Cell Phone 120

6/1/19 Insurance 200
6/1/19 Food

6/1/19 Car payment, fuel, maintenance

Salary 5984

Heathcare Premium 437

6/5/19 Entertainment 550

Cable, Internet, TV 303

6/16/19 Commission 293

Electricity 108

6/21/19 Water & Sewer

Food 150

6/23/19 Rent 2040

Overtime

Cell Phone 120

7/1/19 Insurance 200
7/1/19 Food

7/1/19 Car payment, fuel, maintenance

Salary 5984

Heathcare Premium 437

7/5/19 Car payment, fuel, maintenance

Bonus 633

Commission 293

Gifts 100

7/24/19 Water & Sewer 120
7/24/19 Electricity

7/24/19

7/24/19 Rent 2040

Cable, Internet, TV 303

Cell Phone 120

8/1/19 Insurance 200
8/1/19 Food

8/1/19 Car payment, fuel, maintenance

Overtime

0

Salary 5984

Heathcare Premium 437

Commission 293

Overtime

Food 150

Water & Sewer 106

8/22/19 Electricity

8/22/19 Cable, Internet, TV 303
8/22/19 Overtime

Rent 2040

Overtime

Savings 2000

Cell Phone 120

9/1/19 Insurance 200
9/1/19 Food

9/1/19 Car payment, fuel, maintenance

9/1/19 Overtime

9/1/19 Salary 5984

Heathcare Premium 437

Overtime

9/7/19 Overtime

Commission

Savings

Food 120

Electricity 108

9/22/19 Water & Sewer 125
9/22/19 Savings 200
9/22/19 Cable, Internet, TV 303
9/22/19 Savings

9/22/19 Rent 2040

Cell Phone 120

10/1/19 Insurance 200
10/1/19 Food 638
10/1/19 Car payment, fuel, maintenance

Salary 5984

Heathcare Premium 437

Commission 293

Bonus 693

10/17/19 Overtime

Electricity

10/23/19 Water & Sewer

10/23/19 Cable, Internet, TV 303

Rent 2040

Savings

Rent 2040

Cable, Internet, TV

Water & Sewer

Electricity 108

Commission 293

Heathcare Premium 437

Salary 5984

Food 568

Cell Phone 120

Insurance 200

Car payment, fuel, maintenance

Gifts 40

Rent 2040

Cable, Internet, TV 304

Water & Sewer

Electricity 206

Gifts

Food

Vacation & Travel

Savings

Vacation & Travel

Savings 1100

Commission 293

Heathcare Premium 437

Gifts 1000

Food

Cell Phone 120

Insurance 200

Car payment, fuel, maintenance

Salary 5984

Posted Date Description Expense Income
1/1/19 Cell Phone 120
Insurance 200
644
Car payment, fuel, maintenance 690
1/3/19 5

98
1/5/19 150
Heathcare Premium 437
1/13/19 Commission 293
1/17/19 Cable, Internet, TV 305
1/18/19 Bonus 633
1/24/19 339
1/26/19 Rent 20

40
1/27/19 Water & Sewer 126
1/30/19 Overtime 108
2/1/19
624
638
2/3/19 5984
2/6/19
2/10/19
2/14/19 288
2/22/19 132
214
2/24/19
2040
2/28/19 1056
3/1/19
636
798
3/3/19
3/6/19
3/9/19 Entertainment 100
3/10/19 292
3/16/19
3/17/19
3/24/19
3/27/19 60
143
180
3/29/19 1100
4/1/19
550
738
4/3/19
4/5/19
4/14/19
4/17/19 303
4/18/19
693
4/24/19 114
179
4/25/19
5/1/19
580
682
5/3/19
5/4/19
5/5/19
5/9/19
5/10/19
5/18/19 274
5/23/19
106
5/24/19
5/26/19 1223
6/1/19
568
790
6/2/19
6/5/19
6/16/19
6/21/19
116
6/23/19
6/30/19 990
7/1/19
556
764
7/3/19
7/5/19
1000
7/18/19
7/19/19
7/20/19 Savings 980
7/24/19
124
Vacation & Travel 2000
7/25/19
8/1/19
610
660
8/2/19 125
8/3/19
8/7/19
8/8/19
8/15/19 948
8/17/19
8/22/19
129
1302
8/24/19
8/28/19 891
8/29/19
9/1/19
588
666
1280
9/5/19
9/7/19 904
1168
9/11/19 1173
9/12/19 3200
9/18/19
9/22/19
900
10/1/19
792
10/3/19
10/5/19
10/11/19
10/17/19
1

206
10/23/19 87
96
10/24/19
11/1/19 680
11/2/19
11/3/19 304
11/4/19 111
11/5/19
11/6/19
11/7/19
11/8/19
11/9/19
11/10/19
11/11/19
11/12/19 796
12/1/19
12/2/19
12/3/19
12/4/19 222
12/5/19
12/6/19 400
12/7/19 160
12/8/19 3100
12/9/19 500
12/10/19 2800
12/11/19
12/12/19
12/13/19
12/14/19
12/15/19 628
12/16/19
12/17/19
12/18/19 702
12/19/19
79750 93259

Sheet1

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