Volume 6
October 2009
Issue 10

 

President's Message

October is an important month in our Chapter's history. In October,2004, we first gathered as a new chapter at the DSCC Officer's Club to hold our inaugural luncheon. This month, our DFAS Deputy Director, Mr.Richard "Gus" Gustafson, will celebrate the fifth anniversary of that event with us, in our own DFAS Conference Center.

October is also the month that we join the Central Ohio Chapter in co-hosting the 25th Annual Regional Professional Development Conference(PDC) on October 19-21 at the Columbus Athenaeum. It promises to be an excellent professional development opportunity with 21 hours of Continuing Professional Education (CPE) hours. I hope to see you all there!


We have traditionally celebrated Early Career Month in October, where we recognize the early career members of our chapter (those who are within the first three years of government service). This year, we have moved that celebration to November. Watch the newsletter and your e-mail for more on this year's celebration.

November is also a great month for fun community service! Mark your calendars for Thursday, November 12, and plan to participate in Accounting for Kids Day. At our joint AGA/ASMC meeting in September, we had the great pleasure of welcoming the Ohio Society of CPAs to talk about Accounting for Kids Day. Their representatives showed us how to teach basic financial concepts to fourth-, fifth-, and sixth-grade classrooms by playing a simple (and fun!) game. You don't have to be an AGA member to participate, so bring your friends and co-workers along with you to allow more classrooms than ever to participate in this event. I encourage you to participate in this rewarding community service event that takes only a couple of hours of your time. Contact Kortney Whiteman for details.

Thank you for all you do for AGA and our community!

Chapter News
 

more


less

  • Chapter Directors Wanted
The best time to get involved with your local AGA chapter is now!

Due to the dynamic environment we all exist in, we have had wonderful people working on several committees that have had to move to other things. Your big chance to improve the future has arrived.

Help AGA make that better future by volunteering for one of the roles described below:

  • Membership Director: We are looking for an individual that is interested in recruiting and retaining members. The committees goal is to seek new members and meet current members' needs to ensure a healthy, vigorous chapter. Also, to keep current and potential members interested and involved in AGA and the Greater Columbus Chapter.
  • Education Director: We are looking for an individual that is interested in providing effective, quality educational opportunities to our members by obtaining speakers for our chapter luncheons, conferences, and audio conferences. The committee's overall goal is to foster professional development by enabling members to achieve greater heights in their careers and meet education requirements through the educational opportunities offered.
  • AGA Certification/CGFM Director: We are looking for an individual that is interested in promoting the CGFM certification. It is AGA's vision to be the premier association in advancing government accountability. To accomplish that vision, it is our mission to serve the government accountability professionals by providing quality education, fostering professional development and certification, and supporting standards and research to advance government accountability.

more

By being a member of the Association of Government Accountants (AGA), you have already shown that you believe in and are dedicated to keeping yourself on the leading edge of your profession. It is only with the assistance of members like yourself who are interested in getting involved that we will truly be able to implement the high quality Education committee our members expect and that everyone can benefit from.

If you have an interest in helping us make this the finest chapter in the nation, please send your self-nomination to Justin Sponseller (justin.sponseller@dfas.mil) no later than COB Thursday, June 11, 2009. This self-nomination should include an explanation as to why you feel you would be the right choice to lead this important aspect of our chapter.

The Chapter Executive Council (CEC) will be reviewing all requests received and should be in contact with all interested individuals after the next CEC meeting; which is currently scheduled for Monday, June 15th. At this meeting, the CEC will discuss the qualifications of each self-nominated candidate; after which, each member of the CEC will vote for who they feel would best carry out the responsibilities of that position. The individual selected will be notified by COB Friday, June 19, 2009.
less

  • Professional Development Fair Held

 

  • August Audio Conference Recap
  • By Anthony Mangoff

On Wednesday, August 12, the AGA Columbus chapter, in conjunction with the National Association of State Auditors, Comptrollers and Treasurers, and the Association of Local Government Auditors, participated in an audio conference: Next Steps in Accountability and Control over Recovery Act Funds.

The conference addressed strategies to comply with the American Reinvestment and Recovery Act (ARRA) reporting requirements. Participating in the teleconference were Marcia Paull, Chief Financial Officer, Office of Justice Programs, U.S. Department of Justice; John Radford, Comptroller, State of Oregon; Daniel Werfel, Deputy Controller, Office of Federal Financial Management, U.S. Office of Management and Budget; and David Zavada, Partner, Kearney and Company.

more

ARRA, the economic stimulus measure enacted February 17, 2009, is a milestone in financial and risk management, internal control, oversight, and accountability. The audio conference participants specifically addressed Section 1512, Transparency and Oversight Requirements, by which any entity, including a state, receiving recovery funds is required to report, no later than 10 days after the end of each calendar quarter, the total amount of funds received, the amount expended or obligated, and a detailed list of projects or activities for which funds were obligated or expended. Also mandated by the Act is "an estimate of the number of jobs created and the number of jobs retained by the project or activity." Within 30 days after quarter-end, agencies that make recovery funds available to any recipient must in turn publish this information on the Recovery.gov website. ARRA further establishes (Section 1521) a Recovery Accountability and Transparency Board (RATB) to coordinate and conduct oversight of covered funds to prevent fraud, waste, and abuse.

The Recovery.gov website includes implementation guidance for the Act, registration forms for the primary and sub-recipients who are to report activity, frequently asked questions (FAQs) regarding the process, and, most recently, the Excel templates that are to be completed by the reporting entities. As the agencies' initial reporting deadline under the Act is October 30, the conference participants emphasized the importance of advance planning, particularly in ensuring that both primary and sub-recipients have been properly registered for reporting purposes, as required by the Director of the Office of Management and Budget, and providing training and guidance on reporting, most notably on the less familiar concept of full time equivalent (FTE) jobs created or retrained.

As state entities may also be recipients of ARRA funding they may also be required to coordinate the reporting requirements for their respective state governor's/budget office. They may likewise be required to lend policy support to ensure compliance and reliability of the reported totals, an oversight role which cannot be fulfilled by other parties such as internal or external auditors.

For their part agencies must likewise determine how they will review the reported data within the 10-30 day period subsequent to quarter-end in order for the information be publicly available on the recovery.gov website by the 30th day after quarter-end. Given the volume of data and the potential number of recipients and sub-recipients, their review may necessitate some sort of sampling approach. Agencies will also need to determine what penalties are to be imposed upon recipients who fail to meet reporting deadlines.

As the initial reporting deadlines nears the Recovery.gov website will continue to post updated information to assist recipients in the reporting process mandated by the Recovery Act, including guidance clarification, FAQs, registration forms, and reporting templates. AGA is leading the communication process by hosting panel discussions and research studies on these requirements. Preregistration process for recipients who are to begin reporting began on August 17, 2009, with final reporting due on October 10, 2009. For more information regarding ARRA and the reporting process please check the Recovery.gov website.

less

 

Upcoming Events
  • October Luncheon

Speaker: Richard "Gus" Gustafson, Principal Deputy Director, DFAS
Topic: Mentoring....A Critical Element of a Successful Career!
Date: Thursday, October 8, 2009
Time: 11:30 am - 1:00 pm
Location: DFAS Conference Center - Room C-153

Description: Mr. Richard "Gus" Gustafson, the DFAS Principal Deputy Director will be AGA's guest speaker on October 8th. He will share his thoughts on "the Power of Mentoring - One Person's Perspective." He'll explain the importance of being a mentor or a mentee, review the various types of mentoring, discuss the power of informal mentoring, explain the various mentoring roles, and end with his personal reflection on the value of mentoring. As Mr. Gustafson is firmly committed to the power of mentoring, you won't want to miss the opportunity of learning from him!

