1. Read the following data regarding payroll deductions, and answer the questions that follow:

Lydia: $9.50/hour, worked 20 hours this pay period

Thomas: $12.50/hour, worked 40 hours this pay period

Bruce: $8.50/hour, worked 30 hours this pay period

a. Using a spreadsheet program, create a payroll spreadsheet with the information above. Be sure to include proper headings.

b. Add a “Tax (%)” column. Apply a nested IF statement to the spreadsheet to determine the percentage of taxes that needs to be deducted. For someone who makes $9.00 or less an hour, the is 5%. For someone who makes between $9.01 and $12.00 an hour, the rate is 6%. For someone who makes more than $12.01 an hour, the is 7%.

c. Describe hour you generated this column.

Answers

Answer 1

The hours generated are:

Lydia - 20Thomas - 40Bruce - 30

The Net Amount Payable are:

Lydia - $176.70Thomas - $465.00Bruce - $237.15

What is a Nested IF THEN ELSE Statement

This is a function/formula within Microsoft Excel Spreadsheet that allows one to carry out conditional calculations such as the one explained in the question. Please see the attached spreadsheet.

Learn more about formulas in spreadsheets in the link below:

https://brainly.com/question/25879801


Related Questions

Kevin works for a company which produces printers. A printer sells for $163. 95 and costs $48. 28 to produce. In one month, Kevin’s company sold 427 printers, earning a profit of 22,599. 9. How great were the company’s non-production overhead expenses, to the nearest dollar? a. $13,410 b. $20,616 c. $24,809 d. $26,792.

Answers

The company's non-production overhead expenses is  $26,792.

The first step is to determine the net profit from selling the printers.

Profit = (selling price - cost price) x number of printers sold

(163.95 - $48.28) x 427

= 115.67 x 427

= $49,391.09

The second cost is to determine the difference between the profit calculated above and the profit given in the question:

$49,391.09 - 22,599. 9 = $26,792

To learn more, please check: https://brainly.com/question/16344365

typical capital budgeting decisions include ______ decisions.

Answers

The answer is because

Typical capital budgeting decisions include equipment selection, cost reduction, and lease or buy decisions.

What is budgeting?

The process of making a spending plan is known as budgeting. Budget refers to this plan for spending money. Making this stimulus package enables you to estimate your financial situation in advance and decide whether we had enough resources to accomplish your goals. Simply adjusting your income and expenditures constitutes budgeting.

The procedure is examining the cash flows into and out of a project to ascertain whether the anticipated return reaches a predetermined standard. Net present value, payoff, and transit assessments are three of the main budgeting techniques. The economic viability of a capital spending can be ascertained using a number of budgetary control analysis techniques.

Learn more about budgeting, Here:

https://brainly.com/question/15683430

#SPJ12

Becca has $500 to open a checking account. She wants an account with the lowest fees. She writes about 12 checks per month and her employer has direct deposit. She plans to only use her bank's ATM four times a month. Bank Account Terms and Conditions Bank Account terms and conditions. Bank B is best for Becca. Which checking account would be best for Becca? Account A Account B Account C Account D.

Answers

People often have different types of account. The checking account that would be best for Becca is Account B

A checking account is known to be a type of bank account that gives room for customers to male quick and easy deposit and withdrawal of their money for daily transactions.

It often includes depositing a check that a person receive, taking out cash with your debit card or setting up direct deposit for your paychecks.

Looking at the Account B in the picture attached you will see that the option be is the best for Becca.

Learn more from

https://brainly.com/question/11863374

Answer:

Account B

Explanation:

pro verified this trust

Employers will be evaluating your attitude and communication skills during an interview. Please select the best answer from the choices provided T F.

Answers

It is true that the employers will be evaluating the attitude and communication skills of the job applicant during an interview

Basically, an interview is conducted by the recruiting firm to assess the various skills, behavior of the job applicant.

The communication skills, qualifications, attitude, tone, cultures, norms are all assessed, even though the applicant might be unaware of them.

In conclusion, it is true that the employers will be evaluating the attitude and communication skills of the job applicant during an interview.

Learn more about Job interview:

brainly.com/question/14082634

Answer:

