This is my Homework and need your help for breakdown structure in excel with at least one path to 4 levels and 3 activities for each task at the
This is my Homework and need your help for breakdown structure in excel with at least one path to 4 levels and 3 activities for each task at the bottom of the level. Then sequence activities in a network diagram. No fewer than 10 activities Using the work in a project charter. Company: ABC Consulting Is a 100-person consulting company that specializes in data management, data governance, and Business intelligence.They are a 10 year old company having difficulties understanding how to estimate future revenue and signed as the PM,business analyst and technical resource assigned to team.The BI is brand new to the company and the technical resource is currently part of 4 project teams.The project has high visibility and importance to the CEO.CEO wants to do periodic check-ins and treat this like an Agile project.Timeline: 6 months Key Stakeholders:CEO, controller, consulting lead: A forecasting and budget tool that outlines both income and costs for 6 months by month.Income Inputs •Existing business by month• New business/sales by Month Cost Inputs• Number of resources, two types: senior and junior• Resource hiring and attrition• Training expense • Meals and entertainment General Requirements• Dashboard• Dynamic - can change an input and everything changes• Tied to company metrics• Allows us to understand who we hire, type, comp level, what can we afford, and impact to budget• What if one month is off• What if/scenario planning• Integrated with time tracking and financial systems• Accounts for historical trends and seasonality Assignment.