Homework2_Q5

.xlsx

School

Stevens Institute Of Technology *

*We aren’t endorsed by this school

Course

500

Subject

Mechanical Engineering

Date

Oct 30, 2023

Type

xlsx

Pages

Uploaded by ChiefDogPerson928

Purchase Orders Supplier Order No. Item No. Item Description Item Cost Quantity Hulkey Fasteners Aug11001 1122 Airframe fasteners $ 4.25 19,500 Alum Sheeting Aug11002 1243 Airframe fasteners $ 4.25 10,000 Fast-Tie Aerospace Aug11003 5462 Shielded Cable/ft. $ 1.05 23,000 Fast-Tie Aerospace Aug11004 5462 Shielded Cable/ft. $ 1.05 21,500 Steelpin Inc. Aug11005 5319 Shielded Cable/ft. $ 1.10 17,500 Fast-Tie Aerospace Aug11006 5462 Shielded Cable/ft. $ 1.05 22,500 Steelpin Inc. Aug11007 4312 Bolt-nut package $ 3.75 4,250 Durrable Products Aug11008 7258 Pressure Gauge $ 90.00 100 Fast-Tie Aerospace Aug11009 6321 O-Ring $ 2.45 1,300 Fast-Tie Aerospace Aug11010 5462 Shielded Cable/ft. $ 1.05 22,500 Steelpin Inc. Aug11011 5319 Shielded Cable/ft. $ 1.10 18,100 Hulkey Fasteners Aug11012 3166 Electrical Connector $ 1.25 5,600 Hulkey Fasteners Aug11013 9966 Hatch Decal $ 0.75 500 Steelpin Inc. Aug11014 5234 Electrical Connector $ 1.65 4,500 Steelpin Inc. Sep11001 4312 Bolt-nut package $ 3.75 4,200 Alum Sheeting Sep11002 5417 Control Panel $ 255.00 406 Hulkey Fasteners Sep11003 3166 Electrical Connector $ 1.25 5,500 Steelpin Inc. Sep11004 5234 Electrical Connector $ 1.65 4,850 Steelpin Inc. Sep11005 4312 Bolt-nut package $ 3.75 4,150 Hulkey Fasteners Sep11006 1122 Airframe fasteners $ 4.25 15,500 Spacetime Technologies Sep11007 4111 Bolt-nut package $ 3.55 4,800 Alum Sheeting Sep11008 1243 Airframe fasteners $ 4.25 9,000 Durrable Products Sep11009 7258 Pressure Gauge $ 90.00 120 Steelpin Inc. Sep11010 5234 Electrical Connector $ 1.65 4,750 Hulkey Fasteners Sep11011 1122 Airframe fasteners $ 4.25 12,500 Hulkey Fasteners Sep11012 5066 Shielded Cable/ft. $ 0.95 25,000 Hulkey Fasteners Sep11013 3166 Electrical Connector $ 1.25 5,650 Hulkey Fasteners Sep11014 1122 Airframe fasteners $ 4.25 15,000 Spacetime Technologies Sep11015 4111 Bolt-nut package $ 3.55 4,585 Hulkey Fasteners Sep11016 3166 Electrical Connector $ 1.25 5,425 Fast-Tie Aerospace Sep11017 6321 O-Ring $ 2.45 1,200 Steelpin Inc. Sep11018 5319 Shielded Cable/ft. $ 1.10 16,500 Spacetime Technologies Sep11019 4111 Bolt-nut package $ 3.55 4,200 Hulkey Fasteners Sep11020 5066 Shielded Cable/ft. $ 0.95 17,500 Spacetime Technologies Sep11021 9752 Gasket $ 4.05 1,500 Spacetime Technologies Sep11022 4111 Bolt-nut package $ 3.55 4,250 Pylon Accessories Sep11023 9764 Gasket $ 3.75 1,980 Pylon Accessories Sep11024 9764 Gasket $ 3.75 1,750 Spacetime Technologies Sep11025 9752 Gasket $ 4.05 1,550 Spacetime Technologies Sep11026 4111 Bolt-nut package $ 3.55 4,200 Durrable Products Sep11027 1369 Airframe fasteners $ 4.20 15,000 Manley Valve Sep11028 6431 O-Ring $ 2.85 1,300 Fast-Tie Aerospace Sep11029 6321 O-Ring $ 2.45 2,500 Pylon Accessories Sep11030 9764 Gasket $ 3.75 1,850 Durrable Products Sep11031 1369 Airframe fasteners $ 4.20 14,000 Hulkey Fasteners Sep11032 1122 Airframe fasteners $ 4.25 14,500 Pylon Accessories Sep11033 9764 Gasket $ 3.75 1,800 Durrable Products Sep11034 1369 Airframe fasteners $ 4.20 10,000 Spacetime Technologies Oct11001 5125 Shielded Cable/ft. $ 1.15 15,000 Durrable Products Oct11002 9399 Gasket $ 3.65 1,250 Manley Valve Oct11003 6431 O-Ring $ 2.85 1,350

