Home and property

LPG cylinders or piped gas: compare using your own records

A PNG vs LPG cylinder cost comparison from your own records: twelve months of cylinder receipts, a few piped-gas bills and one-time deposits as separate lines.

Editorial illustration for LPG cylinders or piped gas: compare using your own records

To compare cylinder gas with piped gas, work out what you actually paid per month for each: twelve months of cylinder receipts on one side, and two or three piped-gas bills on the other, plus any connection deposit spread over the years you expect to use it. Prices change, so the comparison is only as good as the date of the figures.

What do you collect for cylinders?

Gather the last twelve months of refill payments. They may be in UPI records, card statements, cash receipts or the delivery slip. For each refill note the date, the amount and any delivery charge or tip you paid on top. Count the number of refills in the year, since households use them at different rates.

Say, purely as an example, you took 8 refills at ₹900 each. That is 8 times 900, which is ₹7,200 for the year, or ₹600 a month.

What do you collect for piped gas?

If you already have piped gas, take at least three bills, ideally from different seasons, and note units consumed and amount. If you are considering a switch, ask the provider for the unit rate in writing, and estimate your monthly units from what you use now. Do not assume cylinder usage translates one to one; the provider or an existing PNG household in a similar flat can give a rough idea of consumption, which you should treat as an estimate.

Take three made-up bills of ₹520, ₹610 and ₹480. Their total is 1,610, and divided by 3 that gives ₹536.67 a month.

How do you treat one-time costs?

Connection charges, a security deposit, a gas stove adjustment or pipe work are one-time lines. Put them in their own rows. Say these come to ₹7,500, and you expect to stay five years. Spread over 60 months, that is ₹125 a month. If part of the deposit is returnable, note it separately, because it is money parked and not spent.

Cost lineCylinders (₹ per month)Piped gas (₹ per month)
Regular gas600.00536.67
One-time costs spread over 60 months0.00125.00
Total600.00661.67

On these invented figures, piped gas is about ₹62 a month more costly (661.67 minus 600). With different prices it could go the other way. That is the point of using your own numbers.

What else does the comparison need?

  • Delivery: whether you pay for it, and how often you ran out unexpectedly
  • Billing: whether piped gas is billed monthly or in advance, and the late charges
  • Safety and supply: reliability in your area, and what the provider offers for service
  • Subsidy or price changes: rules and rates change, so ask your provider and check the official source rather than relying on old figures
  • Stove compatibility: whether your stove needs a change

How do you set it up in a sheet?

List the cylinder refills in one table with date, amount and delivery charge, and total it with =SUM(C2:C13). List the piped bills in another, and use =AVERAGE(C2:C4) for the monthly figure. Put the one-time total in a cell and divide by months: =B10/60. Add the three results in a summary cell for each option, and compare.

Where does an expense tracker help?

Refills paid by UPI are in your statements, and SpendixAI can categorise them under cooking gas, so the twelve-month total is a report rather than a hunt. Cash payments to the delivery person can be added by hand. When you switch, you can add a piped-gas category and compare the two lines in the same report.

Before you decide

  1. Get the provider's tariff and connection terms in writing
  2. Work out your own monthly units, not a neighbour's
  3. Add one-time costs and decide the years you will stay
  4. Re-run the comparison once a year, since rates and your usage change
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports