PROJECT: USING ADVANCED FORMULAS
Suppose you own a small business with ten employees. Small businesses use spreadsheets for a variety of reasons.

OBJECTIVES
Create a spreadsheet to track payroll.
Directions
Create 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 to check for accuracy. Make any necessary corrections. Use formatting techniques to make your spreadsheet easy to read. Upload your spreadsheet using the Upload tool in the box below.

Answers

Answer 1

Answer:

Total hours worked for two weeks by all employees = 686 hours

Total Gross pay of all employees = $8,575.00

Total State income tax of all employees = $488.78

Total Federal income tax of all employees = $1,286.25

Total Social Security of all employees = $300.13

Total Net Pay of all employees = $6,499.85

Explanation:

Note: See the attached excel file for the calculation of the company's payroll or amount paid to each employee and the total amount paid to all employees on a spreadsheet as required by the question.

In the attached excel file, the following formula are used:

Gross pay for each employee = Pay rate of $12.50 per hour * Total hours worked for two weeks by each employee

State income tax for each employee = 5.7% * Gross pay for each employee

Federal income tax for each employee = 15% * Gross pay for each employee

Social Security for each employee = 3.5% * Gross pay for each employee

Answer 2

Answer:

here you go edmentum

Explanation:

PROJECT: USING ADVANCED FORMULASSuppose You Own A Small Business With Ten Employees. Small Businesses

Related Questions

Is it possible for someone in a working industry to has self-motivation, but not self-discipline? Explain.

Answers

It is possible because someone can believe in their self but they can’t control their temptations or their weakness to something

Work and/or assignments performed in a career are _____.


A.) tasks


B.) values


C.) interests


D.) employees


(please help :D)

Answers

Answer:

b. task

Explanation:

The assignments which are actually performed in a given career is known as Tasks option(a) is correct.

What is a career?

A career in simple words we can say that it is known to be an occupation or a profession which actually undertakes for a longer period of the time which gives monetary benefits over a period of the time.

Career is usually one person choose to do because it is known to be his/her purpose of choosing a right path over a period of the time.

Therefore Option(a) is correct.

Learn more about Career here:

https://brainly.com/question/2160579

#SPJ2

Which of the following is not a required element of a contract
A Offer
B Breach
C Acceptance
D Consideration

Answers

Answer:

D

Explanation:

Consideration is unnecessary.

Considering the available options, the option that is not a required element of a contract is "Breach."

This is because for a contract to be valid and enforceable in a court of law there must be the following elements.

Offer: there must be an offer from one party to another which must be accepted. Offer can be verbal or written. The person making the offer is known as the offeror.

Acceptance: for a contract to be valid, there must also be an acceptance from the other party. Acceptance can also be verbal or written. The person accepting the offer is known as the offeree.

Consideration: this is also an essential part of a contract. A consideration Is what is given by the parties to a contract to make it enforceable. For instance, a vendor's consideration is goods or services delivered, while a purchaser's consideration is the money paid for the goods or services.

However, the breach is not part of a contract element as breach voids a contract.

Some other elements of a contract are the legality and capacity of the parties and the consideration involved.

Hence, in this case, the correct answer is option B. "Breach."

Learn more here: https://brainly.com/question/18635207

When loan payments are amortized, the total amount you owe every month​

Answers

Answer:

Since amortization means the period repayment of a loan, with a specific amount going to the principal and interest payments, the amortization schedule amounts to a total fixed monthly payment of $836.03 over the life of the mortgage loan.

Explanation:

At the time when the loan payment should be amortized so the total amount owed is the periodic payment.

The following information related to the periodic payment is:

At the time when there is owe amount for each amount and the payment regarding the loan should be amortized so it is a periodic payment. Also, from that some part of the payment is belonged to the interest and principal amount.

Therefore we can conclude that at the time when the loan payment should be amortized so the total amount owed is the periodic payment.

Learn more: brainly.com/question/15569649

Other Questions
Which situation helped cause the Spanish-American War PLEASE ANSWER QUICKLY ITS DUE IN 3 MIN LOLArtaud noticed that if he takes the opposite of his age and adds 39 he gets the number 23. How old is Artaud? Imagine that you drop an object of 10 kg, how much will be the acceleration andhow much force causes the acceleration? 1f y0u c4n r34d 7h15 y0u 4r3 5m4r7 4nd v3ry w1531 l1k3 y0ur cu7 6..... What macromolecules provide instruction for growth A train travels 558 miles in 3 hours. At this rate, how far does the train travelin 6 hours?186 milesO 1,67401,116 milesO 18 miles The student council has decided to have a raffle at the carnival. They came up with a table to show the relationship between the number of tickets bought and the number of raffle entries. Explain why it could be helpful for the student council to determine an equation to represent this data. What is the name of each labeled part?BBCEAED Why might not wrestling be considered among the oldest sports in recordedhistory?A. It was always overshadowed by marathon races, so no one caredabout it back then.B. Wrestling was not an original Olympic sport.C. Wrestling has undergone many changes since its originalconceptionD. Most people don't consider wrestling a real sport. -1/2x = -4/5Help please Don't be depressed life is too short ok, You may think your heart is nowhere to be found or it is broke or you feel numb well just think of the people around you that love you for you! Nothing else Ok you shouldn't cut because your not paper You should not play with your life it a not a toy ok don't take your life because of your bad times Erase that and start over and surround yourself with love support everything that is positive Do you for only you!! Ok maybe you think No one cares but There will be always 1 person that will care and love and support :D~Kaz Why was Charlotte Perkins Gilman hospitalized Graph.y= 53x4Apparently this is way to short and I have to put in 20 more characters to get a "great" answer *eye roll* sooooooooooo blah blah blah balh there more than 20 Explain the relationship between protons and ionization energy An agricultural extension blank helps farmers and producers stay informed about current practices and technologies. A voltmeter is a device that measures electricity. It can detect the amount of electricity between two electrodes when they are submerged in a solution, such as salt water. Describe how you would find the melting point and the conductivity of the white substances in the beakers. Then, explain how you could identify which substance is salt and which is sugar. 7Frres et seursSay that these brothers and sisters are the opposites of their siblings,Modle:1. Paul et Pierre sont bavards. Et Patricia et Pauline!Charles est paresseux.2. Judith et Claudette sont gnreuses. Et Jean?Et Caroline et Catherine?3. Myriam est intelligente. Et Max et Michel?Caroline et Catherine ne sont4. Fayal est mchant. Et Fatima?pas paresseuses. Elles sont diligentes. 5. Anne-Marie et Ariane sont btes. Et Alexandre!6. Christophe est goiste. Et Christine et Chlo?7. Florence est timide. Et Fred et Fabrice?8. Delphine et Denise sont diligentes. Et Davidet DanielNicolas et Sylvie ne sont pasparesseux. Ils sont diligents. The manager of a fashionable restaurant open Wednesday through Saturday says that the restaurant does about 26 percent of its business on Friday night, 34 percent on Saturday night, and 24 percent on Thursday night. What seasonal relatives would describe this situation? 77 -11 20 points!!!!! What is an action of the highlighted muscle?