[jsfg_cinti] Job Posting: Financial Planner / Billing Administrator

The following job opportunity has been posted to the JSFG E-mail Mailing List 
by 
JSFG@xxxxxxxx on April 8th, 2004 at 11:19AM (CDT).

Date: 04/08/04
JobTitle: Financial Planner / Billing Administrator
JobClass: Accounting/Finance
JobDescript: Summary
Prepares Sales Invoices, maintains cash receipts register and assists in 
collection of accounts.

Updates internal and corporate reports for financial planning.  Assists in the 
yearly budgeting and monthly analysis of variances

2) Functions
- prepares reports and performs weekly analysis of Xetron productive yield; 
investigates variances.

- Prepares monthly productive yield target vs. actual charts for management; 
investigates variances.

- Monthly sick, vacation and personal hours report for functional managers, HR, 
President and CFO.

- Prepares bi-monthly cast forecast for NG.

- Prepares engineering budget analysis reports and charts for quarterly reviews 
with Homeroom

- Prepares budget source report monthly

- Tracks and reports to NG CRAD acquisitions and sales (actuals and forecast) 
monthly

- Updates other monthly NG reports:
   - B-1, B-1A and Local Disallowance
   - BM Headcount
   - Budget Visibility
   - Cash Inputs
   - Business Area A/R report

- Maintains FFS (Financial Forecasting System) database by 1) downloading and 
reconciling monthly actuals to tie to SAP financial statements; 2) Compiling 
the separate business unit forecasts into a corporate forecast.

- Prepares income statement forecast based on FFS data

- Prepares monthly financial review ("Mid-Month") package for President's 
presentation to division VP.

- Assist in annual LRSP & OAP process - program input file.
   - Forecasts headcount and prepares other sector directed schedules as needed.

- Prepares charts and other information for presentation purposes in LRSP, AOP 
and budgeting process.

2A) Budgeting Duties
- Prepares Budget vs. Actual depth charts monthly.

- Distributes monthly budget reports to appropriate managers.

- Reviews monthly actuals for fringe benefit departments (98 & 99) and accounts 
for variances.

- Updates forecasts in FFS systems for changes in benefits, experience or other 
unanticipated budget changes.

- Updates WDS & FFS for changes to be made to Department budgets.

- Prepares EXCEL manpower charts based on company monthly forecast.

- Updates Monthly Company Headcount report in EXCEL file by dept, bld, code and 
name.

2B) Invoicing
- Maintains sales log and enters into WDS.

- Prepares invoices for Cost Plus binning - bi-monthly.

- Prepares time & material invoices as needed.

- Prepares invoices for Fixed Price billing.

- Prepares new contract billing folders and maintains contract folders.

- Prints CRAs and files in appropriate folder.

- Prepares contract closeout invoices.

- Prepares contract closeout documents and coordinates contract closeouts with 
Contracts Administration.  Prepares interim and Final closeout invoices in a 
timely manner.

- Prepares a Billing Instructions Worksheet for all new programs.

- Maintains closeout status of cost reimbursable contracts.

- Reviews sales reserve and un-billed accrued costs for cost plus contracts.

- Maintains database for accounting information by program for use in Tax 
package and other information required for detail sales by program.

- Maintains master spreadsheet for all cost plus fixed price current programs 
and billing requirements.

2C) Accounts Receivable
- Maintain Customer Master Log

- Maintains current status of collection efforts

- Interfaces with Northrop Grumman cash management personnel in the collection 
of Columbus DFAS receivables.

- Keep management apprised of any potential collection issues with customers.

- Maintains billing files in an organized manner and ensures that closed 
contracts are handled in accordance with Xetrons records retention policy.

- Maintains cash receipts by month and enters in to WDS.

- Updates A/R spreadsheet on network daily.

- Check A/R account at Chase Manhattan daily through modem link.

- Prepares and processes debit and credit memos as needed.

- Prepares A/R write-offs as necessary.

2D) General Ledger
- Prepares account reconciliation for unbilled sales, accounts receivable and 
sales reserve accounts (01-810, 01-812, 01-813, 02-820, 06-949 and 06-952)

- Maintains Access database contract information for audit package and tax 
information.

- Inputs contract information into Access database monthly

- Prepares UFO report in EXCEL from Access database

2E) Other Activities
- Open, close and modify general ledger account numbers for programs, WBS, B&P, 
IR&D, and selling expense.

3) Scope, Purpose and Frequency of Contacts
- All departments as needed to resolve problems or obtain approvals.

4) Problem Solving
- Variance analysis - identify and explain.

5) Decision Making
- Ability to read and interpret company policies and apply to daily operations.

- Ability to analyze company results and notify management of important 
variances.

- Ability to reconcile accounts and forecast expenses.


Requirements_Qualif: 1) Education Requirement
- Associate or Bachelors degree in accounting would be helpful.

2) Experience/Skill Requirements
- Minimum five to eight years experience in general ledger accounting, 
invoicing, accounts receivables, collections assisting, report data gathering 
and preparation, assisting with financial planning and forecasting and 
budgeting duties.

- Must be proficient in EXCEL and knowledgeable in Access.

- Highly organized and detail oriented.

3) Skills of Persuasion:
- Ability to work at all levels within the company to obtain information for 
budgets.

4) Administrative Abilities
- Microsoft Word.

-Microsoft EXCEL - calculations, pivot tables, variance analysis, linking 
spreadsheets.

- Access database.

- Strong 10-key calculator ability.
WorkType: Temporary
Travel: No
PositionState: Existing
SalaryRange: $14 - $17
StartDate: Immed.
HowApply_Mail: Yes
HowApply_Phone: Yes
HowApply_Fax: Yes
HowApply_Email: Yes
Company: Xetron (Northrop Grumman)
Person_Requesting_Profiles: Art Bush
Contact_StreetAddress: 460 W. Crescentville Rd
Contact_City: Cincinnati
Contact_State: OH
Contact_ZipCode: 45246
Contact_WorkPhone: 513-881-3254
Contact_FAX: 513-881-3275
e-mail: artb@xxxxxxxxxx
Industry: Electronics
email: JSFG@xxxxxxxx
bgcolor1: #FFFFFF
Submit: Submit Form


-------- Env Report --------
REMOTE_HOST: 
REMOTE_ADDR: 216.196.133.190
HTTP_USER_AGENT: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; .NET CLR 
1.1.4322)

You can unsubscribe from the list by sending email to 
jsfg_cinti-request@xxxxxxxxxxxxx with 'unsubscribe' in the Subject field. 

Web archive: http://www.freelists.org/archives/jsfg_cinti 

Questions to:  jsfg@xxxxxxxx

Other related posts: