Response to the following problem:
Set up a worksheet to calculate the annual cost, average hourly cost, and the burden markup of an hourly employee. The spreadsheet should allow you to enter the hourly wages, the average number of hours paid for each week, number of days off per year, annual bonus ($/year), monthly allowances ($/month), the amount of employee expenses that are not subject to social security and Medicare taxes, social security percentage rate and limit, Medicare percentage rate, FUTA percentage rate and limit, SUTA percentage rate and limit, workers' compensation insurance rate ($/$100), general liability percentage rate, 401(k) matching rate and limit, monthly health insurance payment, monthly union payments, and other monthly benefits. Assume the employee takes full advantage of the 401(k) benefit.