Member Price: $11.00
Non-Member Price: $14.00

Note: Please contact Jessica Carse (3-9607) or Jen Hurles (3-0990) if you should have any questions or special dietary needs. Also, luncheon tickets are non-refundable.

Tickets can be purchased until NOON on Friday, October 6th, from:

BLDG 21:
Jessica Carse (693-9607, cube 6C-268)
Barb Bail (693-0657, cube 3C-084)
Joyce Maleski (693-1334, cube 6A-270)

BLDG 10:
Jen Hurles (693-0990, Internal Review, 10-10-57)


less

  • Audio Conference

Topic: Internal Controls for Auditors, Management and Staff - Making Government Organizations More Effective
Date: Wednesday, October 7, 2009
Time: 2:00 pm to 3:50 pm
Location: DFAS Conference Center - Room C146

Description: AGA, in conjunction with the National Association of State Auditors, Comptrollers and Treasurers (NASACT) and the Association of Local Government Auditors (ALGA) is pleased to announce a new and increasingly important topic to our audio conference schedule—understanding the role of internal controls in improving government operations.

more

Government managers and auditors at all levels will gain a better appreciation and understanding of internal control systems and how to assess their effectiveness.

The audio conference will cover the following topics:

  • Why internal controls are important and your responsibilities under that system
  • Internal control frameworks
  • Understanding COSO
  • Risk assessment models
  • Assessing and changing control systems
  • Strong controls, but the wrong controls—when to recommend preventive controls versus detective controls
  • Effectively conveying audit results and internal control findings

Guidance on internal controls is important and the seminal document Internal Control - Integrated Framework issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO) provides an excellent framework for organizations to follow. Unfortunately, organizations often place too much emphasis on the wrong control components under the misguided premise that control activities (i.e., policies and procedures) are the most critical elements of an organization's success. This misplaced focus can cause managers to respond with strong—but wrong—preventive controls over day-to-day activities, which ultimately frustrates efforts to correct an organization's real problems.

It's time to identify and implement the right controls to prevent a recurrence of past practices, which have harmed major organizations involved in fraud and scandals over the years. This audio conference will explore internal control concepts that can make for a high-performing organization and offer managers and auditors tools to assess internal controls within their organizations.

To share their practical experiences in auditing and views toward the future of auditing are: David R. Hancox, CGFM, CIA, Audit Director, Office of the State Comptroller, State of New York; and Mary Peck, CIA, CCSA, CGAP, Director of Internal Controls, New York State Office of Mental Retardation and Developmental Disabilities.

Please join us for two hours of lively discussion about this important and timely topic. In addition to the speakers’ commentary, 20 minutes is set aside for questions.

less

 

 

less

ffkjgkjfgf kjfhsdkjfh dfhkjhfklj djfhklejhr ;lksjdhjwehfjkhkjdhf sdfjhas;dfjh ;sdfh; ;djh djfhe hjdfhje
Member News
Member Spotlight
Name: La'Varis P. Woods
Length of AGA Membership: 2 Years
Certifications: I would like to study for the CGFM starting in January 2010
Agency: Defense Finance and Accounting Service
Position: Staff Accountant, General Ledger Division, Accounts Maintenance and Control - Acquisitions
Length of Service: 3 Years
Alma Mater: Elizabeth City State University, B.S - Undergraduate.
Keller Graduate School of Management, M.B.A - Graduate (Oct.2009)


Photo Courtesy - Tom Casasanta
What are some of your responsibilities and highlights from your current position? As the staff accountant for General Ledger Division, it is my responsibility to ensure that all tasks that come into the division are completed in a timely manner. A few of the task that come into the division include: DOD Dashboard, Federal Managers Financial Integrity Act (FMFIA), Enterprise Risk Management Processing (ERMP), the creation and submittal of Ad Hoc and Cyclic reports, cancelling year contracts review and approval, ULO reporting, preparing for customer visits, and Army Year End POC just to name a few. Also, I serve as the Navy Intern coordinator for the Dept of the Navy.
more

How has AGA positively impacted you and your job? AGA has given me a chance to meet new people and build lasting relationships. AGA has given me the opportunity to enhance my personal and professional skills during monthly luncheons, working as an Early Career Director, attending conferences, and assisting with community service opportunities. AGA has helped me build an extended network of relationships within the federal, state, and local government.

What are some of your future plans/goals?
Professional: I would like to obtain a CGFM certification and possibly a CMA or CPA afterwards. I plan to stay on track with my 5-10 year career plan by continuing to increase my personal development and leadership skills.

Personal: I would like to have children and travel.

less

CEC Spotlight

Name: Robyn Ruble
Length of AGA Membership: 2years
Certifications: None
CEC Position: Ways & Means Director
Agency: DFAS
Current Position: Defense Agencies - A/P
Length of Service: 2 years
Alma Mater: The Ohio State University


Photo Courtesy - Justin Sponseller

What are some current responsibilities and highlights from your CEC position? Assisting the other Director, Joyce Maleski, with fundraising ideas and activities in hopes of raising funds for the Greater Columbus AGA Chapter. This year we sold Heavenly Dips at the AGA/ASMC PDO in March. During the month of May, AGA earned 25% of the food purchases at City Barbeque when participants showed our flyer with their order.

What are some personal accomplishments or highlights you would like to share with other AGA members? I recently returned from maternity leave (June 15). My husband and I had a beautiful and healthy baby girl named Josephine Isabella Ruble (we call her Josie), weighing 6 lbs 11 oz on April 20. She keeps me busy and has brought an unexplainable happiness to my life.

What are your future plans/goals (personal and professional)?
In September, I am returning back to Franklin University in pursuit of a Master of Business Administration degree. Shortly after, I would like to earn a certification.

more


less

New Members

Ms. Cynthia Adams
DFAS-Columbus
Sponsor: Mr. Justin D. Morrison

Ms. Kristina DeBord
DFAS-Columbus
Sponsor: Mrs. Robyn Ruble
 

 

National AGA News
  • From the National President

Greetings from Mississippi! This is my first article to you as your National President. Over this next year, I look forward to working alongside you, our members, and our national staff. A year from now when we gather at the PDC in Orlando, I hope we can all look back as I say “thank you” for the best year of my life and as I hand over a better AGA and the presidency to Lisa Casias, AGA’s National President-Elect.

First, let me give a big hearty “Thank You” to our immediate Past National President, Sam Mok, CGFM, for a successful year. It has been privilege and honor to serve under his leadership.

Also, I must give a HUGE “Thank You” to the technical and host committees as well as the National Office staff for their roles in the PDC in New Orleans—what a tremendous SUCCESS! You have set the bar high for the PDC 2010 in Orlando!

I have chosen “Think Big! Act Courageously! Make a Difference!” as my presidential theme for this year, and I believe it comes at a critical time in our nation’s history as we tackle our uncertain economy. The many individuals who make up AGA’s membership have and will continue to have an extraordinary impact on our country’s future. AGA is the thought leader for Advancing Government Accountability. We must think big regarding what we can accomplish; we must act courageously to champion the cause of accountability, transparency, performance management, integrity and trustworthiness; and, we must guide our efforts to make a difference in the lives of the citizens who rely upon our respective governments through effective government financial management. Read more.

  • AGA Publishes Its 2009 Member Centric Report
AGA is proud to distribute its 2009 Citizen-Centric Report to our Members. We hope you find this succinct, four-page report on the progress of our Association over the past year to be informative. It remains a work in progress, and we invite your feedback so our future reports will be even more useful to our members and other stakeholders. AGA is promoting the use of similar four-page Citizen-Centric Reports by entities at all levels of government.
 
 
more

 

