Question: year. Formulate the problem and solve using Excel Solver. Answer the questions below. Note - penalty for wrong answers. are in percentage. The total amount

year. Formulate the problem and solve using Excel Solver. Answer the questions below. Note - penalty for wrong answers. are in percentage. The total amount borrowed from the banks is less than $300,000. The optimal interest amount paid to the banks is $25,900. The total loan from Bank 1 is $130,000. The total amount of interest paid to Bank 1 is $11,800. The interest cost of borrowing money from Bank 3 for Machine 4 is $9,000 The minimum cost of borrowing money is $27,200 The interest paid to Bank 3 for Machine 1$5,700. Bank 1 is lending $20,000 for Machine 1 Interest amount paid to Bank 3 for Machine 2 is $0. The total interest paid to Bank 1 is $130,000 Bank 1 will give Machine 2 a loan of $60,000 It is not good to borrow money from Bank 1 for Machine 3
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
