You are an IT Procurement Manager working for Wal-Mart. Your CPO has mandated 2018 savings of no less than $350,000 for IT Laptops with Dell, your current supplier. If this minimum savings target is not achieved, you are authorized to issue an RFP and source a new vendor. The Marketing Department has advised that in 2020, the total volume (number of devices) is projected to increase by 15%. NOTE: The information in this question will also apply for questions 41 to 46. It is recommended that you record your calculations and answers on a separate piece of paper so that you can refer to it, as needed. Supplier Device Name SKU 2019 (current) Price per Device $589 2019 (current) Number of Devices 150 2019 Total Cost 2020 Number of Devices 2020 Baseline 2020 New Price per New Total Cost 2020 Projected Savings for 2020 Device Dell STGHY9 Dell 647TTL $699 Vostro Laptop Latitude E5530 Laptop Precision Desktop OptiPlex Tablet 250 Dell 233 CTFG11 88JU98 $399 $252 Dell $92,967 $167,328 267.95 763.6 $106,912 S192,427 $319.20 $201.60 585,530 S153,942 $21,382 $38,485 664 TOTAL What is the 2019 Total Cost of all Devices with Dell? $523,395 $1,297 $601,904 None of the above du ENG o te & * Question 41 (3 points) Considering all of the information provided from question 40, given volume is expected to increase by 15%, what is the expected total Number of Devices for 2020? 1491.55 1501.52 958.77 1297.00 Question 42 (5 points) Considering all of the information provided from question 40, what is the total dollar value of the 2020 Baseline? $601,904 $705,433 $523,395 $481,523 SIDAN O ENG O Rie hp Considering all of the information provided from question 40, what is the expected cost increase in 2020 (when compared to 2019)? $103,529 There is not cost increase; it's a decrease $41,872 $78,509 Question 44 (5 points) Considering all of the information provided from question 40: you have just completed negotiations with Dell, using the potential of an RFP as leverage. As a result of your efforts, Dell agreed to reduce their current Price per Device by a whopping 20%. What is the expected New Total Cost for 2020? $481,523 $601,904 $705,433 S523,395 ENG 9:10 AM 22.00 hp Question 45 (5 points) Considering all of the information provided from question 40, what would be the Projected Savings for 2020? $120,381 $103,529 There are no savings; costs have increased $78,509 Question 46 (3 points) Considering all of the information provided from question 40, based on the Projected Savings target for 2020, will you be issuing an RFP to source a new vendor? No Yes