less
Government News
  • CAUSEY: Cost of Insurance May Bite Workers
  • By Mike Causey
  • washingtontimes.com

Federal workers who want to avoid a potential cut in take-home pay in January need to do some serious homework next month. That's even more critical for retired government workers and their survivors. Here's the deal:

• White-collar (nonpostal) federal workers are slated to get a national pay raise of 2 percent next year. That amount could be slightly higher in Washington-Baltimore, New York and San Francisco once a locality adjustment is tacked on.

Last January, the national federal pay raise was 2.9 percent. However, when locality pay was factored in, the total increase for the largest concentration of government workers, right here in the Washington metropolitan area, was a combined raise worth 4.78 percent. To see how that played out in other cities, use this link: http://opm.gov/flsa/oca/09tables/pdf/saltbl.pdf

more

• Because of a decline in living costs during the past 12 months (not the calendar year), federal-military-Social Security retirees who got a 5.8 percent cost-of-living adjustment last January will not get any COLA increase next January.

• Health-insurance premiums covering 9 million members of the civilian federal family are going up an average of 8.8 percent next year. Before you decide to end it all, remember the word "average" may not apply to you or yours.

On the surface the situation looks bad. A 2 percent raise for a GS-10 employee at the $50,000 level or a long-time GS-15 being paid $153,200 will overcome higher health premiums with money left to spare. But for a lower-level fed making $25,000 a year before many, many deductions, the health premium increase could hurt — if you are "average."

Whether you are high-level or in a lower grade, and whether you are getting a pay raise or not getting a COLA, the message is the same: You have to shop around during the open enrollment period that starts early next month.

Shopping for the best health plan deal is always important in the Federal Employee Health Benefits Program. But this year — with a very low raise and a zero COLA — is it essential.

Here's why.

Not all health-plan premiums are going up next year. Most federal workers in the Washington area, for example, are eligible to join 10 or more fee-for-service health plans with nationwide coverage. They also can choose from among a dozen or more local health maintenance organizations, which often charge lower premiums.

Not all of those plans are raising premiums. A few are holding the line. A couple are actually reducing biweekly premiums.

One of the beauties of the federal health program is that eligibles can switch from plan to plan each year in pursuit of specific benefits and/or lower premiums. People cannot be rejected for any reason. Also, they cannot be denied coverage because of age or pre-existing condition. Workers and retirees can also change plans anytime if they get married, divorced or have or adopt a child or if they have HMO coverage and move to a different geographic area.

In the event that a fed or retiree (or survivor) approaches the catastrophic limit for his existing plan, he can simply switch to another plan where the countdown begins at zero.

Most people — including the folks who work up the averages — concentrate on the Blue Cross-Blue Shield plans, for good reason. Sixty percent of the enrollees in the FEHBP are in one of the Blue Cross options, mostly in the standard option.

Many Blue Cross enrollees are retirees who have been with the plan for years. Retiree health costs are significantly higher, as a group, than those of younger workers. That has a major impact on the size of any premium increase for any plan, but especially the Blues family.

Next year, for example, the total premium for the Blues' standard self-only plan will be $248.42 biweekly, of which the federal government (the employees agency) will pay the lion's share, or $167.61. That means the increase to a single fed or retiree in that plan will be $10.63 every two weeks.

By contrast, the high-option benefit plan offered by GEHA (Government Employees Hospital Association) is cutting premiums next year. The bottom line is that people who enroll in self-only coverage will pay $11.95 per pay period less next year than they are paying today. GEHA's family plan will cut premiums by 72 cents every two weeks. GEHAs' standard option single and family plans are going up only $2.75 and $6.24 respectively.

The upcoming open season — Nov. 9 through Dec. 14 — isn't only about shopping for health plans. During that time, the Office of Personnel Management says you can also:

• Enroll in a flexible spending account — a health care and/or dependent care account, under the FSAFEDS Program. Unlike with other programs, employeesmust re-enroll in FSAFEDS each year to participate. Enrollments do not carry over year to year.

• Enroll in, change, or cancel an existing enrollment in a dental plan under the FEDVIP Program.

• Enroll in, change, or cancel an existing enrollment in a vision plan under the FEDVIP Program.

• Enroll in, change or cancel an existing enrollment in a health plan under the FEHB Program.

Benefit changes, if any, will be announced later on but in plenty of time for the open enrollment period. Some of the plans will put more emphasis on health, wellness and preventive medicine. There is speculation that some plans may offer coverage (at a price) for children over 22.

Meantime, do the math. And try to avoid being "average."


less

Treasurer's Report
As of September 22, 2009
Checking Account   Savings Account
Beginning Balance
$5,918.56
  Beginning Balance
$6,561.09
Deposits
$631.49
  Transfer to Checking
$0.00
Expenditures
$723.27
  Interest Earned
$5.00
Transfer from Savings
$0.00
 
Ending Balance

$6,566.09

Ending Balance

$5,826.78
   
     
Total Balance

$12,392.87
Auditor's Perspective
  • Eliminating Spreadsheet Risks
  • A Guide for Internal Auditors to Regain Control and Limit Exposure
  • By Richard Blaustein, President, Analytic Solutions Inc.
  • theiia.org

Spreadsheet models and reports can be powerful tools that provide tremendous analytical insight and help guide key decision-making processes throughout an organization. Their extraordinary versatility allows them to be used across every functional area of an organization for almost any type of reporting or analytical need. Unfortunately, however, the vast majority of these spreadsheet tools are created without using appropriate controls, testing procedures, and design standards. In such cases, the results can be disastrous. But it doesn't have to be that way.

The risk exposure associated with spreadsheets is enormous — perhaps one of the greatest risks that exists within an organization. Internal auditors struggle constantly with how to control this risk without removing these otherwise invaluable tools from the hands of those who depend on them. They are faced with the weighty dilemma of how to foster and not inhibit business value creation, while at the same time preventing latently destructive practices from crippling an organization.

The good news is that spreadsheets are, in fact, eminently controllable. Internal auditors have the power to put in place specific procedures that can all but eliminate spreadsheet risk. They can control the previously uncontrollable, and do so without stifling the analytical horsepower that drives an organization to excellence. There are three general categories of spreadsheet integrity risk: structural design, calculation formulas, and data inputs.

more

STRUCTURAL DESIGN

The design of the spreadsheet's structure is one of the most important mechanisms to ensure its success — both in the short term and well into the future. One of the biggest risks with spreadsheet models is the "Black Box Effect," when only the original author knows how it works, can make changes, or even run it correctly. In today's business world, job responsibilities change with the wind, and people come and go. Even if the analyst who inherits the model is an "Excel guru" and claims to have it figured out, if it was not well-structured in the first place then something has likely been overlooked. Everything seems fine, decisions are being made based upon the model's output, but no one realizes that the "Excel guru" didn't update a key data input or formula or piece of visual basic for applications code. Millions of dollars are secretly being misallocated via incorrect decisions — directly the result of modeling errors that would have otherwise been preventable by correct structural design.

How does one achieve correct structural design? Interestingly enough, it starts with a simple mind-set. Instead of building spreadsheet as if building it for oneself, users should build them as if they were building it for someone else. Spreadsheets should be intuitive. If it's not clear to anyone who uses it, exactly what data inputs are needed, and where they need to be entered without missing any single input requirement, then the spreadsheet model will ultimately fail.

