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 forces 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?