APA format Word and Excel doc

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?