You learn from your boss that the corporation is planning to purchase at least 40 similar systems. Because of this volume, the following price reductions are now available:

. Dell has agreed to a rebate of 150 per machine.
. Sony has agreed to give an 18% across-the-board discount on everything but shipping, which remains at $46 per system.
.Lenovo has declined to give any volume purchase discount.

Skip at least two rows at the bottom of your current data. In separate area, calculate the total cost of a single machine from each competitor using this new pricing structure. Reference the values you have previously calculated as needed.