Question
Create a dynamic spreadsheet that not only answers the question of which option is best over a specific time frame, but is also flexible such
Create a dynamic spreadsheet that not only answers the question of which option is best over a specific time frame, but is also flexible such that changes in the values of variables can be easily made and new solutions provided. The scenario is this:You own a consulting business and you travel frequently. There are several airport parking options and you'd like to be able to quickly determine for any given trip which option is the least expensive. Overnight parking at the airport is $11 per day; long-term parking near the airport is $9 per day; long-term parking farther from the airport is $7 per day. To get to the airport long-term parking, you must pay a toll of $4 each way and shuttle service to the airport is free. At the distant long-term parking, the shuttle is $20 round trip. Create an interactive spreadsheet that calculates the least expensive parking for trips of any length from 1 day on. Ifyour spreadsheet is built correctly, you should be able to change any of the values and have it recalculate.For example, how would it change if you got anEZPassand a resident's discount of 25% on thetolls? If you know how to use the VLOOKUP and/or the HLOOKUP functions in Excel, you can even create a cell that results in the type of parking that is least expensive. (Hint: use the MIN function to determine the least expensive option).Upload your spreadsheet file just as you have your document files, please save the file asLastNameFirstInitial_BFIN515_1 (so mine would beWladkowskiM_BFIN515_1.xls). Good luck!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started