How to compute prices of gasoline and diesel

July 13th, 2013 1 Comment   Posted in Oil Pricing Formula

BusinessWorld
http://www.bworldonline.com/content.php?section=Opinion&title=How-to-compute-prices-of-gasoline-and-diesel&id=73169
Thursday, July 11, 2013 | MANILA, PHILIPPINES

How to compute prices of gasoline and diesel

Strategic   Perspective René B. Azurin

SINCE PUMP prices of oil products are again rising, prompting the usual round of demonstrations against “overpricing,” I thought it would be useful to bring to everyone’s attention the pricing model developed by the Independent Oil Price Review Committee (IOPRC) which was tasked last year to study the reasonableness of retail prices of gasoline and diesel. More »

Oil Pump Price Model – Excel Spreadsheet

September 14th, 2012 No Comments   Posted in Oil Pricing Formula

Oil Pump Price Model – Excel Spreadsheet

Calculation model for the following products:

  98 Octane – Super Premium
  95 Octane – Premium
  93 Octane – Unleaded
  87 Octane – Regular / Naphtha
  Avgas
  Kerosene
  Avturbo
  Low Sulfur Diesel
  Regular Diesel
  Low Sulfur Fuel Oil
  Bunker C Fuel Oil
  Lubricating Oils
  LPG – Cooking
  LPG – Power / Automotive

 

Click the link below to order, remit payment via PayPal, then download in one easy step. More »

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Annexes

September 13th, 2012 No Comments   Posted in Oil Pricing Formula

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Annexes

The last part of this 3-part series presents the results of applying the oil pump price calculation model into the 1974-June 2012 historical data on pump price, import costs, taxes and government imposts, logistical and transport costs, biofuels, and dealer margin. More »

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Analysis and Conclusions

September 12th, 2012 8 Comments   Posted in Oil Pricing Formula

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Analysis and Conclusions

 

Analysis and Conclusions

 

This chapter presents the evolution and derivation of the oil pump price formula. There is a need to develop an oil pump price formula simply because the oil companies never divulge their oil company gross margin which is the residual or price difference when we subtract from the actual pump price all the importation value adding activities such as supply cost or FOB/MOPS/Dubai, ocean freight and insurance, customs duty, BOC fee, import processing fee, customs doc stamps, bank charge, arrastre charge, wharfage charge, and excise tax or specific tax to arrive at the 12% VAT on all importation activities, and all local value adding activities such as oil company gross margin, transshipment, pipeline, depot operation, biofuels, hauler’s fee and dealer’s margin to arrive at the 12% VAT on local activities. More »

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Introduction

September 12th, 2012 2 Comments   Posted in Oil Pricing Formula

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Introduction

Introduction

This technical paper will present the various oil pump price calculation model (regulated and de-regulated periods) which together with the supply cost, end pump price, taxes (customs duty, special duty or Estanislao Peso, excise tax or specific tax, value added tax or VAT), biofuels (10% ETHANOL gasoline blend and 2% CME BIODIESEL blend), logistical costs (transshipment, pipeline, depot operation, hauling fee), and dealer’s margin will be subsequently used to calculate the residual component (by difference) that goes to the oil company (refiner, importer/marketer). More »

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Executive Summary

September 11th, 2012 No Comments   Posted in Oil Pricing Formula

Philippine Oil Pump Price Calculation Model and Oil Company Gross Margin – Executive Summary

 An Independent Oil Price Review Committee (IOPRC) recently completed its study and submitted its findings to the Philippine Department of Energy (DOE), the print and broadcast media, and conducted a public consultation at the UP School of Economics to interested parties such as NGOs, oil company associations, academe.

The IOPRC concluded that domestic oil prices of gasoline and diesel tracked changes in the international price of oil (Mean of Platts Singapore or MOPS) based on statistical and regression analysis. It also found that the return on equity (ROE) and internal rate of return (IRR) of the oil companies (refiners, importers) on an annual average are reasonable and lower when compared to returns of other utilities and industries such as power generation, telecom, mining and that the oil company gross margin (in % and absolute Pesos per Liter) which was computed by subtracting from the pump price all taxes and government fees, logistical costs, dealers margin and cost of the imported oil were not excessive as generally alleged. More »

Independent Oil Price Review Committee (IOPRC) found no Overpricing

September 6th, 2012 No Comments   Posted in Oil Pricing Formula

Independent Oil Price Review Committee (IOPRC) found no Overpricing

In today’s news (Philippine Start, Sep 6, 2012, page B-3), the IOPRC released its findings after presenting the results to the DOE Secretary Rene Almendras and subsequently in a press conference at the DOE.

“Contrary to popular belief, oil companies are not overpricing their fuel products and are, in fact, merely tracking international price adjustments”, says the press report.   More »

How to Balance Your Country’s Finances – Adequate Oil & Energy Taxation

September 4th, 2012 No Comments   Posted in Oil Pricing Formula

How to Balance Your Country’s Finances – Adequate Oil & Energy Taxation

The key to a country’s fiscal health is the collection of all taxes needed for good governance and social services. Without taxation, the lifeblood of a country will dry up, and so goes the well-being of its citizens as social, health, security, infrastructure and other government services are deprived of adequate funding and investments to the future. More »