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

Match the phrase that follows with the term (a-e) it describes. integrated set of operating and financing budgets for a period of time estimates the number of units to be manufactured to meet sales and inventory levels shows expected results at several activity levels begins by estimating the quantity of sales shows expected results at only one activity level 1. static budget 2. flexible budget 3. master budget 4. sales budget 5. production budget

Answers

1. Master budget: it is an integrated set of operating and financing budgets for a period of time.

2. Production budget: it estimates the number of units to be manufactured to meet sales and inventory levels.

3. Flexible budget: it shows expected results at several activity levels.

4. Sales budget: it begins by estimating the quantity of sales.

5. Static budget: it shows expected results at only one activity level.

A budget can be defined as a financial plan that is used for the estimation of revenue and expenditures of an individual, organization or government, especially for a specified period of time, often one (1) year.  

Basically, there are different types of budget and this include:

1. Master budget: it comprises an integrated set of both investing, operating and financing budgets for a specified period of time, often one (1) year.

2. Production budget: it estimates the number of units to be manufactured by a business firm, so as to meet budgeted sales and inventory levels.

3. Flexible budget: it shows expected results of a business firm (responsibility center) at several activity levels.

It is also referred to as variable budget and it's used both before and after a period's activities are completed.

4. Sales budget: it begins by estimating the quantity of sales.

Once the quantity of sales are estimated, the sales revenue that are expected is calculated by multiplying the expected unit sales price by the volume.

5. Static budget: it shows expected results of a business firm (responsibility center) at only one activity level.

A static budget is usually based on a predicted amount of sales or any other measure of activity.

Read more on budget here: https://brainly.com/question/8976831

What includes the increasingly complex management of processes, information, and communication to take a product from cradle to grave

Answers

The increasingly complex management of processes, information, and communication to take a product from cradle to grave refers to Logistics.

What is Logistics?

Logistics can be described in the most simple of ways, as the planning and management of a series of factors in order to achieve the end goal of a product. Logistics involves a series of complex processes required to oversee the proper flow of a product from its origin to its consumption by the public.This is important in order to ensure adherence to norms and regulations and allow for an efficient and detailed process of production.

Therefore, we can confirm that when stating the increasingly complex management of processes, information, and communication to take a product from cradle to grave, we are referring to Logistics.

To learn more about Logistics visit:

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

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:

1. The fundamental problem of economics is:
A. to establish an equitable system of personal and business taxation.
B. to establish a democratic political framework for the provision of social goods and services.
C. the scarcity of factors of production relative to the unlimited wants of humans.
D. to achieve a more equitable distribution of money income in order to mitigate poverty.

Answers

Answer:

I think C is the correct answer.

What is a product mix ?

Answers

Full set of products

When a seller allows a buyer thirty to sixty days to pay for a purchase, the sales arrangement is called a. a promissory note. b. equity financing. c. trade credit. d. a bank loan. e. None of these answers is correct.

Answers

The sales arrangement when a seller allows a buyer thirty to sixty days to pay for a purchase is known as Trade credit

A trade credit is an arrangement that exists between buyers and sellers with respect to exchange of goods and services.

In trade credit, the supplier allows the buyer purchase on credit and pay later usually between 30, 60 or 90 days.

Hence, trade credit is where a seller allows a buyer thirty to sixty days to pay for a purchase.

Learn more about trade credit in this link : https://brainly.com/question/7575180

which is a good synonym for the word barter in the term barter economy?

Answers

It should be noted that a good synonym that can be used for the word barter in a barter economy is trade.

A barter economy simply means a cashless economy where a good and services are traded at negotiated rates.

It should be noted that barter systems are known as one of the earliest forms of trade. Therefore, a synonym that can be used for the word barter in a barter economy is trade.

Learn more about barter on:

https://brainly.com/question/490817

Conciliation differs from arbitration in that:________.
a. the conciliator is a neutral third party.
b. the conciliator's goal is to provide a solution to the dispute.
c. the conciliator's solution is legally binding on both the union and management.
d. the conciliator is a member of the union or of management.
e. the conciliator has no formal power over union representatives or management.

Answers

Answer:

