CuriousMonkeyTan
New Member
- Joined
- Aug 20, 2019
- Messages
- 1
Hi all to paint the context i not here to seek for answers but for guidance:
Below is the following question.[TABLE="width: 490"]
<colgroup><col span="7"></colgroup><tbody>[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]The Popular rental car companies in town are Goldee and Supreme.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]Goldee charges $195.99 per day plus $0.85 per kilometer, and Supreme Charges $175.99 a day plus $1.29 per Kilometer.[/TD]
[/TR]
[TR]
[TD="colspan: 5"]You are taking a trip upcountry and will need to rent a car.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]After Looking through the details of both Rental Car, following action are to be made:[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]● Construct a spreadsheet model to anaylze the two choices. Sketch the influence diagram of your model.[/TD]
[/TR]
[TR]
[TD="colspan: 7"]● It is likey that this trip will span 3 to 5 days and involve a significant amount of driving. [/TD]
[/TR]
[TR]
[TD="colspan: 5"] Which company should you go with? Explain your choice.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]● At what travel distances will you be indifferent to either rental company? [/TD]
[/TR]
[TR]
[TD="colspan: 7"] If the trip is longer than 5 days, will the indifferent distance be longer or shorter[/TD]
[/TR]
</tbody>[/TABLE]
1) I have managed to created two 2D Tables for each of the companies (Supreme and Goldee). Where it shows the computed price of both
independent clause ( Rental Price of Car and Total Travelling Cost depending on Days)
2) Right now i am currently trying to plot a graph to serve as a presentation of the break even point where Supreme is better than Goldee over time. However, after searching on youtube and google i can'ts seem to find a guide on how to make a single graph from two 2D Tables
3) Lastly would it be better to use Goal Seek/ Solver to proves the the last 2 question which is (At what travel distances will you be indifferent to either rental company?)
Below is the following question.[TABLE="width: 490"]
<colgroup><col span="7"></colgroup><tbody>[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 6"]The Popular rental car companies in town are Goldee and Supreme.[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]Goldee charges $195.99 per day plus $0.85 per kilometer, and Supreme Charges $175.99 a day plus $1.29 per Kilometer.[/TD]
[/TR]
[TR]
[TD="colspan: 5"]You are taking a trip upcountry and will need to rent a car.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]After Looking through the details of both Rental Car, following action are to be made:[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]● Construct a spreadsheet model to anaylze the two choices. Sketch the influence diagram of your model.[/TD]
[/TR]
[TR]
[TD="colspan: 7"]● It is likey that this trip will span 3 to 5 days and involve a significant amount of driving. [/TD]
[/TR]
[TR]
[TD="colspan: 5"] Which company should you go with? Explain your choice.[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 7"]● At what travel distances will you be indifferent to either rental company? [/TD]
[/TR]
[TR]
[TD="colspan: 7"] If the trip is longer than 5 days, will the indifferent distance be longer or shorter[/TD]
[/TR]
</tbody>[/TABLE]
1) I have managed to created two 2D Tables for each of the companies (Supreme and Goldee). Where it shows the computed price of both
independent clause ( Rental Price of Car and Total Travelling Cost depending on Days)
2) Right now i am currently trying to plot a graph to serve as a presentation of the break even point where Supreme is better than Goldee over time. However, after searching on youtube and google i can'ts seem to find a guide on how to make a single graph from two 2D Tables
3) Lastly would it be better to use Goal Seek/ Solver to proves the the last 2 question which is (At what travel distances will you be indifferent to either rental company?)