GET ASSIGNMENT WRITING HELP, Online Writing Service: GenXY Motors Pte Ltd sells second hand cars. The company has four shops in different locations either within or outside of the city area. Mr. Branson Lim, the general manager of GenXY, would like to expand their business by adding four more locations.

Thursday, March 3, 2016

GenXY Motors Pte Ltd sells second hand cars. The company has four shops in different locations either within or outside of the city area. Mr. Branson Lim, the general manager of GenXY, would like to expand their business by adding four more locations.

SECTION A (Total 65 marks)
GenXY Motors Pte Ltd sells second hand cars. The company has four shops in different
locations either within or outside of the city area.
Mr. Branson Lim, the general manager of GenXY, would like to expand their business by
adding four more locations. The main objective is to maximise revenue by increasing the
number of cars sold and the prices of transactions. Mr. Lim would like know the followings:
Where should the new locations be?
What make (brand) of cars should they hold in these locations?
What models of cars should they hold in these locations?
What features should be built in as standard in these cars?
What features should be added optionally?

Mr. Lim came across a study done by the Car Dealers Association (CDA) on sales of cars in
year 2012. The sample had 1000 transactions randomly selected from car dealers in the
country. The sample proportions for make, model and locations are similar to those of the
population. Mr. Lim speculates that this study could help him to address the above questions
but he is not sure how to interpret this study. Mr. Lim has engaged you as a consultant to help
and has provided you an excel file “cars_dataset.xlsx” 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
Sound: Sound upgrading; 1 indicates an upgrade and 0 indicates no upgrade
LocationID: Numeric ID of the location
Store Location: Location; 1 indicates within the city and 2 indicates outside of the city
ID Make
Model
ID Model Doors
Location
ID
Store
Location
1 Chery 1 2D Sedan 2 0 Non-city
2 Proton 2 4D Sedan 4 1 City
3 Hyundai 3 5D Hatchback 5
4 Nissan 4 MPV 5
5 Toyota 5 2D Sports 2
Make
6 Honda 6 4D Sports 4
7 Others 7 4D Luxury 4
MPV: Multipurpose Vehicle