-
+1 - 312-224-1615
Get in touch with us
-
support@helpwithassignment.com
Send us an e-mail
Solution Library
Business Growth and Revenue Maximisation in a Car Dealership
Question
Business Growth and Revenue Maximisation in a Car Dealership
Generation Automobiles Pte Ltd sells second hand cars. Cars are parked in lots for potential customers to view and test drive. Mr. Satya Nitin, the general manager, wants to sell more cars. The main objective is to maximise revenue by increasing the number of cars sold and/or the prices of transactions. To that end, Mr Nitin wants to know the following:
What make (brand) of cars should they hold?
What models of cars should they hold?
What features should be built in as standard in these cars?
What features should be added optionally?
Which locations sell more cars and/or at higher prices?
Mr. Nitin came across a study done by the Car Dealers Association (CDA) on sales of cars in year 2014. The sample had 1000 transactions randomly selected from car dealers in the country. The sample proportions for make, model and add-on feature are similar to those of the population.
Mr. Nitin speculates that this study could help him to address the above concerns but he is not sure how to interpret this study. Mr. Nitin has engaged you as a consultant to help and has provided you an excel file with this random sample of 1000 transactions. The variables in the data are:
|
CarID: Autogenerated ID of transactions in the sample
|
|
Price$: Price of car sold in Singapore Dollars
|
|
Mileage: Number of kilometres completed
|
|
MakeID: Numeric ID of the make (or brand) of the car
|
|
Make: Make (or brand) of the car |
|
ModelID: NumericID of the model of the car |
|
Model: Model of the car which briefly describes the main features of the car |
|
Engine Capacity: Size of the engine capacity |
|
Doors: Number of doors in the car |
|
Theatre: Video and sound system; 1 indicates installed and 0 indicates not installed |
|
Leather: Leather upholstery, 1 indicates there is and 0 indicates there is none |
|
GPS – Video_Rec: GPS provides traffic and routing information while Video Rec provide recording of front and rear view during journeys, 1 indicates installed and 0 indicates not installed. |
|
LocationID: Numeric ID of the location |
|
Store Location: Location; 1 indicates that car store within the city and 0 indicates outside of the city |
|
Make ID |
Make |
|
1 |
Chery |
|
2 |
Proton |
|
3 |
Hyundai |
|
4 |
Nissan |
|
5 |
Toyota |
|
6 |
Honda |
|
7 |
Others |
|
Model ID |
Model |
Doors |
|
1 |
2D sedan |
2 |
|
2 |
4D sedan |
4 |
|
3 |
5D hatchback |
5 |
|
4 |
MPV |
5 |
|
5 |
2D sports |
2 |
|
6 |
4D sports |
4 |
|
7 |
4D luxury |
4 |
|
Location ID |
Store location |
|
0 |
Non-city |
|
1 |
city |
MPV: Multipurpose Vehicle
Note: see the attached Excel sheet for required data
Choose appropriate hypothesis tests to determine if the Price$ is different with and without each of the three add-on features: Theatre, Leather and GPS-Video_Rec.
You should include the following:
- State the null and alternative hypotheses and explain how you develop these hypotheses.
(b) Present the output from your software for an appropriate hypothesis test with α = 0.05. List the test statistic you use for this test. Explain your decision criteria.
(c) Execute the hypothesis tests and conclude if Theatre, Leather and/or GPS-Video_Rec have an impact on Price$. If yes, what is the impact? What is your advice to Mr. Nitin based on these conclusions?
(d) Discuss the assumptions you have made in performing these hypothesis test? Are these assumptions reasonable for this case? Please provide explanation/s to substantiate your view.
Summary: This question belongs to operations management and discusses about Business Growth and Revenue Maximisation in a Car Dealership.
Total word count: 840
Download Full Solution
WHAT OUR STUDENTS SAY
My professor had mandated that the class had to use legal case studies from the Dunedin area to support our argument for the criminal law assignment essay topic. Since the research would take hours out of my already packed schedule I contacted HwA for help. They paired me with a law assignment expert who was herself practicing in Dunedin and what can I say, my assignment had some of the best case studies in the class.
Simon Hales Student
I never expected that the essay review service would be completely free of cost. There is absolutely no hidden cost and moreover the proof-readers and grammar checkers are really good and helpful.
Victoria Barker Student
The accounting assignment due for my term end evaluation had to include data and examples from Wellington businesses. So when I mentioned this special requirement of mine to the customer care executives at TheReliableTutor they immediately paired me with an accounting assignment expert who is from Wellington and has himself studied from the Victoria University of Wellington. Needless to say I topped the class and the professor was very impressed by the quality of the assignment.
Sophie Eady Student
The online finance fixed income derivatives assignment helper from HwA was very patient with all my questions and did not mind answering my questions at any time of the day relating to the fixed income derivatives assignment help. They also incorporated all the suggestions that were made by me. All in all I was extremely satisfied with the overall experience and the end product. To top it all I topped the class too!
Barry Knowles Student
Being a research scholar in Australia demands that you submit your research proposals and dissertations in a particular format and follow a typical form of expression chalked out by your dissertation advisors. The online dissertation writing help experts at TheReliableTutor based out of Australia understand this specific need and write the research proposals and subsequent dissertation to meet those exact specifications. There is no disconnect between your requirements and the finished dissertation submitted.
Connor Matthews Student
Comments
this is a very good website
I have 50 questions for the same test your page is showing only 28
hi can you please help or guide me to answer my assignments. thanks
hi can anyone help or guide me to my assignments. thanks
This solution is perfect ...thanks
Hello Allison,I love the 2nd image that you did! I also, had never heard of SumoPaint, is something that I will have to exolpre a bit! I understand completely the 52 (or so) youtube videos that you probably watched. Sometimes they have what you want, sometimes they don't! However, it is always satisfying when you are able to produce something that you have taught yourself. Great job!Debra 0 likes
Perfect bank of solution.
great !
thanks for the quick response. the solution looks good. :)
thnx for the answer. it was perfect. just the way i wanted it.
works fine.