Question

In: Accounting

Calculate overhead costs for a Chris, who earns $12/hour milking cows for Snohomish Dairies. Here are...

  1. Calculate overhead costs for a Chris, who earns $12/hour milking cows for Snohomish Dairies. Here are the details:
  • She works 10 hours per day, 6 days per week, 52 weeks per year (2 weeks are provided for sick leaves, vacation and personal leave)
  • She is married, age 45 and has two children
  • The health insurance premium is $800/month and is paid by Snohomish
  • Life insurance is $0.20 per month per $1000 of coverage. Snohomish provides $50,000 of coverage and Chris elects to pay for another $50,000 out of her salary.
  • Short-term and long-term disability insurance is 2% of salary, paid by Snohomish
  • Workers' compensation insurance is $1.2859 per hour worked (include the two weeks of leave time as hours worked). The experience rating factor is 0.95
  • Social security is 6.2% paid by Snohomish and 6.2% paid by Chris. These apply to the first $128,700 of income
  • Medicare/Medicaid is 1.45% paid by Chris and 1.45% paid by Snohomish
  • Retirement is 5% deducted from Chris’ salary with a 5% match from Snohomish
  • Federal unemployment tax is 0.6% of the first $7,000 of salary
  • To simplify the calculations, assume federal income tax is 10% of Chris’ base income
  • Assume State income tax is 3% of Chris’ base income
  • State unemployment tax is 2% of the first $47,300 of salary
  • Chris elects to put $150/month from his salary into a Health Savings Account
  1. Calculate the total cost of payroll expenses (aside from salary) paid by Snohomish Dairies and Chris.

  1. Calculate the percentage that these expenses are of the total salary.
  1. Calculate Chris’ total cost to Snohomish Dairies (salary + benefits) and Chris’ net income after taxes and benefit withholdings

  1. If you were the manager of this dairy, what would you focus on to lower Chris’ overall cost to the operation?

Solutions

Expert Solution

Calculation of total cost of pay roll expenses(Aside of Salary)
Description Qty. Rate Amount
Health Insurance premium 12 800 9600
Life insurance 12 10 120
Short term and Long Term disability 748.8
Workers' compensation insurance 4012.008
Social Security @ 6.20% 2321.28
Medicare/Medicaid@ 1.45% 542.88
Retairment @ 5% 1872
Federal unemployment tax 42
Total cost of pay roll expenses(Aside of Salary)

19258.968

Calculate the percentage that these expenses are of the total salary.

= 19258.968 / 56698.97 * 100

= 33.97%

Description Qty. Rate Amount
Pay roll expenses 3120 12 37440
Health Insurance premium 12 800 9600
Life insurance 12 10 120
Short term and Long Term disability 748.8
Workers' compensation insurance 4012.008
Social Security @ 6.20% 2321.28
Medicare/Medicaid@ 1.45% 542.88
Retairment @ 5% 1872
Federal unemployment tax 42
Total Cost to Snohomish Dairies 56698.968
Federal income Tax @ 10% 3744
State income tax @ 3% 1123.2
State unemloyment tax @ 2% 946
Net Income after taxes 50885.768
Note : Health savins account deduction is not considered since it is not a tax

If I am the manager of the company, I will focus on, how to get the more output from the Cris within his 10 hrs time. All others are statutory requirement and cannot be avoided.


Related Solutions

