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

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

Amaya is a member of a new product design team. The team leader proposed a process that would get quick results, but Amaya was concerned quality would suffer. Due to _______, Amaya did not voice her concern as she did not want to appear unsupportive of the team.

Answers

People often have different suggestions and may or may not agree with each other. Due to groupthink, Amaya did not voice her concern as she did not want to appear unsupportive of the team.

Groupthink is known to be a situation that takes place when a group of individuals arrive at a consensus without critical reasoning or looking into the repercussions or alternatives.

It is often based on a common desire not to anger the balance of a group of people.

It can also be regarded as a psychological phenomenon where individual strive to meet a consensus within a group.

Learn more about Groupthink from

https://brainly.com/question/10206116

The short run average total cost curve reaches it minimum value at an output level greater than that associated with the minimum value of average variable cost because

Answers

Answer:

it includes average fixed cost.

What is political environment in a business? Please help

Answers

Political environment is the state, government and its institutions and legislations and the public and private stakeholders who operate and interact with or influence the system.

What are the dimensions of situational control identified by Fiedler's contingency leadership model? (Check all that apply.)

Answers

There are ways to control different situations. The dimensions of situational control Fiedler's contingency theory are leader-member relations, task structure, and position power.

Fiedler's is popularly known for his contingency theory. This theory helps to understand why managers can behave so differently.

The contingency theory states that there no one single leadership style often works for all employees.

He stated also that there are situational-contingent elements that influences a leader's ability to lead.

Learn more about Fiedler's contingency theory from

https://brainly.com/question/14615424

Describe which fiscal policies of the U.S. Congress would be considered expansionary actions and which would be contractionary actions

Answers

Answer:

Congress acts to cut tax rates or increase government spending, shifting the aggregate demand curve to the right.

Explanation:

Contractionary fiscal policy occurs when Congress raises tax rates or cuts government spending, shifting aggregate demand to the left.

he fastest-growing sales trend is ________ that involves the use of online, mobile, and social media to engage customers, build stronger customer relationships, and augment sales performance. Personal selling Social selling Online selling Teleselling

Answers

Based on business strategy, the fastest-growing sales trend is Social Selling that involves the use of online, mobile, and social media to engage customers, build stronger customer relationships, and augment sales performance.

What is Social Selling?

Social selling is method business firms use to establish one-on-one relationships with their customers as one of the strategies to enhance their sales rates.

Examples of social selling techniquesSharing appropriate contentCommunicating directly with potential consumersPersonal brandingSocial listening, etc.

Hence, in this case, it is concluded that the correct answer is "Social Selling."

Learn more about Social Selling here: https://brainly.com/question/25524075

ARIBA network may not work as a B2C as opposed to B2B,

Answers

It is true to say that the ARIBA network may not function as B2C as opposed to B2B, as ARIBA is a business network focused on Business to Business (B2B) where buyers and suppliers can collaborate.

The advantages of companies participating in the ARIBA network are:

CollaborationOpportunitiesRelationship

Therefore, buyers have the advantages of greater management of the acquisition process and control of expenses, building an effective supply chain.

And suppliers increase cash flow, simplify the sales process and increase customer satisfaction.

Learn more about B2B here:

https://brainly.com/question/24674966

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.

Given a GDP deflator of 120 and a Nominal GDP of 7.8 billion dollars, calculate Real GDP. (1 point)
O 6.5 billion dollars
O 9 billion dollars
09.36 billion dollars
O 6.6 billion dollars

Answers

Answer:

It's 6.5

Explanation:

7.8/(120/100)=6.5

A GDP is calculated as Nominal GDP is divided by the GDP deflator.

The calculation is shown below

$7.8 / $120

=0.065

The answer needs to be multiplied by 100

and therefore

0.065 * 100

= 6.5 billion dollars

The answer is 6.5 billion dollars.

What is GDP?

GDP stands for Gross Domestic Product of a country this represents total monetary value of goods and services produced in a country during a specified period of time.

Learn more about Business - Economy at https://brainly.com/question/5306194

br.uh its like 12:00 am for me.

Answers

Answer:

But for Me its 10:00 AM now

Anyways thnks for points!!!

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:

It is important for the salesperson to pay close attention to the buyer's interests during the need discovery phase to:

Answers

Based on business strategy, the salesperson needs to pay close attention to the buyer's interests during the need discovery phase to "uncover the dominant buying motives."

What is the Need Discovery Phase?

The need discovery phase is when firms or salespeople try to understand the motives of the consumers, their needs, and requirements.

As a salesperson, knowing why the buyer or consumer wants to buy a product will give you an edge to know how to market your products to the consumer.

