A £1.5 million report into the future of Scotland’s last remaining oil refinery will be available by the end of the month, the Scottish Energy Secretary has said.