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:
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:
here you go edmentum
Explanation:
Related Questions
Answer ASAP
An entrepreneur wants to start a bakery. He wants to make a sales forecast for his first six months in business, so he obtains the sales records for all the successful bakeries in his state and uses the monthly average for his forecast. What mistake is he making in this process? A. It is impossible to make an accurate sales forecast for a new business, and attempting to do so will only set him up for failure and disappointment. B. He should not use data from bakeries in his own state, as it is unlikely that they will report accurate estimates to their potential competitor C. He should be looking at sales records for all the successful bakeries in the country, not just in his state. D. It is not likely that he will be able to match the sales volume of successful, established bakeries in his first six months.
Answers
The Mistake is he making in this process it is not likely that he will be able to match the sales volume of successful, established bakeries in his first six months. The correct option is D.
What is the importance of sales forecasting?A precise sales forecast enables businesses to efficiently allocate resources for future growth while also managing cash flow. Forecasting sales help create benchmarks for future trends and allow executives to make early course corrections. Revenue executives can optimize for more wins by aligning sales quotas with revenue goals.
Make a list of the products and services you offer. Estimate how much of each you anticipate selling. Define the unit price or monetary worth of each sold good or service. Divide the number of units sold by the price. Determine the cost of producing and selling each commodity or service.
Thus, the ideal selection is option D.
Learn more about sales forecasting here:
https://brainly.com/question/28478878
#SPJ2
Answer:
option d
Explanation:
it is not likely that he will be able to match the sales volume of successful, established bakeries in his first six months
Explain the impact of price and nonprice competition on business.
Answers
Answer: Price Competition:
Exists when marketers complete on the basis of price. In price competition, the marketers develop different price strategies to beat the competition.
They generally set a same or low price of a product than that of the competitors to gain the market share.
Generally, the prices are changed to cover the costs or increase the demand. For instance, Coca-Cola and Pepsi are close competitors, thus, they often engage in price wars. The major disadvantage of price competition is that the competitors have flexibility to change the prices of products.
ii. Non-price Competition:
Explanation:
Select all that apply.
Important résumé formatting includes:
white space
keywords
uniformity
at least 12-point font
Answers
Answer:
White Space
Uniformity
At least 12-point font
(A, C, and D)
Explanation:
I read from the lesson and this is what I got.
Answer:
white space
Explanation:
edg
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
In which year the first school in the whole world was opened?
Answers
Which of the following is NOT an example of a job skill?
A. attending work every day
B. being good with computers
C. being creative
D. working well in groups
Answers
Answer:
attending work everyday
Explanation:
Its not a skill its a priority.
Some examples of a job skill are being good with computers, being creative or working well with a team but attending work every day is not a skill. Therefore a is correct here.
Why do job skills matter?Job skills are important because they are those collections of skills that can help a person to complete a work. There are various kinds of work skills such as workplace skills, technical skills, transferable skills etc.
Workplace skills are those personal skills that ensure that we do our job well, for instance, teamwork. Technical skills are those skills that are required for a specific job such as coding. And transferable skills are those skills which we take from one job to another.
Some of the skills required are communication, change management, professional development, storytelling, planning, influencing, decision-making, problem-solving, and human resources.
Job seekers should always be ready to learn new skills because employers prefer such employees.
Learn more about computers here:
https://brainly.com/question/21080395
#SPJ2
The United States’ central bank, the , holds the account balances of the country’s commercial banks. These are called .
1st drop menu: Federal Reserve, Bank of America, Goldman Sachs, Capitol Federal
2nd drop menu: Deposit Money, Bankers' Deposits, Online Banking
Answers
Answer:
Reserves
Explanation:
The Federal Reserve is the regulator and banker to commercial banks in the US. All commercial banks are required to open and operate an account with the Federal Reserve. The money that commercial banks deposits in their accounts at the federal reserve is known as reserves.
The Federal reserves use the reserves just as the commercial banks make use of customer deposits. 'Bank reserves' is another term that refers to commercial bank deposits.
Prepare the general journal entry (without explanation) needed to close Net Income or Net Loss for the year end. Use compound entries where required. If no entry is required then write "No Entry Required."
Answers
Answer:
Closing entry for closing net profit / net loss for the year ended
Explanation:
In case of net profit, for the year ended closed -Profit & Loss a/c .. dr
to Capital ac
{Reason - As profit has credit balance, so nullifying by debiting it. And, profit increases capital, so capital a/c is credited}
In case of net loss, for the year ended closed -Capital a/c .. dr
to Profit & Loss ac
{Reason - As loss has debit balance, so nullifying by crediting it. And, loss decreases capital, so capital a/c is debited}
A low credit score can lead too?
Answers
Answer:
Dept
you can loose errythang
no loans
Explanation:
[tex]\text{Hello There!}[/tex]
[tex]\text{A low credit score can lead to a number of things, such as:}[/tex]
Low eligibility rates for apartmentsHigh-interest ratesDifficulty applying for credit cards[tex]\text{And many other issues can arise; which is why it's a good idea to have multiple credit cards.}[/tex]
[tex]\rule{300}{0.5}[/tex]
This type of cover letter style does a side by side comparison of an employer’s requirements and an applicant’s experience:
a.
Paragraph letter
b.
T-letter
c.
Bullet letter
d.
S-letter
Answers
Answer:
B
Explanation:
Got it on edge 2020
In which tab can you find features like New Slide, Slide Layout, and Reset Slide?
Answers
Answer:
in a techniol up coming
Choose the term that best matches the description given.
_______detail the activities of the people both inside and outside of the organization.
Answers
Helps measure market success and detail the activities of the people both inside and outside of the organization. Hence, option C is appropriate.
What is the meaning of market?
To make the long-term strategic expenditures more appealing and provide the organization with a future vision, define your market as just a group of individuals and the task they are attempting to do.
A market is a place where buyers and sellers can meet and trade goods and services. Markets can be physical, like a store, or they can be digital, like an online retailer.
Any location where producers, retailers, or distributors sell and customers buy is a market. Websites, main streets, and stores are a few examples. The phrase may also be used to describe all customers who purchase a service or product. Market-based businesses frequently face competition from other businesses.
The entire number of buyers and sellers inside the region or area under consideration is referred to as the "market." The region can be the whole world, a nation, a state, or a city. The value, cost, and price of traded goods depend on the market's supply and demand forces.
Hence, option C is correct.
Learn more about the Market here:
https://brainly.com/question/27155256
#SPJ2
The lead of a screw is the distance that the screw advances in a straight line when the screw is turned 1 complete turn. If a screw is 2 inches long and has a lead of inch, how many complete turns would get it all the way into a piece of wood?
Answers
Answer:
20 turn
Explanation:
CHECK THE COMPLETE QUESTION BELOW
The lead of a screw is the distance that the screw advances in a straight line when the screw is turned 1 complete turn. If the screw is 2 1/2 inches long and has a lead of 1/8 inch, how many complete turns would get it all the way into a piece of wood?
From the question, the screw is 2 1/2 inches long which is the LENGTH , we can convert this to Fraction, which is called an improper fraction, by multiply the denominator (2) by the whole number(2) then add to the numerator (1) all over denominator= [(2×2)+1]/2 = 5/2
The number of turn= Lenght of the screw / lead of the screw
=( 5/2inch)/(1/8inch)
= 5/2 ÷1/8
5/2×8/1
=40/2
=20
Therefore, the complete turns it would get it all the way into a piece of wood is 20 turn
why banks pay lower interest rates on savings accounts than on certificates of deposits.
Answers
Answer:
See below
Explanation:
Savings accounts are more common than certificates of deposits. Banks do not restrict customers on the number of withdrawal and deposits per period in a savings account. Banks consider savings account very liquid because a customer can withdraw their money anytime. Due to this reason, savings accounts attract low-interest rates.
Certificate of deposits, CDs have withdrawal restrictions. In this type of account, the customers agree to keep their money in the bank for a specified period. Banks offer a higher interest rate to encourage customers to keep their money in the account for the agreed duration.
Explain the benefits of international trade
Answers
Answer:International trade allows countries to exchange good and services with the use of money as a medium of exchange. ... Nations with strong international trade have become prosperous and have the power to control the world economy. The global trade can become one of the major contributors to the reduction of poverty.
Explanation:
Select the correct answer from the drop-down menu.
Which option is an example of verbal communication?
A --------- is an example of verbal communication.
smile
letter
handshake
Answers
Answer:
its a .............................letter
Explanation:
A handshake is an example of verbal communication. Thus, option C is correct.
What is verbal communication?Verbal communication is when you or another person speaks out while expressing yourself verbally. However, nonverbal communication is the exchange of information through actions, reactions on the face, and facial expressions.
When you shake hands with someone, you are expressing your warm welcome and full focus. We communicate nonverbally to convey our intentions, identities, beliefs, and various cultural approaches.
Nonverbal communication includes gestures like signaling, winking, hand-shaking, physical separation, and emotions on the face, among others. This is a major change that comes in the way a person is communicating.
Therefore, option C (handshake) is the correct option.
Learn more about verbal communication, here:
https://brainly.com/question/27876354
#SPJ5
3. Chin Lee Florists is opening a new store in the warehouse district of town. The annual rent is $8.75 per
square foot plus 5% of the store's annual gross sales. The store measures 36 feet by 48 feet. Based on
experience, Chin Lee estimates $225,000 in gross sales. What is Chin Lee's estimate of the monthly rent
on this store?
Answers
Answer:
$26,370
Explanation:
The annual rate per square is $8.75
The store measures 36 feet by 48 feet.
In square feet, the store will be
=36 x 48 sq.feet
=1,728 sq.feet
The annual rents will cost
= 1,728 sq.feet x $8.75
=$15,120
5% of the store's annual gross sales is 5/100 x $225,000
=0.05 x 225,000
=$11,250
the total amount that chin will incur
=$15,120 + $11,250
=$26,370
Monitoring the competition is important for all the following reasons EXCEPT
a
to keep prices competitive.
b
a similar décor will attract customers.
c
to match competitors’ promotions.
d
to detect weaknesses in competitors’ promotional strategies.
Answers
Answer: The answer is B
Explanation: Took the test
Answer:
B. a similar décor will attract customers.
Explanation:
Which part, sentence, or phrase in the passage suggests that the respective entrepreneur is a transformational leader? Four best friends from high school—Erwin, Harry, Mick, and Gary—have gone on to become entrepreneurs. They have very different personalities, and thereby, leadership styles. Erwin A(seems to concern himself with the processes rather than forward-thinking ideas.) Harry is B(finicky about minute details, but always gets the job done). C(Mick seeks advice from others and has great concern for his employees). Gary D(rewards effective behavior of his employees, and corrects them when the expectations are not met.)
Answers
Answer:
Garry
Explanation:
Brainliest please! :)
Answer:
(D) "rewards effective behavior of his employees, and corrects them when the expectations are not met."
Explanation:
Which of the following would a recent journalism graduate most likely need to consider before taking a lower-level copyediting job at a major publishing conglomerate?
student loan debt
benefits package
potential for advancement
vacation time available
Answers
Answer:
potential for advancement
Explanation:
Answer:
Potential for advancement
Explanation:
the other three are important for all jobs, but specifically for conglomerates you are going to want to advance and eventually get better positions.
When you work for a conglomerate, each magazine will get its own editors as well as content to publish. But the workers still have to make sure what they put out there regards the policies, sales, and other factors of the company. A downside to conglomerates is that there are a lot of strict procedures and policies to follow to, and sometimes the general environment of one can be difficult. Working for a conglomerate means you should able to work with others, and help people come up with creative plans. You work with other people who are in the same field, and doing the work takes a lot of time and effort. You have to be flexible and creative, be able to communicate, as well as research a lot of things. There are benefits though in terms of being able to move up in your career, and advance through magazines getting good positions. There is also the pay that you get as well.
The sum of 3 fifteens and 4 twos Try to Answer This and U get Brain List
Answers
Answer:
53
Explanation:
first u gotta do 3x15 which is 45 then 4x2 which is 8
then:45+8=53
Answer:
53
Explanation:
15+15+15+2+2+2+2=53
15x3+4x2=53
hope this helps
what is another term that means withholding
A) gross income
B) payroll deductions
C) taxable income
D) allowances
Answers
Answer:
B) payroll deductions
Explanation:
To withhold a payment implies abstaining or avoiding to pay. If an employer withholds some payments, it means that the employee will not receive the withheld amount.
When employers withhold taxes and other deductions, it means the employee will not be given the tax amount. The employer will deduct that amount from the employee pay and forward it to the tax agency. Withholding, in this sense, is payroll deductions.
Which of the following is an example of an action that is part of making a
rational choice?
A. Doing a cost-benefit analysis.
B. Calculating flexible and fixed expenses.
C. Expanding your discretionary spending.
D. Adding up your assets.
Answers
Step by step explanation:
The meaning of rational is doing someone with reason or logic so B seems like the rational answer..
Answer:
A. Doing a cost-benefit analysis.
Explanation:
i took the test
Consumers have certain rights that do NOT carry corresponding responsibilities.
Please select the best answer from the choices provided
T
F
Answers
Answer:
Explanation:Consumers have certain rights that do NOT carry corresponding responsibilities....(false is the answer)How to inflate myself like a balloon
Answers
Answer:
get airget more air There you go :)get even more air I'll see you in the moon :0drink the air
The amount of money that you are able to charge to a credit card. If you exceed this limit, your purchase may not go through and you could be penalized.
Answers
Answer:
isnt that called your credit limit?
Explanation:
Choosing to go to college over getting a job right out of high school is an example of a(n) _____.
fixed cost
opportunity cost
variable cost
none of the above
Answers
8. You just got paid and want to treat your friends to lunch at Sammy's Steakhouse . You have $ 850.00 in your account . The bill ends up being \$50.2 . How much is left in your account after you use your debit card to pay?
Answers
Answer:
is it C cause that makes sense
Which of the following would be typically added to the Adjustments column
on a worksheet?
A. Depreciation
B. Supplies
C. Cash
D. Utilities
Answers
Depreciation would be typically added to the Adjustments' column on a worksheet. Hence, option A is correct.
What is meant by Depreciation?
A tangible item's cost can be spread out over the period of its useful life using the accounting approach of depreciation. Depreciation indicates how much of an asset's worth has been expended.
It makes it possible for companies to buy assets over a predetermined period of time and profit from those assets. Depreciation is the process of taking the whole cost of an expensive item you bought for your business out of consideration.
But rather than finishing it all in one tax year, you write off parts of it over time. You have more control over your budget when you depreciate assets since you can plan out how much money is written off each year.
Thus, option A is correct.
For more details about Depreciation, click here:
https://brainly.com/question/15085226
#SPJ5
According to the video, in which areas are Accountants and Auditors involved? Check all that apply.
budgeting
hiring
training
planning
cost control
employee compensation
event planning
Answers
Answer:
1, 4, 5, 6
Explanation:
Just did the assignment.
