Self-service gas station

• Project name: Self-service gas station
• Class: 4IT496 Simulation of Systems (WS 2013/2014)
• Author: Bohuslav Dvorský
• Model type: Descrete-event simulation
• Software used: SimProcess

Introduction

In Western countries becoming increasingly popular self-service gas stations - a station where is no staff, but only machine that after the payment distribute fuel or other goods like mix washed, distilled water etc… With my friend we were thinking about a similar concept in the Czech conditions and realistically began to explore the possibility of implementation of the business plan. We contacted fuel distributor, manufacturer that would provide us station infrastructure (fuel tank, tubes, software, fuel dispenser…), directorate for roads and highways, a construction company that would build asphalt road connector, many banks for best offer of cashless payment and business loan and more other institutes. So we got estimate price of everything we need for construction of self-service gas station including payment for permissions from different authorities. Thanks acquaintances of my friend, we also have actual data from the gas station standing on the same path where we would like to build our station. It is the Benzina gas station and we have data like average number of cars on the station, average liters of fuel tanked, ration of diesel, petrol and LPG.

Problem definition

Can be this project profitable? As we discovered, more than 50% of people use credit card to pay the fuel. Unfortunately banks for companies like ours charge a fee for their services in the amount of 1.48% of the total. This finding is very frustrating simply because the margin for fuel out of a large network of filling stations is about 2 CZK per liter. This finding is very frustrating simply because the margin for fuel out of a large network of filling stations is about 2 CZK per liter. So most of the revenue is likely to be cash payments or loyalty card payments. Thanks to the self-service station, we can eliminate the cost of human factor, main building or restrooms. But when considering starting a new business we muse take a loan in the amount of almost 100% of the capital. We must also include the cost of bank loan, electricity, internet and maintenance of the station.

I believe that in certain circumstances the project is profitable. My job is to find the conditions under which self-service station made ​​a profit and paid itself.

What do we know?

As I stated in the introduction, we have obtained all the information to which we could get and made ​​contact with the fuel supplier.

• The lowest possible price for the station: [ CZK ] 3000000

• Price for another dispenser / connection to the system: [ CZK ] 250000

• Price for a split tank with diesel / petrol: [ CZK ] 800000

• Price for road connector in the chosen location: [ CZK ] 1500000

• Price for the parcel: [ CZK ] 500000

• Monthly fixed costs - electricity, internet, maintenance: [ CZK ] 35000

• The cost of a dispenser - asphalt road: [ CZK ] 200000

• Capacity of the tank: [ l ] 15000

- basic type of station (lowest possible price) include: Fuel tank, fuel dispenser (diesel/petrol), infrastructure, asphalt road, software...everything needed for running the station

- split tank: fuel tank is divided into two sections - 7500 litres of diesel and petrol

• Average number of customers: 502

• Average litres of fuel tanked: 35

• Diesel/Petrol tanked ratio: 60% / 40%

• Payments ratio - credit card/cash/loyalty card: 67% / 14% / 19%

• Fee for credit card payment: 1.48% of total amount

We obtained this data from the employee of Benzina gas station in Šterbnerk. This gas station is situated in the same locality as our fictive gas station so we can label this data as relevant for us.

LPG can be refueled only by trained personnel which for this type of station is unacceptable.

Fuel supplier

We communicated with the nearest fuel supplier that meets our conditions. Because our station is located within a distance of 35 km from the headquarters of the supplier, the price per delivery is included in the price of fuel. Our supplier is company Albeva Morava s.r.o.. Our conditions were: price for delivery included in price of fuel and just in time delivery with continuous replenishment of fuel. The idea is that the station software will detect low fuel level and alert our supplier who then begins the process of delivery of the fuel. We were asured that our station software can send email or it can be connected to ERP-like system of various suppliers. Email variant was enough for our suplier and further terms would be specified in the contract. So we found another question...what level of fuel should warn our supplier due to the variable cost for the supply of different quantities of fuel?

Diesel delivery: [ l ]

