2. A closer estimate of the total cost can be made by including the estimated sales tax. Use a formula to
calculate the estimated cost for July 2014 using 7% sales tax. Then, write the formula you used and the
estimated cost in the cell below. Hint: Convert 7% into a decimal for the formula. (5 points)

Answers

Answer 1

Answer:

=([Cost] * 1.07)

Explanation:

The question has missing details.

The complete question is to calculate write a Microsoft Excel formula that calculates the total cost which includes the sales tax

Assume that the table heading for estimated cost in July 2014 is Cost

The formula to calculated the total cost which includes the sales tax is:

=([Cost] * 1.07)

The above uses structured reference to make reference to the cost in July 2014.

To calculate the total which includes sales tax, we use:

[tex]Total = Cost * (1 + Sales\ Tax)[/tex]

[tex]Total = Cost * (1 + 7\%)[/tex]

Convert percentage to decimal

[tex]Total = Cost * (1 + 0.07)[/tex]

[tex]Total = Cost * 1.07[/tex]

Hence, the Excel equivalent is:

=([Cost] * 1.07)

Answer 2

Answer:

=([Cost] * 1.07)

Explanation:

The complete question is to calculate write a Microsoft Excel formula that calculates the total cost which includes the sales tax

Assume that the table heading for estimated cost in July 2014 is Cost

The formula to calculated the total cost which includes the sales tax is:

=([Cost] * 1.07)

The above uses structured reference to make reference to the cost in July 2014.

To calculate the total which includes sales tax, we use:

Total = Cost x ( 1 + Sales Tax )

Total = Cost x ( 1 + 7% )

Convert percentage to decimal

Total = cost x ( 1 + 0.07 )

Total = Cost x 1.07

Hence, the Excel equivalent is:

=([Cost] * 1.07)

Plz mark as brainlist..


Related Questions

plz help!!
Which best describes why taxes and savings are considered leakage factors?

A) They take money out of households.
B) They take money out of the economic system.
C) They take money out of the economic sectors.
D) They take money out of the financial sector.

Thank you!! : )

Answers

Its b

Explain:
The reason it’s because the government collects taxes which are considered leakages

Answer:

my In.stagram I'd: unknown_22770

Explanation:

I hope you will msg me


Which of the following accounts would normally have a credit balance and appear in the balance sheet?
A. Dividends.
B. Salary expense.
C. Revenue.
D. Uneamed revenue.
E. Accounts receivable.

Answers

B.salary expense !!!!!!!!!

The account that contains a normal credit balance & the same appears in the balance sheet is unearned revenue.

The following information is relevant:

The dividend contains the normal debit balance and the same is to be shown under the stockholder equity statement.The salary expense is to be shown under the income statement and contains a normal debit balance.The revenue is to be shown under the income statement & contains a normal credit balance.Unearned revenue is a liability account and contains a normal credit balance. Also, it is to be shown under the balance sheet.The account receivable is an asset account & it contains a normal debit balance. Also, it is to be shown under the balance sheet.

Therefore we can conclude that the account that contains a normal credit balance & the same appears in the balance sheet is unearned revenue.

Learn more about the balance sheet here: brainly.com/question/22988522

Find the effective rate of interest if payments of 300 at the present, 200 at the end of one year, and 100 at the end of two years accumulate to 800 at the end of three years.

Answers

Answer:

12.93%

Explanation:

Given that the amount of 300 is invested for 3 years, while the amount of 100 is invested for 2 years and 100 is invested for 1 year.

also amount accumulated in three years = 800

Applying the formula to find the future value we get

300(1+r)^3 + 200(1+r)^2 + 100(1+r) = 800

which can be further simplified to

300r^3+1100r^2+1400r+600=800

where, r is the effective rate of interest which we have to find out

The above equation is cubic in r, so to solve this we can use equation solver. When we put this equation in equation solver we get

r = 0.12926

r ≅ 0.1293

Therefore,  effective rate of interest  = 12.93%

como conseguir novio en tres días?

Answers

Answer:

go to reddit loads of incels

Explanation:

jk, just shoot your shot with whoever shows interest? ask em out maybe worst they can say is ew no. if they do just move on to the next, seeing as you having a time limit.

yes the person above me is correct! hope this helps


Cassandra is a 21-year-old who is still in college. She wants a credit card so she can order items online.
Her mother offers to let Cassandra use her card, but Cassandra would like it in her own name. What is
the advantage of having it in her own name?
A. If she pays her bills promptly she is establishing a good credit history.
B. She will get a finance charge with a lower APR.
C. Her credit score will go up by 200 points.
D. She will be given more time to pay her bills.

Answers

