RENTAL FLEET PLANNING
Presented By : Nisha Menon
Contents
Discussing about the Business Objective
Analyzing the company, vehicle and branch performance data.
Hypothetical models to increase the revenue and minimize cost
Recommendations
Business Objective
Increase the revenue and minimize the cost
Company Performance - 2018
Gross Revenue : 52.8 Million
Car_YTD_Cost : 30.3 Million
Net Revenue : 22.5 Million
Branch Performance - 2018
Cars Performance - 2018
Total number of cars in the rental fleet : 4000
The highest net revenue car is 2016 Pontiac Grand Prix ($1,39,189.93)
Underperformed Cars
Number of negative revenue generated cars : 99
The lowest net revenue car is 2018 Jaguar XJ Series $(-9374.67)
Strategy 1
Increase in Net Revenue : 2.2 Million
Strategy 2
Increase in Net Revenue : 3.5 Million
Strategy 3
Increase in Net Revenue : 7.8 Million
Combined Strategy
Combine the previous 3 strategies
�2018 Revenue Compared with Strategies�
Combined Strategy
Profit Margin
Recommendations