Free Essay

Maths Solver

In: Computers and Technology

Submitted By aisy
Words 1022
Pages 5
BTMP 1013 BUSINESS MATHEMATICS
GROUP ASSIGNMENT

Student Guidelines 1. Each group consist of 5 person per group. Ideally to have mixtures of gender and ethnics in a group. 2. Each group required to learn Linear Programming using Microsoft Excel’s Solver. You may refer to Business Mathematics reference books, video at Youtube or website. 3. Solve the Linear Programming questions using Microsoft Excel’s Solver. You need to print screen each step for each questions and state conclusion. 4. Produce educational video(s) to explain the solution for some questions. You may decide which questions to be recorded. 5. Please submit your assignment in bound. 6. Plagiarism, copying and cheating will NOT be awarded any mark, and disciplinary actions will be taken instead. Any requires/ questions/ problems regarding this assignment should be directed to your lecturer either during lecture or in the consultation hours. 7. The due date to submit this assignment is on 13 November 2015.

Solve the following questions using Microsoft Excel’s Solver. Pick any of the questions and record/take video step by step on how to solve it using Microsoft Excel’s Solver.

1. Minimize C=2x-3y-4z
Subject to
-x+2y-z≤8
x-2y+2z≤10
2x+4y-3z≤12
x≥0, y≥0,z≥0

2. Minimize C=2x+3y
Subject to
8x+y≥80
3x+2y+2z≥100 x+4y≥80 x≥0, y≥0

3. Deluxe River Cruises operates a fleet of river vessels. The fleet has two types of vessels: A type A vessel has 60 deluxe cabins and 160 standard cabins, whereas a type B vessel has 80 deluxe cabins and 120 standard cabins. Under a charter agreement with Odyssey Travel Agency, Deluxe River Cruises is to provide Odyssey with a minimum of 360 deluxe and 680 standard cabins for their 15-day cruise in May. It costs RM 44,000 to operate a type A vessel and RM 54, 000 to operate a type B vessel for that period. How many of each type vessel should be used to keep the operating costs to a minimum? What is the minimum cost?

4. Everest Deluxe World Travel has decided to advertise in the Sunday editions of two major newspaper in town. These advertisements are directed at the three groups of potential customers. Each advertisements in Newspaper I is seen by 70000 Group A customers, 40 000 Group B customers, and 20 000 Group C customers. Each advertisements in Newspaper II is seen by 10000 Group A customers, 20 000 Group B customers, and 40 000 Group C customers. Each advertisement in Newspaper I costs RM 1000, and each advertisement in Newspaper II costs RM 800. Everest would like their advertisement to be read by at least 2 million people from Group A, 1.4 million people from Group B, and 1 million people from Group C. How many advertisements should Everest place in each newspaper to achieve its advertising goals at a minimum cost? What is the minimum cost?

5. The owner of the Health Juice Bar wishes to prepare a low-calorie fruit juice with a high vitamin A and vitamin C content by blending orange juice and pink grapefruit juice. Each glass of the blended juice is to contain at least 1200 International Units (IU) of vitamin A and 200 IU of vitamin C. One ounce of orange juice contains 60 IU of vitamin A, 16 IU of vitamin C, and 14 calories; each ounce of pink grapefruit juice contains 120 IU of vitamin A, 12 IU of vitamin C, and 11 calories. How many ounces of each juice should a glass of the blend contains if it is meet the minimum vitamin requirements while containing a minimum number of calories?

6. Maximize P=6x+5y+4z
Subject to
2x+y+z≤180
x+3y+2z≤300
2x+y+2z≤240
x≥0, y≥0,z≥0 7. Maximize P=x+y+2z+3w
Subject to
3x+6y+4z+2w≤12
x+4y+8z+4w≤16
2x+y+4z+w≤10
x≥0, y≥0,z≥0, w≥0

8. National Business Machines Corporation manufactures two models of fax machines: A and B. Each model A costs RM 100 to make, and each model B costs RM 150. The profits are RM 30 for each model A and RM 40 for each model B fax machines. If the total number of fax machines demanded each month does not exceed 2500 and the company has earmarked no more than RM 600,000/month for manufacturing costs, find how many units of each model National should make each month to maximize its monthly profit. What is the largest monthly profit the company can make?