I think answer is a.the concilliator is a neutral third party

A project's break-even occupancy level is determined by: _______________

a. adding vacancy and rent loss allowances to the net operating income, and dividing by the operating expenses.
b. subtracting debt service from the before-tax cash flow, and dividing by net operating income.
c. adding the operating expenses to the debt service, and dividing by the gross potential revenue.
d. subtracting operating expenses from effective gross income, and dividing by the operating expense ratio.

Answers

Answer:

a. adding vacancy and rent loss allowances to the net operating income, and dividing by the operating expenses.

Kane manages a used bookstore. He reads a report advising him to stock
more encyclopedias. However, the report is mistaken; customers in Kane's
town hardly ever buy encyclopedias. What problem could this mistake cause?
A. The report could be difficult for Kane to understand.
O B. The bookstore could run out of inventory.
C. The bookstore's reputation could be damaged.
D. The bookstore could lose money if customers buy less than
expected.
SBSM

Answers

Answer:

I would say that the answer is D. If he knows that people don't buy encyclopedia's, yet he stocks them, the store could lose money because no one would buy it.

Explanation:

Hope this helps. :D

The bookstore could lose money if customers buy less than expected, is the problem Kane would face by this mistake. Thus, option D is correct.

What is encyclopedia?

Throughout its lengthy history, the definition of the word "encyclopedia" has undergone significant alteration. Most people today imagine an encyclopedia to be a multivolume compilation of all knowledge, complete with maps, a thorough index, and a variety of ancillary materials like bibliographies, illustrations, lists of abbreviations and foreign words, gazetteers, etc.

They assume that it will contain biographies of important people from the past and the present, and that the alphabetically arranged contents will have been written in their own language by a large number of people and edited by a highly qualified and scholarly staff; however, none of these components have remained constant over time.

Therefore, we can conclude that option D is correct.

Learn more about encyclopedia here:

https://brainly.com/question/16220802

#SPJ5

Which term accurately describes Melanie, who was born in the United States and is currently working in Italy for a company headquartered in China

Answers

A third-country national serves as term that is utilized in description of Melanie, that is been given birth to, in the United States but Working in another country like China.

What is third-country national?

This serves as term to describe an individual that is doesn't belong to a citizen of a country such as United States but is is been assigned a duty.

People do this so as to get better opportunity in their career.

Learn more at;

https://brainly.com/question/21846520

For the last 20 years, Terry has made regular quarterly payments in the amount of $308 into an account paying 1. 5% compounded quarterly. If, at the end of the 20 year period, Terry stops making deposits, transfers the balance to an account paying 5. 5% interest compounded annually, and withdraws a annual salary from the account, determine the amount that he will receive every year for 10 years. Round to the nearest cent. A. $28,672. 88 b. $3,803. 97 c. $28,780. 40 d. $3,074. 66.

Answers

The amount that will be received by Terry at the end of every year for 10 years is $3,803.97

Computations:

1. First the future value will be computed:

Given,

[tex]A[/tex] =$308, Annuity or the quarterly payment amount.

[tex]r[/tex] =1.5%, the rate of interest to be paid quarterly; thus the effective rate of interest will be: 0.375% [tex](\frac{1.5\%}{4})[/tex]

[tex]n[/tex] = 20 years, number of periodic payments, but the effective time period for the computation will be 80 payments that are: [tex](20\times4(\text{quarter}))[/tex]

[tex]\begin{aligned}\text{Future Value}&=\dfrac{A\times(1+r)^n-1}{r}\\&=\dfrac{\$308\times(1+0.00375)^{80}-1}{0.00375}\\&=\$28,672.88\end{aligned}[/tex]

2. From the determined future value that will be used in the present value formula, where 5.5% interest compounded at which Terry will receive an amount for every 10 years will be computed.

Given,

Present value =$28,672.88

[tex]r[/tex] =5.5%, the coumpounded rate of interest

[tex]n[/tex] =10 years

[tex]\begin{aligned}\text{Present Value}&=\dfrac{A(1+r)^n-1}{r(1+r)^n}\\\$28,672.88&=\dfrac{A(1+0.055)^{10}-1}{0.055(1+0.055)^{10}}\\A&=\dfrac{7.537}{\$28,672.88}\\A&=\$3,803.97\end{aligned}[/tex]

