How can budgeting create motivation? And how can it harm the company long term?

By having achievable targets so managers can actually achieve the targets. However, this may cause managers to do things to achieve their budget that harm the company long term.