10001 -15000 : 34,48 [ CZK ]

15001 - 20000 : 34,24 [ CZK ]

20001 - X : 33,81 [ CZK ]

Petrol delivery: [ l ]

10001 -15000 : 34,03 [ CZK ]

15001 - 20000 : 33,91 [ CZK ]

20001 - X : 33,79 [ CZK ]

Location

A parcel of size aproximately 1600 square metres. Price for metre square is 300 CZK. This parcel is situated on the main way from Šternberk to Opava and also to Poland. So there are plenty of cars heading to Poland or to Opava.

Method

Lets start with simple math. We know that Benzina has aproximately 502 customers per day and they tank 35 litres per average. That is 17570 litres per day and divided with diesel/petrol ratio we get 7028 litres of petrol and 10542 litres of diesel. With fuel divided to petrol and diesel we can now calculate the costs of fuel.

We have three variants due to volume of petrol delivery:

Variant A : 10001 - 15000 litres

Diesel cost: 363488,16 [ CZK ]

Petrol cost: 239162,84 [ CZK ]

Variant B : 150001 - 20000 litres

Diesel cost: 360958,08 [ CZK ]

Petrol cost: 238319,48 [ CZK ]

Variant C : 20001 - X litres

Diesel cost: 356425,02 [ CZK ]

Petrol cost: 237476,12 [ CZK ]

After consulting with a financial advisor from Fincentrum.cz I was told that it is possible to get a business loan with an interest rate of around 5.5% for 5 years, 6% loan for 10 years and 6.5% for 15 years. So lets sum what we know about our fixed costs and cost for building the station. We consider the smallest possible size of the company.

• 3 000 000 CZK - complete system
• 800 000 CZK - aditional fuel tank (if capacity is 15000 litres and Benzina sell 17000 litres per day we sure need one more)
• 500 000 CZK - parcel
• 1 500 000 CZK- road connector
• 700 000 CZK - savings

Total = 6 500 000 CZK

Now we can calculate monthly installment.

5,5% interest rate - 5y loan

= 124 157,55 CZK

6% interest rate - 10y loan

= 72 163,33 CZK

6,5% interest rate - 15y loan

= 56 621,98 CZK

And with monthly installments we can define total fixed costs:

Variant 5.5

• 124 157,55 + 35 000 = 159 157,55 CZK

Varian 6

• 72 163,33 + 35 000 = 107 163,33 CZK

Variant 6,5

• 56 621,98 + 35 000 = 91 621,98 CZK

We have estabilished that for profit we must make more money than our fixed costs

How much does Benzina earn?

- price for their diesel is 36,90 and price for petrol is 36,50

- we dont know anything about their fee for credit card payment - it sure be lower than ours

- we dont know anything about their price for fuel from supplier - it sure be lower than ours but now we assume our prices

But with numbers above we can say that their gross margin for diesel is 32574,78 CZK and gross margin for petrol is 19045,88 CZK.

Total gross margin 51620,66 CZK per day.

Can we make our net margin sufficiently high to beat our fexed cost?

The first thing we have say is that we can not have such high prices as Benzina. People will not believe the new technology and will rely on traditional methods. People will not believe the new technology and will rely on traditional methods. The only attraction for them will therefore price and quality of service.

Lets assume that we set prices to 36,00 for diesel and 35,60 for petrol and values from our example. It is gonna to be profitable?

• net margin for diesel: gross margin - bank fees = 19323,73901 CZK

• net margin for petrol: gross margin - bank fees = 10239,72853 CZK

• total margin per day = 29563,46754 CZK

It seems like this project is profitable. But this is only simple math. The is no guarantee that this station would have so many customers even with lower prices. Also we have only one fuel dispenser so there will we definitely queue and angry drivers will leave after few minutes and never come back. So that is what I am gonna simulate.

Method of this simulation is to use SimProcess to create virtual gas station and simulate diferent conditions to achieve real results

So there will different number of customers every time, different number of fuel dispensers and different price.

