Released in 2006, the film went into DVD distribution in January 2007 it’s a Sci-fi adventure comedy with a cryonics theme, starring Luke Wilson. Joe Bauers, an Army librarian, is judged to be absolutely average in every regard, has no relatives, has no future, so he's chosen to be one of the two test subjects in a top-secret hibernation program.
The purpose of the program set up by the Pentagon, called the "Human Hibernation Project," is designed so that the military can save their best men for when they're needed most. According to the officers heading the project, too many times the talents and expensive training of the best pilots and soldiers go to waste during times of peace. So they enlist Bauers (Wilson), the most under-achieving average guy they've got, to be the test subject for the initial hibernation experiment. Also participating in the top-secret program is Rita (Rudolph), a prostitute who agreed to take part in exchange for dropping some criminal charges against her, among other things. Of course, the experiment, which was to last only a year, goes under due to the arrest of Officer Collins, who is busted for heading a prostitution ring. Seeing as though he was in charge of the experiment, one of the only ones who knew of its existence, and "due to a lot of top-secret red tape... and the massive scandals and base closure that followed, Joe and Rita were forgotten about.
Five hundred years later, Joe and Rita's containers (unearthed in The Great Garbage Avalanche) open, reviving them. Joe lands in the apartment of Frito (Shepard), an idiot. Feeling woozy, Joe visits the hospital where Dr. Lexus (Long) diagnoses him as simply "retarded". Lexus panics that Joe has no bar code tattoo and can't be scanned for payment, while Joe panics that 500 years have passed, and the world he sees out the window is falling apart. Joe flees but is arrested at a Carl's Jr. vending booth for failing to pay the hospital bill, and for being unscannable.
Joe's defense lawyer at trial turns out to be Frito, who stupidly helps convict him. In prison, a poorly-designed I.D.machine records Joe's name as "Not Sure" and barcodes him. During a mandatory I.Q. test, Joe realizes just how stupid humanity has become. Easily escaping the prison, Joe returns to Frito's apartment and asks if a time machine exists to help him return to the past. Frito says there is, but will help only after Joe promises him billions of dollars in interest on a bank account Joe will open in the past.
Enroute to the time machine, Joe, Rita and the lawyer enter a city-sized Costco, where Joe is arrested again when his new barcode is scanned. Instead of going to jail, Joe is taken to the White House: President Camacho (Crews) has seen Joe's I.Q. test and recruits him to solve the world's food shortages, crippled economy, mountains of garbage, etc. Joe learns that water has been replaced by Brawndo (a sports drink "with electrolytes"), even for crop irrigation, causing the food shortage.
After Joe reintroduces the use of water (now only used in toilets) for crops, the giant Brawndo Corporation's stock plummets, causing massive unemploy- ment. Meanwhile Rita sees crops sprouting in the fields. To save Joe, she bribes a TV cameraman to show the crops to the world, with Frito going along. But before they reach the field, they are sidetracked by a sale at Star- bucks, now a brothel chain. It is only after Frito knocks out the cameraman for calling him a "fag" that he remembers his job.
The President sees the thriving new plants on the stadium big screens and pardons Joe just as he is about to be incinerated by a flame thrower. Soon afterwards, Joe becomes the Vice-President and eventually, President. He abandons his plans to return to the past so he can work on saving the future.