Maximize profit with Solver in Excel
Not what you're looking for?
The Weedwacker Company manufactures two types of lawn trimmers: an electric model and a gas model. The company has contracted to supply a national discount retail chain with a total of 30,000 electric trimmers and 15,000 gas trimmers. However, Weedwacker's production capability is limited in three departments: production, assembly, and packaging. The following table summarizes the hours of processing time available and the processing time required by each depart, for both types of trimmers.
Hours Required Per Trimmer
Electric Gas Hrs Available
Production 0.20 0.40 10,000
Assembly 0.30 0.50 15,000
Packaging 0.10 0.10 5,000
Formulate the LP model as a spreadsheet using excel solver and answer the business question, that is, what is the optimum solution (how many ot make of each model)
Purchase this Solution
Solution Summary
Solution is in Excel with Solver and a JPEG screen shot of the Solver setup.
Solution Preview
Student,
I added some cost of production prices and an external source so there ...
Purchase this Solution
Free BrainMass Quizzes
Exponential Expressions
In this quiz, you will have a chance to practice basic terminology of exponential expressions and how to evaluate them.
Solving quadratic inequalities
This quiz test you on how well you are familiar with solving quadratic inequalities.
Probability Quiz
Some questions on probability
Graphs and Functions
This quiz helps you easily identify a function and test your understanding of ranges, domains , function inverses and transformations.
Geometry - Real Life Application Problems
Understanding of how geometry applies to in real-world contexts