Hinkel Rotary Engine- Excel -Production Planning Problem
Not what you're looking for?
Hinkel Rotary Engine, Ltd., produces four- and six- cylinder models of automobile engines. The firm's profit for each four-cylinder engine sold during its quarterly production cycle is $1,800 - $50X1, where X1 is the number sold. Hinkel makes $2,400 - $70X2 for each of the larger engines sold, with X2 equal to the number of six-cylinder engines sold. There are 5,000 hours of production time available during each production cycle. A four-cylinder engine requires 100 hours of production time, whereas six-cylinder engines take 130 hours to manufacture. Formulate this production planning problem for Hinkel. How do you set this problem up in Excel to find the optimal solution?
Purchase this Solution
Solution Summary
The solution is presented in a zip file containing:
1. Excel Sheet with the problem formulation and solution (using Solver Add-In)
2. Word Document which shows the Solver parameters
Solution Preview
I have completed and attached the solution.
The zip file has ...
Purchase this Solution
Free BrainMass Quizzes
Organizational Behavior (OB)
The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.
Managing the Older Worker
This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.