The key ingredient in following through on this mind-set is to design the spreadsheet with a user-friendly graphical user interface (GUI). Essentially, this is a menu page worksheet that allows the user to click on icons and buttons to navigate to where they want to go — data input sections, results sections, or model administrator sections. Instead of relying on finding the right worksheet tab to click on at the bottom of the workbook, the user can easily click on the corresponding button on the menu page. Depending on the complexity of the spreadsheet model, there can be 10, 20, 30, or more individual worksheets, and thus worksheet tabs. It can be incredibly difficult for a user to figure out which ones they need to click on to get to the right place, and then to which section within the selected worksheet. With a GUI menu page, the worksheets and data ranges can be organized and categorized intuitively so that it is clear to the user what to click on. At the same time, users will know every data input section that needs to be updated, because each input section is right in front of their eyes on the menu page. As a result, it is far less likely that something will be missed.

CALCULATION FORMULAS

One of the biggest integrity risks in spreadsheet models and reports, and one that should cause many a restless night for internal auditors, is the lack of control in the core engine of a spreadsheet — the formulas that calculate the end results. There are four primary deficiencies that the vast majority of spreadsheet model authors fall victim to.

Fixed-value Formulas A formula should never contain a fixed ("hard-coded") value. Yet, a deep look into almost every spreadsheet model or report — even those built by internal "Excel gurus" — invariably contains these types of ticking time bombs. Any built-in factor will at some point change, and when it does, the spreadsheet model will produce incorrect results, leading to bad decisions. Even seemingly "permanently" fixed components, such as time, can change within the context of business operations. For example, multiplying a daily production number cell reference by a fixed five days within a formula to calculate the week's production is flawed and incorporates unnecessary risk. What if the business expands and the work week is extended to a seven-day production schedule? Then the calculated results are incorrect.

Preventing these types of mistakes is simple: Separate the input components from the formulas. When all components are placed into a separate data input section, the spreadsheet model analyst can easily see what inputs and assumptions need to be entered or updated, and then can do so easily.

The bottom line is that things change and formulas need to be flexible to isolate the components of potential change. It cannot be assumed that the spreadsheet analyst will remember to go back and change all of the impacted formulas if a fixed value formula's data component changes. Even if the analyst does remember, he or she may miss a formula or a block of formulas. This cumbersome review would take an enormous amount of time, even if it were done without any mistakes.

Lack of Columnar or Row Consistency Spreadsheet model authors often take shortcuts by creating formulas that are different across similar types of columns. For example, in a spreadsheet with months across the top of the sheet in columns the author might reference a different input for each year. As soon as a change is made or years are added at a later time, the analyst might forget that each year's formulas are different, and as a result make a change in the first column's formula and mistakenly copy the modified formula across all columns to the right, making all of the years reference the year-one input. If the model owner changes, the likelihood of this mistake happening increases exponentially. To prevent this, all the columns should contain the exact same formula. The formula itself should contain the internal logic to look up the corresponding year's input and apply it accordingly.

No Protection One of the most dangerous risks to a spreadsheet model or a report's integrity — and perhaps the easiest to address — is worksheet protection. As a default, Excel locks all cells in a spreadsheet. However, to make this take effect, the worksheet itself must be protected. Data input cells should be unlocked so that a user can enter and change data input assumptions. All other cells — especially formula cells — must be kept locked. When the model or report is completed and in use (i.e., development is finished), each worksheet within the workbook should be password protected so that formulas cannot be accidentally deleted or modified, and rows and columns cannot be inserted, which in effect could destroy the integrity of the spreadsheet model.

No Intrinsic Error Checks Even with thoughtful and careful calculation formula writing and subsequent quality control testing, there will be times when errors occur that only manifest themselves in certain situations. An error in one particular formula may be triggered only in certain circumstances, yet cause the model to produce incorrect results. In such a case, the dormant error occurs at some point after the quality control checks have already been completed, and as a result, the model produces incorrect results that may never be discovered.

To control for this type of error and prevent its occurrence, a spreadsheet model or report should contain intrinsic error checks within the model itself as a way for the model to, in effect, internally audit itself. Essentially, these error checks are formulas that are written and placed at various key points throughout the spreadsheet to check that various results match the intended result. They can automatically check if numbers that are supposed to add up to 100 percent do not, if the sum of the parts does not equal the whole, if a result is a negative number, or if a result exceeds a certain unreasonable predefined threshold. If any of these errors occur, a flag is triggered. A related process consolidates the status of these error checks and one quick glance in a very visible part of the spreadsheet model tells the user if there is a problem.

These types of continuous and self-auditing devices can be — and depending on the model complexity and value to the organization, should be — expanded upon far beyond the preceding simplistic examples. Automated pop-up or e-mail alerts can be used to prevent the user from accessing the results until errors are corrected and can alert a systems administrator so that the error occurrences are immediately transparent throughout the organization.

DATA INPUTS

The old adage, "Garbage in, garbage out," applies to data inputs. A model is only as good as the data that feeds it. Even if all other aspects of a spreadsheet model are robustly controlled, an end user still can make a typo and enter the data input incorrectly. Similarly, users can misunderstand the type or format of the data that is desired, thereby making an incorrect entry for which the model depends.

Even though these types of end-user errors can occur, there are specific mechanisms that can be incorporated into a spreadsheet model to greatly reduce the likelihood of their occurrence. The three primary categories of these types of end-user error control mechanisms include:

Data Validation Checks Each data input cell in a spreadsheet can be set such that only certain types of data or ranges of data are allowed to be entered. Otherwise a customizable warning message appears, and the user is alerted to the problem so that he or she may retry under the pre-established constraints. For example, a data input cell can be limited to only allow positive numbers, whole numbers (integers), dates, times, percentages, or inputs within a specified range.
Data Entry Controls There are many types of data inputs that lend themselves to using data entry control objects such as option buttons, check boxes, list boxes, and drop-down combo list boxes. These types of tools are an excellent way to improve ease-of-use, and more importantly, to further prevent end-user data entry error. For example, the option button allows for specific answers such as "yes" or "no" without risk of typos that will lead to error messages. Also, slider controls allow entries within a specified range while forcing the user to visually focus on the relative position — thus 40 percent won't be confused with four percent, even when both answers would pass the data validation check.
Explanatory Features Some data input labels are very clear about what specific information is required, such as "Sales Units (thousands)." However, many types of data inputs are less intuitive to a potential user. An example might be "Marginal Income Tax Rate (%)." The model author might have intended for the user to enter a consolidated rate of federal, state, and local taxes, but the user might have only assumed federal. The result is a data input error that might result in a bad investment decision.
There are several ways to avoid this type of user confusion. All operate under the same premise, which is to give the user plenty of explanation and information as to exactly what data is called for. An inserted comment or data validation can be used to add an explanatory note. In cases where an in-depth or overt explanation is required, it is better to add a help button next to the data input cell. A custom-created help button is an effective way to provide valuable information to the user, demonstrate examples, and direct the user to additional resources if further help is needed. It also makes the option of getting helpful information much more apparent, because the help button is prominently displayed.

All in all, these types of explanatory features are vital to correct spreadsheet model usage. If users clearly understand what data is needed, then there is a far greater chance that the correct data will be entered, and the model will produce the correct results.

IMPLEMENTING BEST PRACTICES

Spreadsheets provide unparalleled flexibility and power in analyzing, reporting, enhancing, and optimizing performance and decision-making processes throughout an organization. Their potential value is near limitless. However, if not designed and constructed correctly, spreadsheets can pose tremendous risks by generating incorrect information and leading to poor decisions. Fortunately, these risks can be virtually eliminated by following appropriate design and development practices.

