1.
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
Assignment Information
Name:
Company Discounts Assignment
Instructions
Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.
Get My Paper
1. Using conditional formulas, calculate company discounts at the rate of .01% for any company with purchases over $350 million.
· Learning objective: practice critical thinking and review spreadsheet technology
· See grading rubric.
Due Date
Points Possible
3. 100
Assignment Files
4. What-Your-Submission-Should-Look-Like.xlsx (
What-Your-Submission-Should-Look-Like.xlsx
)
5. Work on This Sheet (
Work on This Sheet
)
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 |
$
| 4 |
13.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
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 |
$1
| 3 |
,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 |
| courseworkhero.co.uk 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
Turn in your highest-quality paper
Get a qualified writer to help you with
“ revised hw. ”
Get high-quality paper
NEW! AI matching with writer
USA: +1(669)289-8683 
Sign in
