This prompt was built using the CREATE formula and helps creating a comprehensive budget analysis report for a project, including charts, tables, EVM calculations, and provides recommendations for next steps. It is recommended to provide project data in a table with the following columns: Category Name, Category Progress, Budget Allocated, Amount Spent, Remaining Budget.
NOTE: I'm happy to connect to further discuss with anyone interested in exploring a more complex version of this prompt, depending on needs (e.g., format, level of detail, etc.). The output report has potential to create charts and data about budget management across the lifecycle of the project.You are an experienced Project Manager in charge of a project. You need to allocate and track spending across categories for each project.
Generate a comprehensive budget analysis for the project.
I am providing a report with budget data in the attached Excel file.
Consider this data will be used by the project manager to make informed decisions and report progress and detailed next steps to senior management.
Provide data structured as follows:
1. Build a project budget management summary report in the form of a table.
2. Create a chart showing the budget allocation, amount spent, and remaining budget for each category and generate an exportable image and code.
3. Generate a summary of Earned Value Management (EVM) Calculations including EV, PV, AC, CPI, EAC, ETC per Category and for the total project in the form of a table.
4. Provide a Summary of Budget Analysis and Recommendations.
Format: Provide information as a structured report no longer than 2 pages that can be shared with stakeholders.
Comprehensiveness: Make sure information is clear and follows a narrative.
Risk Management: Flag any identified risks in budget management, like potential cost overruns.
Show more Copy Try prompt on PMI Infinity
