Explore BrainMass

Explore BrainMass

    Hinkel Rotary Engine- Excel -Production Planning Problem

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com June 4, 2020, 2:36 am ad1c9bdddf

    Solution Preview

    I have completed and attached the solution.

    The zip file has ...

    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