Estimated Weekly Labour Costs
						Weekend Loading	25%
						% Super	9.5%
Employee Number	Product Line	Hourly Rate	Weekday Hours	Weekend Hours	Total Weekly Hours	Weekly Rate	Hourly Pay with Super
S12716	Sprinter	$ 62.11	36	4
S12717	Sprinter	$ 56.40	40	0
S12720	Dash	$ 47.00	40	0
S12722	Dash	$ 58.48	40	0
S12723	Dash	$ 60.95	24	8
S12724	Dash	$ 39.63	40	0
S12725	Sprinter	$ 59.90	40	0
S12726	Sprinter	$ 36.63	16	4
S12727	Dash	$ 61.65	24	8
S12728	Dash	$ 59.93	32	8
S12729	Sprinter	$ 37.67	28	8
S12730	Sprinter	$ 35.57	24	8
S12733	Sprinter	$ 45.83	40	0
						Average Hourly Pay:
						Top/Bottom Pay Difference:
						Number Full Time Staff:

Bi BI BB BE Bi" HE E? BID This sheet contains a list of staff with their weekly rate and typical work week and weekend hours worked per week. In cell FE add the Weekday Hours to the Weekend Hours to get Total Weekly Hours. Copy the formula down to FED. Widen column C'- so it is a similar width to the columns either side of it {all text in {34 should be visible}. Change the number formatting in H5 to percentage with one decimal place. The company currently pay an additional 25% [shown in H4} on top of the standard rate for weekend hours. In GB calculate the weekly rate for employee Si 2?1 5 using the value in H4 [do not type the 25% into the formula as the rate may change]. Copy the formula down to GED. Cell H5 contains the \"is superannuation the company contributes. In HE calculate the average hourly rate with super for employee 512?\": [add the super to weekly rate and then divide by the total hours worked in a week}. Copy the formula down to H20. {Note if the rate in H5 changesIr calculation results should reflect the change.) Home these ranges as follows [must be exact}: ll: 3:32!) P rod uct_Line HE:H 2C! HourIy_Pay {Feel free to name any other ranges that prove helpful.] In H22 calculate the average of the hourly pay with super figures. In H23 calculate the difference between the highest and lowest hourly pay with super. {Note these values can change and the formula must still work]. Staff who work a total of AD hours per week are considered full time staff. In H24 calculate the number of full-time staff. [Keep in mind that the hours staff work can change, and the formula should still return a correct answer.]