Pylon Accessories Oct11004 6433 O-Ring $ 2.95 1,500 Fast-Tie Aerospace Oct11005 5166 Electrical Connector $ 1.25 5,650 Hulkey Fasteners Oct11006 1122 Airframe fasteners $ 4.25 18,000 Durrable Products Oct11007 9399 Gasket $ 3.65 1,450 Spacetime Technologies Oct11008 6489 O-Ring $ 3.00 1,100 Durrable Products Oct11009 9399 Gasket $ 3.65 1,985 Spacetime Technologies Oct11010 4111 Bolt-nut package $ 3.55 4,600 Durrable Products Oct11011 4569 Bolt-nut package $ 3.50 3,900 Manley Valve Oct11012 6431 O-Ring $ 2.85 1,250 Durrable Products Oct11013 9399 Gasket $ 3.65 1,470 Durrable Products Oct11014 5454 Control Panel $ 220.00 550 Spacetime Technologies Oct11015 6489 O-Ring $ 3.00 900 Alum Sheeting Oct11016 1243 Airframe fasteners $ 4.25 10,500 Steelpin Inc. Oct11017 8008 Machined Valve $ 645.00 100 Manley Valve Oct11018 7258 Pressure Gauge $ 100.50 90 Manley Valve Oct11019 8148 Machined Valve $ 655.50 125 Hulkey Fasteners Oct11020 1122 Airframe fasteners $ 4.25 17,000 Fast-Tie Aerospace Oct11021 6321 O-Ring $ 2.45 1,250 Alum Sheeting Oct11022 4224 Bolt-nut package $ 3.95 4,500 Durrable Products Oct11023 5454 Control Panel $ 220.00 500 Manley Valve Oct11024 7258 Pressure Gauge $ 100.50 100 Steelpin Inc. Oct11025 8008 Machined Valve $ 645.00 150 Alum Sheeting Oct11026 5417 Control Panel $ 255.00 500 Manley Valve Oct11027 7258 Pressure Gauge $ 100.50 95 Alum Sheeting Oct11028 5634 Side Panel $ 185.00 150 Durrable Products Oct11029 5275 Shielded Cable/ft. $ 1.00 25,000 Fast-Tie Aerospace Oct11030 6321 O-Ring $ 2.45 1,500 Fast-Tie Aerospace Oct11031 5689 Side Panel $ 175.00 155 Hulkey Fasteners Oct11032 1122 Airframe fasteners $ 4.25 17,500 Steelpin Inc. Oct11033 5677 Side Panel $ 195.00 130 Steelpin Inc. Oct11034 8008 Machined Valve $ 645.00 120 Spacetime Technologies Oct11035 6489 O-Ring $ 3.00 1,050 Alum Sheeting Oct11036 5634 Side Panel $ 185.00 140 Manley Valve Nov11001 9977 Panel Decal $ 1.00 525 Manley Valve Nov11002 9955 Door Decal $ 0.55 150 Fast-Tie Aerospace Nov11003 5689 Side Panel $ 175.00 150 Fast-Tie Aerospace Nov11004 7268 Pressure Gauge $ 95.00 110 Steelpin Inc. Nov11005 5677 Side Panel $ 195.00 120 Manley Valve Nov11006 9967 Hatch Decal $ 0.85 550 Fast-Tie Aerospace Nov11007 7268 Pressure Gauge $ 95.00 105 Fast-Tie Aerospace Nov11008 5689 Side Panel $ 175.00 175 Steelpin Inc. Nov11009 5677 Side Panel $ 195.00 110 Manley Valve Nov11010 9955 Door Decal $ 0.55 125

