Mathematics
cost esmitation ms project

Question Description

I’m working on a Calculus exercise and need support.

create a neat work on cost estimation using the data provided in ms project,

you must have ms project 2010,

estimation_tables_in_ms_excel.xlsxproject_estimation.docx

Unformatted Attachment Preview

Duration WBS 1 1.1 1.2 1.3 2 2.1 2.2 2.3 3 3.1 3.2 3.3 4 4.1 4.2 4.3 4.4 4.5 4.6 5 5.1 5.2 5.3 5.4 6 6.1 6.2 6.3 6.4 Task Name Define New Product Brainstorm Product Ideas Research Brainstormed Product Ideas Decide on 2 Product Ideas Design New Product Define Product Requirements Define Product Design Review Product Design Market New Product Develop Marketing Strategy Review Marketing Strategy Implement Marketing Strategy Develop New Product Develop Prototype Test Prototype Review Prototype Develop Production Model Test Production Model Review Production Model Deliver Product in Production Design Production Process Layout Production Line Test Production Line Review Production Line Setup Customer Support Design Customer Support Process Document Customer Support Process Train Staff on Customer Support Process Rollout Customer Support Process Pessimistic Most Likely Duration Duration Optimistic (Days) (Days) (Days) Predecessor 3 8 2 2 6 1 1 5 1 1.1 1.2 15 20 2 10 15 1 8 10 1 1.3 2.1 2.2 10 2 30 5 1 20 3 1 15 2.3 3.1 3.2 20 10 2 20 15 2 15 5 1 15 10 1 10 3 1 10 8 1 3.3 4.1 4.2 4.3 4.4 4.5 15 15 10 2 10 10 5 1 8 8 3 1 4.6 5.1 5.2 5.3 15 15 20 30 10 10 15 20 8 8 10 16 5.4 6.1 6.2 6.3 20140723152844estimation_tables_in_ms_excel.xlsx Page 1 20140723152844estimation_tables_in_ms_excel.xlsx Labor Estimate WBS 1 1.1 1.2 1.3 2 2.1 2.2 2.3 3 3.1 3.2 3.3 4 4.1 4.2 4.3 4.4 4.5 4.6 5 5.1 5.2 5.3 5.4 6 6.1 6.2 6.3 6.4 Task Name Define New Product Brainstorm Product Ideas Research Brainstormed Product Ideas Decide on 2 Product Ideas Design New Product Define Product Requirements Define Product Design Review Product Design Market New Product Develop Marketing Strategy Review Marketing Strategy Implement Marketing Strategy Develop New Product Develop Prototype Test Prototype Review Prototype Develop Production Model Test Production Model Review Production Model Deliver Product in Production Design Production Process Layout Production Line Test Production Line Review Production Line Setup Customer Support Design Customer Support Process Document Customer Support Process Train Staff on Customer Support Process Rollout Customer Support Process UW-Stout Confidential Pessimistic No. of Est Work People (hrs) (hrs) Most Likely No. of Est Work People (hrs) (hrs) Optimistic No. of Est Work People (hrs) (hrs) 3 3 6 10 20 4 30 60 24 3 3 6 8 16 2 24 48 12 3 3 6 4 8 1 12 24 6 3 3 6 50 100 8 150 300 48 3 3 6 40 80 4 120 240 24 3 3 6 30 60 2 90 180 12 3 4 2 32 4 100 96 16 200 3 4 2 24 4 80 72 16 160 3 4 2 16 4 60 48 16 120 2 2 6 3 4 7 100 40 8 100 80 16 200 80 48 300 320 112 2 2 6 3 4 7 80 32 4 80 60 8 160 64 24 240 240 56 2 2 6 3 4 7 60 24 2 60 40 4 120 48 12 180 160 28 2 2 2 3 80 80 60 16 160 160 120 48 2 2 2 3 60 60 40 8 120 120 80 24 2 2 2 3 40 40 24 4 80 80 48 12 2 2 10 12 80 80 24 16 160 160 240 192 2 2 10 12 60 60 16 8 120 120 160 96 2 2 10 12 40 40 8 6 80 80 80 72 4/27/2019 Page 2 Labor Estimate WBS Task Name 1 Define New Product 1.1 Brainstorm Product Ideas Engineering Marketing Production Most Likely No. of Est Work People (hrs) (hrs) 3 1 1 1 8 8 8 8 24 8 8 8 1.2 Research Brainstormed Product Ideas Engineering Marketing Production 3 1 1 1 16 16 16 16 48 16 16 16 1.3 Decide on 2 Product Ideas Engineering Marketing Production Engineering Marketing Production 6 1 1 1 1 1 1 2 2 2 2 2 2 2 12 2 2 2 2 2 2 2 2.1 Design New Product Define Product Requirements Engineering Marketing Production 3 1 1 1 40 40 40 40 120 40 40 40 2.2 Define Product Design Engineering Marketing Production 3 1 1 1 80 80 80 80 240 80 80 80 2.3 Review Product Design Engineering Marketing Production Engineering Marketing Production 6 1 1 1 1 1 1 4 4 4 4 4 4 4 24 4 4 4 4 4 4 3 3.1 Market New Product Develop Marketing Strategy Marketing Marketing 3 2 1 24 24 24 72 48 24 3.2 Review Marketing Strategy Marketing Marketing Customer Service 4 2 1 1 4 4 4 4 16 8 4 4 3.3 Implement Marketing Strategy Marketing 2 2 80 80 160 160 2 2 80 80 160 160 2 2 32 32 64 64 4 4.1 4.2 Develop New Product Develop Prototype Engineer Test Prototype Engineer 4.3 Review Prototype Engineering Marketing Production Engineering Marketing Production 6 1 1 1 1 1 1 4 4 4 4 4 4 4 24 4 4 4 4 4 4 4.4 Develop Production Model Engineering Production 3 2 1 80 80 80 240 160 80 4.5 Test Production Model Engineering Production 4 2 2 60 60 60 240 120 120 4.6 Review Production Model Engineering Production Engineering Marketing Production 7 2 2 1 1 1 8 8 8 8 8 8 56 16 16 8 8 8 5 5.1 Deliver Product in Production Design Production Process Production 2 2 60 60 120 120 5.2 Layout Production Line Production 2 2 60 60 120 120 5.3 Test Production Line Production 2 2 40 40 80 80 5.4 Review Production Line Production Production 3 2 1 8 8 8 24 16 8 2 2 60 60 120 120 6 6.1 Setup Customer Support Design Customer Support Process Customer Service 6.2 Document Customer Support Process Customer Service 2 2 60 60 120 120 6.3 Train Staff on Customer Support Process Customer Service Customer Service 10 8 2 16 16 16 160 128 32 6.4 Rollout Customer Support Process Customer Service Customer Service 12 10 2 8 8 8 96 80 16 20140723152844estimation_tables_in_ms_excel.xlsx WBS 1 1.1 1.2 1.3 2 2.1 2.2 2.3 3 3.1 3.2 3.3 4 4.1 4.2 4.3 4.4 4.5 4.6 5 5.1 5.2 5.3 5.4 6 6.1 6.2 6.3 6.4 Non-Labor Estimate Pessimistic Most Likely Optimistic Expected Value Task Name Define New Product Brainstorm Product Ideas Research Brainstormed Product Ideas Decide on 2 Product Ideas Design New Product Define Product Requirements Define Product Design Review Product Design Market New Product Develop Marketing Strategy Review Marketing Strategy Implement Marketing Strategy $150,000 $100,000 $50,000 $100,000 Develop New Product Develop Prototype $1,500 $1,300 $1,000 $1,283 Test Prototype Review Prototype Develop Production Model Test Production Model Review Production Model Deliver Product in Production Design Production Process Layout Production Line $15,000 $10,000 $8,000 $10,500 Test Production Line Review Production Line Setup Customer Support Design Customer Support Process Document Customer Support Process $800 $500 $300 $517 Train Staff on Customer Support Process $15,000 $8,000 $5,000 $8,667 Rollout Customer Support Process Confidential 4/27/2019 Page 5 Resource Engineering 1 Engineering 2 Engineering 3 Marketing 1 Marketing 2 Marketing 3 Marketing 4 Production 1 Production 2 Production 3 Customer Service 1 Customer Service 2 Customer Service 3 Customer Service 4 Customer Service 5 Customer Service 6 Customer Service 7 Customer Service 8 Customer Service 9 Customer Service 10 Customer Service 11 Customer Service 12 Max Units 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% 100% Std Rate $50.00/hr $50.00/hr $50.00/hr $40.00/hr $40.00/hr $40.00/hr $40.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr Ovt Rate $50.00/hr $50.00/hr $50.00/hr $40.00/hr $40.00/hr $40.00/hr $40.00/hr $37.50/hr $37.50/hr $37.50/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr Week 6 Home Assignment – Project Estimation – 50 Points Based on the project estimation information (page 2 – page 6), create the MS Project cost estimation plan. Requirements 1. (8 pts.) WBS Create the MS Project WBS with individual tasks, summarizing as appropriate for phases. 2. (34 pts.) Entering the LABOR/WORK ESTIMATES For each task in the WBS, 3 labor or Work estimates – pessimistic, most likely and optimistic were created. Use the most likely labor estimate for each WBS activity. The minimum Work estimate for a task is 1 hour and the pay rates should be in whole dollar values. The company will pay overload if there are resource overloads 3. (4 pts.) Entering the NON-LABOR/MATERIAL ESTIMATES 4. (4 pts.) Appropriate totals appear on each of the estimate worksheets. Page 1 of 6 Project Duration Estimate WBS 1 1.1 1.2 1.3 2 2.1 2.2 2.3 3 3.1 3.2 3.3 4 4.1 4.2 4.3 4.4 4.5 4.6 5 5.1 5.2 5.3 5.4 6 6.1 6.2 6.3 6.4 Task Name Define New Product Brainstorm Product Ideas Research Brainstormed Product Ideas Decide on 2 Product Ideas Design New Product Define Product Requirements Define Product Design Review Product Design Market New Product Develop Marketing Strategy Review Marketing Strategy Implement Marketing Strategy Develop New Product Develop Prototype Test Prototype Review Prototype Develop Production Model Test Production Model Review Production Model Deliver Product in Production Design Production Process Layout Production Line Test Production Line Review Production Line Setup Customer Support Design Customer Support Process Document Customer Support Process Train Staff on Customer Support Process Rollout Customer Support Process Pessimistic Most Likely Duration Duration Optimistic (Days) (Days) (Days) Predecessor 3 8 2 2 6 1 1 5 1 1.1 1.2 15 20 2 10 15 1 8 10 1 1.3 2.1 2.2 10 2 30 5 1 20 3 1 15 2.3 3.1 3.2 20 10 2 20 15 2 15 5 1 15 10 1 10 3 1 10 8 1 3.3 4.1 4.2 4.3 4.4 4.5 15 15 10 2 10 10 5 1 8 8 3 1 4.6 5.1 5.2 5.3 15 15 20 30 10 10 15 20 8 8 10 16 5.4 6.1 6.2 6.3 Page 2 of 6 Project Resource Information Resource Max Units Engineering 1 100% Engineering 2 100% Engineering 3 100% Marketing 1 100% Marketing 2 100% Marketing 3 100% Marketing 4 100% Production 1 100% Production 2 100% Production 3 100% Customer Service 1 100% Customer Service 2 100% Customer Service 3 100% Customer Service 4 100% Customer Service 5 100% Customer Service 6 100% Customer Service 7 100% Customer Service 8 100% Customer Service 9 100% Customer Service 10 100% Customer Service 11 100% Customer Service 12 100% Std Rate $50.00/hr $50.00/hr $50.00/hr $40.00/hr $40.00/hr $40.00/hr $40.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr $25.00/hr Ovt Rate $50.00/hr $50.00/hr $50.00/hr $40.00/hr $40.00/hr $40.00/hr $40.00/hr $37.50/hr $37.50/hr $37.50/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr $35.00/hr Page 3 of 6 Labor Estimate Labor Estimate WBS Task Name 1 Define New Product 1.1 Brainstorm Product Ideas Engineering Marketing Production Most Likely No. of Est Work People (hrs) (hrs) 3 1 1 1 8 8 8 8 24 8 8 8 1.2 Research Brainstormed Product Ideas Engineering Marketing Production 3 1 1 1 16 16 16 16 48 16 16 16 1.3 Decide on 2 Product Ideas Engineering Marketing Production Engineering Marketing Production 6 1 1 1 1 1 1 2 2 2 2 2 2 2 12 2 2 2 2 2 2 2 2.1 Design New Product Define Product Requirements Engineering Marketing Production 3 1 1 1 40 40 40 40 120 40 40 40 2.2 Define Product Design Engineering Marketing Production 3 1 1 1 80 80 80 80 240 80 80 80 2.3 Review Product Design Engineering Marketing Production Engineering Marketing Production 6 1 1 1 1 1 1 4 4 4 4 4 4 4 24 4 4 4 4 4 4 3 2 1 24 24 24 72 48 24 3 3.1 Market New Product Develop Marketing Strategy Marketing Marketing 3.2 Review Marketing Strategy Marketing Marketing Customer Service 4 2 1 1 4 4 4 4 16 8 4 4 3.3 Implement Marketing Strategy Marketing 2 2 80 80 160 160 Page 4 of 6 4 4.1 Develop New Product Develop Prototype Engineer 2 2 80 80 160 160 4.2 Test Prototype Engineer 2 2 32 32 64 64 4.3 Review Prototype Engineering Marketing Production Engineering Marketing Production 6 1 1 1 1 1 1 4 4 4 4 4 4 4 24 4 4 4 4 4 4 4.4 Develop Production Model Engineering Production 3 2 1 80 80 80 240 160 80 4.5 Test Production Model Engineering Production 4 2 2 60 60 60 240 120 120 4.6 Review Production Model Engineering Production Engineering Marketing Production 7 2 2 1 1 1 8 8 8 8 8 8 56 16 16 8 8 8 5 5.1 Deliver Product in Production Design Production Process Production 2 2 60 60 120 120 5.2 Layout Production Line Production 2 2 60 60 120 120 5.3 Test Production Line Production 2 2 40 40 80 80 5.4 Review Production Line Production Production 3 2 1 8 8 8 24 16 8 2 2 60 60 120 120 2 2 60 60 120 120 6 6.1 Setup Customer Support Design Customer Support Process Customer Service 6.2 Document Customer Support Process Customer Service 6.3 Train Staff on Customer Support Process Customer Service Customer Service 10 8 2 16 16 16 160 128 32 6.4 Rollout Customer Support Process Customer Service Customer Service 12 10 2 8 8 8 96 80 16 Page 5 of 6 Non - Labor Estimate (all non-recurring) NOTES: 3.3 Implement Marketing Strategy: Advertising material development and publication (electronic, hard copy). 4.1 Develop Prototype: Prototype materials. 5.2 Layout Production Line: Additional hardware/software/tools for enhancement to existing production line. 6.2 Document Customer Support Process: Electronic and hard copy publication costs. 6.3 Train Staff on Customer Support Process: Training materials. Page 6 of 6 ...
Purchase answer to see full attachment
Student has agreed that all tutoring, explanations, and answers provided by the tutor will be used to help in the learning process and in accordance with Studypool's honor code & terms of service.

Final Answer

Gabriel E (1551)
UC Berkeley

Anonymous
Top quality work from this tutor! I’ll be back!

Anonymous
It’s my second time using SP and the work has been great back to back :) The one and only resource on the Interwebs for the work that needs to be done!

Anonymous
Thanks, good work

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4