9. Ashley has earmarked at most RM 250,000 for investment in three mutual funds: a money market fund, an international equity fund, and a growth-and-income fund. The money market fund has a rate of return of 6%/year, the international equity fund has a rate of return of 10%/year, and the growth-and-income fund has a rate of return of 15%/year. Ashley has stipulated that no more than 25% of her total portfolio should be in the growth-and –income fund and that no more than 50% of her total portfolio should be in the international equity fund. To maximize the return on her investment, how much should Ashley invest in each type of fund? What is the maximum return?

10. A company manufactures Product A, B and C. Each product is processed in three department: I,II, and III. The total available labor hours per week for Departments I, II and III are 900, 1080, and 840, respectively. The time requirements (in hours per unit) and profit per unit for each product as follows:

| Product A | Product B | Product C | Department I | 2 | 1 | 2 | Department II | 3 | 1 | 2 | Department III | 2 | 2 | 1 | Profit | RM 18 | RM 12 | RM 15 |

How many units of each product should the company produce to maximize its profit? What is the largest profit the company can realize? Are there any resources left over?…...

Similar Documents

Free Essay

Matlab and Ode Solvers

...Lab 0: MATLAB and ODE Solvers | ME 4173 Robot Kinematics | | | | Introduction The following report will display the results and conclusions of an experiment to simulate the output of an inverse pendulum system in MATLAB. The objectives of this experiment were to review MATLAB programming and using MATLAB to simulate ODEs and systems. Objectives * Examine the basics of MATLAB * Use MATLAB to simulate a system * Use ODE solvers to numerically integrate the system over a set time period Apparatus The apparatus used in this experiment was MATLAB. It was used to provide a simulation environment to analyze the inverse pendulum’s motion. Experiments and Results There were six components of this experiment. This experiment was mostly familiarizing with MATLAB. All code used is illustrated in the Appendix – Code. The first part consisted of learning commands within the MATLAB environment. It was a brief overview of how commands work in MATLAB. There was no code used in the part of the experiment. The second part of the experiment examined how arrays were created and used in MATLAB. The first step was to create a matrix. This matrix was then subjected to various commands including eye( ), zeroes( ), and ones( ). Indexing was also used to access various parts of the matrix. Matrix operations such as transpose, inverse, size and length were also shown. Part three of the experiment explained how a script was created and what it was...

Words: 828 - Pages: 4

Premium Essay

Math

...say whether I was able to learn how to be a better teacher and what the teacher did that I could possibly use in the future. While analyzing and going through the process of this assignment it is helping realize how to become a better teacher as well. I would also like to get more comfortable and experience on using this template of the paper. Memories Of A Teacher My teacher, Mr. G, used many different instructional techniques and approaches to his lessons. Mr. G had taught me math for three years in a row, so I think that I have a good grasp on his approaches to the lessons that he would teach. He would assign many homework assignments, as well as in-class assignments, which helped me and other students understand and get practice with the lesson that we were learning. I think that with math having a lot of homework is a good thing. In my mind, the only way to learn how to do math is plenty of practice. The more you practice, the easier it will be. Mr. G would also have the students do some math problems on the chalk board or smart board to show the class and go over the corrections with the whole class so that everyone would understand the problem. Playing “racing” games also helped and added fun to the class. With the “racing” games, the students would get into groups and have to take turns doing problems on the chalk board and see who could get the correct answer first. It added fun and a little friendly competition to the class. It also helped the students want to......

Words: 1027 - Pages: 5

Premium Essay

Math

...Diana Garza 1-16-12 Reflection The ideas Stein presents on problem saving and just math in general are that everyone has a different way of saving their own math problems. For explains when you’re doing a math problem you submit all kinds of different numbers into a data or formula till something works or maybe it’s impossible to come up with a solution. For math in general he talks about how math is so big and its due in large measure to the wide variety of situations how it can sit for a long time without being unexamined. Waiting for someone comes along to find a totally unexpected use for it. Just like has work he couldn’t figure it out and someone else found a use for it and now everyone uses it for their banking account. For myself this made me think about how math isn’t always going to have a solution. To any math problem I come across have to come with a clear mind and ready to understand it carefully. If I don’t understand or having hard time taking a small break will help a lot. The guidelines for problem solving will help me a lot to take it step by step instead of trying to do it all at once. Just like the introduction said the impossible takes forever. The things that surprised me are that I didn’t realize how much math can be used in music and how someone who was trying to find something else came to the discovery that he find toe. What may people were trying to find before Feynmsn....

