You run a company with 6 employees. Create a spreadsheet that keeps track of the hours each employee works and determines their weekly salary. If they work 40 hours or less they simply get their hourly wage times the number of hours worked. If they work overtime, anything over 40 hours gets paid time and a half; so 2 overtime hours gets paid for 3 hours worked.
c.) Enter a formula which computes the total weekly wage for the employees. The formula should give time and half for any hours worked over 40. Format as currency. Spreadsheet attached
Looking for a Similar Assignment? Order now and Get 20% Discount! Use Code GET20