revised hw.

profilejontha2
yourworksheet.xls

YourSample - Table 1

Name Job Title Sales Sales Assoc Bonus Admin Asst Bonus All Bonuses Number of Sales Assoc
Carol Troup Sales Assoc $26,000
Dan Park Admin Asst $17,900 Number of Admin Asst
David Jaffe Intern $0
Jim Hance Sales Assoc $16,600 Number of Sales Assoc with bonuses less than 10,000 and sales more than 50,000
Matin Berka Sales Assoc $81,500
Mike Ray VP Marketing $13,800
Peter Houston Sales Assoc $50,400 3
Steve Masters Intern $0
Toby Lange Sales Assoc $17,100
Henriette Lee Sales Assoc $16,900
Jo Schmoe VP Marketing $60,700
Allen Cranston Intern $0
Heidi Moore Sales Assoc $71,000
Samual Smith Sales Assoc $33,400
Karen Lamont Admin Asst $32,400
Bruce O'Connor Sales Assoc $24,800
Michael Brown Sales Assoc $30,600
Jeremy Evens Sales Assoc $33,000
Paulina Prince Admin Asst $74,600

YourAssignment - Table 1

Companies with Purchases over $350 Million Get .01% Discount
Job Title Type of Company Year-to-Date Purchases ($million) Discount on Purchases Number of Healthcare Companies
Wegmans Health Healthcare $550.00
NetApp Technology $501.00 Number of Technology Companies
HilCorp Real Estate $413.00
Ultimate Software Technology $390.00 Number of Real Estate Companies
Google Technology $375.00
Camden Property Real Estate $350.00 Number of Healthcare companies with year-to-date purchases over $350 million
QualComm Technology $325.00
Burns & McCoy Healthcare $310.00
Schumacher Drugs Healthcare $300.00
Halliday Health Healthcare $550.00
Worthington Consultants Technology $501.00
Manse, Inc Real Estate $413.00
BB Software Technology $390.00
Apple Technology $375.00
IEC Realtors Real Estate $350.00
Comcast Technology $325.00
Williams & Borne Healthcare $310.00
Lily & Assoc Healthcare $300.00
Pearl Consultants Technology $413.00
Bell Tower, Inc Real Estate $390.00
ComSys Technology $375.00
Ciscom Technology $350.00
Blumenthal Real Estate $325.00
Mayer-Bowles Tech Technology $310.00
E.J. Morningsinde Healthcare $300.00
Lews, LTD Healthcare $300.00
Pholey Pharmaceuticals Healthcare $550.00
Boyle Tech Technology $501.00
Commercial Prepoerties Real Estate $413.00
Salisbury Security Technology $390.00
Donavan & Miles Tech Technology $375.00
Deck Real Estate Real Estate $350.00
ViraScan Technology $325.00
Samuelson Pharms Healthcare $590.00
Fogarty, LTD Healthcare $300.00
IdeaWare Technology $413.00
Yellowstone Cabins Real Estate $390.00
SoftPlat Technology $375.00
SystemApps Technology $600.00
Mountain Rural Property Real Estate $325.00
OLASistems Technology $475.00
Zimmerman & Associates Healthcare $300.00
Banfield Martin Distributors Healthcare $300.00