Hi, it's not easy to know but since You have descriptive variable names, I could guess that You expect the backup file to end up in /tmp?
First, look in Your current working directory, it may already be there.
Otherwise, You could try to change Your tar command to say:
tar cvzf $Backup_Dest_Dir/$Backup_Date.tar.gz $Backup_Dirs