Words: 270 - Pages: 2

Premium Essay

Math

...the total number of people reached? Requirement: 1. Formulate the problem. 2. Use Excel Solver to find the answer. Include in your answer the excel file. Problem 2: Transportation/Shipping Problem Transportation or shipping problem involves determining the amount of goods or items to be transported from a number of origins to a number of destinations. The Top Speed Bicycle Co. manufactures and markets a line of 10-speed bicycles nationwide. The firm has final assembly plants in two cities in which labor costs are low, New Orleans and Omaha. Its three major warehouses are located near the large market areas of New York, Chicago, and Los Angeles. The sales requirements for the next year at the New York warehouse are 10,000 bicycles, at the Chicago warehouse 8,000 bicycles, and at the Los Angeles warehouse 15,000 bicycles. The factory capacity at each location is limited. New Orleans can assemble and ship 20,000 bicycles; the Omaha plant can produce 15,000 bicycles per year. The cost of shipping one bicycle from each factory to each warehouse differs, and these unit shipping costs are as follows: TO TO FROM FROM | NEW YORK | CHICAGO | LOS ANGELES | New Orleans | $2 | $3 | $5 | Omaha | 3 | 1 | 4 | The company wishes to develop a shipping schedule that will minimize its total annual transportation costs. Requirement: 1. Formulate the problem. 2. Use Excel Solver to find the answer. Include in your answer the excel file. Problem 3: Portfolio Selection...

Words: 618 - Pages: 3

Free Essay

Solver

...Declaración de variables var y1 binary; var y2 binary; var y3 binary; var y4 binary; var y5 binary; var y6 binary; # Función objetivo minimize objetivo: y1+y2+y3+y4+y5+y6 ; # Restricciones asociadas a la distancia entre ciudades subject to res_ciudad_1: y1+y2 >= 1; subject to res_ciudad_2: y1+y2+y6 >= 1; subject to res_ciudad_3: y3+y4 >= 1; subject to res_ciudad_4: y3+y4+y5 >= 1; subject to res_ciudad_5: y4+y5+y6 >= 1; subject to res_ciudad_6: y2+y5+y6 >= 1; Fichero practica8a.run ### Práctica 8a # Problema del libro de Winston, página 478, ejemplo 5 # Problema de cobertura de conjuntos en formato 1 # Fichero practica8a.run reset; model A:\practica8a.mod; option solver cplex; solve; display objetivo; display y1,y2,y3,y4,y5,y6; Solución obtenida con el programa AMPL: CPLEX 8.0.0: optimal solution; objective 2 4 dual simplex iterations (0 in phase I) objetivo = 2 y1 = 0, y2 = 1, y3 = 0, y4 = 1, y5 = 0, y6 = 0; PRÁCTICA 8B Problema de cobertura de conjuntos, Winston página 478, ejemplo 5, formato2. Fichero práctica8b.mod ### Práctica 8b # Problema del libro de Winston, página 478, ejemplo 5 # Problema de cobertura de conjuntos en formato 2 # Fichero practica8b.mod # Declaración de variables param m; param n; set CLIENTES:=1..m; set SERVIDORES:=1..n; var y{SERVIDORES} binary; # Función objetivo minimize objetivo: sum {j in SERVIDORES} y[j] ; # Restricciones......

Words: 2124 - Pages: 9

Premium Essay

Math

