Calculating incomes
Spreadsheets are a useful tool in calculating various types of incomes. Open the Incomes workbook (.XLSX 13KB) and on each sheet (each sheet has its own tab at the bottom of the workbook) enter the appropriate data and formulae for the scenario. You could also choose to format fonts, cell sizes and shading as desired. If you are unsure about using formulae, visit Microsoft's Formulas and functions website.
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.