The most logical answer to me would be A, however I recommend you don’t go with my answer JUST YET because this is an educational guess. Take time to think about my answer. Sorry if it’s wrong

Having a credit card in your own name has a number of benefits, including helping you establish your own credit history, being there for you in times of need, and maybe earning points or cash back on purchases. As a result, choice (A) is appropriate.

What is credit card?

Customers (cardholders) are given a specific sort of payment card called a credit card that enables them to pay for products and services from merchants based on the amount of debt they have acquired (i.e., promise to the card issuer to pay them for the amounts plus the other agreed charges).

A revolving account is set up by the card issuer, which is often a bank or credit union, and gives the cardholder access to a line of credit from which they can borrow money to make purchases or get cash advances. The two different kinds of credit cards are consumer and commercial cards.

Most playing cards are made of plastic, but others are made of metal (stainless steel, gold, palladium, titanium), and some have gemstones inlaid in the metal.

Hence, option (A) is accurate.

Learn more about credit card, from:

brainly.com/question/27350251

#SPJ2

what is 10+10 im having troubles help

Answers

Answer:

20

Explanation:

Simple

10 + 10 = 20

Answer:

20 lolbajahajwbwiqbqn

i will give someone brainliest
98 points will be reworded

Answers

Answer:

I would be glad to help!

Explanation:

Do you have any specific question about this you're asking for?

Answer:

What is your question about?

Do you have an image or something of it?

Explanation:

N Apple bought goods on credit from Pencil Point Ltd. What is the double entry to record this transaction in the accounting records of Pencil Point Ltd? a. Debit N Apple, Credit Sales b. Debit Sales , Credit N Apple c. Debit Purchases, Credit Pencil Point ltd d. Debit Pencil point Ltd, Credit Purchases.

Answers

Answer:

c. Debit Purchases, Credit Pencil Point ltd

Explanation:

The journal entry for purchasing the goods from the Pencil point ltd on credit is given below;

Since the goods are purchased so here purchase account is debited and we credited the pencil point ltd

So, the journal entry is

Purchase Dr XXXX

          To Pencil Point ltd XXXX

(Being goods purchased on credit)

The purchase is debited as it increased the assets and pencil point ltd is credited as it also increased the liability

Personal Financial
Literacy

Answers

Answer:

You would have to answer this because I dind't read the story.

Explanation:

Columbia Bank & Trust has just given you a $20,000 term loan to pay for a new concrete mixer. The loan requires five equal annual end-of-the-year payments. If the loan provides the bank with a 12 percent return, what will be your annual payments?

Answers

Answer:

$5,548.19

Explanation:

According to the scenario, computation of the given data are as follows,

Principal payment (p)= $20,000

Rate of interest (r) = 12%

Time period (t) = 5

So, we can calculate the annual payment by using following formula,

Annual payment = [p×r×[tex](1+r)^{t}[/tex]] ÷ [ [tex](1+r)^{t}[/tex]-1]

By putting the value, we get

= [$20,000×0.12 [tex](1+0.12)^{5}[/tex]] ÷ [[tex](1+0.12)^{5}[/tex]-1]

By solving the equation, we get

= $5,548.19

Hence, the annual payment will be $5,548.19.

Which factor can be a barrier to a person applying for a job as a cook at a fast-food restaurant?
A. being unable to handle shift at work
B. a high school diploma
C. plans to continue education
D. knowing only one language


NO LINKS!!!!!!!!!

Answers

the answer is d i think

What is your current role as a team member either at work, school, family, or sports? How will that role change in the future?
PLEASE ANSWER

Answers

Currently I am a family team member and over the summer I’m hoping to get a job at a local super market to start making money for myself

50 points each
“When you drink alcohol you are just borrowing happiness from tomorrow.”
“Your stomach thinks all potato is mashed.” ...
“I wonder what my dog named me?
”We eat pizza from the inside out. ...
If you live to be 70 years old you will spend TEN YEARS of your life on Monday. ...
Sometime in the future, someone will say your name for the last time. ...
Deaf people probably don't understand why farts are funny. ...
The word ambiguous only has one meaning.These are not my memories. ...
No one knows how anyone feels. ...
You are neither the first nor the last. ...
You are someone's ancestor. ...
Today the Earth is more beautiful than it will be tomorrow. ...
You only know you were happy when you no longer are. ...
If we're alone it's frightening. ...
Every thing could be the last thing.
join my pad let no space in between pad let
https://pad let.com/hoelee86/n9lzo8fq8qb9rows

Answers

Answer:

that x-ray has arthritis

Answer:

Hey mate.....

Explanation:

Facts were very true......can't join pad let now....

Thx for points...!!!!!Lol

businesses today succeeded or fail based on their ability to___