True

Explanation:

Employers will be evaluating your attitude and communication skills during n interview.

Edg 2022

What is a line extension?

Answers

search it up and find the answer

A wholesale lending arrangement that permits a mortgage broker to originate, close, and fund a loan using a warehouse line of credit is called:

Answers

Answer:

table funding

Explanation:

Which form of media advertising has seen the sharpest decline in the United States over the last 15 years

Answers

The form of media advertising that has seen the sharpest decline in the United States over the last 15 years is the Newspaper.

The Newspaper used to be very common in the past. It was the most common means of reaching the bigger audience. Apart from its use as a medium of carrying the happenings in the society, it also served as a means of advertising.

The decline in the use of the Newspaper today is partly due to the riser in the use of electronic media. People have moved on past the age of Newspaper. Most topics are now discussed electronically especially through the social media.

Read more on https://brainly.com/question/23380864?referrer=searchResults

You see an ad for a payday lender which ends with the tagline, “One payday loan is all it takes to get you back on track.” Does the data above support their advertising claim?

Answers

You see an ad for a payday lender which ends with the tagline, “One payday loan is all it takes to get you back on track.” Does the data above support their advertising claim? No, it does not support their advertising claim.

1. Which of the following is INCORRECT?
Assets
Liabilities
Capital
$
$
$
i
ü.
18,270
9,340
15,160
12,230
5,290
3,120
6,380
1,390
12,980
6,220
7,780
10,840
111.
iv.

Answers

Answer:

HINDI KO PO GETPASYENSYA NA POKUNG SAAN UMAASA KAYO SASAGOT KO.

Discuss the value of technology in business

Answers

Answer:

technology has helped business in many ways from it making it easier to shop via the internet and also for the businesses to start putting more and better advertisements then what they were doing before, technology has also made it easier to create the products as well as examine them for flaws.

Explanation:

Look at the chart below.

Potential Career Paths
Skills Education Column 3 Job growth
Job 1 Extroverted, communicator Certification Work from home 0 percent
Job 2 Analytical, solution-oriented B.A. + License Office 11 percent
Job 3 Artistic, focused M.A. Outdoors 9 percent
Job 4 Curious, ambitious Ph.D. Traveling/Field 25 percent
If you want to feel comfortable that there will be job openings available, which field is the biggest risk for you?

job 2
job 4
job 3
job 1

Answers

Answer:
Job 4

Explanation:

Job 4 best suits the job description of health and safety engineer. It is important for a health and safety officer that he must be ambitious and dur to nature of the job he has to travel across different fields. Health and safety officer has great responsibility as he is the one who is responsible for implementing safe work environment.

3. The study of economics is best described as a study of...
A. the factors that influence the stock and bond markets.
B. capitalism.
C. the choices made in producing goods and services.
D. coping with scarcity, and choices made as a result of scarcity in a society.

Answers

Answer:

Option D

Explanation:

The study of economics which can be best described as the understanding of coping with scarcity.It can be also defined as the choices which affect the result of scarcity in a common society

D. coping with scarcity, and choices made as a result of scarcity in a society.

EconomicsEconomics is a social science that studies how products and services are produced, distributed, and consumed. It investigates how individuals, businesses, governments, and nations make resource allocation decisions.The study of economics is best described as a study of D. coping with scarcity, and choices made as a result of scarcity in a society.

For more information:

https://brainly.com/question/17408105?referrer=searchResults

how long will the increase in food stamps last in alabama 2021

Answers

Based on the latest information released by the Alabama government, the increase in food stamps would last in 2021, "when the target of 500,000 children has been met."

Food Stamps in Alabama 2021

As a result of the coronavirus pandemic, the state government of Alabama, like many other states government in the United States, is giving out food stamps to people.

However, the rolling out of these current food stamps will last until after the target has been met, which is "500,000 children."

The food stamps benefit totaled $180 million.

Hence, in this case, it is concluded that the correct answer is "when the target of 500,000 children has been met."

Learn more about Food Stamps here: https://brainly.com/question/25560685

The ability to self-book one’s travel is one of the benefits of online travel companies.
True or False

Answers

Answer:

yes

Explanation:

