Question about forecasting payroll

[Herlengol]

Hi all,

I am trying to forecast hourly teachers salary for the rest of the year. This particular teacher works 32 hours per week, 45 weeks out of the year and paid hourly wage of $20/hour. How do I write a formula so that it calculates monthly salary for the whole year. This teacher does not work during the summer. Thank you!

 

[shg]

=32*45*20

 

[Herlengol]

=32*45*20

Thank you for the reply but I need to forecast per month, some months have 23 working days, some of them have 21 days

 

[shg]

So a clear example of what you want is ...?

 

[Herlengol]

SHORT TITLE

# Staff

NAME

FLSA Status

Location

Est. Hours/ Week

Est. Weeks/ Yr

Est. Hours/ Yr

Annual-ized FTE

Hire Date

Term Date

Rate as 3.20.2018

Proposed Rate

Annualized as of 3.20.2018

Proposed annual rate

11/1/2017

12/1/2017

1/1/2018

2/1/2018

3/1/2018

4/1/2018

5/1/2018

6/1/2018

7/1/2018

8/1/2018

9/1/2018

10/1/2018

TOTAL 2018

xxxx

1

xxxx

PT

BHED

40

42

2080

1.00

1/24/2014

12/31/2019

15.55

15.55

32,344

26,124

2,721.26

2,596.86

2,884.53

2,488.01

2,713.48

2,616.31

2,861.20

2,612.40

2,488.00

2,861.20

26,843.25

<colgroup><col span="9"><col><col><col span="4"><col span="2"><col span="9"><col><col></colgroup><tbody>
</tbody>

 

[Herlengol]

SHORT TITLE

# Staff

NAME

FLSA Status

Location

Est. Hours/ Week

Est. Weeks/ Yr

Est. Hours/ Yr

Annual-ized FTE

Hire Date

Term Date

Rate as 3.20.2018

Proposed Rate

Annualized as of 3.20.2018

Proposed annual rate

11/1/2017

12/1/2017

1/1/2018

2/1/2018

3/1/2018

4/1/2018

5/1/2018

6/1/2018

7/1/2018

8/1/2018

9/1/2018

10/1/2018

TOTAL 2018

xxxx

1

xxxx

PT

BHED

40

42

2080

1.00

1/24/2014

12/31/2019

15.55

15.55

32,344

26,124

2,721.26

2,596.86

2,884.53

2,488.01

2,713.48

2,616.31

2,861.20

2,612.40

2,488.00

2,861.20

26,843.25

<colgroup><col span="9"><col><col><col span="4"><col span="2"><col span="9"><col><col></colgroup><tbody>
</tbody>

I am trying to find a formula that will automatically calculate or skip over July and August she works 42 weeks out of 52 weeks.

 

[shg]

A​

B​

C​

D​

E​

F​

G​

H​

I​

J​

K​

L​

M​

N​

O​

1​

Rate​

11/1/17​

12/1/17​

1/1/18​

2/1/18​

3/1/18​

4/1/18​

5/1/18​

6/1/18​

7/1/18​

8/1/18​

9/1/18​

10/1/18​

Total​

2​

15.55​

2,736.80​

2,612.40​

2,861.20​

2,488.00​

2,736.80​

2,612.40​

2,861.20​

2,612.40​

2,488.00​

2,861.20​

26,870.40​

B2: =$A2 * 8 * NETWORKDAYS(B1, EOMONTH(B1, 0))