revised hw.

jontha2
example..xls

Company Discounts - Table 1

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 4
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

Formulas - Table 1

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