KEMBAR78
Solution To Assignment 6 | PDF | Human Resource Management | Applied Mathematics
Scribd
Upload
36 views3 pages

Solution To Assignment 6

The document presents a numerical example of workforce planning using trend analysis for TechNova Ltd, forecasting the number of employees needed in 2026 based on past data. It outlines a step-by-step solution involving the assignment of time variables, calculation of the mean and slope, and application of the linear trend formula. The final forecast indicates that 188 employees will be needed in 2026, emphasizing the importance of trend analysis in stable environments for long-term planning.

Uploaded by

esraaismailmohamed96
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
36 views3 pages

Solution To Assignment 6

The document presents a numerical example of workforce planning using trend analysis for TechNova Ltd, forecasting the number of employees needed in 2026 based on past data. It outlines a step-by-step solution involving the assignment of time variables, calculation of the mean and slope, and application of the linear trend formula. The final forecast indicates that 188 employees will be needed in 2026, emphasizing the importance of trend analysis in stable environments for long-term planning.

Uploaded by

esraaismailmohamed96
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Solution of assignment no.

Here's a numerical example of planning labor force size using trend analysis, designed in a
clear, easy-to-understand format for students studying Human Resources Management.

Topic: Workforce Planning Using Trend Analysis

Objective: To determine future labor force size based on past employment trends.

Scenario:

You're the HR manager of a company called TechNova Ltd. You want to forecast the number of
employees needed in the next year (2026) using trend analysis based on the past five years of
workforce data.

Year Number of Employees

2021 120

2022 130

2023 145

2024 160

2025 175

Step-by-Step Solution:

Step 1: Assign time variable (t)

To apply a linear trend, assign values for time (t), where the middle year (2023) is t = 0:

Year Employees (Y) Time (t)

2021 120 -2

2022 130 -1

2023 145 0
Year Employees (Y) Time (t)

2024 160 +1

2025 175 +2

Step 2: Use Linear Trend Formula

We apply the formula of a straight line:

Y=a+btY = a + bt

Where:

• Y = Forecasted labor size

• t = Time period

• a = Mean of Y (average number of employees)

• b = Slope (change in Y per unit time)

Step 3: Calculate "a" and "b"

1. Mean of Y (a)

a=120+130+145+160+1755=7305=146a = \frac{120 + 130 + 145 + 160 + 175}{5} = \frac{730}{5}


= 146

2. Calculate b (slope):

b=∑(t×Y)∑(t2)b = \frac{\sum (t \times Y)}{\sum (t^2)}

Let’s calculate:

t Y t × Y t²

-2 120 -240 4

-1 130 -130 1

0 145 0 0

1 160 160 1
t Y t × Y t²

2 175 350 4

Now sum them:

∑(t×Y)=−240−130+0+160+350=140∑(t2)=4+1+0+1+4=10\sum (t \times Y) = -240 -130 + 0 +160 +


350 = 140 \sum (t^2) = 4 + 1 + 0 + 1 + 4 = 10 b=14010=14b = \frac{140}{10} = 14

Step 4: Forecast for 2026 (t = +3)

Y=a+bt=146+14(3)=146+42=188Y = a + bt = 146 + 14(3) = 146 + 42 = \boxed{188}

Final Answer:

The forecasted number of employees needed in 2026 is 188.

Key Takeaways for Students:

• Trend analysis helps project future workforce needs using historical data.

• It assumes past trends continue, so it's best for stable environments.

• Use this method for long-term planning, especially when no major changes in
technology or structure are expected.

Would you like me to turn this into a handout or slide for a class presentation?

You might also like