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.
<colgroup><col span="7"></colgroup><tbody>
</tbody>
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.
The 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. | ||||||
After Looking through the details of both Rental Car, following action are to be made: | ||||||
● Construct a spreadsheet model to anaylze the two choices. Sketch the influence diagram of your model. | ||||||
● It is likey 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. | ||||||
● At what travel distances will you be indifferent to either rental company? | ||||||
If the trip is longer than 5 days, will the indifferent distance be longer or shorter |
<colgroup><col span="7"></colgroup><tbody>
</tbody>
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?)