less

 
Community Service Corner
  • Professional Clothing Drive

During the months of September and October 2009, the Greater Columbus Chapter of the Association of Government Accountants (AGA) will be sponsoring a Professional Clothing Drive. The purpose of service project is to obtain gently used professional clothing and accessories that will be provided to Central Ohio residents. Items that will be accepted are business suits, slacks and pants, skirts and dresses, blazers, ties, sweaters and blouses, shoes, handbags, scarves, and belts. Additionally, donations of hangers would be appreciated. Please contact either of the Community Service Directors listed below for drop-off locations and additional information.

Kortney Whiteman 614-693-0553
kortney.whiteman@dfas.mil

Jennifer Lynn 614-693-1286
jennifer.lynn@dfas.mil

more

The AGA
less

Technically Speaking
  • Harvesting Tax Benefits of Green Building Incentives
  • Energy-efficiency credits and deductions are sprinkled throughout the Code
  • By Ralph S. Watson II
  • journalofaccountancy.com

In the past two years, several federal tax incentives have been extended and enhanced for designing and constructing energy-efficient buildings, both residential and commercial. Some of these measures should be equally attractive for businesses and individuals looking to remodel existing homes and workplaces to save on energy and, as a bonus, taxes.

Four federal laws enacted since early 2008 contain provisions targeting energy conservation: the Economic Stimulus Act of 2008, PL 110-185 (ESA); the Housing Assistance Tax Act of 2008, PL 110-289 (HATA); the Emergency Economic Stabilization Act of 2008, PL 110-343 (EESA); and the American Recovery and Reinvestment Act of 2009, PL 111-5 (ARRA)

In addition, many states and local governments have enacted provisions to encourage energy-efficient buildings.

more

Too often, a flurry of legislative activity can overwhelm taxpayers and their advisers with new provisions. Typically, the taxing authorities need time to develop summaries and guidelines for newly enacted laws. As a result, taxpayers who could benefit from the deductions and credits might not be aware of them, in some cases missing out on substantial savings. Here are five recent federal provisions expanded or extended by the EESA and the ARRA that should be of interest to builders, architects and anyone in the market for a new building or thinking about retrofitting one for energy savings. These are by no means all the tax incentives for energy-efficient building or remodeling even in these two acts. The EESA extended a number of provisions of the landmark Energy Policy Act of 2005. Among the ESA’s provisions were those providing for 50% bonus depreciation on equipment and more funding for the low-income home energy assistance program. HATA requires states to consider energy efficiency in low-income housing when allocating available tax credits to those projects.

ENERGY-EFFICIENT COMMERCIAL BUILDING DEDUCTION

For commercial buildings, IRC § 179D provides a deduction of up to $1.80 per square foot for energy-efficient features of the building’s construction or retrofit. The taxpayer must secure an analysis by a qualified person (defined as a professional engineer or contractor licensed in the jurisdiction where the real estate is located) who must use software prescribed by the IRS. This deduction is effectively an acceleration of depreciation deductions that would have otherwise been spread over a 39-year recovery life, and reduces tax basis accordingly.

This incentive was originally enacted as part of the Energy Tax Policy Act of 2005 (PL 109-58), but was largely overlooked by tax advisers because of its original expiration date of Dec. 31, 2007, for buildings placed in service after Dec. 31, 2005. It was extended an additional year by the Tax Relief and Health Care Act of 2006 (PL 109-432) and then until the end of 2013 by the EESA. Qualifying commercial buildings can include multifamily residential structures so long as they have more than three stories above grade.

Three primary building components are analyzed to determine the qualifying credit, with each available for a deduction of 60 cents per square foot:

Interior lighting systems
HVAC (heating, ventilation and air conditioning) systems
Building envelope (defined as the outer shell used to protect the indoor environment as well as to facilitate its climate control)

In each case, the analysis considers the extent to which the construction of the building provides energy consumption reductions from the American Society of Heating, Refrigerating and Air-Conditioning Engineers (ASHRAE) 90.1-2001 baseline (as in effect April 2, 2003), which is a widely used industry standard. Since the majority of states’ standard building codes are based on the subsequently developed ASHRAE 90.1-2004 or later iterations, virtually all buildings in these states will qualify for some or all of the deduction, even if built to only the minimum standards. Engineers use a modeling guideline promulgated by the U.S. Department of Energy. The study, which must include a signed certification, is not attached to the taxpayer’s return but is instead maintained in the taxpayer’s file for future documentation in case of an IRS inquiry or examination.

An interesting application of this benefit occurs when the building is owned by a government, school or municipality. Since Congress’ intent was to encourage energy-conscious construction, and many energy-efficient buildings across the country are owned by government agencies (which of course do not pay taxes), there was concern that the impact of the incentive would be dramatically reduced since it was not useful for these properties. To address this concern, Congress made the unusual decision to allow the building designer (typically the architect) to take the deduction, even though the designer has no ownership interest in the property. In this case, the deduction is particularly valuable, since no basis reduction is required. The building owner must approve the choice of the designer in writing.

The IRS has released further guidance in notices 2006-52 and 2008-40. The ARRA increased the carryback of net operating losses to up to five years for certain small businesses, so this deduction could provide an immediate cash benefit even if the current economic downturn has reduced or eliminated profitability in the current tax year.

NEW ENERGY-EFFICIENT HOME CREDIT

Although this incentive is scheduled to sunset at the end of this year, IRC § 45L has since August 2005 allowed eligible contractors that construct new energy-efficient homes to claim a federal tax credit of $2,000 for each new home they sell. A qualified energy-efficient home is one that is certified to consume at least 50% less energy for heating and cooling than that of a comparable home constructed in accordance with the standards of section 404 of the 2004 Supplement to the 2003 International Energy Conservation Code (2004 Supplement), and to have building envelope component improvements that provide for a level of heating and cooling energy consumption that is at least 10% below that of a comparable home. In addition to meeting these requirements, manufactured homes must also meet the Federal Manufactured Home Construction and Safety Standards (24 CFR part 3280). A reduced credit of $1,000 is also available for manufactured homes that meet certain lower standards.

The intent is to encourage builders to invest more in these efficiencies by allowing them to offset some or all of the cost through the credit. Since the credit is per qualifying home, this can add up to a sizable tax benefit. In addition, of course, homeowners will realize monthly savings on energy bills, and probably higher home values, as a result of these enhancements to the property.

As with the section 179D deduction, the certification is made by a licensed professional engineer or a contractor who is unrelated to the homebuilder or manufacturer. Many homebuilders who build in accordance with Leadership in Energy and Environmental Design (LEED) standards will qualify for this credit, and others who might not qualify could do so with relatively minor construction changes. LEED was developed by the U.S. Green Building Council for rating a building’s site design, water and energy conservation, use of environmentally friendly materials and other criteria. The certification must come from an individual certified by the Residential Energy Services Network (or an equivalent rating network) to conduct these studies, using software approved by the IRS for this purpose. As with the section 179D deduction outlined above, this certification is not attached to the tax return but is maintained in the taxpayer’s files in case the IRS conducts an inquiry or examination.

These provisions are outlined in IRC § 45L, and further guidance is provided in IRS Notice 2006-27. The credit coordinates with the other components of the general business tax credit under section 38 and reduces the taxpayer’s basis in the building. Unused current-year credits may be carried back one year or forward up to 20 years. Although this credit is set to sunset at the end of this year, others were extended through 2010 and in some cases expanded by the ARRA. Among these is the section 25C residential building improvement credit available to homeowners.

SECTION 25C RESIDENTIAL HOME IMPROVEMENT CREDIT

