Assignment 6 GBA 327
kmftzne
GBAassignment6ch2_Evensworksheet.xlsx2.1
| Total science and engineering jobs in thousands: 2000 and projected 2010 | ||||
| PROJECTED INCREASE | ||||
| Occupation | 2000 | 2010 | Nominal | Percentage |
| Scientists | 3,241 | 5,301 | ||
| Life scientists | 184 | 218 | ||
| Mathematical/computer scientists | 2,408 | 4,308 | ||
| Computer specialists | 2,318 | 4,213 | ||
| Mathematical scientists | 89 | 95 | ||
| Physical scientists | 239 | 283 | ||
| Social scientists | 410 | 492 | ||
| Engineers | 1,465 | 1,603 | ||
| All occupations | 145,571 | 167,754 |
2.2
| ID | Store No. | Sales Region | Item No. | Item Description | Unit Price | Units Sold | Week Ending | Total Weekly Revenue | STORE NO | TOTAL SALES REVENUE | TOTAL SALES REVENUE |
| 1 | 1 | South | 2005 | 24" Monitor | $229.00 | 28 | October | $6,412.00 | 1 | ||
| 2 | 1 | South | 2005 | 24" Monitor | $229.00 | 30 | November | $6,870.00 | 2 | ||
| 3 | 1 | South | 2005 | 24" Monitor | $229.00 | 9 | December | $2,061.00 | 3 | ||
| 4 | 1 | South | 3006 | Wireless Keyboard | $19.95 | 30 | October | $598.50 | 4 | ||
| 5 | 1 | South | 3006 | Wireless Keyboard | $19.95 | 35 | November | $698.25 | 5 | ||
| 6 | 1 | South | 3006 | Wireless Keyboard | $19.95 | 39 | December | $778.05 | 6 | ||
| 7 | 1 | South | 6050 | PC Mouse | $8.95 | 28 | October | $250.60 | 7 | ||
| 8 | 1 | South | 6050 | PC Mouse | $8.95 | 3 | November | $26.85 | 8 | ||
| 9 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | December | $340.10 | using SUM | using SUMIF | |
| 10 | 1 | South | 8500 | Laptop | $849.95 | 25 | October | $21,248.75 | |||
| 11 | 1 | South | 8500 | Laptop | $849.95 | 27 | November | $22,948.65 | |||
| 12 | 1 | South | 8500 | Laptop | $849.95 | 33 | December | $28,048.35 | SALES REGION | TOTAL SALES REVENUE | TOTAL SALES REVENUE |
| 13 | 2 | South | 2005 | 24" Monitor | $229.00 | 8 | October | $1,832.00 | South | ||
| 14 | 2 | South | 2005 | 24" Monitor | $229.00 | 8 | November | $1,832.00 | North | ||
| 15 | 2 | South | 2005 | 24" Monitor | $229.00 | 10 | December | $2,290.00 | East | ||
| 16 | 2 | South | 3006 | Wireless Keyboard | $19.95 | 8 | October | $159.60 | using SUM | using SUMIF | |
| 17 | 2 | South | 3006 | Wireless Keyboard | $19.95 | 8 | November | $159.60 | |||
| 18 | 2 | South | 3006 | Wireless Keyboard | $19.95 | 8 | December | $159.60 | |||
| 19 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | October | $80.55 | |||
| 20 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | November | $80.55 | |||
| 21 | 2 | South | 6050 | PC Mouse | $8.95 | 8 | December | $71.60 | |||
| 22 | 2 | South | 8500 | Laptop | $849.95 | 18 | October | $15,299.10 | |||
| 23 | 2 | South | 8500 | Laptop | $849.95 | 18 | November | $15,299.10 | |||
| 24 | 2 | South | 8500 | Laptop | $849.95 | 20 | December | $16,999.00 | |||
| 25 | 3 | South | 2005 | 24" Monitor | $229.00 | 38 | October | $8,702.00 | |||
| 26 | 3 | South | 2005 | 24" Monitor | $229.00 | 30 | November | $6,870.00 | |||
| 27 | 3 | South | 2005 | 24" Monitor | $229.00 | 3 | December | $687.00 | |||
| 28 | 3 | South | 3006 | Wireless Keyboard | $19.95 | 30 | October | $598.50 | |||
| 29 | 3 | South | 3006 | Wireless Keyboard | $19.95 | 32 | November | $638.40 | |||
| 30 | 3 | South | 3006 | Wireless Keyboard | $19.95 | 33 | December | $658.35 | |||
| 31 | 3 | South | 6050 | PC Mouse | $8.95 | 25 | October | $223.75 | |||
| 32 | 3 | South | 6050 | PC Mouse | $8.95 | 5 | November | $44.75 | |||
| 33 | 3 | South | 6050 | PC Mouse | $8.95 | 26 | December | $232.70 | |||
| 34 | 3 | South | 8500 | Laptop | $849.95 | 28 | October | $23,798.60 | |||
| 35 | 3 | South | 8500 | Laptop | $849.95 | 27 | November | $22,948.65 | |||
| 36 | 3 | South | 8500 | Laptop | $849.95 | 29 | December | $24,648.55 | |||
| 37 | 4 | North | 2005 | 24" Monitor | $229.00 | 18 | October | $4,122.00 | |||
| 38 | 4 | North | 2005 | 24" Monitor | $229.00 | 20 | November | $4,580.00 | |||
| 39 | 4 | North | 2005 | 24" Monitor | $229.00 | 4 | December | $916.00 | |||
| 40 | 4 | North | 3006 | Wireless Keyboard | $19.95 | 12 | October | $239.40 | |||
| 41 | 4 | North | 3006 | Wireless Keyboard | $19.95 | 24 | November | $478.80 | |||
| 42 | 4 | North | 3006 | Wireless Keyboard | $19.95 | 36 | December | $718.20 | |||
| 43 | 4 | North | 6050 | PC Mouse | $8.95 | 29 | October | $259.55 | |||
| 44 | 4 | North | 6050 | PC Mouse | $8.95 | 11 | November | $98.45 | |||
| 45 | 4 | North | 6050 | PC Mouse | $8.95 | 38 | December | $340.10 | |||
| 46 | 4 | North | 8500 | Laptop | $849.95 | 21 | October | $17,848.95 | |||
| 47 | 4 | North | 8500 | Laptop | $849.95 | 24 | November | $20,398.80 | |||
| 48 | 4 | North | 8500 | Laptop | $849.95 | 30 | December | $25,498.50 | |||
| 49 | 5 | North | 2005 | 24" Monitor | $229.00 | 27 | October | $6,183.00 | |||
| 50 | 5 | North | 2005 | 24" Monitor | $229.00 | 25 | November | $5,725.00 | |||
| 51 | 5 | North | 2005 | 24" Monitor | $229.00 | 23 | December | $5,267.00 | |||
| 52 | 5 | North | 3006 | Wireless Keyboard | $19.95 | 80 | October | $1,596.00 | |||
| 53 | 5 | North | 3006 | Wireless Keyboard | $19.95 | 82 | November | $1,635.90 | |||
| 54 | 5 | North | 3006 | Wireless Keyboard | $19.95 | 75 | December | $1,496.25 | |||
| 55 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | October | $581.75 | |||
| 56 | 5 | North | 6050 | PC Mouse | $8.95 | 24 | November | $214.80 | |||
| 57 | 5 | North | 6050 | PC Mouse | $8.95 | 55 | December | $492.25 | |||
| 58 | 5 | North | 8500 | Laptop | $849.95 | 55 | October | $46,747.25 | |||
| 59 | 5 | North | 8500 | Laptop | $849.95 | 57 | November | $48,447.15 | |||
| 60 | 5 | North | 8500 | Laptop | $849.95 | 47 | December | $39,947.65 | |||
| 61 | 6 | East | 2005 | 24" Monitor | $229.00 | 24 | October | $5,496.00 | |||
| 62 | 6 | East | 2005 | 24" Monitor | $229.00 | 85 | November | $19,465.00 | |||
| 63 | 6 | East | 2005 | 24" Monitor | $229.00 | 56 | December | $12,824.00 | |||
| 64 | 6 | East | 3006 | Wireless Keyboard | $19.95 | 52 | October | $1,037.40 | |||
| 65 | 6 | East | 3006 | Wireless Keyboard | $19.95 | 58 | November | $1,157.10 | |||
| 66 | 6 | East | 3006 | Wireless Keyboard | $19.95 | 69 | December | $1,376.55 | |||
| 67 | 6 | East | 6050 | PC Mouse | $8.95 | 35 | October | $313.25 | |||
| 68 | 6 | East | 6050 | PC Mouse | $8.95 | 39 | November | $349.05 | |||
| 69 | 6 | East | 6050 | PC Mouse | $8.95 | 44 | December | $393.80 | |||
| 70 | 6 | East | 8500 | Laptop | $849.95 | 78 | October | $66,296.10 | |||
| 71 | 6 | East | 8500 | Laptop | $849.95 | 88 | November | $74,795.60 | |||
| 72 | 6 | East | 8500 | Laptop | $849.95 | 99 | December | $84,145.05 | |||
| 73 | 7 | East | 2005 | 24" Monitor | $229.00 | 34 | October | $7,786.00 | |||
| 74 | 7 | East | 2005 | 24" Monitor | $229.00 | 36 | November | $8,244.00 | |||
| 75 | 7 | East | 2005 | 24" Monitor | $229.00 | 35 | December | $8,015.00 | |||
| 76 | 7 | East | 3006 | Wireless Keyboard | $19.95 | 49 | October | $977.55 | |||
| 77 | 7 | East | 3006 | Wireless Keyboard | $19.95 | 47 | November | $937.65 | |||
| 78 | 7 | East | 3006 | Wireless Keyboard | $19.95 | 48 | December | $957.60 | |||
| 79 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | October | $402.75 | |||
| 80 | 7 | East | 6050 | PC Mouse | $8.95 | 42 | November | $375.90 | |||
| 81 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | December | $402.75 | |||
| 82 | 7 | East | 8500 | Laptop | $849.95 | 55 | October | $46,747.25 | |||
| 83 | 7 | East | 8500 | Laptop | $849.95 | 57 | November | $48,447.15 | |||
| 84 | 7 | East | 8500 | Laptop | $849.95 | 55 | December | $46,747.25 | |||
| 85 | 8 | East | 2005 | 24" Monitor | $229.00 | 18 | October | $4,122.00 | |||
| 86 | 8 | East | 2005 | 24" Monitor | $229.00 | 17 | November | $3,893.00 | |||
| 87 | 8 | East | 2005 | 24" Monitor | $229.00 | 23 | December | $5,267.00 | |||
| 88 | 8 | East | 3006 | Wireless Keyboard | $19.95 | 22 | October | $438.90 | |||
| 89 | 8 | East | 3006 | Wireless Keyboard | $19.95 | 18 | November | $359.10 | |||
| 90 | 8 | East | 3006 | Wireless Keyboard | $19.95 | 22 | December | $438.90 | |||
| 91 | 8 | East | 6050 | PC Mouse | $8.95 | 14 | October | $125.30 | |||
| 92 | 8 | East | 6050 | PC Mouse | $8.95 | 16 | November | $143.20 | |||
| 93 | 8 | East | 6050 | PC Mouse | $8.95 | 17 | December | $152.15 | |||
| 94 | 8 | East | 8500 | Laptop | $849.95 | 32 | October | $27,198.40 | |||
| 95 | 8 | East | 8500 | Laptop | $849.95 | 28 | November | $23,798.60 | |||
| 96 | 8 | East | 8500 | Laptop | $849.95 | 30 | December | $25,498.50 |
2.3
| Additional Fee Per Guest | Discount after 6 days | ||||||||||
| $ 20.00 | 10% | ||||||||||
| per day | |||||||||||
| ID | Guest First Name | Guest Last Name | Room | Room Type | Arrival Date | Departure Date | No of Guests | Daily Rate | Daily Rate Considering Number of Guests | Number of Days Stayed | Total Revenue |
| 1 | Barry | Lloyd | Hayes | Bay-window | 12/1/11 | 12/4/11 | 2 | $150.00 | $ 150.00 | 3 | $ 450.00 |
| 2 | Michael | Lunsford | Cleveland | Ocean | 12/1/11 | 12/9/11 | 3 | $112.50 | |||
| 3 | Kim | Kyuong | Coolidge | Bay-window | 12/4/11 | 12/7/11 | 1 | $150.00 | |||
| 4 | Edward | Holt | Washington | Ocean | 12/1/11 | 12/3/11 | 4 | $325.00 | |||
| 5 | Thomas | Collins | Lincoln | Ocean | 12/9/11 | 12/13/11 | 2 | $300.00 | |||
| 6 | Paul | Bodkin | Coolidge | Bay-window | 12/1/11 | 12/3/11 | 2 | $150.00 | |||
| 7 | Randall | Battenburg | Washington | Ocean | 12/4/11 | 12/12/11 | 2 | $292.50 | |||
| 8 | Calvin | Nowotney | Lincoln | Ocean | 12/2/11 | 12/4/11 | 1 | $300.00 | |||
| 9 | Homer | Gonzalez | Lincoln | Ocean | 12/5/11 | 12/7/11 | 5 | $320.00 | |||
| 10 | David | Sanchez | Jefferson | Bay-window | 12/5/11 | 12/7/11 | 2 | $175.00 | |||
| 11 | Buster | Whisler | Jackson | Ocean | 12/5/11 | 12/8/11 | 2 | $250.00 | |||
| 12 | Julia | Martines | Reagan | Bay-window | 12/10/11 | 12/15/11 | 1 | $150.00 | |||
| 13 | Samuel | Kim | Truman | Side | 12/20/11 | 12/30/11 | 3 | $112.50 | |||
| 14 | Arthur | Gottfried | Garfield | Side | 12/13/11 | 12/15/11 | 2 | $125.00 | |||
| 15 | Darlene | Shore | Arthur | Ocean | 12/24/11 | 12/31/11 | 5 | $198.00 | |||
| 16 | Carlyle | Charleston | Quincy Adams | Bay-window | 12/3/11 | 12/6/11 | 2 | $150.00 | |||
| 17 | Albert | Goldstone | Johnson | Ocean | 12/5/11 | 12/7/11 | 3 | $250.00 | |||
| 18 | Charlene | Tilson | Van Buren | Bay-window | 12/5/11 | 12/7/11 | 1 | $150.00 | |||
| 19 | Everett | Chad | Madison | Ocean | 12/10/11 | 12/14/11 | 2 | $275.00 | |||
| 20 | Gerald | Pittsfield | Roosevelt | Ocean | 12/5/11 | 12/7/11 | 2 | $275.00 | |||
| 21 | Jamal | Smith | Tyler | Bay-window | 12/20/11 | 12/23/11 | 2 | $150.00 | |||
| 22 | Louis | Paris | Jackson | Ocean | 12/10/11 | 12/14/11 | 1 | $250.00 | |||
| 23 | Nigel | Stratford | Eisenhower | Ocean | 12/14/11 | 12/16/11 | 2 | $200.00 | |||
| 24 | Peter | Willington | Grant | Ocean | 12/19/11 | 12/21/11 | 1 | $200.00 | |||
| 25 | Ronald | Cartier | Jefferson | Bay-window | 12/24/11 | 12/28/11 | 4 | $175.00 | |||
| 26 | Trista | Leven | Eisenhower | Ocean | 12/17/11 | 12/20/11 | 1 | $200.00 | |||
| 27 | Valerie | Snell | Adams | Bay-window | 12/3/11 | 12/6/11 | 1 | $150.00 | |||
| 28 | Walter | Acton | Polk | Side | 12/24/11 | 12/31/11 | 6 | $148.50 | |||
| 29 | Xavier | Trezza | McKinley | Side | 12/14/11 | 12/17/11 | 2 | $125.00 | |||
| 30 | Zachary | Miller | Washington | Ocean | 12/13/11 | 12/16/11 | 2 | $325.00 |
2.5
| Supplier | Order No. | Item No. | Item Description | Item Cost | Quantity | Cost per order | Order No. | Item Description | Cost per order |
| Spacetime Technologies | A0111 | 6489 | O-Ring | $ 3.00 | 900 | $ 2,700.00 | A1567 | ||
| Steelpin Inc. | A0115 | 5319 | Shielded Cable/ft. | $ 1.10 | 17,500 | $ 19,250.00 | C8854 | ||
| Steelpin Inc. | A0123 | 4312 | Bolt-nut package | $ 3.75 | 4,250 | $ 15,937.50 | A0207 | ||
| Steelpin Inc. | A0204 | 5319 | Shielded Cable/ft. | $ 1.10 | 16,500 | $ 18,150.00 | |||
| Steelpin Inc. | A0205 | 5677 | Side Panel | $ 195.00 | 120 | $ 23,400.00 | |||
| Steelpin Inc. | A0207 | 4312 | Bolt-nut package | $ 3.75 | 4,200 | $ 15,750.00 | |||
| Alum Sheeting | A0223 | 4224 | Bolt-nut package | $ 3.95 | 4,500 | $ 17,775.00 | |||
| Alum Sheeting | A0433 | 5417 | Control Panel | $ 255.00 | 500 | $ 127,500.00 | |||
| Alum Sheeting | A0443 | 1243 | Airframe fasteners | $ 4.25 | 10,000 | $ 42,500.00 | |||
| Alum Sheeting | A0446 | 5417 | Control Panel | $ 255.00 | 406 | $ 103,530.00 | |||
| Spacetime Technologies | A0533 | 9752 | Gasket | $ 4.05 | 1,500 | $ 6,075.00 | |||
| Spacetime Technologies | A0555 | 6489 | O-Ring | $ 3.00 | 1,100 | $ 3,300.00 | |||
| Spacetime Technologies | A0622 | 9752 | Gasket | $ 4.05 | 1,550 | $ 6,277.50 | |||
| Spacetime Technologies | A0666 | 5125 | Shielded Cable/ft. | $ 1.15 | 15,000 | $ 17,250.00 | |||
| Spacetime Technologies | A0777 | 6489 | O-Ring | $ 3.00 | 1,050 | $ 3,150.00 | |||
| Spacetime Technologies | A1222 | 4111 | Bolt-nut package | $ 3.55 | 4,200 | $ 14,910.00 | |||
| Durrable Products | A1234 | 9399 | Gasket | $ 3.65 | 1,250 | $ 4,562.50 | |||
| Durrable Products | A1235 | 9399 | Gasket | $ 3.65 | 1,450 | $ 5,292.50 | |||
| Durrable Products | A1344 | 5454 | Control Panel | $ 220.00 | 550 | $ 121,000.00 | |||
| Durrable Products | A1345 | 9399 | Gasket | $ 3.65 | 1,470 | $ 5,365.50 | |||
| Durrable Products | A1346 | 9399 | Gasket | $ 3.65 | 1,985 | $ 7,245.25 | |||
| Spacetime Technologies | A1444 | 4111 | Bolt-nut package | $ 3.55 | 4,250 | $ 15,087.50 | |||
| Spacetime Technologies | A1445 | 4111 | Bolt-nut package | $ 3.55 | 4,200 | $ 14,910.00 | |||
| Spacetime Technologies | A1449 | 4111 | Bolt-nut package | $ 3.55 | 4,600 | $ 16,330.00 | |||
| Durrable Products | A1456 | 5454 | Control Panel | $ 220.00 | 500 | $ 110,000.00 | |||
| Durrable Products | A1457 | 4569 | Bolt-nut package | $ 3.50 | 3,900 | $ 13,650.00 | |||
| Durrable Products | A1567 | 1369 | Airframe fasteners | $ 4.20 | 15,000 | $ 63,000.00 | |||
| Manley Valve | A2345 | 6431 | O-Ring | $ 2.85 | 1,250 | $ 3,562.50 | |||
| Manley Valve | A2356 | 7258 | Pressure Gauge | $ 100.50 | 95 | $ 9,547.50 | |||
| Manley Valve | A2367 | 9977 | Panel Decal | $ 1.00 | 525 | $ 525.00 | |||
| Manley Valve | A2378 | 6431 | O-Ring | $ 2.85 | 1,350 | $ 3,847.50 | |||
| Spacetime Technologies | A3467 | 4111 | Bolt-nut package | $ 3.55 | 4,800 | $ 17,040.00 | |||
| Spacetime Technologies | A5689 | 4111 | Bolt-nut package | $ 3.55 | 4,585 | $ 16,276.75 | |||
| Manley Valve | A9821 | 6431 | O-Ring | $ 2.85 | 1,300 | $ 3,705.00 | |||
| Manley Valve | A9842 | 7258 | Pressure Gauge | $ 100.50 | 100 | $ 10,050.00 | |||
| Manley Valve | A9865 | 9967 | Hatch Decal | $ 0.85 | 550 | $ 467.50 | |||
| Manley Valve | A9876 | 9955 | Door Decal | $ 0.55 | 150 | $ 82.50 | |||
| Pylon Accessories | A9999 | 6433 | O-Ring | $ 2.95 | 1,500 | $ 4,425.00 | |||
| Alum Sheeting | B0247 | 1243 | Airframe fasteners | $ 4.25 | 9,000 | $ 38,250.00 | |||
| Steelpin Inc. | B0445 | 4312 | Bolt-nut package | $ 3.75 | 4,150 | $ 15,562.50 | |||
| Alum Sheeting | B0447 | 5634 | Side Panel | $ 185.00 | 150 | $ 27,750.00 | |||
| Alum Sheeting | B0479 | 5634 | Side Panel | $ 185.00 | 140 | $ 25,900.00 | |||
| Alum Sheeting | B0567 | 1243 | Airframe fasteners | $ 4.25 | 10,500 | $ 44,625.00 | |||
| Pylon Accessories | B1111 | 9764 | Gasket | $ 3.75 | 1,980 | $ 7,425.00 | |||
| Durrable Products | B1234 | 7258 | Pressure Gauge | $ 90.00 | 100 | $ 9,000.00 | |||
| Durrable Products | B1345 | 7258 | Pressure Gauge | $ 90.00 | 120 | $ 10,800.00 | |||
| Durrable Products | B1468 | 1369 | Airframe fasteners | $ 4.20 | 14,000 | $ 58,800.00 | |||
| Durrable Products | B1589 | 5275 | Shielded Cable/ft. | $ 1.00 | 25,000 | $ 25,000.00 | |||
| Durrable Products | B1666 | 1369 | Airframe fasteners | $ 4.20 | 10,000 | $ 42,000.00 | |||
| Fast-Tie Aerospace | B2333 | 6321 | O-Ring | $ 2.45 | 1,300 | $ 3,185.00 | |||
| Fast-Tie Aerospace | B2345 | 6321 | O-Ring | $ 2.45 | 1,200 | $ 2,940.00 | |||
| Fast-Tie Aerospace | B2356 | 6321 | O-Ring | $ 2.45 | 2,500 | $ 6,125.00 | |||
| Fast-Tie Aerospace | B2367 | 6321 | O-Ring | $ 2.45 | 1,250 | $ 3,062.50 | |||
| Fast-Tie Aerospace | B2378 | 6321 | O-Ring | $ 2.45 | 1,500 | $ 3,675.00 | |||
| Fast-Tie Aerospace | B2498 | 5689 | Side Panel | $ 175.00 | 150 | $ 26,250.00 | |||
| Fast-Tie Aerospace | B2499 | 7268 | Pressure Gauge | $ 95.00 | 110 | $ 10,450.00 | |||
| Fast-Tie Aerospace | B2511 | 7268 | Pressure Gauge | $ 95.00 | 105 | $ 9,975.00 | |||
| Fast-Tie Aerospace | B2519 | 5462 | Shielded Cable/ft. | $ 1.05 | 22,500 | $ 23,625.00 | |||
| Fast-Tie Aerospace | B2528 | 5689 | Side Panel | $ 175.00 | 175 | $ 30,625.00 | |||
| Fast-Tie Aerospace | B2537 | 5462 | Shielded Cable/ft. | $ 1.05 | 21,500 | $ 22,575.00 | |||
| Fast-Tie Aerospace | B2566 | 5462 | Shielded Cable/ft. | $ 1.05 | 23,000 | $ 24,150.00 | |||
| Steelpin Inc. | B3022 | 5677 | Side Panel | $ 195.00 | 110 | $ 21,450.00 | |||
| Steelpin Inc. | B3041 | 5234 | Electrical Connector | $ 1.65 | 4,500 | $ 7,425.00 | |||
| Steelpin Inc. | B3042 | 5234 | Electrical Connector | $ 1.65 | 4,750 | $ 7,837.50 | |||
| Steelpin Inc. | B3111 | 5234 | Electrical Connector | $ 1.65 | 4,850 | $ 8,002.50 | |||
| Steelpin Inc. | B3222 | 8008 | Machined Valve | $ 645.00 | 150 | $ 96,750.00 | |||
| Steelpin Inc. | B3333 | 8008 | Machined Valve | $ 645.00 | 100 | $ 64,500.00 | |||
| Fast-Tie Aerospace | C0234 | 5166 | Electrical Connector | $ 1.25 | 5,650 | $ 7,062.50 | |||
| Fast-Tie Aerospace | C0423 | 5689 | Side Panel | $ 175.00 | 155 | $ 27,125.00 | |||
| Fast-Tie Aerospace | C0433 | 5462 | Shielded Cable/ft. | $ 1.05 | 22,500 | $ 23,625.00 | |||
| Steelpin Inc. | C0456 | 5677 | Side Panel | $ 195.00 | 130 | $ 25,350.00 | |||
| Steelpin Inc. | C0467 | 8008 | Machined Valve | $ 645.00 | 120 | $ 77,400.00 | |||
| Steelpin Inc. | C0589 | 5319 | Shielded Cable/ft. | $ 1.10 | 18,100 | $ 19,910.00 | |||
| Manley Valve | C1111 | 9955 | Door Decal | $ 0.55 | 125 | $ 68.75 | |||
| Hulkey Fasteners | C1212 | 1122 | Airframe fasteners | $ 4.25 | 19,500 | $ 82,875.00 | |||
| Hulkey Fasteners | C1313 | 3166 | Electrical Connector | $ 1.25 | 5,600 | $ 7,000.00 | |||
| Pylon Accessories | C2211 | 9764 | Gasket | $ 3.75 | 1,850 | $ 6,937.50 | |||
| Manley Valve | C2222 | 7258 | Pressure Gauge | $ 100.50 | 90 | $ 9,045.00 | |||
| Hulkey Fasteners | C2323 | 1122 | Airframe fasteners | $ 4.25 | 15,500 | $ 65,875.00 | |||
| Hulkey Fasteners | C2929 | 3166 | Electrical Connector | $ 1.25 | 5,500 | $ 6,875.00 | |||
| Hulkey Fasteners | C3232 | 1122 | Airframe fasteners | $ 4.25 | 18,000 | $ 76,500.00 | |||
| Manley Valve | C3333 | 8148 | Machined Valve | $ 655.50 | 125 | $ 81,937.50 | |||
| Hulkey Fasteners | C3434 | 1122 | Airframe fasteners | $ 4.25 | 12,500 | $ 53,125.00 | |||
| Hulkey Fasteners | C4545 | 1122 | Airframe fasteners | $ 4.25 | 15,000 | $ 63,750.00 | |||
| Hulkey Fasteners | C5656 | 1122 | Airframe fasteners | $ 4.25 | 14,500 | $ 61,625.00 | |||
| Hulkey Fasteners | C6765 | 5066 | Shielded Cable/ft. | $ 0.95 | 25,000 | $ 23,750.00 | |||
| Hulkey Fasteners | C7875 | 3166 | Electrical Connector | $ 1.25 | 5,650 | $ 7,062.50 | |||
| Hulkey Fasteners | C8854 | 3166 | Electrical Connector | $ 1.25 | 5,425 | $ 6,781.25 | |||
| Hulkey Fasteners | C8989 | 9966 | Hatch Decal | $ 0.75 | 500 | $ 375.00 | |||
| Pylon Accessories | D1111 | 9764 | Gasket | $ 3.75 | 1,800 | $ 6,750.00 | |||
| Hulkey Fasteners | D1212 | 5066 | Shielded Cable/ft. | $ 0.95 | 17,500 | $ 16,625.00 | |||
| Hulkey Fasteners | D2121 | 1122 | Airframe fasteners | $ 4.25 | 17,500 | $ 74,375.00 | |||
| Hulkey Fasteners | D3232 | 1122 | Airframe fasteners | $ 4.25 | 17,000 | $ 72,250.00 | |||
| Pylon Accessories | D3333 | 9764 | Gasket | $ 3.75 | 1,750 | $ 6,562.50 |
