Rent a car. The two popular rental car companies in town are Goldee and Supreme. Goldee charges $195.99 per day plus $0.85 per kilometer, and Supreme charges $175.99 a day plus $1.29 per kilometer. You are taking a trip upcountry and will need to rent a car.

a. Construct a spreadsheet model to analyze the two choices. Sketch the Influence diagram of your model.

b. It is likely that this trip will span 3 to 5 days and involve a significant amount of driving. Which company should you go with? Explain your choice.

c. At what travel distances will you be indifferent to the either rental company? If the trip is longer than 5 days, will the indifferent distance be longer or shorter?

Note: Use excel if possible. Thank you.