"Bringing joy to running a restaurant"
Mallet - Minimum Wage Calculator
2016 Actual
Pay Type Pay Hrs Pay Amt
Undo Delete Clear Demo Data Add

How Labor Cost is Impacted by Minimum Wage Increases

Avg Hourly Rate Projection
Pay Type 2016 2017 2018 2019 2020 2021 2022
Mandated Minimum Hourly Wage 10 10.5 11 12 13 14 15
Percent Increase in Min. Wage 0% 5% 5% 9% 8% 8% 7%
Wage Increases
{{wage.name}} {{wage.avg_hrs+buffer16|number:2}}
{{wage.avg_hrs+buffer17|number:2}}
{{wage.avg_hrs+buffer18|number:2}}
{{wage.avg_hrs+buffer19|number:2}}
{{wage.avg_hrs+buffer20|number:2}}
{{wage.avg_hrs+buffer21|number:2}}
{{wage.avg_hrs+buffer22|number:2}}
Projected Payroll Costs
Pay Type 2016 2017 2018 2019 2020 2021 2022
{{wage.name}} {{(wage.avg_hrs+buffer16)*wage.pay_hrs|number:2}} {{(wage.avg_hrs+buffer17)*wage.pay_hrs|number:2}} {{(wage.avg_hrs+buffer18)*wage.pay_hrs|number:2}} {{(wage.avg_hrs+buffer19)*wage.pay_hrs|number:2}} {{(wage.avg_hrs+buffer20)*wage.pay_hrs|number:2}} {{(wage.avg_hrs+buffer21)*wage.pay_hrs|number:2}} {{(wage.avg_hrs+buffer22)*wage.pay_hrs|number:2}}
Sub-total {{subtotal(minwage, buffer16)|number:2}} {{subtotal(minwage, buffer17)|number:2}} {{subtotal(minwage, buffer18)|number:2}} {{subtotal(minwage, buffer19)|number:2}} {{subtotal(minwage, buffer20)|number:2}} {{subtotal(minwage, buffer21)|number:2}} {{subtotal(minwage, buffer22)|number:2}}
Workers Comp {{subtotal(minwage, buffer16)*workers_comp_rate/100|number:2}} {{subtotal(minwage, buffer17)*workers_comp_rate/100|number:2}} {{subtotal(minwage, buffer18)*workers_comp_rate/100|number:2}} {{subtotal(minwage, buffer19)*workers_comp_rate/100|number:2}} {{subtotal(minwage, buffer20)*workers_comp_rate/100|number:2}} {{subtotal(minwage, buffer21)*workers_comp_rate/100|number:2}} {{subtotal(minwage, buffer22)*workers_comp_rate/100|number:2}}
Payroll Taxes {{subtotal(minwage, buffer16)*payroll_taxes_rate/100|number:2}} {{subtotal(minwage, buffer17)*payroll_taxes_rate/100|number:2}} {{subtotal(minwage, buffer18)*payroll_taxes_rate/100|number:2}} {{subtotal(minwage, buffer19)*payroll_taxes_rate/100|number:2}} {{subtotal(minwage, buffer20)*payroll_taxes_rate/100|number:2}} {{subtotal(minwage, buffer21)*payroll_taxes_rate/100|number:2}} {{subtotal(minwage, buffer22)*payroll_taxes_rate/100|number:2}}
Grand total - Payroll {{grandtotal(minwage, buffer16)|number:2}} {{grandtotal(minwage, buffer17)|number:2}} {{grandtotal(minwage, buffer18)|number:2}} {{grandtotal(minwage, buffer19)|number:2}} {{grandtotal(minwage, buffer20)|number:2}} {{grandtotal(minwage, buffer21)|number:2}} {{grandtotal(minwage, buffer22)|number:2}}
How Labor Cost Is Impacted by Minimum Wage Increases
2016 2017 2018 2019 2020 2021 2022
Projected Sales - No Change {{projected_sales|number:2}} {{projected_sales|number:2}} {{projected_sales|number:2}} {{projected_sales|number:2}} {{projected_sales|number:2}} {{projected_sales|number:2}} {{projected_sales|number:2}}
Projected Sales - No Change - Labor {{grandtotal(minwage, buffer16)/projected_sales*100|number:2}}% {{grandtotal(minwage, buffer17)/projected_sales*100|number:2}}% {{grandtotal(minwage, buffer18)/projected_sales*100|number:2}}% {{grandtotal(minwage, buffer19)/projected_sales*100|number:2}}% {{grandtotal(minwage, buffer20)/projected_sales*100|number:2}}% {{grandtotal(minwage, buffer21)/projected_sales*100|number:2}}% {{grandtotal(minwage, buffer22)/projected_sales*100|number:2}}%
Projected Sales - {{annual_increase}}% Annual Increase {{projected_sales|number:2}} {{projected_sales*(1+(annual_increase/100)|mathPow:1)|number:2}} {{projected_sales*(1+(annual_increase/100)|mathPow:2)|number:2}} {{projected_sales*(1+(annual_increase/100)|mathPow:3)|number:2}} {{projected_sales*(1+(annual_increase/100)|mathPow:4)|number:2}} {{projected_sales*(1+(annual_increase/100)|mathPow:5)|number:2}} {{projected_sales*(1+(annual_increase/100)|mathPow:6)|number:2}}
Projected Sales - {{annual_increase}}% Annual Increase - Labor {{(grandtotal(minwage, buffer16)/projected_sales)*100|number:2}}% {{grandtotal(minwage, buffer17)/(projected_sales*(1+(annual_increase/100)|mathPow:1))*100|number:2}}% {{grandtotal(minwage, buffer18)/(projected_sales*(1+(annual_increase/100)|mathPow:2))*100|number:2}}% {{grandtotal(minwage, buffer19)/(projected_sales*(1+(annual_increase/100)|mathPow:3))*100|number:2}}% {{grandtotal(minwage, buffer20)/(projected_sales*(1+(annual_increase/100)|mathPow:4))*100|number:2}}% {{grandtotal(minwage, buffer21)/(projected_sales*(1+(annual_increase/100)|mathPow:5))*100|number:2}}% {{grandtotal(minwage, buffer22)/(projected_sales*(1+(annual_increase/100)|mathPow:6))*100|number:2}}%
Sales to Maintain 2016 Labor Ratio {{projected_sales|number:2}} {{grandtotal(minwage, buffer17)/(grandtotal(minwage, 0)/projected_sales)|number:2}} {{grandtotal(minwage, buffer18)/(grandtotal(minwage, 0)/projected_sales)|number:2}} {{grandtotal(minwage, buffer19)/(grandtotal(minwage, 0)/projected_sales)|number:2}} {{grandtotal(minwage, buffer20)/(grandtotal(minwage, 0)/projected_sales)|number:2}} {{grandtotal(minwage, buffer21)/(grandtotal(minwage, 0)/projected_sales)|number:2}} {{grandtotal(minwage, buffer22)/(grandtotal(minwage, 0)/projected_sales)|number:2}}
% Increase in Revenues to Maintain 2016 Labor Ratio 0% {{((grandtotal(minwage, buffer17)/(grandtotal(minwage, 0)/projected_sales)-projected_sales)/projected_sales)*100|number:2}}% {{((grandtotal(minwage, buffer18)/(grandtotal(minwage, 0)/projected_sales)-projected_sales)/projected_sales)*100|number:2}}% {{((grandtotal(minwage, buffer19)/(grandtotal(minwage, 0)/projected_sales)-projected_sales)/projected_sales)*100|number:2}}% {{((grandtotal(minwage, buffer20)/(grandtotal(minwage, 0)/projected_sales)-projected_sales)/projected_sales)*100|number:2}}% {{((grandtotal(minwage, buffer21)/(grandtotal(minwage, 0)/projected_sales)-projected_sales)/projected_sales)*100|number:2}}% {{((grandtotal(minwage, buffer22)/(grandtotal(minwage, 0)/projected_sales)-projected_sales)/projected_sales)*100|number:2}}%
All wages rise proportionate to minimum wage increase
Once minimum wage stays the same (levels out), this can still be used to project increases in labor costs due to wages, hiring more people etc
Sales can increase depending on: number of customers, sell more to same customers and/or raise prices
Two biggest expenses for a restaurant are labor and food. See how to decrease food costs