International project portfolio Earned Value Analysis and Budget Spreadsheet

You will need to examine what it would take to prepare an Earned Value Analysis related to your project’s business case. Write a two-page reflection anticipating relevant aspects of creating an Earned Value (EV) Analysis taking into account the following background information. An Earned Value (EV) Analysis integrates scope, schedule, and cost in the planning, monitoring, and controlling disciplines. 4 Plan the work by using a work breakdown structure (WBS). Identify resources and persons accountable for the work. Schedule the work. Estimate the costs. Develop a performance measurement baseline. Monitor the work against the baseline to determine variances. Control the work to keep the project on schedule and on budget. Manage changes to maintain the baseline integrity. Develop forecasts for future performance. * International project portfolio budget spreadsheet: Please create a preliminary budget spreadsheet taking into consideration your project’s specific international context. Start with a Cost Breakdown Structure by utilizing your Work Breakdown Structure and follow this process. Preparing a budget for your project requires two steps: First you prepare a rough estimate. Then when you move into the organizing and preparing stage of your project, you’re ready to create your detailed budget estimate. Develop your bottom-up estimate by doing the following: – For each lowest-level work package, determine direct labor costs by multiplying the number of hours each person will work on it by the person’s hourly salary. You can estimate direct labor costs by using either of the following two definitions for salary: The actual salary of each person on the project The average salary for people with a particular job title, in a certain department, and so on – For each lowest-level work package, estimate the direct costs for materials, equipment, travel, contractual services, and other non-personnel resources. – Determine the indirect costs associated with each work package. You typically estimate indirect costs as a fraction of the planned direct labor costs for the work package. In general, you can calculate these costs by: Estimating organization direct labor costs for the coming year Estimating organization indirect costs for the coming year Dividing the estimated indirect costs by the estimated direct labor costs You can estimate the total amount of indirect costs either by considering that they’re all in a single category labeled “indirect costs” or that they can be in one of the two separate categories labeled “overhead costs” and “general and administrative costs.”