BUSN250 Wk2

xlsx

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

Report
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