Your store’s average basket (transaction) size for the month of March was $11.50 and you believe the average basket size will remain the same for your store in April. One of your hourly employees had an average basket size of $9.00 for the month of March and averaged 125 transactions per shift. If the same employee’s average basket size was $9.00 for the first two weeks of April but improved to $11.00 for the second two weeks of April, her sales will now be how much lower than the average for your store?
To calculate the difference in sales between the employee and the store average, we need to find the total sales for both the employee and the store.
First, let's calculate the total sales for the employee for the month of March:
Average Basket Size: $9.00
Number of Transactions per shift: 125
Number of shifts in a month (assuming 5 workdays a week): 5 * 4 = 20
Total transactions in March: 20 * 125 = 2500
Total sales for the employee in March: $9.00 * 2500 = $22,500
Next, let's calculate the total sales for the employee for the month of April:
For the first two weeks of April:
Average Basket Size: $9.00
Number of transactions for the first two weeks: 125 * 10 = 1250
Total sales for the first two weeks of April: $9.00 * 1250 = $11,250
For the second two weeks of April:
Average Basket Size: $11.00
Number of transactions for the second two weeks: 125 * 10 = 1250
Total sales for the second two weeks of April: $11.00 * 1250 = $13,750
Total sales for the employee in April: $11,250 + $13,750 = $25,000
Now, let's calculate the average store sales for April:
Average Basket Size: $11.50
Number of transactions for the whole month: 2500
Total sales for the store in April: $11.50 * 2500 = $28,750
Finally, we can calculate the difference in sales between the employee and the store:
Sales difference = Employee's sales - Store's sales
Sales difference = $25,000 - $28,750
Sales difference = -$3,750
Therefore, the employee's sales will be $3,750 lower than the average sales for the store in April.