Question: 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

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.

Step by Step Solution

★★★★★

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

Wages 850 Hour Wages 21195 Average Hours Per Week 45 Hours Allo... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Document Format (1 attachment)

246-B-F-F-M (1854).xlsx

300 KBs Excel File

Students Have Also Explored These Related Finance Questions!

Set up a worksheet to calculate the annual cost, the monthly cost, and the burden markup of a salaried employee. The spreadsheet should allow you to enter the annual salary, annual bonus ($/year),...

Calculate the annual cost in years 1 through 9 of the following series of disbursements. Use an interest rate of 10% peryear. Year Disbursement, S Year Disbursement, $ 5000 5500 6000 6500 7000 7500...

30) Calculate the annual cost for commercial paper (CP) on a $10,000,000 CP issue with a 60-day maturity at a discount rate of 7%. The prorated dealer cost for the CP works out to $2,083. The company...

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...

7. 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...

Set up a worksheet to calculate the annual cost, the monthly cost, and the burden markup of a salaried employee. The spreadsheet should allow you to enter the annual salary, annual bonus ($/year),...

Last year an hourly employee worked 1,960 hours at regular wage rates, 110 hours at overtime wage rates, and was paid an additional 120 hours at regular wage rates for vacation. Overtime is paid at a...

2. Why are the social security and Medicare taxes paid by the employee not included in labor burden? 3. How does employee turnover affect the labor burden costs? 4. What can a company do to reduce...

The admission data for freshmen at Tech during the past 10 years are as follows: Techs admission objective is a class of 5000 entering freshmen, and it wants to forecast the percentage of offers it...

Past studies showed that maternal diabetes results in obesity, blood pressure, and glucose tolerance complications in the offspring. Following are the arterial blood pressures, in millimetres of...

Entertainment expenses are generally nondeductible, regardless of whether or not they are directly related to or associated with the taxpayer s business. Which of the following is not an exception to...

What is the future value of a 24-year ordinary annuity with annual payments of $51,000, evaluated at a 9.8 percent interest rate? Round it to two decimal places, and do not include the $ sign, e.g.,...

Financial information at 30 June 2020 of Great Ltd and its subsidiary company, Wall Ltd, is shown below. At 1 July 2017, the date Great Ltd acquired its 80% shareholding in Wall Ltd, all the...

Trey, Cactus, and Leo are all going to start up new businesses in town. They are all making their decisions simultaneously, and they know the profits they can earn depend on their choice and on the...

American Broadcasting Company (ABC), which is a publicly listed company, has just hired you (Student) as a consultant. Your client is Sally Chen, the assistant controller for the company and you have...

14. (LO 6.3) The stock market typically yields a small positive return each day, but intermittently it yields a high negative return on a few days. What type of distribution describes this behavior?...

Set up a spreadsheet to solve Problem 1. In Problem 1, A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction...

Set up a spreadsheet to solve Problem 2. In Problem 2, A construction company is negotiating on a construction project with a six-month duration. On the last day of each month the construction...

Set up a spreadsheet similar to Figure 12-11 to solve Problem 3. FIGURE 12-11 A construction company is bidding on a contract to build homes for a developer. The project consists of two types of...

Based on the following information: Calculate the expected return for the two stocks. (Do not round intermediate calculations and round your final answers to 2 decimal places. (e.g., 32.16))...

What are the values of variables x , y , and z after the following code is run?x = 7 , y = = 1 2 , z = = 5 x = 6 , y = 5 , z = = 6 x = 7 , y = = 1 1 , z = = 6 x = 6 , y = 6 , z = = 5

13) JW Enterprises is considering a new marketing campaign that will require the addition of a new computer programmer and new software. The programmer will occupy an office in JWs current building...