Multiscale simulations in simple metals: A density-functional-based methodology