Gross income for computer repair business

Assignment Help Other Subject
Reference no: EM13214837

In this project, you will enter in the correct formulas or functions needed to find out the monthly gross income for a computer repair business. To view these instructions while working in Excel, print these instructions or move back and forth between your browser and Excel.

1.Follow this link: Computer Business. Save the file onto your computer. Then locate the Excel file (workbook) on your computer and open it. If you experience problems opening the file, then contact technical support at (877) 221-5800, option 2.
2.The orange-colored cells on the worksheet indicate places where you will put in the formulas and functions.
3.Calculate the total gross pay for each employee. Keep in mind that employees are paid time and a half for all overtime hours. Here is an example formula that demonstrates how you would make such a calculation: (regular hours * hourly rate) + (overtime hours * hourly rate * 1.5) = (b4*d4) + (b4*c4*1.5). These must be formulas and will be entered into the range E11-E14.
4.In steps 5, 6, and 7 below, you must include an absolute reference cell in each formula. Imagine while you are completing these steps that there are 150 employees at the company.
5.Calculate the total amount each employee must pay in federal taxes in the range F11-F14. These calculations must be completed using formulas. These formulas must contain an absolute reference to the cell holding the percentage amount. The percentage figure used in the formula is above the word federal in cell F9.
6.Calculate the total amount each employee must pay in state taxes in the range G11-G14. These calculations must be completed using formulas. These formulas must contain an absolute reference to the cell holding the percentage amount. The percentage figure used in the formula is above the word state in cell G9.
7.Calculate the total amount each employee must pay in social security taxes in the range H11-H14. These calculations must be completed using formulas. These formulas must contain an absolute reference to the cell holding the percentage amount. The percentage figure is above the word social in cell H9.
8.Calculate the total net pay for each employee in the range I11-I14. These calculations must be completed using a formula.
9.Calculate the totals for all of the employee hours and pay categories in the range B16-I16. These calculations must be completed using Sum functions.
10.Format all of the cells that represent a dollar amount as currency with 2 decimal places. 

Reference no: EM13214837

Questions Cloud

How are likert''s casual-intervening and end result variables : How are Likert's casual, intervening, and end result variables useful in discussing and thinking about effectiveness?
Why beth uses the simplified method to compute exclusion : Jim and Linda are your tax clients. They were divorced two years ago, and the divorce decree stated that Jim was to make monthly payments to Linda. The court designated $300 per month as alimony and $200 per month as child support.
The federalists party : The Federalists party, as the party of the "outs" at the end of its existence
Case study on royal bank of canada in thailand : This case analyzes the problems facing a bank in a foreign country and the reasons for deciding to stay or to close its operation. Royal Bank of Canada is the bank involved in this real life situation.
Gross income for computer repair business : In this project, you will enter in the correct formulas or functions needed to find out the monthly gross income for a computer repair business. To view these instructions while working in Excel, print these instructions or move back and forth betwee..
Calculate the present value of each investment : Your client is considering the purchase of $100,000 in common stock, which pays no dividends and will appreciate in market value by 10 percent per year. At the same time, the client is considering an opportunity to invest $100,000 in a lease oblig..
Which ratio appears on a common-size balance sheet : Grandma's Applesauce, Inc. has a 0.60 probability of a good year with operating cash flow of $50,000; and 0.40 probability of a bad year with operating cash flow of $30,000. The company has a debt of $35,000 with 8 percent interest due next year.
Explain the government contracts with a trust to pay : A local government is about to run a lottery but does not want to be involved in the payoff if a winner picks an annuity payoff. The government contracts with a trust to pay the lump-sum payout to the trust and have the trust (probably a local ban..
How you would apply econometrics in your advice : Discuss what interests you the most about econometrics and state why.

Reviews

Write a Review

 

Other Subject Questions & Answers

  Current education policies

Discuss current education policies related to early childhood and how it may affect my role as a future educational psychologist professional.

  Sexual knowledge and technology

How have advances in sexual knowledge and technology facilitated human sexual expression?

  Describing erikson stages of development

Determine and describe Erikson's stages of development as each applies to your own personality formation. How did success at one stage prepare you for meeting the next challenge.

  Define democracy and define reform

Define democracy and define reform. What aspects did Populist and Progressive reform movements have in common that reflected those definitions and specify how so in each case.

  Office friendships

Which of the following is true about office friendships?

  Narco-terror groups

Oftentimes groups like the Revolutionary Armed Forces of Columbia (FARC) are described as "Narco-Terror groups." However, the US makes a clear policy distinction between the War on Terror, which is really a war to counter violent Islamist extremism a..

  Describe the processes involved in development

Describe strategies which teachers can use to stop students from misbehaving in class What do you understand by the term development Describe the processes involved in development

  Depolarization and repolarization phases of action potential

When ion movements across the membrane occur during the depolarization and repolarization phases of an action potential, they are moving by

  Identify areas of environmental concerns and risks

You are a squad leader in Sapper platoon, Special Troop Battalion, 3rd Brigade, 10th Mountain Division. Your unit will deploy to Afghanistan to conduct operations in support of Operation Enduring Freedom

  Because of his deep commitment to folk music

Because of his deep commitment to folk music, which composer is said to have been more successful at integrating folk music into the classical music literature than any other compose

  Concepts of thinking-consciousness

Critically illustrate out the difference between the concepts of thinking, consciousness, and knowledge in relation to machine intelligence and human intelligence?

  Modern example of the potlatch

Which of the following might be interpreted as a modern example of the potlatch?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd