Spreadsheet Modeling Assignment
Helpplease127
Modelingassignments.xlsxLocation
| Laboratory Location Model | Page 403 Example 11.16 | ||||
| 1. Following the steps from the book for the Laboratory Location and create the chart; | |||||
| Data | 2. On page 420 # 39, repeat the same steps and find out the best location. | ||||
| Location | X Coordinate | Y Coordinate | Trips/month | ||
| A1 | 0 | 0 | 5 | ||
| A2 | 20 | 80 | 25 | ||
| A3 | 60 | 30 | 20 | ||
| A4 | 100 | 100 | 35 | ||
| A5 | 70 | 110 | 15 | ||
| New Location | 1 |
Page 419 # 36
| Total money available for investment: | $2,500 | |||
| There are three stocks considered: | Stock | A | B | C |
| Price/share | $ 25 | $ 15 | $ 30 | |
| Return/Share | $ 8 | $ 7 | $ 11 | |
| Find the highest return and limits the investment to what you have. |
Page 415 #18
| Markdown Price Model | Page 415 #18 |
