Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The excel spread sheet below I have done it, however, I am unsure of how to put in the constraint to solve the linear programming

The excel spread sheet below I have done it, however, I am unsure of how to put in the constraint to solve the linear programming model. Need assitance ASAP

image text in transcribed
GBA Q1 - Excel File Home Insert Page Layout Formulas Data Review View Help "Tell me what you want to do View Side by Side Ruler Formula Bar Split EEC Zoom 100% Zoom to Arrange Freeze Hide [DI Synchronous Scrolling New Switch Macros Normal Page Break Page Custom Preview Layout Views Gridlines Headings Selection Window All Panes - Unhide El Reset Window Position Windows - Macros Workbook Views Show Zoom Window P13 fx G N 2 3 Annual Loan 4 Monthly Loan 5 Cash on Hand LLS OLS 6S 8S 6 S7 9S SS ZS 7 Decision Variables S1 S4 0.025 0.025 0.025 0.025 0.025 0.025 0.025 0.025 0.025 0.025 0.025 8 Interest 0 12 9 Optimal Solution 10 Min: 11 Objective Function, Z - 12 13 Constraints 14 1) End of January 4000 6000 L+ S1 + $4000 - $6000 = C1 15 2)End of February 3000 5000 C1 + S2 + $3000 - $5000 - 1.025S1 = C2 16 3)End of March 3000 4000 C2 + S3 + $3000 - $4000 - 1. 025S2 = C3 3000 C3 + $4 + $3000 - $3000 - 1.025S3 = C4 17 4)End of April 3000 MYYYYYYY 18 5)End of May 5000 4000 C4 + S5 + $5000 - $4000 - 1.0254 = C5 9000 1000 0 C5 + S6 + $9000 - $1000 - 1.025S5 = C6 19 6)End of June C6 + S7 + $3000 - $6000 - 1 025S6 = C7 20 7)End of July 3000 6000 21 8) End of August 2000 6000 C7 + S8 + $2000 - $6000 - 1.025S7 = C8 22 9)End of September 1000 4000 0 C8 + S9 + $1000 - $4000 - 1.0258 = C9 C9 + S10 + $2000 - $2000 - 1.0259 = C10 23 10)End of October 2000 2000 0 6000 1000 C10 + S11 + $6000 - $1000 -1.025S10 = C11 24 11)End of November 25 12)End of December 10000 1000 3000 C11 + $10000 - $1000 - 1 12L = C12 26 27 28 29 30 Workings LHS RHS 31 Constraints 1 32 Constraints 2 33 Constraints 3 34 Constraints 4 35 Constraints 5 36 Constraints 6 37 Constraints 7 38 Constraints 8 39 Constraints 9 Sheet2 Ready WE

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Derivatives Markets

Authors: Robert McDonald

3rd Edition

978-9332536746, 9789332536746

Students also viewed these Mathematics questions