Frequency of employees

Task 1

Requirement 1

Requirement 2

Genders	Frequency of employees
Female	80
Male	81
Grand Total	161

 

Length of Service	Count of Employee
1 to 4	17
10 or more	94
5 to 9	32
Less than 1	18
Grand Total	161

 

Departments	Count of Employee
Academic	48
Admin	49
Estate	43
IT	21
Grand Total	161

 

Training attended	Count of Employee
No	92
Yes	69
Grand Total	161

 

 

Age Classes	Frequency
<15	3
15-19	33
20-24	93
25-30	24
>30	8

 

Requirement 3

Department Pie Chart

Departments	Count of Employee
Academic	48
Admin	49
Estate	43
IT	21
Grand Total	161

 

 

 

 

Length of Service

Length of Service	Count of Employee
Less than 1	18
1 to 4	17
5 to 9	32
10 or more	94

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Hours Histogram

Age Classes	age boundaries	Frequency
<10	<10	1
11--15	10,15	4
16--20	15,20	43
21-25	20,25	95
26--30	25,30	12

 

 

 

Hours (Box & Whisker Graph

 

 

Requirement 4

Min

Quartile

Median

Max

Mean

Standard deviation

 

 

Requirement 5

Training & Gender Chart

 

 

Training and length of service chart

 

Requirement 6

TASK 2

Requirement 1

NETWORK MANAGEMENT DIAGRAM (Representing the sequence of activities & their dependence)

A1

B

C

D

E

F

G

H

I

J

 

 

 

 

 

 

 

 

 

 

Requirement 2

Following is shown how the cells of below working is captioned

Early Start	Activity	Early done	(Forward Pass)
Late Start	Duration	Late done	(Backward Pass)

 

Calculation of forward pass and backward pass

0

A

1

1

1

2

0

D

6

5

5

11

5

G

11

3

8

14

2

C

2

3

5

5

0

B

1

2

2

2

 

5

E

5

2

7

7

7

F

7

4

11

11

11

H

11

2

13

13

14

J

14

1

15

15

13

I

13

1

14

14

Duration of the project to complete is 15 days found by forward pass.

Requirement 3

Following are the critical and non-critical paths are defined by conducting backward pass

Critical Passes
Activity = B, C, E, F, H, I, J

Non Critical Passes
Activity = A, D, G

TASK 3

Requirement 1

Year	Quarter	Sales
2016	Q1	60
	Q2	56
	Q3	12
	Q4	34
2017	Q1	66
	Q2	58
	Q3	16
	Q4	39
2018	Q1	71
	Q2	62
	Q3	20
	Q4	40
2019	Q1	77
	Q2	70
	Q3	26
	Q4	46

Requirement 2

Moving Averages are calculated based on 4 years interval below:

Year	Quarter	Sales	Moving Averages
2016	Q1	60	#N/A
	Q2	56	#N/A
	Q3	12	#N/A
	Q4	34	40.5
2017	Q1	66	42
	Q2	58	42.5
	Q3	16	43.5
	Q4	39	44.75
2018	Q1	71	46
	Q2	62	47
	Q3	20	48
	Q4	40	48.25
2019	Q1	77	49.75
	Q2	70	51.75
	Q3	26	53.25
	Q4	46	54.75

Requirement 3

Centered Moving Averages are calculated below

Year	Quarter	Sales	Moving Averages	Centered Moving Averages
2016	Q1	60	#N/A
	Q2	56	#N/A
	Q3	12	#N/A	41.25
	Q4	34	40.5	42.25
2017	Q1	66	42	43
	Q2	58	42.5	44.125
	Q3	16	43.5	45.375
	Q4	39	44.75	46.5
2018	Q1	71	46	47.5
	Q2	62	47	48.125
	Q3	20	48	49
	Q4	40	48.25	50.75
2019	Q1	77	49.75	52.5
	Q2	70	51.75	54
	Q3	26	53.25
	Q4	46	54.75

 

Requirement 4

The center moving averages are the trends of the sale.

The Line Graph has been presented to demonstrate the Original sales and Trend of sales figure                                                   

TASK 4

Requirement 1

Excel file has been enclosed herewith.

Milk used formula has been shown

= (Liters use by one brie x quantity of brie) + (Liters use by one Gouda x quantity of Gouda)

 

Salt usage

= (grams x quantity of Brie) + (grams x quantity of Gouda)

Total Profit

= (unit profit of brie x quantity of brie) + (unit profit of Gouda x quantity of Gouda)

Requirement 2

Solution of Linear Programming Problem

	Milk	Salt	Profit
x = brie	1.8	100	2.8
y = gouda	1.2	150	2

 

1.8x +1.2 y =< 120 ----- eq1

100x + 150y =< 12000 ------ eq2

x >=0 ----- eq3

y> = 0 ------ eq4

y

If y = 0, put in equation 1

1.8x + 2(0) = 120

X= 66.7

If x= 0 put in equation 1

1.8(0) + 2y = 120

a

Y= 60

If x = 0, put in equation 2

100x +150y <= 12000

X = 120

o

Y = 80

x

e

Feasible region

Requirement 3

Optimal point

(Multiply equation 1 by 75 and subtract them to find value of x)

135x + 150y = 9000

-100x - 150y = -12000

---------------------------

35x = 3000

X = 85.71 => 86 units

-------------------------

Put value of x in equation 2 to find value of y

100x +150y = 12000

100(85.71) +150y = 12000

Y= 22.86 => 23 units

Profit Maximization

Brie 86 units

Gouda 23 units

2.8 x 86 + 2 x 23

=240.8+46

=286.8 Profit