An Excel template which assigns and records development (or any resource) allocation. This will help…