...This article is about the study of topics, such as quantity and structure. For other uses, see Mathematics (disambiguation). "Math" redirects here. For other uses, see Math (disambiguation). Euclid (holding calipers), Greek mathematician, 3rd century BC, as imagined by Raphael in this detail from The School of Athens.[1] Mathematics is the study of topics such as quantity (numbers),[2] structure,[3] space,[2] and change.[4][5][6] There is a range of views among mathematicians and philosophers as to the exact scope and definition of mathematics.[7][8] Mathematicians seek out patterns[9][10] and use them to formulate new conjectures. Mathematicians resolve the truth or falsity of conjectures by mathematical proof. When mathematical structures are good models of real phenomena, then mathematical reasoning can provide insight or predictions about nature. Through the use of abstraction and logic, mathematics developed from counting, calculation, measurement, and the systematic study of the shapes and motions of physical objects. Practical mathematics has been a human activity for as far back as written records exist. The research required to solve mathematical problems can take years or even centuries of sustained inquiry. Rigorous arguments first appeared in Greek mathematics, most notably in Euclid's Elements. Since the pioneering work of Giuseppe Peano (1858–1932), David Hilbert (1862–1943), and others on axiomatic systems in the late 19th century, it has become......

Words: 634 - Pages: 3

Premium Essay

Math

...can see how to split up the original equation into its factor pair, this is the quickest and allows you to solve the problem in one step. Week 9 capstone part 1 Has the content in this course allowed you to think of math as a useful tool? If so, how? What concepts investigated in this course can apply to your personal and professional life? In the course, I have learned about polynomials, rational expressions, radical equations, and quadratic equations. Quadratic equations seem to have the most real life applications -- in things such as ticket sales, bike repairs, and modeling. Rational expressions are also important, if I know how long it takes me to clean my sons room, and know how long it takes him to clean his own room. I can use rational expressions to determine how long it will take the two of us working together to clean his room. The Math lab site was useful in some ways, since it allowed me to check my answers to the problems immediately. However, especially in math 117, it was too sensitive to formatting of the equations and answers. I sometimes put an answer into the math lab that I knew was right, but it marked it wrong because of the math lab expecting slightly different formatting Week 9 capstone part 2 I really didn't use center for math excellence because i found that MML was more convenient for me. I think that MML reassures you that you’re doing the problem correctly. MML is extra support because it carefully walks you through the problem visually......

Words: 662 - Pages: 3

Premium Essay

Lp Solver

...Spreadsheet Chapter 3 C.T. Ragsdale. 2008. Spreadsheet Modeling & Decision Analysis, 5th E. Revised, Thompson 1 Section 1 EXCEL SOLVER 2 Introduction • Solving LP problems graphically is only possible when there are two decision variables • Few real-world LP have only two decision variables • Fortunately, we can now use spreadsheets to solve LP problems 3 LP Solvers • Conventional – MPS (IBM) – LINDO, GINO – GAMS – AMPL • Algebraic Language • Spreadsheet Modeling • The company that makes the Solver in Excel, Lotus 12-3, and Quattro Pro is Frontline Systems, Inc. Check out their web site: http://www.solver.com – Frontline Solver, Premium Solver, Risk Solver – What’s Best? 4 Steps in Implementing an LP Model in a Spreadsheet 1. Organize the data for the model on the spreadsheet. 2. Reserve separate cells in the spreadsheet for each decision variable in the model. 3. Create a formula in a cell in the spreadsheet that corresponds to the objective function. 4. For each constraint, create a formula in a separate cell in the spreadsheet that corresponds to the left-hand side (LHS) of the constraint. 5 The Simple Farm Model Again! max π = x1 + 1.5x2 s/t x1 + 2x2 ≤ 160 3x1 + 2x2 ≤ 240 x1 ≥ 0, x2 ≥ 0 6 Implementing the Model See file FarmEx original.xls 7 Cell Labels 8 How Solver Views the Model • Target cell - the cell in the spreadsheet that represents the objective function • Changing cells - the cells in......

Words: 2610 - Pages: 11

Free Essay

Math

