exp22_excel_ch07_HOE_salary

profilesyed1312
Exp22_Excel_Ch07_HOE_Salary.xlsx
Home>Information Systems homework help>exp22_excel_ch07_HOE_salary

1-Date Logic

Input Area Regions Comparison Data Bonus Decision Date Percent
South Last Day of Year 12/31/24 Hired before 1/1/13 8%
Midwest Minimum Manager Salary $ 98,000 Hired before 1/1/18 4%
Northeast Hired before 1/1/23 2%
Name City Region Title Hire Date Year Hired Years Employed Day of Week Hired Salary Bonus Amount Raise Status
Bacarella Atlanta Manager 10/18/10 $ 98,750
Günther Chicago Account Rep 11/7/23 $ 69,575
Chen Boston Manager 3/9/23 $ 85,800
Laing Atlanta Account Rep 12/14/12 $ 98,000
Garbett Atlanta Account Rep 9/18/14 $ 77,835
Gomez Boston Account Rep 10/11/16 $ 66,725
Hartvigsen Boston Account Rep 2/18/23 $ 75,000
Ikenberry Cleveland Account Rep 4/17/18 $ 65,125
Keone Chicago Account Rep 4/3/20 $ 65,125
Thunderhawk Chicago Manager 1/17/14 $ 95,500
Matsumoto Atlanta Account Rep 4/17/15 $ 79,750
Mentzer Boston Account Rep 6/26/19 $ 60,450
Mercado Cleveland Account Rep 8/30/19 $ 60,000
Nitz Chicago Account Rep 8/13/20 $ 61,000
Sae Cleveland Account Rep 1/8/20 $ 60,000
Scholfield Atlanta Account Rep 7/14/20 $ 62,750
Terriquez Chicago Account Rep 4/15/09 $ 70,750

2-Stats Map

Name Location State Title Hire Date Salary Summary by Location
Bacarella Atlanta GA Manager 10/18/10 $ 98,750 City State # Employees Payroll
Günther Chicago IL Account Rep 11/7/23 $ 69,575 Atlanta GA
Chen Boston MA Manager 3/9/23 $ 85,800 Boston MA
Laing Atlanta GA Account Rep 12/14/12 $ 98,000 Chicago IL
Garbett Atlanta GA Account Rep 9/18/14 $ 77,835 Cleveland OH
Gomez Boston MA Account Rep 10/11/16 $ 66,725
Hartvigsen Boston MA Account Rep 2/18/23 $ 75,000 Summary Average Salaries
Ikenberry Cleveland OH Account Rep 4/17/18 $ 65,125 Account Rep
Keone Chicago IL Account Rep 4/3/20 $ 65,125 Manager
Thunderhawk Chicago IL Manager 1/17/14 $ 95,500
Matsumoto Atlanta GA Account Rep 4/17/15 $ 79,750 Account Reps Summary Statistics
Mentzer Boston MA Account Rep 6/26/19 $ 60,450 Hired Before 1/1/2018
Mercado Cleveland OH Account Rep 8/30/19 $ 60,000 Total $ Hired < 1/1/2018
Nitz Chicago IL Account Rep 8/13/20 $ 61,000 Average $ Hired < 1/1/2018
Sae Cleveland OH Account Rep 1/8/20 $ 60,000 Highest $ Hired <1/1/2018
Scholfield Atlanta GA Account Rep 7/14/20 $ 62,750 Lowest $ Hired <1/1/2018
Terriquez Chicago IL Account Rep 4/15/09 $ 70,750

3-Finance

Input Area: Basic Output Area:
Payment $ 600.00 Loan
APR 5.25% Periodic Rate 0.438%
Years 3 # of Payments 36
Pmts per Year 12
Payment Number Beginning Balance Monthly Payment Interest Paid Principal Repayment Ending Balance Cumulative Interest Cumulative Principal
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
Totals $ - 0 $ - 0 $ - 0