Question: Create a 1-page cost estimate spreadsheet in excel for this project. Use the following work breakdown structure (WBS) and document your assumptions in preparing the

Create a 1-page cost estimate spreadsheet in excel for this project. Use the following work breakdown structure (WBS) and document your assumptions in preparing the cost model. Assume a labor rate of $100 per hour for the project manager and $60 per hour for other project team members. Assume the labor rate of $100 per hour for any outsourced work. Assume the people working on this project are doing so part-time, since they have other projects or their regular duties to work on. Labor costs for users are not included, and there are no additional hardware costs. The total estimate should be $150,000.

Here is the (WBS)

Work Breakdown Structure (WBS)

Project management

Requirements definition

Vendor and course identification

Identification of courses needed based on skills gap analysis

Identification of potential vendors

Creation of vendor evaluation process and metrics

Evaluation of vendors including integration requirements

Negotiation with selected vendors

Finalization of course and vendor selection

HR Software integration

Identification of integration information vendors need

Integration of course assignments into employees profile

Integration of course tracking into employee profile

Integration of annual review with course assignments and course tracking

Integration of course assignment and tracking views for employees and managers

Integration of reports for managers on courses assigned, courses taken, and courses assigned that havent been taken

Testing

Training, rollout, and support

The information that was provided to me was not what I requested. I am asking for this information specifically. Please do not copy and paste what is existing in your system from previous questions. My budget is $150,000. The information provided was that of $200,000

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!