A. innovate with technology to meet their customers needs
B. adopt customized software to their needs
C. raise expenses to match revenue
D. open multiple channels of sale
E. butter (im joking at this option but i need the right answer)

Answers

The answer would be A. innovate with technology to meet their customers needs.

A realtor is trying to predict the selling price of houses in Greenville (in thousands of dollars) as a function of size (measured in thousands of square feet) and whether or not there is a fireplace (FP is 0 if there is no fireplace, 1 if there is a fireplace). Part of the regression output is provided below based on a sample of 20 homes. Some of the information has been omitted.


Variable Coefficients Standard Error t-Stat

Intercept 128.93746 2.6205302 49.203

Size 1.2072436 11.439

FP 6.47601954 1.9803612 3.27

a. The estimated coefficient for size is approximately _____.


b. How many predictors (independent variables) were used in the regression?

Answers

Answer:

a. The estimated coefficient for size is approximately 13.81.

b. In the regression, two predictors are used. These two predictors are size and fireplace (FP).

Explanation:

a. The estimated coefficient for size is approximately _____.

Estimated coefficient for size = Standard Error of size * t-Stat of size =  1.2072436 * 11.439 = 13.81

Therefore, the estimated coefficient for size is approximately 13.81.

b. How many predictors (independent variables) were used in the regression?

Independent variables can be described as variables that are changed or manipulated in order to measure the effect of their changes on the dependent variable. Independent variables are therefore also called predictors because they employed to predict the dependent variable.

In the regression, two predictors are used. These two predictors are size and fireplace (FP).

The SmartArt icon will allow you to include which of the following on a slide?

Answers

I think the answer is Graphs, I hope this helps

Shady lawyer. Brice had a number of ethical issues come up in law school involving alleged cheating but managed to graduate because nothing was ever proven. Upon obtaining his law license, Brice enjoyed living "on the edge" and engaged in tactics that were at least questionable. One of his clients was an older gentleman, Sam, with significant assets and significant legal issues involving a messy divorce stemming from his involvement with a local dog groomer, Susie. Brice told Sam that he felt certain that he could arrange matters so that Sam could live happily in the Caribbean with Susie but that, in addition to paying a hefty legal fee, Sam would need to name Brice as a significant beneficiary in his will and give Brice power of attorney over his assets. Sam agreed to do so. He gave Brice power of attorney and changed his will to reflect that upon his death, Brice would receive half his estate. The other half went to Susie. Sam also paid the hefty legal fee Brice demanded. At that point, Brice agreed to proceed with negotiations in the divorce. Shortly after the divorce, Sam had an unexpected heart attack and died immediately. Susie, the executor of the will, told Brice that she was reporting him to the state bar association and that he was not entitled to any assets from the estate. Brice told Susie that he knew that Susie had failed to pay income tax for all her dog grooming and that he was reporting her unless she kept her mouth shut and consented to the terms of the contract. Brice also said that in return for keeping his mouth shut, he wanted additional sums purportedly for his work on Sam's divorce. Assuming that Sam had paid all amounts validly due from the divorce proceeding, which of the following is true regarding Brice's attempt to obtain additional fees?
A. Brice has caused Susie to experience duress.
B. Brice has unduly influenced Susie.
C. Brice has caused Susie to experience duress and unduly influenced Susie.
D. Brice has committed intentional wrongful disclosure.
E. Brice is not guilty of anything, so long as he used no physical force to obtain Susie's agreement.

Answers

Answer:

A. Brice has caused Susie to experience duress

Explanation:

Based on the information given BRICE HAS CAUSED SUSIE TO EXPERIENCE DURESS is true regarding Brice's attempt to obtain additional fees based on the fact Brice is threatening , Forcing and persuading Susie to do things against her will by threatening to report her due to her failure to pay income tax because she said that Brice does not have the legal right to obtain the money from the estate unless she kept her mouth shut and agree to the terms of the contract, which inturn makes Brice to attempt to collect additional fees based on Sam divorce case in return for not reporting her.

what are rock layers​

Answers

Answer:

the answer is isStratum

Choose a real or made up company, and describe at least three ways in which the company uses technology.

Answers

Answer:

Case of E Commerce Companies, & their technical processes.

Explanation:

Any company based on E commerce model, uses technology in its various phases of operation.

E Commerce refers to online buying & selling of goods. They use technology for website or app maintainence, for order placing, for payment, for delivery tracking & various other updates. Technology is also used for back end stock & orders management etc.

Many big online shopping companies (eg Amazon) use this model & its technical aspects.

Answer:

Dominos is a company that has many variable costs. Some examples include flour, cheese, and tomatoes.

Explanation:

