1 of 14

RENTAL FLEET PLANNING

Presented By : Nisha Menon

2 of 14

Contents

Discussing about the Business Objective

Analyzing the company, vehicle and branch performance data.

Hypothetical models to increase the revenue and minimize cost

Recommendations

3 of 14

Business Objective

Increase the revenue and minimize the cost

4 of 14

Company Performance - 2018

Gross Revenue : 52.8 Million

Car_YTD_Cost : 30.3 Million

​

Net Revenue : 22.5 Million

​

5 of 14

Branch Performance - 2018

  • Revenue from branches near airports is 23.2 Million

​

​

  • Revenue from other branches is 29.5 Million

6 of 14

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)

​

7 of 14

Underperformed Cars

Number of negative revenue generated cars : 99

The lowest net revenue car is 2018 Jaguar XJ Series $(-9374.67)

​

​

8 of 14

Strategy 1

​

  • Increase the number of cars in the fleet by 10%.
  • Total no.of cars : 4400

​

Increase in Net Revenue : 2.2 Million

9 of 14

Strategy 2

  • Increase the rental rate by 15% in the airport branches

​

Increase in Net Revenue : 3.5 Million

​

10 of 14

Strategy 3

  • Restructure rental cars inventory.
  • Sell 100 lowest revenue producing cars and buy 100 highest net revenue cars .

​

Increase in Net Revenue : 7.8 Million

​

11 of 14

Combined Strategy

Combine the previous 3 strategies

​

  • Increase the number of cars in the fleet by 10%.
  • Increase the rental rate by 15% in the airport branches.
  • Restructure the car inventory by removing the 100 negative revenue generated cars and replacing it with 100 high performance cars.

​

12 of 14

�2018 Revenue Compared with Strategies�

​

​

​

​

​

​

​

​

​

​

​

​

Combined Strategy

  • Gross Revenue : 78.27 Million Increase in Gross Revenue : 25.47 Million
  • Total Cost : 42.2 Million Increase in Total Cost : 11.9 Million
  • Net Revenue : 36.07 Million Increase in Net Revenue :13.57 Million

​

13 of 14

Profit Margin

  • Profit Margin (2018) -74%
  • Profit Margin (Combined Strategy) – 85%

14 of 14

Recommendations�

  • Implement a combined strategy model for higher revenue.

​

  • Increase in rentals will result in achieving higher profit margin.

​

  • Keep regular check on low revenue generated cars.

​

  • Optimize rental fleet.

​

​