$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket?
Book Your Assignment at The Lowest Price
Now!
Students Who Viewed This Also Studied
CST2330 Data Analysis for Enterprise Modelling
Task
1 The net present value (NPV) problem (10%)
A car manufacturer is looking to bring a new range of electric vehicles (EV) in the next fifive years. This will require an initial investment of £500M and has running costs of £100M per year after that. The predicted incomes from this range are:
Notice that the initial expenditure takes place in 2020.
1. Assume a discount rate of 1% per year, and perform analysis of discounted cashflflow. You should create a data table in R with variables Year, Outflflow and Inflflow in the fifirst three columns:
Write a function to analyse the cashflflow table
This function should modify the table by adding columns showing the net returns, the numbers of years to discount, the present value factors and the discounted returns. Your function must be able to take difffferent cashflflow tables and discount rates as the input, print the modifified cashflflow table and return the (total) net present value (NPV) for the investment. Include your code into the report. 5 marks
2. Decide whether or not this is a worthwhile investment, justifying your answer by your results. 1 mark
3. Calculate the NPV for discount rates of 2%, 3%, 4% and 5%, giving your answers to two decimal places. 1 mark
4. Plot NPV against the discount rates ranging from 0% to 5%. 1 mark
5. Use your graph to estimate the discount rate that would give an NPV of zero. What is the signifificance of this discount rate? (Hint: What happens at discount rates lower and higher than this fifigure?) 2 marks
2 Optimisation and linear programming (20%)
2.1 Solution using analysis and graphs (10%)
A car manufacturer produces conventional cars, which generate £4,000 profifit per car, and a newly developed EVs, which generate £5,000 per car. The objective is to maximise profifit by selecting the right combination of conventional cars and EVs, subject to the following constraints:
- The factory can produce up to 1,000 conventional cars and up to 500 EVs per day.
- The logistics and warehouse facilities do not allow for production of more than 750 vehicles per day in total (i.e. both conventional and EVs).
- The manufacturer has a contract to produce at least 100 conventional and 50 EVs per day.
Your task is to:
- Write the objective function. 1 mark
- Write the constraints for production and logistics. 2 marks
- Plot or draw the feasible region and the isoprofifit line. 3 marks
- Find the optimal numbers of conventional cars and EVs to be produced (the solution) in order to achieve the maximum profifit (the optimal value). 2 marks
- Explain the solution analytically or using the graph. 2 marks
2.2 Solution using solver (10%)
Assume that the manufacturer adds hybrid vehicles to their range, which generate £4,500 profifit per car. The factory can produce up to 1,000 hybrid cars per day, and there are no obligations to the smallest number. The warehouse constraints remain the same.
Your task is to:
- Write the updated objective function. 1 mark
- Write the updated constraints for production and logistics. 2 marks
- Use the lpSolve library in R to fifind the solution (an optimal combination of three types of cars) and the optimal value (the maximum profifit) to this problem. Include your code into the report. 5 marks
- What happens if the contract to supply at least 100 conventional cars is replaced by the same number of hybrid cars? 2 marks
3 Data import, plotting and transformation (20%)
In this task, you should use the crypto-candles dataset, which contains daily exchange rates between major crypto-currencies between Jan 2019—Sept 2020. This dataset can be downloaded from the data folder on the course’s webpage (My Learning). There are two versions of this dataset:
crypto-candles.csv
crypto-candles.db
The fifirst is a comma separated values (csv) fifile, and the second is an SQLite database. You can read the csv fifile with the read.csv command. Alternatively, you can connect to the database and read table candles from the db fifile using the dbReadTable command. You should assign the result to a variable, which you may call candles. Note that if you read data from the database, then the timestamps have to be converted into dates by the command:
CST2330 Data Analysis for Enterprise Modelling
Answer in Detail
Solved by qualified expert
Get Access to This Answer
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.
Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.
24 More Pages to Come in This Document. Get access to the complete answer.
Your search for do my essay cheap online online ends at MyAssignmenthelp.com. We are the only company in Australia which can boast of 3000+ PhD cheap essay writers who can handle even the most complicated of topics with ease. Despite our already affordable prices, we also offer attractive discounts on a regular basis. If you’re wondering who can write my essay cheap, MyAssignmenthelp.com is the answer. Your search for do my essay cheap online ends at MyAssignmenthelp.com. We are the only company in Australia which can boast of 3000+ PhD cheap essay writers who can handle even the most complicated of topics with ease. Despite our already affordable prices, we also offer attractive discounts on a regular basis. If you’re wondering who can write my essay cheap, MyAssignmenthelp.com is the answer.
More CST2330 CST2330 Data Analysis for Enterprise Modelling: Questions & Answers
Business Management
We need a ansys project which should having mesh contous graphics and solution . topic is like curing cancer by using ansys methods which is like curing tisssues in brain by heating or by cooling the tissues. and we need a reseach paper to be written by using the above project. …
View Answer
Management
Task You are required to find either a current or historically vulnerable software product in the GNU/Linux environment with an associated exploit. It is probable that any historical vulnerability may well have been patched. In this case, you will be required to also build an environment …
View Answer
Management
In this example, we will access a web api and create a dataframe out of it # Q: Use metaweather API to get average humidity in Boston over the next 5 days # Hint: You can use the following snippet to extract the woeid for Boston response = requests.get( ‘https://www.metaweather.com/api/location/sear …
View Answer
PHY408 Physics
1. Plot for and sec on the same graph with domain and .2. The analytical formula for the Fourier transform of isCompute the discrete Fourier transform (DFT) for both sampled time series, and compare them to the analytical for both ‘s on the same graph.Hints:As numpy fft assumes signal starts from ti …
View Answer
Content Removal Request
If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the
content removal request.
Choose Our Best Expert to Help You
Still in Two Minds? The Proof is in Numbers!
33845 Genuine Reviews With a Rating of 4.9/5.
Management
Essay: 8 Pages, Deadline:
16 days
Amazing work and I got a full mark on my assignment .thank you so much for your help
User ID: 9***1 United States
English
Home Work: 2 Pages, Deadline:
9 hours
Well done and on time. Very happy. Not graded yet but It looks good! I would recommend to my friends and classmates!
User ID: 8***56 United States
Healthcare
Essay: 8 Pages, Deadline:
7 days
That was good work done by the experts, the only problem was some spellings of some things, no plagiarism.
User ID: 3***08 Australia
Marketing
Home Work: 2 Pages, Deadline:
10 days
best grades i have ever seen thank you so much for this amazing experience and I will be back for more thank you so much
User ID: 3***37 Dubai, United Arab Emirates
Healthcare
Assignment: 6 Pages, Deadline:
4 days
there was no plagiarism, the work was done well and the expert was very good and proffessional
User ID: 3***08 Dubai, Australia
It Write Up
Assignment: 8.8 Pages, Deadline:
10 days
very nice report created. thank you so much. appreciate it a lot. hopefully i get a good grade
User ID: 5***95 Dubai, Australia
Healthcare
Essay: 4 Pages, Deadline:
20 days
Great expert did a good job on the solution and i am impressed. i want other experts to learn from this expert and always deliver the right assignment …
User ID: 2***97 Upper Marlboro, United States
HRM
Essay: 2 Pages, Deadline:
2 days
thank you for your help it was greatly appreciated and I received a 85 on my paper. definitely will be using services again
User ID: 6***74 Upper Marlboro, United States
Management
Essay: 3 Pages, Deadline:
1 day
I am glad about the service. they answer all your questions well, and the team is respectful. they are excellent at writing essays with fast delivery.
User ID: 7***54 Upper Marlboro, Canada
Project Management
Assignment: 8 Pages, Deadline:
20 days
I am pleased with the marks I received on this particular assignment. Thank you!
User ID: 6***97 United Kingdom, Great Britain
Accounting
Home Work: 14 Pages, Deadline:
10 days
Got a good grade. Nice work. Had support until the delivery of assignment and delivered work a few days before than promised.
User ID: 7***68 United Kingdom, Great Britain
Electronics
Home Work: 5 Pages, Deadline:
7 days
I am so satisfied. Great job. Recommended. Fast delivery and smart experts……
User ID: 8***52 United Kingdom, Norway
Nursing
Assignment: 4.8 Pages, Deadline:
8 days
It was very well structured and all the instructions were followed.. The order was also completed on time. minimal grammatical mistakes.
User ID: 7***50 United Kingdom, Australia
Psychology
Home Work: 2 Pages, Deadline:
1 day
This is a really good service, It is rare to have them miss the assignment. I always come back with at least an 85
User ID: 4***21 Charlotte, United States
Psychology
Assignment: 1 Page, Deadline:
1 day
This is a really good service, It is rare to have them miss the assignment. I always come back with at lease an 85
User ID: 4***21 Charlotte, United States
Maths
Assignment: 2 Pages, Deadline:
4 days
helped me so much when I was at a time crunch, and they really pulled through for me
User ID: 5***12 Charlotte, United States
Statistics
Assignment: 5 Pages, Deadline:
12 days
Great service and perfect work and fast feedbacks as well i have no doubt in the work
User ID: 2***25 Khobar, Saudi Arabia
Marketing
Assignment: 1 Page, Deadline:
6 days
Got help from this expert for this assignment. I got an A and was very pleased with the help and grade. Will use again.
User ID: 5***56 San Francisco, United States
Property Law
Assignment: 12 Pages, Deadline:
12 days
Just received very good marks. Very happy with his service. Answer all questions nicely and all require points are included and good eassy writing sty …
User ID: 6***34 San Francisco, Singapore
Project Management
Assignment: 6 Pages, Deadline:
1 day
I got my assignment delivered before the deadline, and it was an excellent job done.
User ID: 8***21 San Francisco, Nigeria
Management
Essay: 8 Pages, Deadline:
16 days
Amazing work and I got a full mark on my assignment .thank you so much for your help
User ID: 9***1 United States
English
Home Work: 2 Pages, Deadline:
9 hours
Well done and on time. Very happy. Not graded yet but It looks good! I would recommend to my friends and classmates!
User ID: 8***56 United States
Healthcare
Essay: 8 Pages, Deadline:
7 days
That was good work done by the experts, the only problem was some spellings of some things, no plagiarism.
User ID: 3***08 Australia
Marketing
Home Work: 2 Pages, Deadline:
10 days
best grades i have ever seen thank you so much for this amazing experience and I will be back for more thank you so much
User ID: 3***37 Dubai, United Arab Emirates
Healthcare
Assignment: 6 Pages, Deadline:
4 days
there was no plagiarism, the work was done well and the expert was very good and proffessional
User ID: 3***08 Dubai, Australia
It Write Up
Assignment: 8.8 Pages, Deadline:
10 days
very nice report created. thank you so much. appreciate it a lot. hopefully i get a good grade
User ID: 5***95 Dubai, Australia
Healthcare
Essay: 4 Pages, Deadline:
20 days
Great expert did a good job on the solution and i am impressed. i want other experts to learn from this expert and always deliver the right assignment …
User ID: 2***97 Upper Marlboro, United States
HRM
Essay: 2 Pages, Deadline:
2 days
thank you for your help it was greatly appreciated and I received a 85 on my paper. definitely will be using services again
User ID: 6***74 Upper Marlboro, United States
Management
Essay: 3 Pages, Deadline:
1 day
I am glad about the service. they answer all your questions well, and the team is respectful. they are excellent at writing essays with fast delivery.
User ID: 7***54 Upper Marlboro, Canada
Project Management
Assignment: 8 Pages, Deadline:
20 days
I am pleased with the marks I received on this particular assignment. Thank you!
User ID: 6***97 United Kingdom, Great Britain
Accounting
Home Work: 14 Pages, Deadline:
10 days
Got a good grade. Nice work. Had support until the delivery of assignment and delivered work a few days before than promised.
User ID: 7***68 United Kingdom, Great Britain
Electronics
Home Work: 5 Pages, Deadline:
7 days
I am so satisfied. Great job. Recommended. Fast delivery and smart experts……
User ID: 8***52 United Kingdom, Norway
Nursing
Assignment: 4.8 Pages, Deadline:
8 days
It was very well structured and all the instructions were followed.. The order was also completed on time. minimal grammatical mistakes.
User ID: 7***50 United Kingdom, Australia
Psychology
Home Work: 2 Pages, Deadline:
1 day
This is a really good service, It is rare to have them miss the assignment. I always come back with at least an 85
User ID: 4***21 Charlotte, United States
Psychology
Assignment: 1 Page, Deadline:
1 day
This is a really good service, It is rare to have them miss the assignment. I always come back with at lease an 85
User ID: 4***21 Charlotte, United States
Maths
Assignment: 2 Pages, Deadline:
4 days
helped me so much when I was at a time crunch, and they really pulled through for me
User ID: 5***12 Charlotte, United States
Statistics
Assignment: 5 Pages, Deadline:
12 days
Great service and perfect work and fast feedbacks as well i have no doubt in the work
User ID: 2***25 Khobar, Saudi Arabia
Marketing
Assignment: 1 Page, Deadline:
6 days
Got help from this expert for this assignment. I got an A and was very pleased with the help and grade. Will use again.
User ID: 5***56 San Francisco, United States
Property Law
Assignment: 12 Pages, Deadline:
12 days
Just received very good marks. Very happy with his service. Answer all questions nicely and all require points are included and good eassy writing sty …
User ID: 6***34 San Francisco, Singapore
Project Management
Assignment: 6 Pages, Deadline:
1 day
I got my assignment delivered before the deadline, and it was an excellent job done.
User ID: 8***21 San Francisco, Nigeria