That was Then... This is Now

WASHINGTON, D.C. (April 21, 2010) – Officials from the U.S. Department of the Treasury, the Board of Governors of the Federal Reserve System and the United States Secret Service today unveiled the new design for the $100 note. Complete with advanced technology to combat counterfeiting, the new design for the $100 note retains the traditional look of U.S. currency. “As with previous U.S. currency redesigns, this note incorporates the best technology available to ensure we’re staying ahead of counterfeiters,” said Secretary of the Treasury Tim Geithner. “When the new design $100 note is issued on February 10, 2011, the approximately 6.5 billion older design $100s already in circulation will remain legal tender,” said Chairman of the Federal Reserve Board Ben S. Bernanke. “U.S. currency users should know they will not have to trade in their older design $100 notes when the new ones begin circulating.” There are a number of security features in the redesigned $100 note, including two new f...

The Godfather is one of my favorite movies and there have been many times when working on a project that I wish I could've wielded as much influence as Don Corleone. Baseline Magazine presents a fun yet informative set of guidelines for managing your IT projects. It's an offer you can't refuse.

Today in Operations Management we had our "Billionaire's Challenge." Each semester we do a production case study involving Excel's Solver "add in." Students must first solve the case, earn at least one-million dollars profit, and then may compete to make at least $1,000,000,000. This semester's Billionaires are: Kevin Kolb BreAnna Nuñez Zach Pusti Jordan Tucker Congratulations! For more information on this exercise, refer to my earlier post .

The Microsoft Office 2010 Beta can be downloaded for free. I have been using it for a few days now and while it doesn't look dramatically different--it will be worth getting when it is released later (June) this year. And the "File" menu is back! My only advice when you install it is that you don't "upgrade" but instead keep your existing Office 2007 software installed. Get it here .

I see it all too often. Many companies keep track of information in Excel spreadsheets when Access would be more effective, simply because “it is easier to use Excel” or they “don’t know Access.” Unfortunately, keeping a list of things in Excel can over time, result in redundant information, errors, and endless headaches. If only end users would invest a little time in learning something about databases they could develop a much better solution. Basically the problem comes from “data redundancy.” In the Excel spreadsheet below, we can see that the entries under PROJ_NAME repeat as do the employee names (EMP_NUMBER, EMP_NAME). Secondly, the fields JOB_CLASS and CHG_HOUR repeat as employees are assigned to different projects (click to enlarge): What are some potential problems with this spreadsheet? In addition to a great deal of unnecessary data entry, anything that is entered more than once opens the possibility for a mistake. For example, the JOB_CLASS “Programmer” has an hourl...

Last week in Operations Management we used Excel to calculate the Economic Order Quantity and graph Carrying Costs, Ordering Costs, and Total Costs. The Economic Order Quantity or "EOQ" is the order size that "minimizes" Total Costs. Any more or less and you are spending too much on ordering or too much on keeping inventory. For example, in the Excel spreadsheet below, if you had an Annual Demand of 12000 units, Ordering Costs of $10 per order, and Holding costs of $4 per unit per year, the EOQ would be 245 units and Total Costs would be $980.00: We used the following formula in Excel to calculate EOQ: =SQRT((2*B2*B3)/B4) And the following formula to calculate Total Costs at this point: =$B$6/2*$B$4+$B$2/B6*$B$3 To create the graph, we used the following formulas and simply copied them over a range of 100 to 500 units. Ordering Costs: =$B$2/D2*$B$3 Holding Costs: =D2/2*$B$4 Total Costs: =F2+G2 Looking at this chart, we can clearly see that our order size of 245 is ...

We have dreamed of being able to control other objects with our minds for centuries. Current technology allows for some degree of control in certain applications such as prosthetics. How close are we actually to "full body control" like was shown in Avatar? Check out this excelent article on CNN: Is the 'Avatar' concept really possible?