Premium Essay

Biam 500 Week 2 Lab Analysis

In:

Submitted By Sheila224
Words 363
Pages 2
Lab 2 Analysis Sheila Mejia

BIAM 500 Prof. Bruning Keller March 13, 2016

Explain the Solver results you obtained for both the initial problem and your sensitivity analysis. The solver results in the initial analysis in my workbook showed that 333 units of the cc7 and 200 units of the cc8 should be produced in order to obtain the maximum of a little over $5 million in profit while still remaining within the given constraints. The constraints included that that MBI Corporation cannot produce more than 200,000 units in its plant and must remain under an $8million dollar budget. MBI Corp. must also meet marketing constraints of at least producing 100 units of cc7 and 200 units of cc8. In the sensitivity analysis we increases the constraints by ten percent and Solver determined that the optimal units MBI should produce is 110 of cc7 and 46 of cc8. Increasing the constraints decreased the number of units produced and decreased the profit by 31%. Thus, the sensitivity analysis helped determine that the current constraints made for a bigger profit while making staying within budget and satisfying other needs within the corporation. Based on the solver results MDI should not increase the parameters of their constraints, at least not by ten percent.
What did you learn from the exercise and how is it important to businesses? The lab showed me how analyze a word problem and interpret the numbers using a spreadsheet. It also taught me how use Solver in excel; which can be a very viable tool in business. This exercise taught us how to obtain an optimal profit given certain constraints. Every business faces similar constraints, budgetary and inventory constraints were a great example to be used. Accuracy in analyzing data is vital in decision making in all businesses and in order to promote accuracy such tools as the one in

Similar Documents

Premium Essay

Organizational Behavior

...ORGANIZATIONAL BEHAVIOR CONCEPTS CONTROVERSIES APPLICATIONS Seventh Edition Stephen P. Robbins 1996 Contents Part One • Introduction Chapter 1 What Is Organizational Behavior? 2 Chapter 2 Responding to Global and Cultural Diversity 42 Part Two • The Individual Chapter 3 Foundations of Individual Behavior 80 Chapter 4 Perception and Individual Decision Making 130 Chapter 5 Values, Attitudes, and Job Satisfaction 172 Chapter 6 Basic Motivation Concepts 210 Chapter 7 Motivation: From Concepts to Applications 250 Part Three • The Group Chapter 8 Foundations of Group Behavior 292 Chapter 9 Understanding Work Teams 344 Chapter 10 Communication 374 Chapter 11 Leadership 410 Chapter 12 Power and Politics 460 Chapter 13 Conflict, Negotiation, and Intergroup Behavior 502 Part Four - The Organization System Chapter 14 Foundations of Organization Structure 548 Chapter 15 Technology, Work Design, and Stress 588 Chapter 16 Human Resource Policies and Practices 634 Chapter 17 Organizational Culture 678 Part Five - Organizational Dynamics Chapter 18 Organizational Change and Development 714 CHAPTER I • WHAT IS ORGANIZATIONAL BEHAVIOR? What Managers Do Let’s begin by briefly defining the terms manager and the place where managers work—the organization. Then let’s look at the manager’s job; specifically, what do managers do? Managers get things done through other people. They make decisions, allocate resources, and direct the activities of others to attain goals. Managers do...

Words: 146017 - Pages: 585

Premium Essay

Term Paper

...Foreword I do not claim to have read the manuscript Of Changes and Transformations: Bangladesh Bank [July 2009-June 2013] highlighting changes the central bank has gone through in the past four years, but certainly had a cursory look at it. The publication of the book is of great significance at a time when the present government has just completed its four years in office. I welcome this initiative by Bangladesh Bank. I would like to thank Governor Dr. Atiur Rahman and others concerned with the project. The effort put in by the editors and their team of script writers to enrich the volume is certainly praiseworthy. I am extremely delighted to have the opportunity to write few words upon the book. Here I would like to touch upon the key aspects of the revolutionary changes that I have witnessed in Bangladesh Bank during the past four years. Firstly, digitization has taken place rapidly in the central bank and the whole banking sector was quick to follow suit. Secondly, mobile banking has been introduced and expanded significantly. This process will come its fruition with the introduction of PayPal payment system. Thirdly, revolutionary changes have taken place in CSR. Fourthly, Bangladesh Bank has achieved commendable success in financial inclusion program. Bangladesh Bank's role in involving the mass people into financial activities is undeniable. Finally, the establishment of Currency Museum is a great initiative of Bangladesh Bank. I would now like to say a few words on the...

Words: 93727 - Pages: 375