What is the excel formula to find % of full-time staff? Labour Rates Full Time Hours General

What is the excel formula to find % of full-time staff?

Transcribed Image Text:

Labour Rates Full Time Hours General Rate Increase 40 5.0% Additional Employee Number E0412 Product Line Hours / Week Old Weekly Rate Increase Old Hourly Rate New Hourly Rate New Weekly Rate Rockglider Rockglider Strata 131.04 $ 89.52 S %24 40 1,747.20 5% 43.68 $ 5,241.60 3,580.72 3,849.60 E0416 40 1,627.60 3% 40.69 S E0418 32.08 S 44.82 S 40 24 1,283.20 1,434.24 1,078.72 5% 96.24 E0420 Strata 32 4% 102.19 S 3,270.07 33.71 28.62 31.94 E0424 Rockglider Rockglider Rockglider 32 $ 2% 55.28 1,769.10 1,501.98 3,832.80 E0425 32 915.84 46.94 40 1,277.60 5% %24 %24 62.64 S 54.60 $ E0428 $ 95.82 E0431 Strata 24 767.04 4% 31.96 S 1,503.40 Rockglider 1,747.06 E0435 E0438 E0440 E0443 1,065.28 1,641,60 1,360.00 32 2% 33.29 S 5% 4,268, 16 2,448.00 3,301.44 2,757.92 Strata 32 2$ 51.30 S 133.38 S Strata 40 2$ 2% 34.00 S Rockglider Rockglider 61.20 $ 103.17 S 68.95 S 32 2$ 1,448.00 4% 45.25 S E0446 40 1,253,60 3% 31.34 $ Lowest New Weekly Rate: S Highest New Weekly Rate: S Average New Weekly Rate: S 1,501.98 5,241.60 3,005.53 Total Weekly Increase: S % Total Weekly Increase: % Full Time Staff: 22,171.92 76.2% Labour Rates Full Time Hours General Rate Increase 40 5.0% Additional Employee Number E0412 Product Line Hours / Week Old Weekly Rate Increase Old Hourly Rate New Hourly Rate New Weekly Rate Rockglider Rockglider Strata 131.04 $ 89.52 S %24 40 1,747.20 5% 43.68 $ 5,241.60 3,580.72 3,849.60 E0416 40 1,627.60 3% 40.69 S E0418 32.08 S 44.82 S 40 24 1,283.20 1,434.24 1,078.72 5% 96.24 E0420 Strata 32 4% 102.19 S 3,270.07 33.71 28.62 31.94 E0424 Rockglider Rockglider Rockglider 32 $ 2% 55.28 1,769.10 1,501.98 3,832.80 E0425 32 915.84 46.94 40 1,277.60 5% %24 %24 62.64 S 54.60 $ E0428 $ 95.82 E0431 Strata 24 767.04 4% 31.96 S 1,503.40 Rockglider 1,747.06 E0435 E0438 E0440 E0443 1,065.28 1,641,60 1,360.00 32 2% 33.29 S 5% 4,268, 16 2,448.00 3,301.44 2,757.92 Strata 32 2$ 51.30 S 133.38 S Strata 40 2$ 2% 34.00 S Rockglider Rockglider 61.20 $ 103.17 S 68.95 S 32 2$ 1,448.00 4% 45.25 S E0446 40 1,253,60 3% 31.34 $ Lowest New Weekly Rate: S Highest New Weekly Rate: S Average New Weekly Rate: S 1,501.98 5,241.60 3,005.53 Total Weekly Increase: S % Total Weekly Increase: % Full Time Staff: 22,171.92 76.2%

Answer rating: 100% (QA)

Answers Insert the below formula ... View the full answer