1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
34kurt
3 years ago
7

In cell G5, enter a formula to calculate the total amount due for the first client based on the annual total and the number of y

ears in the contract. Copy the three formulas in columns C, G, and E down their respective columns.
Business
1 answer:
Brilliant_brown [7]3 years ago
5 0
The answers for your question are: 
1) =E5*F5 (copy to cells G6:G13) 

<span>2) =VLOOKUP(B5,Membership,3,FALSE) </span>

<span>3) =PMT(B$23/B$24,F5*B$24,-I5)</span>
You might be interested in
Let x be per capita income in thousands of dollars. Let y be the number of medical doctors per 10,000 residents. Six small citie
MAVERICK [17]

Answer:

The percentage of variation esplained by the model is given by the determination coefficient, on this case:

R^2 = 0.934^2 =0.872

And we have 87.2% of the variation explained by the linear model given.

\hat y = 5.756(8.5) -36.895=12.031

And we have 12.031 doctors per 10000 residents.

Explanation:

Assuming the following dataset:

x                 y

8.6           9.6

9.3           18.5

10.1          20.9

8.0           10.2

8.3           11.4

8.7            13.1

Assuming this question: "The data has a correlation coefficient of r = 0.934. Calculate the regression line for this  data. What percentage ofvariation is explained by the regression line? Predict the number of doctors per 10,000 residents in a town with a per capita income of $8500."

We want a linear model like this:

y = mx +b

Where m represent the slope and b the intercept for the linear model. And we cna find the slope and b with the following formulas:

m = \frac{n \sum xy - \sum x \sum y}{n \sum x^2 -(\sum x)^2}

b = \frac{\sum y}{n} -m \frac{\sum x}{n}

And from the dataset we have the following values:

n= 6, \sum x =53, \sum y = 83.7 , \sum xy = 755.89, \sum x^2 = 471.04

And replacing into the equation for m we got:

m =\frac{6(755.89) - (53)(83.7)}{6(471.04) -(53)^2}=5.756

And the intercept:

b = \frac{83.7}{6}-36.895 5.756 \frac{53}{6}=-36.895

And then the linear model is given by:

\hat y = 5.756 x -36.895

We can find the estimation replacing x = 8.5 into the linear model and we got:

\hat y = 5.756(8.5) -36.895=12.031

And we have 12.031 doctors per 10000 residents.

The percentage of variation esplained by the model is given by the determination coefficient, on this case:

R^2 = 0.934^2 =0.872

And we have 87.2% of the variation explained by the linear model given.

4 0
2 years ago
Mitchell has a cause: He loves cats. As an economist, he could earn $100,000 as a faculty member, but instead he decides to devo
Usimov [2.4K]

Answer: (e.) The same pay as either a professor or as a chief economist at the Humane Society.

Explanation:

The correct answer would be <u>option (e)</u> because in this case there lies an ambiguity i.e. we are uncertain about skillets that an economists should be endowed with or for being a faculty member.

Therefore , it can be concluded that he would  get at least as good pay as being faculty. In both cases he'll be better off.

8 0
3 years ago
Career Services, Incorporated sold some office equipment for $52,000 on December 31, 2021. The journal entry to record the sale
Papessa [141]

Answer:

Date of selling machine is 31 Dec 2021, then gain of $47,000

If date of selling this machine is 31 Dec 2012 (used tenor: 4 years), then gain of 2,000

Explanation:

Depreciation per year = (original cost $80,000  - residual value $5,000)/ useful life of 10 years

= $7,500 per year

Date of purchase: January 1, 2009

Date of sold:  December 31, 2021

⇒ Actual life of this machine = 13 years, but the maximum depreciation as accounting rule is for 10 year only

After 13 years, the book value = original cost - depreciation booked

= $80,000 - $7,500*10 = $5,000

Gain/ Loss =  sold price - boo value = $52,000 - $5,000 = $47,000

If date of selling this machine is 31 Dec 2012 (used tenor: 4 years), then we have:

Gain/ Loss = sold price - book value

= $52,000 - ($80,000 - $7,500*4) = 2,000

4 0
3 years ago
Ann wants to be a manager who directs the work of others
natali 33 [55]

The answer to this is DECA, I believe. :) I hope this helps

6 0
3 years ago
Sales promotions that provide consumers an incentive to buy a product, such as a cents-off coupons or a discount, are widely use
Nady [450]

Answer:

it is challenging to track usage of the coupons

Explanation:

Coupons are defined as an instrument that is used to obtain a discount or rebate when making a purchase.

Stores usually give out coupons to customers as an incentive to by products.

However there will be challenge of tracking the coupons as well as the discount on each coupon.

Coupons are given at different discount rates at different times, so it is cumbersome to track a particular coupon out of the many issued when customer wants to redeem it

6 0
2 years ago
Other questions:
  • Which of the following line items of the statement of cash flows must be obtained from the income​ statement?
    9·1 answer
  • Automatic stabilizers allow the government budget to ?
    8·1 answer
  • At the scene of the crime, the evidence collector found a damp, bloody shirt. the evidence collector quickly wrapped the shirt i
    9·1 answer
  • Hagelin Co. wants to issue new 15-year bonds for some much-needed expansion projects. The company currently has 8 percent coupon
    13·1 answer
  • On January 1, 2020, Ann Price loaned $212355 to Joe Kiger. A zero-interest-bearing note (face amount, $275000) was exchanged sol
    8·1 answer
  • Consider the market for a breakfast cereal. The​ cereal's price is initially ​$3.003.00 and 7070 thousand boxes are demanded per
    7·1 answer
  • According to the PPC, as we produce more military goods and our resources remain constant, what will happen to the production of
    8·1 answer
  • The law of demand is based on the observation that:________.
    8·2 answers
  • Which of the following is an example of investment (I) Group of answer choices a. new plants and equipment purchased by a firm.
    10·1 answer
  • During the financial crisis of 2007-2008, the Fed engaged in lending to certain large non-bank financial firms in the private se
    11·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!