Aimee is a salaried nonexempt employee who earns an annual salary of $54,000 for a 35-hour...
Aimee is a salaried nonexempt employee who earns an annual salary of $54,000 for a 35-hour workweek, paid biweekly. The employer pays overtime for any hours worked in excess of 35 per week. During a pay period, she worked 73.5 hours. She has requested that she take compensatory time in lieu of paid overtime. How much compensatory time should she receive, assuming that her firm approves the compensatory time? 3.5 hours 2.75 hours 5.25 hours 10.25 hours
Jilai earns $12 per hour for up to 40 hours of work each week. He is...
Jilai earns $12 per hour for up to 40 hours of work each week. He is paid $18 for every hour in excess of 40. Jilai faces a 20 percent tax rate on his labor earnings. Regardless of how much he works, he also receives $200 in tax-free dividends from prior investments each week. There are 110 non-sleeping hours in the week. graph jilai.
Calculate Payroll An employee earns $30 per hour and 1.5 times that rate for all hours...
Calculate Payroll An employee earns $30 per hour and 1.5 times that rate for all hours in excess of 40 hours per week. If the employee worked 54 hours during the week. Assume that the social security tax rate is 6.0%, the Medicare tax rate is 1.5%, and the employee's federal income tax withheld is $295.a. Determine the employee's gross pay for the week. b. Determine the employee's net pay for the week. Round your answer to two decimal places.
Calculate Payroll An employee earns $40 per hour and 1.5 times that rate for all hours...
Calculate Payroll An employee earns $40 per hour and 1.5 times that rate for all hours in excess of 40 hours per week. Assume that the employee worked 55 hours during the week, and that the gross pay prior to the current week totaled $58,000. Assume further that the social security tax rate was 6.0%, the Medicare tax rate was 1.5%, and federal income tax to be withheld was $575. a. Determine the gross pay for the week. $ If...
how would someone find the variable manufacturing overhead per computer-hour? Here is the actual question. Luzadis...
how would someone find the variable manufacturing overhead per computer-hour? Here is the actual question. Luzadis Company makes furniture using the latest automated technology. The company uses a job-order costing system and applies manufacturing overhead cost to products on the basis of machine-hours. The predetermined overhead rate was based on a cost formula that estimates $1,368,000 of total manufacturing overhead for an estimated activity level of 72,000 machine-hours. During the year, a large quantity of furniture on the market resulted...
Presented here are the original overhead budget and the actual costs incurred during April for Piccolo,...
Presented here are the original overhead budget and the actual costs incurred during April for Piccolo, Inc. Piccolo’s managers relate overhead to direct labor hours for planning, control, and product costing purposes. The original budget is based on budgeted production of 16,400 units in 4,100 standard direct labor hours. Actual production of 18,000 units required 5,000 actual direct labor hours. Original Budget Actual Costs Variable overhead $ 24,600 $ 27,200 Fixed overhead 30,750 32,100 Required: a. Calculate the flexed budget...
I need to calculate the variable costs, DLH, Fixed costs and the manufacturing overhead rate per...
I need to calculate the variable costs, DLH, Fixed costs and the manufacturing overhead rate per direct labor hour for each quarter and year-end. I've done some calculation but I believe I am missing something in the variable costs calculations with the indirect materials, indirect labor hours and maintenance. I have been multiplying the indirect costs by DLH, but some of my instructions indicate I am supposed to divide it. Not sure if I am misinterpreting or just missing a...
Assume a product has the following activities and overhead costs: Production ($40 per labor hour) Assembly...
Assume a product has the following activities and overhead costs: Production ($40 per labor hour) Assembly ($25 per labor hour) Quality Inspection ($100 per inspection) Also assume that each product requires 5 hours of direct labor hours for production, 4 hours of direct labor hours for assembly, and one inspection for every 10 units produced. If the company produces 100 units, what is the total overhead cost?
Problem 12-18 Allocation to accomplish smoothing LO 12-1, 12-2, 12-3 Walton Corporation estimated its overhead costs...
Problem 12-18 Allocation to accomplish smoothing LO 12-1, 12-2, 12-3 Walton Corporation estimated its overhead costs would be $22,200 per month except for January when it pays the $155,700 annual insurance premium on the manufacturing facility. Accordingly, the January overhead costs were expected to be $177,900 ($155,700 + $22,200). The company expected to use 7,900 direct labor hours per month except during July, August, and September when the company expected 9,800 hours of direct labor each month to build inventories...
What are the drawbacks for a company who does not allocate overhead costs to its products?...
What are the drawbacks for a company who does not allocate overhead costs to its products? Why might a company do this and what other controls would they have to implement to insure optimal performance?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT