cost estimation using ms project

estimation_tables_in_ms_excel.xlsx

Home >Human Resource Management homework help >cost estimation using ms project

Duration

WBS	Task Name	Pessimistic Duration (Days)	Most Likely Duration (Days)	Optimistic (Days)	Predecessor
1	Define New Product
1.1	Brainstorm Product Ideas	3	2	1
1.2	Research Brainstormed Product Ideas	8	6	5	1.1
1.3	Decide on 2 Product Ideas	2	1	1	1.2
2	Design New Product
2.1	Define Product Requirements	15	10	8	1.3
2.2	Define Product Design	20	15	10	2.1
2.3	Review Product Design	2	1	1	2.2
3	Market New Product
3.1	Develop Marketing Strategy	10	5	3	2.3
3.2	Review Marketing Strategy	2	1	1	3.1
3.3	Implement Marketing Strategy	30	20	15	3.2
4	Develop New Product
4.1	Develop Prototype	20	15	10	3.3
4.2	Test Prototype	10	5	3	4.1
4.3	Review Prototype	2	1	1	4.2
4.4	Develop Production Model	20	15	10	4.3
4.5	Test Production Model	15	10	8	4.4
4.6	Review Production Model	2	1	1	4.5
5	Deliver Product in Production
5.1	Design Production Process	15	10	8	4.6
5.2	Layout Production Line	15	10	8	5.1
5.3	Test Production Line	10	5	3	5.2
5.4	Review Production Line	2	1	1	5.3
6	Setup Customer Support
6.1	Design Customer Support Process	15	10	8	5.4
6.2	Document Customer Support Process	15	10	8	6.1
6.3	Train Staff on Customer Support Process	20	15	10	6.2
6.4	Rollout Customer Support Process	30	20	16	6.3

Page &P

Labor

	Labor Estimate	Pessimistic			Most Likely			Optimistic
WBS	Task Name	No. of People	Est (hrs)	Work (hrs)	No. of People	Est (hrs)	Work (hrs)	No. of People	Est (hrs)	Work (hrs)
1	Define New Product
1.1	Brainstorm Product Ideas	3	10	30	3	8	24	3	4	12
1.2	Research Brainstormed Product Ideas	3	20	60	3	16	48	3	8	24
1.3	Decide on 2 Product Ideas	6	4	24	6	2	12	6	1	6
2	Design New Product
2.1	Define Product Requirements	3	50	150	3	40	120	3	30	90
2.2	Define Product Design	3	100	300	3	80	240	3	60	180
2.3	Review Product Design	6	8	48	6	4	24	6	2	12
3	Market New Product
3.1	Develop Marketing Strategy	3	32	96	3	24	72	3	16	48
3.2	Review Marketing Strategy	4	4	16	4	4	16	4	4	16
3.3	Implement Marketing Strategy	2	100	200	2	80	160	2	60	120
4	Develop New Product
4.1	Develop Prototype	2	100	200	2	80	160	2	60	120
4.2	Test Prototype	2	40	80	2	32	64	2	24	48
4.3	Review Prototype	6	8	48	6	4	24	6	2	12
4.4	Develop Production Model	3	100	300	3	80	240	3	60	180
4.5	Test Production Model	4	80	320	4	60	240	4	40	160
4.6	Review Production Model	7	16	112	7	8	56	7	4	28
5	Deliver Product in Production
5.1	Design Production Process	2	80	160	2	60	120	2	40	80
5.2	Layout Production Line	2	80	160	2	60	120	2	40	80
5.3	Test Production Line	2	60	120	2	40	80	2	24	48
5.4	Review Production Line	3	16	48	3	8	24	3	4	12
6	Setup Customer Support
6.1	Design Customer Support Process	2	80	160	2	60	120	2	40	80
6.2	Document Customer Support Process	2	80	160	2	60	120	2	40	80
6.3	Train Staff on Customer Support Process	10	24	240	10	16	160	10	8	80
6.4	Rollout Customer Support Process	12	16	192	12	8	96	12	6	72

&BUW-Stout Confidential&B &D Page &P

Labor Detail

	Labor Estimate	Most Likely
WBS	Task Name	No. of People	Est (hrs)	Work (hrs)
1	Define New Product
1.1	Brainstorm Product Ideas	3	8	24
	Engineering	1	8	8
	Marketing	1	8	8
	Production	1	8	8
1.2	Research Brainstormed Product Ideas	3	16	48
	Engineering	1	16	16
	Marketing	1	16	16
	Production	1	16	16
1.3	Decide on 2 Product Ideas	6	2	12
	Engineering	1	2	2
	Marketing	1	2	2
	Production	1	2	2
	Engineering	1	2	2
	Marketing	1	2	2
	Production	1	2	2
2	Design New Product
2.1	Define Product Requirements	3	40	120
	Engineering	1	40	40
	Marketing	1	40	40
	Production	1	40	40
2.2	Define Product Design	3	80	240
	Engineering	1	80	80
	Marketing	1	80	80
	Production	1	80	80
