Premium Essay

Lpp Through Excel

In:

Submitted By pankajimtcdl
Words 798
Pages 4
Data Analysis and
Business Decision Making
Session – IV
Chapter 11: Linear Programming
Chapter 12: Transportation, Transshipment, and
Assignment Problems
Chapter 13: Decision Analysis
Faculty
Pankaj Dutta

Chapter – 11
Linear Programming
LPP solution through Excel Solver:
The Steps in Implementing an LP Model in a Spreadsheet:
1.
2.
3.
4.

Organize the data for the model on the spreadsheet.
Reserve separate cells in the spreadsheet for each decision variable in the model.
Create a formula in a cell in the spreadsheet that corresponds to the objective function.
For each constraint, create a formula in a separate cell in the spreadsheet that corresponds to the left-hand side (LHS) of the constraint. PANKAJ DUTTA IMTCDL

Chapter – 11
Linear Programming
LPP solution through Excel Solver:

Max
Z = 350X1 + 300X2
Subject To
1X1 + 1X2 ≤ 200
9X1 + 6X2 ≤ 1566
12X1+16X2 ≤ 2880
X1 , X 2 ≥ 0

1. Organize the data for the model on the spreadsheet.

PANKAJ DUTTA IMTCDL

Chapter – 11
Linear Programming
LPP solution through Excel Solver:

Max
Z = 350X1 + 300X2
Subject To
1X1 + 1X2 ≤ 200
9X1 + 6X2 ≤ 1566
12X1+16X2 ≤ 2880
X1 , X 2 ≥ 0

1. Organize the data for the model on the spreadsheet.
Changing cells

Target cell

PANKAJ DUTTA IMTCDL

Constraint cells

Chapter – 11
Linear Programming

Max
Z = 350X1 + 300X2
Subject To
1X1 + 1X2 ≤ 200
9X1 + 6X2 ≤ 1566
12X1+16X2 ≤ 2880
X1 , X 2 ≥ 0

LPP solution through Excel Solver:
1. Organize the data for the model on the spreadsheet.

– Target cell - the cell in the spreadsheet that represents the objective function – Changing cells - the cells in the spreadsheet representing the decision variables – Constraint cells - the cells in the spreadsheet representing the LHS formulas on the constraints

PANKAJ DUTTA IMTCDL

Chapter – 11
Linear Programming

Similar Documents

Premium Essay

Cases

...the constraints are the total of individual contribution of respective activities. If this is not a reasonable function, we have to assume non- linear model. 3) Divisibility: In Linear Programming it is assumed that the objective functions and constraint expressions are continuous. Integer Programming Model is used where the round off of the decision variable values in Linear Programming solution may not give the optimum integer solution. 4) or Technology coefficient Certainty: In LP the values of each coefficient i.e. Profit, Cost is fixed as a constant. 5) Infinite Choice: In Linear Programming solution there are infinite choices available to decide the level of activities. Formulation of LPP Decision Variables: It is one of the important step in LPP and if defined properly it can convert non-linear problems into linear problems. To define the functions for objectives and constraints in terms of mathematical statements it is necessary to sate the variables explicitly. Decision Variables are as follows:- X1 = | No. of Butterscotch Cones Sold. | X2 = | No. of Butterscotch Cups Sold. | X3 = | No. of Butterscotch Family Packs Sold. | Y1 = | No. of Chocolate Cones Sold. | Y2 = | No. of Chocolate Cups Sold. | Y3 = | No. of Chocolate Family Packs Sold. | A1 = |...

Words: 811 - Pages: 4

Free Essay

Abcd

