Project - Review-complete2

xlsx

School

Oregon State University, Corvallis *

*We aren’t endorsed by this school

Course

240

Subject

Industrial Engineering

Date

Dec 6, 2023

Type

xlsx

Pages

32

Uploaded by KidSharkPerson958

Report
Eugene Property Co. Prop ID Property Date Listed Date Sold Days on Market 2020-001 796 Lexington Aven 9/1/2020 3/8/2021 188 2020-002 2 Plymouth Lane 8/25/2020 11/19/2020 86 2020-003 951 Birch Hill Drive 12/27/2020 5/11/2021 135 2020-004 339 West Summer D 11/8/2020 3/1/2021 113 2020-005 480 S. Foxrun Lane 9/13/2020 11/18/2020 66 2020-006 60 Fifth Drive 8/23/2020 10/27/2020 65 2020-007 74 Ocean Street 9/23/2020 4/3/2021 192 2020-008 8666 Clark St. 9/24/2020 1/5/2021 103 2020-009 9857 N. Prospect Av 11/21/2020 3/21/2021 120 2020-010 9551 Edgemont Ave 10/28/2020 4/25/2021 179 2020-011 9385 Windsor Ave. 8/23/2020 12/21/2020 120 2020-012 350 East Peachtree 9/16/2020 3/19/2021 184 2020-013 8733 John Street 9/2/2020 2/27/2021 178
List Price Sold Price $ 339,098 $ 359,444 $ 368,654 $ 361,281 $ 475,944 $ 456,906 $ 246,125 $ 211,668 $ 469,559 $ 417,908 $ 392,788 $ 408,500 $ 580,693 $ 522,624 $ 221,984 $ 208,665 $ 257,021 $ 251,881 $ 469,066 $ 478,447 $ 557,131 $ 562,702 $ 593,023 $ 587,093 $ 221,684 $ 186,215
24084
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
Name Tour Package Cost Trip Insurance Hopkins Silver $ 1,200 Yes $ 1,416 Ellis Gold $ 2,100 Yes $ 2,478 Stewart Platinum $ 3,000 No $ 3,000 Marshall Silver $ 1,200 No $ 1,200 Garza Platinum $ 3,000 Yes $ 3,540 Schmidt Gold $ 2,100 No $ 2,100 Hayes Platinum $ 3,000 Yes $ 3,540 Totals $ 1,200 $ 17,274 Tour Package Cost Silver $ 1,200 Gold $ 2,100 Platinum $ 3,000 Trip Insurance 18% Total Per Person
24084
Name Tour Total Hopkins 1416 4 $ 5,664 0.025 $ 5,806 Ellis 2478 4 $ 9,912 0.035 $ 10,259 Stewart 3000 3 $ 9,000 0.035 $ 9,315 Marshall 1200 4 $ 4,800 0.02 $ 4,896 Garza 3540 2 $ 7,080 0.03 $ 7,292 Schmidt 2100 4 $ 8,400 0.03 $ 8,652 Hayes 3540 3 $ 10,620 0.04 $ 11,045 Tour Total 0 0.0% 3000 2.0% 5000 2.5% 7000 3.0% 9000 3.5% 10000 4.0% Total Per Person # of People Agent Commison Total with Agent Commssion Agent Commison
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
24084
Member Name: Ellis Total Due: $10,259 Down Payment: 2000 Financing Offer: 3 years @ 8.5% APR Total Due $ 10,259 Down Payment $ 2,000 Principal (PV) $ 8,259 Annual Interest Rate 8.5% Monthly Rate (Rate) 0.007083333333333 Years 3 Number of Monthly Payments (NPER) 36 Monthly Payment (PMT) ($260.72)
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
24084
Six-year Rates for Freshman OSU PSU SOU UO ALL 2005 66.80% 43.30% 46.00% 72.60% 57.18% 2006 65.80% 47.30% 41.30% 72.80% 56.80% 2007 68.70% 43.70% 45.10% 72.50% 57.50% 2008 69.80% 46.80% 47.70% 73.60% 59.48% 2009 70.00% 46.70% 45.60% 76.00% 59.58% 2010 68.90% 51.90% 45.50% 76.80% 60.78% Source: HECC Research and Data - SCARF 2005 2006 2007 0.00% 10.00% 20.00% 30.00% 40.00% 50.00% 60.00% 70.00% 80.00% Six-year Public University Graduation R OSU PSU S
2008 2009 2010 Rates for Resident First-time Freshman SOU UO ALL
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
24084
Six-year Rates for Freshman OSU PSU SOU UO ALL 2005 54.30% 40.50% 39.70% 65.00% 54.90% 2006 63.40% 41.10% 42.00% 67.40% 58.60% 2007 57.70% 48.50% 49.10% 66.20% 57.40% 2008 59.80% 39.90% 47.20% 69.60% 60.40% 2009 62.50% 43.20% 47.30% 73.70% 62.10% 2010 61.30% 50.80% 47.10% 72.00% 62.90% Source: HECC Research and Data - SCARF 2005 2006 2007 2008 2009 2010 54.90% A
% 58.60% 57.40% 60.40% 62.10% 62.90% ALL
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
24084
Six-year Rates for Freshman OSU PSU SOU UO ALL 2005 66.80% 43.30% 46.00% 72.60% 57.18% 2006 65.80% 47.30% 41.30% 72.80% 56.80% 2007 68.70% 43.70% 45.10% 72.50% 57.50% 2008 69.80% 46.80% 47.70% 73.60% 59.48% 2009 70.00% 46.70% 45.60% 76.00% 59.58% 2010 68.90% 51.90% 45.50% 76.80% 60.78% Source: HECC Research and Data - SCARF 2005 2006 2007 35% 40% 45% 50% 55% 60% 65% 70% 75% 80% Six-year Public University Graduation Ra OSU PSU
2008 2009 2010 ates for Resident First-time Freshman SOU UO
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
24084
Six-year Public University Graduation Rates for Resident First-time Freshman 2005 2006 2007 2008 2009 2010 OSU 66.80% 65.80% 68.70% 69.80% 70.00% 68.90% PSU 43.30% 47.30% 43.70% 46.80% 46.70% 51.90% SOU 46.00% 41.30% 45.10% 47.70% 45.60% 45.50% UO 72.60% 72.80% 72.50% 73.60% 76.00% 76.80% ALL 57.18% 56.80% 57.50% 59.48% 59.58% 60.78% Source: HECC Research and Data - SCARF
24084
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
Customer Name Order ID Product ID Lycoris Saunders CA-2011-130813 OFF-PA-10002005 Michael Moore CA-2011-118192 OFF-PA-10002947 Ionia McGrath CA-2011-102645 OFF-PA-10001804 Steven Roelle CA-2011-164903 OFF-PA-10003363 Sue Ann Reed CA-2011-133354 OFF-PA-10001800 Nicole Hansen CA-2011-111157 OFF-PA-10000327 Aimee Bixby CA-2011-169061 OFF-PA-10001878 Dean Katz CA-2011-157623 OFF-PA-10001204 Christine Phan US-2011-148838 OFF-PA-10000919 Christine Phan US-2011-148838 OFF-PA-10002960 Quincy Jones CA-2011-127859 OFF-PA-10003641 Beth Fritzler CA-2011-148040 OFF-PA-10002581 Carlos Daly CA-2011-147235 OFF-PA-10004948 Andy Yotov CA-2011-102652 OFF-PA-10001977 Andy Yotov CA-2011-102652 OFF-PA-10003309 Nathan Mautz CA-2011-111857 OFF-PA-10001878 Ted Trevino CA-2011-164224 OFF-PA-10001526 Frank Gastineau CA-2011-152443 OFF-PA-10003022 Total
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
Product Name Order Date Ship Date Days Xerox 225 1/7/2012 1/9/2012 2 Xerox 1923 1/14/2012 1/19/2012 5 Xerox 195 1/24/2012 1/29/2012 5 Xerox 204 2/21/2012 2/25/2012 4 Xerox 220 2/23/2012 2/25/2012 2 Xerox 1971 3/2/2012 3/6/2012 4 Xerox 1891 3/5/2012 3/8/2012 3 Xerox 1972 3/14/2012 3/18/2012 4 Xerox 1918 3/17/2012 3/21/2012 4 Xerox 1926 3/17/2012 3/21/2012 4 Xerox 1909 3/17/2012 3/20/2012 3 Xerox 1951 3/22/2012 3/26/2012 4 Xerox 190 3/24/2012 3/28/2012 4 Xerox 194 4/6/2012 4/12/2012 6 Xerox 211 4/6/2012 4/12/2012 6 Xerox 1891 4/23/2012 4/26/2012 3 Xerox 1949 5/18/2012 5/20/2012 2 Xerox 1992 5/21/2012 5/26/2012 5
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
Category Sub-Category Region State City Discount Office Supplies Paper West California East Los Angeles 0 Office Supplies Paper East Ohio Newark 0.2 Office Supplies Paper West Nevada Las Vegas 0 Office Supplies Paper West California East Los Angeles 0 Office Supplies Paper West California Moreno Valley 0 Office Supplies Paper East PennsylvaniaPhiladelphia 0.2 Office Supplies Paper East New York Yonkers 0 Office Supplies Paper West California Huntington Beach 0 Office Supplies Paper East New York New York City 0 Office Supplies Paper East New York New York City 0 Office Supplies Paper East PennsylvaniaPhiladelphia 0.2 Office Supplies Paper West Arizona Tucson 0.2 Office Supplies Paper East New York New York City 0 Office Supplies Paper West California East Los Angeles 0 Office Supplies Paper West California East Los Angeles 0 Office Supplies Paper West California San Francisco 0 Office Supplies Paper East Ohio Akron 0.2 Office Supplies Paper East MassachusetLawrence 0 0.05555556
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
Profit Quantity Sales Shipping Cost 9.3312 3 19.44 4.37 13.0928 7 37.408 1.46 19.2384 6 40.08 4.31 6.2208 2 12.96 1.14 9.3312 3 19.44 5.01 1.07 1 3.424 0.41 45.9754 2 97.82 10.13 4.752 2 10.56 1.23 75.9696 4 155.04 3.7 16.3842 7 34.86 3.61 41.1528 6 126.624 27.1 23.235 3 74.352 3.02 11.703 5 24.9 1.85 26.6304 1 55.48 2.28 9.3312 3 19.44 2.11 22.9877 1 48.91 4.34 5.7768 4 15.936 3.85 8.7906 3 17.94 1.22 350.9731 63 814.614
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
24084
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
Questions Score Data in cell(s): A1, in worksheet: Properties 1 Data in cell(s): A1:G1, in worksheet: Properties 1 Data in cell(s): B8, in worksheet: Properties 1 Data in cell(s): A5:A17, in worksheet: Properties 1 Data in cell(s): C5:C17, in worksheet: Properties 1 Data in cell(s): C5:C17, in worksheet: Properties 1 Data in cell(s): D5:D17, in worksheet: Properties 1 Data in cell(s): E5:E17, in worksheet: Properties 1 Data in cell(s): $5:$17, in worksheet: Properties 1 Data in cell(s): $A:$G, in worksheet: Properties 1 Data in cell(s): A4:G17, in worksheet: Properties 1 Data in cell(s): C2:C8, in worksheet: Tours 0.5 Data in cell(s): E2:E8, in worksheet: Tours 1 Data in cell(s): C10, in worksheet: Tours 1 Data in cell(s): E10, in worksheet: Tours 1 Data in cell(s): D2:D8, in worksheet: Commission 1 Data in cell(s): E2:E8, in worksheet: Commission 0.5 Data in cell(s): F2:F8, in worksheet: Commission 1 Data in cell(s): B12, in worksheet: Payment Plans 1 Data in cell(s): B14, in worksheet: Payment Plans 1 Data in cell(s): B16, in worksheet: Payment Plans 1 Data in cell(s): B17, in worksheet: Payment Plans 1 Data in cell(s): CHART EXISTS, in worksheet: Column 1 Data in cell(s): CHART PROPERTIES, in worksheet: Column 1 Data in cell(s): CHART PROPERTIES, in worksheet: Column 1 Data in cell(s): CHART PROPERTIES, in worksheet: Column 1 Data in cell(s): CHART EXISTS, in worksheet: Bar 1 Data in cell(s): CHART PROPERTIES, in worksheet: Bar 1 Data in cell(s): CHART PROPERTIES, in worksheet: Bar 1 Data in cell(s): CHART EXISTS, in worksheet: Line 1 Data in cell(s): CHART PROPERTIES, in worksheet: Line 1 Data in cell(s): CHART PROPERTIES, in worksheet: Line 1 Data in cell(s): CHART PROPERTIES, in worksheet: Line 1 Data in cell(s): H4:H8, in worksheet: Sparklines 1 Data in cell(s): TABLE EXISTS, in worksheet: Orders 1 Data in cell(s): G1, in worksheet: Orders 1 Data in cell(s): G2:G501, in worksheet: Orders 1 Data in cell(s): H2:H501, in worksheet: Orders 1 Data in cell(s): I2:I501, in worksheet: Orders 1 Data in cell(s): COLUMN(Region), in worksheet: Orders 1 Data in cell(s): N502, in worksheet: Orders 1 Data in cell(s): O502, in worksheet: Orders 1
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
Data in cell(s): P502, in worksheet: Orders 1 Data in cell(s): M502, in worksheet: Orders 1 Data in cell(s): O306:O371, in worksheet: Orders 1 Data in cell(s): N306:N371, in worksheet: Orders 1 Total Score 45
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
Max Points 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
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
1 1 1 1 46
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
Feedback Check your answer. Your formula should look something like "=VLOOKUP(B2,$A$13:$B$15,2,FALSE)". Check your answer. Your formula should look something like "=VLOOKUP(D2,$A$13:$B$18,2,TRUE)".
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
97.8261%
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

Related Documents

Deron Wan's Quiz History_ Module 3 - Lesson 1_ Knowledge Check.pdf
Deron Wan's Quiz History_ Module 1 - Lesson 2_ Knowledge Check.pdf
Quiz 14 - FDA.pdf
Quiz -12.pdf
LP practice-1.pdf
Pickton Egg Company (1).pdf
BSBSUS501 Assessment.docx
HW8.docx
HW8.pdf
Assignments_Fall2023_IE410CS481.pdf
Homework 9.docx
Midterm Exam - Fall 2023.docx