What is working capital?

Answers

Answer:

Working capital, also called net working capital (NWC), represents the difference between a company’s current assets and current liabilities.

NWC is a measure of a company’s liquidity and short-term financial health.

A company has negative NWC if its ratio of current assets to liabilities is less than one.

Positive NWC indicates that a company can fund its current operations and invest in future activities and growth.

High NWC isn’t always a good thing. It might indicate that the business has too much inventory or is not investing its excess cash.

Explanation:

can you me as brainliest if its right? i just need a few more to rank up! ^-^

Also have a great day and good luck in your studies!

answer:

the capital of a business which is used in it day-to-day trading operation, calculated as the current assets minus the current liabilities

56. How do most states finance their capital budget?
a. sales or excise taxes
b. long-term borrowing or sale of bonds
c. income and property taxes
d. personal property or inheritance taxes

Answers

Long term borrowing!!
B long term borrowing or sale of bonds !!

what is the first thing you should do when you open an account

Answers

Answer : consider how much money you will add in your account and start saving up money

Explanation :

Company Z understands that their business is at risk. How can they use step two in the
Decision Making Process to reach their end goal of increasing sales and customer satisfaction?

Answers

Company Z can use step two in the decision-making process to achieve its ultimate goal of increasing sales and customer satisfaction by gathering the relevant information about a decision.

Step two of the decision-making process corresponds to gathering relevant information after the decision has been identified. At this stage, internal and external work is necessary, analyzing the errors and successes related to a past decision.

Therefore, it is necessary for company Z to seek information from different sources, such as the results of previous decisions, studies, market research and consultancy, to ensure greater chances of a decision being effective.

Learn more about decision making here:

https://brainly.com/question/1249089

One way a local community might regulate a shared and limited resource and reduce the tragedy of the commons is to:

Answers

Division of the resources into parcels as well as assigning them to individuals serves as a way that local community usually follow in regulations of shared as well limited resource.

limited resource serves as term used to describe that the quantities of available labor as well as  capital, land are finite.

In order to regulate these resources, the local community can divide the resources into parcel so it will be able to easy for allocation.

Another way is to assign this resources to individual one after the other.

Therefore, Division of the resources into parcels  one way to share the resources.

Learn more:

https://brainly.com/question/24371554

Indicate whether each of the following is used in the calculation of the official poverty measure, the Supplemental Poverty Measure, or both. (2 points)
Official Poverty Measure
Supplemental Poverty Measure
Both
food costs
O
O
housing costs
o
O
o
utilities costs
o
O
о о
clothing costs
O
O

Answers

The Official Poverty Measure is used to estimate numbers of people unable to afford basic needs with little or no government assistance

The Supplemental Poverty Measure is used to measure the economic deprivation, that is, people having insufficient financial resources to achieve a specified standard of living.

The official poverty measure is based on cash resources while the Supplemental Poverty Measure is based on both cash and noncash benefits and subtracts necessary expenses.

The cost including food costs, housing costs, utilities costs and clothing costs are elements used in calculation of the Official poverty measure and Supplemental Poverty Measure.

Read more about Poverty measures:

brainly.com/question/3360099

Answer:

Clothing Costs: Supplemental Poverty Measure
Food costs: Both
Housing costs: Supplemental Poverty Measure
Ultilities cost: Supplemental Poverty Measure

Explanation:
I litterally made a brainly account just to give this answer you best believe its right

Match the terms.

a. Initial Markup
b. Additional Markup
c. Markup cancellation
d. Markdown
e. Markdown cancellation

1. original amount of markup from cost to selling price
2. Increase in selling price subsequent to initial markup
3. Elimination of an additional markup.
4. Reduction in selling price below the original selling price
5. Elimination of a markdown

Answers

I could be completely wrong here but I believe just by breaking down the terms and some common sense... I THINK the answers match up. like a1, b2, c3, d4, e5. If I'm wrong I'm so sorry! But if i'm right I'd love a Brainliest...

Can some people give me free adopt me pets? Just put in your user and I'll add u

Answers

Answer:

U can have my fly ride neon unicorn

Explanation:

