Calculating incomes

Shuffles Shoes pays award rates as follows:

• Normal rate for 0–36 hours worked.

• Time-and-a-half for the next 4 hours worked.

• Double time for any hours worked after that.

Use your spreadsheet to calculate the wage bill for the company.

Everyday Exercise Equipment pays salespeople by commission.

• Jill earns a flat rate of 5% of all sales.

• Bill earns 3.8% of all sales, plus a retainer of $110 per week.

• Gill earns 6% of all sales over $4000, plus a retainer of $75 per week.

• Lilleth earns 7.2% of all sales over $6500, plus a $200 retainer per week.

Assume all co-workers make the same value of sales in a particular week. Use your spreadsheet to determine what that value of sales is if Jill is to be the highest income earner of that week.

Alex works at the Splash’n’Dash car wash. He earns $6.50 per car for a wash only and $17.25 per car for a wash and polish.

His job sheet for a recent 35-hour week, appears below.

Use your spreadsheet to calculate his total weekly earnings, average daily earnings and his average hourly rate of pay.