Computer Information System

Taty1987

IS312_ExcelProject_F20.xlsx

Home >Computer Science homework help >Computer Information System

Payroll

Cyberia Enterprise
Payroll for the week of Nov 11 , 2019
			Production Department - Unit 3
Prepared by YOUR NAME
Name	Number of Dependents	Hourly Wage	Regular Hours	Overtime Hours	Gross Pay	Taxable Income	Withholding Tax	Soc Sec Tax	Net Pay
Alphan	2	$15.00	40	8
Betan	2	$10.25	40	12
Cocan	2	$12.50	40	8
Deltan	3	$17.00	40	4
Eptan	1	$15.00	35	0
Fifan	4	$10.25	40	0
Totals
Minimum
Maximum
Average
Assumptions
Overtime Rate			2.00		Withholding Tax			30.0%
Deduction per dependent			$50.00		Social Security Tax			7.65%
Notes:
1. Taxable Income is the Gross Pay minus total deduction for dependents
2. Withholding Tax is calculated on the Taxable Income
3. Social Security Tax is calculated on the employee's Gross Pay
4. The overtime bonus per hour is calculated from Hourly Wage and Overtime Rate (2.00 means double of regular hourly rate)
5. Use Absolute Addresses/References of Assumptions in calculations

Forecasting

		Cyberia Enterprise
		Statement of Projected Revenue
		Prepared by YOUR NAME
Projection		2019	2020	2021	2022	2023	2024
	Revenue Income by Source
	Custom Projects	$1,809,347
	Standard Projects	$3,200,567
	Consulting Fees	$2,543,256
	Total Revenue by Source	$7,553,170
	Investment Earnings
	Investment Earnings	$450,687
	Total Investment Earnings	$450,687
	Rental Income
	Rental Income	$147,000
	Total Rental Income	$147,000
	Transfers from Other Funds
	Sales of Equipments	$213,557
	Subvention from State	$150,000
	Total Transfers from Other Funds	$363,557
	Total Projected Revenue From All Sources	$8,514,414
( Use Absolute Addresses/ References of Assumptions in calculations )				CHART
Assumptions	Assumptions	Annual Increase / Decrease Rate
	Custom Projects	10%
	Standard Projects	20%
	Consultingt Fees	15%
	Investment Earnings	10%
	Rental Income	15%
	Sales of Equipments	20%
	Subvention	25%

Pivot Table

Millenium Enterprise					PIVOT TABLE
Sales by Sales Reps					Prepared by YOUR NAME
Sales Rep	Quarter	Media	Amount
Alpha	1st quarter	TV	$15,000
Alpha	1st quarter	Radio	$4,000
Beta	1st quarter	Magazine	$2,000
Beta	1st quarter	Radio	$1,000
Coca	1st quarter	Radio	$4,000
Delta	1st quarter	Radio	$2,000
Alpha	2nd quarter	Magazine	$2,000
Alpha	2nd quarter	Radio	$4,000
Beta	2nd quarter	Radio	$4,000
Coca	2nd quarter	Magazine	$2,000
Coca	2nd quarter	Magazine	$7,000
Coca	2nd quarter	TV	$10,000
Delta	2nd quarter	TV	$6,000
Delta	2nd quarter	TV	$6,000
Alpha	3rd quarter	Radio	$2,000
Beta	3rd quarter	TV	$10,000
Coca	3rd quarter	TV	$8,000
Coca	3rd quarter	TV	$18,000
Delta	3rd quarter	TV	$20,000
Delta	3rd quarter	Magazine	$15,000
Delta	3rd quarter	Magazine	$2,000
Alpha	4th quarter	Radio	$4,000
Alpha	4th quarter	Radio	$1,000
Beta	4th quarter	Magazine	$10,000
Beta	4th quarter	Magazine	$12,000
Beta	4th quarter	Radio	$1,000
Beta	4th quarter	Magazine	$7,000
Coca	4th quarter	TV	$13,000
Delta	4th quarter	TV	$13,000
Delta	4th quarter	TV	$15,000
				PIVOT CHART

Mortgage Schedule 30 years

Mortgage Schedule 30 years
Prepared by YOUR NAME
30 YEARS LOAN PLAN at 3.8% Fixed
Use the follwing information as Absolute References in calculations
Loan Amount / Principal	Annual Interest Rate	Interest Rate per Month	Months to Pay			New Plan: Additional Monthly Payment to Principal *
$300,000.00	3.80%	0.32%	360			$300.00
						* starting on 2nd Month
