The model given for Question $2$ is a solved version of a modified problem from Chapter $3.$ Given a company's cash flow projections, the problem involves determining how much to borrow each month against different types of loans, those with either $1-$month or $3-$month terms, such that cash requirements are met each month at minimum total interest expense. All relevant information is given in the spreadsheet.

Keeping everything else the same, use linear constraints to modify the problem to incorporate the following new condition: if any amount is borrowed on a $1-$month loan in any month, it must be at least $$175,000,$ or nothing. Assume there is no restriction on the amount that can be borrowed against $3-$month loans. The model must be solvable with the Simplex algorithm.$\backslash$table$[[$Question $2],[,,$Month$],[,,1,2,3,4,5,6],[$Beg Balance,,$80,000,16,000,16,000,16,000,16,000,16,000],[$Cash Receipts,,$80,000,180,000,220,000,280,000,380,000,500,000],[$Bills Due,,$400,000,400,000,480,000,160,000,160,000,80,000],[$Loans Taken Out$],[1$ Month Loan,$1\mathrm{.}00\%,127,073,0,0,0,124,902,--],[3$ Month Loan,$2\mathrm{.}50\%,122,927,342,344,254,000,--,--,--],[$Total Loans Taken Out,,$250,000,342,344,254,000,0,124,902,0],[$Loan Payback, Principal & Interest$],[1$ Month Loan,,$--,128,344,0,0,0,126,152],[3$ Month Loan,,$--,--,--,126,000,350,903,260,350],[$Total Loan Payback, Principal & Interest,$0,128,344,0,126,000,350,903,386,502],[$Ending Balance,,$10,000,10,000,10,000,10,000,10,000,49,498],[$Min Ending Balance,$10,000,,,$Total Interest Expense,$20,502]]$