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?)