From a macroeconomic point of view, increases in ____________ are an addition to aggregate demand, while increases in ___________ are a subtraction from aggregate demand.

Answers

There are different factors that causes changes in demands. An increases in exports are an addition to aggregate demand, while increases in imports are a subtraction from aggregate demand.

When there is an increase in a country's exchange rate increases, note that the net exports will reduce and aggregate expenditure will reduce too at all price level. This therefore implies that Aggregate demand will decrease.

An increase in the exchange rate will decrease aggregate demand when demand is known to be relatively elastic. This is due to exports falling and imports increasing.

An effect of an exchange rate shift is to alter the prices of goods and services produced in a country.

Learn more about Aggregate demand from

https://brainly.com/question/1490249

If Kevin is currently insured under Leroux for his medical insurance under Plan A, how will the proposed changes affect his health care costs? a. Costs for regularly scheduled health care will go down, but Kevin may end up paying more if he finds himself seriously ill or injured. B. Costs for regularly scheduled health care will go up, but Kevin will probably pay less than he would have if he finds himself seriously ill or injured. C. Both the cost for regularly scheduled health care and the cost for emergency health care will go down, making the changes very good for Kevin. D. Both the cost for regularly scheduled health care and the cost for emergency health care would go up, contradicting the intentions of Leroux Insurance.

Answers

Considering the case, of Kelvin, if he currently insured under Leroux for his medical insurance under Plan A, then, Costs for regularly scheduled health care will go down, but Kevin may end up paying more if he finds himself seriously ill or injured.

What is health insurance?

Health insurance can be regarded as the type of insurance that cover hospital visits as well as prescription drugs and wellness care.

Most health insurance do cover some other range of services such as cosmetic procedures and beauty treatments.

Since, Kelvin is currently insured under Leroux, then Costs for regularly scheduled health care will go down.

Learn more about health insurance at:

https://brainly.com/question/1941778

Answer:

A!!!!!!!

Explanation:

Just believe me I got this

4. Economists measure opportunity cost
A. only when it is on the margin.
B. as the best thing given up.
C. as the sum of all forgone opportunities.
D. as the same as marginal benefit.

Answers

Answer:

Option A is the correct answer.

When a special assessment is calculated, each parcel of real estate that will benefit from the improvement is

Answers

A special assessment is a charge for a public improvement that will provide a benefit to a real estate parcel. State law permits the use of special assessments to recoup the costs of a variety of City services. All revenues collected through an assessment can only be used on expenditures directly related to the public improvement.

The President of PDQ Corporation buys PDQ shares in the open market. After holding them for 3 months fully paid, the President wishes to sell the shares. The shares can be sold:

Answers

There are different ways to share shares. The shares can be sold immediately.

In a sale of shares, a company's shareholders often sell the shares that is entitling ownership of the company to a specific buyer. In the transaction, all the rights and responsibilities that pertains to the ownership of shares are transferred to the buyer.

Note that as long as the 6-month holding period needed has fulfilled on the restricted shares, and therefore, when they are donated, the charity can sell the shares immediately. There is therefore no need for another 6-month holding period be taken again.

See full question below

The President of PDQ Corporation buys PDQ shares in the open market. After holding them for 3 months fully paid, the President wishes to sell the shares. The shares can be sold:

A. immediately

B. after holding the securities for an additional 3 months

C. after holding the securities for an additional 6 months

D. after holding the securities for an additional 1 year

Learn more about Shares from

https://brainly.com/question/25818989

Which technique is used to improve customer relationship management (CRM) systems by identifying, storing, and disseminating facts about how to perform tasks

Answers

Knowledge management is the technique that is used to improve customer relationship by storing and disseminating facts.

Knowledge management can be described as the use of different techniques to create and share knowledge in an organization.

It is a multiple approach way that organizations use to attain their objectives through the best use of knowledge.

It is very important to the organization because it helps to:

Increase efficiencyRaise productivityKeep critical information in  the organization.

Read more on customer relationship management: https://brainly.com/question/25656282?referrer=searchResults

If the dollar amount of total return on your mutual fund is $165 and the original cost of your investment is $1,200, then what is your percentage of total return

Answers

Answer:

% 70