Therefore, after the payment of $308 for 20 years, Terry will start receiving the amount of $3,803.97 every 10 years.

To know more about the future value and present value, refer to the link:

https://brainly.com/question/14799840

Integrated Marketing Communication involves coordinating only paid personal communications. True False

Answers

it is false that Integrated Marketing Communication involves coordinating only paid personal communications because it involves paid and non-paid personal communications.

A paid personal communications entails the communication channel which requires payment such as advertisement.

An Integrated Marketing Communication entails integrated marketing elements which helps to communicate with the customers.

The element of Integrated Marketing Communication includes:

public relationssocial mediaaudience analyticsadvertising etc

In conclusion, it is false that Integrated Marketing Communication involves coordinating only paid personal communications because it involves paid and non-paid personal communications.

Read more about Integrated Marketing Communication

brainly.com/question/9696745

Consider the different steps of the Waterfall and Agile project management approaches and consider the benefits of each one. Then, reflect on a project that you recently completed. Write 5-10 sentences on which approach you would use choose if you were starting it from scratch, and why. ​

Answers

The waterfall project management approach aims to make the project flow continuous through the phases:

Requirements analysisProjectImplementationIntegrationVerificationMaintenance

In the Agile approach, there are four fundamental principles for creating value, which are:

Individuals and interaction about processes and tools.Job software with comprehensive documentation.Customer collaboration in contract negotiation.Responding to change by following a plan.

The benefits of each of these management approaches are to generate value in the internal and external environment, through greater adaptation to rapid social, economic and technological demands, and through the improvement of quality.

Find out more information about agile approach here:

https://brainly.com/question/25734045

What phrase could a licensee use in advertising that would not discriminate on the basis of familial status

Answers

Senior discount is the phrase that a licensee could use in advertising that would not discriminate.

A familial status discrimination is known to occurs when the landlord, manager  or property owner treats someone very differently.

The other options clearly discriminate the familial status.

Hence, the Senior discount is the phrase that a licensee could use in advertising that would not discriminate.

Therefore, the Option is correct.

Missing options "Couples only Empty nesters No bicycles allowed Senior discount"

Read more about Discount

brainly.com/question/912869

Put the following items in order from most expensive to least expensive. Item Base Price Change Direction Toaster $23. 35 36% Markup DVD $20. 36 66% Markup Headphones $69. 09 56% Markdown Jeans $55. 08 41% Markdown a. Headphones, jeans. Toaster, DVD b. Headphones, DVD, toaster, jeans c. DVD, toaster, headphones, jeans d. DVD, jeans, toaster, headphones.

Answers

The items arranged from most expensive to least expensive is  DVD, jeans, toaster, headphones.

A mark up increases the price of an item while a mark down reduces the price of an item.

Price after a mark up = (1 + mark up) x base price

Price after a mark down = (1 - mark down) x base price