...Sample Exam 2 - MATH 321 Problem 1. Change the order of integration and evaluate. (a) (b) 2 0 1 0 1 (x y/2 + y)2 dxdy. + y 3 x) dxdy. 1 0 0 x 0 y 1 (x2 y 1/2 Problem 2. (a) Sketch the region for the integral f (x, y, z) dzdydx. (b) Write the integral with the integration order dxdydz. THE FUNCTION f IS NOT GIVEN, SO THAT NO EVALUATION IS REQUIRED. Problem 3. Evaluate e−x −y dxdy, where B consists of points B (x, y) satisfying x2 + y 2 ≤ 1 and y ≤ 0. − Problem 4. (a) Compute the integral of f along the path → if c − f (x, y, z) = x + y + yz and →(t) = (sin t, cos t, t), 0 ≤ t ≤ 2π. c → − → − → − (b) Find the work done by the force F (x, y) = (x2 − y 2 ) i + 2xy j in moving a particle counterclockwise around the square with corners (0, 0), (a, 0), (a, a), (0, a), a > 0. Problem 5. (a) Compute the integral of z 2 over the surface of the unit sphere. → → − − → − → − − F · d S , where F (x, y, z) = (x, y, −y) and S is → (b) Calculate S the cylindrical surface defined by x2 + y 2 = 1, 0 ≤ z ≤ 1, with normal pointing out of the cylinder. → − Problem 6. Let S be an oriented surface and C a closed curve → − bounding S . Verify the equality → − → − → → − − ( × F ) · dS = F ·ds − → → − if F is a gradient field. S C 2 2 1 ...

Words: 254 - Pages: 2

Free Essay

Math

...and solve problems in everyday life”. In my everyday life I have to keep the balance in my check book, pay bills, take care of kids, run my house, cook, clean etc. With cooking I am using math, measuring how much food to make for four people (I still haven’t mastered that one). With bills I am using math, how much each company gets, to how much money I have to spare (which these days is not much). In my everyday life I do use some form of a math. It might not be how I was taught, but I have learned to adapt to my surroundings and do math how I know it be used, the basic ways, none of that fancy stuff. For my weakest ability I would say I fall into “Confidence with Mathematics”. Math has never been one of my favorite subjects to learn. It is like my brain knows I have to learn it, but it puts up a wall and doesn’t allow the information to stay in there. The handout “The Case for Quantitative Literacy” states I should be at ease with applying quantitative methods, and comfortable with quantitative ideas. To be honest this class scares the crap out of me, and I am worried I won’t do well in this class. The handout also says confidence is the opposite of “Math Anxiety”, well I can assure you I have plenty of anxiety right now with this class. I have never been a confident person with math, I guess I doubt my abilities, because once I get over my fears and anxiety I do fine. I just have to mentally get myself there and usually it’s towards the end of the class. There are......

Words: 418 - Pages: 2

Free Essay

Problem Solver

...Problem Solver I chose problem solver because I have realized in my life that is what I love to do. I love to solve problems. I have a hard time practicing or participating in activities that don’t have a sense of purpose. But if there is a problem, I obsess over it until it is resolved. The problem that I decided to put through the five step process was with the problem I had after graduating with my B.S. degree. I graduated in December of 2011, right in the middle of so many problems with people being able to get jobs. At the time I was working in a field that I would say was about 20% related to my degree. My degree is in Electronics Engineering and I was working in a power plant, however it was a methane gas power plant and the majority of what I did was mechanical maintenance. Not liking where I was and not able to get more than a few interviews, I was stuck. Either I was too qualified, the job didn’t pay enough, or I was under qualified. Step 1: The main problem was job placement, there were many factors but in the end I was not in a place that I wanted to be in my career. Step 2: The causes were many, as I mentioned earlier. * Under/over qualified * Weak jobs market * Pay associated with available jobs * Nowhere to go with current job, or lack of desire to do so I also at this time began to realize that I didn’t like where my experience was taking me. I had now worked in two jobs that were in an industrial setting, (large machinery, noisy, dirty...

Words: 623 - Pages: 3

Free Essay

How to Use Solver Spanish

...Instrucciones de EXCEL Solver Octubre de 2000 2 La opción Solver de EXCEL sirve para resolver problemas de optimización lineal y no lineal; también se pueden indicar restricciones enteras sobre las variables de decisión. Con Solver es posible resolver problemas que tengan hasta 200 variables de decisión, 100 restricciones explícitas y 400 simples (cotas superior e inferior o restricciones enteras sobre las variables de decisión). Para acceder a Solver, seleccione Tools en el menú principal y luego Solver. La ventana con los parámetros de Solver aparecerá tal y como se muestra a continuación: 3 Cuadro de diálogo de los parámetros de Solver La ventana Solver Parameters se utiliza para describir el problema de optimización a EXCEL. El campo Set Target Cell contiene la celda donde se encuentra la función objetiva correspondiente al problema en cuestión. Si desea hallar el máximo o el mínimo, seleccione Max o Min. Si la casilla Value of está seleccionada, Solver tratará de hallar un valor de la celda igual al valor del campo que se encuentra a la derecha de la selección. El cuadro de diálogo By Changing Cells contendrá la ubicación de las variables de decisión para el problema. Por último, las restricciones se deben especificar en el campo Subject to the Constraints haciendo clic en Add. El botón Change permite modificar las restricciones recién introducidas y Delete sirve para borrar las restricciones precedentes. Reset All borra el problema en curso y restablece......

Words: 1383 - Pages: 6

Premium Essay

Linear Programming-Using Solver in Excel

...Linear Programming: Using Solver in Excel Linear Programming was conceptually developed before World War II by the outstanding Russian mathematician A.N.Kolmogorov and gained its popularity ever since the development of Simplex method by George B. Dantzig in 1947. Linear programming deals with problems of maximizing or minimizing a linear function in the presence of linear equality and/or inequality constraints. In these problems, we find the optimal, or most efficient way of using limited resources to achieve the objective of the situation. Linear Programming enables users to model large and complex problems and solve in a short amount of time by the use of effective algorithm, hence it is a powerful and widely used tool in various fields such as science, industrial engineering, financial planning and management decision making. Nowadays, with the development of technology, most of the real world Linear Programming problems are solved by computer programs. Excel Solver is a popular one. We work through different examples to demonstrate the applications of linear Programming model and the use of Excel Solver for various decision making in operation and supply chain management. Components of Linear Programming model To solve the linear programming problems, we first need to formulate the mathematical description called a mathematical model to represent the situation. Linear programming model usually consists of the following components * Decision variables: These......

Words: 2395 - Pages: 10

Premium Essay

Solver, Vlookup & What-If Analysis

...Solver: A solver is a generic term indicating a piece of mathematical software, possibly in the form of a stand-alone computer program or as a software library, that 'solves' a mathematical problem. A solver takes problem descriptions in some sort of generic form and calculates their solution. In a solver, the emphasis is on creating a program or library that can easily be applied to other problems of similar type. Types of problems with existing dedicated solvers include: * Linear and non-linear equations. In the case of a single equation, the "solver" is more appropriately called a root-finding algorithm. * Systems of linear equations. * Nonlinear systems. * Systems of polynomial equations, which are a special case of non linear systems, better solved by specific solvers. * Linear and non-linear optimisation problems * Systems of ordinary differential equations * Systems of differential algebraic equations * Logic/satisfiability problems * Constraint satisfaction problems * Shortest path problems * Minimum spanning tree problems * Search algorithms Excel Solver, introduced by Microsoft in 1991, is a powerful optimization application used in finance, production, distribution, purchasing and scheduling. It is part of the data analysis tools used for what-if analysis--a process of identifying changes in a cell by adjusting related cells. If your boss has asked you to find ways to increase company's profits by......

Words: 3603 - Pages: 15

Premium Essay

Math

...on a word file. Also, submit an Excel model showing your answers. Solution: By using solver, we get 2 different optimal solutions whose minimum costs are both 4470. Under optimal policy, Suppliers 1,3,5,7 or Suppliers 1,2,3,6,7 should be Mars’s suppliers in the first round. Because of the limitation in the case , for mars, the less the suppliers, the better. Finally, Mars should choose Supplier 1,3,5,7--- four suppliers----to meet its needs. I need to impose integer constraints. Question 2 [Examining the optimal solution] The M&M product manager has indicated that the demand for medium M&M display boxes might increase substantially. If that happens, instead of one 1500 medium package, Mars will need two 1500 medium packages. However, the manager will defer to the next procurement cycle (instead, he will encourage retailers to buy other Mars products) if the total cost of procurement exceeds $5000. Is it possible to come up with an allocation plan that achieves this goal? Or should the additional order of 1500 medium boxes be delayed to the next cycle? What to submit: Write your answers on a word file. Please do not submit the Excel file. In fact, try to answer this question without resolving the problem. Solution: First cycle, In the first cycle,we changed M&M’s demand for medium boxes package from 1 to 2 and keep other conditions the same.After running the solver ,we found that the minimize cost was 5469 which is more than 5000.Then Mars must......

Words: 1317 - Pages: 6