Cost per order A/P Terms (Months) Order Date Arrival Date Order Numbe Item Descripti $ 82,875.00 30 08/05/11 08/13/11 Aug11008 Pressure Gaug $ 42,500.00 30 08/08/11 08/14/11 Sep11023 Gasket $ 24,150.00 30 08/10/11 08/15/11 Oct11020 Airframe fasten $ 22,575.00 30 08/15/11 08/22/11 $ 19,250.00 30 08/20/11 08/31/11 $ 23,625.00 30 08/20/11 08/26/11 $ 15,937.50 30 08/25/11 09/01/11 $ 9,000.00 45 08/25/11 08/28/11 $ 3,185.00 30 08/25/11 09/04/11 $ 23,625.00 30 08/25/11 09/02/11 $ 19,910.00 30 08/25/11 09/05/11 $ 7,000.00 30 08/25/11 08/29/11 $ 375.00 30 08/25/11 08/31/11 $ 7,425.00 30 08/28/11 09/05/11 $ 15,750.00 30 09/01/11 09/10/11 $ 103,530.00 30 09/01/11 09/10/11 $ 6,875.00 30 09/01/11 09/06/11 $ 8,002.50 30 09/02/11 09/11/11 $ 15,562.50 30 09/03/11 09/11/11 $ 65,875.00 30 09/04/11 09/12/11 $ 17,040.00 25 09/05/11 09/20/11 $ 38,250.00 30 09/05/11 09/12/11 $ 10,800.00 45 09/05/11 09/09/11 $ 7,837.50 30 09/05/11 09/13/11 $ 53,125.00 30 09/05/11 09/11/11 $ 23,750.00 30 09/05/11 09/12/11 $ 7,062.50 30 09/05/11 09/10/11 $ 63,750.00 30 09/08/11 09/15/11 $ 16,276.75 25 09/10/11 09/30/11 $ 6,781.25 30 09/10/11 09/15/11 $ 2,940.00 30 09/12/11 09/23/11 $ 18,150.00 30 09/15/11 10/05/11 $ 14,910.00 25 09/15/11 10/15/11 $ 16,625.00 30 09/15/11 09/22/11 $ 6,075.00 25 09/20/11 09/25/11 $ 15,087.50 25 09/20/11 10/10/11 $ 7,425.00 15 09/20/11 09/29/11 $ 6,562.50 15 09/20/11 09/25/11 $ 6,277.50 25 09/25/11 10/05/11 $ 14,910.00 25 09/25/11 10/25/11 $ 63,000.00 45 09/25/11 09/30/11 $ 3,705.00 30 09/25/11 10/01/11 $ 6,125.00 30 09/25/11 10/04/11 $ 6,937.50 15 09/25/11 10/05/11 $ 58,800.00 45 09/27/11 10/03/11 $ 61,625.00 30 09/28/11 10/03/11 $ 6,750.00 15 09/28/11 10/05/11 $ 42,000.00 45 09/29/11 10/04/11 $ 17,250.00 25 10/01/11 10/15/11 $ 4,562.50 45 10/01/11 10/06/11 $ 3,847.50 30 10/01/11 10/07/11