Payment Schedule for 30-year Loan at 3.8 % Fixed
Year	Month / Period	Remaining Principal	Interest Payment	Principal Payment	Total Payment for this Month	Monthly Payment under New Plan	Remaining Principal under New Plan
1	1
1	2
1	3
1	4
1	5
1	6
1	7
1	8
1	9
1	10
1	11
1	12
2	13
2	14
2	15
2	16
2	17
2	18
2	19
2	20
2	21
2	22
2	23
2	24
3	25
3	26
3	27
3	28
3	29
3	30
3	31
3	32
3	33
3	34
3	35
3	36
4	37
4	38
4	39
4	40
4	41
4	42
4	43
4	44
4	45
4	46
4	47
4	48
5	49
5	50
5	51
5	52
5	53
5	54
5	55
5	56
5	57
5	58
5	59
5	60
6	61
6	62
6	63
6	64
6	65
6	66
6	67
6	68
6	69
6	70
6	71
6	72
7	73
7	74
7	75
7	76
7	77
7	78
7	79
7	80
7	81
7	82
7	83
7	84
8	85
8	86
8	87
8	88
8	89
8	90
8	91
8	92
8	93
8	94
8	95
8	96
9	97
9	98
9	99
9	100
9	101
9	102
9	103
9	104
9	105
9	106
9	107
9	108
10	109
10	110
10	111
10	112
10	113
10	114
10	115
10	116
10	117
10	118
10	119
10	120
11	121
11	122
11	123
11	124
11	125
11	126
11	127
11	128
11	129
11	130
11	131
11	132
12	133
12	134
12	135
12	136
12	137
12	138
12	139
12	140
12	141
12	142
12	143
12	144
13	145
13	146
13	147
13	148
13	149
13	150
13	151
13	152
13	153
13	154
13	155
13	156
14	157
14	158
14	159
14	160
14	161
14	162
14	163
14	164
14	165
14	166
14	167
14	168
15	169
15	170
15	171
15	172
15	173
15	174
15	175
15	176
15	177
15	178
15	179
15	180
16	181
16	182
16	183
16	184
16	185
16	186
16	187
16	188
16	189
16	190
16	191
16	192
17	193
17	194
17	195
17	196
17	197
17	198
17	199
17	200
17	201
17	202
17	203
17	204
18	205
18	206
18	207
18	208
18	209
18	210
18	211
18	212
18	213
18	214
18	215
18	216
19	217
19	218
19	219
19	220
19	221
19	222
19	223
19	224
19	225
19	226
19	227
19	228
20	229
20	230
20	231
20	232
20	233
20	234
20	235
20	236
20	237
20	238
20	239
20	240
21	241
21	242
21	243
21	244
21	245
21	246
21	247
21	248
21	249
21	250
21	251
21	252
22	253
22	254
22	255
22	256
22	257
22	258
22	259
22	260
22	261
22	262
22	263
22	264
23	265
23	266
23	267
23	268
23	269
23	270
23	271
23	272
23	273
23	274
23	275
23	276
24	277
24	278
24	279
24	280
24	281
24	282
24	283
24	284
24	285
24	286
24	287
24	288
25	289
25	290
25	291
25	292
25	293
25	294
25	295
25	296
25	297
25	298
25	299
25	300
26	301
26	302
26	303
26	304
26	305
26	306
26	307
26	308
26	309
26	310
26	311
26	312
27	313
27	314
27	315
27	316
27	317
27	318
27	319
27	320
27	321
27	322
27	323
27	324
28	325
28	326
28	327
28	328
28	329
28	330
28	331
28	332
28	333
28	334
28	335
28	336
29	337
29	338
29	339
29	340
29	341
29	342
29	343
29	344
29	345
29	346
29	347
29	348
30	349
30	350
30	351
30	352
30	353
30	354
30	355
30	356
30	357
30	358
30	359
30	360

Mortgage Schedule 15 years

Mortgage Schedule 15 years
Prepared by YOUR NAME
15 YEARS LOAN PLAN at 3.2% Fixed
Use the follwing information as Absolute References in calculations
Loan Amount / Principal	Annual Interest Rate	Interest Rate per Month	Months to Pay			New Plan: Additional Monthly Payment to Principal *
$300,000.00	3.20%	0.27%	180			$300.00
						* starting on 2nd Month
Payment Schedule for 15-year Loan at 3.2% Fixed
Year	Month / Period	Remaining Principal	Interest Payment	Principal Payment	Total Payment for this Month	Monthly Payment under New Plan	Remaining Principal under New Plan
1	1
1	2
1	3
1	4
1	5
1	6
1	7
1	8
1	9
1	10
1	11
1	12
2	13
2	14
2	15
2	16
2	17
2	18
2	19
2	20
2	21
2	22
2	23
2	24
3	25
3	26
3	27
3	28
3	29
3	30
3	31
3	32
3	33
3	34
3	35
3	36
4	37
4	38
4	39
4	40
4	41
4	42
4	43
4	44
4	45
4	46
4	47
4	48
5	49
5	50
5	51
5	52
5	53
5	54
5	55
5	56
5	57
5	58
5	59
5	60
6	61
6	62
6	63
6	64
6	65
6	66
6	67
6	68
6	69
6	70
6	71
6	72
7	73
7	74
7	75
7	76
7	77
7	78
7	79
7	80
7	81
7	82
7	83
7	84
8	85
8	86
8	87
8	88
8	89
8	90
8	91
8	92
8	93
8	94
8	95
8	96
9	97
9	98
9	99
9	100
9	101
9	102
9	103
9	104
9	105
9	106
9	107
9	108
10	109
10	110
10	111
10	112
10	113
10	114
10	115
10	116
10	117
10	118
10	119
10	120
11	121
11	122
11	123
11	124
11	125
11	126
11	127
11	128
11	129
11	130
11	131
11	132
12	133
12	134
12	135
12	136
12	137
12	138
12	139
12	140
12	141
12	142
12	143
12	144
13	145
13	146
13	147
13	148
13	149
13	150
13	151
13	152
13	153
13	154
13	155
13	156
14	157
14	158
14	159
14	160
14	161
14	162
14	163
14	164
14	165
14	166
14	167
14	168
15	169
15	170
15	171
15	172
15	173
15	174
15	175
15	176
15	177
15	178
15	179
15	180