Hinkel rotary engine- excel -production planning problem

Assignment Help Business Management
Reference no: EM1365591

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: EM1365591

Questions Cloud

Design of experiments : Why would you want to use Design of Experiments rather than Multiple Regression? In other words, what situations are more suited for DOE and which ones more suited to Multiple Regression?
Write a note on qualification and curriculum authority : Goverment-led training initiatives-Write a note on 'Qualification and Curriculum Authority (QCA)' and 'National Vocational Qualifications (NVQs)'.
Show types of power : From an organizational behavior perspective, power is the capacity to influence the behavior of others. Power relationships are the medium within which business is conducted.
Power in organizations : we ponder this animal called "POWER" in organizations, contemplate and discuss for a moment the statement. It's not what you know, it's who you know?
Hinkel rotary engine- excel -production planning problem : Hinkel Rotary Engine, Ltd., produces four- and six- cylinder models of automobile engines.
Training and development misconceptions : Training is not valuable. It doesn't teach information that help managers drive the business. It is an expense - not an investment and anyone can be a trainer. Give me some PowerPoints and I'm ready to go. Anyone can get up there and talk for an ho..
What would be the best way to contact the hiring manager : What would be the best way to contact the hiring manager? By mail, email or by phone? Explain and support your selection and how would you explain that you know about this position without identifying your friend?
Addresses resistance to change : How can Jorge deal with the employees' resistance to change, to enable him to move the change process along
Employee retention rates in car dealer industry : Prepare a summary of your findings. Comment on whether attrition rates in the retail industry are higher than other industries and explain why. Properly cite your sources in your paper.

Reviews

Write a Review

Business Management Questions & Answers

  Show how do case studies help in business research

Show how do case studies help in business research and what are the advantages and disadvantages of using case studies?

  Balancing organizational team needs with individual needs

Explain how would you recommend an organization should go about striking a balance between individual and team needs especially as they relate to training and development?

  Cultural diversity and business

Sealwrap, a producer of plastics in United States, is about to expand its business. As part of this expansion, they will begin to sell their products in Europe and Asia. In addition, they plan to open a plant in Asia.

  Tools and techniques for evaluating a decision

What tools and techniques should be used for evaluating a decision?

  Organizational culture in prison

Compare and contrast the two types of organizational culture that develop within a prison: management culture and relationship culture. Explain the continuum ranges for each type of culture and what they mean.

  Examine the customer service environment

Analysis and Recommendations: Using what you've learned from the interview and your research, examine the customer service environment at this company. How can customer service be enhanced? What are your endorsements to this company based on what ..

  Traditional ecological knowledge

How do we honour traditional ecological knowledge (TEK) and at the same time bring traditional cultures into the 21st century? Conversely, how do traditional societies protect themselves from rampant consumerism?

  Employee stock ownership and executive pay

Employee Stock Ownership and Executive Pay, Conclude two circumstances in which profit sharing and employee stock ownership may increase employee motivation and performance levels. Sustenance your answer with examples.

  Discuss porsche''s decision

When Porsche decided to enter the SUV market with its luxury Cayenne model,  Can you explain Porsche's decision?

  It must be present a scholarly discussion of a legal concept

It must be present a scholarly discussion of a legal concept that goals and structure of the business environment

  Explain the disorder as per the dsm-iv

Explain the disorder as per the DSM-IV and How is the definition of normal and abnormal behavior impacted by culture?

  Explain the level of significance

Explain At the 0.05 level of significance is there evidence of a difference in the daily customer count based on the price of a small coffee

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd