You have to use the add-in tool called “Tree Plan” to solve this question here by using the Excel. question: …