Explore BrainMass

Explore BrainMass

    Excel Solver of IP Problem - Susan Wong's budget

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Please see the attachment.

    © BrainMass Inc. brainmass.com December 24, 2021, 8:39 pm ad1c9bdddf
    https://brainmass.com/math/linear-programming/excel-solver-ip-problem-susan-wongs-budget-298741

    Attachments

    Solution Preview

    I set up the IP problem in Excel and solved it with Solver. The Excel spreadsheet is attached. You can see in this solution the annual return of $824.09 is gotten by investing $3500 in the 1-month investment in January, $3090 in the 7-month investment in February, etc. as read off the light grey cells on the right-hand side. The sum in column D is what Solver is ...

    Solution Summary

    For the Solution, I set up the IP problem in Excel and solve it with Solver. The Excel spreadsheet is attached.

    $2.49

    ADVERTISEMENT