M S Excel Computer Lab Assignments With Solutions 3w1l6j
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 2z6p3t
Overview 5o1f4z
& View M S Excel Computer Lab Assignments With Solutions as PDF for free.
More details 6z3438
- Words: 10,672
- Pages: 59
Microsoft Office Excel Exercise 1 Name
Science
Math
English
Total
Average
Daniel Maureen John Nihar Somnath Priya Spoorthi
89 67 78 86 75 86 68
87 81 86 89 87 76 61
79 69 86 86 64 53 72
255 217 250 261 226 215 201
85 72.33 83.33 87 75.33 71.66 67
Percentag e 85 % 72 % 83 % 87 % 75 % 72 % 67 %
Exercise 2 Name
Kannada
English
Hindi
Total
Average
Anjali Naima Nikhil Talan Shreya Pragathi Anu
75 87 68 68 76 84 85
87 68 64 69 49 69 96
64 57 67 64 58 71 55
226 212 199 201 183 224 236
75.33 70.66 66.33 67 61 74.66 78.66
Percentag e 75 % 71 % 66 % 67 % 61 % 75 % 79 %
Exercise 3 Name
Math
Science
Social
Total
Average
Sharma Gupta Malhotra Bhatnagar Saxena Haritha Ashwini
78 68 49 67 75 79 86
59 94 58 73 69 64 74
68 75 47 79 48 73 69
205 237 154 219 192 216 229
68.33 79 51.33 73 64 72 76.33
Percentag e 68 % 79 % 51 % 73 % 64 % 72 % 76 %
Exercise 4 Name
Kannada
English
Hindi
Total
Average
Benjamin Augustine David Edward Charles Elbert Kelly
76 97 59 68 49 76 68
84 67 68 76 67 84 85
79 84 71 59 58 52 73
239 248 198 203 174 212 226
79.66 82.66 66 67.66 58 70.66 75.33
Page 1
Percentag e 80 % 83 % 66 % 68 % 58 % 71 % 75 %
Microsoft Office Excel Exercise 5 Name
Test 1
Test 2
Test 3
Total
Average
Frank Pace Getty Robert Amy John Alan
72 68 67 58 55 72 81
67 73 58 67 59 85 73
75 85 67 49 57 64 72
214 226 192 174 171 221 226
71.33 75.33 64 58 57 73.66 75.33
Percentag e 71 % 75 % 64 % 58 % 57 % 74 % 75 %
Exercise 6 Worldwide Sporting Goods Sales
January
Februar y
March
Total Sales
Expens es
Net Sales
Avg Sales
Smith
1,819.21
1,766.55
1,942.88
5,528.64
1,241.00
4,287.64
1,842.88
Brown
1,704.38
1,809.01
1,650.28
5,163.67
1,165.00
3,998.67
1,721.22
Wallace
2,009.69
2,195.19
2,159.29
6,364.17
1,650.00
4,714.17
2,121.39
Adams
1,948.44
1,725.56
1,870.26
1,345.00
7,481.72
7,496.31
7,622.71
4,199.26 17,199.7 4
1,848.09
Total
5,544.26 22,600.7 4
5,401.00
7,533.58
Exercise 7 Worldwide Sporting Goods – Customer Sales – Last Year Company
Stat us
Qtr 1
Qtr 2
Qtr 3
Qtr 4
Total
Averag e
Sports City
2
15,568
16,523
17,658
18,952
68,701
17,175
Athlete’s Dream Sports Emporium
3
21,356
22,547
24,598
23,691
92,192
23,048
1
22,571
23,681
22,698
24,995
93,945
23,486
Sports World
4
14,568
15,423
16,532
15,248
61,771
15,443
Tennis t
3
10,652
9,865
10,156
11,564
42,237
10,559
Athlete’s World
2
20,364
18,596
19,532
20,348
78,840
19,710
Page 2
Microsoft Office Excel Sportsman’s Den World of Sports
1
21,457
20,567
22,365
22,056
86,445
21,611
3
15,862
16,538
17,568
18,563
68,531
17,133
4
18,745
19,865
20,361
20,455
79,426
19,857
Total
161,143
163,605
171,468
175,872
672,088
168,022
Average
17,905
18,178
19,052
19,541
74,676
18,669
Specialty Sports
Exercise 8 Public School Name
Test 1
Test 2
Test 3
Test 4
Test 5
Test 6
Total
Averag e
Veronic a
47
75
68
49
57
67
363
60.5
Betty
59
24
67
32
59
62
321
53.5
Archie
68
75
71
49
53
64
380
63.33
Marge
59
64
28
53
57
41
302
50.33
Reggie
31
54
62
55
47
53
302
50.33
Per 61 % 54 % 63 % 50 % 50 %
Min
Max
Result
47
75
32
67
Fail
49
75
28
64
Fail
31
62
Fail
Exercise 9 Sl. No
Gend er
Age
Ethnicity
Planned major
Category
College
1
male
18
white
business
business
business
2
male
18
white
electrical engineering
engineering
engineering
3
male
19
white
biology
natural science
4
male
18
white
math
math
5
male
19
white
computer science
computer science
6
male
19
white
computer science
computer science
Page 3
arts and sciences arts and sciences arts and sciences arts and sciences
Microsoft Office Excel 7
male
20
white
graphic design
fine and performing art
arts and sciences
8
male
19
hispanic
secondary education
education
education
9
male
20
business
business
business
10
male
19
political science
social science
arts and sciences business
11 12 13 14 15 16 17 18 19 20
femal e femal e femal e femal e femal e femal e femal e femal e femal e femal e
africanamerican africanamerican
22
White
business
business
19
White
french
humanities
18
White
anthropology
social science
19
White
english
humanities
20
White
elementary education
education
education
21
White
computer science
computer science
arts and sciences
19
africanamerican
education
education
21
asian
secondary education early childhood education
education
education
19
hispanic
english
humanities
22
africanamerican
political science
social science
21
male
19
white
theatre
fine and performing art
22
male
19
hispanic
communications
humanities
arts and sciences arts and sciences arts and sciences
arts and sciences arts and sciences arts and sciences arts and sciences
Exercise 10 Wages
Inventory
Supplies
Sales
Profit
Apparel
1,000
5,000
200
7,500
1,300
Hardware
2,200
10,000
200
15,000
2,600
Toys
500
3,500
200
7,500
3,300
Furniture
1,000
300
200
7,025
5,525
Page 4
Microsoft Office Excel Electronics
2,000
9,000
200
22,000
10,800
Food
1,500
4,750
350
9,675
3,075
Totals
8,200
32,550
1,350
68,700
26,600
Exercise 11 Cards and gifts 2008 sales 1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Average
22,188
21,099
22,253
28,231
23,443
93,771
16,277
17,377
17,760
19,819
17,808
71,233
5,566
5,445
6,125
6,223
5,840
23,359
1,289
1,495
1,209
2,188
1,545
6,181
General Gifts
16,926
17,351
13,796
20,459
17,133
68,532
Seasonal Gifts
11,223
12,225
12,654
13,665
12,442
49,767
Maximum
22,188
21,099
Minimum
1,289
Average
12,245
General Cards Seasonal Cards Gift Wrap Stationery
Total
73,469
2008 Totals
22,253
28,231
23,443
93,771
1,495
1,209
2,188
1,545
6,181
12,499
12,300
15,098
13,035
52,141
74,992
73,797
90,585
78,211
312,843
Exercise 12 Acme Incorporated Sales Report Northern District
Southern District
Western District
Eastern District
Total
Sales 1
56,789
45,784
78,327
56,783
237,683
Sales 2
76,489
62,646
73,456
67,328
279,919
Sales 3
62,543
54,786
71,980
54,987
244,296
Sales 4
71,239
65,900
83,265
69,736
290,140
Page 5
Microsoft Office Excel Maximum
76,489
65,900
83,265
69,736
290,140
Minimum
56,789
45,784
71,980
54,987
237,683
Average
66,765
57,279
76,757
62,209
263,010
267,060
229,116
307,028
248,834
1,052,038
Total
Exercise 13 Eat Cake Sales Forecast Month NA NA NA NA NA NA
Quarters NA NA NA NA NA NA
Year 2005 2005 2005 2005 2005 2005
Channel Retail Partner Direct Sales Catering Internet Mall stores
Forecast 945,734 876,098 345,876 234,587 456,098 678,435
Exercise 14 Name
First Name
Genre
Income
Situation
Child
Janjuah
Bob
Man
20000
Relationship
0
Sara
Sumit
Man
80000
Married
1
Champney
Robert
Man
67000
Married
0
Jonas
Lee
Man
35000
Relationship
0
Samen
Michael
Man
77000
Single
0
Satake
Kaori
Man
70000
Married
3
Leon
Fernando
Man
23000
Single
3
Byerly
Kimberly
Woman
97000
Relationship
1
Warner
Norris
Man
26000
Divorced
3
Gaudefroy
Marie
Woman
89000
Relationship
0
Chap
Mathew
Woman
77000
Single
2
Simpson
Aubrey
Man
34000
Divorced
0
Fordyce
David
Man
61000
Relationship
2
Tortelli
Olavo
Woman
27000
Single
0
Page 6
Microsoft Office Excel Adcock
David
Woman
72000
Divorced
3
Contat
Thibault
Man
85000
Relationship
1
Zizzari
Stephen
Woman
84000
Single
3
Freyer
Jean-Luc
Man
50000
Single
2
Jones
David
Man
31000
Single
0
Exercise 15 Weekly Time Card Summary for Hourly Employees Employee ID
Last Name
First Name
Total Hours
Hourly Pay
Total Pay
1848
Gul
Doug
8
8.55
68.40
1863
Guzik
Sue
4
9.55
38.20
1878
Madi
Chris
6
10.00
60.00
1913
Haf
Richard
7
11.25
78.75
2156
Bolte
Ellen
8
11.00
88.00
3788
Miller
Cindy
8
15.00
120.00
4110
Miller
Jan
6
13.25
79.50
4564
Butler
Teresa
9
12.50
112.50
4793
Abels
Ginger
5
11.50
57.50
5078
Causey
Tim
4
9.50
38.00
5106
Chambers
Julie
6
20.00
120.00
5128
Chambers
Les
8
16.00
128.00
5145
Abell
Bruce
8
14.00
112.00
5714
Miller
Kevin
10
13.00
130.00
6566
Miller
Rudeana
8
9.25
74.00
6569
Eads
Linda
6
10.25
61.50
7708
Russell
Susan
4
11.75
47.00
Exercise 16 Page 7
Microsoft Office Excel Month
Sales Rep
Region
s
Sales
Annualized
Jan
Bob
North
58
283,800
3,689,400
Jan
Frank
North
35
507,200
6,086,400
Jan
Paul
South
25
107,600
1,291,200
Jan
Randy
South
47
391,600
4,699,200
Jan
Mary
South
39
226,700
2,720,400
Feb
Bob
North
44
558,400
6,700,800
Feb
Jill
North
46
350,400
4,204,800
Feb
Frank
North
74
411,800
4,941,600
Feb
Paul
South
29
154,200
1,850,400
Feb
Randy
South
45
258,000
3,096,000
Feb
Mary
South
52
233,800
2,805,600
Mar
Bob
North
30
353,100
4,237,200
Mar
Jill
North
44
532,100
6,385,200
Mar
Frank
North
57
258,400
3,100,800
Mar
Paul
South
13
286,000
3,432,000
Mar
Randy
South
14
162,200
1,946,400
Exercise 17 Year
198 0 198 1 198 2 198 3 198 4
Temp (avg)
Temp (max)
Temp (min)
# of Readings
Rainfall (in)
28
32
10
100
110
Tropical
George
25
37
-5
100
2
Desert
Jim
-3
10
-32
100
4
Arctic
Janet
18
28
-15
100
56
Temperat Mike e
25
38
13
100
98
Tropical
Page 8
Climate
Observer
Bill
Microsoft Office Excel 198 5 198 6 198 7 198 8 198 9 199 0 199 1 199 2 199 3 199 4 199 5 199 6 199 7 199 8 199 9 200 0 200 1 200 2 200 3
28
32
10
100
110
Tropical
Bill
25
37
-5
100
2
Desert
Bill
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat Janet e
25
38
13
100
98
Tropical
Bill
28
32
10
100
110
Tropical
Janet
25
37
-5
100
2
Desert
Jim
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat George e
25
38
13
100
98
Tropical
George
28
32
10
100
110
Tropical
Bill
25
38
13
100
98
Tropical
Janet
28
32
10
100
110
Tropical
Bill
25
37
-5
100
2
Desert
Bill
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat Janet e
25
38
13
100
98
Tropical
Bill
28
32
10
100
110
Tropical
Janet
25
37
-5
100
2
Desert
Jim
Page 9
Microsoft Office Excel 200 4 200 5 200 6
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat George e
25
38
13
100
98
Tropical
George
Exercise 18 Eastern 1992 Quarters 1
Quarters 2
Quarters 3
Quarters 4
Golf
5,000
2,000
1,500
2,000
Safari
9,000
6,000
4,000
5,000
Tennis
1,500
500
600
1,500
15,500
8,500
6,100
8,500
Quarters 1
Quarters 2
Quarters 3
Quarters 4
Windsurfing
1,800
5,000
6,500
1,750
Golf
3,500
2,500
6,430
4,590
Tennis
6,000
3,200
4,070
5,000
11,300
10,700
17,000
11,340
Quarters 1
Quarters 2
Quarters 3
Quarters 4
5,500
1,500
1,400
2,500
Safari
10,000
6,500
4,400
4,500
Tennis
1,000
800
550
1,000
16,500
8,800
6,350
8,000
Total Sales
Western 1992
Total Sales
Eastern 1993 Golf
Total Sales
Page 10
Microsoft Office Excel Western 1993 Quarters 1
Quarters 2
Quarters 3
Quarters 4
Windsurfing
1,850
4,000
5,500
1,550
Golf
1,500
2,500
4,075
2,500
Tennis
6,500
2,000
4,590
5,055
Total Sales
9,850
8,500
14,165
9,105
53,150
36,500
43,615
36,945
Grand Total Sales
Exercise 19 Item Category Flour
Item Type
Item#
Pastry
4
Current Cost 7
Flour
Whole Wheat
5
Flour
WW Pastry
Flour
Inventory
Final Cost
2
14
4.2
3
12.6
14
7
7
49
Whole Wheat
15
4.2
4
16.8
Flour
Pastry
24
7
5
35
Icing
Butter cream
6
1.75
3
5.25
Icing
Royal
7
2.25
5
11.25
Icing
Fondant
8
3.5
4
14
16
1.75
15
26.25
17
2.25
8
18
Icing
Blue Butter cream Blue Royal
Icing
Blue Fondant
18
3.5
6
21
Mix
Chocolate
1
5.25
4
21
Mix
Vanilla
2
3
1
3
Mix
Marble
3
4.25
2
8.5
Icing
Page 11
Microsoft Office Excel Mix
Dutch Chocolate Royal Vanilla
Mix
Pound
Mix
11
7.25
3
21.75
12
4
15
60
13
5.25
11
57.75
21
6.25
10
62.5
22
4
13
52
Mix
French Chocolate French Vanilla
Mix
Marble
23
5.25
2
10.5
Sprinkles
Sugar
9
1.05
22
23.1
Sprinkles
Sugar Free
19
1.05
16
16.8
Toppings
Sugar
10
1.3
19
24.7
Toppings
Sugar Free
20
1.3
4
5.2
Mix
Exercise 20
50
Sun/Oct/0 5 1000
Mon/Oct/0 5 1
-10
Wed/Oct/0 5 65
Thu/Oct/0 5 3
250
51
999
7
-15
66
9
400
52
998
13
-20
67
15
550
53
997
19
-25
68
21
700
54
996
25
-30
69
27
850
55
995
31
-35
70
33
1000
56
994
37
-40
71
39
1150
57
993
43
-45
72
45
1300
58
992
49
-50
73
51
1450
59
991
55
-55
74
57
1600
60
990
61
-60
75
63
1750
61
989
67
-65
76
69
Fri/Oct/05
Sat/Oct/05
100
Page 12
Tue/Oct/05
Microsoft Office Excel 1900
62
988
73
-70
77
75
2050
63
987
79
-75
78
81
2200
64
986
85
-80
79
87
2350
65
985
91
-85
80
93
2500
66
984
97
-90
81
99
2650
67
983
103
-95
82
105
2800
68
982
109
-100
83
111
2950
69
981
115
-105
84
117
3100
70
980
121
-110
85
123
3250
71
979
127
-115
86
129
3400
72
978
133
-120
87
135
3550
73
977
139
-125
88
141
3700
74
976
145
-130
89
147
Exercise 21 ission No.
Last Name
First Name
Exam 1
Exam 2
Exam 3
Total
000606
Altiveros
Melissa
75
72
66
213
000943
Colburn
Mary
92
95
91
278
000983
Davis
Michael
44
52
73
169
001326
Davis
Kelly
93
92
86
271
001572
Douglas
Theresa
88
74
69
231
002563
Dwyer
Helen
92
91
88
271
002637
Gott
Michelle
90
77
85
252
002679
Hardy
Russell
78
76
79
233
002773
Hobson
Jen
98
92
92
282
002779
Holt
Nicholas
91
89
83
263
Page 13
Microsoft Office Excel 002981
Jackson
Scott
95
95
91
281
003789
Jackson
Kenneth
73
57
68
198
003874
Lopez
Elaine
65
78
71
214
004662
Meese
Erin
82
75
72
229
004875
Mittelstadt
Stephanie
72
75
80
227
004919
Oestreich
Jennifer
71
55
76
202
009690
Steele
Kylie
91
72
80
243
009873
Williamson
Linda
76
69
75
220
Exercise 22 PF Statement for the month of July Sl. No .
Particulars
Basic
1
H.R. &
50000
2
Security
30000
3
s
5000
4
Maintenanc e
3000
5
Drivers
6000
6
Bouncer
3250
7
F&B Service
3500
VDA
HRA
CON V
Medic al
Wash Allowan ce
Special Allowanc e
Othe rs
Total
100 1 100 1 100 1 100 1 100 1 100 1 100 1
2000 0
800
1250
600
26349
0
10000 0
0
800
1250
0
26949
0
60000
2000
800
0
600
599
0
10000
400
0
0
600
999
0
6000
2150
800
1250
0
799
0
12000
600
250
0
600
799
0
6500
600
500
0
600
799
0
7000
Page 14
Microsoft Office Excel 8 9 10 11
Front Office F&B Production House Keeping Kitchen Stewarding
12
4250 7500 3250 3250
Trainee
2450
Grand Total
12145 0
100 1 100 1 100 1 100 1 100 1 120 12
800
600
0
600
1249
0
8500
2600
800
1250
0
1849
0
15000
600
250
0
600
799
0
6500
600
250
0
600
799
0
6500
400
0
0
600
1049
0
5500
3075 0
5850
5000
5400
63038
0
24350 0
Exercise 23
Jan Switch plates Tin Ceilings Door Plates
Feb
Iron Works Source of Income First six months Mar Apr
May
Jun
Total
236
583
453
284
1,294
788
3,638
17,894
17,012
12,894
12,884
15,623
17,433
93,740
478,003
593,221
488,534
589,322
499,322
523,855
187,945
198,422
201,123
293,844
198,843
200,019
18,956
19,842
17,363
18,764
19,846
17,883
112,654
38,953
39,847
37,855
39,009
38,755
37,129
231,548
1,930,0 55
2,847,73 3
1,895,32 2
1,984,47 2
1,758,33 2
1,846,73 4
12,262,6 48
Minimum
1,930,0 55 236
2,847,73 3 583
1,895,32 2 453
1,984,47 2 284
1,758,33 2 1,294
1,846,73 4 788
Average
381,720
530,951
379,078
419,797
361,716
377,692
2,672,0 42
3,716,66 0
2,653,54 4
2,938,57 9
2,532,01 5
2,643,84 1
12,262,6 48 3,638 2,450,95 4 17,156,6 81
Lock Sets Cabinet Knobs Drawer Pulls Bathroom Hardware Maximum
Total
Page 15
3,172,25 7 1,280,19 6
Microsoft Office Excel Exercise 24 ABC Limited For the period of 2000 - 2002 REVENUE
2000
2001
2002
Gross Sales
70000
75000
90000
Sales Returns
20000
23000
28000
50000
52000
62000
2000
2001
2002
Beginning Inventory
35000
36000
42000
Goods Purchased
12000
16500
18500
47000
52500
60500
3600
4200
4350
43400
48300
56150
6600
3700
5850
2000
2001
2002
6200
7300
4600
4450
5275
6000
10650
12575
10600
NET SALES COST OF SALES
Total Goods Available Ending Inventory Total cost of Goods Consumed Gross Profit OPERATING EXPENSES Selling General/istrat ive Total Operating Expenses Income before Taxes Taxes on Income
-4050
-8875
-4750
-1822.5
-3993.75
-2137.5
Net Profit
-2227.5
-4881.25
-2612.5
Note : net sales = gross sales – sales return Page 16
Microsoft Office Excel Total cost of goods consumed = Total Goods Available - Ending Inventory Gross profit = net sales - Total cost of goods consumed Total Operating Expenses = selling + General/istrative Income before taxes = gross profit - Total Operating Expenses Taxes on income = 0.45 * Income before Taxes Net profit = Income before Taxes - Taxes on Income
Exercise 25 ID
Last Name
First Name
Department
Extension
1
Burmeister
Allen
Development
5325
2
Cole
Francis
Publications
5277
3
Conrad
John
Customer
5424
4
Dixon
Colleen
Human Resources
5387
5
Elphin
Brenda
Publications
5298
6
Franklin
Benito
Sales & Marketing
5701
7
Griffith
Susan
Human Resources
5321
8
Henry
Kurt
Shipping
5167
9
Hirsch
Alexa
Human Resources
5345
10
Kaplan
Dan
ing
5598
11
Kapur
Madeline
ing
5500
12
Lao
Tony
Publications
5211
13
Lindquist
Donald
Sales & Marketing
5727
14
Mercer
Ernest
Development
5333
15
Murphy
Franklin
Development
5676
16
Spencer
Felicity
Publications
5209
Page 17
Microsoft Office Excel 17
Stephens
Maryanne
Sales & Marketing
5763
18
Tai
Anna
Development
5301
19
Thomas
George
Shipping
5189
20
Tran
Margaret
ing
5571
Exercise 26 Name
State
City
Product
Quantity
Mitron
California
San Jose
CD-ROM
64
Unit Price 0.25
Smith
California
Los Angeles
CD-ROM
152
0.25
38
282
25.3
7134.6
292
0.55
160.6
Garcia Yokuchi
Massachus etts Texas
Total 16
Dallas
Smart Card DVD-ROM
Boston
DVD-ROM
336
0.55
184.8
Boston
DVD-ROM
304
0.55
167.2
Dallas
Keyboard
331
7.5
Boston
Charlton
Massachus etts Massachus etts Texas
Yokuchi
Texas
Dallas
CD-ROM
385
0.25
Yang
Nevada
Las Vegas
Cle USB
285
12.45
Yang
Nevada
Las Vegas
Hard drive
164
75
Charlton
Texas
Dallas
DVD-ROM
344
0.55
189.2
Yang
Nevada
Las Vegas
CD-ROM
53
0.25
13.25
Smith
California
CD-ROM
283
0.25
70.75
Charlton
Texas
Los Angeles Dallas
DVD-ROM
313
0.55
172.15
Julian
Texas
Houston
DVD-ROM
397
0.55
218.35
Charlton
Texas
Dallas
USB
488
12.45
6075.6
Charlton
Texas
Dallas
Smart Card
181
25.3
4579.3
Garcia Garcia
Page 18
2482.5 96.25 3548.25 12300
Microsoft Office Excel Charlton
Texas
Dallas
USB
460
12.45
5727
Yang
Nevada
Las Vegas
Hard drive
90
75
6750
Brown
California
San Francisco
Printer
260
54
14040
Springfield DVD-ROM
286
0.55
157.3
San Jose
DVD-ROM
254
0.55
139.7
Boston
Printer
398
54
Springfield
Smart Card
185
25.3
Springfield Hard drive
15
75
1125
Houston
228
54
12312
284
25.3
472
75
35400 397.5
Boulard Mitron
Massachus etts California
Julian
Massachus etts Massachus etts Massachus etts Texas
Mitron
California
San Jose
Yang
Nevada
Las Vegas
Smart Card Hard drive
Charlton
Texas
Dallas
Keyboard
53
7.5
Yokuchi
Texas
Dallas
Smart Card
372
25.3
Boulard
Massachus etts
Springfield Keyboard
490
7.5
Smith
California
Los Angeles
CD-ROM
1000
0.25
Boston
Printer
500
54
27000
Houston
Printer
374
54
20196
Springfield Keyboard
285
7.5
2137.5
Las Vegas
Printer
376
54
20304
Las Vegas
CD-ROM
25
0.25
Boston
Printer
471
54
25434
San Jose
Printer
366
54
19764
San Jose
Smart Card
365
25.3
Garcia Boulard Boulard
Garcia Julian
Massachus etts Texas
Yang
Massachus etts Nevada
Yang
Nevada
Boulard
Mitron
Massachus etts California
Mitron
California
Garcia
Printer
Page 19
21492 4680.5
7185.2
9411.6 3675 250
6.25
9234.5
Microsoft Office Excel Exercise 27 A to Z Office Supplies Quarterly Sales 2003 Sales Person
Qtr1
Qtr2
Qtr3
Qtr4
Total
Nichols, Todd
1,200
423
521
625
2,769
Green, Cheryl
654
634
326
754
2,368
Finley, Robert
2,567
2,390
3,005
2,389
10,351
Jenkins, Jerry
233
532
525
652
1,942
Franklin, William
354
633
422
255
1,664
Soderman, Pamela
255
525
252
624
1,656
422
642
642
624
2,330
854
364
474
743
2,435
Williams, Walter
2,234
2,567
2,987
2,546
10,334
Coombs, Dallas
356
634
632
743
2,365
Maximum
2,567
2,567
3,005
2,546
10,351
Minimum
233
364
252
255
1,656
Average
913
934
979
996
3,821
9,129
9,344
9,786
9,955
38,214
Carpenter, Candace Sutherland, Patricia
Total
Page 20
Total
December
November
October
September
August
July
June
May
April
March
February
January
Exercise 28
Microsoft Office Excel Income Fixed expends Variables expends Amount of expends Result
150 0
100 0
100 0
180 0
270 0
270 0
330 0
3630
231 0
1732 .5
120 0
138 0
750
750
750
750
750
750
750
750
750
750
750
750
600
500
500
211 6 286 6
160 0 235 0
110
434
139 0 190
132 6
350
2433 .4 3183 .4 446. 6
576
125 0 250
184 0 259 0
640
125 0 250
160 0 235 0
540
135 0
150 0 225 0 450
24,252. 50 9,000.0 0 14,445. 40 23,445. 40
54
807.10
150
-40
1290 442. 5
Note: result = income – amount of expends
Exercise 29 Downtown Internet Café February
March
April
May
June
July
August
r Septembe
October
November
December
1330 0
1360 0
1420 0
1440 0
1520 0
1550 0
1560 0
1570 0
1580 0
1620 0
1680 0
1710 0
580 0 360 0 100 0
600 0 380 0 110 0
620 0 380 0 110 0
620 0 360 0 150 0
620 0 380 0 150 0
620 0 380 0 150 0
645 0 500 0 210 0
650 0 510 0 220 0
650 0 520 0 220 0
670 0 580 0 230 0
690 0 625 0 240 0
Computer
400
400
400
600
600
800
775
800
800
900
950
1000
8425
Total Sales
2410 0
2490 0
2570 0
2630 0
2730 0
2780 0
2992 5
3030 0
3050 0
3190 0
3330 0
3400 0
34602 5
722
748
769
762
794
801
883
893
902
954
1002 0
1021 5
10253 5
Sales Espresso Drip Cofee Food/Bevera ges Merchandise
7000 6400 2500
Total
January
Annual Forecast
18340 0
7665 0 5615 0 2140 0
Expenses Cost of
Page 21
Microsoft Office Excel Goods
5
0
0
0
0
5
5
5
0
0
Cost of Merchandise
700
770
770 900 0
105 0 786 0
105 0 839 0
105 0 874 0
147 0 900 0
154 0 900 0
154 0 900 0
161 0 950 0
168 0 980 0
Payroll
900 0
900 0
Internet
325
325
325
325
325
325
325
325
325
325
Building
210 0
210 0
210 0
210 0
210 0
210 0
210 0
210 0
210 0
Advertising
600
600
600
600
600
600
600
600
Capital Assets Miscellaneou s Total Expenses
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
2275 0
2307 5
2328 5
2235 5
2320 5
2363 0
1,35 0
1,82 5
2,41 5
3,94 5
4,09 5
5.60 %
7.33 %
9.40 %
15%
15%
Net Income Profit Margin
1020 0
1498 0 1084 90
325
325
3900
210 0
210 0
2100
2520 0
600
600
600
600
7200
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
2513 0
2530 0
2538 5
2647 5
2732 5
2799 0
29590 5
4,17 0
4,79 5
5,00 0
5,11 5
5,42 5
5,97 5
6,01 0
50,12 0
15%
16%
16%
16%
17%
17%
17%
1750
1500 1300
1800 0 1560 0
16%
Note: Net Income = Total Sales – Total Expenses Profit Margin = Net Income / Net Sales
Exercise 30 Save Sable River Foundation Lifetime Fundraising Summary
Corporate
Allentow n 74,029.3 5
Chamber City 92,278.21
Catonsvil le 63,081.7 4
Page 22
Sable Village 84,210.02
Strongsv ille 61,644.2 6
Town of Cary 89,820.5 1
Total 465,064.0 9
Microsoft Office Excel Direct Mail Fun Runs Governmen t Phone-athon
Maximum Minimum Average Total
67,286.0 6 54,704.3 9 30,623.9 9 16,692.1 4 74,029.3 5 16,692.1 4 48,667.1 9 243,335 .93
83,867.23 66,934.67 58,614.35
55,076.4 8 64,581.6 6 51,486.4 6
55,547.28 28,895.86 36,387.09
24,223.81
9,492.91
17,328.74
92,278.21
64,581.6 6
84,210.02
24,223.81
9,492.91
17,328.74
65,183.65 325,918. 27
48,743.8 5 243,719 .25
44,473.80 222,368. 99
79,779.0 2 32,690.3 7 51,642.5 5 12,305.8 5
84,366.1 9 64,242.7 2 40,177.8 7 21,097.6 0
425,922.2 6 312,049.6 7 268,932.3 1 101,141.0 5
79,779.0 2 12,305.8 5 47,612.4 1 238,062 .05
89,820.5 1 21,097.6 0 59,940.9 8 299,704 .89
465,064.0 9 101,141.0 5 314,621.8 8 1,573,10 9.38
Exercise 31 Adventure Travels 1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
Total
Car Rentals
124,650
124,875
126,500
129,145
505,170
Airlines
225,000
226,902
229,995
235,390
917,287
1,125,530
1,350,655
1,500,675
1,755,850
5,732,710
2,236,480
2,567,892
2,756,215
3,125,689
10,686,276
550,000
550,545
595,655
605,115
2,301,315
Maximum
2,236,480
2,567,892
2,756,215
3,125,689
10,686,276
Minimum
124,650
124,875
126,500
129,145
505,170
Average
852,332
964,174
1,041,808
1,170,238
4,028,552
4,261,660
4,820,869
5,209,040
5,851,189
20,142,758
Tour Packages Cruise Packages Hotels
Total
Exercise 32 Page 23
Microsoft Office Excel Employe e ID
Last Name
First Name
Address
00212
Schif
Chad
235 N. Cactus Dr.
00617
Nichols
Cathy
75 Brooklea Dr.
Chesterfiel d Landis
Mark
23 Mill Ave.
Dan
564 S. Lemon Dr.
03225
Penningt on Morgan
03406
Lopez
Mina
03890
Thi
Erona
04321
Sabin
Greg
04731
Marchant
Roberta
05015
Briggs
Scott
00907
4290 E. Alameda Dr. 7867 Forest Ave. 90 E. Rawhide Ave. 564 Palm Avenue
City
State
ZIP Code
CA
92122
CA
92120
Landis
ca
92120
Maldin
CA
92121
Maldin
CA
92121-3740
River Mist
CA
92123
CA
92122
CA
92120
River Mist
Ca
92123-2232
Maldin
CA
92121
Maldin
CA
92121-3740
CA
92122-1268
CA
92121-3740
Chesterfiel d Landis
Anita
45 E. Camelback Rd. 832 S. William Ave. 2348 S. Bala Dr.
Ruiz
Enrique
35 Palm St.
11747
Lettow
Ryan
358 Maple Dr.
Chesterfiel d Maldin
12194
Polonsky
Mitch
8701 E. Sheridan
Maldin
CA
92121-3740
12213
Young
Kim
89 College Ave.
Landis
CA
92120
12230
Reddie
Suzanne
932 E. Parkway Dr.
Landis
CA
92120
12247
Rath
Kathy
87 E. Aurora Ave.
CA
92122-1268
12258
Delano
Gordon
CA
92122-1268
12366
Stacey
David
CA
92122-1268
07287
Robertso n Roman
08391
06000
12389 12501
Blackma n DeLuca
Kirk
1310 N. Sprindrift Dr. 737 S. College Rd.
Chesterfiel d Chesterfiel d Chesterfiel d
Jennifer
773 E. Laurel St.
River Mist
CA
92123-2232
Elizabeth
21 W. Southern
Landis
CA
92120
Page 24
Microsoft Office Excel Ave. 12583
Sullivan
Marie
12594
Reddie
Mark
12612
Lettow
Melissa
12655
Lahti
Jill
78 Omega Drive 900 W. Campus Dr. 234 N. 1st St. 5401 E. Thomas Rd.
Chesterfiel d
CA
92122-1268
Maldin
CA
92121
River Mist
CA
92123
Landis
CA
92120
Exercise 33
New Car Sales January
February
March
Total Sales
Alfred
68,560
87,657
67,865
224,082
Antonie
74,768
100,234
95,465
270,467
Bass
87,546
98,555
83,655
269,756
100,765
123,543
34,999
259,307
Bunnis
88,765
100,876
98,655
288,296
Cherisma
35,000
65,987
56,787
157,774
Delva
67,980
87,657
56,766
212,403
Dixon
82,987
102,675
45,673
231,335
Dearborn
98,765
132,987
105,467
337,219
Fleuridor
76,546
126,547
101,675
304,768
Heydt
65,785
87,657
67,865
221,307
Hinton
65,754
100,234
95,465
261,453
King
98,673
98,555
83,655
280,883
104,654
123,543
92,876
321,073
88,765
100,876
98,655
288,296
Bradley
Lamons Nudelman
Page 25
Microsoft Office Excel Sun
45,676
65,987
65,478
177,141
Tullos
98,765
87,657
98,675
285,097
Washington
82,987
67,876
34,765
185,628
Zappa
98,765
89,654
87,678
276,097
Zelaya
76,546
99,765
99,678
275,989
Maximum
104,654
132,987
105,467
337,219
Minimum
35,000
65,987
34,765
157,774
Average
80,403
97,426
78,590
256,419
1,608,052
1,948,522
1,571,797
5,128,371
Total
Exercise 34 Animal Angels Volunteers 1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
Average
Total
45
34
102
35
54
216
106
45
55
106
78
312
Carver, Kathi
30
83
3
3
29.75
119
Chorley, Besty
68
2
235
96
100.25
401
Clark, Jamel
51
30
28
58
41.75
167
Cody, Martin
28
66
6
45
36.25
145
Dickson, Diane
72
19
77
32
50
200
Edwards, Mike
12
20
61
28
30.25
121
Ferguson, Robby
99
12
0
43
38.5
154
32
66
34
30
40.5
162
57
98
93
80
82
328
13
25
55
100
48.25
193
Bell, Patricia Carey, Ronnie
Forester, Kimberly Franklin, Stacey Fulton, Anne
Page 26
Microsoft Office Excel Garcia, Maria
5
23
61
36
31.25
125
Gatens, Chris
0
100
58
85
60.75
243
Henderson, James
9
76
51
60
49
196
Ingram, Helen
29
12
33
12
21.5
86
Isbell, Sonya
46
65
47
3
40.25
161
5
25
18
7
13.75
55
Jones, April
70
83
38
79
67.5
270
Kelly, William
13
78
52
88
57.75
231
4
59
57
8
32
128
Kullman, Rodney
28
30
35
16
27.25
109
La Paglia, Sally
39
10
12
134
48.75
195
Lee, Su
56
6
5
0
16.75
67
Legge, Cristan
3
81
73
34
47.75
191
Lopez, Andrew
83
3
165
0
62.75
251
Marcus, Danielle
3
19
24
2
12
48
Merwin, Michael
44
9
95
37
46.25
185
Nelson, Faith
10
115
8
0
33.25
133
Johnson, Thaman
Kettonhoefer, Bill
Exercise 35 Last Name
First Name
Address
City
3333
Arteaga
Ella
58 Langley Avenue
2222
Barringt on
Cindy
7777
Bruner
5555 6666
ID
Stat e
Zip Code
Aurora
NC
28307
271 Latrell Road
Baltimore
NC
28306
Myra
182 Birchwood Street
Refugio
NC
28305
Caruso
Jill
524 Ridge Road
Spring Lake
NC
28390
Charlton
Kara
52 Hiroko Street
Spring Lake
NC
28390
Page 27
Phone (910) 4134728 (910) 4284137 (910) 3315052 (910) 4209063 (910) 3844911
Microsoft Office Excel 1234
Getty
William
1111
Givens
Bryan
4444
Haller
Geneva
9999
Keane
Vickie
8888
Mai
Tony
81 Columbus Road 72 White Eagle Street 985 Lisa Street 47 Carolyn Avenue 732 Oregon Street
Buena Vista
NC
28304
Fayetteville
NC
28301
Spring Lake
NC
28390
Middleton
NC
28309
Madison
NC
28302
(910) 4754153 (910) 4565660 (910) 3573062 (910) 4737752 (910) 3509309
Exercise 36 Type of Transaction Category
Qtr.
Description of Transaction Starting Balance Mr. G's
Withdrawal
Debit Card
Grocery
1
Check
Mortgage
1
Debit Card
Grocery
1
Faceless Mortgage Corp
Electric
1
Mr. G's
Credit Card
1
ERG/Synergy
Grocery
1
Power Bank
ATM
1
Mr. G's
92.64
Cell Phone
1
Cash
68.64
Cable
1
Busy signal Phone Co
30.00
ATM
1
Costly Cable Co
70.00
ATM
ATM
1
Cash
115.35
Debit Card
Grocery
1
Cash
28.72
Water
1
Wings' R Us
100.00
ATM
1
City Utilities
39.63
Electric
1
Cash
Automatic Withdrawal Automatic Withdrawal Debit Card ATM Automatic Withdrawal Automatic Withdrawal ATM
Automatic Withdrawal ATM Automatic
Page 28
1,280.00 114.42 37.09 350.00 71.14 100.00
112.59
Microsoft Office Excel Withdrawal Automatic Withdrawal Debit Card
Gas
1
ERG/Synergy
Grocery
1
Nat's Gas Service
Direct Deposit
Paycheck
1
Mr. G's
ATM
ATM
1
Direct deposited
Check
Mortgage
1
Cash
Credit Card
1
ATM
1
Faceless Mortgage Corp Power Bank
Cell Phone
1
Cash
ATM
1
Busy signal Phone Co
Cable
1
Cash
80.00
Grocery
1
Costly Cable Co
70.00
ATM
ATM
1
Mr. G's
ATM
ATM
1
Cash
1,280.00
Debit Card
Grocery
1
Cash
114.42
Check
Mortgage
1
Starting Balance
Automatic Withdrawal ATM Automatic Withdrawal ATM Automatic Withdrawal Debit Card
178.49 50.00 1,280.00 350.00 40.00 93.76 100.00 68.64 300.43
158.18
37.09
Exercise 37 Region
Rep
Item
Units
East
Jones
Pencil
95
1.99
189.05
Central
Kivell
Binder
50
19.99
999.50
Central
Jardine
Pencil
36
4.99
179.64
Central
Gill
Pen
27
19.99
539.73
West
Sorvino
Pencil
56
2.99
167.44
East
Jones
Binder
60
4.99
299.40
Central
Andrews
Pencil
75
1.99
149.25
Page 29
Unit Cost
Total
Microsoft Office Excel Central
Jardine
Pencil
90
4.99
449.10
West
Thompson
Pencil
32
1.99
63.68
East
Jones
Binder
60
8.99
539.40
Central
Morgan
Pencil
90
4.99
449.10
East
Howard
Binder
29
1.99
57.71
East
Parent
Binder
81
19.99
East
Jones
Pencil
35
4.99
174.65
Central
Smith
Desk
2
125.00
250.00
East
Jones
Pen Set
16
15.99
255.84
Central
Morgan
Binder
28
8.99
251.72
East
Jones
Pen
64
8.99
575.36
East
Parent
Pen
15
19.99
299.85
Central
Kivell
Pen Set
96
4.99
479.04
Central
Smith
Pencil
67
1.29
86.43
East
Parent
Pen Set
74
15.99
Central
Gill
Binder
46
8.99
Central
Smith
Binder
87
15.00
East
Jones
Binder
4
4.99
West
Sorvino
Binder
7
19.99
139.93
Central
Jardine
Pen Set
50
4.99
249.50
Central
Andrews
Pencil
66
1.99
131.34
East
Howard
Pen
96
4.99
479.04
Central
Gill
Pencil
53
1.29
68.37
Central
Gill
Binder
80
8.99
719.20
Central
Kivell
Desk
5
125.00
625.00
East
Jones
Pen Set
62
4.99
309.38
Central
Morgan
Pen Set
55
12.49
686.95
Page 30
1,619.19
1,183.26 413.54 1,305.00 19.96
Microsoft Office Excel Central
Kivell
Pen Set
42
23.95
1,005.90
West
Sorvino
Desk
3
275.00
Central
Gill
Pencil
7
1.29
9.03
West
Sorvino
Pen
76
1.99
151.24
West
Thompson
Binder
57
19.99
Central
Andrews
Pencil
14
1.29
18.06
Central
Jardine
Binder
11
4.99
54.89
Central
Jardine
Binder
94
19.99
Central
Andrews
Binder
28
4.99
825.00
1,139.43
1,879.06 139.72
Exercise 38 Aficionado Guitar Parts Monthly s Receivable Balance Report Customer
Beginn ing Balanc e
Credits
Payments
Purchase s
Service Charge
New Balance
Cervantes, Katriel
803.01
56.92
277.02
207.94
12.90
689.91
285.05
87.41
182.11
218.22
0.43
234.18
702.13
79.33
180.09
364.02
12.17
818.90
438.37
60.90
331.10
190.39
1.28
238.04
378.81
48.55
126.15
211.38
5.61
421.10
Raglow, Dora
710.99
55.62
231.37
274.71
11.66
710.37
Tuan, Lin
482.74
85.01
129.67
332.89
7.37
608.32
Totals
3,801. 10
473.74
1,457.51
1,799.55
51.42
3,720.82
Maximum
803.01
87.41
331.10
364.02
12.90
818.90
Cummings, Trenton Danielsson, Oliver Kalinowski, Jadwiga Lanctot, Royce
Page 31
Microsoft Office Excel Minimum
285.05
48.55
126.15
190.39
0.43
234.18
Average
543.01
67.68
208.22
257.08
7.35
531.55
Note: service charge = 2.75% * ( beginning balance – credits – payments – purchases ) New balance = beginning balance + credits + payments + purchases + service charges
Exercise 39
TYH-1MN3
Product Number 1123
TUP-2MN4
1456
98 %
4950
4876
TYH-1MN3
1356
99 %
3780
3769
TUP-2MN4
1487
99 %
4950
4777
NVB-9MN1
1876
96 %
4900
4435
TYH-1MN3
1001
90 %
5000
4570
TYH-1MN3
1100
91 %
4500
4641
Product Name
98 %
Input Quantity 5000
Output Quantity 4905
Yield
Exercise 40 Transaction
Category
Check 201
Mortgage
Debit Card
Grocery
Faceless Mortgage Corp Mr. G's
Electric
ERG/Synergy
Credit Card
Largo Credit Corp
Grocery
Mr. G's
ATM
ATM
Cash
Automatic Withdrawal
Cell Phone
Busy signal Phone Co
Automatic Withdrawal Automatic Withdrawal Debit Card
Description
Page 32
Withdrawal 780 114.42 37.09 150 71.14 100 42.64
Microsoft Office Excel Automatic Withdrawal ATM
Cable
Costly Cable Co
ATM
Cash
30
ATM
ATM
Cash
70
Credit Card
Grocery
Wings' R Us
115.35
Water
City Utilities
28.72
ATM
Cash
Electric
ERG/Synergy
Gas
Nat's Gas Service
112.59
Grocery
Mr. G's
178.49
ATM
ATM
Cash
Check 202
Mortgage
Faceless Mortgage Corp
780
Credit Card
Largo Credit Corp
150
ATM
Cash
Automatic Withdrawal ATM Automatic Withdrawal Automatic Withdrawal Debit Card
28.64
100 39.63
50
Direct Deposit Automatic Withdrawal ATM Automatic Withdrawal ATM Automatic Withdrawal Check 190
ATM
Busy signal Phone Co Cash
Cable
Costly Cable Co
Cell Phone
40 43.76 100 28.64
Void
ATM
ATM
Cash
80
ATM
ATM
Cash
70
Water
City Utilities
28.72
Electric
ERG/Synergy
39.45
Gas
Nat's Gas Service
Automatic Withdrawal Automatic Withdrawal Automatic Withdrawal
Page 33
120.77
Microsoft Office Excel ATM
ATM
Cash
Check 203
Mortgage
Faceless Mortgage Corp
80 780
Direct Deposit ATM
ATM
Cash
Credit Card
Grocery
Mr. G's
169.84
Debit Card
Grocery
Mr. G's
44.08
Credit Card
Largo Credit Corp
ATM
Cash
Cable
Costly Cable Co
Automatic Withdrawal ATM Automatic Withdrawal Automatic Withdrawal Debit Card Automatic Withdrawal Debit Card Automatic Withdrawal Debit Card Automatic Withdrawal
150 90 28.64
Grocery
Busy signal Phone Co Mr. G's
ATM
Cash
Water
City Utilities
28.72
Grocery
Mr. G's
81.79
Electric
ERG/Synergy
35.52
Grocery
Mr. G's
94.59
Gas
Nat's Gas Service
73.87
Cell Phone
ATM
70
50.74 131.51 30
Direct Deposit Check 204
Mortgage
Debit Card
Grocery
Faceless Mortgage Corp Mr. G's
780 133.64
Exercise 41 Application # 000123
First Name
Last Name
Address
City
Marilyn
Foster
505 Lincoln Ave.
Brentwood
Page 34
Microsoft Office Excel 000125
Mikhail
Siederhof
17 Spyglass Cir.
Oceanview
000138
Yvonne
Brady
301 Canoe Ave.
Palmdale
000139
Adelle
Cavenough
999 Seaspray Dr.
Palmdale
000146
Olef
Borisnov
403 Skif Cir.
Brentwood
000147
Lenny
Brewster
2100 Palm St.
Lexington
000150
Carolyn
Welsh
186 Alameda St.
Brentwood
000158
Danielle
Nash
725 Waterway Ln.
Oceanview
000167
Yong
Wu
326 Rockwell St.
Oceanview
000173
Jessica
Clegg
532 A St.
Palmdale
000177
Christopher
Finkle
323 Lorry Ave.
Lexington
000180
Paul
Vishon
2012 Hunt Rd.
Oceanview
000199
Terence
Pratt
1724 Lakewood Rd.
Lexington
000206
Ahmed
Jamal
511 Cabrillo Cir.
Brentwood
000209
Lily
Hammond
64 Spring St.
Palmdale
000211
Ernest
Helms
490 Wilson Ave.
Palmdale
000222
Roberta
Drew
203 Scanlan Rd.
Palmdale
000232
Leon
French
188 10th Ave.
Oceanview
000241
Wendy
Thompson
1947 Cypress Dr.
Lexington
000256
Mohammed
Patan
2097 5th Ave.
Oceanview
000263
Bob
Alvarez
616 Vasser Way
Oceanview
000264
Vincent
Ashton
387 Alamo Way
Lexington
000300
Herve
Umeza
812 Grant Ave.
Brentwood
000301
Phillip
Roberts
1221 Ferret St.
Oceanview
Exercise 42 Data Entry for Financial Forecast Analysis 2006
2007 Page 35
2008
2009
Four Year Totals
Microsoft Office Excel Sales 8,583,600.0 0 0 8,583,600.0 0
Sales
2,010,000.00
2,060,000.00
2,121,800.00
2,391,800.00
Other
0
0
0
0
2,010,000.00
2,060,000.00
2,121,800.00
2,391,800.00
320,000 500,000 125,500 0
329,600 515,000 128,750 0
339,488 530,450 132,613 0
389,088 545,450 186,363 0
1,378,176 2,090,900 572,725 0
945,000
973,350
1,002,551
1,120,901
4,041,801
1,065,000
1,086,650
1,119,250
1,270,900
4,541,800
190,000
190,000
190,000
190,000
760,000
50,000
51,500
53,045
54,545
209,090
30,000 5,000 3,000
30,900 5,150 3,090
31,827 5,350 3,183
32,727 5,455 3,273
125,454 20,909 12,545
1,000
1,030
1,061
1,061
4,152
1,000 2,133 11,000 4,000
1,030 2,197 11,330 4,120
1,061 2,263 11,670 4,244
1,061 2,263 12,670 4,244
4,152 8,856 46,670 16,607
6,000
6,180
6,365
6,365
24,911
1,000
1,030
1,061
1,061
4,152
3,000
3,090
3,183
3,183
12,455
1,000
1,030
1,061
1,061
4,152
1,000
1,030
1,061
1,061
4,152
1,000 1,000 6,000
1,030 1,030 6,000
1,061 1,061 6,000
1,061 1,061 6,000
4,152 4,152 24,000
Total Sales Less Cost of Goods Sold Materials Labor Overhead Other Total Cost of Goods Sold Gross Profit Operating Expenses Salaries and wages Employee Benefits Payroll taxes Rent Utilities Repairs and maintenance Insurance Travel Telephone Postage Office supplies Advertising Marketing / promotion Professional fees Training and development Bank charges Depreciation Interest
Page 36
Microsoft Office Excel Expense Other Total Operating Expenses
0
0
0
0
0
317,133
320,767
324,510
328,150
1,290,560
Exercise 43 Last Name
First Name
Doctor Name
Hollars
Stacey
Hollars, Stacey
Smith
Carol
Smith, Carol
Griesemer
Joshua
McConnell
Alicia
Probus
Kelly
Rodgers
Michael
Murphy
Griesemer, Joshua McConnell, Alicia Probus, Kelly
Specialty Family Medicine Emergency Cardiology Sports Medicine Emergency
Sample s
Lunches
10
no
9
yes
5
no
15
yes
9
yes
1
yes
5
no
Tina
Rodgers, Michael Murphy, Tina
Family Medicine Cardiology
Bates
Alex
Bates, Alex
Pediatrics
7
no
Gladish
Judith
Gladish, Judith
Pediatrics
5
no
Law
Tara
Law, Tara
Pediatrics
8
no
Ash
Cheryl
Ash, Cheryl
Radiology
10
yes
Blanton
Samuel
Cardiology
13
yes
Griesemer
Joshua
Cardiology
8
no
Jones
Jennifer
4
yes
McConnell
Alicia
7
no
Ash
3
no
Gladish
2
no
Blanton, Samuel Griesemer, Joshua
Cheryl
McConnell, Alicia Ash, Cheryl
Sports Medicine Sports Medicine Radiology
Judith
Gladish, Judith
Pediatrics
Jones, Jennifer
Page 37
Microsoft Office Excel Smith
Carol
Smith, Carol
Emergency
15
yes
Murphy
Tina
Murphy, Tina
Cardiology
3
yes
Smith
Carol
Smith, Carol
Emergency
0
yes
Probus
Kelly
Probus, Kelly
Emergency
0
yes
Rodgers
Michael
no
Alex
Family Medicine Radiology
0
Bates
Rodgers, Michael Bates, Alex
2
no
Jones
Jennifer
Jones, Jennifer
10
no
Murphy
Tina
Murphy, Tina
Sports Medicine Cardiology
15
yes
Bates
Alex
Bates, Alex
Radiology
10
yes
Jones
Jennifer
Jones, Jennifer
5
no
Law
Tara
Law, Tara
6
yes
Blanton
Samuel
Cardiology
10
yes
Law
Tara
Pediatrics
15
no
Griesemer
Joshua
Griesemer, Joshua
Cardiology
11
yes
Jones
Jennifer
Jones, Jennifer
9
no
Maris
Jonathon
Maris, Jonathon
Sports Medicine Emergency
14
no
Barnes
Ethan
Barnes, Ethan
Pediatrics
10
no
Partner
Debra
Partner, Debra
15
yes
McCoy
Sarah
McCoy, Sarah
Family Medicine Emergency
14
yes
Smith
Carol
Smith, Carol
Emergency
3
yes
Thompson
Jennifer
Cardiology
14
yes
Bates
Alex
Thompson, Jennifer Bates, Alex
Radiology
14
yes
Law
Tara
Law, Tara
Pediatrics
2
no
Blanton
Samuel
Blanton,
Cardiology
6
no
Blanton, Samuel Law, Tara
Page 38
Sports Medicine Pediatrics
Microsoft Office Excel Samuel Griesemer, Joshua Probus, Kelly
Griesemer
Joshua
Probus
Kelly
Rodgers
Michael
Rodgers, Michael
Hollars
Stacey
Hollars, Stacey
Blanton
Samuel
Griesemer
Joshua
Jones
Jennifer
Jones, Jennifer
Smith
Carol
Smith, Carol
Griesemer
Joshua
Griesemer, Joshua
Blanton, Samuel Griesemer, Joshua
Cardiology
10
yes
Emergency
13
no
12
yes
6
yes
Cardiology
5
no
Cardiology
10
yes
10
no
6
yes
12
yes
Family Medicine Family Medicine
Sports Medicine Emergency Cardiology
Exercise 44 Part Number
Type
11164539
RT
11164540
AC
11164541
AB
11164542
RT
11164544
AC
11164545
DE
11164546
DE
11164547
DE
Departmen t Department 2 Department 5 Department 4 Department 2 Department 5 Department 5 Department 2 Department 4 Page 39
Cost
Quantity
Total Value
55.30
15
829.50
69.58
7
487.06
47.87
1
47.87
16.22
5
81.10
54.36
-
74.45
13
967.85
52.03
11
572.33
25.74
8
205.92
Microsoft Office Excel 11164548
DB
11164549
DE
11164550
DB
11164551
RT
11164556
DE
11164557
AB
11164558
DE
11164559
AC
11164560
RT
11164561
RT
11164562
DE
11164563
DE
11164564
AC
11164565
RT
11164567
AB
11164568
AC
11164569
DE
11164570
DB
Department 5 Department 4 Department 1 Department 2 Department 4 Department 2 Department 1 Department 1 Department 5 Department 3 Department 2 Department 1 Department 5 Department 2 Department 3 Department 1 Department 3 Department 3
Exercise 45 Page 40
39.12
14
547.68
10.97
3
32.91
18.56
12
222.72
45.80
17
778.60
88.39
2
176.78
79.08
12
948.96
15.28
7
106.96
2.77
15
41.55
40.96
-
25.07
12
300.84
0.84
12
10.08
9.42
3
28.26
16.02
7
112.14
77.83
4
311.32
1.54
15
23.10
9.81
1
9.81
1.77
8
14.16
7.99
13
103.87
Microsoft Office Excel Grow More Hospitality Services Private Limited
Page 41
Microsoft Office Excel Salary Statement for the month of December 2011 Sl. No .
ID No.
Name
Basic
VDA
HRA
CON V
Medic al
Wash Allow
50,00 0 30,00 0
20,00 0
800
0
800
2,000
800
0
600
22,00 0
2,4 00
2,50 0
Spl. Allow
Othe rs
Total
0
1,00,0 00
0
60,000
599
0
10,000
1,20 0
53,8 97
0
1,70,0 00
istration 1 2
GM00 1 GM00 2
3
Allen, Timothy J Kershaw, David Lapham, Carrie A Total
85,0 00
1,00 1 1,00 1 1,00 1 3,00 3
Abel, Mary E
3000
1001
400
0
0
600
999
0
6000
Total
3000
100 1
400
0
0
600
999
0
6000
Sentell, Tricia J
6000
1001
2150
800
1250
0
799
0
12000
Profer, Brian
2250
1001
550
0
0
600
99
148
4648
3250
1001
600
250
0
600
799
0
6500
3500
1001
600
500
0
600
799
0
7000
5,000
1,25 0 1,25 0
600 0
26,34 9 26,94 9
Security 4
s 5
113
6 7
652
8
Beamish, Coleen Mason, Timothy
9
Rose, Gina M
4250
1001
800
600
0
600
1249
0
8500
10
Streby, Paul G
7500
1001
2600
800
1250
0
1849
0
15000
Total
2675 0
600 6
7300
295 0
2500
240 0
5594
148
53648
3250
1001
600
250
0
600
799
0
6500
Maintenance 11
824
Terry, Andrea
Page 42
Microsoft Office Excel Total
3250
100 1
600
250
0
600
799
0
6500
Banerjee, Ruma
3250
1001
600
250
0
600
799
0
6500
13
Baptist, Jan
2450
1001
400
0
0
600
1049
0
5500
14
Bartlett, Lisa
2450
1001
400
0
0
600
1049
0
5500
2450
1001
400
0
0
600
1049
0
5500
2450
1001
400
0
0
600
1049
0
5500
Total
1305 0
500 5
2200
250
0
300 0
4995
0
28500
17
Dyer, Judy A
4500
1001
700
700
0
600
1499
0
9000
18
Calma, Grace C
4500
1001
700
700
0
600
1499
0
9000
Total
9000
200 2
1400
140 0
0
120 0
2998
0
18000
Drivers 12
114
15 16
Carney, Linda M Koonmen, Jamie
Bouncer
F & B Services 19
Kidd, Reva J
6000
1001
2400
800
0
600
1199
0
12000
20
Jafurs, Sheri E
7500
1001
2600
800
1250
0
1849
0
15000
21
Haley, John J
4500
1001
700
700
0
600
1499
0
9000
3500
1001
600
500
0
600
799
0
7000
2500
1001
750
0
0
600
149
0
5000
22 23
Glover, Cory M Flynn, Crystal A
24
Ellis, Joel
2250
1001
550
0
0
600
99
342
4842
25
Cherem, Barbara
3000
1001
400
0
0
600
999
0
6000
26
Bur, Kevin P
2500
1001
750
0
0
600
149
0
5000
27
Clyde, Paul S
4000
1001
1600
0
0
600
799
0
8000
Page 43
Microsoft Office Excel 28
Clyde, Paul S
2250
1001
550
0
0
600
99
342
4842
29
Clark, Susan M
2250
1001
550
0
0
600
99
342
4842
30
Book, C Jane
3000
1001
400
0
0
600
999
0
6000
31
Bonk, Mario
2250
1001
550
0
0
600
99
342
4842
32
Pomo, Darrin
2250
1001
550
0
0
600
99
342
4842
33
Salata, Diane L
2250
1001
550
0
0
600
99
342
4842
34
Zhou, Chuan
2250
1001
550
0
0
600
99
342
4842
35
Xue, Xiaolin
4000
1001
1600
0
0
600
799
0
8000
36
Nichols, Larry
3000
1001
400
0
0
600
999
0
6000
37
Total
5925 0
180 18
1605 0
280 0
1250
102 00
1093 2
239 4
12089 4
Grand Total
199,30 0
36,03 6
49,950
10,0 50
6,250
19,20 0
80,214
2,54 2
303,542
Exercise 46 Randolph Academy 336 Main St, Randolph, NY 14772, United States Income & expenditure for the year ended 31st march 2010 PARTICULARS
2009 – 2010 ( Rs. )
2008 – 2009 ( Rs. )
INCOME : Donation In INR In Foreign Currency Equivalent to INR
Page 44
9,527,408
12,314,346
170,791
25,758
Microsoft Office Excel Bank Interest On Bank FDRs
401,147
195,983
34,799
30,817
3,740,464
3,373,850
849
0
13,875,457
15,940,754
4,261,021
3,807,880
325,000
275,000
8,305,035
8,743,968
61,900
66,950
12,952,956
12,893,798
922,501
3,046,956
813,776
850,089
108,725
2,196,867
On Bank Project Receipts Other Income TOTAL EXPENDITURE : istrative Expenses Donation Project Expenses Affiliation Fees TOTAL SURPLUS / ( DEFICIT ) BEFORE DEPRECIATION Less: Depreciation SURPLUS / ( DEFICIT ) TRANFERRED TO CORPUS FUND
Exercise 47 Randolph Academy 336 Main St, Randolph, NY 14772, United States Income & expenditure for the year ended 31st march 2010 Page 45
Microsoft Office Excel PARTICULARS
2009 – 2010 ( Rs. )
2008 – 2009 ( Rs. )
203,500
0
Schedule No. 1 hip Fund Opening Balance Received During the year
66,000
203,500
269,500
203,500
11,029,427
8,832,560
108,725
2,196,867
11,138,152
11,029,427
Total Schedule No. 2 Corpus Fund Opening Balance Excess of Income over Expenditure Total
Exercise 48 Balance Sheet - Years 1 to 4 Opening
Year 1
Year 2
Year 3
Year 4
507,604 4,300 393,928 450,204 11,255 1,367,29 1
451,000 1,200 350,000 400,000 10,000 1,212,20 0
464,530 3,200 360,500 412,000 10,300 1,250,53 0
478,466 3,000 371,315 424,360 10,609 1,287,75 0
492,820 3,400 382,454 437,091 10,927 1,326,69 2
2,701,22 1 450,204
2,400,00 0 400,000
2,472,00 0 412,000
2,546,16 0 424,360
2,622,54 5 437,091
ASSETS Current Assets Cash Notes Receivable s receivable, net Inventory Other Total Current Assets Long-Term Assets Property, plant, and equipment Less accumulated depreciation
Page 46
Microsoft Office Excel Net property, plant, and equipment Other long-term assets Total Long-Term Assets Total Assets
2,251,01 8 58,765 2,309,78 3
2,000,00 0 55,000 2,055,00 0
2,060,00 0 55,900 2,115,90 0
2,121,80 0 56,827 2,178,62 7
2,185,45 4 57,782 2,243,23 6
3,677,07 4
3,267,20 0
3,366,43 0
3,466,37 7
3,569,92 8
675,305
600,000
618,000
636,540
655,636
112,551
100,000
103,000
106,090
109,273
112,551 33,765 101,296 18,008 1,053,47 6
100,000 30,000 90,000 16,000
103,000 30,900 92,700 16,480
106,090 31,827 95,481 16,974
936,000
964,080
993,002
109,273 32,782 98,345 17,484 1,022,79 2
692,156
601,200
624,200
645,630
668,308
112,551 85,903 890,610
100,000 79,000 780,200
103,000 80,650 807,850
106,090 82,350 834,070
109,273 84,101 861,682
1,944,08 6
1,716,20 0
1,771,93 0
1,827,07 2
1,884,47 4
100,000 1,000 56,275 1,575,71 2 1,732,98 8
100,000 1,000 50,000 1,400,00 0 1,551,00 0
100,000 1,000 51,500 1,442,00 0 1,594,50 0
100,000 1,000 53,045 1,485,26 0 1,639,30 5
100,000 1,000 54,636 1,529,81 8 1,685,45 4
3,677,07 4
3,267,20 0
3,366,43 0
3,466,37 7
3,569,92 9
LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities Short-term debt Current maturities of long-term debt s payable Income taxes payable Accrued liabilities Other Total Current Liabilities Long-Term Liabilities Long-term debt less current maturities Deferred income taxes Other long-term liabilities Total Long-Term Liabilities Total Liabilities Shareholders' Equity Common stock Additional paid-in capital Retained earnings Other Total Shareholders' Equity Total Liabilities and Shareholders' Equity
Exercise 49 Page 47
Microsoft Office Excel Cisco Systems India Pvt. Ltd. Emp. Code Departme nt Bank Name P.F No. Comp. Of LWP/Abse nt CL/CL Balance MAL/Balan ce
16701
Name
Joseph
Branch/Si te
Cisco Systems
Operation
Designation
Tech.
Grade
S4
SVC
No.
4780
Division
Facility Management
KN/BN/358
ESIC No.
289456781
4/0
Days Present
22
Pan No. W.Of/Pd. Of
0/5
Days Paid
30
0/0
SL/SL Bal
0/0
0/0
PAL/Bal
0/0
Month PL/Balanc e L6/Balanc e
4/0 Feb 2010 0/0 0/12
Exercise 50 Salary Slip Employee Name Designation School Name Income tax PAN Month and year Emoluments Basic pay House rent allowance Dearness allowance Medical allowance Vehicle allowance Washing allowance Other allowance Other allowance
Gross pay
James Asst. Teacher St. Anne high school, Lawrence road, Amritsar 143 001 AAAPP1111L December 2010 Amount Rs. Deductions Amount Rs. 15,000 Profession tax 200 3,000 General provident fund 4,000 Contributory provident 7,500 fund 100 Life insurance corporation 5,000 Postal life insurance 240 Group insurance 150 Income tax (TDS) 1,000 Credit society 300
25,600
*Net pay = Gross pay – Total deductions Page 48
Total deductions
10,890
Net pay
14,710
Microsoft Office Excel Exercise 51 Sl. No
City
Bank
1
Agra
ICICI
Ground floor, 18, A/51, Fatehbad Road, Agra - 282001
2
Agra
ICICI
C- 80 / 4, Kamla Nagar, Agra - 282005
3 4 5 6
Ahmedab ad Ahmedab ad Ahmedab ad Ahmedab ad
ICICI ICICI Centurio n
Address
JMC House Opp.Parimal Garden, Of. C.G. Road, Ambavadi Ahmedabad 380 006 2, Shashi Shopping Complex, Swaminarayan Chowk, Paldi Vasna, Ahmedabad Sarkhej Gandhinagar Highway
HSBC
ShopNo.UL12,IndraprasthaTower,Drive-InRoad,Ahmedabad380054
7
Amritsar
ICICI
Airport Authority of India, Rajsansi Airport, Amritsar - 143 001
8
Amritsar
ICICI
S.C.F 39, Kabir Park, Opp Gurunanak Dev University, Amritsar 141003.
9
Amritsar
ICICI
Nidhi, 2- Lawrence Road, Amritsar 143 001.
HDFC
Shop No. 16 , Ground Floor
HDFC
Parle Biscuits, Bahadurgarh
ICICI
1292, 25th Main Road, Jayanagar, 9th Block, Bangalore - 560069.
ICICI
No 641, 11th Main , 46th Cross, 5th Block, Banglore – 560041
10 11 12 13 14 15 16 17 18
Aurangab ad Aurangab ad Bangalor e Bangalor e Bangalor e Bangalor e Bangalor e Bangalor e Bangalor e
ICICI ICICI ICICI
Asea Brown Boveri Ltd., Plot No.5 & 6, II Phase, Peenya Industrial Area 560058. Annapurna, IOCL Pump R.V.Road, Next To Vijaya College, Bangalore - 560009. 80/7, Elephant Rock Road, Block III, Jayanagar, Bangalore 560 041.
ICICI
366-367, 1st A Main, VII Block, Koramangala, Bangalore 560 095.
HDFC
No. 6, Royal Arcade
Page 49
Microsoft Office Excel Exercise 52 Projected Balance Sheet Integral India Software Development Centre Pvt. Ltd. No. 99, mittal towers, 3rd main, 2nd cross, Bangalore – 560 001 January
February
March
April
May
June
July
August
Septemb er
October
Novemb er
Decemb er
10,0 00 20,0 00
10,0 50 18,0 00
12,0 00 20,0 00
10,0 00 17,0 00
13,0 00 16,0 00
20,0 00 17,9 00
21,0 00 17,8 50
22,0 00 19,0 00
18,2 50 25,0 00
26,0 00 26,0 00
22,0 00 21,0 00
25,4 50 18,0 00
s receivable
12,0 00
15,0 00
13,9 00
17,0 00
21,0 00
13,0 00
15,0 00
18,0 00
20,0 00
15,7 00
14,0 00
16,0 00
Prepaid expenses Other current assets
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
0
0
0
0
0
0
0
0
0
0
0
0
Total current assets
43,0 00
44,0 50
46,9 00
45,0 00
51,0 00
51,9 00
54,8 50
60,0 00
64,2 50
68,7 00
58,0 00
60,4 50
Balance sheet
Cash Inventory
Exercise 53 Pro-Forma Balance Sheet ASSETS Current Assets Cash Net s receivable Inventory Temporary investment
Xyz company From (2003 - 2006) 2003 2004 54,000 3,67,000 1,77,000 12,000 Page 50
57,000 3,96,000 1,91,000 12,000
2005
2006
59,000 4,26,000 2,03,000 12,000
64,000 4,35,000 12,000
Microsoft Office Excel Prepaid expenses
2,000
2,000
2,000
2,000
6,12,000
6,58,000
7,02,000
5,13,000
42,000 6,56,000 9,03,000 6,08,000 61,000
43,000 6,56,000 9,28,000 6,31,00 65,000
43,000 6,84,000 9,83,000 6,42,000 68,000
46,000 7,27,000 10,21,000 6,54,000 72,000
Total fixed assets
22,70,000
17,55,100
24,20,000
25,20,000
TOTAL ASSETS
28,82,000
24,13,100
31,22,000
30,33,000
Total current assets Fixed Assets Long-term investments Land Buildings (net of depreciation) Plant and equipment (net) Furniture and fixtures (net)
LIABILITIES Current liabilities s payable Short-term notes Current portion of long-term notes Accruals and other payables
2,56,000 24,000
2,52,000 25,000
2,58,000 26,000
2,77,000 28,000
14,000
14,000
14,000
15,000
14,000
14,000
14,000
14,000
Total current liabilities
3,08,000
3,05,000
3,12,000
3,34,000
Long-term liabilities Mortgage Other long-term liabilities
8,97,000 4,43,000
9,31,000 14,16,000
9,78,000 15,05,000
10,21,000 15,97,000
13,40,000
23,47,000
24,83,000
26,18,000
3,00,000 9,44,000
3,00,000 9,60,000
3,00,000 10,05,000
3,00,000 10,07,000
Total shareholders’ equity
12,44,000
12,60,000
13,05,000
13,07,000
Total liabilities and equity
28,92,000
39,12,000
41,00,000
42,59,000
Total long-term liabilities Shareholders’ equity Capital stock Retained earnings
Exercise 54
Page 51
Microsoft Office Excel Sales
Page 52
Microsoft Office Excel Janua ry
Febru ary
Marc h
Total Sales per Region
Amos, Andy
52,00 0
35,000
45,50 0
837,100
Boyd, Betty
45,00 0
27,500
52,00 0
124,500
Cox, Carole
65,00 0
32,500
51,50 0
149,000
Dell, Denice
75,00 0
80,500
75,00 0
230,500
Evans, Everett
45,00 0
70,500
85,10 0
200,600
Fountain, Fran
35,00 0
37,500
78,52 0
Garner, Gabe
27,50 0
81,000
70,50 0
179,000
Henry, Herb
32,50 0
45,000
37,50 0
115,000
Ingram, Ian
80,50 0
82,500
81,00 0
244,000
Jackson, Jake
70,50 0
70,500
45,00 0
186,000
King, Karl
25,00 0
37,500
82,50 0
81,00 0
85,000
75,00 0
241,000
56,50 0
60,500
45,00 0
162,000
Sales Report Region 1
Region 2
Region 3
Lemmons, Leslie Murdoch, Martin
Page 53
875,020
1,067,000
Total Sales per Employee 132,500
151,020
145,000
Microsoft Office Excel Neil, Nelly
94,00 0
97,000
50,00 0
341,000
70,00 0
75,500
32,50 0
178,000
Pine, Phyllis
48,50 0
45,500
35,00 0
Quartz, Cody
52,00 0
52,000
27,50 0
131,500
Russell, Ryan
51,50 0
51,500
32,50 0
135,500
75,00 0
52,000
80,50 0
207,500
85,10 0
45,000
70,50 0
200,600
78,52 0
65,000
37,50 0
Varner, Vince
45,85 0
75,000
81,00 0
201,850
Webb, Wyatt
75,85 0
45,000
45,00 0
165,850
65,89 0
35,000
82,50 0
183,390
78,88 0
27,500
82,50 0
188,880
Ormond, Oprah Region 4
Stevens, Stuart Tate, Thomas Region 5
Unger, Ulysses
Younts, Yolanda Zimmerman, Zack
804,100
920,990
129,000
181,020
Exercise 55 Sl. No.
Database Marketing City/State Quantity Page 54
Price
Microsoft Office Excel 1. 2. 3. 4. 5. 6. 7. 8. 9. 10.
Mumbai Delhi Bangalore Hyderabad Gujarat Maharashtra Haryana Kerala Andhra Pradesh
60 lakh 1 crore 60 lakh 24 lakh 1.5 crore 1.2 crore 90 lakh 35 lakh 2 core
20,000 30,000 20,000 15,000 35,000 35,000 30,000 15,000 50,000
Madhya Pradesh
25 lakh
20,000
Tamil Nadu
1 crore
30,000
Uttar Pradesh
2.5 crore
60,000
Punjab
40 lakh
20,000
11. 12. 13.
Exercise 56 Category
City/Stat e
Quantity
1.
All India Addresses Database
All India
15 lac addresses
2.
HNI Mumbai
Mumbai
3.
Job Seekers
All India
4.
CEO Personal Email Ids
All India
5.
Companies in Mumbai
Mumbai
6.
Companies in Delhi
Delhi
Sl. No.
Price 10,000
2 Lakh ( 95% Accurate ) 4 Lakh ( 95% Accurate ) 50,000 ( 90% Accurate ) 6 Lakh ( 85% accurate ) 5 Lakh ( 85% Accurate )
8,900 10,000 4,500 10,000 10,000
Exercise 57 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Income Page 55
Jul
Aug
Sep
Oct
Nov
Dec
To t
Av g
Microsoft Office Excel Wages & Tips Interest Income Dividends Gifts Received Reimburseme nt’s Savings Other
100 0 200 0 300 0 400 0 500 0 600 0 700 0
500 100 0 150 0 200 0 250 0 300 0 350 0
100 0 110 0 120 0 130 0 140 0 150 0 160 0
200 0 250 0 300 0 350 0 400 0 450 0 500 0
500 600 700 800 900 100 0 110 0
350 0 300 0 250 0 200 0 150 0 100 0 500
130 0 160 0 190 0 220 0 250 0 280 0 310 0
120 0 140 0 160 0 180 0 200 0 220 0 240 0
320 0 360 0 400 0 440 0 480 0 520 0 560 0
180 0 200 0 220 0 240 0 260 0 280 0 300 0
100 0 160 0 220 0 280 0 340 0 400 0 460 0
500 700 900 110 0 130 0 150 0 170 0
Total
Exercise 58 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Home Expenses Mortgage / Rent Electricity
350 0 500
350 0 550
350 0 600
350 0 650
350 0 700
350 0 750
350 0 800
350 0 850
350 0 900
350 0 950
Gas / Oil
750
800
850
900
950
750
800
850
900
Water / Sewer
100 0 600 300 200 0 350 300
100 0 610 300 200 0 400 300
100 0 620 300 200 0 450 300
100 0 630 300 200 0 500 300
100 0 640 300 200 0 550 300
100 0 100 0 650 300 200 0 600 300
350 0 100 0 950
100 0 660 300 200 0 650 300
100 0 670 300 200 0 700 300
100 0 680 300 200 0 750 300
100 0 690 300 200 0 800 300
100 0 700 300 200 0 850 300
350 0 150 0 100 0 100 0 710 300 200 0 900 300
100
200
300
400
500
600
100
200
300
400
500
600
100 0 200 0
100 0 200 0
100 0 200 0
100 0 200 0
100 0 200 0
100 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
Phone Cable Internet Furnishings Lawn / Garden Home Supplies Maintenance Improvement s
Page 56
To t
Av g
Microsoft Office Excel Other
-
-
-
-
-
-
220 0
360 0
-
750 0
-
-
Total
Exercise 59 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
600 500
650 500
600 500
650 500
600 500
650 500
600 500
650 500
600 500
650 500
600 500
650 500
300 0 100 0 400 0 100 0 300
350 0 100 0 600 0 100 0 300
300 0 100 0 200 0 100 0 300
300 0 100 0 500 0 100 0 300
350 0 100 0 400 0 100 0 300
300 0 100 0 300 0 100 0 300
350 0 100 0 200 0 100 0 300
300 0 100 0 100 0 100 0 300
350 0 100 0 200 0 100 0 300
300 0 100 0 300 0 100 0 300
350 0 100 0 100 0 100 0 300
-
-
-
350 0 100 0 300 0 100 0 300 0 -
-
-
-
-
-
-
-
-
To t
Av g
To t
Av g
Daily Living Groceries Personal Supplies Clothing Cleaning Services Dining/Eating out Dry Cleaning Salon / Barber Other Total
Exercise 60 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Medical
500 400 0 800 0 300 0 100 0 200 0
150 0 500 0 800 0 300 0 100 0 200 0
200 0 550 0 800 0 300 0 100 0 200 0
250 0 600 0 800 0 300 0 100 0 200 0
300 0 650 0 800 0 300 0 100 0 200 0
500
Clothing
100 0 450 0 800 0 300 0 100 0 200 0
100 0 450 0 800 0 300 0 100 0 200 0
150 0 500 0 800 0 300 0 100 0 200 0
200 0 550 0 800 0 300 0 100 0 200 0
250 0 600 0 800 0 300 0 100 0 200 0
300 0 650 0 800 0 300 0 100 0 200 0
Children
School Tuition School Lunch School Supplies Babysitting
Page 57
400 0 800 0 300 0 100 0 200 0
Microsoft Office Excel Toys / Games Other
600 0 -
600 0 -
600 0 -
600 0 -
600 0 400
600 0 300
600 0 200
600 0 100
600 0 500
600 0 -
600 0 -
600 0 600
Total
Exercise 61 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
To t
Av g
To t
Av g
To t
Av g
Transportation Vehicle Payment Fuel Bus / Taxi Repairs Registration Other
100 0 300 0 700 300 400 -
Total
Exercise 62 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
700
700
700
700
700
700
700
700
700
700
700
700
300
300
300
300
300
300
300
300
300
300
300
300
200
250
300
350
400
450
200
250
300
350
400
450
100 0 -
150 0 -
100 0 -
150 0 -
200 0 -
350 0 -
100 0 -
250 0 -
300 0 -
320 0 -
250 0 -
300 0 -
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Health Doctor / Dentist Medicine / Drugs Health Club Dues Emergency Other Total
Exercise 63 Family Budget Planner Jan
Feb
Mar
Apr
Business Expense Page 58
Microsoft Office Excel Deductible NonDeductible Other Other
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
-
-
-
-
-
-
-
-
-
-
-
-
Total
Page 59
Science
Math
English
Total
Average
Daniel Maureen John Nihar Somnath Priya Spoorthi
89 67 78 86 75 86 68
87 81 86 89 87 76 61
79 69 86 86 64 53 72
255 217 250 261 226 215 201
85 72.33 83.33 87 75.33 71.66 67
Percentag e 85 % 72 % 83 % 87 % 75 % 72 % 67 %
Exercise 2 Name
Kannada
English
Hindi
Total
Average
Anjali Naima Nikhil Talan Shreya Pragathi Anu
75 87 68 68 76 84 85
87 68 64 69 49 69 96
64 57 67 64 58 71 55
226 212 199 201 183 224 236
75.33 70.66 66.33 67 61 74.66 78.66
Percentag e 75 % 71 % 66 % 67 % 61 % 75 % 79 %
Exercise 3 Name
Math
Science
Social
Total
Average
Sharma Gupta Malhotra Bhatnagar Saxena Haritha Ashwini
78 68 49 67 75 79 86
59 94 58 73 69 64 74
68 75 47 79 48 73 69
205 237 154 219 192 216 229
68.33 79 51.33 73 64 72 76.33
Percentag e 68 % 79 % 51 % 73 % 64 % 72 % 76 %
Exercise 4 Name
Kannada
English
Hindi
Total
Average
Benjamin Augustine David Edward Charles Elbert Kelly
76 97 59 68 49 76 68
84 67 68 76 67 84 85
79 84 71 59 58 52 73
239 248 198 203 174 212 226
79.66 82.66 66 67.66 58 70.66 75.33
Page 1
Percentag e 80 % 83 % 66 % 68 % 58 % 71 % 75 %
Microsoft Office Excel Exercise 5 Name
Test 1
Test 2
Test 3
Total
Average
Frank Pace Getty Robert Amy John Alan
72 68 67 58 55 72 81
67 73 58 67 59 85 73
75 85 67 49 57 64 72
214 226 192 174 171 221 226
71.33 75.33 64 58 57 73.66 75.33
Percentag e 71 % 75 % 64 % 58 % 57 % 74 % 75 %
Exercise 6 Worldwide Sporting Goods Sales
January
Februar y
March
Total Sales
Expens es
Net Sales
Avg Sales
Smith
1,819.21
1,766.55
1,942.88
5,528.64
1,241.00
4,287.64
1,842.88
Brown
1,704.38
1,809.01
1,650.28
5,163.67
1,165.00
3,998.67
1,721.22
Wallace
2,009.69
2,195.19
2,159.29
6,364.17
1,650.00
4,714.17
2,121.39
Adams
1,948.44
1,725.56
1,870.26
1,345.00
7,481.72
7,496.31
7,622.71
4,199.26 17,199.7 4
1,848.09
Total
5,544.26 22,600.7 4
5,401.00
7,533.58
Exercise 7 Worldwide Sporting Goods – Customer Sales – Last Year Company
Stat us
Qtr 1
Qtr 2
Qtr 3
Qtr 4
Total
Averag e
Sports City
2
15,568
16,523
17,658
18,952
68,701
17,175
Athlete’s Dream Sports Emporium
3
21,356
22,547
24,598
23,691
92,192
23,048
1
22,571
23,681
22,698
24,995
93,945
23,486
Sports World
4
14,568
15,423
16,532
15,248
61,771
15,443
Tennis t
3
10,652
9,865
10,156
11,564
42,237
10,559
Athlete’s World
2
20,364
18,596
19,532
20,348
78,840
19,710
Page 2
Microsoft Office Excel Sportsman’s Den World of Sports
1
21,457
20,567
22,365
22,056
86,445
21,611
3
15,862
16,538
17,568
18,563
68,531
17,133
4
18,745
19,865
20,361
20,455
79,426
19,857
Total
161,143
163,605
171,468
175,872
672,088
168,022
Average
17,905
18,178
19,052
19,541
74,676
18,669
Specialty Sports
Exercise 8 Public School Name
Test 1
Test 2
Test 3
Test 4
Test 5
Test 6
Total
Averag e
Veronic a
47
75
68
49
57
67
363
60.5
Betty
59
24
67
32
59
62
321
53.5
Archie
68
75
71
49
53
64
380
63.33
Marge
59
64
28
53
57
41
302
50.33
Reggie
31
54
62
55
47
53
302
50.33
Per 61 % 54 % 63 % 50 % 50 %
Min
Max
Result
47
75
32
67
Fail
49
75
28
64
Fail
31
62
Fail
Exercise 9 Sl. No
Gend er
Age
Ethnicity
Planned major
Category
College
1
male
18
white
business
business
business
2
male
18
white
electrical engineering
engineering
engineering
3
male
19
white
biology
natural science
4
male
18
white
math
math
5
male
19
white
computer science
computer science
6
male
19
white
computer science
computer science
Page 3
arts and sciences arts and sciences arts and sciences arts and sciences
Microsoft Office Excel 7
male
20
white
graphic design
fine and performing art
arts and sciences
8
male
19
hispanic
secondary education
education
education
9
male
20
business
business
business
10
male
19
political science
social science
arts and sciences business
11 12 13 14 15 16 17 18 19 20
femal e femal e femal e femal e femal e femal e femal e femal e femal e femal e
africanamerican africanamerican
22
White
business
business
19
White
french
humanities
18
White
anthropology
social science
19
White
english
humanities
20
White
elementary education
education
education
21
White
computer science
computer science
arts and sciences
19
africanamerican
education
education
21
asian
secondary education early childhood education
education
education
19
hispanic
english
humanities
22
africanamerican
political science
social science
21
male
19
white
theatre
fine and performing art
22
male
19
hispanic
communications
humanities
arts and sciences arts and sciences arts and sciences
arts and sciences arts and sciences arts and sciences arts and sciences
Exercise 10 Wages
Inventory
Supplies
Sales
Profit
Apparel
1,000
5,000
200
7,500
1,300
Hardware
2,200
10,000
200
15,000
2,600
Toys
500
3,500
200
7,500
3,300
Furniture
1,000
300
200
7,025
5,525
Page 4
Microsoft Office Excel Electronics
2,000
9,000
200
22,000
10,800
Food
1,500
4,750
350
9,675
3,075
Totals
8,200
32,550
1,350
68,700
26,600
Exercise 11 Cards and gifts 2008 sales 1st Quarter
2nd Quarter
3rd Quarter
4th Quarter
Average
22,188
21,099
22,253
28,231
23,443
93,771
16,277
17,377
17,760
19,819
17,808
71,233
5,566
5,445
6,125
6,223
5,840
23,359
1,289
1,495
1,209
2,188
1,545
6,181
General Gifts
16,926
17,351
13,796
20,459
17,133
68,532
Seasonal Gifts
11,223
12,225
12,654
13,665
12,442
49,767
Maximum
22,188
21,099
Minimum
1,289
Average
12,245
General Cards Seasonal Cards Gift Wrap Stationery
Total
73,469
2008 Totals
22,253
28,231
23,443
93,771
1,495
1,209
2,188
1,545
6,181
12,499
12,300
15,098
13,035
52,141
74,992
73,797
90,585
78,211
312,843
Exercise 12 Acme Incorporated Sales Report Northern District
Southern District
Western District
Eastern District
Total
Sales 1
56,789
45,784
78,327
56,783
237,683
Sales 2
76,489
62,646
73,456
67,328
279,919
Sales 3
62,543
54,786
71,980
54,987
244,296
Sales 4
71,239
65,900
83,265
69,736
290,140
Page 5
Microsoft Office Excel Maximum
76,489
65,900
83,265
69,736
290,140
Minimum
56,789
45,784
71,980
54,987
237,683
Average
66,765
57,279
76,757
62,209
263,010
267,060
229,116
307,028
248,834
1,052,038
Total
Exercise 13 Eat Cake Sales Forecast Month NA NA NA NA NA NA
Quarters NA NA NA NA NA NA
Year 2005 2005 2005 2005 2005 2005
Channel Retail Partner Direct Sales Catering Internet Mall stores
Forecast 945,734 876,098 345,876 234,587 456,098 678,435
Exercise 14 Name
First Name
Genre
Income
Situation
Child
Janjuah
Bob
Man
20000
Relationship
0
Sara
Sumit
Man
80000
Married
1
Champney
Robert
Man
67000
Married
0
Jonas
Lee
Man
35000
Relationship
0
Samen
Michael
Man
77000
Single
0
Satake
Kaori
Man
70000
Married
3
Leon
Fernando
Man
23000
Single
3
Byerly
Kimberly
Woman
97000
Relationship
1
Warner
Norris
Man
26000
Divorced
3
Gaudefroy
Marie
Woman
89000
Relationship
0
Chap
Mathew
Woman
77000
Single
2
Simpson
Aubrey
Man
34000
Divorced
0
Fordyce
David
Man
61000
Relationship
2
Tortelli
Olavo
Woman
27000
Single
0
Page 6
Microsoft Office Excel Adcock
David
Woman
72000
Divorced
3
Contat
Thibault
Man
85000
Relationship
1
Zizzari
Stephen
Woman
84000
Single
3
Freyer
Jean-Luc
Man
50000
Single
2
Jones
David
Man
31000
Single
0
Exercise 15 Weekly Time Card Summary for Hourly Employees Employee ID
Last Name
First Name
Total Hours
Hourly Pay
Total Pay
1848
Gul
Doug
8
8.55
68.40
1863
Guzik
Sue
4
9.55
38.20
1878
Madi
Chris
6
10.00
60.00
1913
Haf
Richard
7
11.25
78.75
2156
Bolte
Ellen
8
11.00
88.00
3788
Miller
Cindy
8
15.00
120.00
4110
Miller
Jan
6
13.25
79.50
4564
Butler
Teresa
9
12.50
112.50
4793
Abels
Ginger
5
11.50
57.50
5078
Causey
Tim
4
9.50
38.00
5106
Chambers
Julie
6
20.00
120.00
5128
Chambers
Les
8
16.00
128.00
5145
Abell
Bruce
8
14.00
112.00
5714
Miller
Kevin
10
13.00
130.00
6566
Miller
Rudeana
8
9.25
74.00
6569
Eads
Linda
6
10.25
61.50
7708
Russell
Susan
4
11.75
47.00
Exercise 16 Page 7
Microsoft Office Excel Month
Sales Rep
Region
s
Sales
Annualized
Jan
Bob
North
58
283,800
3,689,400
Jan
Frank
North
35
507,200
6,086,400
Jan
Paul
South
25
107,600
1,291,200
Jan
Randy
South
47
391,600
4,699,200
Jan
Mary
South
39
226,700
2,720,400
Feb
Bob
North
44
558,400
6,700,800
Feb
Jill
North
46
350,400
4,204,800
Feb
Frank
North
74
411,800
4,941,600
Feb
Paul
South
29
154,200
1,850,400
Feb
Randy
South
45
258,000
3,096,000
Feb
Mary
South
52
233,800
2,805,600
Mar
Bob
North
30
353,100
4,237,200
Mar
Jill
North
44
532,100
6,385,200
Mar
Frank
North
57
258,400
3,100,800
Mar
Paul
South
13
286,000
3,432,000
Mar
Randy
South
14
162,200
1,946,400
Exercise 17 Year
198 0 198 1 198 2 198 3 198 4
Temp (avg)
Temp (max)
Temp (min)
# of Readings
Rainfall (in)
28
32
10
100
110
Tropical
George
25
37
-5
100
2
Desert
Jim
-3
10
-32
100
4
Arctic
Janet
18
28
-15
100
56
Temperat Mike e
25
38
13
100
98
Tropical
Page 8
Climate
Observer
Bill
Microsoft Office Excel 198 5 198 6 198 7 198 8 198 9 199 0 199 1 199 2 199 3 199 4 199 5 199 6 199 7 199 8 199 9 200 0 200 1 200 2 200 3
28
32
10
100
110
Tropical
Bill
25
37
-5
100
2
Desert
Bill
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat Janet e
25
38
13
100
98
Tropical
Bill
28
32
10
100
110
Tropical
Janet
25
37
-5
100
2
Desert
Jim
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat George e
25
38
13
100
98
Tropical
George
28
32
10
100
110
Tropical
Bill
25
38
13
100
98
Tropical
Janet
28
32
10
100
110
Tropical
Bill
25
37
-5
100
2
Desert
Bill
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat Janet e
25
38
13
100
98
Tropical
Bill
28
32
10
100
110
Tropical
Janet
25
37
-5
100
2
Desert
Jim
Page 9
Microsoft Office Excel 200 4 200 5 200 6
-3
10
-32
100
4
Arctic
Jim
18
28
-15
100
56
Temperat George e
25
38
13
100
98
Tropical
George
Exercise 18 Eastern 1992 Quarters 1
Quarters 2
Quarters 3
Quarters 4
Golf
5,000
2,000
1,500
2,000
Safari
9,000
6,000
4,000
5,000
Tennis
1,500
500
600
1,500
15,500
8,500
6,100
8,500
Quarters 1
Quarters 2
Quarters 3
Quarters 4
Windsurfing
1,800
5,000
6,500
1,750
Golf
3,500
2,500
6,430
4,590
Tennis
6,000
3,200
4,070
5,000
11,300
10,700
17,000
11,340
Quarters 1
Quarters 2
Quarters 3
Quarters 4
5,500
1,500
1,400
2,500
Safari
10,000
6,500
4,400
4,500
Tennis
1,000
800
550
1,000
16,500
8,800
6,350
8,000
Total Sales
Western 1992
Total Sales
Eastern 1993 Golf
Total Sales
Page 10
Microsoft Office Excel Western 1993 Quarters 1
Quarters 2
Quarters 3
Quarters 4
Windsurfing
1,850
4,000
5,500
1,550
Golf
1,500
2,500
4,075
2,500
Tennis
6,500
2,000
4,590
5,055
Total Sales
9,850
8,500
14,165
9,105
53,150
36,500
43,615
36,945
Grand Total Sales
Exercise 19 Item Category Flour
Item Type
Item#
Pastry
4
Current Cost 7
Flour
Whole Wheat
5
Flour
WW Pastry
Flour
Inventory
Final Cost
2
14
4.2
3
12.6
14
7
7
49
Whole Wheat
15
4.2
4
16.8
Flour
Pastry
24
7
5
35
Icing
Butter cream
6
1.75
3
5.25
Icing
Royal
7
2.25
5
11.25
Icing
Fondant
8
3.5
4
14
16
1.75
15
26.25
17
2.25
8
18
Icing
Blue Butter cream Blue Royal
Icing
Blue Fondant
18
3.5
6
21
Mix
Chocolate
1
5.25
4
21
Mix
Vanilla
2
3
1
3
Mix
Marble
3
4.25
2
8.5
Icing
Page 11
Microsoft Office Excel Mix
Dutch Chocolate Royal Vanilla
Mix
Pound
Mix
11
7.25
3
21.75
12
4
15
60
13
5.25
11
57.75
21
6.25
10
62.5
22
4
13
52
Mix
French Chocolate French Vanilla
Mix
Marble
23
5.25
2
10.5
Sprinkles
Sugar
9
1.05
22
23.1
Sprinkles
Sugar Free
19
1.05
16
16.8
Toppings
Sugar
10
1.3
19
24.7
Toppings
Sugar Free
20
1.3
4
5.2
Mix
Exercise 20
50
Sun/Oct/0 5 1000
Mon/Oct/0 5 1
-10
Wed/Oct/0 5 65
Thu/Oct/0 5 3
250
51
999
7
-15
66
9
400
52
998
13
-20
67
15
550
53
997
19
-25
68
21
700
54
996
25
-30
69
27
850
55
995
31
-35
70
33
1000
56
994
37
-40
71
39
1150
57
993
43
-45
72
45
1300
58
992
49
-50
73
51
1450
59
991
55
-55
74
57
1600
60
990
61
-60
75
63
1750
61
989
67
-65
76
69
Fri/Oct/05
Sat/Oct/05
100
Page 12
Tue/Oct/05
Microsoft Office Excel 1900
62
988
73
-70
77
75
2050
63
987
79
-75
78
81
2200
64
986
85
-80
79
87
2350
65
985
91
-85
80
93
2500
66
984
97
-90
81
99
2650
67
983
103
-95
82
105
2800
68
982
109
-100
83
111
2950
69
981
115
-105
84
117
3100
70
980
121
-110
85
123
3250
71
979
127
-115
86
129
3400
72
978
133
-120
87
135
3550
73
977
139
-125
88
141
3700
74
976
145
-130
89
147
Exercise 21 ission No.
Last Name
First Name
Exam 1
Exam 2
Exam 3
Total
000606
Altiveros
Melissa
75
72
66
213
000943
Colburn
Mary
92
95
91
278
000983
Davis
Michael
44
52
73
169
001326
Davis
Kelly
93
92
86
271
001572
Douglas
Theresa
88
74
69
231
002563
Dwyer
Helen
92
91
88
271
002637
Gott
Michelle
90
77
85
252
002679
Hardy
Russell
78
76
79
233
002773
Hobson
Jen
98
92
92
282
002779
Holt
Nicholas
91
89
83
263
Page 13
Microsoft Office Excel 002981
Jackson
Scott
95
95
91
281
003789
Jackson
Kenneth
73
57
68
198
003874
Lopez
Elaine
65
78
71
214
004662
Meese
Erin
82
75
72
229
004875
Mittelstadt
Stephanie
72
75
80
227
004919
Oestreich
Jennifer
71
55
76
202
009690
Steele
Kylie
91
72
80
243
009873
Williamson
Linda
76
69
75
220
Exercise 22 PF Statement for the month of July Sl. No .
Particulars
Basic
1
H.R. &
50000
2
Security
30000
3
s
5000
4
Maintenanc e
3000
5
Drivers
6000
6
Bouncer
3250
7
F&B Service
3500
VDA
HRA
CON V
Medic al
Wash Allowan ce
Special Allowanc e
Othe rs
Total
100 1 100 1 100 1 100 1 100 1 100 1 100 1
2000 0
800
1250
600
26349
0
10000 0
0
800
1250
0
26949
0
60000
2000
800
0
600
599
0
10000
400
0
0
600
999
0
6000
2150
800
1250
0
799
0
12000
600
250
0
600
799
0
6500
600
500
0
600
799
0
7000
Page 14
Microsoft Office Excel 8 9 10 11
Front Office F&B Production House Keeping Kitchen Stewarding
12
4250 7500 3250 3250
Trainee
2450
Grand Total
12145 0
100 1 100 1 100 1 100 1 100 1 120 12
800
600
0
600
1249
0
8500
2600
800
1250
0
1849
0
15000
600
250
0
600
799
0
6500
600
250
0
600
799
0
6500
400
0
0
600
1049
0
5500
3075 0
5850
5000
5400
63038
0
24350 0
Exercise 23
Jan Switch plates Tin Ceilings Door Plates
Feb
Iron Works Source of Income First six months Mar Apr
May
Jun
Total
236
583
453
284
1,294
788
3,638
17,894
17,012
12,894
12,884
15,623
17,433
93,740
478,003
593,221
488,534
589,322
499,322
523,855
187,945
198,422
201,123
293,844
198,843
200,019
18,956
19,842
17,363
18,764
19,846
17,883
112,654
38,953
39,847
37,855
39,009
38,755
37,129
231,548
1,930,0 55
2,847,73 3
1,895,32 2
1,984,47 2
1,758,33 2
1,846,73 4
12,262,6 48
Minimum
1,930,0 55 236
2,847,73 3 583
1,895,32 2 453
1,984,47 2 284
1,758,33 2 1,294
1,846,73 4 788
Average
381,720
530,951
379,078
419,797
361,716
377,692
2,672,0 42
3,716,66 0
2,653,54 4
2,938,57 9
2,532,01 5
2,643,84 1
12,262,6 48 3,638 2,450,95 4 17,156,6 81
Lock Sets Cabinet Knobs Drawer Pulls Bathroom Hardware Maximum
Total
Page 15
3,172,25 7 1,280,19 6
Microsoft Office Excel Exercise 24 ABC Limited For the period of 2000 - 2002 REVENUE
2000
2001
2002
Gross Sales
70000
75000
90000
Sales Returns
20000
23000
28000
50000
52000
62000
2000
2001
2002
Beginning Inventory
35000
36000
42000
Goods Purchased
12000
16500
18500
47000
52500
60500
3600
4200
4350
43400
48300
56150
6600
3700
5850
2000
2001
2002
6200
7300
4600
4450
5275
6000
10650
12575
10600
NET SALES COST OF SALES
Total Goods Available Ending Inventory Total cost of Goods Consumed Gross Profit OPERATING EXPENSES Selling General/istrat ive Total Operating Expenses Income before Taxes Taxes on Income
-4050
-8875
-4750
-1822.5
-3993.75
-2137.5
Net Profit
-2227.5
-4881.25
-2612.5
Note : net sales = gross sales – sales return Page 16
Microsoft Office Excel Total cost of goods consumed = Total Goods Available - Ending Inventory Gross profit = net sales - Total cost of goods consumed Total Operating Expenses = selling + General/istrative Income before taxes = gross profit - Total Operating Expenses Taxes on income = 0.45 * Income before Taxes Net profit = Income before Taxes - Taxes on Income
Exercise 25 ID
Last Name
First Name
Department
Extension
1
Burmeister
Allen
Development
5325
2
Cole
Francis
Publications
5277
3
Conrad
John
Customer
5424
4
Dixon
Colleen
Human Resources
5387
5
Elphin
Brenda
Publications
5298
6
Franklin
Benito
Sales & Marketing
5701
7
Griffith
Susan
Human Resources
5321
8
Henry
Kurt
Shipping
5167
9
Hirsch
Alexa
Human Resources
5345
10
Kaplan
Dan
ing
5598
11
Kapur
Madeline
ing
5500
12
Lao
Tony
Publications
5211
13
Lindquist
Donald
Sales & Marketing
5727
14
Mercer
Ernest
Development
5333
15
Murphy
Franklin
Development
5676
16
Spencer
Felicity
Publications
5209
Page 17
Microsoft Office Excel 17
Stephens
Maryanne
Sales & Marketing
5763
18
Tai
Anna
Development
5301
19
Thomas
George
Shipping
5189
20
Tran
Margaret
ing
5571
Exercise 26 Name
State
City
Product
Quantity
Mitron
California
San Jose
CD-ROM
64
Unit Price 0.25
Smith
California
Los Angeles
CD-ROM
152
0.25
38
282
25.3
7134.6
292
0.55
160.6
Garcia Yokuchi
Massachus etts Texas
Total 16
Dallas
Smart Card DVD-ROM
Boston
DVD-ROM
336
0.55
184.8
Boston
DVD-ROM
304
0.55
167.2
Dallas
Keyboard
331
7.5
Boston
Charlton
Massachus etts Massachus etts Texas
Yokuchi
Texas
Dallas
CD-ROM
385
0.25
Yang
Nevada
Las Vegas
Cle USB
285
12.45
Yang
Nevada
Las Vegas
Hard drive
164
75
Charlton
Texas
Dallas
DVD-ROM
344
0.55
189.2
Yang
Nevada
Las Vegas
CD-ROM
53
0.25
13.25
Smith
California
CD-ROM
283
0.25
70.75
Charlton
Texas
Los Angeles Dallas
DVD-ROM
313
0.55
172.15
Julian
Texas
Houston
DVD-ROM
397
0.55
218.35
Charlton
Texas
Dallas
USB
488
12.45
6075.6
Charlton
Texas
Dallas
Smart Card
181
25.3
4579.3
Garcia Garcia
Page 18
2482.5 96.25 3548.25 12300
Microsoft Office Excel Charlton
Texas
Dallas
USB
460
12.45
5727
Yang
Nevada
Las Vegas
Hard drive
90
75
6750
Brown
California
San Francisco
Printer
260
54
14040
Springfield DVD-ROM
286
0.55
157.3
San Jose
DVD-ROM
254
0.55
139.7
Boston
Printer
398
54
Springfield
Smart Card
185
25.3
Springfield Hard drive
15
75
1125
Houston
228
54
12312
284
25.3
472
75
35400 397.5
Boulard Mitron
Massachus etts California
Julian
Massachus etts Massachus etts Massachus etts Texas
Mitron
California
San Jose
Yang
Nevada
Las Vegas
Smart Card Hard drive
Charlton
Texas
Dallas
Keyboard
53
7.5
Yokuchi
Texas
Dallas
Smart Card
372
25.3
Boulard
Massachus etts
Springfield Keyboard
490
7.5
Smith
California
Los Angeles
CD-ROM
1000
0.25
Boston
Printer
500
54
27000
Houston
Printer
374
54
20196
Springfield Keyboard
285
7.5
2137.5
Las Vegas
Printer
376
54
20304
Las Vegas
CD-ROM
25
0.25
Boston
Printer
471
54
25434
San Jose
Printer
366
54
19764
San Jose
Smart Card
365
25.3
Garcia Boulard Boulard
Garcia Julian
Massachus etts Texas
Yang
Massachus etts Nevada
Yang
Nevada
Boulard
Mitron
Massachus etts California
Mitron
California
Garcia
Printer
Page 19
21492 4680.5
7185.2
9411.6 3675 250
6.25
9234.5
Microsoft Office Excel Exercise 27 A to Z Office Supplies Quarterly Sales 2003 Sales Person
Qtr1
Qtr2
Qtr3
Qtr4
Total
Nichols, Todd
1,200
423
521
625
2,769
Green, Cheryl
654
634
326
754
2,368
Finley, Robert
2,567
2,390
3,005
2,389
10,351
Jenkins, Jerry
233
532
525
652
1,942
Franklin, William
354
633
422
255
1,664
Soderman, Pamela
255
525
252
624
1,656
422
642
642
624
2,330
854
364
474
743
2,435
Williams, Walter
2,234
2,567
2,987
2,546
10,334
Coombs, Dallas
356
634
632
743
2,365
Maximum
2,567
2,567
3,005
2,546
10,351
Minimum
233
364
252
255
1,656
Average
913
934
979
996
3,821
9,129
9,344
9,786
9,955
38,214
Carpenter, Candace Sutherland, Patricia
Total
Page 20
Total
December
November
October
September
August
July
June
May
April
March
February
January
Exercise 28
Microsoft Office Excel Income Fixed expends Variables expends Amount of expends Result
150 0
100 0
100 0
180 0
270 0
270 0
330 0
3630
231 0
1732 .5
120 0
138 0
750
750
750
750
750
750
750
750
750
750
750
750
600
500
500
211 6 286 6
160 0 235 0
110
434
139 0 190
132 6
350
2433 .4 3183 .4 446. 6
576
125 0 250
184 0 259 0
640
125 0 250
160 0 235 0
540
135 0
150 0 225 0 450
24,252. 50 9,000.0 0 14,445. 40 23,445. 40
54
807.10
150
-40
1290 442. 5
Note: result = income – amount of expends
Exercise 29 Downtown Internet Café February
March
April
May
June
July
August
r Septembe
October
November
December
1330 0
1360 0
1420 0
1440 0
1520 0
1550 0
1560 0
1570 0
1580 0
1620 0
1680 0
1710 0
580 0 360 0 100 0
600 0 380 0 110 0
620 0 380 0 110 0
620 0 360 0 150 0
620 0 380 0 150 0
620 0 380 0 150 0
645 0 500 0 210 0
650 0 510 0 220 0
650 0 520 0 220 0
670 0 580 0 230 0
690 0 625 0 240 0
Computer
400
400
400
600
600
800
775
800
800
900
950
1000
8425
Total Sales
2410 0
2490 0
2570 0
2630 0
2730 0
2780 0
2992 5
3030 0
3050 0
3190 0
3330 0
3400 0
34602 5
722
748
769
762
794
801
883
893
902
954
1002 0
1021 5
10253 5
Sales Espresso Drip Cofee Food/Bevera ges Merchandise
7000 6400 2500
Total
January
Annual Forecast
18340 0
7665 0 5615 0 2140 0
Expenses Cost of
Page 21
Microsoft Office Excel Goods
5
0
0
0
0
5
5
5
0
0
Cost of Merchandise
700
770
770 900 0
105 0 786 0
105 0 839 0
105 0 874 0
147 0 900 0
154 0 900 0
154 0 900 0
161 0 950 0
168 0 980 0
Payroll
900 0
900 0
Internet
325
325
325
325
325
325
325
325
325
325
Building
210 0
210 0
210 0
210 0
210 0
210 0
210 0
210 0
210 0
Advertising
600
600
600
600
600
600
600
600
Capital Assets Miscellaneou s Total Expenses
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
2275 0
2307 5
2328 5
2235 5
2320 5
2363 0
1,35 0
1,82 5
2,41 5
3,94 5
4,09 5
5.60 %
7.33 %
9.40 %
15%
15%
Net Income Profit Margin
1020 0
1498 0 1084 90
325
325
3900
210 0
210 0
2100
2520 0
600
600
600
600
7200
150 0 130 0
150 0 130 0
150 0 130 0
150 0 130 0
2513 0
2530 0
2538 5
2647 5
2732 5
2799 0
29590 5
4,17 0
4,79 5
5,00 0
5,11 5
5,42 5
5,97 5
6,01 0
50,12 0
15%
16%
16%
16%
17%
17%
17%
1750
1500 1300
1800 0 1560 0
16%
Note: Net Income = Total Sales – Total Expenses Profit Margin = Net Income / Net Sales
Exercise 30 Save Sable River Foundation Lifetime Fundraising Summary
Corporate
Allentow n 74,029.3 5
Chamber City 92,278.21
Catonsvil le 63,081.7 4
Page 22
Sable Village 84,210.02
Strongsv ille 61,644.2 6
Town of Cary 89,820.5 1
Total 465,064.0 9
Microsoft Office Excel Direct Mail Fun Runs Governmen t Phone-athon
Maximum Minimum Average Total
67,286.0 6 54,704.3 9 30,623.9 9 16,692.1 4 74,029.3 5 16,692.1 4 48,667.1 9 243,335 .93
83,867.23 66,934.67 58,614.35
55,076.4 8 64,581.6 6 51,486.4 6
55,547.28 28,895.86 36,387.09
24,223.81
9,492.91
17,328.74
92,278.21
64,581.6 6
84,210.02
24,223.81
9,492.91
17,328.74
65,183.65 325,918. 27
48,743.8 5 243,719 .25
44,473.80 222,368. 99
79,779.0 2 32,690.3 7 51,642.5 5 12,305.8 5
84,366.1 9 64,242.7 2 40,177.8 7 21,097.6 0
425,922.2 6 312,049.6 7 268,932.3 1 101,141.0 5
79,779.0 2 12,305.8 5 47,612.4 1 238,062 .05
89,820.5 1 21,097.6 0 59,940.9 8 299,704 .89
465,064.0 9 101,141.0 5 314,621.8 8 1,573,10 9.38
Exercise 31 Adventure Travels 1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
Total
Car Rentals
124,650
124,875
126,500
129,145
505,170
Airlines
225,000
226,902
229,995
235,390
917,287
1,125,530
1,350,655
1,500,675
1,755,850
5,732,710
2,236,480
2,567,892
2,756,215
3,125,689
10,686,276
550,000
550,545
595,655
605,115
2,301,315
Maximum
2,236,480
2,567,892
2,756,215
3,125,689
10,686,276
Minimum
124,650
124,875
126,500
129,145
505,170
Average
852,332
964,174
1,041,808
1,170,238
4,028,552
4,261,660
4,820,869
5,209,040
5,851,189
20,142,758
Tour Packages Cruise Packages Hotels
Total
Exercise 32 Page 23
Microsoft Office Excel Employe e ID
Last Name
First Name
Address
00212
Schif
Chad
235 N. Cactus Dr.
00617
Nichols
Cathy
75 Brooklea Dr.
Chesterfiel d Landis
Mark
23 Mill Ave.
Dan
564 S. Lemon Dr.
03225
Penningt on Morgan
03406
Lopez
Mina
03890
Thi
Erona
04321
Sabin
Greg
04731
Marchant
Roberta
05015
Briggs
Scott
00907
4290 E. Alameda Dr. 7867 Forest Ave. 90 E. Rawhide Ave. 564 Palm Avenue
City
State
ZIP Code
CA
92122
CA
92120
Landis
ca
92120
Maldin
CA
92121
Maldin
CA
92121-3740
River Mist
CA
92123
CA
92122
CA
92120
River Mist
Ca
92123-2232
Maldin
CA
92121
Maldin
CA
92121-3740
CA
92122-1268
CA
92121-3740
Chesterfiel d Landis
Anita
45 E. Camelback Rd. 832 S. William Ave. 2348 S. Bala Dr.
Ruiz
Enrique
35 Palm St.
11747
Lettow
Ryan
358 Maple Dr.
Chesterfiel d Maldin
12194
Polonsky
Mitch
8701 E. Sheridan
Maldin
CA
92121-3740
12213
Young
Kim
89 College Ave.
Landis
CA
92120
12230
Reddie
Suzanne
932 E. Parkway Dr.
Landis
CA
92120
12247
Rath
Kathy
87 E. Aurora Ave.
CA
92122-1268
12258
Delano
Gordon
CA
92122-1268
12366
Stacey
David
CA
92122-1268
07287
Robertso n Roman
08391
06000
12389 12501
Blackma n DeLuca
Kirk
1310 N. Sprindrift Dr. 737 S. College Rd.
Chesterfiel d Chesterfiel d Chesterfiel d
Jennifer
773 E. Laurel St.
River Mist
CA
92123-2232
Elizabeth
21 W. Southern
Landis
CA
92120
Page 24
Microsoft Office Excel Ave. 12583
Sullivan
Marie
12594
Reddie
Mark
12612
Lettow
Melissa
12655
Lahti
Jill
78 Omega Drive 900 W. Campus Dr. 234 N. 1st St. 5401 E. Thomas Rd.
Chesterfiel d
CA
92122-1268
Maldin
CA
92121
River Mist
CA
92123
Landis
CA
92120
Exercise 33
New Car Sales January
February
March
Total Sales
Alfred
68,560
87,657
67,865
224,082
Antonie
74,768
100,234
95,465
270,467
Bass
87,546
98,555
83,655
269,756
100,765
123,543
34,999
259,307
Bunnis
88,765
100,876
98,655
288,296
Cherisma
35,000
65,987
56,787
157,774
Delva
67,980
87,657
56,766
212,403
Dixon
82,987
102,675
45,673
231,335
Dearborn
98,765
132,987
105,467
337,219
Fleuridor
76,546
126,547
101,675
304,768
Heydt
65,785
87,657
67,865
221,307
Hinton
65,754
100,234
95,465
261,453
King
98,673
98,555
83,655
280,883
104,654
123,543
92,876
321,073
88,765
100,876
98,655
288,296
Bradley
Lamons Nudelman
Page 25
Microsoft Office Excel Sun
45,676
65,987
65,478
177,141
Tullos
98,765
87,657
98,675
285,097
Washington
82,987
67,876
34,765
185,628
Zappa
98,765
89,654
87,678
276,097
Zelaya
76,546
99,765
99,678
275,989
Maximum
104,654
132,987
105,467
337,219
Minimum
35,000
65,987
34,765
157,774
Average
80,403
97,426
78,590
256,419
1,608,052
1,948,522
1,571,797
5,128,371
Total
Exercise 34 Animal Angels Volunteers 1st Qtr
2nd Qtr
3rd Qtr
4th Qtr
Average
Total
45
34
102
35
54
216
106
45
55
106
78
312
Carver, Kathi
30
83
3
3
29.75
119
Chorley, Besty
68
2
235
96
100.25
401
Clark, Jamel
51
30
28
58
41.75
167
Cody, Martin
28
66
6
45
36.25
145
Dickson, Diane
72
19
77
32
50
200
Edwards, Mike
12
20
61
28
30.25
121
Ferguson, Robby
99
12
0
43
38.5
154
32
66
34
30
40.5
162
57
98
93
80
82
328
13
25
55
100
48.25
193
Bell, Patricia Carey, Ronnie
Forester, Kimberly Franklin, Stacey Fulton, Anne
Page 26
Microsoft Office Excel Garcia, Maria
5
23
61
36
31.25
125
Gatens, Chris
0
100
58
85
60.75
243
Henderson, James
9
76
51
60
49
196
Ingram, Helen
29
12
33
12
21.5
86
Isbell, Sonya
46
65
47
3
40.25
161
5
25
18
7
13.75
55
Jones, April
70
83
38
79
67.5
270
Kelly, William
13
78
52
88
57.75
231
4
59
57
8
32
128
Kullman, Rodney
28
30
35
16
27.25
109
La Paglia, Sally
39
10
12
134
48.75
195
Lee, Su
56
6
5
0
16.75
67
Legge, Cristan
3
81
73
34
47.75
191
Lopez, Andrew
83
3
165
0
62.75
251
Marcus, Danielle
3
19
24
2
12
48
Merwin, Michael
44
9
95
37
46.25
185
Nelson, Faith
10
115
8
0
33.25
133
Johnson, Thaman
Kettonhoefer, Bill
Exercise 35 Last Name
First Name
Address
City
3333
Arteaga
Ella
58 Langley Avenue
2222
Barringt on
Cindy
7777
Bruner
5555 6666
ID
Stat e
Zip Code
Aurora
NC
28307
271 Latrell Road
Baltimore
NC
28306
Myra
182 Birchwood Street
Refugio
NC
28305
Caruso
Jill
524 Ridge Road
Spring Lake
NC
28390
Charlton
Kara
52 Hiroko Street
Spring Lake
NC
28390
Page 27
Phone (910) 4134728 (910) 4284137 (910) 3315052 (910) 4209063 (910) 3844911
Microsoft Office Excel 1234
Getty
William
1111
Givens
Bryan
4444
Haller
Geneva
9999
Keane
Vickie
8888
Mai
Tony
81 Columbus Road 72 White Eagle Street 985 Lisa Street 47 Carolyn Avenue 732 Oregon Street
Buena Vista
NC
28304
Fayetteville
NC
28301
Spring Lake
NC
28390
Middleton
NC
28309
Madison
NC
28302
(910) 4754153 (910) 4565660 (910) 3573062 (910) 4737752 (910) 3509309
Exercise 36 Type of Transaction Category
Qtr.
Description of Transaction Starting Balance Mr. G's
Withdrawal
Debit Card
Grocery
1
Check
Mortgage
1
Debit Card
Grocery
1
Faceless Mortgage Corp
Electric
1
Mr. G's
Credit Card
1
ERG/Synergy
Grocery
1
Power Bank
ATM
1
Mr. G's
92.64
Cell Phone
1
Cash
68.64
Cable
1
Busy signal Phone Co
30.00
ATM
1
Costly Cable Co
70.00
ATM
ATM
1
Cash
115.35
Debit Card
Grocery
1
Cash
28.72
Water
1
Wings' R Us
100.00
ATM
1
City Utilities
39.63
Electric
1
Cash
Automatic Withdrawal Automatic Withdrawal Debit Card ATM Automatic Withdrawal Automatic Withdrawal ATM
Automatic Withdrawal ATM Automatic
Page 28
1,280.00 114.42 37.09 350.00 71.14 100.00
112.59
Microsoft Office Excel Withdrawal Automatic Withdrawal Debit Card
Gas
1
ERG/Synergy
Grocery
1
Nat's Gas Service
Direct Deposit
Paycheck
1
Mr. G's
ATM
ATM
1
Direct deposited
Check
Mortgage
1
Cash
Credit Card
1
ATM
1
Faceless Mortgage Corp Power Bank
Cell Phone
1
Cash
ATM
1
Busy signal Phone Co
Cable
1
Cash
80.00
Grocery
1
Costly Cable Co
70.00
ATM
ATM
1
Mr. G's
ATM
ATM
1
Cash
1,280.00
Debit Card
Grocery
1
Cash
114.42
Check
Mortgage
1
Starting Balance
Automatic Withdrawal ATM Automatic Withdrawal ATM Automatic Withdrawal Debit Card
178.49 50.00 1,280.00 350.00 40.00 93.76 100.00 68.64 300.43
158.18
37.09
Exercise 37 Region
Rep
Item
Units
East
Jones
Pencil
95
1.99
189.05
Central
Kivell
Binder
50
19.99
999.50
Central
Jardine
Pencil
36
4.99
179.64
Central
Gill
Pen
27
19.99
539.73
West
Sorvino
Pencil
56
2.99
167.44
East
Jones
Binder
60
4.99
299.40
Central
Andrews
Pencil
75
1.99
149.25
Page 29
Unit Cost
Total
Microsoft Office Excel Central
Jardine
Pencil
90
4.99
449.10
West
Thompson
Pencil
32
1.99
63.68
East
Jones
Binder
60
8.99
539.40
Central
Morgan
Pencil
90
4.99
449.10
East
Howard
Binder
29
1.99
57.71
East
Parent
Binder
81
19.99
East
Jones
Pencil
35
4.99
174.65
Central
Smith
Desk
2
125.00
250.00
East
Jones
Pen Set
16
15.99
255.84
Central
Morgan
Binder
28
8.99
251.72
East
Jones
Pen
64
8.99
575.36
East
Parent
Pen
15
19.99
299.85
Central
Kivell
Pen Set
96
4.99
479.04
Central
Smith
Pencil
67
1.29
86.43
East
Parent
Pen Set
74
15.99
Central
Gill
Binder
46
8.99
Central
Smith
Binder
87
15.00
East
Jones
Binder
4
4.99
West
Sorvino
Binder
7
19.99
139.93
Central
Jardine
Pen Set
50
4.99
249.50
Central
Andrews
Pencil
66
1.99
131.34
East
Howard
Pen
96
4.99
479.04
Central
Gill
Pencil
53
1.29
68.37
Central
Gill
Binder
80
8.99
719.20
Central
Kivell
Desk
5
125.00
625.00
East
Jones
Pen Set
62
4.99
309.38
Central
Morgan
Pen Set
55
12.49
686.95
Page 30
1,619.19
1,183.26 413.54 1,305.00 19.96
Microsoft Office Excel Central
Kivell
Pen Set
42
23.95
1,005.90
West
Sorvino
Desk
3
275.00
Central
Gill
Pencil
7
1.29
9.03
West
Sorvino
Pen
76
1.99
151.24
West
Thompson
Binder
57
19.99
Central
Andrews
Pencil
14
1.29
18.06
Central
Jardine
Binder
11
4.99
54.89
Central
Jardine
Binder
94
19.99
Central
Andrews
Binder
28
4.99
825.00
1,139.43
1,879.06 139.72
Exercise 38 Aficionado Guitar Parts Monthly s Receivable Balance Report Customer
Beginn ing Balanc e
Credits
Payments
Purchase s
Service Charge
New Balance
Cervantes, Katriel
803.01
56.92
277.02
207.94
12.90
689.91
285.05
87.41
182.11
218.22
0.43
234.18
702.13
79.33
180.09
364.02
12.17
818.90
438.37
60.90
331.10
190.39
1.28
238.04
378.81
48.55
126.15
211.38
5.61
421.10
Raglow, Dora
710.99
55.62
231.37
274.71
11.66
710.37
Tuan, Lin
482.74
85.01
129.67
332.89
7.37
608.32
Totals
3,801. 10
473.74
1,457.51
1,799.55
51.42
3,720.82
Maximum
803.01
87.41
331.10
364.02
12.90
818.90
Cummings, Trenton Danielsson, Oliver Kalinowski, Jadwiga Lanctot, Royce
Page 31
Microsoft Office Excel Minimum
285.05
48.55
126.15
190.39
0.43
234.18
Average
543.01
67.68
208.22
257.08
7.35
531.55
Note: service charge = 2.75% * ( beginning balance – credits – payments – purchases ) New balance = beginning balance + credits + payments + purchases + service charges
Exercise 39
TYH-1MN3
Product Number 1123
TUP-2MN4
1456
98 %
4950
4876
TYH-1MN3
1356
99 %
3780
3769
TUP-2MN4
1487
99 %
4950
4777
NVB-9MN1
1876
96 %
4900
4435
TYH-1MN3
1001
90 %
5000
4570
TYH-1MN3
1100
91 %
4500
4641
Product Name
98 %
Input Quantity 5000
Output Quantity 4905
Yield
Exercise 40 Transaction
Category
Check 201
Mortgage
Debit Card
Grocery
Faceless Mortgage Corp Mr. G's
Electric
ERG/Synergy
Credit Card
Largo Credit Corp
Grocery
Mr. G's
ATM
ATM
Cash
Automatic Withdrawal
Cell Phone
Busy signal Phone Co
Automatic Withdrawal Automatic Withdrawal Debit Card
Description
Page 32
Withdrawal 780 114.42 37.09 150 71.14 100 42.64
Microsoft Office Excel Automatic Withdrawal ATM
Cable
Costly Cable Co
ATM
Cash
30
ATM
ATM
Cash
70
Credit Card
Grocery
Wings' R Us
115.35
Water
City Utilities
28.72
ATM
Cash
Electric
ERG/Synergy
Gas
Nat's Gas Service
112.59
Grocery
Mr. G's
178.49
ATM
ATM
Cash
Check 202
Mortgage
Faceless Mortgage Corp
780
Credit Card
Largo Credit Corp
150
ATM
Cash
Automatic Withdrawal ATM Automatic Withdrawal Automatic Withdrawal Debit Card
28.64
100 39.63
50
Direct Deposit Automatic Withdrawal ATM Automatic Withdrawal ATM Automatic Withdrawal Check 190
ATM
Busy signal Phone Co Cash
Cable
Costly Cable Co
Cell Phone
40 43.76 100 28.64
Void
ATM
ATM
Cash
80
ATM
ATM
Cash
70
Water
City Utilities
28.72
Electric
ERG/Synergy
39.45
Gas
Nat's Gas Service
Automatic Withdrawal Automatic Withdrawal Automatic Withdrawal
Page 33
120.77
Microsoft Office Excel ATM
ATM
Cash
Check 203
Mortgage
Faceless Mortgage Corp
80 780
Direct Deposit ATM
ATM
Cash
Credit Card
Grocery
Mr. G's
169.84
Debit Card
Grocery
Mr. G's
44.08
Credit Card
Largo Credit Corp
ATM
Cash
Cable
Costly Cable Co
Automatic Withdrawal ATM Automatic Withdrawal Automatic Withdrawal Debit Card Automatic Withdrawal Debit Card Automatic Withdrawal Debit Card Automatic Withdrawal
150 90 28.64
Grocery
Busy signal Phone Co Mr. G's
ATM
Cash
Water
City Utilities
28.72
Grocery
Mr. G's
81.79
Electric
ERG/Synergy
35.52
Grocery
Mr. G's
94.59
Gas
Nat's Gas Service
73.87
Cell Phone
ATM
70
50.74 131.51 30
Direct Deposit Check 204
Mortgage
Debit Card
Grocery
Faceless Mortgage Corp Mr. G's
780 133.64
Exercise 41 Application # 000123
First Name
Last Name
Address
City
Marilyn
Foster
505 Lincoln Ave.
Brentwood
Page 34
Microsoft Office Excel 000125
Mikhail
Siederhof
17 Spyglass Cir.
Oceanview
000138
Yvonne
Brady
301 Canoe Ave.
Palmdale
000139
Adelle
Cavenough
999 Seaspray Dr.
Palmdale
000146
Olef
Borisnov
403 Skif Cir.
Brentwood
000147
Lenny
Brewster
2100 Palm St.
Lexington
000150
Carolyn
Welsh
186 Alameda St.
Brentwood
000158
Danielle
Nash
725 Waterway Ln.
Oceanview
000167
Yong
Wu
326 Rockwell St.
Oceanview
000173
Jessica
Clegg
532 A St.
Palmdale
000177
Christopher
Finkle
323 Lorry Ave.
Lexington
000180
Paul
Vishon
2012 Hunt Rd.
Oceanview
000199
Terence
Pratt
1724 Lakewood Rd.
Lexington
000206
Ahmed
Jamal
511 Cabrillo Cir.
Brentwood
000209
Lily
Hammond
64 Spring St.
Palmdale
000211
Ernest
Helms
490 Wilson Ave.
Palmdale
000222
Roberta
Drew
203 Scanlan Rd.
Palmdale
000232
Leon
French
188 10th Ave.
Oceanview
000241
Wendy
Thompson
1947 Cypress Dr.
Lexington
000256
Mohammed
Patan
2097 5th Ave.
Oceanview
000263
Bob
Alvarez
616 Vasser Way
Oceanview
000264
Vincent
Ashton
387 Alamo Way
Lexington
000300
Herve
Umeza
812 Grant Ave.
Brentwood
000301
Phillip
Roberts
1221 Ferret St.
Oceanview
Exercise 42 Data Entry for Financial Forecast Analysis 2006
2007 Page 35
2008
2009
Four Year Totals
Microsoft Office Excel Sales 8,583,600.0 0 0 8,583,600.0 0
Sales
2,010,000.00
2,060,000.00
2,121,800.00
2,391,800.00
Other
0
0
0
0
2,010,000.00
2,060,000.00
2,121,800.00
2,391,800.00
320,000 500,000 125,500 0
329,600 515,000 128,750 0
339,488 530,450 132,613 0
389,088 545,450 186,363 0
1,378,176 2,090,900 572,725 0
945,000
973,350
1,002,551
1,120,901
4,041,801
1,065,000
1,086,650
1,119,250
1,270,900
4,541,800
190,000
190,000
190,000
190,000
760,000
50,000
51,500
53,045
54,545
209,090
30,000 5,000 3,000
30,900 5,150 3,090
31,827 5,350 3,183
32,727 5,455 3,273
125,454 20,909 12,545
1,000
1,030
1,061
1,061
4,152
1,000 2,133 11,000 4,000
1,030 2,197 11,330 4,120
1,061 2,263 11,670 4,244
1,061 2,263 12,670 4,244
4,152 8,856 46,670 16,607
6,000
6,180
6,365
6,365
24,911
1,000
1,030
1,061
1,061
4,152
3,000
3,090
3,183
3,183
12,455
1,000
1,030
1,061
1,061
4,152
1,000
1,030
1,061
1,061
4,152
1,000 1,000 6,000
1,030 1,030 6,000
1,061 1,061 6,000
1,061 1,061 6,000
4,152 4,152 24,000
Total Sales Less Cost of Goods Sold Materials Labor Overhead Other Total Cost of Goods Sold Gross Profit Operating Expenses Salaries and wages Employee Benefits Payroll taxes Rent Utilities Repairs and maintenance Insurance Travel Telephone Postage Office supplies Advertising Marketing / promotion Professional fees Training and development Bank charges Depreciation Interest
Page 36
Microsoft Office Excel Expense Other Total Operating Expenses
0
0
0
0
0
317,133
320,767
324,510
328,150
1,290,560
Exercise 43 Last Name
First Name
Doctor Name
Hollars
Stacey
Hollars, Stacey
Smith
Carol
Smith, Carol
Griesemer
Joshua
McConnell
Alicia
Probus
Kelly
Rodgers
Michael
Murphy
Griesemer, Joshua McConnell, Alicia Probus, Kelly
Specialty Family Medicine Emergency Cardiology Sports Medicine Emergency
Sample s
Lunches
10
no
9
yes
5
no
15
yes
9
yes
1
yes
5
no
Tina
Rodgers, Michael Murphy, Tina
Family Medicine Cardiology
Bates
Alex
Bates, Alex
Pediatrics
7
no
Gladish
Judith
Gladish, Judith
Pediatrics
5
no
Law
Tara
Law, Tara
Pediatrics
8
no
Ash
Cheryl
Ash, Cheryl
Radiology
10
yes
Blanton
Samuel
Cardiology
13
yes
Griesemer
Joshua
Cardiology
8
no
Jones
Jennifer
4
yes
McConnell
Alicia
7
no
Ash
3
no
Gladish
2
no
Blanton, Samuel Griesemer, Joshua
Cheryl
McConnell, Alicia Ash, Cheryl
Sports Medicine Sports Medicine Radiology
Judith
Gladish, Judith
Pediatrics
Jones, Jennifer
Page 37
Microsoft Office Excel Smith
Carol
Smith, Carol
Emergency
15
yes
Murphy
Tina
Murphy, Tina
Cardiology
3
yes
Smith
Carol
Smith, Carol
Emergency
0
yes
Probus
Kelly
Probus, Kelly
Emergency
0
yes
Rodgers
Michael
no
Alex
Family Medicine Radiology
0
Bates
Rodgers, Michael Bates, Alex
2
no
Jones
Jennifer
Jones, Jennifer
10
no
Murphy
Tina
Murphy, Tina
Sports Medicine Cardiology
15
yes
Bates
Alex
Bates, Alex
Radiology
10
yes
Jones
Jennifer
Jones, Jennifer
5
no
Law
Tara
Law, Tara
6
yes
Blanton
Samuel
Cardiology
10
yes
Law
Tara
Pediatrics
15
no
Griesemer
Joshua
Griesemer, Joshua
Cardiology
11
yes
Jones
Jennifer
Jones, Jennifer
9
no
Maris
Jonathon
Maris, Jonathon
Sports Medicine Emergency
14
no
Barnes
Ethan
Barnes, Ethan
Pediatrics
10
no
Partner
Debra
Partner, Debra
15
yes
McCoy
Sarah
McCoy, Sarah
Family Medicine Emergency
14
yes
Smith
Carol
Smith, Carol
Emergency
3
yes
Thompson
Jennifer
Cardiology
14
yes
Bates
Alex
Thompson, Jennifer Bates, Alex
Radiology
14
yes
Law
Tara
Law, Tara
Pediatrics
2
no
Blanton
Samuel
Blanton,
Cardiology
6
no
Blanton, Samuel Law, Tara
Page 38
Sports Medicine Pediatrics
Microsoft Office Excel Samuel Griesemer, Joshua Probus, Kelly
Griesemer
Joshua
Probus
Kelly
Rodgers
Michael
Rodgers, Michael
Hollars
Stacey
Hollars, Stacey
Blanton
Samuel
Griesemer
Joshua
Jones
Jennifer
Jones, Jennifer
Smith
Carol
Smith, Carol
Griesemer
Joshua
Griesemer, Joshua
Blanton, Samuel Griesemer, Joshua
Cardiology
10
yes
Emergency
13
no
12
yes
6
yes
Cardiology
5
no
Cardiology
10
yes
10
no
6
yes
12
yes
Family Medicine Family Medicine
Sports Medicine Emergency Cardiology
Exercise 44 Part Number
Type
11164539
RT
11164540
AC
11164541
AB
11164542
RT
11164544
AC
11164545
DE
11164546
DE
11164547
DE
Departmen t Department 2 Department 5 Department 4 Department 2 Department 5 Department 5 Department 2 Department 4 Page 39
Cost
Quantity
Total Value
55.30
15
829.50
69.58
7
487.06
47.87
1
47.87
16.22
5
81.10
54.36
-
74.45
13
967.85
52.03
11
572.33
25.74
8
205.92
Microsoft Office Excel 11164548
DB
11164549
DE
11164550
DB
11164551
RT
11164556
DE
11164557
AB
11164558
DE
11164559
AC
11164560
RT
11164561
RT
11164562
DE
11164563
DE
11164564
AC
11164565
RT
11164567
AB
11164568
AC
11164569
DE
11164570
DB
Department 5 Department 4 Department 1 Department 2 Department 4 Department 2 Department 1 Department 1 Department 5 Department 3 Department 2 Department 1 Department 5 Department 2 Department 3 Department 1 Department 3 Department 3
Exercise 45 Page 40
39.12
14
547.68
10.97
3
32.91
18.56
12
222.72
45.80
17
778.60
88.39
2
176.78
79.08
12
948.96
15.28
7
106.96
2.77
15
41.55
40.96
-
25.07
12
300.84
0.84
12
10.08
9.42
3
28.26
16.02
7
112.14
77.83
4
311.32
1.54
15
23.10
9.81
1
9.81
1.77
8
14.16
7.99
13
103.87
Microsoft Office Excel Grow More Hospitality Services Private Limited
Page 41
Microsoft Office Excel Salary Statement for the month of December 2011 Sl. No .
ID No.
Name
Basic
VDA
HRA
CON V
Medic al
Wash Allow
50,00 0 30,00 0
20,00 0
800
0
800
2,000
800
0
600
22,00 0
2,4 00
2,50 0
Spl. Allow
Othe rs
Total
0
1,00,0 00
0
60,000
599
0
10,000
1,20 0
53,8 97
0
1,70,0 00
istration 1 2
GM00 1 GM00 2
3
Allen, Timothy J Kershaw, David Lapham, Carrie A Total
85,0 00
1,00 1 1,00 1 1,00 1 3,00 3
Abel, Mary E
3000
1001
400
0
0
600
999
0
6000
Total
3000
100 1
400
0
0
600
999
0
6000
Sentell, Tricia J
6000
1001
2150
800
1250
0
799
0
12000
Profer, Brian
2250
1001
550
0
0
600
99
148
4648
3250
1001
600
250
0
600
799
0
6500
3500
1001
600
500
0
600
799
0
7000
5,000
1,25 0 1,25 0
600 0
26,34 9 26,94 9
Security 4
s 5
113
6 7
652
8
Beamish, Coleen Mason, Timothy
9
Rose, Gina M
4250
1001
800
600
0
600
1249
0
8500
10
Streby, Paul G
7500
1001
2600
800
1250
0
1849
0
15000
Total
2675 0
600 6
7300
295 0
2500
240 0
5594
148
53648
3250
1001
600
250
0
600
799
0
6500
Maintenance 11
824
Terry, Andrea
Page 42
Microsoft Office Excel Total
3250
100 1
600
250
0
600
799
0
6500
Banerjee, Ruma
3250
1001
600
250
0
600
799
0
6500
13
Baptist, Jan
2450
1001
400
0
0
600
1049
0
5500
14
Bartlett, Lisa
2450
1001
400
0
0
600
1049
0
5500
2450
1001
400
0
0
600
1049
0
5500
2450
1001
400
0
0
600
1049
0
5500
Total
1305 0
500 5
2200
250
0
300 0
4995
0
28500
17
Dyer, Judy A
4500
1001
700
700
0
600
1499
0
9000
18
Calma, Grace C
4500
1001
700
700
0
600
1499
0
9000
Total
9000
200 2
1400
140 0
0
120 0
2998
0
18000
Drivers 12
114
15 16
Carney, Linda M Koonmen, Jamie
Bouncer
F & B Services 19
Kidd, Reva J
6000
1001
2400
800
0
600
1199
0
12000
20
Jafurs, Sheri E
7500
1001
2600
800
1250
0
1849
0
15000
21
Haley, John J
4500
1001
700
700
0
600
1499
0
9000
3500
1001
600
500
0
600
799
0
7000
2500
1001
750
0
0
600
149
0
5000
22 23
Glover, Cory M Flynn, Crystal A
24
Ellis, Joel
2250
1001
550
0
0
600
99
342
4842
25
Cherem, Barbara
3000
1001
400
0
0
600
999
0
6000
26
Bur, Kevin P
2500
1001
750
0
0
600
149
0
5000
27
Clyde, Paul S
4000
1001
1600
0
0
600
799
0
8000
Page 43
Microsoft Office Excel 28
Clyde, Paul S
2250
1001
550
0
0
600
99
342
4842
29
Clark, Susan M
2250
1001
550
0
0
600
99
342
4842
30
Book, C Jane
3000
1001
400
0
0
600
999
0
6000
31
Bonk, Mario
2250
1001
550
0
0
600
99
342
4842
32
Pomo, Darrin
2250
1001
550
0
0
600
99
342
4842
33
Salata, Diane L
2250
1001
550
0
0
600
99
342
4842
34
Zhou, Chuan
2250
1001
550
0
0
600
99
342
4842
35
Xue, Xiaolin
4000
1001
1600
0
0
600
799
0
8000
36
Nichols, Larry
3000
1001
400
0
0
600
999
0
6000
37
Total
5925 0
180 18
1605 0
280 0
1250
102 00
1093 2
239 4
12089 4
Grand Total
199,30 0
36,03 6
49,950
10,0 50
6,250
19,20 0
80,214
2,54 2
303,542
Exercise 46 Randolph Academy 336 Main St, Randolph, NY 14772, United States Income & expenditure for the year ended 31st march 2010 PARTICULARS
2009 – 2010 ( Rs. )
2008 – 2009 ( Rs. )
INCOME : Donation In INR In Foreign Currency Equivalent to INR
Page 44
9,527,408
12,314,346
170,791
25,758
Microsoft Office Excel Bank Interest On Bank FDRs
401,147
195,983
34,799
30,817
3,740,464
3,373,850
849
0
13,875,457
15,940,754
4,261,021
3,807,880
325,000
275,000
8,305,035
8,743,968
61,900
66,950
12,952,956
12,893,798
922,501
3,046,956
813,776
850,089
108,725
2,196,867
On Bank Project Receipts Other Income TOTAL EXPENDITURE : istrative Expenses Donation Project Expenses Affiliation Fees TOTAL SURPLUS / ( DEFICIT ) BEFORE DEPRECIATION Less: Depreciation SURPLUS / ( DEFICIT ) TRANFERRED TO CORPUS FUND
Exercise 47 Randolph Academy 336 Main St, Randolph, NY 14772, United States Income & expenditure for the year ended 31st march 2010 Page 45
Microsoft Office Excel PARTICULARS
2009 – 2010 ( Rs. )
2008 – 2009 ( Rs. )
203,500
0
Schedule No. 1 hip Fund Opening Balance Received During the year
66,000
203,500
269,500
203,500
11,029,427
8,832,560
108,725
2,196,867
11,138,152
11,029,427
Total Schedule No. 2 Corpus Fund Opening Balance Excess of Income over Expenditure Total
Exercise 48 Balance Sheet - Years 1 to 4 Opening
Year 1
Year 2
Year 3
Year 4
507,604 4,300 393,928 450,204 11,255 1,367,29 1
451,000 1,200 350,000 400,000 10,000 1,212,20 0
464,530 3,200 360,500 412,000 10,300 1,250,53 0
478,466 3,000 371,315 424,360 10,609 1,287,75 0
492,820 3,400 382,454 437,091 10,927 1,326,69 2
2,701,22 1 450,204
2,400,00 0 400,000
2,472,00 0 412,000
2,546,16 0 424,360
2,622,54 5 437,091
ASSETS Current Assets Cash Notes Receivable s receivable, net Inventory Other Total Current Assets Long-Term Assets Property, plant, and equipment Less accumulated depreciation
Page 46
Microsoft Office Excel Net property, plant, and equipment Other long-term assets Total Long-Term Assets Total Assets
2,251,01 8 58,765 2,309,78 3
2,000,00 0 55,000 2,055,00 0
2,060,00 0 55,900 2,115,90 0
2,121,80 0 56,827 2,178,62 7
2,185,45 4 57,782 2,243,23 6
3,677,07 4
3,267,20 0
3,366,43 0
3,466,37 7
3,569,92 8
675,305
600,000
618,000
636,540
655,636
112,551
100,000
103,000
106,090
109,273
112,551 33,765 101,296 18,008 1,053,47 6
100,000 30,000 90,000 16,000
103,000 30,900 92,700 16,480
106,090 31,827 95,481 16,974
936,000
964,080
993,002
109,273 32,782 98,345 17,484 1,022,79 2
692,156
601,200
624,200
645,630
668,308
112,551 85,903 890,610
100,000 79,000 780,200
103,000 80,650 807,850
106,090 82,350 834,070
109,273 84,101 861,682
1,944,08 6
1,716,20 0
1,771,93 0
1,827,07 2
1,884,47 4
100,000 1,000 56,275 1,575,71 2 1,732,98 8
100,000 1,000 50,000 1,400,00 0 1,551,00 0
100,000 1,000 51,500 1,442,00 0 1,594,50 0
100,000 1,000 53,045 1,485,26 0 1,639,30 5
100,000 1,000 54,636 1,529,81 8 1,685,45 4
3,677,07 4
3,267,20 0
3,366,43 0
3,466,37 7
3,569,92 9
LIABILITIES AND SHAREHOLDERS' EQUITY Current Liabilities Short-term debt Current maturities of long-term debt s payable Income taxes payable Accrued liabilities Other Total Current Liabilities Long-Term Liabilities Long-term debt less current maturities Deferred income taxes Other long-term liabilities Total Long-Term Liabilities Total Liabilities Shareholders' Equity Common stock Additional paid-in capital Retained earnings Other Total Shareholders' Equity Total Liabilities and Shareholders' Equity
Exercise 49 Page 47
Microsoft Office Excel Cisco Systems India Pvt. Ltd. Emp. Code Departme nt Bank Name P.F No. Comp. Of LWP/Abse nt CL/CL Balance MAL/Balan ce
16701
Name
Joseph
Branch/Si te
Cisco Systems
Operation
Designation
Tech.
Grade
S4
SVC
No.
4780
Division
Facility Management
KN/BN/358
ESIC No.
289456781
4/0
Days Present
22
Pan No. W.Of/Pd. Of
0/5
Days Paid
30
0/0
SL/SL Bal
0/0
0/0
PAL/Bal
0/0
Month PL/Balanc e L6/Balanc e
4/0 Feb 2010 0/0 0/12
Exercise 50 Salary Slip Employee Name Designation School Name Income tax PAN Month and year Emoluments Basic pay House rent allowance Dearness allowance Medical allowance Vehicle allowance Washing allowance Other allowance Other allowance
Gross pay
James Asst. Teacher St. Anne high school, Lawrence road, Amritsar 143 001 AAAPP1111L December 2010 Amount Rs. Deductions Amount Rs. 15,000 Profession tax 200 3,000 General provident fund 4,000 Contributory provident 7,500 fund 100 Life insurance corporation 5,000 Postal life insurance 240 Group insurance 150 Income tax (TDS) 1,000 Credit society 300
25,600
*Net pay = Gross pay – Total deductions Page 48
Total deductions
10,890
Net pay
14,710
Microsoft Office Excel Exercise 51 Sl. No
City
Bank
1
Agra
ICICI
Ground floor, 18, A/51, Fatehbad Road, Agra - 282001
2
Agra
ICICI
C- 80 / 4, Kamla Nagar, Agra - 282005
3 4 5 6
Ahmedab ad Ahmedab ad Ahmedab ad Ahmedab ad
ICICI ICICI Centurio n
Address
JMC House Opp.Parimal Garden, Of. C.G. Road, Ambavadi Ahmedabad 380 006 2, Shashi Shopping Complex, Swaminarayan Chowk, Paldi Vasna, Ahmedabad Sarkhej Gandhinagar Highway
HSBC
ShopNo.UL12,IndraprasthaTower,Drive-InRoad,Ahmedabad380054
7
Amritsar
ICICI
Airport Authority of India, Rajsansi Airport, Amritsar - 143 001
8
Amritsar
ICICI
S.C.F 39, Kabir Park, Opp Gurunanak Dev University, Amritsar 141003.
9
Amritsar
ICICI
Nidhi, 2- Lawrence Road, Amritsar 143 001.
HDFC
Shop No. 16 , Ground Floor
HDFC
Parle Biscuits, Bahadurgarh
ICICI
1292, 25th Main Road, Jayanagar, 9th Block, Bangalore - 560069.
ICICI
No 641, 11th Main , 46th Cross, 5th Block, Banglore – 560041
10 11 12 13 14 15 16 17 18
Aurangab ad Aurangab ad Bangalor e Bangalor e Bangalor e Bangalor e Bangalor e Bangalor e Bangalor e
ICICI ICICI ICICI
Asea Brown Boveri Ltd., Plot No.5 & 6, II Phase, Peenya Industrial Area 560058. Annapurna, IOCL Pump R.V.Road, Next To Vijaya College, Bangalore - 560009. 80/7, Elephant Rock Road, Block III, Jayanagar, Bangalore 560 041.
ICICI
366-367, 1st A Main, VII Block, Koramangala, Bangalore 560 095.
HDFC
No. 6, Royal Arcade
Page 49
Microsoft Office Excel Exercise 52 Projected Balance Sheet Integral India Software Development Centre Pvt. Ltd. No. 99, mittal towers, 3rd main, 2nd cross, Bangalore – 560 001 January
February
March
April
May
June
July
August
Septemb er
October
Novemb er
Decemb er
10,0 00 20,0 00
10,0 50 18,0 00
12,0 00 20,0 00
10,0 00 17,0 00
13,0 00 16,0 00
20,0 00 17,9 00
21,0 00 17,8 50
22,0 00 19,0 00
18,2 50 25,0 00
26,0 00 26,0 00
22,0 00 21,0 00
25,4 50 18,0 00
s receivable
12,0 00
15,0 00
13,9 00
17,0 00
21,0 00
13,0 00
15,0 00
18,0 00
20,0 00
15,7 00
14,0 00
16,0 00
Prepaid expenses Other current assets
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
1,00 0
0
0
0
0
0
0
0
0
0
0
0
0
Total current assets
43,0 00
44,0 50
46,9 00
45,0 00
51,0 00
51,9 00
54,8 50
60,0 00
64,2 50
68,7 00
58,0 00
60,4 50
Balance sheet
Cash Inventory
Exercise 53 Pro-Forma Balance Sheet ASSETS Current Assets Cash Net s receivable Inventory Temporary investment
Xyz company From (2003 - 2006) 2003 2004 54,000 3,67,000 1,77,000 12,000 Page 50
57,000 3,96,000 1,91,000 12,000
2005
2006
59,000 4,26,000 2,03,000 12,000
64,000 4,35,000 12,000
Microsoft Office Excel Prepaid expenses
2,000
2,000
2,000
2,000
6,12,000
6,58,000
7,02,000
5,13,000
42,000 6,56,000 9,03,000 6,08,000 61,000
43,000 6,56,000 9,28,000 6,31,00 65,000
43,000 6,84,000 9,83,000 6,42,000 68,000
46,000 7,27,000 10,21,000 6,54,000 72,000
Total fixed assets
22,70,000
17,55,100
24,20,000
25,20,000
TOTAL ASSETS
28,82,000
24,13,100
31,22,000
30,33,000
Total current assets Fixed Assets Long-term investments Land Buildings (net of depreciation) Plant and equipment (net) Furniture and fixtures (net)
LIABILITIES Current liabilities s payable Short-term notes Current portion of long-term notes Accruals and other payables
2,56,000 24,000
2,52,000 25,000
2,58,000 26,000
2,77,000 28,000
14,000
14,000
14,000
15,000
14,000
14,000
14,000
14,000
Total current liabilities
3,08,000
3,05,000
3,12,000
3,34,000
Long-term liabilities Mortgage Other long-term liabilities
8,97,000 4,43,000
9,31,000 14,16,000
9,78,000 15,05,000
10,21,000 15,97,000
13,40,000
23,47,000
24,83,000
26,18,000
3,00,000 9,44,000
3,00,000 9,60,000
3,00,000 10,05,000
3,00,000 10,07,000
Total shareholders’ equity
12,44,000
12,60,000
13,05,000
13,07,000
Total liabilities and equity
28,92,000
39,12,000
41,00,000
42,59,000
Total long-term liabilities Shareholders’ equity Capital stock Retained earnings
Exercise 54
Page 51
Microsoft Office Excel Sales
Page 52
Microsoft Office Excel Janua ry
Febru ary
Marc h
Total Sales per Region
Amos, Andy
52,00 0
35,000
45,50 0
837,100
Boyd, Betty
45,00 0
27,500
52,00 0
124,500
Cox, Carole
65,00 0
32,500
51,50 0
149,000
Dell, Denice
75,00 0
80,500
75,00 0
230,500
Evans, Everett
45,00 0
70,500
85,10 0
200,600
Fountain, Fran
35,00 0
37,500
78,52 0
Garner, Gabe
27,50 0
81,000
70,50 0
179,000
Henry, Herb
32,50 0
45,000
37,50 0
115,000
Ingram, Ian
80,50 0
82,500
81,00 0
244,000
Jackson, Jake
70,50 0
70,500
45,00 0
186,000
King, Karl
25,00 0
37,500
82,50 0
81,00 0
85,000
75,00 0
241,000
56,50 0
60,500
45,00 0
162,000
Sales Report Region 1
Region 2
Region 3
Lemmons, Leslie Murdoch, Martin
Page 53
875,020
1,067,000
Total Sales per Employee 132,500
151,020
145,000
Microsoft Office Excel Neil, Nelly
94,00 0
97,000
50,00 0
341,000
70,00 0
75,500
32,50 0
178,000
Pine, Phyllis
48,50 0
45,500
35,00 0
Quartz, Cody
52,00 0
52,000
27,50 0
131,500
Russell, Ryan
51,50 0
51,500
32,50 0
135,500
75,00 0
52,000
80,50 0
207,500
85,10 0
45,000
70,50 0
200,600
78,52 0
65,000
37,50 0
Varner, Vince
45,85 0
75,000
81,00 0
201,850
Webb, Wyatt
75,85 0
45,000
45,00 0
165,850
65,89 0
35,000
82,50 0
183,390
78,88 0
27,500
82,50 0
188,880
Ormond, Oprah Region 4
Stevens, Stuart Tate, Thomas Region 5
Unger, Ulysses
Younts, Yolanda Zimmerman, Zack
804,100
920,990
129,000
181,020
Exercise 55 Sl. No.
Database Marketing City/State Quantity Page 54
Price
Microsoft Office Excel 1. 2. 3. 4. 5. 6. 7. 8. 9. 10.
Mumbai Delhi Bangalore Hyderabad Gujarat Maharashtra Haryana Kerala Andhra Pradesh
60 lakh 1 crore 60 lakh 24 lakh 1.5 crore 1.2 crore 90 lakh 35 lakh 2 core
20,000 30,000 20,000 15,000 35,000 35,000 30,000 15,000 50,000
Madhya Pradesh
25 lakh
20,000
Tamil Nadu
1 crore
30,000
Uttar Pradesh
2.5 crore
60,000
Punjab
40 lakh
20,000
11. 12. 13.
Exercise 56 Category
City/Stat e
Quantity
1.
All India Addresses Database
All India
15 lac addresses
2.
HNI Mumbai
Mumbai
3.
Job Seekers
All India
4.
CEO Personal Email Ids
All India
5.
Companies in Mumbai
Mumbai
6.
Companies in Delhi
Delhi
Sl. No.
Price 10,000
2 Lakh ( 95% Accurate ) 4 Lakh ( 95% Accurate ) 50,000 ( 90% Accurate ) 6 Lakh ( 85% accurate ) 5 Lakh ( 85% Accurate )
8,900 10,000 4,500 10,000 10,000
Exercise 57 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Income Page 55
Jul
Aug
Sep
Oct
Nov
Dec
To t
Av g
Microsoft Office Excel Wages & Tips Interest Income Dividends Gifts Received Reimburseme nt’s Savings Other
100 0 200 0 300 0 400 0 500 0 600 0 700 0
500 100 0 150 0 200 0 250 0 300 0 350 0
100 0 110 0 120 0 130 0 140 0 150 0 160 0
200 0 250 0 300 0 350 0 400 0 450 0 500 0
500 600 700 800 900 100 0 110 0
350 0 300 0 250 0 200 0 150 0 100 0 500
130 0 160 0 190 0 220 0 250 0 280 0 310 0
120 0 140 0 160 0 180 0 200 0 220 0 240 0
320 0 360 0 400 0 440 0 480 0 520 0 560 0
180 0 200 0 220 0 240 0 260 0 280 0 300 0
100 0 160 0 220 0 280 0 340 0 400 0 460 0
500 700 900 110 0 130 0 150 0 170 0
Total
Exercise 58 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Home Expenses Mortgage / Rent Electricity
350 0 500
350 0 550
350 0 600
350 0 650
350 0 700
350 0 750
350 0 800
350 0 850
350 0 900
350 0 950
Gas / Oil
750
800
850
900
950
750
800
850
900
Water / Sewer
100 0 600 300 200 0 350 300
100 0 610 300 200 0 400 300
100 0 620 300 200 0 450 300
100 0 630 300 200 0 500 300
100 0 640 300 200 0 550 300
100 0 100 0 650 300 200 0 600 300
350 0 100 0 950
100 0 660 300 200 0 650 300
100 0 670 300 200 0 700 300
100 0 680 300 200 0 750 300
100 0 690 300 200 0 800 300
100 0 700 300 200 0 850 300
350 0 150 0 100 0 100 0 710 300 200 0 900 300
100
200
300
400
500
600
100
200
300
400
500
600
100 0 200 0
100 0 200 0
100 0 200 0
100 0 200 0
100 0 200 0
100 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
105 0 200 0
Phone Cable Internet Furnishings Lawn / Garden Home Supplies Maintenance Improvement s
Page 56
To t
Av g
Microsoft Office Excel Other
-
-
-
-
-
-
220 0
360 0
-
750 0
-
-
Total
Exercise 59 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
600 500
650 500
600 500
650 500
600 500
650 500
600 500
650 500
600 500
650 500
600 500
650 500
300 0 100 0 400 0 100 0 300
350 0 100 0 600 0 100 0 300
300 0 100 0 200 0 100 0 300
300 0 100 0 500 0 100 0 300
350 0 100 0 400 0 100 0 300
300 0 100 0 300 0 100 0 300
350 0 100 0 200 0 100 0 300
300 0 100 0 100 0 100 0 300
350 0 100 0 200 0 100 0 300
300 0 100 0 300 0 100 0 300
350 0 100 0 100 0 100 0 300
-
-
-
350 0 100 0 300 0 100 0 300 0 -
-
-
-
-
-
-
-
-
To t
Av g
To t
Av g
Daily Living Groceries Personal Supplies Clothing Cleaning Services Dining/Eating out Dry Cleaning Salon / Barber Other Total
Exercise 60 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Medical
500 400 0 800 0 300 0 100 0 200 0
150 0 500 0 800 0 300 0 100 0 200 0
200 0 550 0 800 0 300 0 100 0 200 0
250 0 600 0 800 0 300 0 100 0 200 0
300 0 650 0 800 0 300 0 100 0 200 0
500
Clothing
100 0 450 0 800 0 300 0 100 0 200 0
100 0 450 0 800 0 300 0 100 0 200 0
150 0 500 0 800 0 300 0 100 0 200 0
200 0 550 0 800 0 300 0 100 0 200 0
250 0 600 0 800 0 300 0 100 0 200 0
300 0 650 0 800 0 300 0 100 0 200 0
Children
School Tuition School Lunch School Supplies Babysitting
Page 57
400 0 800 0 300 0 100 0 200 0
Microsoft Office Excel Toys / Games Other
600 0 -
600 0 -
600 0 -
600 0 -
600 0 400
600 0 300
600 0 200
600 0 100
600 0 500
600 0 -
600 0 -
600 0 600
Total
Exercise 61 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
100 0 300 0 700 300 400 -
To t
Av g
To t
Av g
To t
Av g
Transportation Vehicle Payment Fuel Bus / Taxi Repairs Registration Other
100 0 300 0 700 300 400 -
Total
Exercise 62 Family Budget Planner Jan
Feb
Mar
Apr
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
700
700
700
700
700
700
700
700
700
700
700
700
300
300
300
300
300
300
300
300
300
300
300
300
200
250
300
350
400
450
200
250
300
350
400
450
100 0 -
150 0 -
100 0 -
150 0 -
200 0 -
350 0 -
100 0 -
250 0 -
300 0 -
320 0 -
250 0 -
300 0 -
Ma y
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Health Doctor / Dentist Medicine / Drugs Health Club Dues Emergency Other Total
Exercise 63 Family Budget Planner Jan
Feb
Mar
Apr
Business Expense Page 58
Microsoft Office Excel Deductible NonDeductible Other Other
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
600 300
-
-
-
-
-
-
-
-
-
-
-
-
Total
Page 59
Related Documents c2h70
M S Excel Computer Lab Assignments With Solutions 3w1l6j
October 2019 88
Excel Assignments 465m2h
October 2019 80
Computer Architecture Assignments 2f6n6j
November 2019 57
April 2020 16
April 2020 35
November 2021 0
More Documents from "Arun" 6f3r3f
M S Excel Computer Lab Assignments With Solutions 3w1l6j
October 2019 88
Calicut University - Sixth Semester Btech - Embedded Systems 6g4cm
December 2019 90
Sadashiva Brahmendra Kirtanas Lyrics In Sanskrit 1qm2d
January 2022 0
New Microsoft Office Powerpoint Presentation.pptx 4c2b5y
March 2021 0
Wife In A Massage Parlour 51f3c
July 2022 0