...Shanti Business School PGDM Batch 2015-17 Semester II Course Outline 1 Shanti Business School, Ahmedabad PGDM 2015-17: Program Structure Semester-1 Semester-2 Semester-3 Semester-4 Course credit Course credit Course credit Language Skills @ Written Analysis & Communication @ Soft skills II @ Employability Skills @ IT & MIS 2 Soft skills I @ Computing skills 2 Social Media Marketing @ 2 Legal Aspects of Business 2 Business Strategy 3 Management Control Systems 3 Micro Economics 3 Macro Economics 3 Business Environment 3 Business Ethics & Corporate Governance 2 Quantitative Methods-1 3 Business Research Methods 3 Quantitative Methods-2 3 Core Elective-1 3 Core Elective1 3 Core Elective-2 3 Core Elective2 3 Elective-1 3 Elective-1 3 Elective-2 3 Elective-2 3 Grand Project-1 3 Grand Project-2 3 Principles of Management Basic Building Blocks Autumn Break Executive Skills Organisational Behavior Human Resources Management 3 Marketing Management 1 3 Marketing Management -2 3 Understanding Financial Statements 3 Financial Mgt 3 Operation Management Management Domain 3 3 Basics of Business Planning 2 Electives Credits Autumn Break credit SUMMER INTERNSHIP Course ...

Words: 7010 - Pages: 29

Premium Essay

Mba Syllabus

...ITM UNIVERSITY UPARWARA, NEW RAIPUR Syllabus for MASTER OF BUSINESS ADMINISTRATION EFFECTIVE FROM THE SESSION: 2012-2013 Semester –I ITM UNIVERSITY, NEW RAIPUR Master of Business Administration Semester –I List of subject for Academic Session 2012 – 13. Serial No. 1. 2. 3. 4. 5. 6. 7. 8. List of Subjects Principles of Management Managerial Economics Financial Accounting Environment Management Quantitative Techniques Business Legislation Communication Skills- I Computers for Managers ITM UNIVERSITY, RAIPUR Master of Business Administration Subject: Principles of Management Semester-I Unit I Introduction - Nature, function, definition and importance of management, Definition, nature, purpose and scope of management, Functions of a manager, an overview of planning, organizing, staffing leading and controlling. Is management a science or art? Unit II Development of Management Thought - Scientific management; Contribution of Taylor, Fayol, Mary Follet, Elton Mayo; Hawthorne experiments, Contingency approach, Indian heritage in production and consumption. Management and administration, Management as a profession, Professionalism of management in India, Management ethics and management culture, Skills required of manager, Classification of skills, Methods of skills development. Unit III Management Planning - Concept of planning, objectives, Nature, Types of plan, Stages involved in planning, Characteristics of a good plan, Importance, Limitations of planning, Making...

Words: 3209 - Pages: 13

Premium Essay

Links

...RULES AND REGULATIONS OF M.B.A. PROGRAMME – 2010 The Master of Business Administration (M.B.A.) is a Post-Graduate course offered as: I. II. Two-year i.e., four semester Full time Day programme Three year, i.e., six semester Part-time programme offered to Working Executives and employees. 1. ELIGIBILITY CONDITIONS 1.1 M.B.A. (Day) Candidate seeking admission into Full Time M.B.A. (Day) programme must be: 1. Bachelor degree holder of Osmania University or a degree recognized by the university as equivalent thereto and /(or) as per the rules laid down by the University; 2. The candidate seeking admission must qualify in the Entrance Examination, conducted by the appropriate authority in the year of admission as per the norms prescribed by the University. 3. The admission of Non-resident Indians and candidates admitted in lieu of them will be as per the University Rules in force on the date of the admission. 4. Foreign candidates’ admission is based on the Screening Process of the University currently in vogue. 1.2 M.B.A. (Evening) Candidate seeking admission into Part-Time M.B.A. (Evening) Programme has to satisfy the following Conditions: 1. Must be a Bachelor Degree holder of Osmania University or a Degree recognized by the university as equivalent thereto and/ (or) as per the Rules laid down by the University. 2. The candidate seeking admission must qualify in the entrance examination conducted by the appropriate authority in the year of admission as per the norms prescribed...

