Month: January Year:2018 Trading Days:22 Staff Full Clients Service S/Sales S/Sales Retail R/Sales R/Sales Voucher Total Re- New Gross Wages Name Days Clients per Day Sales per Day per Sales per Day per Sales Books Clients Wages to Total $ $ Client $ $ Client $ $ $ & % Sales % $ $ Carmen 7.47 45 6 2200 294.64 48.89 150 20.09 3.33 100 2450 250 29/64 8 1500 61.22 Simone 4.27 31 7.3 1719 402.89 55.45 750 175.78 24.19 250 2719 35 12/39 4 800 29.42 Laura 10.67 57 5.3 2560 240 44.91 1290 120.94 22.63 75 3925 120 45/79 7 1400 35.67 Jen 13.33 96 7.2 3275 245.63 34.11 1500 112.60 15.63 550 5325 0 75/78 0 1650 30.99 SALON 35.74 229 6.4 9754 272.97 42.59 3690 103.26 16.11 975 14419 405 161/70 19 5350 37.1 All sales figures must be tax or GST exclusive. Full Days = Total Monthly Hours divided by 7.5 Notes: Clients per day = Total Clients divided by Trading Days Service Sales per day = Service Sales divided by Trading Days Service Sales per Client = Service sales divided by Total Clients Retail Sales per Day = Retail sales divided by Trading Days Retail Sales per Client = Retail sales divided by Total Clients Total Sales = Service Sales + Retail Sales + Gift Sales Rebooks & % = # of clients re-booked then multiplied by 100 and divided by Total Clients Wages to Total Sales = Gross wages multiplied by 100 then divided by Total Sales.
Month: January Year:2018 Trading Days:22 Staff Name Full Days Clients Clients per Day Service Sales $ S/Sales per Day $ S/Sales per Client $ Retail Sales $ R/Sales per Day $ R/Sales per Client $ $ Total Sales $ $ Re- Books & % New Clients Gross Wages Wages to Total Sales % Carmen 7.47 45 6 2200 294.64 48.89 150 20.09 3.33 100 2450 250 29/64 8 1500 61.22 Simone 4.27 31 7.3 1719 402.89 55.45 750 175.78 24.19 250 2719 35 12/39 4 800 29.42 Laura 10.67 57 5.3 2560 240 44.91 1290 120.94 22.63 75 3925 120 45/79 7 1400 35.67 Jen 13.33 96 7.2 3275 245.63 34.11 1500 112.60 15.63 550 5325 0 75/78 0 1650 30.99 SALON 35.74 229 6.4 9754 272.97 42.59 3690 103.26 16.11 975 14419 405 161/70 19 5350 37.1 All sales figures must be tax or GST exclusive. Full Days = Total Monthly Hours divided by 7.5 Notes: Clients per day = Total Clients divided by Trading Days Service Sales per day = Service Sales divided by Trading Days Service Sales per Client = Service sales divided by Total Clients Retail Sales per Day = Retail sales divided by Trading Days Retail Sales per Client = Retail sales divided by Total Clients Total Sales = Service Sales + Retail Sales + Gift Voucher Sales Rebooks & % = # of clients re-booked then multiplied by 100 and divided by Total Clients Wages to Total Sales = Gross wages multiplied by 100 then divided by Total Sales.