Price of the toaster after the mark up: (1.36 x $23.35 = $31.76

Price of the DVD after the mark up: 1.66 x $20.36 = $33.80

Price of the head phones after the mark down: (0.44 x $69.09 = $30.40

Price of the jeans after the mark down: 0.59 x $55 = $32.45

A similar question was solved here: https://brainly.com/question/25717996

The answer is:D. DVD, jeans, toaster, headphones.

A chicken farmer can produce one crate of eggs at a cost of $9. 86, and can sell that crate for $34. 24. If the farmer has a starting overhead cost of $7,312, not including production costs, how many crates must be sold in order to realize a profit of $11,300, to the nearest crate? a. 164 b. 330 c. 463 d. 763.

Answers

Based on the equation used, the number of crates that must be sold in order to realize the profit is 763 crates.

Let the number of crates be represented by x.

Based on the information given, the equation to solve the question will be:

(34.24 × x) - (7312 + 9.86x) = 11300

34.24x - 7312 - 9.86x = 11300

34.24x - 9.86x = 11300 + 7312

24.38x = 18612

x = 18612 / 24.38

x = 763

Learn more about equation on:

https://brainly.com/question/24691073

If a product is considered a bundle of attributes, what would be two attributes of a tube of toothpaste

Answers

If a product is considered a bundle of attributes, the two attributes of a tube of toothpaste will be: Weighs 10 grams and is Water resistant.

A product is considered a bundle of attributes that could be tangible or not.

In describing the product attributes of a toothpaste tube, we could reference the fact that it is lightweight and is resistant to water.

These attributes are the features that make the product attractive to consumers.

Learn more about product attributes here:

https://brainly.com/question/14563539

Answer: Flavor of toothpaste & Size of container

Explanation:

The correct answer for smartbook.

Betsy loves to garden, and her rose garden is enjoyed by everyone in her neighborhood. Because her consumption of rosebushes provides a positive externality to the community, the government should _____ because the market quantity of rosebushes is _____ than the socially optimal quantity.

Answers

Answer:

Provide a Subsidy; Lower

Explanation:

Suppose that a steel manufacturer headquartered in Japan sets up a subsidiary in Canada to produce steel. This practice is referred to as:

Answers

Hi! The answer would be “Horizontal integration”

Large banks who take excess risk because they believe they will be bailed out by the government if they go bankrupt are often known as

Answers

Answer:

Too Big to Fail

Explanation:

If this helped, please give Brainliest Answer! Thanks!

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

Brenda, a job applicant at Trade Winds Corp., discovers that the job she is applying for requires her to be a union member before being hired. She also learns that this arrangement is illegal under the National Labor Relations Act. In the context of the security provisions related to union membership, this Trade Winds Corp. has a(n) __________ arrangement.

Answers

Based on the information given, it can be deduced that Trade Winds Corp. has a closed shop arrangement.

A closed shop arrangement simply means a place of work where all the employees gave to belong to an agreed trade union.

Under this condition, an employer will only employ the people that are to be part of the trade union. Therefore, it can be seen that Trade Winds Corp. has a closed shop arrangement.

Learn more about trade union on:

https://brainly.com/question/366179

Discuss the value of technology in business.

Answers

Answer:

The vaule of technology in business is very important like the most important of the business because it help keeps tracks of things,  save database, and it help the business grow.

Under the current managed float exchange rate regime; countries with surpluses in their balance of payments frequently do not want to see their currencies appreciate because it makes their goods ________ expensive abroad and foreign goods ________ in their countries.

Answers

The country will not want their currencies to appreciate because it makes their goods expensive abroad and foreign goods be cheaper in their countries.

The floating exchange rate system is a system where currency price on forex market is based on supply and demand of other currencies therein.

Countries with surpluses in their balance of payments usually have a favorable currency because they exports more than it imports.

Hence, the country will not want to see their currencies appreciate because it makes their goods expensive abroad and foreign goods be cheaper in their countries.

Read more about floating exchange rate

brainly.com/question/25813005

how do you wheeze?becasue im lost

Answers

Answer:

breathe out, but try to restrict some of the air passage.

Explanation:

i think plz mark me brainliest

A company makes a $5 profit on each non-faulty product it sells. Approximately 2% of the products manufactured are faulty, with no way to discover which ones are faulty before delivery. If replacement-and-repair costs for the faulty products are $100 each, what is the profit per item? loss of $15. 10 loss of $15 profit of $2. 90 profit of $3. 0.

Answers

Based  on the information given the profit per item is $2.90.

First step is to calculate the company profit

Profit=(100%-2%)×$5

Profit=98%×$5

Profit=$4.9

Second step is to calculate the profit per item

Profit per item=$4.9-($100×2%)

Profit per item=$4.9-$2

Profit per item=$2.90

Inconclusion  the profit per item is $2.90.

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

Demand is more elastic when you are shopping in Walmart than when you shop at a small convenience store because: Group of answer choices

Answers

Answer:

It rises by 25%

Explanation:

Demand is more elastic when you are shopping in Walmart than when you shop at a small convenience store because: more competing products means greater elasticity. Lyft cuts the price of a ride in New York City by 10%. Thereafter, the quantity of rides demanded rises by 25%.

Hope this helped <3

why do many people have a fraught relationship with money?

Answers

Answer:

They often put their wants before their needs

Ming made a car insurance payment of $122. 50. He’ll use the check register to record his transaction. What will be his new balance? An account statement has a balance of 802 dollars and 10 cents. $.

Answers

Based on the information given the new balance is $679.60.

Using the formula

New balance=Account statement balance-Insurance payment

Where:

Account statement balance=$802.10

Insurance payment=$122.50

Let plug in the formula

New balance=$802.10-$122.50

New balance=$679.60

Inconclusion the new balance is $679.60.

Learn more about account statement here:https://brainly.com/question/15525383

Other Questions
A triangle undergoes an enlargement as shown in thediagram below. What is x?Please help Ill give brainliest Renee is filming a scene in which the main character, who is afraid of heights, needs to climb a tree to rescue his catbut then panics when he realizes how enormous the tree is. In the short story on which the scene is based, the character expresses his fear by speaking to his cat, but Renee has decided to film the scene with no dialogue.What film technique could Renee use to convey the characters fear and to create drama? A bright lightingB a low camera angleC a cool color schemeD an eye-level camera angle The equations ? Its for a chemistry class, and he said we need to explain and write down the math problems? Solve the exponential equation by the method of relating the bases, first rewriting the equation in the form In Khan academy int he 8th grade section "Geometric transformation" in the section "Properties & definitions of transformations" how are you supposed to do this? If f(x) = 2 8, what is f(1. 8)? 4 6 10 12. Find the missing value in each row. Use the percent equation. A county has constructed a conical building to store sand. The cone has a height of 101 m and a diameter of 330 m. Find the volume of this building to the nearest hundredth. Use 3.14 for . Describe how parties are organized at the state level. Which of the following is a true statement? A. A number is divisible by two and three if the number ends in a 0, 2, 4, 6, or 8. B. A number is divisible by three and nine if the sum of the digits is divisible by three. C. A number is divisible by nine if the last two digits are divisibly by nine. D. A number is divisible by six if the number is divisible by both two and three. a train is leaving the station and goes from 3m/s to 30 m/s in 12 s. The acceleration of the train is CAN SOMEONE PLEASEE HELP??The face of feminism has changed in unexpected places by unsuspecting heroes. Take Gabrielle Coco Chanel, for example. Her modernist philosophy redesigned the way the world viewed women. By transforming the way women dressed during the 20th century, Coco Chanel granted femininity back to women. Little did the world know that a girl raised in an orphanage would liberate women from common stereotypical uniforms. Gabrielle Chanel was born in France in 1883. She was first inspired to reinvent clothes because she could not afford the fashionable garments of her time. Chanels job as a seamstress in the orphanage had given her the skills that she needed to redefine clothes for women. She opened her first shop outside of Paris, France with her uncles partnership. The store featured pullover sweaters and sailor jackets for men and displayed eye-catching straight skirts. The shop did not survive the tough competition of Paris. After a series of jobs and failed ventures, Chanels second millinery shop became a success. French actresses began wearing Chanels glamorous hats and helped establish her reputation. Chanels first designer item, the little black dress, was a stunning feat. Later, Chanel won critical acclaim for womens business suits which allowed females to look professional and glamorous at the same time. The fashion industry was taken by storm. Clothing originally designed for menlike business suits had been revamped for women.How can the reader tell what genre this is? A. It includes detail about the author's personal experiences. B. It is about a specific time period in Gabrielle Chanel's life. C. It is written by someone other than the person it's about. D. It shows the first person point of view using a descriptive style. Write the percent as a fraction or mixed number in simplest form.72.5%Please show your work. Thank you! Plz Help 100 points and brainlyest if correct Use the chart to answer the questions. What reason for concern about population growth is related to improving air quality?congestionfamineagriculturepollution What happened in My Name is Parvana Chapter 6? i was wondering if u convert 38 inches to centimeters what would it be i told my teacher there is no correct answer for it 5. He_______celebrating their 30th wedding anniverrsary the next week.A. suggested B. suggested of C. suggested on D. suggested in how do u find peoples account on here because i dont know HELP IMPORTANT!! i need help with Java basics