Lezárt

excel solver

A projektet nevo1234 felhasználó nyerte el az alábbi feltételekkel: $5 USD / hour.

Kapjon ingyenes árajánlatokat egy hasonló projektre
A munkaadó dolgozik
Projekt költségvetés
$2 - $8 USD / hour
Összes Árajánlat
17
Projekleírás

Instructions:

1. Use Excel to answer your assignment. Solve each part (A, B, and C) in a separate sheet.

2. Explain all the details, define decision variables, objective function, constraints, etc.

.

Assignment 2: Assume you have $X000 (X thousand dollars) to invest over the next

seven years. At the beginning of each year you can invest money in one or three-year

time deposits. The bank pays 1 percent interest on one-year deposits and 4 percent

(total) on three-year time deposits. In addition, Royal Bank of Canada will offer twoyear

certificates starting at the beginning of the third year. This investment in RBC will

return [url removed, login to view] percent (total). If you invest your money that is available every year,

formulate a linear programming to maximize your total cash on hand at the end of the

7

th year.

A: Suppose X is the sum of your student ID digits. Moreover, assume that you can

invest at the beginning of each year any value in the available investment options.

Define decision variables, objective function, and constraints for your linear

programming model. (6 marks)

B: Solve your investment LP model using Excel Solver and interpret your investment

plan. (3 marks)

C: Assume the two-year RBC deposit starts at the beginning of the fifth year. What

would be the corresponding change in your model formulated in Part A?

Odaítélve:

Kapcsolódó készségek böngészése

Kapcsolódó projektek

Egyéb dolgok, amiket az emberek a Freelanceren csinálnak

Kapcsolódó cikkek

A legújabb cikkek

Szeretne pénzt keresni?

  • Adja meg a költségvetést és a munkaelvégzéséhez szükséges időt
  • Vázolja fel ajánlatát
  • Kapjon fizetést munkájáért

Alkalmazza a szabadúszókat, akik erre a projektre is ajánlatot adtak

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online