Hinkel rotary engine- excel -production planning

Assignment Help Business Management

Reference no: EM13368231

Hinkel Rotary Engine- Excel -Production Planning Problem

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?

Reference no: EM13368231

Questions Cloud

Design of experimentswhy would you want to use design of : design of experimentswhy would you want to use design of experiments rather than multiple regression? in other words

Goverment-led training initiatives1write a note on : goverment-led training initiatives1.write a note on qualification and curriculum authority qca and national vocational

Show types of powerfrom an organizational behavior : show types of power.from an organizational behavior perspective power is the capacity to influence the behavior of

Post addresses if its what or who you knowso power is about : post addresses if its what or who you know.so power is about the capacity that a has to influence the behavior of b so

Hinkel rotary engine- excel -production planning : hinkel rotary engine- excel -production planning problemhinkel rotary engine ltd. produces four- and six- cylinder

Training and development misconceptionsaddress the : training and development misconceptions.address the misconceptions in the following assertions1 training is not

Applying for a job not publicly advertisedyou recently : applying for a job not publicly advertisedyou recently heard from a friend at abc company that there will be a

Addresses resistance to changeunderstanding and managing : addresses resistance to change.understanding and managing organizational change presents complex challenges. planned

Employee retention rates in car dealer industry job : employee retention rates in car dealer industry job levelselect a car dealer as a retail organization to serve as the

User Account

All Pages