Question: Please solve using excel solver Please solve using excel solver The great bank of India is currently engaged in devising a loan policy that involves

Please solve using excel solver

Please solve using excel solver Please solve using excel solver The great

Please solve using excel solver

The great bank of India is currently engaged in devising a loan policy that involves a maximum of 15 crore. The pertinent information about various tvnes of loans is diven as The bad debts are those loans that are not recoverable and also they do not produce any revenue. The bank is considering the following for drafting its policy. Keeping in view the competition with other financial institutions it is felt that at least 40% of the funds be given as agricultural and commercial loans. In keeping with the government policy of encouraging housing it is decided that that the housing loans should be at least one half of the combined personal, car and home loans. Further the commercial loans should be no less than 1 crore and the overall ratio of bad debts on all loans should not exceed 5.5%. Formulate this problem as an LPP

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Solve in Excel, using SOLVER The great bank of India is currently engaged in devising a loan policy that involves a maximum of 15 crore. The pertinent information about various types of loans is...

The Bank of India is currently engaged in devising a loan policy that involves a maximum of 1 5 crore. The pertinent information about various types of loans is given as \ table [ [ Type of Ioan,Rate...

I need help with my part 1 and part 2.can you finished ,thank u FINA 415-15S PART 2 (VBA) # Worksheet Name 1 A 2 B Description Programing user defined function (30 marks) Subroutine to generate after...

3 COLLEGE ALGEBRA - TRIGONOMETRY Business and Finance (MAT115) This course will start with a review of basic algebra (factoring, solving linear equations, and equalities, etc.) and proceed to a study...

I need help with part,can you help me finish it?thank u FINA 415-15S Exam PART 1 Excel # 1 2 3 4 5 6 Worksheet Name Solver Look Up Function Matrix Pivot table Data Table Offset Function Description...

BIZ3189 Management Information Systems Take-home Exam 1 The tasks in this exam aim at developing a basic level of understanding on Excel and how you can use it to develop Decision Support Systems....

Please create an excel spreadsheet with formulas for requirement 5 (pages 24-27)and requirement 6 (pages 28-31)only. Please submit in excel format. Both questions and answers are provided for...

Corporate Finance Course it's about Whole Foods purchase by Amazon. below are the questions need to be answered, also the documents are attached. QUESTIONS: 1.The investment thesis on AMZN has ALWAYS...

Please help me with my Hand in Group Assignment on Linear Programming 1. One Word Document with a report outlining your recommendations for the issues listed in the case. The document should also...

Mexico City Bank of Commerce and Industry is a busy bank . Due to different customers needs, it needs to assign a different number of tellers at the counter at different time s of each day . The...

The sample space for tossing a coin three times is: S={HHH, HHT, HTH, THH, TTT, TTH, THT, HTT} Note #1: In your answer that is to be entered in the box below, please do not omit the 0 that comes...

The government has recently come up with an initiative to encourage business enterprise. A business agency has been set up by the government and you have been appointed as the business adviser. Aslam...

Which method produces larger depreciation expenses during the early years of a fixed asser's ife and smaller expenses in the later years. Muriple Choice Double - declining F = O Straight - line....

Alia, the manager of a pet store, notices that most of the goods that come to her store are packed in high - quality cardboard boxes which are later discarded. She comes up with a plan and instructs...

2. Outline the functions of nonverbal communication

5. Make a study of your Facebook (or other social networking) pages. Compile a list of the types of language used, including acronyms. Do you ever misunderstand the language in posts from your...

3. Describe the set of communication symbols that are nonverbal codes