2.3	Review Product Design	6	4	24
	Engineering	1	4	4
	Marketing	1	4	4
	Production	1	4	4
	Engineering	1	4	4
	Marketing	1	4	4
	Production	1	4	4
3	Market New Product
3.1	Develop Marketing Strategy	3	24	72
	Marketing	2	24	48
	Marketing	1	24	24
3.2	Review Marketing Strategy	4	4	16
	Marketing	2	4	8
	Marketing	1	4	4
	Customer Service	1	4	4
3.3	Implement Marketing Strategy	2	80	160
	Marketing	2	80	160
4	Develop New Product
4.1	Develop Prototype	2	80	160
	Engineer	2	80	160
4.2	Test Prototype	2	32	64
	Engineer	2	32	64
4.3	Review Prototype	6	4	24
	Engineering	1	4	4
	Marketing	1	4	4
	Production	1	4	4
	Engineering	1	4	4
	Marketing	1	4	4
	Production	1	4	4
4.4	Develop Production Model	3	80	240
	Engineering	2	80	160
	Production	1	80	80
4.5	Test Production Model	4	60	240
	Engineering	2	60	120
	Production	2	60	120
4.6	Review Production Model	7	8	56
	Engineering	2	8	16
	Production	2	8	16
	Engineering	1	8	8
	Marketing	1	8	8
	Production	1	8	8
5	Deliver Product in Production
5.1	Design Production Process	2	60	120
	Production	2	60	120
5.2	Layout Production Line	2	60	120
	Production	2	60	120
5.3	Test Production Line	2	40	80
	Production	2	40	80
5.4	Review Production Line	3	8	24
	Production	2	8	16
	Production	1	8	8
6	Setup Customer Support
6.1	Design Customer Support Process	2	60	120
	Customer Service	2	60	120
6.2	Document Customer Support Process	2	60	120
	Customer Service	2	60	120
6.3	Train Staff on Customer Support Process	10	16	160
	Customer Service	8	16	128
	Customer Service	2	16	32
6.4	Rollout Customer Support Process	12	8	96
	Customer Service	10	8	80
	Customer Service	2	8	16

Non-Labor Estimate

	Non-Labor Estimate	Pessimistic	Most Likely	Optimistic	Expected Value
WBS	Task Name
1	Define New Product
1.1	Brainstorm Product Ideas
1.2	Research Brainstormed Product Ideas
1.3	Decide on 2 Product Ideas
2	Design New Product
2.1	Define Product Requirements
2.2	Define Product Design
2.3	Review Product Design
3	Market New Product
3.1	Develop Marketing Strategy
3.2	Review Marketing Strategy
3.3	Implement Marketing Strategy	$150,000	$100,000	$50,000	$100,000
4	Develop New Product
4.1	Develop Prototype	$1,500	$1,300	$1,000	$1,283
4.2	Test Prototype
4.3	Review Prototype
4.4	Develop Production Model
4.5	Test Production Model
4.6	Review Production Model
5	Deliver Product in Production
5.1	Design Production Process
5.2	Layout Production Line	$15,000	$10,000	$8,000	$10,500
5.3	Test Production Line
5.4	Review Production Line
6	Setup Customer Support
6.1	Design Customer Support Process
6.2	Document Customer Support Process	$800	$500	$300	$517
6.3	Train Staff on Customer Support Process	$15,000	$8,000	$5,000	$8,667
6.4	Rollout Customer Support Process

&B Confidential&B &D Page &P

Resource Details

Resource	Max Units	Std Rate	Ovt Rate
Engineering 1	100%	$50.00/hr	$50.00/hr
Engineering 2	100%	$50.00/hr	$50.00/hr
Engineering 3	100%	$50.00/hr	$50.00/hr
Marketing 1	100%	$40.00/hr	$40.00/hr
Marketing 2	100%	$40.00/hr	$40.00/hr
Marketing 3	100%	$40.00/hr	$40.00/hr
Marketing 4	100%	$40.00/hr	$40.00/hr
Production 1	100%	$25.00/hr	$37.50/hr
Production 2	100%	$25.00/hr	$37.50/hr
Production 3	100%	$25.00/hr	$37.50/hr
Customer Service 1	100%	$25.00/hr	$35.00/hr
Customer Service 2	100%	$25.00/hr	$35.00/hr
Customer Service 3	100%	$25.00/hr	$35.00/hr
Customer Service 4	100%	$25.00/hr	$35.00/hr
Customer Service 5	100%	$25.00/hr	$35.00/hr
Customer Service 6	100%	$25.00/hr	$35.00/hr
Customer Service 7	100%	$25.00/hr	$35.00/hr
Customer Service 8	100%	$25.00/hr	$35.00/hr
Customer Service 9	100%	$25.00/hr	$35.00/hr
Customer Service 10	100%	$25.00/hr	$35.00/hr
Customer Service 11	100%	$25.00/hr	$35.00/hr
Customer Service 12	100%	$25.00/hr	$35.00/hr