MODULE 13-BUDGET PRACTICE

Instructions

Get data from Budget Practice Transactions 3640.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

Posted Date Description Expense Income
1/1/19 Cell Phone 120
1/1/19 Insurance 200
1/1/19 Food 644
1/1/19 Car payment, fuel, maintenance 690
1/3/19 Salary 5984
1/5/19 Food 150
1/5/19 Heathcare Premium 437
1/13/19 Commission 293
1/17/19 Cable, Internet, TV 305
1/18/19 Bonus 633
1/24/19 Electricity 339
1/26/19 Rent 2040
1/27/19 Water & Sewer 126
1/30/19 Overtime 1082
2/1/19 Cell Phone 120
2/1/19 Insurance 200
2/1/19 Food 624
2/1/19 Car payment, fuel, maintenance 638
2/3/19 Salary 5984
2/6/19 Heathcare Premium 437
2/10/19 Commission 293
2/14/19 Cable, Internet, TV 288
2/22/19 Water & Sewer 132
2/22/19 Electricity 214
2/24/19 Food 150
2/24/19 Rent 2040
2/28/19 Overtime 1056
3/1/19 Cell Phone 120
3/1/19 Insurance 200
3/1/19 Food 636
3/1/19 Car payment, fuel, maintenance 798
3/3/19 Salary 5984
3/6/19 Heathcare Premium 437
3/9/19 Entertainment 1000
3/10/19 Cable, Internet, TV 292
3/16/19 Commission 293
3/17/19 Food 150
3/24/19 Rent 2040
3/27/19 Gifts 60
3/27/19 Water & Sewer 143
3/27/19 Electricity 180
3/29/19 Overtime 1100
4/1/19 Cell Phone 120
4/1/19 Insurance 200
4/1/19 Food 550
4/1/19 Car payment, fuel, maintenance 738
4/3/19 Salary 5984
4/5/19 Heathcare Premium 437
4/14/19 Commission 293
4/17/19 Cable, Internet, TV 303
4/18/19 Gifts 100
4/18/19 Bonus 693
4/24/19 Water & Sewer 114
4/24/19 Electricity 179
4/24/19 Rent 2040
4/25/19 Entertainment 200
5/1/19 Cell Phone 120
5/1/19 Insurance 200
5/1/19 Food 580
5/1/19 Car payment, fuel, maintenance 682
5/3/19 Salary 5984
5/4/19 Gifts 60
5/5/19 Heathcare Premium 437
5/9/19 Cable, Internet, TV 303
5/10/19 Commission 293
5/18/19 Food 274
5/23/19 Water & Sewer 98
5/23/19 Electricity 106
5/24/19 Rent 2040
5/26/19 Overtime 1223
6/1/19 Cell Phone 120
6/1/19 Insurance 200
6/1/19 Food 568
6/1/19 Car payment, fuel, maintenance 790
6/2/19 Salary 5984
6/5/19 Heathcare Premium 437
6/5/19 Entertainment 550
6/16/19 Cable, Internet, TV 303
6/16/19 Commission 293
6/21/19 Electricity 108
6/21/19 Water & Sewer 116
6/23/19 Food 150
6/23/19 Rent 2040
6/30/19 Overtime 990
7/1/19 Cell Phone 120
7/1/19 Insurance 200
7/1/19 Food 556
7/1/19 Car payment, fuel, maintenance 764
7/3/19 Salary 5984
7/5/19 Heathcare Premium 437
7/5/19 Car payment, fuel, maintenance 1000
7/18/19 Bonus 633
7/19/19 Commission 293
7/20/19 Savings 980
7/24/19 Gifts 100
7/24/19 Water & Sewer 120
7/24/19 Electricity 124
7/24/19 Vacation & Travel 2000
7/24/19 Rent 2040
7/25/19 Cable, Internet, TV 303
8/1/19 Cell Phone 120
8/1/19 Insurance 200
8/1/19 Food 610
8/1/19 Car payment, fuel, maintenance 660
8/2/19 Overtime 1250
8/3/19 Salary 5984
8/7/19 Heathcare Premium 437
8/8/19 Commission 293
8/15/19 Overtime 948
8/17/19 Food 150
8/22/19 Water & Sewer 106
8/22/19 Electricity 129
8/22/19 Cable, Internet, TV 303
8/22/19 Overtime 1302
8/24/19 Rent 2040
8/28/19 Overtime 891
8/29/19 Savings 2000
9/1/19 Cell Phone 120
9/1/19 Insurance 200
9/1/19 Food 588
9/1/19 Car payment, fuel, maintenance 666
9/1/19 Overtime 1280
9/1/19 Salary 5984
9/5/19 Heathcare Premium 437
9/7/19 Overtime 904
9/7/19 Overtime 1168
9/11/19 Commission 1173
9/12/19 Savings 3200
9/18/19 Food 120
9/22/19 Electricity 108
9/22/19 Water & Sewer 125
9/22/19 Savings 200
9/22/19 Cable, Internet, TV 303
9/22/19 Savings 900
9/22/19 Rent 2040
10/1/19 Cell Phone 120
10/1/19 Insurance 200
10/1/19 Food 638
10/1/19 Car payment, fuel, maintenance 792
10/3/19 Salary 5984
10/5/19 Heathcare Premium 437
10/11/19 Commission 293
10/17/19 Bonus 693
10/17/19 Overtime 1206
10/23/19 Electricity 87
10/23/19 Water & Sewer 96
10/23/19 Cable, Internet, TV 303
10/24/19 Rent 2040
11/1/19 Savings 680
11/2/19 Rent 2040
11/3/19 Cable, Internet, TV 304
11/4/19 Water & Sewer 111
11/5/19 Electricity 108
11/6/19 Commission 293
11/7/19 Heathcare Premium 437
11/8/19 Salary 5984
11/9/19 Food 568
11/10/19 Cell Phone 120
11/11/19 Insurance 200
11/12/19 Car payment, fuel, maintenance 796
12/1/19 Gifts 40
12/2/19 Rent 2040
12/3/19 Cable, Internet, TV 304
12/4/19 Water & Sewer 222
12/5/19 Electricity 206
12/6/19 Gifts 400
12/7/19 Food 160
12/8/19 Vacation & Travel 3100
12/9/19 Savings 500
12/10/19 Vacation & Travel 2800
12/11/19 Savings 1100
12/12/19 Commission 293
12/13/19 Heathcare Premium 437
12/14/19 Gifts 1000
12/15/19 Food 628
12/16/19 Cell Phone 120
12/17/19 Insurance 200
12/18/19 Car payment, fuel, maintenance 702
12/19/19 Salary 5984
79750 93259

Sheet1

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *