You have a vendor, Central Perk, with various spend throughout the organization.
IT has the following quotes:
- Q-Monica:
- Term: 5/1/2019 – 6/30/2020
- Qty: 100
- Total: $30,116
- Product: iknow
- Q-Ross
- Term: 10/1/2017 – 6/30/2020
- Qty: 30,000
- Total: $82,500 with a one-time discount of $39,506
- Product: Pivot
Network Operations has the following quotes:
- Q-Chandler:
- Term: 6/30/2017-6/30/2020
- Qty: 800
- Total: $621,600
- Product: iknow
- Q-Rachel
- Term: 7/1/2019 – 6/30/2020
- Qty: 120,000
- Total: $138,273
- Product: Pivot
IT wants to add 500 licenses of a new product called Joey Doesn’t Share for an annual cost of $101,000 with their upcoming renewal. Both IT and NetOps would like a new 3-year deal with the same quantities as above, and the vendor has stated there is a 6% increase on the Pivot product, but they will waive the 3% YoY increase on the iKnow product. There is a $100k Professional Services implementation SOW that the vendor is discounting by 50% after negotiations.
Task: Please provide an excel analysis of the above scenario and a one-page overview slide to be shared with the business and your leadership.