$ 4,425.00 15 10/01/11 10/10/11 $ 7,062.50 30 10/01/11 10/06/11 $ 76,500.00 30 10/01/11 10/08/11 $ 5,292.50 45 10/03/11 10/08/11 $ 3,300.00 25 10/05/11 10/10/11 $ 7,245.25 45 10/05/11 10/11/11 $ 16,330.00 25 10/05/11 10/19/11 $ 13,650.00 45 10/05/11 10/10/11 $ 3,562.50 30 10/05/11 10/10/11 $ 5,365.50 45 10/07/11 10/12/11 $ 121,000.00 45 10/09/11 10/14/11 $ 2,700.00 25 10/10/11 10/18/11 $ 44,625.00 30 10/10/11 10/17/11 $ 64,500.00 30 10/10/11 10/21/11 $ 9,045.00 30 10/10/11 10/17/11 $ 81,937.50 30 10/10/11 10/17/11 $ 72,250.00 30 10/11/11 10/19/11 $ 3,062.50 30 10/12/11 10/21/11 $ 17,775.00 30 10/15/11 10/20/11 $ 110,000.00 45 10/15/11 10/20/11 $ 10,050.00 30 10/15/11 10/24/11 $ 96,750.00 30 10/15/11 10/26/11 $ 127,500.00 30 10/20/11 10/27/11 $ 9,547.50 30 10/20/11 10/29/11 $ 27,750.00 30 10/25/11 11/03/11 $ 25,000.00 45 10/25/11 10/30/11 $ 3,675.00 30 10/25/11 11/02/11 $ 27,125.00 30 10/25/11 11/03/11 $ 74,375.00 30 10/25/11 11/03/11 $ 25,350.00 30 10/28/11 11/07/11 $ 77,400.00 30 10/28/11 11/04/11 $ 3,150.00 25 10/29/11 11/10/11 $ 25,900.00 30 10/29/11 11/04/11 $ 525.00 30 11/01/11 11/07/11 $ 82.50 30 11/01/11 11/06/11 $ 26,250.00 30 11/01/11 11/09/11 $ 10,450.00 30 11/01/11 11/12/11 $ 23,400.00 30 11/02/11 11/13/11 $ 467.50 30 11/05/11 11/11/11 $ 9,975.00 30 11/05/11 11/16/11 $ 30,625.00 30 11/05/11 11/15/11 $ 21,450.00 30 11/05/11 11/17/11 $ 68.75 30 11/05/11 11/10/11

Cost-per-order $ 9,000.00 $ 7,425.00 $ 72,250.00

Observation Cost per order x1 $2,700.00 x2 $19,250.00 x3 $15,937.50 x4 $18,150.00 x5 $23,400.00 x6 $15,750.00 x7 $17,775.00 x8 $127,500.00 x9 $42,500.00 x10 $103,530.00 x11 $6,075.00 x12 $3,300.00 x13 $6,277.50 x14 $17,250.00 x15 $3,150.00 x16 $14,910.00 x17 $4,562.50 x18 $5,292.50 x19 $121,000.00 x20 $5,365.50 x21 $7,245.25 x22 $15,087.50 x23 $14,910.00 x24 $16,330.00 x25 $110,000.00 x26 $13,650.00 x27 $63,000.00 x28 $3,562.50 x29 $9,547.50 x30 $525.00 x31 $3,847.50 x32 $17,040.00 x33 $16,276.75 x34 $3,705.00 x35 $10,050.00 x36 $467.50 x37 $82.50 x38 $4,425.00 x39 $38,250.00 x40 $15,562.50 x41 $27,750.00 x42 $25,900.00 x43 $44,625.00 x44 $7,425.00 x45 $9,000.00 x46 $10,800.00 x47 $58,800.00 x48 $25,000.00 x49 $42,000.00 x50 $3,185.00 x51 $2,940.00 x52 $6,125.00 x53 $3,062.50 x54 $3,675.00 x55 $26,250.00 x56 $10,450.00

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version