Assignment

mharpermontes
MidtermExam2018.xlsx

EARLY

FVGA

RETIRE

BREWSKI

State BCPC INC MB TAX FPCT POP TEMP
Alabama 30.2 $44,765 28 $1.05 51.5 4.87 62.8
Alaska 28.7 $73,355 32 $1.07 47.6 0.74 26.6
Arizona 29.5 $51,492 86 $0.16 50.3 7.02 60.3
Arkansas 26.7 $41,995 28 $0.35 50.9 3.00 60.4
California 25.5 $64,500 623 $0.20 50.3 39.54 59.4
Colorado 30.0 $63,909 334 $0.08 49.8 5.61 45.1
Connecticut 22.0 $71,346 49 $0.23 51.2 3.59 49.0
Delaware 33.6 $61,255 19 $0.16 51.6 0.96 55.3
Florida 27.4 $49,426 195 $0.48 51.1 20.98 70.7
Georgia 25.7 $51,244 53 $1.01 51.1 10.43 63.5
Hawaii 30.4 $73,486 14 $0.93 49.5 1.43 70.0
Idaho 27.8 $48,275 53 $0.15 49.9 1.72 44.4
Illinois 29.1 $59,588 181 $0.23 50.9 12.80 51.8
Indiana 25.9 $50,532 127 $0.12 50.7 6.67 51.7
Iowa 33.6 $54,736 70 $0.19 50.4 3.15 47.8
Kansas 28.3 $53,906 31 $0.18 50.2 2.91 54.3
Kentucky 24.4 $45,215 34 $0.84 50.8 4.45 55.6
Louisiana 33.9 $45,727 26 $0.32 51.1 4.68 66.4
Maine 34.0 $51,494 77 $0.35 51.0 1.34 41.0
Maryland 23.2 $75,847 65 $0.49 51.5 6.05 54.2
Massachusetts 26.2 $70,628 110 $0.11 51.5 6.86 47.9
Michigan 26.8 $51,084 222 $0.20 50.9 9.96 44.4
Minnesota 28.5 $63,488 112 $0.47 50.3 5.58 41.2
Mississippi 33.9 $40,593 9 $0.43 51.4 2.98 63.4
Missouri 31.0 $50,238 78 $0.06 51.0 6.11 54.5
Montana 41.0 $49,509 68 $0.14 49.8 1.05 42.7
Nebraska 35.2 $54,996 42 $0.31 50.2 1.92 48.8
Nevada 35.8 $52,431 37 $0.16 49.6 3.00 49.9
New Hampshire 43.9 $70,303 54 $0.30 50.6 1.34 43.8
New Jersey 22.4 $72,222 82 $0.12 51.2 9.01 52.7
New Mexico 32.4 $45,382 57 $0.41 50.4 2.09 53.4
New York 22.4 $60,850 269 $0.14 51.5 19.85 45.4
North Carolina 27.1 $47,830 200 $0.62 51.3 10.27 59.0
North Dakota 45.8 $60,557 10 $0.39 48.9 0.76 40.4
Ohio 30.1 $51,075 177 $0.18 51.1 11.66 50.7
Oklahoma 28.3 $48,568 20 $0.40 50.5 3.93 59.6
Oregon 30.3 $54,148 243 $0.08 50.5 4.14 48.4
Pennsylvania 28.6 $55,702 205 $0.08 51.1 12.81 48.8
Rhode Island 26.3 $58,073 15 $0.12 51.6 1.06 50.1
South Carolina 32.7 $47,238 50 $0.77 51.3 5.02 62.4
South Dakota 38.9 $53,017 15 $0.27 49.8 0.87 45.2
Tennessee 26.2 $47,275 66 $1.29 51.2 6.72 57.6
Texas 34.4 $55,653 201 $0.20 50.3 28.30 64.8
Utah 20.2 $62,912 27 $0.41 49.7 3.10 48.6
Vermont 35.3 $56,990 50 $0.27 50.7 0.62 42.9
Virginia 26.7 $66,262 164 $0.26 50.8 8.47 55.1
Washington 24.8 $64,129 334 $0.26 50.0 7.41 48.3
Washington DC 28.3 $75,628 12 $0.64 52.6 0.69 55.7
West Virginia 30.3 $42,019 15 $0.18 50.6 1.82 51.8
Wisconsin 36.2 $55,638 138 $0.06 50.3 5.80 43.1
Wyoming 33.0 $60,214 23 $0.02 49.0 0.58 42.0

RAISE

Worker Gender This Year's Salary Minimum Production Maximum Production
Alex M $ 59,269 10,000 13,546
Bob M $ 64,972 10,000 18,214
Cyndie F $ 51,191 10,000 20,536
Dave M $ 58,320 10,000 21,490
Ed M $ 60,250 10,000 18,634
Francine F $ 45,765 10,000 15,656
Georgina F $ 34,512 10,000 16,384
Hillary F $ 37,896 10,000 12,511
Ida F $ 39,786 10,000 15,445
Jennifer F $ 41,061 10,000 14,477
Kevin M $ 69,733 10,000 19,914
Lani F $ 39,240 10,000 15,877
Marcy F $ 41,220 10,000 15,820
Norman M $ 56,438 10,000 19,559

NPV

Year Project A Project B
0 $ (300,000) $ (100,000)
1 $ 47,656 $ 22,067
2 $ 76,807 $ 23,998
3 $ 49,337 $ 28,380
4 $ 51,997 $ 18,767
5 $ 62,734 $ 27,047
6 $ 66,521 $ 29,219
7 $ 43,077 $ 27,618
8 $ 64,423 $ 14,424
9 $ 58,134 $ 20,800
10 $ 41,594 $ 18,119

SIM

AOI

WEEK