Model

Stages

• Arrival

• Fueling

• Exit

Entities

• Customer

Resources

• fuel dispenser

• diesel

• petrol

Arrival stage

Thanks to data from Benzina, we know when peaks occur. So we can estabilish a generator that will provide us customers according to real data. There are 6 different time perionds with different "breed rate".

Fueling stage

This stage compose of Branch that divide customers to those who tank diesel and those who tank petrol. There is Delay that is simulating the fueling proces. We measured that ordinary person is done with fueling and payment in Nor(140,20). This Delay also provide us the possibily to simulate angry customers who are leaving after 10 minutes of waiting. There is also Get Resource process that simulate fueling of petrol or diesel. Everytime when customer needs to refuel he needs the fuel dispenser. There is limited number of fuel dispensers and their release is controled by Release Resource proces.

Exit stage

Nothing special.

Scenario 1

= GREAT OPTIMIST

- average 600 customers per day

- huge peak 05:00 - 11:00 + 15:00 - 17:00

- 2 fuel tanks

We surely need to keep customer satisfaction on the highest level possible. That mean no queues and low prices.

Lets try it with one fuel dispenser.

-

As you can see in one day visited station 601 customers. Unfortunately, it queues up to 14 customers and there were moments when the customer waited longer than 10 minutes. -

-

There were also a great number of angry customers that leave. 94 that wanted diesel and 84 that wanted petrol....result? = NOT OPTIMAL

Now lets try 2 fuel dispensers. ( + 400 000 CZK for fuel dispenser and asphalt road)

Generaly the result is not bad. We managed to lower the number of angry customers to total 6. But it is still not perfect. Customers are waiting too long for dispenser and their "visit rate" could decrease in time.

Lets try 3 fuel dispensers. ( + 800 000 CZK for fuel dispenser and asphalt road)

Optimal result. No angry customers. Customers are not waiting for a long time. Lets do math and se how is this scenario profitable:

a) miracle - diesel 36,00 CZK and petrol 35,60 CZK

Litres of fuel sold:

• 12 516 litres of diesel
• 8 344 litres of petrol

Net margin (diesel + petrol): 35099,25628 CZK

Monthly income: 1052977,688 CZK

= PROFITABLE FOR EVERY LOAN VARIANT

b) attractive price - diesel 35,10 and petrol 34,70

Litres of fuel sold:

• 12 516 litres of diesel
• 8 344 litres of petrol

Net margin (diesel + petrol): 16511,41927 CZK

Monthly income: 495342,578 CZK

= PROFITABLE FOR EVERY LOAN VARIANT

Scenario 2

= GREAT PESSIMIST

- average 250 customers per day

- peak 05:00 - 11:00 + 15:00 - 17:00

- 2 fuel tanks

Scenario 3

= BENZINA LIKE

- average 500 customers per day

- huge peak 05:00 - 11:00 + 15:00 - 17:00

- 2 fuel tanks

Lets assume that we can due to lower prices estabilish the same "visit ratio" as Benzina. To do this we need to keep the customer satisfaction on high level. That mean no queues, short waiting time and low prices.

We will start with 1 fuel dispenser.

Barely optimal. One fuel dispenser is simply not enough.

Lets try 2 fuel dispensers. ( + 400 000 CZK for fuel dispenser and asphalt road)

As we can see, we are getting closer to optimal state. There are 504 customers in the system and 8 customers max waiting for fuel dispenser. No one leaves due to angrer of waiting. That is practicaly real situation in rush hour. But still customer who is waiting for 9,2 minutes have to be pretty frustrated. For the sake of future profit we need to be more open and flexible to the needs of our clients.

Now we add one more fuel dispenser. Total number = 3. ( + 800 000 CZK for fuel dispenser and asphalt road)

In this case we achieved optimal state. There are max 3 customers waiting in the queue for max 3,4 minutes. No one leaves with anger and 3 minutes of waiting is a reasonable amount of time spent on wainting for cheap petrol or diesel.