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?