Explanation:

Explain how market research is different than marketing.

Answers

Answer:

Although both involve consumers, Marketing research is concerned specifically about marketing processes, such as advertising effectiveness and salesforce effectiveness, while market research is concerned specifically with markets and distribution.

Explanation:

Other Questions
In one year, a government collected $6770 per person in taxes. If the population was 220,000,000, how much did the government collect in taxes that year? Which of the following is written correctly?Select one:The grocery store was out of raisins; Cynthia had to use something else.The national park was closed; A tornado had damaged a large portion of it.Frances won the local bike race; and took home the biggest trophy.Sydneys painting earned an honorable mention; which motivated Sydney to make a larger painting. What point of view does Emily Bront use in this excerpt from the novel Wuthering Heights?In all England, I do not believe that I could have fixed on a situation so completely removed from the stir of society. A perfect misanthropists heaven: and Mr. Heathcliff and I are such a suitable pair to divide the desolation between us. A capital fellow! He little imagined how my heart warmed towards him when I beheld his black eyes withdraw so suspiciously under their brows, as I rode up, and when his fingers sheltered themselves, with a jealous resolution, still further in his waistcoat, as I announced my name.A. first-person point of viewB. second-person point of viewC. third-person limited point of viewD. third-person omniscient point of view Morales Corporation produces microwave ovens. The following per unit cost information is available: direct materials $30, direct labor $20, variable manufacturing overhead $16, fixed manufacturing overhead $42, variable selling and administrative expenses $18, and fixed selling and administrative expenses $24. Its desired ROI per unit is $27.00. Compute its markup percentage using a total-cost approach. (Round answer to 2 decimal places, e.g. 10.50%.) The length of a rectangle is 10 feet longer than it is wide. If each side is increased 10 feet, then the area is multiplied by 2. What was the size of the original rectangle? which of the following one is true Find the value of x. PLEASE HELP ASAP!A.4B. 16. 5D. 12 Tests of controls in an advanced computer system Can be performed using actual transactions or simulated transactions. Can be performed using only actual transactions because testing of simulated transactions is of no consequence. Is inadvisable because they may distort the evidence in master files. Is impracticable because many procedures within the computer processing activity leave no visible evidence of having been performed. The graph of a line is shown below. What is the equation of the line, in slope-intercept form, that is parallel to this line and has a y-intercept of 1? What is the equation of the following line? Be sure to scroll down first to see all answer options. A. y = 18x B. y = 9x C. y = -9x D. y = - x E. y = -18x F. y = x a. Download the attached Greetings.java file.b. Implement the getGreetings method, so that the code prompts the user to enter the first name, the last name, and year of birth, then it returns a greetings message in proper format (see the example below). The main method will then print it out. Here is an example dialogue with the user:Please enter your first name: tomPlease enter your last name: cruisePlease enter your year of birth: 1962Greetings, T. Cruise! You are about 50 years old.Note that the greetings message need to be in the exact format as shown above (for example, use the initial of the first name and the first letter of the last name with capitalization).c. Submit the final Greetings.java file (DO NOT change the file name) online. Answer problem below A place where animals are protected in their natural habitat is called ------------------ find the value of trigonometric ratio HURRY! HELP PLSJanelle is conducting an experiment to determine whether a new medication is effective in reducing sneezing she finds 1000 volunteers with sneezing issues and divides them into two groups the control group does not receive any medication the treatment group received the medication the patients in the treatment group show reduced signs of sneezing what can genetic include from this experiment? Give four examples illustrating each of the following terms. a. homogeneous mixture b. heterogeneous mixture c. compound e. physical change d. element f. chemical change what is the meaning of "under a lot of pressure" slang expression gdp bnh qun l g ? In ________ organizational cultures, more individuality is shown through the organizations rules being less strictly applied. The graph shows the distribution of lengths of songs (in seconds). The distribution is approximately Normal, with a mean of 227 seconds and a standard deviation of 31 seconds.A graph titled Song length has length (seconds) on the x-axis, going from 103 to 351 in increments of 31. The highest point of the curve is at 227.What percentage of songs have lengths that are within 31 seconds of the mean?34%68%95%99.7%