Home | SoCalGas
DATA REQUEST
Southern California Gas Company Test Year 2012 GRC
A.10-12-006
Date: June 20, 2011
Responses Due: July 5, 2011
To: Ronald van der Leeden
RvanderLeeden@
(213) 244-2009
From: Truman Burns, Project Coordinator
Donna Fay Bower, Assistant Project Coordinator
Division of Ratepayer Advocates
505 Van Ness Avenue, Room 4205
San Francisco, CA 94102
Originated by: Marek Kanter
Phone: 415-355-5512
Email: mrk@cpuc.
Data Request No: DRA-SCG-108-MRK
Exhibit Reference: SCG-27
Subject: Depreciation
Please provide the following:
Please modify and correct the April 1 update to the March 7 supplemental update to DRA-SCG-4-MRK as follows:
1. The spreadsheet WPS-Working Copy SCG 2009 EST Provision Split.XLS has some cells with a working formula and some without, despite the cells being in the same column. In tab 2009 EST PROV SPLIT the cells K9 and L9 for storage rights accrual and rate are hard coded without formulas, whereas most of the other cells in columns K and L have formulas. This hard coding leads to an inconsistency in that the product of Q9 times J9 times D9 divided by H9 is 1.4 rather than being 1 as it should be. (The product of Q10 times J10 times D10 divided by H10 is 1; the product of Q11 times J11 times D11 divided by H11 is 1, etc.) Please document all such other hard coded cells, including in other tabs, and explain the rationale for this hard coding. Please provide an updated spreadsheet for the years 2005-2010 without such hard coding, or if that is impossible, please explain the reason.
2. The formula in cell Q7 should be N+O-P not N+O+P. Please correct in the spreadsheets prepared for this data request.
3. Data request DRA-SCG-4-MRK states that:
”If the data in the column titled “Provision” is calculated rather than recorded, then the calculation thereof should be provided in the spreadsheet.”
However, the response to the DR does not give any calculation for the provision numbers in column S. The response does state that:
“The excel spreadsheets utilize the total yearly depreciation accrual rate by FERC account as submitted to the CPUC on an annual basis incorporating the rate discussed above. The total yearly estimated provision is included as part of that submission to the CPUC using the rate discussed above.“
Please provide an updated spreadsheet for the years 2005-2010 which shows how annual provision was calculated using yearly depreciation accrual rate by FERC account as described above or if that is impossible, please explain the reason.
Provide two copies of the above information as it becomes available but no later than the due date identified above. If you are unable to provide the information by this date, please provide a written explanation to the data request Originator seven calendar days before the due date as to why the response date cannot be met and your best estimate of when the information can be provided. Please identify the person who provides the response and his (her) phone number.
Provide electronic responses if possible, and set of hard copy responses with your submittal to the data request originator and the DRA Project Coordinator(s). All data responses need to have each page numbered, referenced, and indexed so worksheets can be followed. If any number is calculated, include a copy of all electronic files so the formula and their sources can be reviewed.
If you have any questions regarding this data request, please call the originator at the above phone number.
-----------------------
DRA
Division of Ratepayer Advocates
California Public Utilities Commission
State of California
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- home financing calculator
- home health hiring
- home loan calculator
- home mortgage calculator
- home speech home wh questions
- home parties for home decor
- home speech home word list
- home loan vs home equity loan
- home decor home party companies
- home based home decor businesses
- home inspection checklist printable home inspection checklist new
- home interiors in home parties