Hence, in this case, it is concluded that the correct answer is "uncover the dominant buying motives."

Learn more about Need Discovery Phase here: https://brainly.com/question/25571041

Is someone smart here?

Answers

Answer:i think it is A

Explanation: the reason its a is because the maximum would prevent people paying to much for gas

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 !!

A couple is required by their lender to have a down payment of 20% of the purchase price of the home they want to buy. If the couple has saved $35,000, what is the most expensive home the couple can afford to buy? a. $63,000 b. $140,000 c. $175,000 d. $210,000 Please select the best answer from the choices provided A B C D.

Answers

The most expensive home the couple can afford to buy a home is $175,000 having a down payment of 20%.

The computation of the total amount of expenses for home

Given,

The percentage of the down payment from the complete amount of purchase is 20%.

The total amount of saving by the couple is $35,000.

For calculating the maximum amount for buying the most expensive home the total amount of saving is assumed to be equal to the percentage of down payment.

Thus, if $35,000 is equal to 20% of the total amount then what will be the total amount?

This is computed as follows:

[tex]\begin{aligned}\text{Amount}&=\dfrac{\text{Total Savings}}{\text{\% of Down Payment}}\times100\\&=\dfrac{\$35,000}{20}\times100\\&=\$175,000\end{aligned}[/tex]

Therefore, the maximum amount that can be afforded by the couple to buy the most expensive home is $175,000.

Learn more about the down payment, refer to the link:

https://brainly.com/question/1114543

Answer:

Answer is C $175,000 i believe could be wrong

Explanation:

Click this link to view O*NET’s Work Context section for Licensing Examiners and Inspectors. Note that common contexts are listed toward the top, and less common contexts are listed toward the bottom. According to O*NET, what are some common work contexts for Licensing Examiners and Inspectors? Select four options.

in an open vehicle
telephone
face-to-face discussions
wear specialized safety equipment
contact with others
importance of being exact or accurate

Answers

Answer:

A, C, E, F

Explanation:

Answer:

B, C, E, F

Explanation:

reer

The qualitative characteristic of using the same accounting method each period over time refers to the concept of

Answers

I’m not sure try looking it up

StayWell Health Insurance is offering a plan with a monthly premium of $240, a deductible of $6500, and maximum out-of-pocket expenses of $10,000. Which of the following people is that plan BEST suited for? *

Answers

The question is about the StayWell Health Insurance plan.

The plan requires a premium to be paid of $240, for a coverage of upto $10,000. The plan can suit the person that can easily afford $240 per month and is expected to claim the out of pocket expenses of $10,000.

A person who's income is more than $1,000 can be suitable for this Health Insurance plan, A person who's income is less than $1,000 can be reluctant to pay $240 as an insurance premium per month when the person have other expenses for example rent, grocery etc.

Learn more at https://brainly.com/question/25865264

Chad bought a cabin in the mountains for $45,000. He repaired the furnace, redecorated the interior, and repainted the exterior. All of this work totaled just over $7,000. When he tried to resell it, the best offer he got for his cabin was $48,500. Which principle of valuation does this scenario exemplify

Answers

The principle of valuation that the scenario exemplifies is called the principle of contribution.

Data and Calculations:

Cost of cabin = $45,000

Maintenance cost = $7,000

Resale value = $48,500

Shortfall in investment cost = $3,500 ($48,500 - $45,000)

The principle of contribution states that the worth of an improvement is  the market value of the entire property, despite the cost of the improvement. If Chad wanted to make some profit on the sale, he should not incur more maintenance cost than the market is ready to accept.

Thus, the principle of valuation that the scenario exemplifies is called the principle of contribution.

Learn more about the principle of contribution in valuations here: https://brainly.com/question/25818989

Does Nike have any responsibility (of any kind) to the citizens of Indonesia or any country where they operate?
Explain your answer below.

Answers

It should be noted that Nike has responsibilities to the people that are living in any country that they operate. Therefore, the statement is true.

It should be noted they the company's sustainability program and corporate social responsibility aligns with the core beliefs of the company.

Nike has responsibilities to the people that are living in any country that they operate. The company leverages the power of sport in order to promote its agenda about changing the world for the better. The company also engages in various programs that will improve the communities.

Learn more about responsibility on:

https://brainly.com/question/1236273

Which organization, whose launch responded to the emergence of television as the leading medium of advertising, rose to fame in the mid-1950s

Answers

Answer:

The Non-profit Television Bureau for Advertising

Explanation:

The stock in Bowie Enterprises has a beta of .91. The expected return on the market is 12.10 percent and the risk-free rate is 2.97 percent. What is the required return on the company's stock

Answers

Answer:

