CECOM has free buying app

CECOM has free buying app

A free Microsoft Excel 2000 add-in developed by analysts at the Army Communications-Electronics Command can help government purchasing agents determine the lowest overall cost when a vendor discounts various quantities of a product.

Michael Bogner, Bernard Price and Chuck Wong of the Systems Analysis Office at the Fort Monmouth, N.J., command developed the Microsoft Excel 2000 macro tool.

Product buyers do not have to develop a spreadsheet themselves. They simply launch the macro tool and fill in boxes for quantity ranges, unit prices and ordering costs to see graphically the lowest-cost quantity.

Surprisingly, the analysts found that the cheapest choice is never a quantity at the high end of a particular discount range. Buying a slightly larger quantity in the next range costs less overall, Bogner said.

E-mail Re Van Holt at re.vanholt@mail1.monmouth.army.mil to obtain the free tool.

'Susan M. Menke, William Jackson, Dennis Blank and Matt McLaughlin

inside gcn

  • benchmarks (Bakhtiar Zein/Shutterstock.com)

    Best practices for performance metrics

Reader Comments

Please post your comments here. Comments are moderated, so they may not appear immediately after submitting. We will not post comments that we consider abusive or off-topic.

Please type the letters/numbers you see above

More from 1105 Public Sector Media Group