For 2009 and 2010, this credit is expanded from 10% to 30% of qualifying improvements, with a lifetime cap per taxpayer of $1,500. Prior credits claimed under similar rules in effect before 2009 do not reduce this credit.

Qualifying improvements include installing insulation materials, exterior windows (including skylights), exterior doors, central air conditioners, natural gas, propane or oil water heaters or furnaces, hot water boilers, electric heat pump water heaters, certain metal roofs and stoves, and advanced main air circulating fans. These improvements qualify only if made to existing homes. The improvements must meet certain efficiency guidelines published by the IRS (see especially an interim guidance update, Notice 2009-53, issued June 1, 2009), and the vendor will typically be able to determine if an item qualifies.

SECTION 25D RESIDENTIAL CREDIT FOR CERTAIN ENERGY-EFFICIENT ITEMS

Another ARRA amendment allows increased credits for installing state-of-the-art energy- efficient systems in new or existing homes through 2016. A 30% tax credit is available for geothermal heat pumps, solar panels, solar water heaters, small wind energy systems and fuel cells (IRC § 25D). The credit applies to the cost of labor and installation as well as the cost of the equipment. Except for fuel cell credits, which qualify only if made to an existing principal residence, these credits are also available for improvements to rental properties and second homes. There is no cap on the amount of credit that can be claimed. IRS Form 5695, Residential Energy Efficient Property Credit, has been developed to assist taxpayers with claiming this credit. See also interim guidance in Notice 2009-41, issued April 22, 2009.

ACCELERATED DEPRECIATION FOR "SMART" ELECTRICAL SYSTEMS

The EESA amended the IRC § 168 MACRS (modified accelerated cost recovery system) provisions to assign a 10-year recovery period to qualified “smart” electric meters and grid systems (section 168(e)(3)(D)(iii) and (iv)). Otherwise, electrical transmission and distribution equipment and related land improvements generally are 20-year property. The property must have been placed in service after Oct. 3, 2008. The taxpayer realizing the enhanced depreciation, of course, is generally an electrical utility. But smart meters can benefit electric customers as well (see sidebar, “Smarter Electric Power,” below).

On behalf of their clients, particularly those in construction trades, CPAs can review these federal provisions as well as state and local ones in their jurisdiction. Often, the local or state taxing authority will be helpful for gaining a full understanding of additional tax incentives, in addition to providing information regarding any loan or grant incentives that might be available.

less

But I Digress

Wow! Can you believe it's been five years?!?!?!?! I can hardly believe it myself. It seems just like yesterday when Ken came to me and asked if I'd be willing to write a little filler piece for the then "Unnamed Newsletter." I told him that I'd be more than happy to, if I could write about what I wanted and do so anonymously.

Since that time I've had the opportunity to share my, as described by Ken, "random thoughts of a mad individual." In some ways I miss the old format of the newsletter; I had to be concise at times to share my thoughts in the sometimes tiny amount of space afforded me. This new format allows me to ramble on and on and on and on . . . Sorry, I lost myself there.

Anyway, here's to you, the Greater Columbus Chapter of the AGA, congratulations on five wonderfully successful years. I hope the future holds many more successes for this organization.

And I hope I'll continue to be allowed to share my random, insane, albeit anonymous, thoughts for a little while longer. But I digress . . .

Tech Talk
  • DISA Ramps up Cloud-Computing Platform
  • By Joab Jackson
  • gcn.com

Military program managers frustrated by having to wait six months to get a server provisioned might want to take a look at the Defense Information Systems Agency's new cloud-computing offering. The agency is boasting that can provide a NIPRnet-connected, production-ready virtual server within 72 hours.

DISA announced today that it has expanded the scope of its Rapid Access Computing Environment (RACE) to incorporate production-ready services.

DISA launched RACE a year ago as a self-service environment for defense developers to provision virtual servers and test new applications in a safe environment. Now the agency has expanded the offering as a production platform.

"It's not just a test-and-development environment anymore," said Henry Sienkiewicz, technical program director of DISA's computing services. “It's also a production environment.”

more

All branches of the military services can provision servers through RACE for their production-ready applications. The applications that are best served by that environment are lighter ones that could run easily in a standard Microsoft Windows or Linux environment. Convoy control systems, satellite controls or even smaller command-and-control systems would work well. "It would almost be the same sort of applications that you would [deploy] within a commercial hosting company," Sienkiewicz said.

One advantage that DISA offers over commercial hosting companies is its familiarity with meeting defense security standards. In the new environment, accreditation for production systems takes only about 40 days, or about half the time it normally takes to get a new system audited and accredited for military use, Sienkiewicz said.

The agency has assembled a package for users called Pathway to Production, which includes integration with the Defense Department's Vulnerability Management System, the Enterprise Mission Assurance Support Service (eMASS) and associated documentation. DISA has also prepared the virtual environment to conform as closely as possible to the DOD Information Assurance Certification and Accreditation Process and the DISA Security Technical Implementation Guides.

DISA officials hope to cut more time from the accreditation process by further integrating RACE with eMASS and other accreditation processes. Users can also save time by developing applications right in the RACE testing environment.

"Applications developed in the RACE testing environment inherit all the information assurance controls in the production environment, and that streamlines a great deal of human intervention," which shortens accreditation time, Sienkiewicz said.

The service offers Windows Server and standard Linux, Apache, MySQL, PHP stacks. The basic service runs $1,200 per month per server. Users can provision up to 1T of storage. The provisioned servers will be accessible via the Unclassified but Sensitive IP Router Network and, beginning in the second quarter of fiscal 2010, the Secret IP Router Network.

Although DISA is using virtualization to maximize server use, end users do not need expertise in virtualization management. To them, the service appears as "a preloaded, preconfigured server," Sienkiewicz said.

Once commissioned, virtual servers can be operational within 72 hours, and agency officials hope to shorten that time to less than 24 hours. The agency has maintained an uptime of 99.999 percent with its hosted offerings and plans to offer that level of service to RACE users, Sienkiewicz said.

less

Quote of the Month

If human beings had genuine courage, they'd wear their costumes every day of the year, not just on Halloween.

  • Doug Coupland
The Bottom Line
  • Social Security 101
  • By Tammy Flanagan, National Institute of Transition Planning
  • govexec.com

Social Security used to be a topic of little interest to federal employees, since few government workers had coverage and they were exempt from FICA taxes while working under the Civil Service Retirement System. Most questions revolved around the evil twins (as Mike Causey calls them): the Windfall Elimination Provision and the Government Pension Offset.

But times have changed. Now only 20 percent of federal employees are under CSRS. Those under the newer Federal Employees Retirement System are fully covered by Social Security, and they often have questions about when and how to apply for retirement benefits.

Here are the types of benefits you might be able to choose from when it comes time to apply for Social Security:

Your own.
Your current spouse's.
If you are divorced, your former spouse's.
If you are widowed, your deceased spouse's.
If you are very young, your parents'.

more

Here's what else you should know:

You can apply as early as 62.
You can apply at your full retirement age, somewhere between 65 and 67.
You can apply for delayed credits as late as age 70.
Or, you can apply anywhere in between.

You can receive only one benefit at a time, but it is possible that more than one person can receive benefits based on your work record. Whether people can receive a benefit from you depends on:

If you have a former spouse, the number of years you were married.
Whether you are currently married.
Whether you have any dependent children.

Terms and Conditions

Before we look at some specific examples of how the Social Security benefits process plays out, here are a few important pieces of terminology to understand.