3 . 9 %

Explanation:

what is the first step in the feedback control system?

Answers

Answer:

The first step in the positive feedback loop is the stimulation that sets off the loop in order to complete a process.

Pete and Mason are shopping for Cheese-its for a class activity. They needed several boxes. Which prices give the better deal.
A. $1.25 per box
B. $5.50 for 3 boxes
c. Buy 1 at regular price ($3.50) and get one at 50% off
D. $2.75 per box and a coupon for $1.00 off

Answers

Answer:

I believe A. $1.25 per box would be the best deal.

Explanation:

This is because A is $1.25 per box,

B. is about $1.83 per box (5.50/3 divided by 3/3 = about 1.83/1)

C. Would be 1 box = $3.50, and the next $1.75 (which is still not less then just $1.25 per box)

and D. would be $2.75-$1 off = $1.75

Out of all of them, A is cheapest/gives the best deal.

Not sure if all calculations are correct, but I hope this helps! :)

Which of the following transactions would decrease cash?

A.Capital investment by the owner

B.Payments to creditors

C.Cash sales

D.Payments received from debtors

Answers

Answer:

B. Payments to creditors

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 :

The growth rate is a measure of the rate at which a countrya's population is increasing. Please select the best answer from the choices provided. T F.

Answers

The growth rate is a measure of the rate at which a country's population is increasing.

The growth rate of a population measures the percentage increase in the value of a quantity.

For example, if the growth rate of a population is 10%, if the town currently has 1000 people, next year population would be: 1000(1.1) = 1100 people.

Factors that leads to increases in a population

Migration Birth

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

Answer:

This is true.

Explanation:

Edg. 2022

Income taxes are taxes that are paid on any financial gain. Purchased goods. Homes, land, or property. Special goods and activities.

Answers

Income taxes are those taxes that are paid on any financial gain.

Income taxes are a progressive type of tax system. Them are taxes that are paid on all forms of income.

This type of tax , taxes those that have more income that those that have lower income.

The government uses the income tax to fund several public services and also use it for the provision of goods to the citizens in the country.

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

Answer:

any financial gain

Explanation:

e2022

A company buys electronic components, assembles them into PCs, and then ships them to customers. In this case the electronic components are _____ for the company.

Answers

Answer:

inputs

Explanation:

inputs are what is brought into the company to help it function. In this case, the inputs are the electronic components.

If this helped, please give brainliest answer! Thanks

Other Questions
what does the root cred mean in the word credulous Whats the best red waterproof lipstick? Need some help :) Find the value of x and the indicated angles. pls help i really need it. how does it feel when your are in a empty field, and what do you see?? sum of 5r and 7, divided by 15 [tex]\sf -4(-4x-5)[/tex] Comunicacin que se utiliza para solicitar informacin o requerir una respuesta del enunciatario. 13 letras termina con oInformacin que el enunciador desea poner en comn con el enunciatario. 7 palabras segunda letra eRepresenta grficamente un resumen. Se emplea cuando se desea organizar la informacin. 15 letras ayuda es un crucigrama Please help! This is due tomorrow! Question 16What is the shortest distance between the line y = 2x+4 and the point at (0.0)? Round to the nearest tenth. O A) 1.8O B) 2.0O C) 3.2O D) 4.0 Write a two-column proof.I WILL GIVE BRAINLIEST TO BEST ANSWER! PLS HELP!refer to images for questionMUST WRITE FULL PROOF Match the vocabulary word with the correct definition,1. coefficienta number, a variable, or the productof a number and variable(s)a letter used to represent anunknown numberThe number in front of a variable in2. constant3. terma terma single term, multiple termsconnected by an addition or subtractionsigna number, a term containing no4. variable5. expressionvariablesTURNITINNEXT QUESTIONREAD NEXT SECTIONASK FOR HELP Write a one page summary of the life of Cornelius Vanderbilt. Plz help brainiest to the correct answer! Question 7 of 10What was an economic effect of World War II?A. Increased consumer goodsB. Increased numbers of working womenC. Decreased wagesD. Decreased employmentSURMIT Lin has a pet German Shepherd that weighs 38 when measured in one unit and 84 when measured in a different unit. which measurement is in pounds, and which is in kilograms? dickens married catherine thompson hogarth in 1836. how many children did they have? What is the one part of a nucleotide that differs among the four different nucleotides in your group?. How would you write 5 times a number Y? Plzzzzz helpmeeeee plzzzzzz A Cars rectangular gas tank has dimensions 30 cm by 25 cm by 42 cm.(a) Calculate the capacity in liters, of the tank.(b) If gasoline cost $154 per liter, what is the cost of filling the tank?