In cells H2:H6, calculate the value of the adjusted salary package for each position over a two-

year period, including bonuses. The bonus does not need to be adjusted for location (multiplied

by location factor) because the employee plans to use the bonus toward a vacation. Assume

that the employee will receive a 3.5% raise after the first year of employment in the new

position.

Position	Location	Annual Salary	Cost of Living Multiplier	Monthly Car Payment	Adjusted Salary	Bonus	Total 2yr. Financial Package
Demand Planning Manager	New York	$ 84,250	$ 2	$ -	$ 40,081	$ 5,000