Full Retirement Age. It can be from 65 to 67. Here's how to figure out yours.
Primary Insurance Amount. This is the benefit a person would receive at full retirement age, without reductions for early retirement or increases for delayed retirement. Social Security has more complete definition and offers a fact sheet on how benefits are calculated.
Reductions. You can apply for Social Security retirement any time between 62 and your full retirement age. But if you start receiving benefits early, they will be reduced by a fraction of a percent for each month before your full retirement age. This also applies to the benefit you might be applying for on your spouse's work record. People born in 1960 or later will have a greater reduction than those born earlier. Here's a chart showing the reduction.
Delayed Credits. Social Security benefits are increased by a certain percentage if you delay your retirement beyond your full retirement age. Here's something that's a little quirky: This delayed credit does not apply to a spouse's benefit, but it can be included in a widow's amount. Here's more information. Because of the increase in the full retirement age from 65 to 67, the delayed credits provide a bigger increase to those born in 1937 than they do for people born in 1960 or later. Here's a chart explaining how it works.

Now let's look at a few scenarios to get you thinking about your options.

Two Income Couple; Both Covered by Social Security

At their full retirement age, Pat and Joe each will qualify for $1,800 per month in Social Security retirement benefits. Pat retired at 62 and decided to file early, so her benefit will be reduced by 25 percent to $1,350. Joe is 66 and has decided to apply for spousal benefits via Pat instead of on his own. He will receive $900 per month -- 50 percent of his wife's primary insurance amount. He then will apply for his own Social Security benefit at 70 to take advantage of delayed retirement credits. That will boost his monthly benefit to $2,376 -- a 32 percent increase during the four years between 66 and 70. He must be clear when he applies for Social Security at 66 that he is applying only for the spousal benefit.

One Income Couple Covered by Social Security

Jeff's wife, Annemarie, is 62 and doesn't work outside the home. He is at his full retirement age for Social Security -- 66 -- but wants to continue working. Jeff can apply for his own benefit, but also can request that it be suspended until he reapplies later to receive the delayed credits. Once Jeff applies for his benefit, Annemarie can apply for a spousal benefit. Since she is only 62, she will be entitled to 32.5 percent of Jeff's primary insurance amount. He is entitled to $2,000 per month, so she will receive $650 a month. At 70, Jeff can begin receiving his benefit with delayed retirement credits, and it will go up to $2,640.

Former Spouse

Suppose in the above example Jeff has a former spouse to whom he was married for more than 10 years. Lucy, the former spouse, has never remarried. She is the same age as Jeff and can file for benefits on his work record even before he files for his own. Since Lucy worked at lower wages, her own benefit at her full retirement age is only $500 per month. She can file for 50 percent of Jeff's $2,000. If she applies early, her benefit will be reduced whether she applies for her own or the one her ex-husband earned for her. If she has a more substantial benefit on her own, she also could use the strategy outlined in the two-income couple mentioned above. The fact that Lucy is eligible for benefits on Jeff's work record does not affect the right of his current spouse to collect her spousal benefit.

Widow

Widows can apply for benefits as early as 60 (50 if they are disabled). Starting at 62, they can choose between the widow's benefit or the benefit based on their own work record. If a widow applies earlier than full retirement age, the benefit received will be between 71.5 percent and 99 percent of the full benefit of the deceased spouse's. Widows at the full retirement age or older are entitled to 100 percent of the deceased spouse's benefit -- even if they applied for their own benefit early. This rule also applies to former spouses who were married for at least 10 years to a worker who is now deceased.

CSRS Wife Married to FERS Husband

Georgia has earned only 12 credits of Social Security coverage. She has been a federal employee since she was 19 and has been exempt from the FICA tax during her career. When she retired from government at 58, she worked part time for awhile, but does not have enough credits to qualify for her own Social Security retirement benefit. Her husband, Andy, 66, is retired and receiving his Social Security benefit. Georgia also is now 66 and would like to apply for spousal benefits based on Andy's work record. Ordinarily, she would be entitled to 50 percent of his $2,000 benefit. But she will be affected by the Government Pension Offset because she is receiving $3,000 per month in CSRS retirement benefits. In fact, her entitlement to the $1,000 per month Social Security spousal benefit will be offset by $2,000 (two-thirds of $3,000), so she won't be able to receive any spousal benefits. If Andy dies before her and she becomes entitled to the full $2,000 widow's amount, she still will be subject to the two-thirds offset, meaning she won't receive any widow's benefit.

The Big Do-Over

Bryan has been collecting his Social Security benefit since he was 62. Now, at 70, he receives $13,250 a year. He has decided to withdraw his original application so he can reapply for the delayed credits. He will have to pay back $94,556 that he has already received, but his new annual benefit will now be $20,693 a year. With the $7,443 increase, he will recover the redeposit amount and break even at about 83. When Social Security computes the amount of the payback, it doesn't include interest due. Bryan also can recover the taxes paid on the previously received benefits by filing with the Internal Revenue Service for a tax credit or deduction. The delayed credits also can boost the amount payable to a widow, even though they don't help the spouse of someone who is still living. In other words, if Bryan happens to die at 78, his widow could continue receiving the $20,693 benefit if it is higher than the benefit she is receiving on her own record and she is at least her full retirement age.

less

CGFM Update
  • March is CGFM Month

The Greater Columbus Chapter of AGA is preparing for National Certified Government Financial Manager (CGFM) Month, March 2009. There are several activities planned including an Appreciation Luncheon, on March 17, for our current Certified CGFM Members. The Columbus Center is holding a CGFM Training Class for those interested in preparing to take the CGFM tests from March 9-13. The Chapter Certification Committee will be setting up a table in the lunchroom during the month at separate intervals to assist employees who want to learn more about the CGFM program, and the benefits of earning a CGFM Certification.
more

 


less

Standard Deviations
  • Review: Martian Fluxx

Have you ever wondered if Martians envaded Earth, what they would sound like? Well, according to my nephew they sound much like a mix of dolphins and whales communicating via whistles, clicks, etc. For myself, perhaps I'm a little too old, but I think they'd sound an awful like everybody's (at least those of my generation) favorite Martian, Marvin (big kudos to Warner Bros for that brainwashing).

So you're asking yourself why all this discussion about Martians and how they talk. Well, the creative minds at Looney Labs have struck gold yet again with Martian Fluxx, the latest installment in the Fluxx family.

Fluxx is "The card game of ever-changing rules." The basic gameplay takes a hand or two to get down, but it's fairly straight forward. Keepers and Creepers can help you win (or keep you from winning). Rules are rules, play a rule card to change the rules in play. Action cards are actions you can take (take another turn, steal a card, etc). Finally, Goals tell you what you want to get to win the game.

In Martian Fluxx, you are the Martians and you are invading Earth. Be careful though, germs or the Army could send you packing your fleet back to Mars. Change the rules, collect the keepers, and watch out for the pathetic humans and you might just walk (or is that slither?) away victorious.

I played this game with several folks all of whom had a great time pretending to Martian invaders. I must have played three dozen or so games in the first weekend after getting my copy. Some games were really short, others long. But each game was different and exciting and kept us all laughing as we tried to take over the Earth.

As with the other versions of Fluxx available (Fluxx 4.0, Monty Python Fluxx, Zombie Fluxx, etc) the gameplay is smooth and everything you need to know is right there on the face of the card.

So, if you're looking for an out of this world adventure, try your hand at Martian Fluxx. Just becareful when handling the space modulator.

What: Martian Fluxx
Where: Local Game Store or LooneyLabs.com
When: Available now!
For More Information: www.looneylabs.com

