APA format Word and Excel doc For each situation described, identify the target

Question

APA format Word and Excel doc For each situation described, identify the target cell, changing cells, and constraints 1-I am borrowing $ 100,000 for a 15-year mortgage. The annual rate of interest is 8 percent.

How can I determine my monthly mortgage payment?

2-How should an auto company allocate its advertising budget between different advertising formats?

3-How should cities transport students to more distant schools to obtain racial balance?

4- If a city has only one hospital, where should it be located?

5-How should a drug company allocate its sales force’s efforts among its products?

6- A drug company has allocated $ 2 billion to purchasing biotech companies. Which companies should it buy?

7-The tax rate charged to a drug company depends on the country in which a product is produced. How can a drug company determine where each drug should be made?

Explanation / Answer

SOLUTION:
This solution having explanation , full calculation ,step by step procedure for

clear and better understanding.

EXPLANATION:

1.

Beforing going to direct answer let's first understand the 'mortage payment'.
mortage payment is the payment paid by borrower with principal and interest rate to the owner
from which they have taken loan amount earlier.

the formula for calculating mortal payment is below:

M=P*r(1+r)^n/((1+r)^n-1)

where M=mortage payment amount
P=principla value
r=monthly rate
n= no of payments (i.e The number of months that you will be paying the loan amount).

so now Given value :

P=$100,000
n=15 year =15*12=180 months
r=8% annual
=8/100=0.08 annual
r=0.08/12=6.67*10^-3=0.0067

so now putting all value in formula :

M=P*r(1+r)^n/((1+r)^n-1)

M=100,000*(1+0.0067)^180/((1+0.0067)^180-1)

M=142979.51
hence the Mortage payment is $142979.51 per month.

2.

As you know that each company are not powerful in terms of money.
They have some limitation.
each company should decides what the profit are comming from business and
then according to customer they should advertise their business brand to reach maximum customers
ANd for that they should have different types of advertising formats:

social media advertising is one of of them for reaching to many people.
ad-campain is also beneficial for comppany.
Affiliate marketing is best way for advertising.
and If possible make a price low as much as they can with better quality .It attracts the customer for low price and better quality.

Related Questions

Navigate

• Browse (All)
• Browse A
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.