BUSN250 Wk2
xlsx
keyboard_arrow_up
School
American Public University *
*We aren’t endorsed by this school
Course
250
Subject
Industrial Engineering
Date
Jan 9, 2024
Type
xlsx
Pages
25
Uploaded by UltraSteelDeer31
Science and Engineering Jobs
Total science and engineering jobs in thousands: 2000 and projected 2010
PROJECTE
Occupation
2000
2010
Nominal
Scientists
3,241
5,301
"=C6-B6"
2,060
Life scientists
184
218
34
Mathematical/computer scientists
2,408
4,308
1,900
Computer specialists
2,318
4,213
1,895
Mathematical scientists
89
95
6
Physical scientists
239
283
44
Social scientists
410
492
82
Engineers
1,465
1,603
138
All occupations
145,571 167,754
22,183
Fill formulas in to get results
ED INCREASE
Percentage
63.56%
"=G6/B6"
18.48%
78.90%
81.75%
6.74%
18.41%
20.00%
9.42%
15.24%
ID
Store No.
Sales Region
Item No.
Item Description
Unit PriceUnits Sold
1
1 South
2005 24" Monitor
$229.00
28
2
1 South
2005 24" Monitor
$229.00
30
3
1 South
2005 24" Monitor
$229.00
9
4
1 South
3006 Wireless Keyboard
$19.95
30
5
1 South
3006 Wireless Keyboard
$19.95
35
6
1 South
3006 Wireless Keyboard
$19.95
39
7
1 South
6050 PC Mouse
$8.95
28
8
1 South
6050 PC Mouse
$8.95
3
9
1 South
6050 PC Mouse
$8.95
38
10
1 South
8500 Laptop
$849.95
25
11
1 South
8500 Laptop
$849.95
27
12
1 South
8500 Laptop
$849.95
33
13
2 South
2005 24" Monitor
$229.00
8
14
2 South
2005 24" Monitor
$229.00
8
15
2 South
2005 24" Monitor
$229.00
10
16
2 South
3006 Wireless Keyboard
$19.95
8
17
2 South
3006 Wireless Keyboard
$19.95
8
18
2 South
3006 Wireless Keyboard
$19.95
8
19
2 South
6050 PC Mouse
$8.95
9
20
2 South
6050 PC Mouse
$8.95
9
21
2 South
6050 PC Mouse
$8.95
8
22
2 South
8500 Laptop
$849.95
18
23
2 South
8500 Laptop
$849.95
18
24
2 South
8500 Laptop
$849.95
20
25
3 South
2005 24" Monitor
$229.00
38
26
3 South
2005 24" Monitor
$229.00
30
27
3 South
2005 24" Monitor
$229.00
3
28
3 South
3006 Wireless Keyboard
$19.95
30
29
3 South
3006 Wireless Keyboard
$19.95
32
30
3 South
3006 Wireless Keyboard
$19.95
33
31
3 South
6050 PC Mouse
$8.95
25
32
3 South
6050 PC Mouse
$8.95
5
33
3 South
6050 PC Mouse
$8.95
26
34
3 South
8500 Laptop
$849.95
28
35
3 South
8500 Laptop
$849.95
27
36
3 South
8500 Laptop
$849.95
29
37
4 North
2005 24" Monitor
$229.00
18
38
4 North
2005 24" Monitor
$229.00
20
39
4 North
2005 24" Monitor
$229.00
4
40
4 North
3006 Wireless Keyboard
$19.95
12
41
4 North
3006 Wireless Keyboard
$19.95
24
42
4 North
3006 Wireless Keyboard
$19.95
36
43
4 North
6050 PC Mouse
$8.95
29
44
4 North
6050 PC Mouse
$8.95
11
45
4 North
6050 PC Mouse
$8.95
38
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
46
4 North
8500 Laptop
$849.95
21
47
4 North
8500 Laptop
$849.95
24
48
4 North
8500 Laptop
$849.95
30
49
5 North
2005 24" Monitor
$229.00
27
50
5 North
2005 24" Monitor
$229.00
25
51
5 North
2005 24" Monitor
$229.00
23
52
5 North
3006 Wireless Keyboard
$19.95
80
53
5 North
3006 Wireless Keyboard
$19.95
82
54
5 North
3006 Wireless Keyboard
$19.95
75
55
5 North
6050 PC Mouse
$8.95
65
56
5 North
6050 PC Mouse
$8.95
24
57
5 North
6050 PC Mouse
$8.95
55
58
5 North
8500 Laptop
$849.95
55
59
5 North
8500 Laptop
$849.95
57
60
5 North
8500 Laptop
$849.95
47
61
6 East
2005 24" Monitor
$229.00
24
62
6 East
2005 24" Monitor
$229.00
85
63
6 East
2005 24" Monitor
$229.00
56
64
6 East
3006 Wireless Keyboard
$19.95
52
65
6 East
3006 Wireless Keyboard
$19.95
58
66
6 East
3006 Wireless Keyboard
$19.95
69
67
6 East
6050 PC Mouse
$8.95
35
68
6 East
6050 PC Mouse
$8.95
39
69
6 East
6050 PC Mouse
$8.95
44
70
6 East
8500 Laptop
$849.95
78
71
6 East
8500 Laptop
$849.95
88
72
6 East
8500 Laptop
$849.95
99
73
7 East
2005 24" Monitor
$229.00
34
74
7 East
2005 24" Monitor
$229.00
36
75
7 East
2005 24" Monitor
$229.00
35
76
7 East
3006 Wireless Keyboard
$19.95
49
77
7 East
3006 Wireless Keyboard
$19.95
47
78
7 East
3006 Wireless Keyboard
$19.95
48
79
7 East
6050 PC Mouse
$8.95
45
80
7 East
6050 PC Mouse
$8.95
42
81
7 East
6050 PC Mouse
$8.95
45
82
7 East
8500 Laptop
$849.95
55
83
7 East
8500 Laptop
$849.95
57
84
7 East
8500 Laptop
$849.95
55
85
8 East
2005 24" Monitor
$229.00
18
86
8 East
2005 24" Monitor
$229.00
17
87
8 East
2005 24" Monitor
$229.00
23
88
8 East
3006 Wireless Keyboard
$19.95
22
89
8 East
3006 Wireless Keyboard
$19.95
18
90
8 East
3006 Wireless Keyboard
$19.95
22
91
8 East
6050 PC Mouse
$8.95
14
92
8 East
6050 PC Mouse
$8.95
16
93
8 East
6050 PC Mouse
$8.95
17
94
8 East
8500 Laptop
$849.95
32
95
8 East
8500 Laptop
$849.95
28
96
8 East
8500 Laptop
$849.95
30
Store and Regional Database
Week Ending
Total Weekly Revenue
STORE NO
TOTAL SALES REVENUE
October
$6,412.00 1
$90,281.10
November
$6,870.00 2
$54,262.70
December
$2,061.00 3
$90,051.25
October
$598.50 4
$75,498.75
November
$698.25 5
$158,334.00
December
$778.05 6
$267,648.90
October
$250.60 7
$170,040.85
November
$26.85 8
$91,435.05
December
$340.10 October
$21,248.75 November
$22,948.65 December
$28,048.35 SALES REGION
TOTAL SALES REVENUE
October
$1,832.00 South
$234,595.05
November
$1,832.00 North
$233,832.75
December
$2,290.00 East
$529,124.80
October
$159.60 November
$159.60 December
$159.60 October
$80.55 November
$80.55 December
$71.60 October
$15,299.10 November
$15,299.10 December
$16,999.00 October
$8,702.00 November
$6,870.00 December
$687.00 October
$598.50 November
$638.40 December
$658.35 October
$223.75 November
$44.75 December
$232.70 October
$23,798.60 November
$22,948.65 December
$24,648.55 October
$4,122.00 November
$4,580.00 December
$916.00 October
$239.40 November
$478.80 December
$718.20 October
$259.55 November
$98.45 December
$340.10
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
October
$17,848.95 November
$20,398.80 December
$25,498.50 October
$6,183.00 November
$5,725.00 December
$5,267.00 October
$1,596.00 November
$1,635.90 December
$1,496.25 October
$581.75 November
$214.80 December
$492.25 October
$46,747.25 November
$48,447.15 December
$39,947.65 October
$5,496.00 November
$19,465.00 December
$12,824.00 October
$1,037.40 November
$1,157.10 December
$1,376.55 October
$313.25 November
$349.05 December
$393.80 October
$66,296.10 November
$74,795.60 December
$84,145.05 October
$7,786.00 November
$8,244.00 December
$8,015.00 October
$977.55 November
$937.65 December
$957.60 October
$402.75 November
$375.90 December
$402.75 October
$46,747.25 November
$48,447.15 December
$46,747.25 October
$4,122.00 November
$3,893.00 December
$5,267.00 October
$438.90 November
$359.10 December
$438.90 October
$125.30 November
$143.20 December
$152.15
October
$27,198.40 November
$23,798.60 December
$25,498.50
President's Inn Guest Database
ID
Guest First Name
Guest Last Name
Room
Room Type
Arrival Date
Departure Date
1 Barry
Lloyd
Hayes
Bay-window
12/1/2014
12/4/2014
2 Michael
Lunsford
Cleveland
Ocean
12/1/2014
12/9/2014
3 Kim
Kyuong
Coolidge
Bay-window
12/4/2014
12/7/2014
4 Edward
Holt
Washington
Ocean
12/1/2014
12/3/2014
5 Thomas
Collins
Lincoln
Ocean
12/9/2014
12/13/2014
6 Paul
Bodkin
Coolidge
Bay-window
12/1/2014
12/3/2014
7 Randall
Battenburg
Washington
Ocean
12/4/2014
12/12/2014
8 Calvin
Nowotney
Lincoln
Ocean
12/2/2014
12/4/2014
9 Homer
Gonzalez
Lincoln
Ocean
12/5/2014
12/7/2014
10 David
Sanchez
Jefferson
Bay-window
12/5/2014
12/7/2014
11 Buster
Whisler
Jackson
Ocean
12/5/2014
12/8/2014
12 Julia
Martines
Reagan
Bay-window
12/10/2014
12/15/2014
13 Samuel
Kim
Truman
Side
12/20/2014
12/30/2014
14 Arthur
Gottfried
Garfield
Side
12/13/2014
12/15/2014
15 Darlene
Shore
Arthur
Ocean
12/24/2014
12/31/2014
16 Carlyle
Charleston
Quincy Adams
Bay-window
12/3/2014
12/6/2014
17 Albert
Goldstone
Johnson
Ocean
12/5/2014
12/7/2014
18 Charlene
Tilson
Van Buren
Bay-window
12/5/2014
12/7/2014
19 Everett
Chad
Madison
Ocean
12/10/2014
12/14/2014
20 Gerald
Pittsfield
Roosevelt
Ocean
12/5/2014
12/7/2014
21 Jamal
Smith
Tyler
Bay-window
12/20/2014
12/23/2014
22 Louis
Paris
Jackson
Ocean
12/10/2014
12/14/2014
23 Nigel
Stratford
Eisenhower
Ocean
12/14/2014
12/16/2014
24 Peter
Willington
Grant
Ocean
12/19/2014
12/21/2014
25 Ronald
Cartier
Jefferson
Bay-window
12/24/2014
12/28/2014
26 Trista
Leven
Eisenhower
Ocean
12/17/2014
12/20/2014
27 Valerie
Snell
Adams
Bay-window
12/3/2014
12/6/2014
28 Walter
Acton
Polk
Side
12/24/2014
12/31/2014
29 Xavier
Trezza
McKinley
Side
12/14/2014
12/17/2014
30 Zachary
Miller
Washington
Ocean
12/13/2014
12/16/2014
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Additional Fee Per Guest
$ 20.00 per day
No of Guests
Daily Rate
2
$150.00
$150.00
3
3
$112.50
$132.50
8
1
$150.00
$150.00
3
4
$325.00
$365.00
2
2
$300.00
$300.00
4
2
$150.00
$150.00
2
2
$292.50
$292.50
8
1
$300.00
$300.00
2
5
$320.00
$380.00
2
2
$175.00
$175.00
2
2
$250.00
$250.00
3
1
$150.00
$150.00
5
3
$112.50
$132.50
10
2
$125.00
$125.00
2
5
$198.00
$258.00
7
2
$150.00
$150.00
3
3
$250.00
$270.00
2
1
$150.00
$150.00
2
2
$275.00
$275.00
4
2
$275.00
$275.00
2
2
$150.00
$150.00
3
1
$250.00
$250.00
4
2
$200.00
$200.00
2
1
$200.00
$200.00
2
4
$175.00
$215.00
4
1
$200.00
$200.00
3
1
$150.00
$150.00
3
6
$148.50
$228.50
7
2
$125.00
$125.00
3
2
$325.00
$325.00
3
Daily Rate Considering Number of Guests
Number of Days Stayed
Discount after 6 days
10%
Total Revenue
$450.00
$954.00
$450.00
$730.00
$1,200.00
$300.00
$2,106.00
$600.00
$760.00
$350.00
$750.00
$750.00
$1,192.50
$250.00
$1,625.40
$450.00
$540.00
$300.00
$1,100.00
$550.00
$450.00
$1,000.00
$400.00
$400.00
$860.00
$600.00
$450.00
$1,439.55
$375.00
$975.00
Credit Risk Base Data
(b)
Loan Purpose
Checking Savings
Checking Acct Status
Savings Acct Status
Small Appliance
$0
$739
LOW
MEDIUM
Furniture
$0
$1,230
LOW
MEDIUM
New Car
$0
$389
LOW
MEDIUM
Furniture
$638
$347
MEDIUM
MEDIUM
Education
$963
$4,754
MEDIUM
HIGH
Furniture
$2,827
$0
HIGH
LOW
New Car
$0
$229
LOW
LOW
Business
$0
$533
LOW
MEDIUM
Small Appliance
$6,509
$493
HIGH
MEDIUM
Small Appliance
$966
$0
MEDIUM
LOW
Business
$0
$989
LOW
MEDIUM
New Car
$0
$3,305
LOW
HIGH
Business
$322
$578
MEDIUM
MEDIUM
New Car
$0
$821
LOW
MEDIUM
New Car
$396
$228
MEDIUM
LOW
Used Car
$0
$129
LOW
LOW
Furniture
$652
$732
MEDIUM
MEDIUM
New Car
$708
$683
MEDIUM
MEDIUM
Repairs
$207
$0
LOW
LOW
Education
$287
$12,348
MEDIUM
HIGH
Furniture
$0
$17,545
LOW
HIGH
Furniture
$101
$3,871
LOW
HIGH
Furniture
$0
$0
LOW
LOW
Furniture
$0
$485
LOW
MEDIUM
New Car
$0
$10,723
LOW
HIGH
Business
$141
$245
LOW
LOW
Used Car
$0
$0
LOW
LOW
Used Car
$2,484
$0
HIGH
LOW
Small Appliance
$237
$236
LOW
LOW
Small Appliance
$0
$485
LOW
MEDIUM
Education
$335
$1,708
MEDIUM
MEDIUM
Small Appliance
$3,565
$0
HIGH
LOW
Small Appliance
$0
$407
LOW
MEDIUM
Business
$16,647
$895
HIGH
MEDIUM
Business
$0
$150
LOW
LOW
Small Appliance
$0
$490
LOW
MEDIUM
Furniture
$0
$162
LOW
LOW
Small Appliance
$940
$715
MEDIUM
MEDIUM
Small Appliance
$0
$323
LOW
MEDIUM
New Car
$0
$128
LOW
LOW
Other
$218
$0
LOW
LOW
Used Car
$0
$109
LOW
LOW
Small Appliance
$16,935
$189
HIGH
LOW
Furniture
$664
$537
MEDIUM
MEDIUM
Furniture
$150
$6,520
LOW
HIGH
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Small Appliance
$0
$138
LOW
LOW
Furniture
$216
$0
LOW
LOW
New Car
$0
$660
LOW
MEDIUM
Business
$0
$724
LOW
MEDIUM
Small Appliance
$0
$897
LOW
MEDIUM
Small Appliance
$265
$947
MEDIUM
MEDIUM
Furniture
$4,256
$0
HIGH
LOW
Business
$870
$917
MEDIUM
MEDIUM
New Car
$162
$595
LOW
MEDIUM
Used Car
$0
$789
LOW
MEDIUM
Education
$0
$0
LOW
LOW
Furniture
$0
$746
LOW
MEDIUM
New Car
$461
$140
MEDIUM
LOW
New Car
$0
$659
LOW
MEDIUM
Furniture
$0
$717
LOW
MEDIUM
New Car
$0
$667
LOW
MEDIUM
New Car
$580
$0
MEDIUM
LOW
Small Appliance
$0
$763
LOW
MEDIUM
New Car
$0
$1,366
LOW
MEDIUM
Small Appliance
$0
$552
LOW
MEDIUM
Small Appliance
$0
$14,643
LOW
HIGH
Business
$758
$2,665
MEDIUM
HIGH
Used Car
$399
$0
MEDIUM
LOW
Furniture
$513
$442
MEDIUM
MEDIUM
Furniture
$0
$8,357
LOW
HIGH
New Car
$0
$0
LOW
LOW
Small Appliance
$565
$863
MEDIUM
MEDIUM
Business
$0
$322
LOW
MEDIUM
Furniture
$0
$800
LOW
MEDIUM
Small Appliance
$0
$656
LOW
MEDIUM
New Car
$166
$922
LOW
MEDIUM
Business
$9,783
$885
HIGH
MEDIUM
Business
$674
$2,886
MEDIUM
HIGH
Repairs
$0
$626
LOW
MEDIUM
Business
$15,328
$0
HIGH
LOW
New Car
$0
$904
LOW
MEDIUM
Education
$713
$784
MEDIUM
MEDIUM
New Car
$0
$806
LOW
MEDIUM
Education
$0
$3,281
LOW
HIGH
New Car
$0
$759
LOW
MEDIUM
Small Appliance
$0
$680
LOW
MEDIUM
Used Car
$0
$104
LOW
LOW
Small Appliance
$303
$899
MEDIUM
MEDIUM
Small Appliance
$900
$1,732
MEDIUM
MEDIUM
Furniture
$0
$706
LOW
MEDIUM
Education
$1,257
$0
MEDIUM
LOW
Small Appliance
$0
$576
LOW
MEDIUM
Repairs
$273
$904
MEDIUM
MEDIUM
Business
$522
$194
MEDIUM
LOW
Small Appliance
$0
$710
LOW
MEDIUM
Small Appliance
$0
$5,564
LOW
HIGH
Small Appliance
$0
$192
LOW
LOW
New Car
$0
$637
LOW
MEDIUM
Small Appliance
$514
$405
MEDIUM
MEDIUM
Furniture
$457
$318
MEDIUM
MEDIUM
Small Appliance
$5,133
$698
HIGH
MEDIUM
New Car
$0
$369
LOW
MEDIUM
Retraining
$644
$0
MEDIUM
LOW
Furniture
$305
$492
MEDIUM
MEDIUM
New Car
$9,621
$308
HIGH
MEDIUM
Education
$0
$127
LOW
LOW
Business
$0
$565
LOW
MEDIUM
Furniture
$0
$12,632
LOW
HIGH
New Car
$0
$116
LOW
LOW
Used Car
$0
$178
LOW
LOW
Small Appliance
$6,851
$901
HIGH
MEDIUM
Furniture
$13,496
$650
HIGH
MEDIUM
Business
$509
$241
MEDIUM
LOW
Used Car
$0
$609
LOW
MEDIUM
Furniture
$19,155
$131
HIGH
LOW
Furniture
$0
$544
LOW
MEDIUM
Small Appliance
$0
$10,853
LOW
HIGH
Used Car
$374
$0
MEDIUM
LOW
Large Appliance
$0
$409
LOW
MEDIUM
Furniture
$828
$391
MEDIUM
MEDIUM
Furniture
$0
$322
LOW
MEDIUM
Small Appliance
$829
$583
MEDIUM
MEDIUM
Small Appliance
$0
$12,242
LOW
HIGH
Furniture
$0
$479
LOW
MEDIUM
New Car
$939
$496
MEDIUM
MEDIUM
New Car
$0
$466
LOW
MEDIUM
New Car
$889
$1,583
MEDIUM
MEDIUM
Furniture
$876
$1,533
MEDIUM
MEDIUM
Small Appliance
$893
$0
MEDIUM
LOW
Business
$12,760
$4,873
HIGH
HIGH
Furniture
$0
$0
LOW
LOW
Small Appliance
$0
$717
LOW
MEDIUM
Small Appliance
$959
$7,876
MEDIUM
HIGH
Small Appliance
$0
$4,449
LOW
HIGH
Other
$0
$0
LOW
LOW
Business
$0
$104
LOW
LOW
Repairs
$0
$897
LOW
MEDIUM
New Car
$698
$4,033
MEDIUM
HIGH
Furniture
$0
$945
LOW
MEDIUM
Furniture
$0
$836
LOW
MEDIUM
Small Appliance
$0
$325
LOW
MEDIUM
Small Appliance
$12,974
$19,568
HIGH
HIGH
Furniture
$0
$803
LOW
MEDIUM
Small Appliance
$317
$10,980
MEDIUM
HIGH
Business
$0
$265
LOW
MEDIUM
Repairs
$0
$609
LOW
MEDIUM
Small Appliance
$0
$1,851
LOW
MEDIUM
Furniture
$192
$199
LOW
LOW
New Car
$0
$500
LOW
MEDIUM
New Car
$0
$509
LOW
MEDIUM
Used Car
$0
$270
LOW
MEDIUM
New Car
$0
$457
LOW
MEDIUM
Used Car
$0
$260
LOW
MEDIUM
New Car
$942
$3,036
MEDIUM
HIGH
Small Appliance
$0
$643
LOW
MEDIUM
New Car
$3,329
$0
HIGH
LOW
Used Car
$0
$6,345
LOW
HIGH
Education
$0
$922
LOW
MEDIUM
Furniture
$0
$909
LOW
MEDIUM
Large Appliance
$0
$775
LOW
MEDIUM
Furniture
$0
$979
LOW
MEDIUM
Furniture
$0
$948
LOW
MEDIUM
Business
$339
$2,790
MEDIUM
HIGH
Used Car
$0
$309
LOW
MEDIUM
Small Appliance
$0
$762
LOW
MEDIUM
Small Appliance
$0
$970
LOW
MEDIUM
Used Car
$105
$320
LOW
MEDIUM
Small Appliance
$0
$861
LOW
MEDIUM
Repairs
$216
$262
LOW
MEDIUM
Furniture
$113
$692
LOW
MEDIUM
Used Car
$109
$540
LOW
MEDIUM
New Car
$0
$470
LOW
MEDIUM
New Car
$0
$192
LOW
LOW
New Car
$8,176
$12,230
HIGH
HIGH
Repairs
$0
$772
LOW
MEDIUM
Furniture
$468
$14,186
MEDIUM
HIGH
Used Car
$7,885
$6,330
HIGH
HIGH
Small Appliance
$0
$18,716
LOW
HIGH
New Car
$0
$886
LOW
MEDIUM
Business
$0
$750
LOW
MEDIUM
Small Appliance
$0
$3,870
LOW
HIGH
Small Appliance
$0
$3,273
LOW
HIGH
Business
$0
$406
LOW
MEDIUM
Furniture
$0
$461
LOW
MEDIUM
Furniture
$0
$340
LOW
MEDIUM
Small Appliance
$0
$6,490
LOW
HIGH
Small Appliance
$734
$348
MEDIUM
MEDIUM
Furniture
$0
$506
LOW
MEDIUM
Used Car
$0
$14,717
LOW
HIGH
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Business
$172
$0
LOW
LOW
New Car
$644
$1,571
MEDIUM
MEDIUM
New Car
$0
$0
LOW
LOW
Furniture
$617
$411
MEDIUM
MEDIUM
New Car
$0
$544
LOW
MEDIUM
Small Appliance
$586
$0
MEDIUM
LOW
Furniture
$0
$835
LOW
MEDIUM
Small Appliance
$0
$823
LOW
MEDIUM
Business
$0
$5,180
LOW
HIGH
Small Appliance
$0
$408
LOW
MEDIUM
New Car
$0
$821
LOW
MEDIUM
Education
$522
$385
MEDIUM
MEDIUM
New Car
$585
$2,223
MEDIUM
HIGH
New Car
$5,588
$0
HIGH
LOW
New Car
$0
$605
LOW
MEDIUM
Furniture
$352
$7,525
MEDIUM
HIGH
Small Appliance
$0
$3,529
LOW
HIGH
Business
$2,715
$1,435
HIGH
MEDIUM
Other
$560
$887
MEDIUM
MEDIUM
Small Appliance
$895
$243
MEDIUM
LOW
New Car
$305
$4,553
MEDIUM
HIGH
Small Appliance
$0
$418
LOW
MEDIUM
New Car
$0
$771
LOW
MEDIUM
Furniture
$0
$463
LOW
MEDIUM
Business
$8,948
$110
HIGH
LOW
Used Car
$0
$10,099
LOW
HIGH
Used Car
$0
$13,428
LOW
HIGH
Small Appliance
$0
$208
LOW
LOW
Small Appliance
$0
$552
LOW
MEDIUM
Education
$0
$3,105
LOW
HIGH
Small Appliance
$483
$415
MEDIUM
MEDIUM
Large Appliance
$0
$1,238
LOW
MEDIUM
Education
$0
$238
LOW
LOW
Furniture
$0
$127
LOW
LOW
Business
$663
$0
MEDIUM
LOW
New Car
$624
$785
MEDIUM
MEDIUM
Repairs
$0
$718
LOW
MEDIUM
Furniture
$0
$493
LOW
MEDIUM
Small Appliance
$152
$757
LOW
MEDIUM
New Car
$0
$9,125
LOW
HIGH
Small Appliance
$0
$364
LOW
MEDIUM
Business
$498
$598
MEDIUM
MEDIUM
New Car
$0
$374
LOW
MEDIUM
Small Appliance
$156
$0
LOW
LOW
Used Car
$1,336
$0
MEDIUM
LOW
New Car
$0
$508
LOW
MEDIUM
Small Appliance
$0
$956
LOW
MEDIUM
Furniture
$0
$636
LOW
MEDIUM
New Car
$2,641
$0
HIGH
LOW
Used Car
$0
$1,519
LOW
MEDIUM
Business
$0
$922
LOW
MEDIUM
Furniture
$0
$180
LOW
LOW
Used Car
$0
$701
LOW
MEDIUM
Small Appliance
$0
$296
LOW
MEDIUM
Small Appliance
$887
$519
MEDIUM
MEDIUM
Business
$0
$800
LOW
MEDIUM
Furniture
$0
$736
LOW
MEDIUM
Small Appliance
$0
$11,838
LOW
HIGH
Small Appliance
$0
$364
LOW
MEDIUM
New Car
$18,408
$212
HIGH
LOW
New Car
$497
$888
MEDIUM
MEDIUM
Used Car
$0
$999
LOW
MEDIUM
Small Appliance
$946
$0
MEDIUM
LOW
Business
$986
$578
MEDIUM
MEDIUM
Education
$8,122
$136
HIGH
LOW
Furniture
$0
$734
LOW
MEDIUM
Business
$778
$861
MEDIUM
MEDIUM
Other
$645
$855
MEDIUM
MEDIUM
Furniture
$0
$4,486
LOW
HIGH
New Car
$682
$2,017
MEDIUM
HIGH
New Car
$19,812
$0
HIGH
LOW
Business
$0
$500
LOW
MEDIUM
Used Car
$0
$859
LOW
MEDIUM
Business
$859
$3,305
MEDIUM
HIGH
Small Appliance
$0
$1,218
LOW
MEDIUM
New Car
$0
$9,016
LOW
HIGH
New Car
$0
$11,587
LOW
HIGH
Furniture
$0
$8,944
LOW
HIGH
Repairs
$0
$807
LOW
MEDIUM
Small Appliance
$0
$867
LOW
MEDIUM
Small Appliance
$795
$16,804
MEDIUM
HIGH
Furniture
$0
$347
LOW
MEDIUM
Furniture
$0
$836
LOW
MEDIUM
Furniture
$0
$142
LOW
LOW
Furniture
$0
$169
LOW
LOW
Other
$852
$3,613
MEDIUM
HIGH
Education
$0
$403
LOW
MEDIUM
Small Appliance
$0
$836
LOW
MEDIUM
New Car
$425
$0
MEDIUM
LOW
Business
$0
$11,481
LOW
HIGH
Business
$0
$3,285
LOW
HIGH
Education
$0
$164
LOW
LOW
New Car
$11,072
$891
HIGH
MEDIUM
Used Car
$0
$0
LOW
LOW
Used Car
$219
$841
LOW
MEDIUM
New Car
$8,060
$607
HIGH
MEDIUM
New Car
$0
$486
LOW
MEDIUM
New Car
$0
$108
LOW
LOW
Small Appliance
$0
$0
LOW
LOW
New Car
$0
$113
LOW
LOW
New Car
$1,613
$0
MEDIUM
LOW
Furniture
$757
$208
MEDIUM
LOW
Retraining
$0
$603
LOW
MEDIUM
New Car
$0
$343
LOW
MEDIUM
Education
$977
$463
MEDIUM
MEDIUM
Education
$197
$0
LOW
LOW
Furniture
$0
$299
LOW
MEDIUM
New Car
$0
$490
LOW
MEDIUM
Small Appliance
$0
$6,628
LOW
HIGH
Business
$0
$859
LOW
MEDIUM
New Car
$0
$750
LOW
MEDIUM
Small Appliance
$256
$954
MEDIUM
MEDIUM
New Car
$296
$591
MEDIUM
MEDIUM
Furniture
$0
$13,970
LOW
HIGH
New Car
$0
$857
LOW
MEDIUM
Furniture
$0
$5,857
LOW
HIGH
Small Appliance
$298
$3,326
MEDIUM
HIGH
Small Appliance
$0
$726
LOW
MEDIUM
Furniture
$8,636
$214
HIGH
LOW
New Car
$0
$207
LOW
LOW
New Car
$0
$713
LOW
MEDIUM
New Car
$19,766
$2,141
HIGH
HIGH
New Car
$0
$483
LOW
MEDIUM
New Car
$0
$127
LOW
LOW
Furniture
$0
$367
LOW
MEDIUM
Small Appliance
$0
$813
LOW
MEDIUM
Furniture
$4,089
$0
HIGH
LOW
New Car
$0
$102
LOW
LOW
Repairs
$271
$759
MEDIUM
MEDIUM
New Car
$949
$0
MEDIUM
LOW
Small Appliance
$0
$503
LOW
MEDIUM
Small Appliance
$911
$823
MEDIUM
MEDIUM
New Car
$0
$693
LOW
MEDIUM
Used Car
$0
$973
LOW
MEDIUM
New Car
$0
$648
LOW
MEDIUM
Other
$0
$523
LOW
MEDIUM
Used Car
$271
$7,090
MEDIUM
HIGH
Small Appliance
$0
$596
LOW
MEDIUM
Used Car
$0
$904
LOW
MEDIUM
New Car
$0
$541
LOW
MEDIUM
Furniture
$0
$154
LOW
LOW
New Car
$4,802
$0
HIGH
LOW
Business
$177
$0
LOW
LOW
Small Appliance
$0
$337
LOW
MEDIUM
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
New Car
$0
$716
LOW
MEDIUM
Education
$996
$837
MEDIUM
MEDIUM
Education
$705
$0
MEDIUM
LOW
Furniture
$0
$7,710
LOW
HIGH
New Car
$0
$531
LOW
MEDIUM
Small Appliance
$5,960
$129
HIGH
LOW
Furniture
$0
$941
LOW
MEDIUM
Furniture
$759
$596
MEDIUM
MEDIUM
Furniture
$0
$987
LOW
MEDIUM
Small Appliance
$651
$0
MEDIUM
LOW
Business
$257
$460
MEDIUM
MEDIUM
Small Appliance
$955
$0
MEDIUM
LOW
Small Appliance
$0
$798
LOW
MEDIUM
Small Appliance
$8,249
$0
HIGH
LOW
Small Appliance
$0
$959
LOW
MEDIUM
Small Appliance
$956
$1,482
MEDIUM
MEDIUM
New Car
$382
$883
MEDIUM
MEDIUM
Furniture
$0
$12,721
LOW
HIGH
Education
$842
$0
MEDIUM
LOW
Repairs
$3,111
$0
HIGH
LOW
Small Appliance
$0
$302
LOW
MEDIUM
Furniture
$0
$538
LOW
MEDIUM
Small Appliance
$2,846
$0
HIGH
LOW
Small Appliance
$231
$702
LOW
MEDIUM
Repairs
$0
$2,688
LOW
HIGH
Small Appliance
$17,366
$0
HIGH
LOW
Small Appliance
$0
$425
LOW
MEDIUM
New Car
$332
$214
MEDIUM
LOW
Small Appliance
$242
$0
LOW
LOW
New Car
$0
$272
LOW
MEDIUM
Business
$929
$124
MEDIUM
LOW
Small Appliance
$0
$17,124
LOW
HIGH
Used Car
$0
$612
LOW
MEDIUM
New Car
$0
$862
LOW
MEDIUM
Furniture
$0
$146
LOW
LOW
New Car
$0
$14,190
LOW
HIGH
Used Car
$0
$396
LOW
MEDIUM
Small Appliance
$0
$519
LOW
MEDIUM
Used Car
$646
$0
MEDIUM
LOW
New Car
$538
$344
MEDIUM
MEDIUM
Furniture
$0
$204
LOW
LOW
Small Appliance
$0
$148
LOW
LOW
Furniture
$0
$435
LOW
MEDIUM
Small Appliance
$0
$914
LOW
MEDIUM
New Car
$135
$0
LOW
LOW
Used Car
$2,472
$0
HIGH
LOW
New Car
$0
$412
LOW
MEDIUM
New Car
$10,417
$19,811
HIGH
HIGH
Small Appliance
$211
$822
LOW
MEDIUM
Small Appliance
$16,630
$0
HIGH
LOW
Furniture
$0
$3,369
LOW
HIGH
Furniture
$642
$0
MEDIUM
LOW
Small Appliance
$0
$707
LOW
MEDIUM
Small Appliance
$296
$818
MEDIUM
MEDIUM
Business
$898
$177
MEDIUM
LOW
New Car
$478
$4,071
MEDIUM
HIGH
New Car
$315
$466
MEDIUM
MEDIUM
New Car
$122
$460
LOW
MEDIUM
Furniture
$0
$991
LOW
MEDIUM
Small Appliance
$0
$17,653
LOW
HIGH
Education
$0
$497
LOW
MEDIUM
Business
$670
$4,014
MEDIUM
HIGH
Business
$444
$921
MEDIUM
MEDIUM
New Car
$3,880
$0
HIGH
LOW
Used Car
$819
$0
MEDIUM
LOW
Used Car
$0
$607
LOW
MEDIUM
Large Appliance
$0
$15,800
LOW
HIGH
Furniture
$0
$369
LOW
MEDIUM
Business
$0
$4,973
LOW
HIGH
Furniture
$0
$0
LOW
LOW
New Car
$0
$761
LOW
MEDIUM
Education
$0
$471
LOW
MEDIUM
Used Car
$0
$674
LOW
MEDIUM
New Car
$0
$547
LOW
MEDIUM
Furniture
$161
$524
LOW
MEDIUM
Furniture
$0
$815
LOW
MEDIUM
Used Car
$0
$0
LOW
LOW
New Car
$789
$989
MEDIUM
MEDIUM
Small Appliance
$765
$10,406
MEDIUM
HIGH
Furniture
$0
$957
LOW
MEDIUM
New Car
$0
$770
LOW
MEDIUM
Furniture
$983
$950
MEDIUM
MEDIUM
Used Car
$0
$160
LOW
LOW
Used Car
$0
$276
LOW
MEDIUM
Education
$798
$137
MEDIUM
LOW
New Car
$0
$579
LOW
MEDIUM
New Car
$193
$2,684
LOW
HIGH
Small Appliance
$497
$0
MEDIUM
LOW
Furniture
$0
$0
LOW
LOW
New Car
$0
$0
LOW
LOW
New Car
$0
$712
LOW
MEDIUM
New Car
$0
$912
LOW
MEDIUM
(a)
Loan Purpose
Number of Applicants
New Car
104
Used Car
40
Business
44
Education
23
Small Appliance
0
Furniture
85
Checking Acct Balance
No of Customers
less than $500
312
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Purchase Orders
Supplier Order No.
Item No.
Item Description
Item Cost
Quantity
Cost per order
Hulkey Fasteners
Aug11001
1122
Airframe fasteners
$ 4.25 19,500 $ 82,875.00 Alum Sheeting
Aug11002
1243
Airframe fasteners
$ 4.25 10,000 $ 42,500.00 Fast-Tie Aerospace
Aug11003
5462
Shielded Cable/ft.
$ 1.05 23,000 $ 24,150.00 Fast-Tie Aerospace
Aug11004
5462
Shielded Cable/ft.
$ 1.05 21,500 $ 22,575.00 Steelpin Inc.
Aug11005
5319
Shielded Cable/ft.
$ 1.10 17,500 $ 19,250.00 Fast-Tie Aerospace
Aug11006
5462
Shielded Cable/ft.
$ 1.05 22,500 $ 23,625.00 Steelpin Inc.
Aug11007
4312
Bolt-nut package
$ 3.75 4,250 $ 15,937.50 Durrable Products
Aug11008
7258
Pressure Gauge
$ 90.00 100 $ 9,000.00 Fast-Tie Aerospace
Aug11009
6321
O-Ring
$ 2.45 1,300 $ 3,185.00 Fast-Tie Aerospace
Aug11010
5462
Shielded Cable/ft.
$ 1.05 22,500 $ 23,625.00 Steelpin Inc.
Aug11011
5319
Shielded Cable/ft.
$ 1.10 18,100 $ 19,910.00 Hulkey Fasteners
Aug11012
3166
Electrical Connector
$ 1.25 5,600 $ 7,000.00 Hulkey Fasteners
Aug11013
9966
Hatch Decal
$ 0.75 500 $ 375.00 Steelpin Inc.
Aug11014
5234
Electrical Connector
$ 1.65 4,500 $ 7,425.00 Steelpin Inc.
Sep11001
4312
Bolt-nut package
$ 3.75 4,200 $ 15,750.00 Alum Sheeting
Sep11002
5417
Control Panel
$ 255.00 406 $ 103,530.00 Hulkey Fasteners
Sep11003
3166
Electrical Connector
$ 1.25 5,500 $ 6,875.00 Steelpin Inc.
Sep11004
5234
Electrical Connector
$ 1.65 4,850 $ 8,002.50 Steelpin Inc.
Sep11005
4312
Bolt-nut package
$ 3.75 4,150 $ 15,562.50 Hulkey Fasteners
Sep11006
1122
Airframe fasteners
$ 4.25 15,500 $ 65,875.00 Spacetime Technologies
Sep11007
4111
Bolt-nut package
$ 3.55 4,800 $ 17,040.00 Alum Sheeting
Sep11008
1243
Airframe fasteners
$ 4.25 9,000 $ 38,250.00 Durrable Products
Sep11009
7258
Pressure Gauge
$ 90.00 120 $ 10,800.00 Steelpin Inc.
Sep11010
5234
Electrical Connector
$ 1.65 4,750 $ 7,837.50 Hulkey Fasteners
Sep11011
1122
Airframe fasteners
$ 4.25 12,500 $ 53,125.00 Hulkey Fasteners
Sep11012
5066
Shielded Cable/ft.
$ 0.95 25,000 $ 23,750.00 Hulkey Fasteners
Sep11013
3166
Electrical Connector
$ 1.25 5,650 $ 7,062.50 Hulkey Fasteners
Sep11014
1122
Airframe fasteners
$ 4.25 15,000 $ 63,750.00 Spacetime Technologies
Sep11015
4111
Bolt-nut package
$ 3.55 4,585 $ 16,276.75 Hulkey Fasteners
Sep11016
3166
Electrical Connector
$ 1.25 5,425 $ 6,781.25 Fast-Tie Aerospace
Sep11017
6321
O-Ring
$ 2.45 1,200 $ 2,940.00 Steelpin Inc.
Sep11018
5319
Shielded Cable/ft.
$ 1.10 16,500 $ 18,150.00 Spacetime Technologies
Sep11019
4111
Bolt-nut package
$ 3.55 4,200 $ 14,910.00 Hulkey Fasteners
Sep11020
5066
Shielded Cable/ft.
$ 0.95 17,500 $ 16,625.00 Spacetime Technologies
Sep11021
9752
Gasket
$ 4.05 1,500 $ 6,075.00 Spacetime Technologies
Sep11022
4111
Bolt-nut package
$ 3.55 4,250 $ 15,087.50 Pylon Accessories
Sep11023
9764
Gasket
$ 3.75 1,980 $ 7,425.00 Pylon Accessories
Sep11024
9764
Gasket
$ 3.75 1,750 $ 6,562.50 Spacetime Technologies
Sep11025
9752
Gasket
$ 4.05 1,550 $ 6,277.50 Spacetime Technologies
Sep11026
4111
Bolt-nut package
$ 3.55 4,200 $ 14,910.00 Durrable Products
Sep11027
1369
Airframe fasteners
$ 4.20 15,000 $ 63,000.00 Manley Valve
Sep11028
6431
O-Ring
$ 2.85 1,300 $ 3,705.00 Fast-Tie Aerospace
Sep11029
6321
O-Ring
$ 2.45 2,500 $ 6,125.00 Pylon Accessories
Sep11030
9764
Gasket
$ 3.75 1,850 $ 6,937.50
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Durrable Products
Sep11031
1369
Airframe fasteners
$ 4.20 14,000 $ 58,800.00 Hulkey Fasteners
Sep11032
1122
Airframe fasteners
$ 4.25 14,500 $ 61,625.00 Pylon Accessories
Sep11033
9764
Gasket
$ 3.75 1,800 $ 6,750.00 Durrable Products
Sep11034
1369
Airframe fasteners
$ 4.20 10,000 $ 42,000.00 Spacetime Technologies
Oct11001
5125
Shielded Cable/ft.
$ 1.15 15,000 $ 17,250.00 Durrable Products
Oct11002
9399
Gasket
$ 3.65 1,250 $ 4,562.50 Manley Valve
Oct11003
6431
O-Ring
$ 2.85 1,350 $ 3,847.50 Pylon Accessories
Oct11004
6433
O-Ring
$ 2.95 1,500 $ 4,425.00 Fast-Tie Aerospace
Oct11005
5166
Electrical Connector
$ 1.25 5,650 $ 7,062.50 Hulkey Fasteners
Oct11006
1122
Airframe fasteners
$ 4.25 18,000 $ 76,500.00 Durrable Products
Oct11007
9399
Gasket
$ 3.65 1,450 $ 5,292.50 Spacetime Technologies
Oct11008
6489
O-Ring
$ 3.00 1,100 $ 3,300.00 Durrable Products
Oct11009
9399
Gasket
$ 3.65 1,985 $ 7,245.25 Spacetime Technologies
Oct11010
4111
Bolt-nut package
$ 3.55 4,600 $ 16,330.00 Durrable Products
Oct11011
4569
Bolt-nut package
$ 3.50 3,900 $ 13,650.00 Manley Valve
Oct11012
6431
O-Ring
$ 2.85 1,250 $ 3,562.50 Durrable Products
Oct11013
9399
Gasket
$ 3.65 1,470 $ 5,365.50 Durrable Products
Oct11014
5454
Control Panel
$ 220.00 550 $ 121,000.00 Spacetime Technologies
Oct11015
6489
O-Ring
$ 3.00 900 $ 2,700.00 Alum Sheeting
Oct11016
1243
Airframe fasteners
$ 4.25 10,500 $ 44,625.00 Steelpin Inc.
Oct11017
8008
Machined Valve
$ 645.00 100 $ 64,500.00 Manley Valve
Oct11018
7258
Pressure Gauge
$ 100.50 90 $ 9,045.00 Manley Valve
Oct11019
8148
Machined Valve
$ 655.50 125 $ 81,937.50 Hulkey Fasteners
Oct11020
1122
Airframe fasteners
$ 4.25 17,000 $ 72,250.00 Fast-Tie Aerospace
Oct11021
6321
O-Ring
$ 2.45 1,250 $ 3,062.50 Alum Sheeting
Oct11022
4224
Bolt-nut package
$ 3.95 4,500 $ 17,775.00 Durrable Products
Oct11023
5454
Control Panel
$ 220.00 500 $ 110,000.00 Manley Valve
Oct11024
7258
Pressure Gauge
$ 100.50 100 $ 10,050.00 Steelpin Inc.
Oct11025
8008
Machined Valve
$ 645.00 150 $ 96,750.00 Alum Sheeting
Oct11026
5417
Control Panel
$ 255.00 500 $ 127,500.00 Manley Valve
Oct11027
7258
Pressure Gauge
$ 100.50 95 $ 9,547.50 Alum Sheeting
Oct11028
5634
Side Panel
$ 185.00 150 $ 27,750.00 Durrable Products
Oct11029
5275
Shielded Cable/ft.
$ 1.00 25,000 $ 25,000.00 Fast-Tie Aerospace
Oct11030
6321
O-Ring
$ 2.45 1,500 $ 3,675.00 Fast-Tie Aerospace
Oct11031
5689
Side Panel
$ 175.00 155 $ 27,125.00 Hulkey Fasteners
Oct11032
1122
Airframe fasteners
$ 4.25 17,500 $ 74,375.00 Steelpin Inc.
Oct11033
5677
Side Panel
$ 195.00 130 $ 25,350.00 Steelpin Inc.
Oct11034
8008
Machined Valve
$ 645.00 120 $ 77,400.00 Spacetime Technologies
Oct11035
6489
O-Ring
$ 3.00 1,050 $ 3,150.00 Alum Sheeting
Oct11036
5634
Side Panel
$ 185.00 140 $ 25,900.00 Manley Valve
Nov11001
9977
Panel Decal
$ 1.00 525 $ 525.00 Manley Valve
Nov11002
9955
Door Decal
$ 0.55 150 $ 82.50 Fast-Tie Aerospace
Nov11003
5689
Side Panel
$ 175.00 150 $ 26,250.00 Fast-Tie Aerospace
Nov11004
7268
Pressure Gauge
$ 95.00 110 $ 10,450.00 Steelpin Inc.
Nov11005
5677
Side Panel
$ 195.00 120 $ 23,400.00 Manley Valve
Nov11006
9967
Hatch Decal
$ 0.85 550 $ 467.50 Fast-Tie Aerospace
Nov11007
7268
Pressure Gauge
$ 95.00 105 $ 9,975.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Fast-Tie Aerospace
Nov11008
5689
Side Panel
$ 175.00 175 $ 30,625.00 Steelpin Inc.
Nov11009
5677
Side Panel
$ 195.00 110 $ 21,450.00 Manley Valve
Nov11010
9955
Door Decal
$ 0.55 125 $ 68.75
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Order No.
Item Description
Cost per order
Aug11008
Pressure Gauge
$ 9,000.00 Sep11023
Gasket
$ 7,425.00 Oct11020
Airframe fasteners
$ 72,250.00
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help