Chapter Officers
Chapter President Nancy Zmyslinski, CGFM nancy.zmyslinski@dfas.mil
Chapter President-Elect Justin Sponseller justin.sponseller@dfas.mil
Treasurer Aubrey Martin, CGFM aubrey.martin@dfas.mil
Secretary Barb Bail, CGFM, CDFM-A
barbara.bail@dfas.mil
View Directors    
Membership Justin Morrison
justin.morrison@dfas.mil
James Cox
james.cox@dfas.mil
Early Careers Lyndsey Foell
lyndsey.foell@dfas.mil
La'Varis Woods
lavaris.woods@dfas.mil
Communications Merle Robinson
merle.robinson@dfas.mil
Kenneth George, CPA
kenneth.george@dfas.mil
Programs Jennifer Hurles
jennifer.hurles@dfas.mil
Jessica Carse
jessica.carse@dfas.mil
Certification Robert Palmieri
robert.palmieri@dfas.mil
 
Education Gene Petropavlovskiy
gennadiy.petropavlovskiy@dfas.mil

Lori Mikesell
lori.mikesell@dfas.mil

Community Service Kortney Whiteman
kortney.whiteman@dfas.mil
Jennifer Lynn
jennifer.lynn@dfas.mil
Ways & Means Joyce Maleski
joyce.maleski@dfas.mil
Robyn Ruble
robyn.ruble@dfas.mil
Chapter Historian HenriAnn Franklin
henriann.franklin@dfas.mil
 
By Laws Ben Novotny, CGFM
benjamin.novotny@dfas.mil
 
Hide Directors    
CEC Minutes
  • 21 September 2009

Chapter President-Elect:

  • Establishment of an Accountability Outreach Coordinator - Received email from AGA Hdq. regarding establishment of Accountability Outreach Chair (Director, Coordinator) position, a volunteer (not required for each chapter) to help promote AGA's accountability programs (CEAR, SEA, Citizen Centric). More info will be forthcoming - direct questions to Justin S.
  • Renewal of Insurance Policy - Time to renew Chapter insurance policy covering fundraising and off-site events. CEC agreed to renew. Joyce Maleski checking to make sure policy coverage includes increase in membership numbers and will coordinate payment with Treasurer by October due date.
  • Chapter Recognition Program (CRP) input - tomorrow at 11:30, C-138

  more

Programs:

  • Location of October Luncheon (5 Year Anniversary) - on-site or off-site. - suggestion for having luncheon off-site, however due to logistics of protocol involving the speaker, Mr. Gustafson, consensus that on-site would be better.
  • Date for November luncheon, Nov.12 is Accounting for Kids - Nov 12th date for luncheon changing due to scheduling conflict, Jessica Carse will check Conference Center room availability for Nov 5th (1st Thurs. of month).

Membership:

  • Suggestion for membership drive table in Café 21 in January.
  • The chapter has 14 new members this year.
  • Need to come up with method to reach new DFAS employees.
  • Our chapter will have a table at the Professional Development Fair (sponsored by ASMC) on Dec.

Early Career:

  • Change in Early Career Month (October to November)
    • CEC agreed to suggestion to move from Oct. to Nov.
    • Lyndsey Foell gave handout with EC events listed: membership drive, appreciation letters, breakfast with Directors, and social

Certification:

  • Bob Palmieri reported that he might be on extensive TDY until Dec, but plans to have brown bag CGFM study sessions in future.
  • Suggestion was made to hold another CGFM open house, survey interest, or have another article in the newsletter to "spark" interest in CGFM.
  • Nancy Z. reported that our chapter has volunteered to be a pilot location for on-site testing., pending AGA Hdq. agreement.

Education:

  • Regional PDC - Oct. 19-21 -
    • Registration Process, etc.
    • Number of attendees that DFAS will fund will likely remain same as last year (20-25 for Accounting Ops, 3 for SBM, etc.).
    • Need to "advertise" to members ASAP, Lori M. and Gene P. will draft email to be sent to members. Aubrey Martin volunteered to be registration POC.
  • Next AGA Audio Conference, Oct. 7,
    • Topic - Internal Controls for Auditors, Management and Staff - Making Government Organizations More Effective

Communications:

  • Newsletter submissions due to Merle and Ken by the 22nd
  • Website update: Main page of the website has been updated (per Ben Novotny), rest of website update still in progress.
    • Ken George reported that he is looking at new updating technology for website that should allow CEC to update their portions of site.
  • Ken will also print samples of name badges for use at luncheons, etc. CEC can select "favorite" and badges can be printed on cardstock from AGA Hdq with logo prior to Oct luncheon.
  • Several CEC members are not receiving AGA chapter emails and request was made to update/validate member list that is linked to distribution.
    • Ken will be validating and will send email with instructions for self-subscribing to list.

Ways & Means:

  • Joyce M. waiting for word from Kroger in regards to Kroger Community Awards Program.
  • Need 2 more volunteers for working this week's OSU game (9/26) and 4-5 more volunteers for games on 10/31 and 11/14.

Community Service:

  • Clothing Drive: Extended into October, due to delayed delivery of email message.
    • Clothing Drive is for professional clothing to be donated to Goodwill on Morse Rd (has professional clothing section), however Kortney W. volunteered to drop off other clothing as well.
  • Columbus Reads Program - Charles Miller is POC for volunteers to contact. Email was sent to members.
  • Accounting Day for Kids - Nov 12th, email was sent soliciting volunteers by Oct 14.

Historian:

  • N/A

By Laws:

  • N/A

less

Chapter Ways & Means
  • OSU Football Fundraiser
AGA will be once again participating in a fundraising event in conjunction with Ohio State Football games. Our chapter will be selling Ohio State merchandise for The Official Team Shop. The Team Shop has several stands located inside/outside the stadium that needs volunteers to assist in selling clothing related merchandise. AGA will be volunteering at one of these stands. Our tasks will include: interacting with fans, helping them with questions and merchandise sales, and handling money.

more

Rules/Regulations:

  • For each game, you will be required to be at the stadium 3 hours before kick-off.
  • The stand will be in operation throughout the entire game and about 30-40 minutes after the game.
  • You will be required to be at the stand at all times; that is, other than approved downtimes/scheduled breaks. During such time, you will have the opportunity to watch some of the game.
  • Please keep in mind this opportunity is not to be used as a free game day ticket.
  • Family members and children (over the age of 16) are welcome and encouraged to participate in this fundraising event.
  • Please keep in mind that AGA is required to provide 8-10 members per game, therefore if a no-show occurs, you forfeit the right to participate in future games.
  • Sign-up is a first come first serve basis. Any volunteers that surpass the 10 person threshold, will be waitlisted.
  • AGA will provide a $10.00 lunch compensation and a $10.00 parking fee reimbursement to all volunteers.

The 7 home games are listed below with their kick-off times. Please contact Joyce Maleski for the game(s) you are interested in working.

Game Date Opponent Report Time Game Time
October 10th Wisconsin TBA TBA
October 24th Minnesota 8:45 AM 12:00 PM
October 31st New Mexico St TBA TBA
November 14th Iowa TBA TBA

Further details will be provided to the volunteers once the work schedule has been finalized. In the meantime, please contact Joyce Maleski at joyce.maleski@dfas.mil or 693-1334 if you should have any questions or concerns.

less

 



ABOUT THE FEDERAL FOCUS
The Federal Focus is provided free of charge to members of the AGA Greater Columbus Chapter. It is intended for educational and chapter news sharing purposes only.

Submissions for publication should be submitted by the 22nd of the month for inclusion in the following month’s newsletter. Submissions can be sent to either Communications Director. Consideration for inclusion is based solely on the Editor’s judgment.

All previously published articles are copyrighted by their respective sources.