Project management

Exam1-ExtraCredit.xlsx

PROBLEM 1- PM

Project Management (5 points)

The following information relates to a project (task times are in weeks).

Task

Preceding Tasks

Expected Time

Variance

None

D, E

1) Calculated the Expected Time and Variance for each activity.

2) Draw the project network (draw network on a paper -- no need to submit the diagram). Using the Expected Time from (1), find:

a. Critical Path activities

b. Length of Critical path

c. Which activities have slack and how much?

Task

Slack?

If so, how many weeks?

3) Now find the Expected Project (critical path) mean and standard deviation.

MEAN:

VARIANCE:

STD DEV:

4) What is the probability of completing the project (critical path) within 28 weeks? (show your formulas and work)

Forecasting (5 points)
	Given the following monthly demand for official transcript requests at the MSU registrar’s office:
		Month	# transcripts
		1	552	Place Graph Here:
		2	542
		3	569
		4	554
		5	578
		6	555
		7	552
		8	580
		9	587
		10	610
		11	589
		12	602
	a) Develop a simple linear regression model based on the following 12 months of historical data.
	b) Plot the historical data and the forecast line.
	c) Then compute the forecast for the next 5 periods.
			13
			14
			15
			16
			17
			18
	d) Find the MAD and MAPE.

Quality (5 points)
	The school board is trying to evaluate a new math program introduced to second-graders in twenty elementary schools across the county this year. A sample of the student scores on standardized math tests in each elementary school yielded the following data:
		School	No. of Test Errors
		1	45	Place Graph Here:
		2	24
		3	38
		4	41
		5	45
		6	47
		7	69
		8	52
		9	23
		10	27
		11	46
		12	64
		13	50
		14	31
		15	35
		16	41
		17	44
		18	50
		19	28
		20	34
	1. What type of control chart should be created to evaluate the number of test errors?
	2. Find the center line, UCL and LCL for a 95 percent confidence (at Z= 1.96) control chart.
		Center Line:
		UCL
		LCL:
	3. Graph the control chart including the number of test errors for each school, the center line, UCL and LCL.
	4. Is the process in control? Why or why not?
	Make sure to show your all your calculations (formulas).