help with assignment
Gogold 
AET702assignment.xlsxQ1
| Year | NCF (net cash flow) |
| 0 | -$20,000 |
| 1 | -$2,000 |
| 2 | -$5,000 |
| 3 | -$10,000 |
| 4 | $5,000 |
| 5 | $20,000 |
| 6 | $30,000 |
| 7 | $40,000 |
The table represents a net cash flow of a potential 7-year business opportunity. Current bank loan charges 3.5% interest rate. Should we go for the business?
Q2
| Project | Init. Invest | Annual NCF | Life | PW |
| A | $20,000 | $5,000 | 4 | -$2,270.25 |
| B | $90,000 | $19,000 | 9 | $45,048.61 |
| C | $70,000 | $26,800 | 5 | $46,029.97 |
| D | $40,000 | $24,000 | 4 | $45,102.81 |
| E | $60,000 | $20,000 | 5 | $26,589.53 |
| F | $70,000 | $20,000 | 6 | $31,513.84 |
| G | $40,000 | $17,000 | 5 | $33,601.10 |
| H | $10,000 | $3,400 | 5 | $4,720.22 |
| Budget | $215,000 | 5% | interest rate | |
| Constraint 1: Project A must be selected if Project B is selected | ||||
| Constraint 2: A maximum of two projects can be selected among Project C, D, E, and F. | ||||
| Constraint 3: Exactly three projects must be selected among E, F, G, and H | ||||
Build a project selection solver model that maximizes a profit within a given budget.
Q3
| Order | Weight | $Cost | $Cost |
| Carrier A | Carrier B | ||
| 1 | 10 | $2 | $3 |
| 2 | 20 | $4 | $2 |
| 3 | 10 | $2 | $5 |
NCAT MSTM graduate works at shipping department, Greensboro Manufacturing. New orders just came in. There are two shipping carriers: A and B. Each carrier offers different prices and each carrier has a remaining capacity limitation of 20kg. Build a project selection solver model that maximizes a profit within a given budget.