Words: 20223 - Pages: 81

Premium Essay

Case Study

...First Semester Curriculum MBA (Full Time) 2 Yrs. Program of D.A.V.V., Indore For Affiliated Institutions 1 DEVI AHILYA VISHWAVIDYALAYA, INDORE MASTER OF BUSINESS ADMINISTRATION (MBA) CURRICULUM FOR FULL-TIME COURSES FIRST YEAR First Semester SUBJECT CODE LIST OF SUBJECTS FT 101C FT 102C FT 103C FT 104C FT 105C FT 106C FT 107C FT 108C Management Principles and Practices Mathematics and Statistics for Managers Accounting for Managers IT and E-Business Fundamentals Business Environment Organization Behavior and Processes Business Communication Business Legislation 1-2 3-4 5-6 7-8 9-10 11-12 13-14 15-16 COURSES AND SYLLABUS FOR SECOND, THIRD AND FOURTH SEMESTER SHALL BE COMMUNICATED LATER. 2 FT-101C MANAGEMENT PRINCIPLES AND PRACTICES Course Objective The objective of this course is to help the students gain understanding of the functions and responsibilities of the manager, provide them tools and techniques to be used in the performance of the managerial job, and enable them to analyze and understand the environment of the organization. Examination The faculty member will award internal marks out of 20 (8 for Tests and 12 for class participation). The semester examination carrying 80 marks will have two sections A and B. Section A worth 60 marks will have 6 theory questions out of which students will be required to attempt any four questions. Section B carrying 20 marks will contain one or more cases. Cases prescribed below are only for classroom...

Words: 8599 - Pages: 35

Free Essay

Nit-Silchar B.Tech Syllabus

...NATIONAL INSTITUTE OF TECHNOLOGY SILCHAR Bachelor of Technology Programmes amï´>r¶ JH$s g§ñWmZ, m¡Úmo{ à VO o pñ Vw dZ m dY r V ‘ ñ Syllabi and Regulations for Undergraduate PROGRAMME OF STUDY (wef 2012 entry batch) Ma {gb Course Structure for B.Tech (4years, 8 Semester Course) Civil Engineering ( to be applicable from 2012 entry batch onwards) Course No CH-1101 /PH-1101 EE-1101 MA-1101 CE-1101 HS-1101 CH-1111 /PH-1111 ME-1111 Course Name Semester-1 Chemistry/Physics Basic Electrical Engineering Mathematics-I Engineering Graphics Communication Skills Chemistry/Physics Laboratory Workshop Physical Training-I NCC/NSO/NSS L 3 3 3 1 3 0 0 0 0 13 T 1 0 1 0 0 0 0 0 0 2 1 1 1 1 0 0 0 0 4 1 1 0 0 0 0 0 0 2 0 0 0 0 P 0 0 0 3 0 2 3 2 2 8 0 0 0 0 0 2 2 2 2 0 0 0 0 0 2 2 2 6 0 0 8 2 C 8 6 8 5 6 2 3 0 0 38 8 8 8 8 6 2 0 0 40 8 8 6 6 6 2 2 2 40 6 6 8 2 Course No EC-1101 CS-1101 MA-1102 ME-1101 PH-1101/ CH-1101 CS-1111 EE-1111 PH-1111/ CH-1111 Course Name Semester-2 Basic Electronics Introduction to Computing Mathematics-II Engineering Mechanics Physics/Chemistry Computing Laboratory Electrical Science Laboratory Physics/Chemistry Laboratory Physical Training –II NCC/NSO/NSS Semester-4 Structural Analysis-I Hydraulics Environmental Engg-I Structural Design-I Managerial Economics Engg. Geology Laboratory Hydraulics Laboratory Physical Training-IV NCC/NSO/NSS Semester-6 Structural Design-II Structural Analysis-III Foundation Engineering Transportation Engineering-II Hydrology &Flood...

Words: 126345 - Pages: 506