Philip earns $980,000 per annum. He is allowed a tax free income of
$50,000. Then his taxable income will be $______
and tax paid at 6% will be $_____
per annum.

Answers

Answer:

His taxable income is $930,000.

Tax paid at 6% will be $55,800 p.a

Helpmeeeeeeeeeeeeeee

Answers

Answer:

18. b : most economic decisions are made by buyer and sellers

19. b : federal income tax

Explanation:

Can you really answer the question of whether an opportunity is real before developing a product concept?

Answers

Answer:

Yes

Explanation:

For example, it has been said that what prompted e-commerce on platforms such as Amazon, eBay, etc was a result of the opportunity their founders saw with the invention/adoption of the internet.

In other words, they saw a real opportunity (through the internet growth rate) and thus decided to develop a product concept. Hence, we could thus conclude with a yes to the question.

list two of three places where a student can learn about apprenticeship opportunities

Answers

Answer: The first and really the best way is Job corps, trade schools, and a regular fast food restuarant

Explanation: But Job corps is better you get a place to stay you get all the benefits like medical coverage, child services, food, drivers liscence, and you can learn over 50 things to do.

The two places where a student can learn about apprenticeship opportunities are Job corps, trade schools.

What is apprenticeship?

Apprenticeship is a system for educating a new generation of practitioners of a trade or profession through on-the-job training and, in some cases, additional study.

Apprenticeships can also help practitioners obtain a license to work in a regulated occupation. The majority of their training is completed while working for an employer who assists apprentices in learning their trade or profession in exchange for continued labor for an agreed-upon period after they have demonstrated measurable competencies.

Therefore, Job corps, trade schools are the best places  where a student can learn about apprenticeship opportunities.

To learn more about apprenticeship, click here:

https://brainly.com/question/779411

#SPJ2

does the overcast amount in the debtors journal go into cost of sales or only debtors allowance?

Answers

I think it’s only debtors allowance
Other Questions
PLEASE HELP FAST Looking for the bottom angle to find my answer! 30 POINTS Find the volume of triangular prism. NO LINKS BRAIN FART! Is there a word that pretty much means the act of being desperate? I thought it was disparity, but that means something completely different. How might supporters of the slave trade react to the ideas of the Enlightenment? you had a nightmare last night, write a story about a bad dream you have experienced last night Which example uses transitional tags to show chronological order?Unless you are prepared to have sore fingers, wear some gloves the first time you try flint knapping.First, you have to find the right kind of rock for your hard hammer. Then, you have to learn how to strike the flint correctly.Dont strike straight down on the rock. Instead, try hitting the rock with a glancing blow so that you push the hammer away from you.In other words, you should never try flint knapping without wearing safety glasses. Which of these answer choices best describes the overall effects that would occur in an animal that consumes this plant? Who commissioned Bramante to build the structure below?a. Pope Julius IIb. Queen Isabella and King FerdinandC the Catholic Diocesed. Michelangelo Which phrase correctly completes this sentence?____________ es boliviano. Options:A. La maestraB. Los maestrosC. El maestroD. Las maestras Aluminum chloride, AlCl3, is an inexpensive reagent used in many industrial processes. It is made by treating scrap aluminum with chlorine according to the following equation. Please balance the equation. __2_ Al (s) + 3___ Cl2(g) _2___ AlCl3(s)If you start with 3.11 g of Al and 5.32 g of Cl2, which reagent is limiting? How many grams of AlCl3 can be produced? During an experiment you obtained 5.57 g of AlCl3, what was your percent yield? please help PLEASE PLEASE !!!!determine the area of the composite figure 14in 10in 8in*it wont let me add the pic * Enlarge the triangle by scale factor 0.5 using (3, 1)as the centre of enlargement. You have 48 in a yellow ribbon and 64 inches of red ribbon you want to cut the ribbon into pieces of equal length with no leftovers what is the greatest length of pieces that you can make? Alex brought 48 cookies to school to celebrate his birthday. He gave 9 to teachers. He then shared equally the remaining cookies with his 18 classmates. How many cookies remained? true or false Producers found on the ocean floor use a process called photosynthesis to create energy-rich molecules. 11. Our teacher said that coal (found - finds - is found - was found) underground. Willl give brainlyist if quick its timedd The cereal box below is being cut at the edges. Choose the net below that could be created from the box. A dodecagonal pyramid has a surface area of 130 square inches. A similar dodecagonal pyramid has a surface area of 2080 square inches. If the larger pyramid has a height of 32, what is the height of the smaller dodecagonal pyramid? Japan continued its military aggression in the 1930s because it had failed to achieve which goal during World War I?OA. gaining control of AustraliaOB. stopping British imperialismOC. expanding its power over ChinaOD. expelling Korea from its islands