Free Essay

Maths Solver

In: Computers and Technology

Submitted By aisy
Words 1022
Pages 5

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≥0, y≥0,z≥0

2. Minimize C=2x+3y
Subject to
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
x≥0, y≥0,z≥0 7. Maximize P=x+y+2z+3w
Subject to
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

Premium Essay

Case Study Merton Truck

...Mathematical Programming Add-in constructs models that can be solved using the Solver Add-in or one of the solution add-ins provided in the collection. When the Math Programming add-in is installed, several new command lines are added to the OR_MM menu. The menu items under the title Math Programming create models of the different types. Selecting an item from this list causes a dialog box to be presented which constructs a mathematical programming model. The models created by the add-in are solved with the Excel Solver, the Jensen Network Solver or the Jensen LP/IP Solver. All are Excel add-ins. Documentation for these programs can be reached by clicking the links on the lower left. The Solver add-in comes with Excel, and it can solve linear programming, integer programming and nonlinear programming models. The Math Programming add-in automatically builds Solver models and calls the computational procedures that solve the problems. All four model types can be can be solved in this way. The Jensen LP/IP Solver solves linear or integer programming problems. It is available for the Linear/Integer Programming and Network Flow Programming model types. The Jensen Network Solver can solve pure or generalized network flow models. Both linear and integer problems can be solved. It is available for the Network Flow Programming or Transportation model types. Parametric analysis can be applied to any of the math programming models. Here one parameter is allowed to vary within a......

Words: 12583 - Pages: 51

Free Essay


