subject
Business, 17.12.2020 14:00 mrnotsosmart2787

PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pay each employee and the total you pay all employees. You pay your employees every two weeks, and for the last two weeks, your employees worked the following hours:

Employee 1: 78
Employee 2: 75
Employee 3: 80
Employee 4: 45
Employee 5: 50
Employee 6: 80
Employee 7: 65
Employee 8: 60
Employee 9: 78
Employee 10: 75
Your spreadsheet should calculate:

the total hours worked for each employee;
the gross pay for each employee (pay rate is $12.50 per hour);
the state income tax for each employee. Use 5.7%;
the Federal income tax for each employee. Use 15%;
Social Security for each employee. Use 3.5 %;
the net pay for each employee by subtracting the income tax and Social Security from the gross pay;
the total gross pay, total state income tax, total Federal income tax, total Social Security, and total net pay paid to all employees.
When you finish your spreadsheet, estimate your answers.

ansver
Answers: 3

Another question on Business

question
Business, 22.06.2019 03:00
1) u.s. real gdp is substantially higher today than it was 60 years ago. what does this tell us, and what does it not tell us, about the well-being of u.s. residents? what are the limitations of the gdp as a measure of economic well-being? given the limitations, why is gdp usually regarded as the best single measure of a society’s economic well-being? 2) what is an intermediate good? how does an intermediate good differ from a final good? explain why it is the case that the value of intermediate goods produced and sold during the year is not included directly as part of gdp, but the value of intermediate goods produced and not sold is included directly as part of gdp.
Answers: 2
question
Business, 22.06.2019 08:10
The last time he flew jet value air, juan's plane developed a fuel leak and had to make an 4) emergency landing. the time before that, his plane was grounded because of an electrical problem. juan is sure his current trip will be fraught with problems and he will once again be delayed. this is an example of the bias a) confirmation b) availability c) selective perception d) randomness
Answers: 1
question
Business, 22.06.2019 11:40
Zachary company produces commercial gardening equipment. since production is highly automated, the company allocates its overhead costs to product lines using activity-based costing. the costs and cost drivers associated with the four overhead activity cost pools follow: activities unit level batch level product level facility level cost $ 64,800 $ 27,730 $ 15,000 $ 154,000 cost driver 2,400 labor hrs. 47 setups percentage of use 11,000 units production of 780 sets of cutting shears, one of the company’s 20 products, took 240 labor hours and 7 setups and consumed 15 percent of the product-sustaining activities. required: (a) had the company used labor hours as a company wide allocation base, how much overhead would it have allocated to the cutting shears? (b) how much overhead is allocated to the cutting shears using activity-based costing? (c) compute the overhead cost per unit for cutting shears first using activity-based costing and then using direct labor hours for allocation if 780 units are produced. if direct product costs are $150 and the product is priced at 30 percent above cost for what price would the product sell under each allocation system? (d) assuming that activity-based costing provides a more accurate estimate of cost, indicate whether the cutting shears would be over- or underpriced if direct labor hours are used as an allocation base. explain how over-or undercosting can affect vaulker's profitability. (e) comment on the validity of using the allocated facility-level cost in the pricing decision. should other costs be considered in a cost- plus pricing decision? if so, which ones? what costs would you include if you were trying to decide whether to accept a special order?
Answers: 1
question
Business, 22.06.2019 19:50
The common stock and debt of northern sludge are valued at $65 million and $35 million, respectively. investors currently require a return of 15.9% on the common stock and a return of 7.8% on the debt. if northern sludge issues an additional $14 million of common stock and uses this money to retire debt, what happens to the expected return on the stock? assume that the change in capital structure does not affect the interest rate on northern’s debt and that there are no taxes.
Answers: 2
You know the right answer?
PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pa...
Questions
question
Mathematics, 17.10.2021 16:20
question
Mathematics, 17.10.2021 16:20
question
History, 17.10.2021 16:20
question
Biology, 17.10.2021 16:20
question
Mathematics, 17.10.2021 16:20
Questions on the website: 13722362