Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Supply Chain/ERP
Enterprise Software
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
Computerworld 2007Subscribe to Computerworld
40 years of the most authoritative source of news and information for IT leaders.

L.A. government struggling with new inventory system

 

Sign up to receive Security Resource Alerts

May 16, 2001 (Computerworld) -- The Los Angeles Police Department would have had to write a lot of tickets to break even after it got a $750,000 invoice for new citation books that should have cost just $7,500. The culprit: incorrect data entered into a new procurement and inventory-management system that Los Angeles' city government began using in January.

And the Police Department isn't the only agency that's having problems with the $11 million system, which is based on PeopleSoft Inc.'s enterprise resource planning (ERP) applications. City officials this week confirmed that multiple departments have voiced complaints about inadequate end-user training and help desk support, resulting in billing problems, late payments to suppliers and inventory shortages.

"The [system] was meant to speed things up and save money," said Laura Chick, a member of the Los Angeles City Council and the incoming city controller. "So far, we are not reaching all the goals we have set. There's a laundry list of problems." Chick and other city officials noted that training, or a lack thereof, is the major cause of the problems.

The city is using PeopleSoft's procurement, inventory-management and accounts payable modules. The applications have "bugs like every software package, but we've [reported] them to PeopleSoft, and they've been good at turning them around," said Bob Jensen, assistant general manager of the city's General Services Department.

Jensen, who's overseeing the project for the city, wrote in a report dated May 9 that problems with PeopleSoft's inventory module "have resulted in inaccurate shelf counts" of some supplies. Manual processes for doing the counts have since been implemented, he said, adding that other bugs related to receiving and inventory-replenishment procedures were mostly resolved earlier this month.

But Jensen said this week that the software bugs aren't to blame for most of the start-up pains being felt with the new system. "The procurement problems have to do with people problems," he said. In one case, Jensen noted, employees unfamiliar with the system populated PeopleSoft tables with inaccurate data, causing glitches.

According to a memo issued last Friday by the city's Office of Administrative and Research Services, many departments indicated in detailed reports "that additional training on the new system needs to be provided" to their workers. Jensen said extensive training programs are already offered on an ongoing basis, but he added that more training is planned.

The design of the new system and many of the employees who are using it have changed since the initial training was done, Chick said. In addition, she said, some departments don't have employees who are familiar with how "to run complex technology." Illustrating that point, Chick added that the city has also had problems with an older payroll system that predates the PeopleSoft applications.

Last week's memo said the help desk staffers assigned to the inventory and procurement system are "helpful, but the demand for their assistance is greater than their availability." It also noted that payments to suppliers are being delayed because of processing problems, causing departments to lose discounts they usually receive. "Some [suppliers] have not been paid large sums of money, and it's costing the taxpayers money," Chick said.

In the case of the big bill that the Police Department received for its new citation books, Jensen said in the report he wrote last week that warehouse workers within the General Services Department incorrectly priced the books at $1,649 apiece when they entered the inventory data into the new system. The actual price should have been $16.49 per book.

The police department was credited the difference after the error was discovered, Jensen wrote, and warehouse workers "have been re-instructed on the proper procedures for entering price information." But his report listed a variety of other problems that police officials had complained about, including out-of-stock supplies and an inability to track inventory.

Jim McGlothlin, regional vice president for education and government at Pleasanton, Calif.-based PeopleSoft, said the Los Angeles project "was not an easy implementation." The rollout of the new system was a relatively extensive two-year project requiring "business process re-engineering and lots of [internal] changes" by the city, McGlothlin said.

In such cases, he added, it becomes "incumbent on the users to adhere to the new processes." Despite the bugs cited by Jensen, McGlothlin said that to his knowledge, the city hasn't encountered any major problems with the PeopleSoft software itself.

Public-sector ERP projects can be problematic because government agencies often are working on tight budgets and have to accept the lowest bids on system implementation contracts, said Joshua Greenbaum, an analyst at Enterprise Applications Consulting in Daly City, Calif.

ERP vendors such as PeopleSoft and Walldorf, Germany-based SAP AG have a good reputation for the quality of their public-sector applications, Greenbaum said. But IT managers at government agencies as well as private-sector companies should be careful not to "nickel-and-dime on the implementation process," he added.

Related stories:




Print this Story Send Us Feedback E-mail this Story Digg! Digg this Story Slashdot this Story
"It's IT Blogwatch: in which billionaire investor Carl Icahn starts a proxy fight to restart the Microsoft/Yahoo merger talks. Not..." Read more...
Read more Software posts or See all Blogs
HP confirms XP SP3 endless reboot snafu, promises patch
Yahoo tells Icahn that its own board knows best
Tools circulate that crack Debian, Ubuntu keys
More top stories...
Former Microsoft manager offers free fix for XP SP3 'endless reboot'
Can Icahn take on the Yahoo board and win?
Elgan: Hyperconnectivity: Friend or foe?
Specialists have retrieved about 99% of the data on a disk drive on board the crashed space shuttle Columbia. Don't miss the photographs of the recovered drive.
These big ideas were supposed to revolutionize technology, but they never actually appeared. In a few cases, you'll be glad they didn't.
Nearly 20 years after the first Internet worm, Steven J. Vaughan-Nichols takes stock of the malware/anti-malware landscape and spotlights how the two sides are approaching the battle.
Though some thought it was released too soon, Mac OS X 10.5 has matured into a solid operating system, says reviewer Michael DeAgonia.
Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS.
Four years from now, the IT field will be a vastly different place. Will you be ready?
All Zones
Application Performance Zone
Enterprise-Class Security Zone
Enterprise Solutions Zone
The File Data Management Zone
Grid Computing on Windows Zone
Security Management Zone
ITIL Best Practices Zone
The SAS Zone
Storage Virtualization Zone
The Data Center Management Zone

Ads by TechWords

See your link here
Computerworld Report: Virtual Reality
Download this Computerworld Report, free for a limited time, compliments of HP.
(Source: Computerworld) The data center is real, but storage is turning virtual at many organizations that need to manage exploding storage needs. Learn how virtualizing your enterprise will save you money in this Computerworld Report, a $49.95 value, available free for a limited time, compliments of HP.
Download this executive briefing download
E-Mail As a Service: Time for Another Look?
E-Mail As a Service: Time for Another Look?
Download this webcast, compliments of Google.
Go to the webcast 
Top 10 Reasons to Go Green in IT
Get this white paper now!
(Source: Verdiem) With fast facts and figures, this free e-booklet details the significant savings you can expect from a greener IT department. Plus: how sustainability can improve employee and customer retention, boost IT performance, even protect against energy price fluctuations. Download your copy of this e-booklet now.
Download this white paper go
White Papers
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
Discover the Secret to Secure Remote Access: GoToMyPC Corporate Security White Paper
Spam Spikes: A Real Risk to Your Business
Six Support Issues That Keep Execs Awake at Night
View more whitepapers