... x ◦ π Decimals Exponents & Radicals Percents Mean, Median & Mode ( 2x2√ ab3 )( 3x√ a3b3 ) Examples » Algebra Matrices & Vectors Functions & Graphing Geometry (new) Go ( 2√ Solving 2x 3 ab )( 3x√ a3b3 ) ( Solve f ( x ) = 2x 2 √ ab3 )( 3x√ a3b3 ) instead » Solution Trigonometry Calculus Statistics ( 3x√ a3b3 )( 2x2√ ab3 ) = 6x3√ ab3 √ a3b3 « Hide Steps Related Symbolab blog posts Steps Practice Makes Perfect ( 3x√ a3b3 )( 2x2√ ab3 ) Learning math takes practice, lots of pra  Just like running, it takes practice and Remove parentheses: = 2 · 3x x√ ab 2 2 3 2 = 6x 3 1+2 all types of math, you need... 2· 3=6 √ a 3b 3 Apply exponent rule: x x= x dedication.    If you want to be really goo √ a 3b 3 3 Multiply the numbers: = 6x x√ ab (a) = a = x b c a · a =a My Notebook, the Symbolab way b+c 3 Math notebooks have been around for hundreds of years.  You write down prob √ ab3 √ a3b3 Save solutions and notes to go back to when your homework or studing  for an exam. feedback And a a loalt memer, ​ enjo excluive enefit crafted epeciall for our reort ta. DICOVR & JOIN Examples −x + 3 > 2x + 1 2 ax + bx + c = 0 Line ( 1, 2...

Words: 403 - Pages: 2

Premium Essay


...TI-84 Plus TI-84 Plus Silver Edition Guidebook Important Information Texas Instruments makes no warranty, either express or implied, including but not limited to any implied warranties of merchantability and fitness for a particular purpose, regarding any programs or book materials and makes such materials available solely on an "as-is" basis. In no event shall Texas Instruments be liable to anyone for special, collateral, incidental, or consequential damages in connection with or arising out of the purchase or use of these materials, and the sole and exclusive liability of Texas Instruments, regardless of the form of action, shall not exceed the purchase price of this product. Moreover, Texas Instruments shall not be liable for any claim of any kind whatsoever against the use of these materials by any other party. © 2005 Texas Instruments Incorporated Windows and Macintosh are trademarks of their respective owners. ii USA FCC Information Concerning Radio Frequency Interference This equipment has been tested and found to comply with the limits for a Class B digital device, pursuant to Part 15 of the FCC rules. These limits are designed to provide reasonable protection against harmful interference in a residential installation. This equipment generates, uses, and can radiate radio frequency energy and, if not installed and used in accordance with the instructions, may cause harmful interference to radio communications. However, there is no guarantee that......

Words: 27513 - Pages: 111

Free Essay

Feeling Hungry

...1 A User’s Guide to Learning Styles and Math Tools T he journey of developing this book began almost five years ago. After over sixty combined years of service in schools, two of us—John R. Brunsting and Terry Walsh—were coming to the end of our careers as mathematics instructors and administrators. For most of those sixty years, we had the pleasure of working together in Hinsdale Central High School in Hinsdale, Illinois, where we met Harvey Silver and were introduced to the Thoughtful Classroom professional development model he designed with Richard Strong. What we quickly came to learn is that the Thoughtful Classroom really works. Whenever we implemented Thoughtful Classroom strategies in our classrooms or worked with other teachers to help them implement Thoughtful Classroom strategies in their own classrooms, the effect on student learning was palpable—students became more engaged, discussions got richer, student thinking went deeper, and test scores went up. There was, however, one particular Thoughtful Classroom text that always seemed to make the biggest difference in classrooms in the shortest amount of time. That text was Tools for Promoting Active, In-Depth Learning (Silver, Strong, & Perini, 2001; Silver, Strong, & Commander, 1998). The idea behind Tools for Promoting Active, InDepth Learning is simple. It is a collection of classroom-tested tools, or simple teaching “moves,” that teachers can use to foster active, in-depth learning. These tools are based on......

Words: 6303 - Pages: 26

Premium Essay

The in Covenant Truth

...Functions and Inequalities Course: Integrated Math 6 Brief Summary of Unit: In this unit, students will learn to represent and analyze the relationships between two variables using functions. Additionally, students will write, graph, and solve one-variable inequalities. Textbook Correlation: Glencoe Math Course 1 Chapter 8 Time Frame: 3 weeks WSD Overarching Essential Question Students will consider… ● ● ● ● ● ● ● ● ● ● ● ● ● ● How do I use the language of math (i.e. symbols, words) to make sense of/solve a problem? How does the math I am learning in the classroom relate to the real-world? What does a good problem solver do? What should I do if I get stuck solving a problem? How do I effectively communicate about math with others in verbal form? In written form? How do I explain my thinking to others, in written form? In verbal form? How do I construct an effective (mathematical) argument? How reliable are predictions? Why are patterns important to discover, use, and generalize in math? How do I create a mathematical model? How do I decide which is the best mathematical tool to use to solve a problem? How do I effectively represent quantities and relationships through mathematical notation? How accurate do I need to be? When is estimating the best solution to a problem? WSD Overarching Enduring Understandings Students will understand that… ● ● ● ● Mathematical skills and understandings are used to solve real-world problems. Problem solvers examine and critique arguments......

Words: 1243 - Pages: 5

Free Essay

Mat 540 Stateline

...2                        29 | AllentownCapacity(barrels) | 22                       16                   18                        3865                       80                  105 | Math Tutorial     1 1.  I treat this problem similar to a transportation problem for optimization.  In this case we want to find routes which will minimize the cost of transportation of the 6 plants to the 3 waste disposal sites.  The following table represents cost and capacity. for the above table let, quantity of waste transported from the plant to the waste center, where hence we want to minimize the objective function which is subject to the following constraints, All products provided by Lil-Help are intended for academic resource and research only.  These are not designed to replace student personal work and rules and regulations from schools, colleges, and universities should be applied when using our services.  Customers are responsible for understanding and adhering to plagiarism rules and Lil-Help is not responsible for inappropriate use of products. | White water | LosCanos | Duras | Kingport | 35 | | | Danville | | | 26 | Macon | | | 42 | Selma | 1 | 52 | | Columbus | 29 | | | Allentown | | 28 | 10 | Dummy | | | 27 | Math Tutorial     2 2.  Using the excel...

Words: 815 - Pages: 4

Free Essay

Innocentive Business Model

...The Company, organization or individual who is looking for an answer to a problem or a question. • The “Solver” – Individuals who are willing to answer to the questions or problems, usually giving a good solution based on experience or their idea • The “Observer” –Though this does not appear on their company page, INNOCENTIVE acts as a moderator to guide the two parties. The “Seeker” (it can be a corporation, governmental entity, nonprofit organization or partners) registers to INNOCENTIVE site and sets: 1. The question or problem to ask, 2. Set the amount of reward when the problem is answer to the “solver” 3. And, set the deadline, by when the problem would like to be solved. The “Seeker” will also pay a fee each time the problem is posted. The amount of the reward will be decided by the “Seeker” and INNOCENTIVE, based on such criteria as how effective the answer/idea was, or by how much profit it would bring to the “Seeker”. On the other hand, the uniqueness of this model is that the “Solver” and the “Seeker” remains anonymous, and the “Solver” could have various backgrounds not necessarily linked with the “Seeker’s industry. This has been proven effective in the past when the 2007 Exxon oil spill removal method was suggested on the site by an individual from a totally different industry to that of the oil industry. There are chances where the “Solver” could be a competitor, or...

Words: 1966 - Pages: 8

Free Essay

Going Green the operation of the power generating stations, preventative maintenance and component assembly. Responsible for Using a Variety of Equipment to Move Products Maintain a Safe Warehouse Area Taking Inventory of ProductsDetail-oriented Assembler Worker highly efficient in leading shipping and receiving operations. Able to lift 75 Hardworking Warehouse Worker with 5 years experience in a warehouse pick/pack fulfillment and distribution environment. pounds. Flexible schedule and available for all shifts. Highlights Shipping and receiving Safety-oriented Multi-tasker Safety-conscious Customer-service focused Strong communication skills Natural leader Exceptional problem solver Manufacturing background Valid MissouriDetermined driver's license Adaptable Basic math skills Lifts up to 75 pounds Exceptional problem solver Accomplishments Earned a perfect attendance record for 2 years in a row. Prepared pallets by following prescribed stacking arrangement and properly tagging pallets. Assembled product containers and crates. Experience Assembly Worker 02/2010 to 09/2014 Acrux Personnel Saint Louis, MO Staffing for various locations in a warehouse with standing, lifting, bending for various hours. Unloaded, picked, staged and loaded products for shipping. Conducted monthly, quarterly and yearly inventories of warehouse stock. Oversaw warehousing and storage practices and housekeeping. Followed proper selection procedures as established by the company. General Labor 12/2007 to......

Words: 309 - Pages: 2

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

Free Essay

College Essay use of the opportunity get.Optimistic and a good attitude towards my work.Very friendly and i understand my responsibilities and obligations and i like to be well aware the current affair. EDUCATION & QUALIFICATION: Master of Human Resources Management (MHRM) 2013 to 2015 Institute of Administrative Sciences ,University of the Punjab, Lahore Major: Management Bachelor in Arts (B.A) 2011 to 2013 Bahaudin Zikrya University,Multan Major: Economics, Statistics Pre-Engineering (FSC) 2007 to 2009 Board of Intermediate & Secondary Education, Multan Major: Maths, Chemistry, Physics Matriculation (SSC) 2005 to 2007 Board of Intermediate & Secondary Education, Multan Major: Maths, Chemistry, Physics WORK EXPERIENCE: * Internhsip in HR department of mobilink head office lahore from August 2014 till October 2014 * Internship at Tracon services pvt ltd lahore from June till August 2015. * Internship in HR department at MCB bank head office lahore from August 2015 till october 2015 COMPUTER SKILLS: * Internet & E-mail. * Computer skills. Proficient user...

Words: 313 - Pages: 2

Premium Essay

Illustration Essay years, I often had poor school days not always as good as they seemed because the lack of a caring teacher, however, when my previous supportive, loving teacher came in my presence it made my day better. For example, I remember a typical day at school when I was struggling with solving a math problem. I did not have any idea or thought on what steps I should take in order to get an accurate answer. As I sat there for about five minutes, searching for examples to gain an understanding of the concept, I still had no answer to the problem. However, when my teacher, Ms. Lau had acknowledged the problem I encountered, she took the initiative to assist me not only with that particular problem, but in general. Ever since that incident, my teacher has been an outstanding support system for me. She has helped me in ways that aid me to figure out how to solve problems effectively when I approached them. During the next couple of days, when I was given an assignment, I was able to use strategies she had taught me previously. The strategies she provided were helpful. I learned to apply them to conflicts I faced in math. Because of my teacher Ms. Lau, I became a more successful problem solver and began to build more confidence in my work. After a few weeks of school, I began to feel confident going to school and performing well in class; thanks to my teacher for being so great in assisting me. Her...

Words: 873 - Pages: 4

Premium Essay

Perceptual Blocks

...can be just as bad as not enough information. You can become overloaded with minute details and unable to sort out critical aspects of the problem. Ex. When trying to solve a word problem minute details can distract you from the actual problem. Emotional blocks Fear of risk taking- fear of making a mistake due to childhood teachings, being rewarded for doing right and punished for doing wrong. Ex. Not trying out for a sport team because you’re afraid of not making the team. Lack of appetite for chaos- problem solvers must learn to live with confusion. The best solution may seem contradictory. Ex. When solving math problems using equations, you just have to accept it. Judging rather than generating ideas- problems can stem from approaching problem with negative attitudes. Ex. When trying to learn how to do geometry you have a hard time because you keep telling yourself “it’s too hard” and “I can’t do it”. Lack of challenge- sometimes problem solvers don’t want to get started because they perceive the problem as being too trivial and easily solved. Ex. Someone who thinks they know everything may not start on homework until last minute because they think it’s so easy they’ll get it done in no time. Inability to incubate- rushing to solve a problem just to get it off your mind can create blocks. Ex. You might have a big paper do and you’re having a hard time getting it done so you just jump into it and end up stuck...

Words: 721 - Pages: 3

Premium Essay

Tree Value

...1997 Introduction In any introductory mathematics course designed for non-mathematics majors, it is important for the student to understand and apply mathematical ideas in a variety of contexts. With the increased use of advanced software in all fields, it is also important for the student to effectively interact with the new technology. Our goal is to integrate these two objectives in a supplement for the text Finite Mathematics and Its Applications, by Goldstein, Schneider, and Siegel. The package consists of interactive tutorials and projects in an Excel workbook format. The software platform used is the Microsoft Excel 5.0 spreadsheet. It was chosen for the following reasons: • • • suited to applications encountered in a finite math course widespread use outside of academia ease of creating reports with a professional look Use of Excel 5.0 was put into effect in the author's sections of the Finite Mathematics II course in the Spring 1996 semester. It was expanded to cover the Finite Mathematics I course for the Fall semester of 1996. Using a combination of specially designed projects and tutorials, students are able to analyze data, draw conclusions, and present their analysis in a professional format. The mathematical and computer skills learned with such an approach is an asset that they can carry with them to other courses as well as to their future places of employment. 2 Scope of supplement The package is divided into three portions - introduction......

Words: 3176 - Pages: 13

Premium Essay

Benefit of Quantitative Reasoning

...nation a float and ahead of the rest. With the introduction of Quantitative Reasoning we will be able to pull out of this economic disaster we are currently living in today. Quantitative Reasoning is a course we are required to take halfway through the MBA program at the University of Phoenix. It applies quantitative reasoning skills to business problems. During which we will learn to analyze data using a variety of analytical tools and techniques. It combines many areas of study such as, formulas, visual representations of quantities, time value of money, and measures of uncertainty. The diversity of this course challenges our critical thinking, reasoning, and problem solving skills we will need to succeed in later course. It uses math formulas that will be critical for accounting. Visual representation of quantities used in statistics and economics. As well as time value of money used in economics and finance courses. The Quantitative Reasoning for Business simply is an overview of the economic, finance, accounting, and research courses we will study after using the skills learned from an Quantitative view. Where traditional mathematics fails, Quantitative Reasoning focuses on those areas to interpret and critically assess...

Words: 426 - Pages: 2

Premium Essay

Business Proposal

...“brain development program”.  The company wants to deliver quality education solutions to a large number of students across the globe. Sunshine Tutorials PVT. LTD is an ISO 9001-2008 certified company by Ms. abc. We are here to provide our students with unparalleled opportunities to learn and grow in their respective fields through traditional and educational culture. Product and Service We provide an Abacus “whole brain development program” to students. This course is especially for kids from four to fifteen years of age.  An individual of any age can learn the techniques but the whole brain development can be achieved when the brain is at its early absorbing age, and that is why early learning provides a strong foundation. The Mental Math Abacus program is an exercise for the brain which helps students develop different mental skills by teaching mental arithmetic, using the Abacus technique. We have ten levels in this program. We provide books, the Abacus instrument and other study materials to students. Also we provide teacher, marketing, and counseling training in our centers. The company developed a speed-building software for students’ practice. This software has been specifically designed like an animated video game which increases the child’s accuracy and speed in a playful environment. We have both online and onsite classes available for students. Financial Outlook Sunshine has a complex financial structure. The company’s annual operating budget of......

Words: 923 - Pages: 4